I have installed the import tool successfully but when I go to import, I get taken to a screen that says:
# Starting profile execution, please wait…
# Warning: Please don’t close window during importing/exporting data
and nothing happens. I checked my db and there has not been any changes.....
I did make the corrections to the files as posted in this thread.... hence my import tool seems to function to the point of doing what it is suppose to do......
Once i executed the import to begin I left my computer alone and did not close my browser. After 45 minutes there was no change on the screen or in my database.
Does anyone have any suggestions? I have about 2,000 products to import and desperately need this to work.
One more thing...... I only selected categories and products, not customers or orders..... I don’t have a need to import the customers or orders for this site..... just the product catalog.
many thanks to konez2k and others for sorting this
now my only sadness is for the time I spent trying to get it to work before I found this thread! - but I suppose at least that got me some way to understanding magento
Since this is core module - WHY OH WHY hasn’t it been updated so it works???
I have now got the tool to import the products and categories. The products cannot be seen in the front end, but that is properly just a matter of configuration.
My question is, have any of you succeeded in importing customers and orders?
When I run the import on customers and orders I get the same error I got when I first was importing products and categories, before making the changes. Can any of you help?
What did you do to get the cats and products to import? I have an oscommerce store with over 1,700 products… I really don’t think I can do that one at a time… been there and done that already lol… any advice, input, help would be great!
Before you import your oscommerce customers, you can disable all email in your backoffice : System/Configuration/System/SMTP Settings > Disable Email communication (set it to true)
Normally, your customer will not receive newsletter subscribing email and you keep your customer’s newsletter subscription
Sorry for my French English ^^
My install (1.3) says that those options are for windows servers only. I am a bit scared of sending emails that I have no idea about. I need to have them kept as subscribers. I’ll have to go through the code line by line. damn.
Rick
Evangelist and Programmer
<a href="http://racy.com">racy.com</a>
example@example.com cannot be saved because of Cannot save your subscription: Warning: call_user_func(Zend_Validate_Hostname_Com::getCharacters) first argument is expected to be a valid callback
try changing this in lib/Zend/Validate/Hostname.php aroung line 320.
REPLACE
/** * Match against IDN hostnames * @see Zend_Validate_Hostname_Interface */ $labelChars = 'a-z0-9'; $utf8 = false; $classFile = 'Zend/Validate/Hostname/' . ucfirst($this->_tld) . '.php'; if ($this->_validateIdn) { if (Zend_Loader::isReadable($classFile)) {
I am having problems as well. In my OSCommerce I have 426 products. I got the category import working, but it hangs on “Products processed 0% 0/426 records”.
Then after a while I get the error:
SKU Tieroom - 59 cannot be saved because of SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
I’m starting to work on this tool, but keep running into the same error all the time. This error also screws up the entire Magento installation. Maybe 1 of you can help me on this? I already did the investigation, but couldn’t find any usefull entries.
I am having problems as well. In my OSCommerce I have 426 products. I got the category import working, but it hangs on “Products processed 0% 0/426 records”.
Then after a while I get the error:
SKU Tieroom - 59 cannot be saved because of SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
Does anyone know how to fix this?
Best regards,
Paul Peelen
Nobody that can help with this? Really need some help, still havn’t fixed it.
