I want to respect the comments and suggestions in helping _Ben_Bickley_. They're definitely in the spirit of troubleshooting. I have the same exact problem, same errors, and no matter how much I try, the errors abound. I couldn't even get as far as this error with Illustrator. Is anyone here as impressed as I am about how finicky both PhotoShop and Illustrator are regarding the recognition of a simple data set? This is sort of absurd.
Hi Ben, I know it's been YEARS, but I'm having this same problem and did create the variable text within the image before trying to import the data, but I still get that error message. I did everything exactly as it is explained in this video:
I converted the Excel spreadsheet into a .csv (comma delimited), and created a Photoshop image with one text layer called "Name", which matches the text in the first box (top of the first column) in the spreadsheet; and another text layer called "Degree", which is the title at the top of my second column. I then did Image > Variables > Define and defined each of the two layers for text replacement with the same name. Then I imported my .csv file, but when I try to click "OK", I get that same error message: "Could not parse the file contents as a data set. There were too many variable names in the first line of the text file."
I see that Adam_Pilarski has provided layout and format information, which I honestly cannot understand at all, and is not what the tutorial I saw said. Photoshop's website no longer offers this tutorial. Somebody please help!
Nevermind, I realized that I did have commas between some text in the second column of my spreadsheet, so as Adam_Pilarski suggested, I put quotations around any text that contained commas. Didn't get the error this time!
I've been trying to do the following in photoshop for 3 hours now, I want a sequence of numbers to appear in a box one by one but now I'm not sure this is the best method to follow. So what I do is this: first I open my document and double click on the text layer, which in turn opens another document (a .psb file, I don't have an idea why) and there I define a TextVariable1 and import a .csv as my dataset. This is what it looks like ->
Now, when I click ok it says: "the name 'myvariable1' is not a variable in the current document". The only variable I see [in the Variables dialog] is TextVariable1 with a value of 01 and layer 01, no more.
What I don't understand is why no other method described in this thread is working for me. I've tried separating the numbers by commas, with or without a variable name, checking and unchecking the 'use first column for data set names' square. Maybe something is escaping me, but what exactly?. Thanks for your help, I'm kinda new to this.
EDIT: solved. I guess it was obvious that myvariable1 should have been Textvariable1 instead, but it was Not that obvious to me. NOTE: It doesn't make a difference if I have any value set for that in the dialog.
I do have commas in my original spreadsheet, which need to remain in the text. As Adam_Pilarski suggested, I put quotations around my text which contained commas, and that got rid of the error message I was getting. However, the quotations I added actually show in the final product, but I do not want to see quotation marks. Is there a way do do this in a way that I don't have to add quotes, or in a way that the quotations are ignored? I've attached images of both my spreadsheet and one of the resulting images. Thanks!
Also just figured out that after I create the .csv from the Excel file, I have to close everything, then go into my finder and directly open that .csv file. Now re-opened, the columns are incredibly narrow in width for some reason. I needed to widen the columns so that all of the contained text fits inside without being cut off, then re-save. When I don't do this, I get the error message; commas or no commas.
I had a similar error, using CS4. Turns out Photoshop did not like me having an extra named column, not used as a variable, which I had for my own record purposes. Deleteing that solved the problem.
I thought I'd throw my two cents in to this discussion. Hopefully it will help someone chasing some answers to the error you get when trying to parse the csv file into data sets.
After building a test excel sheet then saving as csv I tried to import this data set into photoshop and got this message. "Could not parse the file contents as a data set. There were too many variable names in the first line of the text file."
After opening this csv file in text edit, I discovered the data had included a couple of spaces (which to me looked like a double comma) at the end of each line.
This turned out to be an operator error, as I had applied the space bar in a couple of columns without realising.
Simply removing these, and/or make sure your "empty" cells are actually empty. Your raw data should end on the last input data and nothing more.
I was able to import the data set without any errors.
Hope this helps?
I just messed around with this too.
Here was my problem & solution:
I had 3 layers with data (one variable field per layer), but in my spreadsheet / tab delimited file I had 6 columns of data. I assumed that Photoshop would be able to look to the table and find the data related to that column (and ignore other columns). I was wrong. It appears you need to have the same number of columns in your data table as fields in your document.
Spot on Matdog123
The error is misleading. There are not 'too many' variables in the first row of the text file (or spreadsheet columns) per se. You can have lots of variables listed there.
What it means is that there are more variables listed in the text file relative to those present in the Photoshop file.
The relevant variable must be added to Photoshop layers and Image > Variables > Define, or deleted from the spreadsheet and text file to synchronise them.
Plz follow this link Photoshop error "could not parse the file contents as a data set." - YouTube
and see the video. I hope that your solution is available here. Thank You.
EDIT [video has bad audio interference - moderator]
mera deta set file load karne par problem de rahahai
erre aa raha hai "could not purse file contain as a data set .data set 11 was incomplete "
krupaya maragdarshan kijiye