Jump to content

osCommerce import problem.

aktur
 Share

Recommended Posts

aktur Newbie

aktur

Posted
Posted

Welcome everyone,

This is my first day playing with the PrestaShop 1.4. I'm trying to import my osCommerce web shop which I'm using for few years now. However, when I'm trying to import my osC database, after filling db details, default language, shop url and hiting next I'm getting the following error message: '2,the field symbool is invalid'. Yes, I get this with this spelling error in 'symbol'. Does anybody have any hints for me what does it mean and how can I fix it? I've already tried 3 different import options including skip and force. All them give the same error.

Kind regards,
Michal

Link to comment
Share on other sites
  • 3 weeks later...
akingston Newbie

akingston

Posted
Posted

Can anyone at all help with this? Or is there any documentation we can look at for this module?

The functionality to migrate from OsCommerce to Prestashop is (in theory) great but I see other posts where people are describing problems they are experiencing and they aren't getting any responses either. Can anybody even let us know if its some kind of version issue. The site I'm working with is OsCommerce 2.2-MS2.

It would be great if we could get some help just to at least point us in the right direction.

Thanks,
Andrew.

Link to comment
Share on other sites
devilsown Newbie

devilsown

Posted
Posted

are you using any weird ansi charctors in your password or db name? &*@#$ etc?
I get past the spot your at and get it to start importing. I just get errors.

I have 2 issues with the importer. I am using CREloaded so i expect some errors. My products don't want to import the images because all of mine are larger like 1024x800 it just errors out on me. Then orders don't import not sure why yet. I am sure its something in my CRE/oscommy db, since it does not filter db input i got someone with something funny in a filed like ~ above the e or o like used in foregn languages and prestshop not liking the way its entered or some i have 3 letters for a state or a letter in the phone number filed. Its not really a prestshop issue just that people put stuff in the wrong field and oscommerce let people do it.

Link to comment
Share on other sites
akingston Newbie

akingston

Posted
Posted

Thanks for the help guys.

I've managed to get past the original error now by changing all tables in the database to have a prefix, which they previously didn't. However I now get the following error:

TECHNICAL ERROR

Details: Fatal error : iso code is not correct :

Anyone got any ideas?

@devilsown - I'm not using any strange characters as far as I am aware. Although, that said I didn't build the osCommerce site and I'm not really that familiar with osCommerce so I'm not entirely sure what might be in there.

@tomerg3 - I appreciate the suggestion, and I had actually seen your plugin before, but given that this functionality is supposed to be included with Prestashop 1.4, I am a little reluctant to pay for it. Mind you if you were to guarantee me that I wasn't going to have any issues like these I would give it some more consideration.

Link to comment
Share on other sites
tomerg3 Apprentice

tomerg3

Posted
Posted

You should report the problems you are having on the bug report page, that would help the Prestashop team to fix the built in module.

The module on my shop is more mature and has worked for many many customers.

All the modules come with free support / installation help.

Link to comment
Share on other sites
tomerg3 Apprentice

tomerg3

Posted
Posted

I can guarantee that is there are any issues, I will help fix them (for free), and if I can't get it to work, you can have a refund.
This is also covered in the terms and conditions, and applies to any module from my store.

Link to comment
Share on other sites
  • 1 month later...
Milano2 Rookie

Milano2

Posted
Posted

osC importer works fine, but I have notice, that imported products from osCommerce to Prestashop now don't have short description, meta description and meta keywords. It is possible to fix this... or could someone tell me how to import first 160 characters from full description to short description and meta description? And how to import to meta keywords: product name, category and manufacturer?

Link to comment
Share on other sites
  • 2 weeks later...
nibbles Newbie

nibbles

Posted
Posted

I've come up against the same error.

While checking my (oscommerce) database in phpMyAdmin, I noticed that my database tables were all set to "Latin - Swedish"?

Not sure if this is what's causing the problem as I'm part way through sorting mine out now.
But I found a script to change all database tables back to the correct collation settings -

Copy the following into notepad, editing the USERNAME, DATABASE and PASSWORD values (These can be found in the configuration files in your oscommerce install)

<?php

// Configuration Section
$server = 'localhost'; //probably localhost but change if required
$username = 'USERNAME';
$password = 'PASSWORD';
$database = 'DATABASE';
$new_charset = 'utf8'; // change to the required character set - you're probably changing to utf8 ?
$new_collation = 'utf8_general_ci'; // change to the required collation - you're probably changing to utf8_general_ci ?

// Connect to database
$db = mysql_connect($server, $username, $password); if(!$db) die("Cannot connect to database server -".mysql_error());
$select_db = mysql_select_db($database); if (!$select_db) die("could not select $database: ".mysql_error());

// change database collation
mysql_query("ALTER DATABASE $database DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");

// Loop through all tables changing collation
$result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
$table = $tables[0];
mysql_query("ALTER TABLE $table DEFAULT CHARACTER SET $new_charset COLLATE $new_collation");

// loop through each column changing collation
$columns = mysql_query("SHOW FULL COLUMNS FROM $table where collation is not null");
while($cols = mysql_fetch_array($columns)) {
$column = $cols[0];
$type = $cols[1];
mysql_query("ALTER TABLE $table MODIFY $column $type CHARACTER SET $new_charset COLLATE $new_collation");
}

print "changed collation of $table to $new_collation
";
}
print '
The collation of your database has been successfully changed!
';
?>



Then save the file as change_collation.php and upload to the root of your server, then open it up in a browser (www.yourdomain.com/change_collation.php

Hope this helps someone else, if I find anything more - I'll post back

Link to comment
Share on other sites
  • 2 weeks later...
Nervosity Newbie

Nervosity

Posted
Posted

Dear Readers,

I came accross the same issue. What i did was the following:

In the filedirectory i went to: /modules/shopimperter/shopimporter.js

Open the file, go to line nr: 66 (around), now do the following:

if (jsonData.hasError)
{
    $('#steps').html('
'+jsonData.error+'');
    $('#currency_feedback').fadeIn('slow');
    onComplete(false);
} 
else



Uncomment the entire section. Then the test import will run and give you errors. I had errors on Currencies and countries or zones i thought. You can deselect them from the option list and the most tables will be imported.

Just a "quick and dirty" work arround to get some data imported.

Good luck,

Greetz Nervosity

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...