CSV Output Difference Local vs Sever

[leggleston]

I have a csv report that prints without a problem when I run it locally. When run on the server, three fields come up missing. They are three in a row, but in the middle of the report, so it's not getting cut off somehow. Could this simply be a problem with spacing? I don't see why it would be different between the two, but any suggestions would be helpful.

Thank you

Lee Eggleston
XE AS400 SP20

 

[DBohner-(db)]

Hi Lee (my gude friend),

Generally, it is probably spacing. Make the columns wider (the actual
data, not the space between, even if they seem to wide already). CSVs
can be a pain! Make sure that all columns in all sections line up -
or you can see similar issues.

(db)

You know how to get a hold of me if you want to chat off-line!


On Tue, 19 Oct 2004 10:42:34 -0500, leggleston


--

 

[anurudh]

Can you confirm whether your Horizantal Grid Alignment is set to '52' for CSV output.

 

[sap_sucks]

Hey Lee,

RDA uses a specific width to determine what
makes up a cell when choosing the option to Export to CSV.
In order to configure a report to Export to CSV, it is
necessary to modify the report in the Report Design Aid so
that the columns fit within this width and do not overlap
within a cell. to do this, From within the Report Design
Aid choose the option for Layout - Grid Alignment. Set the
Horizontal Spacing to 52. Make sure both the Snap to Grid
and Display Grid options are selected. Press OK. This
changes the look of the Grid (Dotted Lines) that appear
within the Report Design Aid. Each Cloumn that appears,
or space between dotted lines, makes up a column when
exporting to Excel.

Good Luck!

 

[leggleston]

I ended up getting it to work. What was odd is that it the output was fine when run locally.

What I ended up doing was setting my spacing to zero and making sure each field was the exact same size, 1/2 inch. I kept my column width set to 52 for all 70+ fields.

I then tested and tested until both local and server had the same output. It took several tries, but it ended up working.

Thanks for your inputs!

 

[Zoltan_Gyimesi]

Hi Lee,

There is a white paper:

OTT-00-0047 "Formatting a Report to Export to CSV"

which describes enough well, how to format the layout for CSV output, as well for Columnar as for Group sections.

I followed that instructions more times, whithout problem.

You can find this white paper on the PSFT customer Connection, searching for "OTT-00-0047" with the Search function on the left side of the PSFT form. I tried it now and I got 6 hit. The 4th was this documentation.

Hope, this helps a bit.

Regards,

Zoltán

 

[DBohner-(db)]

Zoltan - it's answers like yours (that give specific direction on how
to find the documentation) that makes this list so GREAT!

THANKS

(db)


--