CSV Error

[binky]

Good Day All

I have sucessfully created a report that I can export to CSV format. I used many suggestions within this forum, so thanks to all.

I also have created a history report that reproduces the above mentioned reports. They look fine when viewed in .pdf form but the header, details, footer order gets completely messed up when I export it to CSV.

1. Could this be due to multiple pages in the report?
2. Has anyone had similar problems with multi pages reports exporting to CSV?

All thoughts welcome, I'm not sure where to go with this one.

Thanks
Binky

 

[Adrian_Chimirel]

Did you use the "How to" KG document related to UBEs to be exported to CSV?
It suggests using a minimum Horizontal Spacing of ??(I forgot, but you may do a search on CSV, here on the List, or in KG), and align your objects ...
And I suggest you include your sys config in your signature (see mine)
Warm regards,
Adrian Chimirel

 

[KSmithCPA]

The Horizontal Spacing should be set to 52 when outputting to a CVS file.

Peace.

 

[binky]

Thanks to you both.

I your suggestions without any luck. I am still having exporting problems if my report is longer than a single page.

Thanks for the signature tip Adrian!

 

[chokiti]

The Horizontal Spacing should be set to 52 when outputting to a CVS file.Peace.
Ken <img src=\"http://www.jdelist.com/ubb/images/icons/cool.gif\
XE SP 16
Win2000/Oracle 8.1.6.
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OWDEV&Number=41224
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE Developers mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

 

[Segfault]

Perhaps you could attach a PDF file of the output with some dummy data so we can get an idea what you are doing?

 

[KSmithCPA]

After changing your horizontal spacing you also need to align your fields with the grid lines. They will not look right on the RDA screen, but they will convert to CVS format more consistantly.

Hope this helps.

Peace.

 

[binky]

Great idea!

Attached is an example of what I can produce if I export to CSV when the report is less then 1 page.

THISISMYTEST### is a predefined header

The 300... line is the file starting header (electronically sent to another computer in their format)

The DET... is the detail line

And 999... is the end of file line.

As I mentioned previously, it works great if the report is only 1 page. If more than one page (I've only tested with two pages so far) the 999... line prints where the page break occurs.

Any thoughts?

 

[Segfault]

Hmm. No attachments came through to the list. Perhaps if you attach a .zip from the forum on http://www.jdelist.com/ it will work better.

 

[slhgrainco]

I found it useful to omit the default headers and footers and create my own sections for them - group section (not set as a header or footer to the main section) and set the Only when Explicitly Called flag on each.

In Page Setup, set the output to CSV and changed column width to 52 when asked.

Then moved data items into the columns - ignore the overlapping, Excel will sort it all out. Set up constants in the custom "header" section aligned with the data items, and in the custom "footer" section any constants and totals, again aligned with the correct data item.

Then in the event rules for the main section, the following code:
in Initialize Section: Do Custom Section (name of custom "header" section)
in End Section: Do Custom Section (name of custom "footer" section)

Looks ugly in Report Design, but works perfectly when you look at it in Excel. Have all fields horizontally aligned - if any are a little lower than others in the same section, it'll split it over 2 rows.

Now I just have to figure out how to make the CSV option a default - have set it in the report and in the versions, but still won't output to CSV unless you specify it in the printer selections window.....


oh - this is only useful if you have a UBE that you ALWAYS want to view through CSV, and not through CSV sometimes and PDF others - if you want both options (though I haven't explored this), perhaps a processing option and different sections within the report formatted accordingly - or just do 2 reports.

Sharon

 

[Segfault]

To make it a default, go into the report->printer setup in RDA and check the "Export to CSV" checkbox.

This setting is per version.

If you set it on the template, any new version you create should get the setting.

Have fun!

 

[jde1919]

Re: 17.1 Bug

Binky,
I had the same problem. Do a KnowledgeGarden search for Call # 4988047. It looks like it is a problem with Service Pack 17.1 There is a SAR #5612920 that should fix it, but they (JDE) recommend upgrading to SP18 or higher.

At every page break it will be missing a line, and add the 999 line at various places in the CSV export. You could use RDA and modify the report to do a Database Output to a CSV everytime the report runs. (doc # 00t-99-0215) I have used this as a work around.

Good Luck.
-jde1919

 

[SHAKER]

Select all Columns in each section seperatly and use the Alignment , this will fix you problems....

 

[binky]

have been in contact with JDE and this bug was supposed to have been fixed in sp17. We are now on sp20 and it works great! Thanks for all your suggestions.

Binky