Problems to data merge a normal CSV

Explorer ,
Jul 09, 2022 Jul 09, 2022

Copy link to clipboard

Copied

Hi,
I have a problem to use the data merge with my csv.
The csv is generated from Toggl the timetrack app.
I don't understand whats teh problem is that ID have. Its a normal comma seperated file.

User,Email,Client,Project,Task,Description,Billable,Start date,Start time,End date,End time,Duration,Tags,Amount ()

This is the first line of my csv file.

 

Cheers

TOPICS
Bug

Views

79

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 2 Correct answers

Adobe Employee , Jul 11, 2022 Jul 11, 2022

Hi @J_F_S,

 

I assume you're looking for a similar request mentioned on our InDesign UserVoice page. If so, then we would request you to please submit your feedback and upvote the request to add your voice.

 

We will also make sure to pass on your feedback to the team.

 

Thanks,

Harshika

Likes

Translate

Translate
Adobe Community Professional , Jul 11, 2022 Jul 11, 2022

If you have problems with CSV files, try tabulator separated files.

 

E.g. here in German we use commas, where the English uses dots, we use dots, where the English uses commas. But for example Excel changes not only in the table dots and commas, but also in exported files like CSV or codes this exchange and makes the program in German not usable for many purposes. We can either change the MS Language for Office or use less errative files like tabulator separated text files.

Likes

Translate

Translate
Adobe Community Professional ,
Jul 09, 2022 Jul 09, 2022

Copy link to clipboard

Copied

What error message do you receive?

Haver you tried removing the () from the last entry?

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Jul 09, 2022 Jul 09, 2022

Copy link to clipboard

Copied

Yes I tried to delete the brackets at the end. No change.
The errormessage is: 

quoteDie gewählte Datenquelldatei enthält keine Datensätze oder liegt nicht
in einem unterstützten Dateiformat vor. Reparieren Sie die Datei oder
wählen Sie eine Datei mit Datensätzen bzw. einen unterstützten
Dateityp aus.

 

quote

The selected data source file does not contain records or is not in a supported file format. Repair the file or select a file with records or a supported file type.



 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jul 09, 2022 Jul 09, 2022

Copy link to clipboard

Copied

Try copying the data into a new spreadsheet and amnaully add the header row.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Jul 09, 2022 Jul 09, 2022

Copy link to clipboard

Copied

Hi,
sorry, what do you mena with amnaully?

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Jul 09, 2022 Jul 09, 2022

Copy link to clipboard

Copied

I found out whats wrong with my csv.
It must be Western (MacOS Roman) coded.
It's a shame Adobe that you don't support UTF-8 for CSV. Its so 90s.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Jul 11, 2022 Jul 11, 2022

Copy link to clipboard

Copied

Hi @J_F_S,

 

I assume you're looking for a similar request mentioned on our InDesign UserVoice page. If so, then we would request you to please submit your feedback and upvote the request to add your voice.

 

We will also make sure to pass on your feedback to the team.

 

Thanks,

Harshika

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jul 11, 2022 Jul 11, 2022

Copy link to clipboard

Copied

LATEST

If you have problems with CSV files, try tabulator separated files.

 

E.g. here in German we use commas, where the English uses dots, we use dots, where the English uses commas. But for example Excel changes not only in the table dots and commas, but also in exported files like CSV or codes this exchange and makes the program in German not usable for many purposes. We can either change the MS Language for Office or use less errative files like tabulator separated text files.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines