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

Thread: CSV Export

  1. #1
    Join Date
    Feb 2009
    Posts
    2,165

    Default CSV Export

    I am assuming that the csv export option does not cater for a csv export with the column names only appearing one on row 1?

    Is this correct as it seems to wonts to place column header for every page break

  2. #2
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: CSV Export

    Chris,

    At export you have options for what sections to export. Column headers are usually printed in the page header and you can tell the export to use page headers and footers.

    On top of that you can suppress sections, objects etc based on functions and thus control what gets exported via integration.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  3. #3
    Join Date
    Feb 2009
    Posts
    2,165

    Default Re: CSV Export

    I apologise, maybe I wasn't clear in my question.

    What you have told me I understand.

    What I want to know is can I put out the column header once only in row 1 the all the rest of the rows are data.
    AS for import to excel. Not column header repeated on each page break

    From what I see with experimenting that the report writer is not designed to output as requested.

    Is this correct?

  4. #4
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: CSV Export

    Chris,

    Just spend 1 minute on this and I don't see a problem. Enclosed is the test report and output.

    For the upload here I had to rename the CSV file
    Attached Files Attached Files
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  5. #5
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: CSV Export

    Chris,

    Additional; the section suppress is now a function but unconditional. One can change this from integration level, for example via a parameter.

    In the enclosed version there is a parameter called Exporting. When false the page header is repeated on each page, when true only the first page.

    Note that when this parameter changes at runtime the report needs to be reformatted
    Attached Files Attached Files
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  6. #6
    Join Date
    Feb 2009
    Posts
    2,165

    Default Re: CSV Export

    I will look at this later but I made the assumption from reading the help that the report would have internal logic to do what I wanted.

    The help needs to be expanded i think to explain what the csv export option really does in its native form.

    In othe words a normal report could be asked to export as csv and the details and headers would be.

    However as I use RDS for all reports I have gone down a diferent route not using the reports to export to csv if required by client

  7. #7
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: CSV Export

    Chris,

    Export is a kind of weird thing from reports with the exception of PDF. Export to Word is also OK but one should ask the why? Is it to change the results? Same for Excel.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  8. #8
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia
    Posts
    2,863

    Default Re: CSV Export

    Excel is essential as the accounts department often have to consolidate data from 5+ systems.
    So excel macros can pull the data together.

    You could say that this should be with a collating system that uses api’s. And I would agree, but have you have tried to get an accountant to give up their spreadsheets? It’s dangerous
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    DataFlex Channel Partner for Australia and Pacific region
    Adelaide, South Australia
    www.28it.com.au

  9. #9
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    5,445

    Default Re: CSV Export

    They simply don’t!
    Samuel Pizarro

  10. #10
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default Re: CSV Export

    Try working with a company that has over 100 spreadsheets that act as "reports" (ODBC connection to the production database via the Guest account that has read/write permissions & no password) & an additional 20 or so that update data! Nightmare.

    Spreadsheets are IMO one of the most abused pieces of software out there.
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •