I have imported about 20 feeds and they all worked fine. However, two of my largest feeds (2 x 15MB CSV files) cannot import fully.
A trial import works and 10 products show up.
When I run the import, it takes a while then asks me to save the feed_import.php file (in Firefox) and IE reports Cannot find server.
My webhost will not let me tweak any php settings.
Plus, the MySql panel is a bit basic.
I can do manual entries into the database but am I right in saying that the CSV file needs to be parsed through magic parser before it can be entered into the database?
Any help / suggestions welcomed.
I do not have access to the command line as it is a shared server (unless there are a program I can download which will allow me to do this).
:-(
Hi,
It might be worth trying Putty, which you can get from here:
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
You will need to setup an SSH connection (I think the default is Telenet); and then try it with your hosting account username and pasword - you never know!
Let me know how you get on, there are some things that might help you import more products if you host is restricting execution time and is not prepared to remove the time limit on your account...
Cheers,
David.
Just tried using Putty but the firewall on the server won't let me access it.
The only php variables I am allowed to change include:
register_globals (currently off)
session.use_trans_sid (currently off)
session.gc_maxlifetime (currently 7000, option to change to 2000,3000,4000,5000,6000)
Are any of these likely to help?
Hi,
Unfortunately none of those variables will get around an imposed time limit by your host. There is an option to use a less strict parsing mechanism that I have developed to help other users out who are not able to run PHP scripts for an unlimited time. If you drop me an email (reply to your Price Tapestry reg. code email) I will send you the alternative version of MagicParser.php that might be able to import a 15MB feed within the time limit set by your host.
Please note that several users have been successful in asking their hosts to remove the time limit on their account, which they have done so in order to keep their business!
Cheers,
David.
Hi David I have the same problem. i can't import file bigger then 2-3MB. I have tried all solutions... with no result.
Can i have the alternative version of magicparser?
My mail is goldcave[]cheapnet.it
([]=@)
Let me know, i need it urgently
Thanks
Hi CSYS,
Can you drop me an email in reply to your Magic Parser or Price Tapestry registration code email and i'll send you the alternative version. Note that it is only for CSV files that it is faster - is it a CSV file that you are having the problem with?
Cheers,
David.
Hi,
Do you have Telnet or SSH access to your server?
If so, it is worth trying the command line import.php script as sometimes it is not subject to the same limitations as a PHP script invoked by the web server.
After logging in, issue the commands as follows (where $ is the command prompt on your server):
$cd /path/to/pricetapestry/scripts$php import.php <filename>
...where is the name of the feed you wish to import, having previously registered the feed via the admin interface.
Cheers,
David.