Kryptronic Software Support Forum

markelvin · 07-30-2004 12:52:03

Hi, I have just converted my product.csv file to sql without any glitches an now want to add some more products. Am I right in thinking I need to somehow add these to the SQL database?

If so how would I do it? I am not too technical so would welcome a walkthrough. The reason I moved to mysql is that when my product.csv file hit 380K the site was intermittently poor. Having contacted my ISP they said it was due to the resources the CGI script was taking up.

It has taken we a week to implement excel entry files that allow me to create csv files with the minimum of sata entry and hope it is possible to append a new csv file to the existing mysql table.

Would really appreciate any help as I was hoping to get this sorted this weekend.

Many thanks

Mark

EagleWolf · 07-30-2004 13:00:24

If you want, log into the ccp admin, move the product table back into csv, then download that and work on that table. Once you are done, upload it in binary format and go back to the ccp admin and convert it back to mysql.

markelvin · 07-30-2004 13:19:01

Chris

Thanks for the info and also the prompt reply. I thought while Britain was getting ready for bed America would still be working :-)

Ever the optimist, can I append to mysql database or would i need my hand holding for so long I would end up tripping over my beard

Regards

Mark

ghost1157 · 07-30-2004 20:52:05

Be aware ! "Converting" BACK to CSV from MySQL does not "convert" the actual MySQL records to CSV ! Converting back ONLY makes the program start reading from the CSV file instead of the MySql . When your product table is in MySql and you make updates via the CCP51 admin panel , these updates will not be dumped back into your CSV file when using CCP51 admin to "convert" back to CSV .

You can use phpMyAdmin to dump the MySql file back to CSV and you will not lose your changes . Howver if you have made changes to the product file while it was in MySql and you only use the CCP51 admin to sitch back to CSV mode you will lose any changes you made while it was in MySql !

EagleWolf · 07-31-2004 00:42:04

From my understanding that if you move your tables into mysql, and add items to your cart, then move your tables back to csv it dumps those mysql tables into your csv tables. So it is up to date.

ghost1157 · 07-31-2004 00:47:34

Well , that would certainly be nice , but mine doesn't work that way ........

webmaster · 08-13-2004 13:57:31

It should. That is unless the permissions are wrong on your product.csv file. It performs a full MySQL -> CSV dump. Make sure permissions on the product.csv file are world-writable (chmod 777 on Unix/Linux).

Kryptronic Software Support Forum

#1 07-30-2004 12:52:03

How To Update Mysql Product Table

#2 07-30-2004 13:00:24

Re: How To Update Mysql Product Table

#3 07-30-2004 13:19:01

Re: How To Update Mysql Product Table

#4 07-30-2004 20:52:05

Re: How To Update Mysql Product Table

#5 07-31-2004 00:42:04

Re: How To Update Mysql Product Table

#6 07-31-2004 00:47:34

Re: How To Update Mysql Product Table

#7 08-13-2004 13:57:31

Re: How To Update Mysql Product Table

Board footer