Skip to main content
R
rileym15705378
Participant
April 30, 2020
Answered

Having some trouble using variables and data sets in photoshop CS5

  • April 30, 2020
  • 3 replies
  • 12094 views

Hello, I'm having some issues incorporating variables and data sets into my workflow and was hoping someone would be able to help me out since none of the solutions I've found online have worked.

 

So all I'm trying to do is import an excel spreadsheet of text lines into photoshop and have photoshop populate a series of text layers from the text in the spreadsheet. So I started off with a smaller sample of the total text, saved it as a as a text (Tab delimited) file and attempted to use this file as a data set. I have a text layer, I've defined the text replacement with the same name as the column above the text ("text" in this case). However when I try to import the text file as my data set I receive the error: "Could not parse the file contents as a data set. There were too many variable names in the first line of the text file."

 

So I started playing around and troubleshooting and oddly enough when I remove the bottom two lines in the spreadsheet and save it in the same manner the data set now works. This is throwing me off since the error that I keep receiving says that the issue is with the first line of the text file- yet removing the last two lines and keeping the first line the same fixes it. I though that maybe it was because the last two lines didn't have punctuation and the first two do but that came up with the same error. Any help or ideas is greatly appreciated.

 

Thank you!

Correct answer Stephen Marsh

Check out the .csv version in a text editor to see if empty/garbage lines are at the end, which are not visible once translated into the spreadsheet.

3 replies

Bojan Živković11378569
Community Expert
Bojan Živković11378569Community Expert
Community Expert
August 19, 2022

"Could not parse the file contents as a data set. There were too many variable names in the first line of the text file."

 

Easy way to check for extra space is to open exported file, place cursor at the end of line with variables (or data sets) and use right arrow key on keyboard. If cursor continues or move in the same line then you have space after variable name in the first (or any other) column. If cursor moves after pressing right arrow key to the beginning of next line then you are good to go. This is common problem when creating data sets manually or using Excel spreadsheets.

S
Sudip275180976njm
Participant
December 10, 2022
  • I had that issue "There were too many variable names in the first line of the text file." No matter which method is used, this problem does not go away. Is there any suitable solution? 

     

Bojan Živković11378569
Community Expert
Bojan Živković11378569Community Expert
Community Expert
December 10, 2022

Data sets does not forgive. Ensure no space after each line especially first line with variable names. Also check that you have matching number of variables in file.

    JF Antonio
    JF Antonio
    Participant
    August 19, 2022

    I had that issue "There were too many variable names in the first line of the text file." and in my case was because I had an extra column that I was not actually using as a variable, so, I think all columns need to be in variable use before importing the data set.

      Stephen Marsh
      Community Expert
      Stephen MarshCommunity ExpertCorrect answer
      Community Expert
      April 30, 2020

      Check out the .csv version in a text editor to see if empty/garbage lines are at the end, which are not visible once translated into the spreadsheet.

        R
        rileym15705378Author
        Participant
        April 30, 2020

        Hey thanks for the reply, I went and deleted all of the columns to the right of the column in use in excel and now it's working- I feel like a bit of an idiot that it was that simple. I imagine you're right though there are probably variables in the columns to the right in the excel spreadsheet that aren't visible on the notepad.

         

        I have another question, (which you're not obligated to answer since you've already helped me with this one!). My whole goal here is to be able to turn these lines of text into png files. So now I have the ability to export several psd files with the appropriate text (which is great, it reduces my workload immensley) but I'm wondering if there's a way to either export as .png (I see that psd is the only option though so Imagine this won't work) or is there an easier way to convert these psd files to png? Again though thanks for your help, you've helped me a lot here!

        Stephen Marsh
        Community Expert
        Stephen MarshCommunity Expert
        Community Expert
        April 30, 2020

        You can bulk convert using an action to save to PNG with the automate/batch command... or use the Image Processor Pro script to batch convert to PNG without needing an action:

         

        https://sourceforge.net/projects/ps-scripts/files/Image%20Processor%20Pro/v3_2%20betas/

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