Incorrect data type when exporting to CSV

(6 posts) (2 voices)
  1. cayasanchez, Member

    I have a report where all values are numbers, when exporting to CSV I use the statement:

    select 'dbr.export.options', 'csv.skip_formatting', 1;

    Some values are exported as numbers and others as text.
    I'm using the latest MyDBR version myDBR 7.1.0 (build 5232).
    Is there anything I can do so all the data is exported as numbers instead of text?

    Thanks in advance.

  2. myDBR Team, Key Master

    Where do you see the numbers shown as text?

    Can you open up a support ticket with example data as a SQL export if your report.


    myDBR Team

  3. cayasanchez, Member

    I see the numbers as text when opening the CSV file in Excel

  4. myDBR Team, Key Master

    It could be just Excel interpreting the CSV file.

    Please open a support ticket with example data as a SQL export of your report.


    myDBR Team

  5. cayasanchez, Member

    Please explain me how to open a support ticket. I can't find that option in MyDBR.
    Should I just send an email with the details to an specific email address?

  6. myDBR Team, Key Master

    The support email address is support@mydbr.com.

    When you open a ticket, the best way to do it, is to run SQL export of your report and attach the generated code to the ticket. This way we can replicate your report without your tables and data.

    --
    myDRR Team


Reply

You must log in to post.