[[Apps] Tools Import Data]

The section that you suggested doesn't exist; this is the closest that I could find:

      while ($data = $QproductDescriptions->fetch_assoc()) {
        foreach ($clicshopping_languages as $languages) {

          echo $data['products_id'] . ' - ' . $data['products_name'] . '<br />';

          $sql_data_array = [
            'products_id' => (int)$data['products_id'],
            'language_id' => (int)$languages['languages_id'],
            'products_name' => $data['products_name'],
            'products_description' => $data['products_description'],
            'products_url' => $data['products_url'],
            'products_viewed ' => (int)$data['products_viewed'],
          ];

          // $this->db->save('products_description', $sql_data_array);
        }
      }

 

[[Apps] Tools Import Data]

Hi,

This is a fresh installation with no demo data loaded. (Was bad enough just to get the thing to run!)

Importing a single language (en).

There is no specific file for osCmax, even though it is listed in the dropdown. It'll try changing it in the Oscommerce.php file and select that one.

 

[[Apps] Tools Import Data]

I'm trying to import a database from osCmax using this addon but it gets stuck almost immediately.

Quote

The migration is in progress, please wait

Oscommerce

table_languages

Item number : 1

No item to import, exist inside db : en

table_products_description

number_of_products : 28

663 - TEN Gel 3pk

It (at least) reads the first product (with a description) from the 'old' database but doesn't continue.

 

[29-Oct-2020 17:44:44 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in /home/clic/public_html/shop/includes/ClicShopping/OM/DbStatement.php:136
Stack trace:
#0 /home/clic/public_html/shop/includes/ClicShopping/OM/DbStatement.php(136): PDOStatement->execute(NULL)
#1 /home/clic/public_html/shop/includes/ClicShopping/OM/Db.php(374): ClicShopping\OM\DbStatement->execute()
#2 /home/clic/public_html/shop/includes/Module/Hooks/ClicShoppingAdmin/ImportDatabase/Oscommerce.php(117): ClicShopping\OM\Db->save(':table_products...', Array)
#3 /home/clic/public_html/shop/includes/ClicShopping/OM/Hooks.php(63): ClicShopping\OM\Module\Hooks\ClicShoppingAdmin\ImportDatabase\Oscommerce->execute(NULL)
#4 /home/clic/public_html/shop/includes/ClicShopping/Apps/Tools/ImportData/Sites/ClicShoppingAdmin/Pages/Home/templates/import_process.php(80): ClicShopping\OM\Hooks->call('ImportDatabase', 'Oscommerce')
#5 /home/clic/public_html/shop/ClicShoppingAdmin/index.php(41): include('/home/clic/publ...')
#6 {main}
  in /home/clic/public_html/shop/includes/ClicShopping/OM/DbStatement.php on line 136

I've tried adding and deleting database tables prefix (something I don't normally use), in case that was the cause of "Invalid parameter" - that didn't help.

 

Note: the installation instructions are not clear at all. I uploaded the images & includes directories to shop. I then added the apps_tools_import_data.json from ModuleInfosJson to ClicShopping/Work/Cache/Github. Is this correct?