Report Export Question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pdavis1958
    Member
    • Oct 2015
    • 48

    Report Export Question

    Why does the Get csv option from Reports produce an excel file that looks like this? I used a budget field I have as an example of the way all the fields export instead of a typical Excel File
    Ancestry;0;0;0;19.99;0
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    You can change export delimiter in crm, you can select other delimiter in csv file
    By default in system it is ';', set ',' if you want (in Preferences)

    Comment

    • pdavis1958
      Member
      • Oct 2015
      • 48

      #3
      I have it set to , but is still not working. Is there more than one place that it has to be set to , (comma) ?

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        in data/config.php exists global settings (exportDelimiter)

        Comment

        • pdavis1958
          Member
          • Oct 2015
          • 48

          #5
          But that merely has to be set in the admin preferences doesn't it? Or does something else have to happen?

          Comment

          Working...