Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › Trouble importing products with CSV to DB
Tagged: csv to db, importing, spreadsheet
- This topic has 14 replies, 5 voices, and was last updated 12 years, 8 months ago by admin.
-
AuthorPosts
-
January 21, 2011 at 6:34 pm #2553chipcherryMember
Warning: fopen(/usr/local/apache/htdocs/~chip/wp-content/plugins/wp-csv-to-db/uploads/test3.csv) [function.fopen]: failed to open stream: No such file or directory in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 46
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
****** I have checked file permissions on the plugin files, I have reinstalled estore, and the csv to db plugin several times. I have striped the csv file to a simple test product and have gotten the same results. I checked with my host company and they were unable to determine what may be happening. I have gone through 3 separate forum postings you have on this topic, and was unable to reach a resolution. I greatly appreciate your assistance.
January 22, 2011 at 4:54 am #28291amin007ParticipantWhat value do you have in the “Specify the file URL” field of the CSV to DB plugin?
January 24, 2011 at 5:58 pm #28292January 25, 2011 at 7:22 am #28293amin007ParticipantThat looks like a temporary URL to me. You don’t have you site live yet? I have updated the plugin slightly to use absolute path to open the file. Lets see if that helps at all. Can you download a new copy of the plugin from here and give it a go:
Don’t forget to deactivate and delete the old copy first.
January 25, 2011 at 8:50 pm #28294chipcherryMemberWarning: fopen(/usr/local/apache/htdocs/~chip/wp-content/plugins/wp-csv-to-db/uploads/test3.csv) [function.fopen]: failed to open stream: No such file or directory in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 46
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
********** Yes this is a temp url, we have the existing site hosted elsewhere on a different platform.
I downloaded the new file, deactivated and deleted the existing plug in, reinstalled and got these new errors.
Thank you for all of your help!
January 26, 2011 at 4:10 am #28295amin007ParticipantLets try using a relative URL. Please enter the following value in the “Specify the file URL” field and hit save location:
uploads/test3.csv
Now try to import it.
January 26, 2011 at 11:02 pm #28296chipcherryMemberSame error. I apologize I didn’t include that, we have tried removing every file level one at a time.
I did reattempt specifically uploads/test3.csv, and received the same error.
Thank you for all of your help!
January 27, 2011 at 5:32 am #28297amin007ParticipantI will take a look at your site. I have sent you an email.
April 6, 2011 at 10:09 pm #28298RinaldoMemberI am really sorry to bother you everyday with new problems: My import allegedly worked well, except that there are no new products in the Manager!?
Thanks!
April 7, 2011 at 2:01 am #28299amin007ParticipantLOL… have you changed the database prefix of your WordPress installation? Did you first try importing the two test products from the “products.csv” file to see if it works or not?
April 7, 2011 at 7:43 am #28300RinaldoMemberYes, I just tested with sample products – same result – successfully imported, but no new products in PM.
No, I have not yet changed the table prefix.
?
Thanks!
April 8, 2011 at 5:36 am #28301amin007ParticipantI have sent you an email to get site access so I can check it out.
April 9, 2011 at 1:22 am #28302amin007ParticipantI had a look at your CSV to DB plugin settings and it looks like you didn’t specify the values in the “Database Column Names” field.
According to the instruction you are suppose to enter the following in the “Database Columns Names” field:
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
Please do exactly what the instruction says.
March 1, 2012 at 8:50 am #28303dwilkesMemberI am getting the error “There was an error uploading the file, please try again!” when trying to upload my .csv products file using wp-admin settings (csv To DB) on my website “http://www.stbedes.school.nz” I think I have followed all instructions correctly.
March 1, 2012 at 10:15 pm #28304adminKeymasterPlease see this video tutorial then use the technique explained there and you won’t have any issue importing content into a database table:
-
AuthorPosts
- You must be logged in to reply to this topic.