Problem uploading CSV file

[AHI]

I’m trying to upload a CSV file using the CSV to DB plugin. My CSV file consists of 6 columns and 39 rows. The first row contains column headers and all of the other rows have a value in each column (i.e., I don’t have any blank cells). I also made sure that I don’t have any special characters. I follow the tutorial instructions, but I keep getting the following error:

Error occured while trying to import!

Insert into the Database failed for the following Query:

INSERT INTO wp_wp_eStore_tbl (name,price,product_download_url,downloadable,available_copies,button_image_url) VALUES (”)

Insert into the Database failed for the following Query:

INSERT INTO wp_wp_eStore_tbl (name,price,product_download_url,downloadable,available_copies,button_image_url) VALUES (”)

Insert into the Database failed for the following Query:

INSERT INTO wp_wp_eStore_tbl (name,price,product_download_url,downloadable,available_copies,button_image_url) VALUES (‘}’,’200);’)

Can I send you my CSV file? I don’t know what I’m doing wrong!

[amin007]

It’s easier if you just do what the video tutorial on this page does:

How to Bulk Upload eStore Products from a CSV File

Don’t add it any modification just yet… simply do what the video does to test the whole thing.

Once you see it working then go to the next step and modify the CSV file to add in your own product details.

If you still can’t figure it out let me know and I will take a look.

[AHI]

I followed the video exactly and I got the error below. Please help.

Error occured while trying to import!

Insert into the Database failed for the following Query:

INSERT INTO wp_wp_eStore_tbl (name,price,product_download_url,downloadable,shipping_cost,available_copies,button_image_url,return_url,sales_count,description,thumbnail_url,variation1,variation2,variation3,commission,a1,p1,t1,a3,p3,t3,sra,srt,ref_text,paypal_email,custom_input,custom_input_label,variation4,aweber_list,currency_code,target_thumb_url,target_button_url,weight,product_url) VALUES (”)

Insert into the Database failed for the following Query:

INSERT INTO wp_wp_eStore_tbl (name,price,product_download_url,downloadable,shipping_cost,available_copies,button_image_url,return_url,sales_count,description,thumbnail_url,variation1,variation2,variation3,commission,a1,p1,t1,a3,p3,t3,sra,srt,ref_text,paypal_email,custom_input,custom_input_label,variation4,aweber_list,currency_code,target_thumb_url,target_button_url,weight,product_url) VALUES (”)

Insert into the Database failed for the following Query:

INSERT INTO wp_wp_eStore_tbl (name,price,product_download_url,downloadable,shipping_cost,available_copies,button_image_url,return_url,sales_count,description,thumbnail_url,variation1,variation2,variation3,commission,a1,p1,t1,a3,p3,t3,sra,srt,ref_text,paypal_email,custom_input,custom_input_label,variation4,aweber_list,currency_code,target_thumb_url,target_button_url,weight,product_url) VALUES (‘}’,’200);’)

[Ivy]

Hi, We will need to have a closer look at what is happening on your site. I will send you a site access request via email. Please let me know if you do not receive this email.

[vocalcoach]

Hello

Did this issue get resolved?

I have a simiar issue of which i cant work out

please find details listed below

I would appreciate some help if anyone has experienced the following problem.

I have installed the wp csv to database plugin. works ok with a test using the same layout as in the test file.

I have saved xl sheet as a windows comma separated value .cvs ( I am using a Mac and read previously to use this format for mac). I have ftp the file to the correct location. I have also used the plugin upload option also. The problem is I get an error it seems, if I export anything more than line 16! I have over a thousand products in this csv file.

example of error is

Error occured while trying to import!

Insert into the Database failed for the following Query:

INSERT INTO ss_wp_eStore_tbl (name,price,product_download_url,downloadable,ship ping_cost,available_copies,button_image_url,return _url,sales_count,description,thumbnail_url,variati on1,variation2,variation3,commission,a1,p1,t1,a3,p 3,t3,sra,srt,ref_text,paypal_email,custom_input,cu stom_input_label,variation4,aweber_list,currency_c ode,target_thumb_url,target_button_url,weight,prod uct_url) VALUES (‘GIRLS ON FILM – DURAN DURAN’,’1′,’www.successfulsinging.co.uk/BT-Folder/GIRLSONFILM.mp3′,’yes’,”,”,’http://www.successfulsinging.com/wordpress/wp-content/plugins/wp-cart-for-digital-products/images/add-to-cart-10.gif’)

Insert into the Database failed for the following Query:

INSERT INTO ss_wp_eStore_tbl (name,price,product_download_url,downloadable,ship ping_cost,available_copies,button_image_url,return _url,sales_count,description,thumbnail_url,variati on1,variation2,variation3,commission,a1,p1,t1,a3,p 3,t3,sra,srt,ref_text,paypal_email,custom_input,cu stom_input_label,variation4,aweber_list,currency_c ode,target_thumb_url,target_button_url,weight,prod uct_url) VALUES (‘GIVE A LITTLE WHISTLE – DISNEY PINOCCHIO’,’1′,’www.successfulsinging.co.uk/BT-Folder/GIVEALITTLEWHISTLE.mp3′,’yes’,”,”,’http://www.successfulsinging.com/wordpress/wp-content/plugins/wp-cart-for-digital-products/images/add-to-cart-10.gif’)

I have re done the csv file as it seems the error stats from line 17 everytime no matter how many lines are in the file.

during testing anything with 16 or less lines work!

is there a php file i can edit to make the list unlimited or at least a 1000 lines?

would be very pleased if someone has the answer

thanks in advance

[admin]

Try this option… it is more flexible and robust (the video tutorial should explain everything):

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[vocalcoach]

Thanks ever so much for your very prompt reply.

The video tutorial was fantastic, I think his name was Kirk, a wonderful presentation – it certainly made my basic understanding of phpmyadmin improve and I followed the basic idea and it has worked and my products are now added.

Thankyou so much.

I am not 100% sure but I think the database uses column A as the I.d. value and the file i was uploading originally was using column A as the ‘name’ value and that may have confused it?

thanks again you wonderful people.

[Author]

Posts