E810 Export to CSV Error (  )

Hi List,

We are currently experiencing a problem in E810 when exporting a report to CSV. All the data is brought into MS Excel properly, but in the first column in the first row we get 3 extra characters that appear (  ). Sending the report to PDF is fine, we do not see these extra characters. It is only when we run the report with "Export to CSV" selected that it does this. We did not see this problem in XE.

ex.
DetailData1
DetailData2
DetailData3
DetailData4

Has any ever encountered this situation ?


Thanks

Andrew

Hi Andrew,
Is it an old (upgraded) version? Try with a new one.
What about the layout - does it have the horizontal spacing set to 52?

Hi Adrian,

No this is a fresh E810 Install (Tools Release 4), with some custom objects boomeranged over from our previous version of One World (B7334 sp 23).


It is doing this on any report (new & old) we try to export to CSV, both submitted to the server and locally. I even created a dummy address book report from scratch and it still puts them there when exporting to CSV.

Yes, we also did try setting horizontal spacing to 52 , it did not seem to make a difference.

If you changed the extention of the .CSV to .txt and view with notepad these characters do not show, but MS Excel and MS Word both show the 3 characters.

What platform are you on? You are seeing a series of control characters - based on the platform, it could be a csid issue.

(db)

What plaform / language / database?

We are running Peoplesoft EnterpriseOne
Application Release E810 (sp 8.94)
Tools Release 4
NT / SQL Server 2000

I have a feeling, these characters are from UTF8 encoding.

Do you have any config in P93081?

Hi all,

We found the solution to our problem.

There was a new entry that we needed to add to the jde.ini file in the [UBE] section.

[UBE]
UBEUnicodeCSV=1

Once we added this to our jde.ini file the problem went away.

Andrew

Thank YOU for sharing, Andrew!

Originally the output looked good the 3 characters were gone, until we sent it to the bank. The CSV file was now all in Unicode.

In E810 the database has change to Unicode.
The UBEUnicodeCSV=1 entry turns the output of the CSV file into Unicode. Unfortunately the bank we are sending this file to does not accept Unicode, only plain text ASCII.

The application P93081 that Alex mentioned seems like it should be the answer to our solution, as that is what it was designed for, but it does not have any effect on the output of the report when saving to CSV.

The Response from JDE has been to open the up and save it as plain text ASCII. Not the Ideal solution.

If we remove the UBEUnicodeCSV=1 from the JDE.ini the output is not in Unicode but we are back to the original problem of the 3 extra characters

-----------------------------------------------------------
As a work around we re-coded the report to use the B0500025 - ExportToFlatFile function. This created a text file in ASCII format and we are able to use this file.

I also experienced this problem and it turns out to be a bug in Excel, the only fix to remove the characters is to upgrade to office 2003. I tried this on one PC and the characters went away. This doesn't work for the client so we are just going to live with it, and hope in a later SP that there will be a fix.

Try including these in the jde.ini
[UBE]
UBEUnicodeCSV=1
prtCSVExtension=.csv
prtCSVSeparator=\t (value of the desired separator character)

The Excel 2003 solution is an expensive approach. Each user outputting to a CSV needs to be upgraded. And by the way, Excel 2003 is not in the MTR.