Magento

I am using this module to import data from zencart. I recognize that this module was written for OSCommerce, but the stores share common core tables and other people have had success using this module with zencart.

My problem is that my zencart database tables are currently prefixed with zen_. I configured osCommerce Profile correctly enough to be authenticated by the database, but upon trying ‘Run Profile’ I am getting the message

I have unsuccessfully tried with and without setting the ‘prefix’ option to ‘zen_’. It appears to me that the prefix field is not currently being referenced by the osCommerce Migration Tool (Mage_Oscommerce v1.0.19700).  I have verified that the table ‘brass5_brasslinepro.zen_languages’ exists.

Any ideas? Thanks!

I just edited my original database sql file to remove the ‘zen_’ prefixes and imported the file into a new database. Mage_Oscommerce found the language table in this new database.

So it does appear that the prefix field is non-operational in Mage_Oscommerce v1.0.19700.

I have no idea what you responded to your last post there, refreind - but i would appreciate if you can provide us step by step instructions on how to came to resolve this issue!  I have spent hours trying to look for an answer , but in vain . All i see are comments about changing some table name of I dont know , the source or the destination to removing prefixes - where infact I dont even notice any prefixes in the first place :s

Please help!!!!

I am having an identical problem with the same error, without db prefixes.

We are using the most up-to-date versions of all Magento files, php5.6, and mysql 4.

There is no answer to this question, on the internet, anywhere. We feel that the program may be directed at the wrong database to look for the languages table.

Looking forward to a solution.

I can also confirm this error. I’ve got two databases running, which are accessed by one Mysql user. DB1 is my magento database, db2 contains the oscommerce-data which should be imported. However, the error-message seems to say that the importer is currently looking for a certain table in db1 while it should really look at db2. Also looking forward to a solution here.

any news on that? same error here..
easiest solution is to install the magemto tables with prefix and then add the osc tables in the same database. then there is no conflict and it works fine. it seems that the data you can save is totaly needless.

hello,

is there a solution yet? this problem still seems to be around.
i am just experiencing it with the oscommerce-import extension.

Another person with the same problem right here.. doesn’t look like a solution to this is being found.

Chris

Well, there is a solution to go forward from that .languages problem - goto your PHP/MYSql database for oscommerce, goto the lanuages table of it, export that table in SQL query, and copy it in the magento mysql database. The .languages error will NOT appear anymore.

But I have gone as far as that, just to discover yet another problem, ie - tax_id not found in the field list. Looked around everywhere for a solution on this, but nothing yet. Everyone who is seeing this message, please keep us posted with any solutions or workarounds for this, I bet we will all appreciate it.

I am not certain, but it crossed my mind, is there a SPECIFIC version of OSCOMMERCE that would work flawlessly? Is there a way to covert data from oscommerce such as Excel CMV, the same format that we can export over to Magento? I personally have over 2000 entries to make and its gonna be a pain if I had to do them all manually.

Keep us posted, it only takes a minute of your time.