Error importing csv file for bulk upload

[rramirez125]

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

[amin007]

Here 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:

http://www.tipsandtricks-hq.com/wp-csv-to-database-plugin-import-excel-file-content-into-wordpress-database-2116

[rramirez125]

Thank you !!! I will try it out and let you know how it goes

[rramirez125]

I 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

[amin007]

I 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

[rramirez125]

same 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

[amin007]

Its 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.

[Author]

Posts