God what the f

[GilloD]

I HAVE TWO IDENTICAL CSV FILES. IDENTICAL. IN EXCEL AND NOTEPAD. THEY AGREE. THEY'RE THE SAME.

THE ERP WILL TAKE ONE BUT NOT THE OTHER.

WHAT THE FUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU. 

[Reb]

Sometimes I think you're doing the wrong job GilloD.

[GilloD]

Sometimes I think you're doing the wrong job GilloD.

Think? Son, I know. 

[Howard Alan Treesong]

I HAVE TWO IDENTICAL CSV FILES. IDENTICAL. IN EXCEL AND NOTEPAD. THEY AGREE. THEY'RE THE SAME.

are they encoded identically?

[GilloD]

I HAVE TWO IDENTICAL CSV FILES. IDENTICAL. IN EXCEL AND NOTEPAD. THEY AGREE. THEY'RE THE SAME.

are they encoded identically?

They're the same byte-size

[Eric P]

not the same thing

[Eric P]

is one a csv for txt and the other csv for xcl?

[GilloD]

I HAVE TWO IDENTICAL CSV FILES. IDENTICAL. IN EXCEL AND NOTEPAD. THEY AGREE. THEY'RE THE SAME.

are they encoded identically?

Also, via answer, they're both CSVs, in whatever the default is. Uni-8?

[drew]

who knew being a peanut butter salesman could be so complicated

[GilloD]

is one a csv for txt and the other csv for xcl?

Explain. Both just pop out in .csv, one from an XLS/XML template, the other from whatever Dark Magycks swirl in the bowels of the ERP. They look identical in Excel and in a Text Ed.

I've gotten one from the XLS/XML side to work with the ERP prior, but it requires some bizzare acrobatics (It needs a seemingly random 13 total fields on each line?)

[GilloD]

who knew being a peanut butter salesman could be so complicated

I wish I was in Sales. I coulda had that gig.

[Tauntaun]

I know nothing of what you guys speak.  I am not l337.  :'(

[GilloD]

didn't you make the XSL thread also?

wow, change your job man, start selling hotdogs maybe?

Haha, yes. That one was a stupid goof. I mean,. I'm just kind of learning this shit as I go along. My major was English/Philosophy with a minor in Ceramics, haha

[GilloD]

B,CON,,BIL,NTX,CRC,MAIL
A,BIL,Billing Address,85 North Fn Street,,Scott,BLFIELD,New Jersey,7003,United States of America
A,SHI,Shipping Address,85 North Fn Street,,Scott,BLOELD,New Jersey,7003,United States of America
D,BIL,Scott
D,SHI,Scott

That one works and no that's not my address, I f'ed it up

B,CON,,BIL,NTX,CRC,MAIL
A,BIL,Billing Address,85 North Fu Street,,Scott,Blofield,New Jersey,07003,US
A,SHI,Shipping Address,85 North Fulton Street,,Scott,Bloold,New Jersey,07003,US
D,BIL,Scott
D,SHI,Scott

That one does not. And I'm fully aware there's a zipcode/case/US discrepancy, but it doesn't matter. I've gotten it to pick up that data previously via another method (The adding junk columns method)

Whatever. I'm just gonna wait for the ERP guy to get back to me.

[GilloD]

Okay. So the solution is to add junk fields to every row until the number of fields is equal to the number of fields in the largest row MINUS 1.

So if the largest riow has 10 fields and the first row has only 3 fields you have to add 6 junk rows.

This is the party line. This is a 70,000 software package.

For whatever reason, the .csv files the ERP outputs doesn't need the junk rows, but no one knows why.

[Eric P]

that's odd

i would have thought that the csv stuff would be pretty standard since it's a simple form.

[GilloD]

that's odd

i would have thought that the csv stuff would be pretty standard since it's a simple form.

Join T. Club.

Also, did I mention there's no manual for any of this? Just a bunch of PowerPoints?

[GilloD]

haha. new mindfuck:

I brewed up a template with the requisite junk fields. And it still won't work. Unless I open it up and save it in Excel. It doesn't change the file at all. Or appears not to?

[Eric P]

count the number of commas

[GilloD]

Exactly the same. Okay, I got to the bottom of this, but I don’t have a solution.

Attached are two files: 56_customer.csv and 56_customerSavedWithExcel.csv

They are literally- from a naked perspective- the same exact file. With one evident exception: The fresh from Magento version is 234 bytes. The Excel’d version is 235 bytes. That’s all I can see.

The one from Magento does not work.

The one from Excel does.

The only other thing is that the Magento encoding is coming out at ISO-8859-15, though the XML itself is in UTF-8. So the Excel MUST be doing something to it. Do you think this is an encoding issue?

[Howard Alan Treesong]

It's probably adding the invisible Unicode header bytes

God, I hate Unicode. The word "Unicode" alone can mean 3 different encoding mechanisms.

UTF-8 4 lyfe

[demi]

well at least you got a raise

[GilloD]

They're both in UTF-8 now and still the same problem. It needs to be saved with Excel. Jesus fucking christ

[Howard Alan Treesong]

Excel adds invisible bytes too. Fucking MS Office.

I use Notepad++ to make sure I don't get invisible garbage bytes in my text files.

http://notepad-plus.sourceforge.net/uk/site.htm

[GilloD]

Actually, Sage is in ISO 8859. Whcih is what Magento was in before

[GilloD]

yeah, I'm using Notepad++

[GilloD]

Excel adds invisible bytes too. Fucking MS Office.

I use Notepad++ to make sure I don't get invisible garbage bytes in my text files.

http://notepad-plus.sourceforge.net/uk/site.htm

The worst shit in the UNIVERSE is all that garbage MS Word adds if you copy/paste to the web.

[muckhole]

I don't know why it is that I always read every post in these threads even though I hven't the slightest clue what's being said in them. 

[Beezy]

I don't know why it is that I always read every post in these threads even though I hven't the slightest clue what's being said in them. 

same here

[Fragamemnon]

WTF-8 is my best friend. 

Doesn't this shit show up using a decent diff tool?

[GilloD]

SOLUTION:

Did a Hex Dump (LOL, that's FIVE POOPS)- My file ends lines in 0d (CR), the working file ends in 0a(LF). fuuuuuuuuuuuuuuu

[recursivelyenumerable]

heh, I called it to myself as a CRLF issue on the first post

if only I'd actually read the thread when it was new, oh well