[Réglé] Le bouton importer (Produits CSV)

  • Posts: 157
  • Thank you received: 18
11 years 9 months ago #88776

Bonjour,
La honte m'envahit mais je ne trouve pas la fonction importer pour les produits :blush:
J'arrive à exporter sans souci avec le bouton exporter.
Je modifie mes fichiers pour faire des tests d'import mais je ne vois pas de bouton "importer" à l'instar du bouton "exporter" dans hikashop> produits, vu notamment sur des screenshots mais impossible d'attraper cette interface.
Peux être faut il passer par le phpmyadmin ? Mais j'ai lu qu'il y'a une fonction d'import dans la partie gestion des produits.
Merci d'avance...

Last edit: 11 years 9 months ago by Bill D..

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13376
  • MODERATOR
11 years 9 months ago #88894

Bonjour,

Dans votre menu HikaShop, Importer est un sous menu du menu Produits:
www.hikashop.com/media/doc/tuto_content_options_module_menu.png
C'est le menu juste en dessous du titre de la page.

Please Log in or Create an account to join the conversation.

  • Posts: 157
  • Thank you received: 18
11 years 9 months ago #88909

:S Désolé je ne trouve pas...
Même en essayant de transposer à la version pour joomla 3.0
Je suis un peu perdu sur cet import :(

composant>hikashop>produits


composant>hikashop>configuration générale

composant>hikashop


Je n'arrive pas à attraper quelque chose approchant votre capture jointe...

Attachments:
Last edit: 11 years 9 months ago by Bill D..

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 9 months ago #88978

Bonjour,

Votre menu est défaillant, l'import se trouve à ce niveau:



Il se trouve normalement ici:


Pouvez vous activer le mode debug de Joomla et le error reporting au maximum pour voir d'ou vient ce problème de menu ?
Ou simplement essayer de ré-installer HikaShop.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 157
  • Thank you received: 18
11 years 9 months ago #89037

Ah ok...
Alors j'ai réessayé de réinstaller le com_ par dessus, mais comme ça ne fonctionne pas j'ai supprimer manuellement les com_hikashop, mod_hikashop et plg_hikashop.
Et installé la dernière version datée de ce jour. Même souci, le menu n'apparaît pas. Je ne suis pas sur que ce soit bien ré-installé, j'ai des titres "informatiques" style HIKA_WAITLIST ou VOTE_AND_COMMENT...
Je vous mets le rapport de débogage de joomla.
J'ai aussi activé le error reporting dans le php.ini mais je n'ai aucune idée où se trouve le résultat, je regarderai demain =)

Console de débogage Joomla!
Session
__default
session.counter ⇒ 34
session.timer.start ⇒ 1360262606
session.timer.last ⇒ 1360263789
session.timer.now ⇒ 1360263926
session.client.browser ⇒ Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0
registry ⇒ {"application":{"lang":""},"com_installer":{"message":"","extension_message":"","redirect_url":null},"com_hikashop":{"product":{"limitstart":0,"filter_id":"17"}}}
user
session.token ⇒ fcc03734c1e630fbcf732cff90d2062f
Profil d'information
Occupation de la mémoire
10.53 MB (11,036,692 Bytes)
Requêtes de base de données
30 requêtes exécutées

