Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › Error importing csv file for bulk upload
- This topic has 6 replies, 2 voices, and was last updated 13 years, 10 months ago by amin007.
-
AuthorPosts
-
November 19, 2010 at 10:02 pm #2260rramirez125Member
I think I have followed all the instructions and I am getting the following errors,when trying to
could you please let me know if you know of a workaround
Warning: fopen() [function.fopen]: URL file-access is disabled in the server configuration in /home2/shb12_114/travpho.com/public_html/Travpho/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 27
Warning: fopen(http://travpho.com/Travpho/wp-content/plugins/wp-csv-to-db/uploads/products.csv) [function.fopen]: failed to open stream: no suitable wrapper could be found in /home2/shb12_114/travpho.com/public_html/Travpho/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 27
Warning: feof(): supplied argument is not a valid stream resource in /home2/shb12_114/travpho.com/public_html/Travpho/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 30
Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home2/shb12_114/travpho.com/public_html/Travpho/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 32
November 19, 2010 at 11:53 pm #26720amin007ParticipantHere is the problem:
URL file-access is disabled in the server configuration
So on your server URL fopen functionality is disabled so when the plugin is trying to open the uploaded CSV file it is failing to read it.
I have slightly modified the CSV to DB plugin so it converts the URL into an absolute path before opening the file which might solve this issue. Try downloading v1.2 from here and give it a go:
November 21, 2010 at 7:08 am #26721rramirez125MemberThank you !!! I will try it out and let you know how it goes
November 21, 2010 at 7:33 am #26722rramirez125MemberI just tried it and this is what I get now, I think the url is fine because I can access it by typing it on the browser.
http://travpho.com/Travpho/wp-content/plugins/wp-csv-to-db/uploads/products.csv
errors I get below:
Warning: fopen(/home/www/public_html/Travpho/wp-content/plugins/wp-csv-to-db/uploads/products.csv) [function.fopen]: failed to open stream: No such file or directory in /home2/shb12_114/travpho.com/public_html/Travpho/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 /home2/shb12_114/travpho.com/public_html/Travpho/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 /home2/shb12_114/travpho.com/public_html/Travpho/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51
then it repeats the two lines above many times.
FYI I did manage to populate the table by typing inserts with sql directly into the database, (I know a bit of sql), so treat this as a low priority and if you would like my help fix it please just let me know and I can keep trying to make it work
thanks again for your help
Rafael
November 22, 2010 at 1:03 am #26723amin007ParticipantI think your server only allows opening a file using relative URL. Try entering the following in the “Specify the file URL ” field then import it:
uploads/products.csv
November 22, 2010 at 1:34 am #26724rramirez125Membersame errors
Warning: fopen() [function.fopen]: Filename cannot be empty in /home2/shb12_114/travpho.com/public_html/Travpho/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 /home2/shb12_114/travpho.com/public_html/Travpho/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 /home2/shb12_114/travpho.com/public_html/Travpho/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 /home2/shb12_114/travpho.com/public_html/Travpho/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 /home2/shb12_114/travpho.com/public_html/Travpho/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 /home2/shb12_114/travpho.com/public_html/Travpho/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49
I am not sure if this will help but
I had a similar problem that got fixed as described in this note
https://support.tipsandtricks-hq.com/forums/topic/cant-download-file
November 23, 2010 at 12:47 am #26725amin007ParticipantIts actually not the same error as this time the error is the following:
Filename cannot be empty
So somehow the filename has not been saved in the “File URL” field.
Anyway, you got the data into your database so lets stop this investigation for now.
-
AuthorPosts
- You must be logged in to reply to this topic.