Aller au contenu principal Aide Panneau de contrôle

actupro - actualités

Accueil Le blog

Migration OSCommerce vers Prestashop

Dans une migration d'un logiciel e-commerce vers un autre, l'une des phases importantes est la reprise des données. J'ai choisi de la faire avec l'ETL Talend

Talend Open Studio est un ETL puissant et libre qui permet de traiter des données, de les transformer et de les intégrer dans n'importe quel environnement.

Dans mon travail précédent j'ai eu l'ocasion de travailler avec son équivalent Datastage. La transition n'a pas été trop difficile mais une pratique régulière m'aurait fait gagner du temps.

Pour migrer une boutique OSCommerce ou plutôt OSCSS vers Prestashop le plus difficile reste de connaître les subtilités du modèle de données de Prestashop. Et là ce n'est pas simple du tout. Je n'ai pas trouvé de documentation expliquant ce modèle et le code source est très mal documenté. A ce jour j'ai encore des zones d'ombre.

L'avantage de Talend réside aussi dans sa rapidité de traitement.

Les Jobs Talend

J'ai découpé mon traitement en plusieurs jobs

  1. les produits et les attributs
  2. les clients
  3. les commandes et factures

Les images sont traitées par un petit script php

Au cours de l'été je vais revenir sur les différents traitements Talend plus en détail. Voici déjà un aperçu en image du traitement sur les produits.


Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 395

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Item has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 3109

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Source has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 5725

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Author has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 6276

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Category has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 6333

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Enclosure has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 6390

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Caption has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 7345

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Credit has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 7430

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Copyright has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 7487

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Rating has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 7530

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Restriction has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 7573

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_File has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 7633

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_HTTP_Parser has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 7867

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_gzdecode has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 8297

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Cache has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 8602

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Cache_File has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 8638

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Cache_MySQL has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 8799

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Decode_HTML_Entities has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 11371

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_IRI has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 11573

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Parse_Date has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 12526

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Content_Type_Sniffer has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 13463

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_XML_Declaration_Parser has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 13739

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; SimplePie_Locator has a deprecated constructor in /home/sc1actupro2s/actuproinfo/included/simplepie.inc on line 14051