James Pyle
Member
- Messages
- 18
- Likes
- 1
So I have huge datasets that have 10 or so variables. I use the same file for batching every data set and have had NO issues tonight so far. Now randomly when I import my CSV file just ONE of the images is not importing the relative path.
Most of my variables are text but I have 3 images and 2 of them import the relative path (where my CSV file is) but the other doesn't for no reason at all. Therefore the batch fails.
If I manually pick the proper image it works but that can't be done because my datsets are thousands of lines.
Really frustrated and cannot figure out why it won't import just one image. There are no special characters on this line/cell. It doesn't happen only on lines with special characters.
I do have some lines with apostophes in my CSV files but the error doesn't happen on this and in fact mostly everything works just a few random datset lines the one image won't work.
Things I tried:
Moving my files to other drives, with no nested folders.
I removed ALL lines from my CSV file except one of the lines causing the error, it still errored so it's definitely specific line related.
I am attaching csv with the one line (one that errors)
View attachment testbatch.rar
This file has a line with apostophes but on my end I removed those and it still errors. Here's a picture of the image that doesn't work, that doesn't import a path as it should:
Lastly, yes the image is there. But the error ALWAYS happens on a line with this "1 Player.png" even though my file is there..since the path is wrong it won't work. If I hit "Select" and choose the same file "1 Player.png" then it adds the path in and works fine.
Edit:
Okay I found the problem but I need help understanding it, and how to fix it.
All of the lines that say "Player 1" look right visually but I found out by doing a Search in the document for "Player 1" that none were found. So I determined theres something wrong with those cells. I retyped one of them manually, then copy and pasted it over several of the lines that had the broken "Player 1" in them...then I tried again search and it found them, then tried my batch and it found them.
So...how can these say "Player 1" and not actually be "Player 1" How can I fix this? I tried search and replace but since it can't even see them it can't replace them.
I tried copying the whole columna dn pasting values but it still doesn't see them as saying "Player 1" The only way I can fix is to manually type Player 1 there..makes no sense. (see attached file try to search for "1 Player"
Here you can see the issue, I did conditional formatting to make any line named "1 Player" red..and any line not "1 Player" green. You can see all the lines "1 Player" at the bottom that show green saying they aren't recognized.. If I click in one of those boxes and just retype "1 Player" then the color changes.
Edit 3:
Well, I fixed it by copying that column into notepad++ then back into excel. I wish I knew WHAT was causing this...2 hours on this and I had never seen anything like this before..makes no sense.
Most of my variables are text but I have 3 images and 2 of them import the relative path (where my CSV file is) but the other doesn't for no reason at all. Therefore the batch fails.
If I manually pick the proper image it works but that can't be done because my datsets are thousands of lines.
Really frustrated and cannot figure out why it won't import just one image. There are no special characters on this line/cell. It doesn't happen only on lines with special characters.
I do have some lines with apostophes in my CSV files but the error doesn't happen on this and in fact mostly everything works just a few random datset lines the one image won't work.
Things I tried:
Moving my files to other drives, with no nested folders.
I removed ALL lines from my CSV file except one of the lines causing the error, it still errored so it's definitely specific line related.
I am attaching csv with the one line (one that errors)
View attachment testbatch.rar
This file has a line with apostophes but on my end I removed those and it still errors. Here's a picture of the image that doesn't work, that doesn't import a path as it should:
![ftSItTSh.jpg](http://i.imgur.com/ftSItTSh.jpg)
Lastly, yes the image is there. But the error ALWAYS happens on a line with this "1 Player.png" even though my file is there..since the path is wrong it won't work. If I hit "Select" and choose the same file "1 Player.png" then it adds the path in and works fine.
Edit:
Okay I found the problem but I need help understanding it, and how to fix it.
All of the lines that say "Player 1" look right visually but I found out by doing a Search in the document for "Player 1" that none were found. So I determined theres something wrong with those cells. I retyped one of them manually, then copy and pasted it over several of the lines that had the broken "Player 1" in them...then I tried again search and it found them, then tried my batch and it found them.
So...how can these say "Player 1" and not actually be "Player 1" How can I fix this? I tried search and replace but since it can't even see them it can't replace them.
I tried copying the whole columna dn pasting values but it still doesn't see them as saying "Player 1" The only way I can fix is to manually type Player 1 there..makes no sense. (see attached file try to search for "1 Player"
Here you can see the issue, I did conditional formatting to make any line named "1 Player" red..and any line not "1 Player" green. You can see all the lines "1 Player" at the bottom that show green saying they aren't recognized.. If I click in one of those boxes and just retype "1 Player" then the color changes.
Edit 3:
Well, I fixed it by copying that column into notepad++ then back into excel. I wish I knew WHAT was causing this...2 hours on this and I had never seen anything like this before..makes no sense.
Last edited: