Sage 100

Importing into SO_InvoiceHeader using CSV file and getting this error on the first record. It is no different than the rest of the records. Anyone seen this - 4.4.4?

I suspect the file has a hidden marker that you cannot see but that VI reads. Try to open the file in WordPad and backspace out the invoice number and then re-enter and save and try again. How was the file created.

You're right, it does have something before the invoice number! I exported it from Crystal.

I have seen this too -- it was exported with Crystal 11. I don't think this occurred when exporting text files from Crystal 10 or lower. What I've done is open in notepad, copy the text and paste into another notepad doc. Then save as the same file name.

If you use Notepad++ (free, much better than Notepad for scripts, etc, and there is a portable version if you don't want to install it on client machines) which will display those bizarre characters and let you clear them out.

This is for a customer to run on a monthly basis (they import invoices from another program) and believe me, they are NOT going to want to have to mess with any additional steps. (Have you ever had a customer who does exactly what they're told but never gets the big picture? If it says VI can't open the file, they call me in a panic. ""Um, let's browse out to where it's supposed to be. Oh look! You saved it with a different name!"" or, ""..to a different location!"")

This is a known Crystal issue with Byte Ordered Mark support. You can update to CR XIR2 sp6 or I could send you the dll file to correct the issue. I always thought Notepad would show the true contents of a file, but these Byte Ordered Marks are hidden even in Notepad and can only be seen in a hex editor. That's why copying the file to another file works. Only the printable characters are copied.

@DanBurleson if you could send me the dll file, that would be great! tlogeais@technology-integrators.com

I always use Access for pulling data and exporting a file. Less mistakes and easier to schedule.

Right @louis, now I need to train them on Access.....

Dan, How about posting the dll here along with comments on how/when it should be used?

I don't think it is a good idea to distribute programs via a public forum.

Oops, sorry Dan! I deleted what I was going to post.

You da man!

Not a problem: The Crystal 11.2 SP6 can be found here: https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm Or I tested just copying the new version of the CSV export module u2fsepv.dll included in the sp and replacing the existing file at these locations: For 32-Bit machines C:\Program Files\Business Objects\Common\3.5\Bin\ u2fsepv.dll Or for 64-bit machines C:\Program Files (x86)\Business Objects\Common\3.5\bin\ u2fsepv.dll

Thanks @DanBurleson - that worked!