Dear all,

We're having problem with the import of some of our data, particularly our Contact list, tccom140, with the following error

30,3,205,,ABC101,,,,,,,,,,,EN,1041914121,0,,0

and our engineering BOM, tiedm110, with the following error

30,2,"tuxch021707.06","Incorrect record: number of fields or field contents doesn't correspond with ascii file format", WBMD1C0001,0303,10, WBMD1L0001,2,0,0,0,100,,0

For the latter, we've checked the the engineering BOM tiedm110 table structure but found that indeed we already conform to its structure. So we have no idea what happened.

Anybody has any clue what happened? Thanks very much

Rgds,
Paul

most prolly one of the field contains a "," (which you seem to use as delimiter), so the number of fields isn't correct any more.
Try using "|" as delimiter.

hth

Norbert

Dear Norbert,

Thanks but the number of fields are correct, no extra comma was present.

We are just going to use a simple API script to port these data in. I'm sure it will go through using API. There's just something funny with Exchange from time to time, I guess. Have a nice weekend

Rgds,
Paul

Please check whether any of the data loaded is having any control character in it( say /r/n). That might also creat this type of errors