Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 10-28-2011 12:01:56

Lisaweb
Member
From: CA
Registered: 04-21-2003
Posts: 417

Please help: Need the right settings to download database tables

My product database has gotten so large that I am unable to download it from within CCP.  But when I try to download it via phpmyadmin into a csv file, the columns and rows become all corrupted.  I'm pretty sure this is because I am not using the right settings.  Here are the setting options the program gives me:

Format:   CSV
Character set of the file:   utf-8
Columns separated with:   ,
Columns enclosed with:   "
Columns escaped with:   \
Lines terminated with:   AUTO
Replace NULL with:   NULL
Remove carriage return/line feed characters within columns:    NO
Put columns names in the first row:   YES

Which one of these setting is incorrect?

Thanks so much for any help or suggestions you can provide.  :-)

Offline

 

#2 10-28-2011 13:09:01

JDLS88
Member
From: Maryland, USA
Registered: 07-06-2011
Posts: 102
Website

Re: Please help: Need the right settings to download database tables

I've been exporting it as "CSV For MS Excel" or "Open Document Spreadsheet" . Then I make my changes in Excel. Then from Excel I export it as a regular CSV. Then I upload that CSV. That might work better for you.


Jeremy D.

Offline

 

#3 10-28-2011 23:59:46

Lisaweb
Member
From: CA
Registered: 04-21-2003
Posts: 417

Re: Please help: Need the right settings to download database tables

Thanks soo much for the advice!  Unfortunately, however, I do not have Microsoft Excel.  I only have OpenOffice Calc.  But I'll give your suggestion a try with Calc, and see what happens.

Thanks again,

Offline

 

#4 10-29-2011 06:19:30

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: Please help: Need the right settings to download database tables

You don't need Excel, OpenOffice will handle Excel files just fine.

Offline

 

Board footer