Try the Demo

Magento Forum

   
Import all products ERROR - please help
 
ewule1
Jr. Member
 
Total Posts:  1
Joined:  2012-07-05
 

Hi

Im using magento 1.7 .. i was trying to import a spreadsheet of about 3000 products. I had used opeoffice to save it in csv (utf-8) format.
The first time i tried, the magento import process froze, stopping at line 1080 of the spreadsheet. So i followed the advice in a post online, to spread the product list into 3 spreadsheets (each with about a thousand products). i started the import but this time the import window opened but stayed at 0 without counting up.  ..and afterward, the frontend showed the error message below.  I have read a lot of posts here while seeking a solution but no luck.
please advice

error message -----------------------------

There has been an error processing your request

SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user ‘ufos_722628_0001’@’linweb9.atlas.pipex.net’ for table ‘log_visitor’

Trace:
#0 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `lo...’, Array)
#4 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `lo...’, Array)
#5 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `lo...’, Array)
#6 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert(’log_visitor’, Array)
#7 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor))
#8 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Log/Model/Visitor.php(167): Mage_Core_Model_Abstract->save()
#9 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(1338): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#10 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), ‘initByRequest’, Object(Varien_Event_Observer))
#11 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#12 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(528): Mage::dispatchEvent(’controller_acti...’, Array)
#13 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Front/Action.php(64): Mage_Core_Controller_Varien_Action->preDispatch()
#14 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(408): Mage_Core_Controller_Front_Action->preDispatch()
#15 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#16 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#18 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#19 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/index.php(87): Mage::run(’’, ‘store’)
#20 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Store_Manager
Guru
 
Avatar
Total Posts:  679
Joined:  2012-07-09
 

Hi!
If you need to import in bulk great numbers of products, and you cannot do it online, I can offer you to try Store Manager for Magento with Bridge connection.  It has no limitations in the number of products you want to upload to your site, so there is no need for you to separate your .csv file into the smaller parts and it can be done locally and changes can be synchronized afterwards.

You can check trial version of the software - http://www.magentocommerce.com/magento-connect/store-manager-for-magento.html
Trial version has the same functionality as full version, so you can experience all the features it possesses.
In any case you can try it and then post your experience here.

 Signature 

Try out easy-to-use Magento Import/Export tool. A fully-functional 14-day free version of Store Manager for Magento is available for download here:
http://www.mag-manager.com/magento-import

Watch our new video on how to create Magento configurable products:
http://www.youtube.com/watch?v=KcHEV9ov8xg

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top