Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: [SOLVED] CSV export not working

[SOLVED] CSV export not working 14 years 4 months ago #8822

  • jrossi
  • jrossi's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 21
  • Thank you received: 0
I'm having an issue with CSV export not properly pulling the fields. When I export it pulls the information into one field in Excel. This is making the information impossible to read.

Please Log in or Create an account to join the conversation.

[SOLVED] CSV export not working 14 years 4 months ago #8881

  • licausse
  • licausse's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
same problem here, when I export a CSV, it's like Excel cant really recognize the format & put all the data into one single field.

Please Log in or Create an account to join the conversation.

[SOLVED] CSV export not working 14 years 4 months ago #8887

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Then this means you have not followed directions... you have upgraded without re-saving the DT Register configuration. There is a parameter on the first tab of configuration for declaring the character to be used as the separator for the CSV export. You have not saved, so your database has no character to be used for separation... so there is NO separation being made. Save this parameter with a comma (or whatever you need it to be), then you'll be fine.

Please Log in or Create an account to join the conversation.

[SOLVED] CSV export not working 14 years 4 months ago #8896

  • licausse
  • licausse's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
Actually there already was a comma(,) but Excel doesnt recognize the comma. I put a semicon(;) instead and it just worked fine.

Please Log in or Create an account to join the conversation.

[SOLVED] CSV export not working 14 years 4 months ago #8897

  • jrossi
  • jrossi's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 21
  • Thank you received: 0
I had the same thing the comma was already there. I just deleted it and saved then put it back in and saved again and it worked fine.

Please Log in or Create an account to join the conversation.

[SOLVED] CSV export not working 14 years 4 months ago #8898

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
The comma will show up in the config as default, but you still need to SAVE it to the database.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.145 seconds