SELECT `data`
FROM `gajz9_session`
WHERE `session_id` = '8u0vji4vusb4lkev04kdjumqi1'
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM gajz9_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT template, s.params
FROM gajz9_template_styles as s
LEFT JOIN gajz9_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = '1'
ORDER BY home
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM gajz9_hikashop_config
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT a.id
FROM gajz9_user_usergroup_map AS map
LEFT JOIN gajz9_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 107
SELECT *
FROM gajz9_hikashop_widget
WHERE widget_published=1
AND (widget_access = 'all' OR widget_access LIKE '%,8,%')
ORDER BY widget_ordering ASC
SELECT b.*,a.*
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_user AS b
ON a.order_user_id=b.user_id
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
ORDER BY a.order_created DESC
LIMIT 7
SELECT category_id
FROM gajz9_hikashop_category
WHERE category_type='root'
LIMIT 1
SELECT category_id
FROM gajz9_hikashop_category
WHERE category_parent_id=1
AND category_type='status'
LIMIT 1
SELECT a.*
FROM gajz9_hikashop_category AS a
WHERE a.category_parent_id = 4
ORDER BY category_ordering ASC
LIMIT 0, 500
SHOW TABLES LIKE 'gajz9_falang_content'
SELECT lang_id as id, lang_code as code, image as shortcode, published as active
FROM gajz9_languages
WHERE published=1
SELECT *
FROM gajz9_falang_content AS b
WHERE b.reference_id IN (5,6,7,8,9)
AND b.reference_table='hikashop_category'
AND b.reference_field='category_name'
AND b.published=1
AND b.language_id=2
SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(a.order_created AS SIGNED )+0),'%Y %j') AS calculated_date, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id
FROM gajz9_hikashop_order AS a
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
GROUP BY calculated_date, currency_id
ORDER BY calculated_date DESC
SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
GROUP BY a.order_currency_id
SELECT *
FROM gajz9_hikashop_currency
WHERE currency_id IN (1)
SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity
FROM gajz9_hikashop_order_product AS prod
LEFT JOIN gajz9_hikashop_order AS a
on a.order_id=prod.order_id
WHERE a.order_created > 1328727926
AND a.order_created < 1360263926
AND a.order_status IN ('confirmed','shipped')
GROUP BY prod.order_product_name
ORDER BY Total DESC
LIMIT 1
SELECT u.name
FROM gajz9_hikashop_order AS o
LEFT JOIN gajz9_hikashop_user as hu
ON o.order_user_id=hu.user_id
LEFT JOIN gajz9_users as u
ON u.id=hu.user_cms_id
ORDER BY o.order_created ASC
LIMIT 1
SELECT COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
WHERE a.order_type='sale'
AND a.order_status IN ('created','confirmed')
AND a.order_created > 1360191600
AND a.order_created < 1360263926
GROUP BY a.order_currency_id
SELECT *, SUM(order_product_quantity) as Total
FROM gajz9_hikashop_order as a
LEFT JOIN gajz9_hikashop_order_product as prod
ON a.order_id=prod.order_id
LEFT JOIN gajz9_hikashop_product AS p
ON p.product_id=prod.product_id
LEFT JOIN gajz9_hikashop_product_category as cat
ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id
LEFT JOIN gajz9_hikashop_category as c
ON cat.category_id=c.category_id
WHERE a.order_created > 1359659126
AND a.order_created < 1360263926
GROUP BY c.category_id
ORDER BY Total DESC
LIMIT 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gajz9_modules AS m
LEFT JOIN gajz9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gajz9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-02-07 19:05:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-02-07 19:05:26')
AND m.access IN (1,1,2,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT COUNT(*)
FROM gajz9_messages
WHERE state = 0
AND user_id_to = 107
SELECT COUNT(session_id)
FROM gajz9_session
WHERE guest = 0
AND client_id = 1
SELECT COUNT(session_id)
FROM gajz9_session
WHERE guest = 0
AND client_id = 0
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM gajz9_menu_types AS a
LEFT JOIN gajz9_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN gajz9_languages AS l
ON l.lang_code = language
WHERE (b.client_id = 0 OR b.client_id IS NULL)
GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM gajz9_menu AS m
LEFT JOIN gajz9_extensions AS e
ON m.component_id = e.extension_id
WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1
ORDER BY m.lft
UPDATE `gajz9_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:34;s:19:\"session.timer.start\";i:1360262606;s:18:\"session.timer.last\";i:1360263789;s:17:\"session.timer.now\";i:1360263926;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"17\";}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"107\";s:4:\"name\";s:17:\"Super Utilisateur\";s:8:\"username\";s:7:\"william\";s:5:\"email\";s:26:\"contact@monsite.com\";s:8:\"password\";s:65:\"daf56d8902229b866748e4ce630e7c1c:LeWMX5h6uwB9aqRGddlvGFLaNER2ZRtS\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-12-06 15:35:52\";s:13:\"lastvisitDate\";s:19:\"2013-02-07 18:43:26\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fcc03734c1e630fbcf732cff90d2062f\";}' , `time` = '1360263926'
WHERE `session_id` = '8u0vji4vusb4lkev04kdjumqi1'

26 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :

3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
2 × SELECT COUNT(session_id)
FROM gajz9_session
2 × SELECT category_id
FROM gajz9_hikashop_category
1 × SELECT COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
1 × SELECT u.name
FROM gajz9_hikashop_order AS o
LEFT JOIN gajz9_hikashop_user as hu
ON o.order_user_id=hu.user_id
LEFT JOIN gajz9_users as u
ON u.id=hu.user_cms_id
1 × SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity
FROM gajz9_hikashop_order_product AS prod
LEFT JOIN gajz9_hikashop_order AS a
on a.order_id=prod.order_id
1 × SELECT *
FROM gajz9_hikashop_currency
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gajz9_modules AS m
LEFT JOIN gajz9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gajz9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM gajz9_menu AS m
LEFT JOIN gajz9_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM gajz9_menu_types AS a
LEFT JOIN gajz9_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN gajz9_languages AS l
ON l.lang_code = language
1 × SELECT COUNT(*)
FROM gajz9_messages
1 × SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
1 × SELECT *, SUM(order_product_quantity) as Total
FROM gajz9_hikashop_order as a
LEFT JOIN gajz9_hikashop_order_product as prod
ON a.order_id=prod.order_id
LEFT JOIN gajz9_hikashop_product AS p
ON p.product_id=prod.product_id
LEFT JOIN gajz9_hikashop_product_category as cat
ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id
LEFT JOIN gajz9_hikashop_category as c
ON cat.category_id=c.category_id
1 × SELECT *
FROM gajz9_falang_content AS b
1 × SELECT a.id
FROM gajz9_user_usergroup_map AS map
LEFT JOIN gajz9_usergroups AS a
ON a.id = map.group_id
1 × SELECT *
FROM gajz9_hikashop_confi
1 × SELECT template, s.params
FROM gajz9_template_styles as s
LEFT JOIN gajz9_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
1 × SELECT folder AS type, element AS name, params
FROM gajz9_extensions
1 × SELECT *
FROM gajz9_hikashop_widget
1 × SELECT b.*,a.*
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_user AS b
ON a.order_user_id=b.user_id
1 × SELECT `data`
FROM `gajz9_session`
1 × SELECT lang_id as id, lang_code as code, image as shortcode, published as active
FROM gajz9_languages
1 × SELECT a.*
FROM gajz9_hikashop_category AS a
1 × SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(a.order_created AS SIGNED )+0),'%Y %j') AS calculated_date, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id
FROM gajz9_hikashop_order AS a

Autres tables :

1 × UPDATE `gajz9_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:34;s:19:\"session.timer.start\";i:1360262606;s:18:\"session.timer.last\";i:1360263789;s:17:\"session.timer.now\";i:1360263926;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"17\";}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"107\";s:4:\"name\";s:17:\"Super Utilisateur\";s:8:\"username\";s:7:\"william\";s:5:\"email\";s:26:\"contact@universmineral.com\";s:8:\"password\";s:65:\"daf56d8902229b866748e4ce630e7c1c:LeWMX5h6uwB9aqRGddlvGFLaNER2ZRtS\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-12-06 15:35:52\";s:13:\"lastvisitDate\";s:19:\"2013-02-07 18:43:26\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fcc03734c1e630fbcf732cff90d2062f\";}' , `time` = '1360263926'
1 × SHOW TABLES LIKE 'gajz9_falang_content


Bon courage pour le décriptage ...
A bientôt

Last edit: 11 years 9 months ago by Bill D..

Please Log in or Create an account to join the conversation.

  • Posts: 157
  • Thank you received: 18
11 years 9 months ago #89075

Bonjour,
La nuit portant conseil j'avais souvenir d'une histoire avec un changement de position de menu qui pouvait engendrer différents bugs...
Alors j'ai fais composants> Hikashop> Configuration générale puis "onglet" Affichage et position du menu à "au dessus de l'aire proncipale".



Je me retrouve donc bien avec le menu contenant l'import dans la page produit, même s'il y a beaucoup de "slash" / et quelques décalages.



Je reviens vers vous si j'éprouve d'autres difficultés...
Merci.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 157
  • Thank you received: 18
11 years 9 months ago #89110

Mais du coup en frontend j'ai des / partout dans les déclarations automatiques d'hikashop.


\45,00 € \ l\'unité\\
\s) produits en stock\

\Total\ \45,00 € \


EDIT : J'ai fais une réinstallation complète de joomla, en fait c'était un souci avec les magic quotes. Il fallait redémarrer le serveur.
J'ai garder la version hikashop d'avant celle du 7 février. Ca fonctionne.

Last edit: 11 years 9 months ago by Bill D..

Please Log in or Create an account to join the conversation.

Time to create page: 0.090 seconds
Powered by Kunena Forum