Jump to content

Gestionnaire sql export produit erreur délimiteur


Recommended Posts

Salut , 
j'ai fait une export csv depuis le gestionnaire du back office  prestashop 1.7.5.2 . l'overture du fichier csv avec Excel est mal affiché . 
En fait certains colonnes contienent des ";" dans leur contenu .
comment ignorer le ";" dans le contenu des colonnes pour avoir un bon affichage ?
Une idée
 

SELECT    `fp`.`id_product`                                                       AS 'ID', 
          p.reference                                                             AS 'SKU', 
          pl.NAME                                                                 AS 'Titre', 
          manu.NAME                                                               AS 'Marque', 
          pl.description_short                                                    AS 'Description courte',
          pl.description                                                          AS 'Description longue',
          group_concat(DISTINCT(concat(fl.`NAME`,':',fvl.`value`)) separator ",") AS `features`
FROM      ps_product p 
LEFT JOIN ps_product_lang pl 
ON       ( 
                    p.id_product = pl.id_product ) 
LEFT JOIN ps_manufacturer manu 
ON       ( 
                    manu.id_manufacturer = p.id_manufacturer ) 
LEFT JOIN ps_feature_product fp 
ON       ( 
                    fp.id_product = p.id_product ) 
LEFT JOIN ps_feature_lang fl 
ON       ( 
                    fl.id_feature = fp.id_feature AND fl.id_lang = 1 ) 
LEFT JOIN ps_feature_value_lang fvl 
ON        ( 
                    fvl.id_feature_value = fp.id_feature_value ) 
GROUP BY  `fp`.`id_product` 
ORDER BY  `fp`.`id_product` ASC

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...