[mrdennisclark]

I was wondering if anyone had this problem before? I was importing POs and the header records pointed to the incorrect detail record. I wonder what would cause this ? formulas? or special characters ?
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

Did you give all related lines in your CSV the same Extyernal ID? What did you use to tie lines together?

---

mrdennisclark replied on 12/19/2016, 07:22 AM: do you have any other suggestions ? These we tied together by an application number. Have you ever heard of this happening before? This became quite an issue because I was importing a couple of hundred records.

[mrdennisclark]

I used used a application number ( we process grants) to tie the hdr and dtl records together. I have done this a number of times in the past but was wondering if formulas or special characters may have been in the file. Did you ever see a result like this before?

[Olivier Gagnon NC]

Hmm, no, haven’t seen anything like that. I’ve seen mismatches but they were due to explainable data errors in the files. Sorry, don’t have anything to more to offer.

---

mrdennisclark replied on 12/20/2016, 11:39 AM: Someone mentioned the fact that I had commas in the vendor name fields ( e.g ABC, Inc) that may have caused an error with the csv import ( even though I am importing vendor internal id); I had the vendor name on the file as an extra fields ( ie. not imported). Does this sound plausible?

[Olivier Gagnon NC]

Well, typically Excel will deal with commas within cells well, as it wraps it with quotation marks. “ABC, Inc” is a valid CSV value. However, if you have cells with “, such as say the length of something being in inches, that would be bad.

[Author]

Posts