DBohner-(db)
Legendary Poster
Don't we all love CSV Output? I've been doing a few Flat-File Exports (CSV), lately - and thought I post a few comments (tips), so I can find them here (instead of trying to remember). Here Goes:
CSV Tips / Traps:
1. Make sure your Unicode / Flat File settings are set correctly. Starting in one of the 8.94 tools releases, Oracle flipped a switch that requires us to use CP1252 Encoding. P93081->Create a new entry, defaulting everything to CP1252 -> Then remember to ACTIVATE it.
a. If you do not turn on the Unicode Switch – you will get a one column entry, when you open in CSV.
b. The cause is, actually, that the file data is Unicode (6 6 6 . 0 0 instead of 666.00 – if you look at it through DOS Edit)
2.In Layout, Set your Horizontal (Columns) Grid Alignment to 52 (yes, that is a magical number – and it usually works)
3.In Layout, set your Vertical (Rows) Grid Alignment to 11(Not a Magical Number – just something Experience has taught me). Setting to 11 places a small gap between the rows – allowing a bit more visual definition between rows. BUT – it does not garuntee that the row will be aligned (<grrrrr>)
4. If you have a row that does not want to align, one or more objects keep dropping to the next row; Select the ENTIRE ROW->Hold the CTRL Key and select the object that keeps dropping to the next line. This will place a darkened box around that specific Object ->then Bottom Align the entire row.
a. The Forces within the bOrgacle have not figured out that, for some reason; Text, Text Variable, Numeric Variable, Date Variable and Bolded objects are of different heights (WHY???). Doing this ‘Bottom Align’ with the ‘tallest’ object – seems to fix this issue
I know there are a ton more tricks – Share yours, please!
ps, Terry D....
[ QUOTE ]
Just posting, because I don't really know (and, I'm trying get to my 2000th JDEList Post):
[/ QUOTE ]
I finally made it!
(db)
CSV Tips / Traps:
1. Make sure your Unicode / Flat File settings are set correctly. Starting in one of the 8.94 tools releases, Oracle flipped a switch that requires us to use CP1252 Encoding. P93081->Create a new entry, defaulting everything to CP1252 -> Then remember to ACTIVATE it.
a. If you do not turn on the Unicode Switch – you will get a one column entry, when you open in CSV.
b. The cause is, actually, that the file data is Unicode (6 6 6 . 0 0 instead of 666.00 – if you look at it through DOS Edit)
2.In Layout, Set your Horizontal (Columns) Grid Alignment to 52 (yes, that is a magical number – and it usually works)
3.In Layout, set your Vertical (Rows) Grid Alignment to 11(Not a Magical Number – just something Experience has taught me). Setting to 11 places a small gap between the rows – allowing a bit more visual definition between rows. BUT – it does not garuntee that the row will be aligned (<grrrrr>)
4. If you have a row that does not want to align, one or more objects keep dropping to the next row; Select the ENTIRE ROW->Hold the CTRL Key and select the object that keeps dropping to the next line. This will place a darkened box around that specific Object ->then Bottom Align the entire row.
a. The Forces within the bOrgacle have not figured out that, for some reason; Text, Text Variable, Numeric Variable, Date Variable and Bolded objects are of different heights (WHY???). Doing this ‘Bottom Align’ with the ‘tallest’ object – seems to fix this issue
I know there are a ton more tricks – Share yours, please!
ps, Terry D....
[ QUOTE ]
Just posting, because I don't really know (and, I'm trying get to my 2000th JDEList Post):
[/ QUOTE ]
I finally made it!
(db)