Importing inventory error: "Error in line 1564"
TappedOut forum
Posted on July 30, 2018, 10:51 a.m. by thechristophershow
I'm trying to import my inventory from a CSV file created by Deckbox. When I save it on TappedOut, though, I keep getting this error message: "Invalid CSV file: Error in line 1564."
My CSV file, when I open it in Notepad to view it, is only like...I don't know, 40 lines tall, and each line is really long. How do I find line 1564? And why would there be an error when I made the CSV from Deckbox and didn't tamper with it at all afterwards?
thechristophershow says... #3
https://docs.google.com/document/d/1Vcl6WxqMOyqEEQWFhFtFX77JAks0wLeroIKKVGHqfxk/edit?usp=sharing
I don't know how to make it a spreadsheet, though, so the lines aren't numbered here.
July 30, 2018 11:26 a.m.
thechristophershow says... #4
Okay, I loaded it into a spreadsheet and discovered that line 1564 has nothing on it; 1563 is the final line. Don't know what to do with this information, though.
July 30, 2018 11:29 a.m.
sorry, you'll have to link to a spreadsheet version for help
July 30, 2018 1:33 p.m.
thechristophershow says... #6
Here's the spreadsheet:
https://docs.google.com/spreadsheets/d/1vcLzkVj90W0_YXEKHyueio6882-AH7VWcQFK6BpY1ic/edit?usp=sharing
July 30, 2018 2:43 p.m.
thechristophershow says... #7
As you can see in the spreadsheet above, there IS no row 1564, so how can there be an error in that row?
July 30, 2018 2:43 p.m.
That spreadsheet is not formatted correctly. Please try to upload and link your original file somewhere
August 1, 2018 11:53 a.m.
thechristophershow says... #11
Hmm. Where do I upload CSV files then so that I can link you to it?
I made that spreadsheet by opening the CSV file in Notepad, copying everything, and pasting it into the spreadsheet. Is there a better way to do it?
August 1, 2018 3:48 p.m.
thechristophershow says... #13
Okay, great, here it is:
https://www.dropbox.com/s/0oxaakxcx4z861b/Inventory_CasualMTGSeller_2018.August.01.csv?dl=0
August 1, 2018 5:40 p.m.
Seems like only some rows don't have the same amount of columns.... Maybe it's an error with their output format but it's very strange
August 1, 2018 5:48 p.m.
thechristophershow says... #15
Hmm. But it says the error is in line 1564, a line that doesn't exist. I tried opening the CSV in Notepad and removing any extra spaces that might be occurring after line 1563, but there was nothing extra after that. Guess I just can't upload my inventory. Bah, that sucks.
August 2, 2018 9:12 a.m.
All bets are off with those columns looking like they are. Sort that out somehow or report it to them and try again
August 2, 2018 10:16 a.m.
thechristophershow says... #17
I've even tried selecting the box "Ignore errors," but that doesn't work--it doesn't ignore the errors. Is there a bug in that "ignore errors" feature, you think?
August 7, 2018 10 p.m.
You should just send them that csv so they can fix whatever is broken with their export
yeaGO says... #2
Link to it from Google Docs or something
July 30, 2018 11:04 a.m.