Jluis Posted September 16, 2020 Share Posted September 16, 2020 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now