New Participant

Answered

Error - "Incoming Variable Library Is Invalid" while uploading a CSV data source file in Illustrator

Forum|Forum|5 years ago
June 23, 2020
13 replies
67218 views

Hey all!

I'm trying to make a bunch of business cards using a template en masse with a Excel document.

This contains Inuktitut characters that I would like to remain in the finished product. I've tried it with and without the Inuktitut, all the cells are filled and I've done a search for all empty cells to be sure. Each time, the result is the same: invalid library. What could be going wrong?

Here is what happened when I tried to investigate possible problems listed here: https://helpx.adobe.com/in/illustrator/using/data-driven-graphics-templates-variables.html#FacingissueswhileimportingyourCSVfile

Your CSV file is not blank.
I've checked.

The spreadsheets that you've created using the latest version of Microsoft Excel are saved as CSV (Comma delimited) (*.csv) or CSV (MS-DOS) (*.csv) and those created using Apple Numbers are saved as CSV format with Unicode (UTF-8) encoding. Data source files saved in any other file format such as Macintosh Comma Separated (*.csv) are not supported for data merge.
Done. Both with comma delimited and MS-DOS.

All columns have a data field name. For example, Illustrator displays the error message when a column in your data source file contains data but doesn't have a data field name.
Done. All columns have a data field name.

The data source file doesn't have a blank column in between any filled columns. For example, Illustrator displays the error message when column B and D in your data source file contain data but column C is empty.
There are no blank columns. I've used find and replace to verify.

A. Data field name is missing for a column B. There's a blank column between filled columns
There are no blank field names.

The data field names in your spreadsheet don't contain any blank spaces.
There are no blank spaces.

The paths referring to image and graph files in your source file don't contain any blank spaces.
There are no blank spaces, image files or graphs.

The graph files linked from your data source file are saved as comma-delimited (.csv) files.
There is no graph.

{Renamed by MOD}

Correct answer Kasandra

You need to use a spreadsheet program like excel or google sheets to update the headers. The headers can't have spaces in them. So in the screenshot above the changed the header from "Variable 1" to "Variable1"

Known Participant

*** THE ANSWER IS THAT YOU MUST EXPORT AS WINDOWS CSV ... NOT 'ORDINARY CSV'. ***

*** SOLUTION! ****

*** THE ANSWER IS THAT YOU MUST EXPORT AS WINDOWS CSV ... NOT 'ORDINARY CSV'. ***

*** SOLUTION! ****

*** THE ANSWER IS THAT YOU MUST EXPORT AS WINDOWS CSV ... NOT 'ORDINARY CSV'. ***

*** SOLUTION! ****

*** THE ANSWER IS THAT YOU MUST EXPORT AS WINDOWS CSV ... NOT 'ORDINARY CSV'. ***

*** SOLUTION! ****

*** THE ANSWER IS THAT YOU MUST EXPORT AS WINDOWS CSV ... NOT 'ORDINARY CSV'. ***

*** SOLUTION! ****

Inspiring

Does that show the same on OSX?

For me it was the added spaces in the header. Not this what you are pointing at

Edit

After googling, that Microsoft version probably ads escapes for special characters. I didn't have special characters. Illustrator parser is probably much different vs that of InDesign. Read it couple times that CSV format is poorly standardized

New Participant

*** MAKE SURE THERE'S No "Enter" in the information you want to put in the variable. If you press enter and make the information go to the next line it will not work.

New Participant

I still had issues after trying these solutions. I was Downloading as CSV from Google Sheets and everything appeared right. But I finally cleaned and trimmed each cell and got rid of some hidden characters or spaces. My data set was quite large and I did not find these by visual examination at first. I put my data on one sheet and then used the =CLEAN(TRIM(data_range_here)) function to get it working.

Dubníčková36877607asxz

New Participant

Thanks a lot, it works for me, too

New Participant

i am not sure whos fault it is for my case , Either EXCEL or ADOBE because i was working on a doc with Turkish characters and when i export then as csv when i opened the file just only in excel again all turkish charaters lost value and had changed so now when i was trying to import them into illstrator it was giving me the error . so maybe illstrator needs to update to be able to decord it or Excel needs to be able to export them and maintain value ,

Community Expert

Try and import it using the Variable Importer Script. https://github.com/Silly-V/Adobe-Illustrator/blob/master/Variable%20Importer/VariableImporter.jsx

New Participant

Thank you Monika, this worked. I'd tried everything else for a simple 3 column csv file. Your script was the only thing that worked!

New Participant

Today, I found another problem or may be a key for the error, I found a limit for the number of rows in csv file, which make data sets is limited to 230 set, when I add more rows, illustrator refuse the file and say "invalid.."
for columns, I have reached 103 and still work.

michaeltyson22952987

New Participant

Old thread I know but I was having this issue and nothing here helped.

I figured out what it was for me.

I was copying text with line breaks into the cells but becuase the cells were clipped/wrapped i didn't notice.

Make sure all text in each cell is on one line.

Dulce292071850het

New Participant

Esto se puede resolver seleccionando todo, luego en Inicio > Edición > Borrar > Borrar formatos

New Participant

this is the ULtimate solution

https://www.youtube.com/watch?v=2vu3tYsWGkc

marcink67422639

New Participant

It is worth to note that this is a valid solution only when we don't have any longer strings of text with commas inside. Cause commas can't be inside values here. If we have them, the software will interpret separations incorrectly. For a solution with commas, the only possible way to do it is in XML, as far as I know!

puneeta63515182

New Participant

Dear,

My Name is Puneet Agarwal,

I am also facing the same problem and tried checking all the pointers given here, but my problem still persists .

Can anyone help?

Thanks and Regards

Puneet

New Participant

The data field names cannot start with a number

This was my issue.

So annoying, the help doesn't say this anywhere.

Ernests26428220nev6

New Participant

Thank you! That solved my issue!

New Participant

For me what solved was changing the first line from:

to:

The simple space was keeling the file, haha.

New Participant

Yes! That solved my issue!! Thank you!

Show more replies