Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: CSV Export Alignment problem

  1. #1
    New Member
    Join Date
    May 2005
    Posts
    18

    CSV Export Alignment problem

    Hi List,

    I am in one critical problem. I have one UBE which i want to export in to CSV (.txt) file. while i am exporting it in to CSV that time my columns are not coming properly aligned. Can any one help me on this issue so my data will be exported with proper alignment in to text file


  2. #2
    Member cst's Avatar
    Join Date
    Mar 2005
    Location
    France
    Posts
    74

    Re: CSV Export Alignment problem

    Hi,
    I'm not understand exactly want you want.
    1/ you want a file CSV to import in Excel.
    So, you must name it xxx.csv (not .txt) so that Excel open it directly and it will be align in columns (separated by comma ",").
    In this case, it's not a problem that commas are not aligned because Excel will do it.

    2/ you want a columnated (?) file so, you must build it with "concat" or other but be carfeul to size your columns.

    3/ You use 'Export to csv' jde fonctionnality to have a csv file and some columns are disppear. So, in this case, you must size all columns in your section with same width.
    But i think this is not your case.

    To be more explicit, thanks to explain how you create your csv file (BSFN, TableConversion,...) ?

    Regards,
    Charles

  3. #3
    Senior Member
    Join Date
    Feb 2005
    Location
    Bolingbrook, IL, USA
    Posts
    177

    Re: CSV Export Alignment problem

    There is a white paper on this - ott-00-0047 "Formatting a Report to Export to CSV". For best results, variables need to begin (left edge touches) grid lines. Turn your grid on with horizontal spacing of 52 and vertical spacing of 8. Make sure to use the alignment tools to align everything exactly. If one field is even one pixel below another, it will go on a new row. If fields do not start on a grid line, they could not show up at all or be staggered into new columns.
    Thanks,
    Jeremy

  4. #4
    Senior Member
    Join Date
    Oct 2004
    Location
    Hong Kong
    Posts
    175

    Re: CSV Export Alignment problem

    Sorry for jumping in on this one, but is there any way to do away with the spaces between the columns when exporting to csv. We have to open the report in excel and delete all the addional blank columns everytime.

    Also sometimes when we insert a new column in an existing report and export to excel a few of the existing columns vanish. They appear in pdf but not in excel. we have to insert dummy columns to move the vanished columns a bit and then they appear. Any solution for this?

    Thanks
    Shrikanth
    EnterpriseOne 8.12 TR 8.98.3.2, Windows OS, Oracle 10G

  5. #5
    Senior Member Adrian_Chimirel's Avatar
    Join Date
    Nov 2000
    Location
    Toronto, Canada
    Posts
    2,161

    Re: CSV Export Alignment problem

    Just put your fields in CONSECUTIVE columns.
    It will NOT look nice on your RDA, but you'll get the desired output (no more empty columns).
    Warm regards,
    Adrian,
    E1 9.1 TR 9.1.4.7 08-13-2014_07_7 MSQL 2012 SP1 x64, WebLogic 12c, all on WIntel 2012 x64
    3rd Party Software: All Out Security 3.2, TransForm 5.3, SAP Business Objects Enterprise XI 12
    In the Cloud!

  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    Australia
    Posts
    5

    Re: CSV Export Alignment problem

    The white paper shows to set the alignment to 52/8 and then let the fields to verlap, we do this by creating a version specific for CSV. Also if the report is only ever going to be a CSV create it as a columnar report.
    Hope this helps....

  7. #7
    New Member
    Join Date
    May 2005
    Posts
    18

    Re: CSV Export Alignment problem

    Hi,

    First of all thanks to Charles, Jeremy and webster for taking interest in my Quote.

    According to our requirement, we have one invoice report which we want to export in .txt(Not Excel) file. For this when we are normally exporting it in .txt file that time our columns are not coming properly aligned like which has coming nicely in PDF File. Now our client wants it in very exact aligned like PDF File. For that we did lots of try to arranged our columns in UBE. We set all the variables in Left aligned. We have set its spacing horizontally and vertically. But there is no more improvements in our output. And this is the invoice report so it is not possible to make it columnar report.





    [ QUOTE ]
    Hi,
    I'm not understand exactly want you want.
    1/ you want a file CSV to import in Excel.
    So, you must name it xxx.csv (not .txt) so that Excel open it directly and it will be align in columns (separated by comma ",").
    In this case, it's not a problem that commas are not aligned because Excel will do it.

    2/ you want a columnated (?) file so, you must build it with "concat" or other but be carfeul to size your columns.

    3/ You use 'Export to csv' jde fonctionnality to have a csv file and some columns are disppear. So, in this case, you must size all columns in your section with same width.
    But i think this is not your case.

    To be more explicit, thanks to explain how you create your csv file (BSFN, TableConversion,...) ?

    Regards,

    [/ QUOTE ]

  8. #8
    New Member jgvargas's Avatar
    Join Date
    Mar 2004
    Location
    Leon, Guanajuato, Mexico
    Posts
    28

    Re: CSV Export Alignment problem

    Estimado amigo:
    Entiendo tu problema, pero creo que te estas complicando la existencia. segun entiendo el problema, tu tienes un Reporte, y ese reporte para ti es una factura, y dicha factura tu la deseas imprimir. si es eso, aqui te proporciono un posible solucion.
    1.- Modifica una version del reporte, y en el RDA(Print Setup, Peper Custom, Whidth=X,Height=Y), establece el tamańo del papel a las medidas de la factura fisica(papel, osea X x Y). Nota: debes de modificar el tamańo del papel en una version, en el objeto principal no verias los cambios.
    2.- Formatea la version del reporte, como desees que quieras que salga la impresion, osea, ajusta los campos en el reporte, de tal manera que cuando quieras imprimir ese reporte, este caiga en el papel(fisico) en la posicion correcta.
    3.- En las propiedades de la impresora, crea una nueva hoja con las dimenciones de X x Y, de la factura fisica, y establecela por default.


    Si tu entiendes estos datos podras analizar, que cuando el usuario genere su PDF, este lo mande imprimir no se preocupe en hacer muchos procedimiento, si no solamente en imprimir dicho PDF.
    OneWorld J.D.Edwards, Relese B7333, Relese E810, Release 8.11,Release 9.0

  9. #9
    Senior Member tgore's Avatar
    Join Date
    Jul 2002
    Location
    Rolling Meadows, Illinois
    Posts
    317

    Re: CSV Export Alignment problem

    One problem you might encounter that many poeple overlook is to make sure you do not have any commas in any of the data fields. This will really mess up a CSV file. You will get unexpected breaks.
    AS400 820 V5R1, World, OW B7334 Xe SP21F1, CITRIX, HP9000 11.0

  10. #10
    Senior Member
    Join Date
    Oct 2004
    Location
    Hong Kong
    Posts
    175

    Re: CSV Export Alignment problem

    thanks adrian and webster, i shall definitely try this out. my users will be very relieved when it works. thanks again
    EnterpriseOne 8.12 TR 8.98.3.2, Windows OS, Oracle 10G

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.