Skip to main content
karstenr62666681
karstenr62666681
Participant
October 8, 2018
Answered

upload usergroups as csv does not work

  • October 8, 2018
  • 1 reply
  • 434 views

Hello,

I've downloaded the template of the actual user groups (only 2) and imported into openoffice.
I've saved the file as csv. The only difference between the entrie I can see is the missing bom in the ods file.

But this make no difference when using user upload by csv.

I've tried:

- adding bom

- including text in '

- using only one line

- editing the file and converting a long - (I do not check the code) to a short - (the "normal one" :-))

  The Assigned Product Profiles name in the downloaded file has a long german name - strange

The admin console does not give any senseful feedback, just error - this is the most annoying

fact of this tool.

Any help would be nice

Karsten

This topic has been closed for replies.
Correct answer alisterblack

Hi,

Support can create a bug for you once they have reproduced the issue.

In your Admin Console go to Support>Create a Support Case.

1 reply

alisterblack
alisterblack
Inspiring
October 9, 2018

Hi,

Make sure you are using UTF-8 encoding.

For excel the steps are:

To use the correct encoding when working with a CSV file exported form the Adobe Admin Console in Microsoft Excel, import it with the following steps:

1. Open a new (blank) spreadsheet

2. From the "Data" menu choose "Get External Data" -> "Import Text File"

3. Select the CSV file

4. Select "Delimited"

5. In the "File origin" drop-down menu, choose "UTF-8", and click "Next"

6. Select only "Comma" as the delimiter and click "Next"

7. Leave the Column data format as "General" and click "Finish"

For OpenOffice it looks like this article covers it https://csvimproved.com/support/questions-and-answers/916-save-a-csv-file-as-utf-8

Save a CSV file as UTF-8

Also make sure the file is really a CSV - so it is comma separated and does not use some other separator.

karstenr62666681
karstenr62666681Author
Participant
October 10, 2018

Hello, and thanks for your answer.

I think I know how to save a spread sheet as csv file, but it does not work for me.

So  I have an error, or there is an error in the implementation of reading this file.

Sorry, but I think it is a bug because the last step I've tried:

Download template file user-groups.csv, copy it to user-groups-mod.csv

Change the two groups in this file slightly by modifying the last letter in group name to the number 2

The change is done using an editor called joe, no excel, no libreoffice.

Upload the file leads to two errors.

some checks:

roemke@karoNouveau:~/GFSTex/AdobeSchueler> file user-groups.csv

user-groups.csv: UTF-8 Unicode (with BOM) text, with CRLF line terminators

roemke@karoNouveau:~/GFSTex/AdobeSchueler> file user-groups-mod.csv

user-groups-mod.csv: UTF-8 Unicode (with BOM) text, with CRLF line terminators

-> both use utf-8 with bom and the windows line delimiters

analyse the content of the two files:

roemke@karoNouveau:~/GFSTex/AdobeSchueler> hexdump -C user-groups.csv > user-groups.hex

roemke@karoNouveau:~/GFSTex/AdobeSchueler> hexdump -C user-groups-mod.csv > user-groups-mod.hex

roemke@karoNouveau:~/GFSTex/AdobeSchueler> diff user-groups.hex user-groups-mod.hex

with the result:

5c5

< 00000040  74 20 50 72 6f 66 69 6c  65 73 0d 0a 4b 75 4b 2c  |t Profiles..KuK,|

---

> 00000040  74 20 50 72 6f 66 69 6c  65 73 0d 0a 4b 75 32 2c  |t Profiles..Ku2,|

13c13

< 000000c0  0a 53 75 53 2c 53 63 68  c3 bc 6c 65 72 69 6e 6e  |.SuS,Sch..lerinn|

---

> 000000c0  0a 53 75 32 2c 53 63 68  c3 bc 6c 65 72 69 6e 6e  |.Su2,Sch..lerinn|

The only difference as far as I can see is the change from KuK to Ku2 and from SuS to Su2.

So I think this template isn't correct or the import isn't correct implemented - or I do any mistake
I can't find - again: The error report from admin console is not helpful.

Is there any place to report a bug? - In support I can chat with an Adobe employee, but I can't find
a link to report a bug.

Thanks

Karsten

alisterblack
alisterblackCorrect answer
Inspiring
October 10, 2018

Hi,

Support can create a bug for you once they have reproduced the issue.

In your Admin Console go to Support>Create a Support Case.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices