Call-back icon  Sales: Call 877.832.5289 (N America)|310.295.4144 (International)

Magento

eCommerce Software for Online Growth

Magento Forum

   
Import hanging at “Importing…”
 
flufftronix
Jr. Member
 
Avatar
Total Posts:  29
Joined:  2007-11-09
 

First I should say how excited and relieved I am that Magento is going so well. Every prior experience I’ve had with ecommerce has been pretty nightmarish and things are shaping up to be a lot different from now on!

But anyway, bug reporting: hopefully this is just me being impatient, but I just tried an import of just categories only. It’s been a little while and nothing seems to be happening. The site I’m importing from could very well be over the current size limitation.. does the extension currently report errors or does it just hang indefinitely if there’s a problem?

 
Magento Community Magento Community
Magento Community
Magento Community
 
flufftronix
Jr. Member
 
Avatar
Total Posts:  29
Joined:  2007-11-09
 

After a little bit of use, it seems there’s no “import successful” notification. So the problem I seem to be dealing with is that this extension apparently isn’t finding any products to import. Database shows ~1900 products.

By the way, the site has just about as many users (~1900) and they seem to have all imported properly. That’s a start at least smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
Matt Puchlerz
Jr. Member
 
Total Posts:  15
Joined:  2008-01-09
Lisle, IL
 

I’m getting the same problem.

After running the profile, I noticed that there is an AJAX response (thank you FireBug) that just doesn’t seem to be writing into the document; it says that there was an error:

SQLSTATE[HY000]General error1194 Table 'ref' is marked as crashed and should be repaired

If I try to view the oscommerce_ref table in the Magento database, I also get a similar error:

#1194 - Table 'oscommerce_ref' is marked as crashed and should be repaired

Apparently something is killing the table altogether. I do know that the osCommerce database I’m trying to pull from has been edited at some point, so I’m not sure if that’s the cause of the problem or not. I may try a fresh install of osCommerce to see if that imports correctly.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Matt Puchlerz
Jr. Member
 
Total Posts:  15
Joined:  2008-01-09
Lisle, IL
 

I was able to fix the trouble I was having with the customer import. On line 336 of /app/code/core/Mage/Oscommerce/Model/Mysql4/Oscommerce.php there is a reference to a variable-variable, that I believe was just a mistake:

$address $this->getAddresses($$customer['id']);

By duplicating the file in /app/code/local/Mage/Oscommerce/Model/Mysql4/Oscommerce.php and getting rid of the second dollar sign, the hanging import for customers was fixed:

$address $this->getAddresses($customer['id']);

I’m still trying to work out the others, as they are still crashing the oscommerce_ref table.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Matt Puchlerz
Jr. Member
 
Total Posts:  15
Joined:  2008-01-09
Lisle, IL
 

Here is some more detailed information regarding the crashed table:

mysql-sandbox [magento_1]check table oscommerce_ref;
+--------------------------+-------+----------+----------------------------------+
Table                    Op    Msg_type Msg_text                         |
+--------------------------+-------+----------+----------------------------------+
magento_1.oscommerce_ref check error    Found too long record (35at 36 
magento_1.oscommerce_ref check error    Corrupt                          
+--------------------------+-------+----------+----------------------------------+
2 rows in set (0.00 sec)

 
Magento Community Magento Community
Magento Community
Magento Community
 
piotrekkaminski
Magento Team
 
Avatar
Total Posts:  60
Joined:  2007-09-01
 

Please try the latest version. Make sure to backup first.

 
Magento Community Magento Community
Magento Community
Magento Community
 
zadpro
Sr. Member
 
Avatar
Total Posts:  108
Joined:  2007-12-10
FL, USA
 
piotrekkaminski - 17 May 2008 01:51 PM

Please try the latest version. Make sure to backup first.

I have the latest version 1.1.3. During the import process, It just freezes randomly. I was trying to import a list of 6094 products, 3-4 times it stopped at product 93-95. Then it stopped at 4900. I think this problem is still going on.

 Signature 

ZadPro.com

BargainCollection.com Powered by Magento

 
Magento Community Magento Community
Magento Community
Magento Community
 
Oldgamer
Member
 
Avatar
Total Posts:  59
Joined:  2008-09-12
 

I have the same products importing problem.
I use core 1.1.6.
At first I tried small files with 3-6 products and it was fine, except of that images was not shown and somehow checkboxes “exclude” were checked (but this is another problem). When I tried to import more records it just freeze randomly. I like Magento pretty much, but I can not start use it in production until problem will be solved. :(

 Signature 

Video games, video game consoles, kids education software

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
Sales: Call 877.832.5289 (North America) 310.295.4144 (International)
© Copyright 2008 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
53247 users|905 users currently online|107323 forum posts