Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
1

Specify Dataset name from variable in CSV file

Guest
May 07, 2018 May 07, 2018

Hello, I am working on a project that contains variable data. I have a CSV setup with 5 text variables and an image link. When I run the import into illustrator everything works as it should on the art board, however the i can't get the data set name listed in the variables window to reflect the name of the field in the CSV "dataset". I have tried this with a quick XML, and it works, however all the data going to our graphics department real time is in CSV. Does anyone know if I have to call out the dataset name in the CSV differently from CSV, or bind it somehow?

See images to show XML vs CSV import.Capture1.JPGCapture2.JPG

Thanks in advance,

Jason

13.6K
Translate
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
Valorous Hero ,
May 09, 2018 May 09, 2018

Why not try to import your data with the VariableImporter script?

Translate
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
Participant ,
Nov 12, 2019 Nov 12, 2019

Are there any APIs in SDK to do the same? I have seen there are DataSet and Variable classes in DOM which fulfill the purpose. But could not find anything in SDK related to DataSet and Variable. 

Any help would be appreciated!

Translate
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
Valorous Hero ,
Jan 09, 2020 Jan 09, 2020

I do not know about the realm of the SDK at this time, only ExtendScript, sorry.

Translate
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
New Here ,
Apr 04, 2022 Apr 04, 2022

The problem with Varible Importer is that you can't use spaces in variables. If you are working with anything that is multiple words it breaks.

Translate
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
New Here ,
Feb 13, 2019 Feb 13, 2019

Did you find the solution?

Translate
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
Community Expert ,
Feb 13, 2019 Feb 13, 2019

the native feature does not have an option to name Datasets. The alternatives are the use XML or Variable Importer Script mentioned above

Translate
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
Enthusiast ,
Feb 14, 2019 Feb 14, 2019

I gave the same answer to a similar title, but I think it might help.

Free Online Illustrator Variables XML editor and converter

Graphic Designer Educator / PrePress Consultant
Translate
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
Community Expert ,
Feb 14, 2019 Feb 14, 2019

oh that's a good one, I didn't know about it.

thanks

Translate
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
Community Expert ,
Feb 14, 2019 Feb 14, 2019

That site is one of three that I previously mentioned in my original blogpost on the Variable Importer script!

Prepression: Illustrator – Introducing the VariableImporter Script

Translate
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
New Here ,
Feb 27, 2025 Feb 27, 2025

this is extremely helpful. thankyouu

Translate
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
New Here ,
Mar 05, 2025 Mar 05, 2025
LATEST

Hello,

I had the same problem so have used this script and it has worked :

https://github.com/Silly-V/Adobe-Illustrator/blob/master/Variable%20Importer/VariableImporter.jsx

 

To use it :

In Github : Download as Raw

In Illustrator : File > scripts > other scripts > select " VariableImporter.jsx "

On the Script's Menu : import the CSV/XML > Options > DataSet Names > select the column that you want

 

I hope that helps

Translate
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