transfert CSV

[kri2sis]

Bonjour,
j'ai un prestashiote et je voudrais bien m'installé ici pour faire de bonne chose sur du bon Open source.
Néanmoins même si je m'héberge moi-même je ne touche pas tous les jours mon serveur.
J'ai donc la flemme de recopier mon stock (et surtout les descriptions de produits) et j'aimerais savoir, après avoir téléchargé ce petit truc : http://www.opencart.com/index.php?route=extension/extension/info&extension_id=17&filter_extension_type_id=8 où je devais l'installer ? dans quel répertoire pour qu'il devienne actif.

merci à vous

[LeorLindel]

Comme dans chaque module mis à disposition, un fichier texte (readme.txt) se trouve dans l'archive. Dans celui-ci se trouve généralement les instructions d'installation.

[kri2sis]

merci à toi

par contre non pas que je ne comprenne pas l'anglais mais... un rep admin j'en ai déjà et le rep system aussi ...

Export/Import Tool for OpenCart 1.5.0.x
=======================================

The Import/Export Tool allows the admin user to do a bulk
export

of all the categories, products, and product options to an Excel spreadsheet file.

The spreadsheet file can be edited offline and then be re-imported to the OpenCart database.



Requirements and Limitations
============================



1) This module only supports one front end language.


2) Memory requirements can be quite high.

For example, for a store that has 13,500 products and 300 categories:


XLS File Size: 9 to 10MB

Memory Usage Export: up to 13MB

Memory Usage Import: up to 355MB



Which works fine with the following PHP settings:


memory_limit 512M

post_max_size 16M

upload_max_filesize 16M

Not every shared web hosting account supports such a high process memory usage.


Therefore, if you use a basic shared web hosting account, no more than than a few thousands
products can be supported.
Use a more dedicated web hosting account if a higher number of
products are to be supported for the Export/Import module.


The high memory usage of the Import is due to the fact that the underlying PHPExcelReader parses
the whole file into
RAM memory first before being able to access the spreadsheet cells.


Installation
============





1) Upload the folders 'admin' and 'system' and their files
from the 'upload' directory to your OpenCart root directory.



2)
The following OpenCart core files need to be changed:

admin/controller/common/header.php
admin/language/english/common/header.
php
admin/view/template/common/header.tpl

If you have a pre-installed VQMod (Virtual Modifier) on your OpenCart system
then all you have to do is to upload the 'vqmod' folder and its files from the
'upload' directory to the OpenCart root directory.

VQMod is available from <http://vqmod.com/>

Alternatively, you can change the header files manually:

In file admin/controller/common/header.php find:
$this->data['text_backup'] = $this->language->get('text_backup');
Add the following after the found line:
$this->data['text_export'] = $this->language->get('text_export');

In file admin/controller/common/header.php find:
$this->data['backup'] = $this->url->link('tool/backup', 'token=' . $this->session->data['token'], 'SSL');
Add the following after the found line:
$this->data['export'] = $this->url->link('tool/export', 'token=' . $this->session->data['token'], 'SSL');

In file admin/language/english/common/header.php find:
$_['text_backup'] = 'Backup / Restore';
Add the folling after the found line:
$_['text_export'] = 'Export / Import';

In file admin/view/template/common/header.tpl find:

<li><a href="<?php echo $backup; ?>"><?php echo $text_backup; ?></a></li>

Add the following after the found line:
<li><a href="<?php echo $export; ?>"><?php echo $text_export; ?></a></li>





3)
Before using this newly installed Export/Import feature for the first time, you must set the
access rights for top administrator as follows:


In the admin interface, choose

System > Users > User Group

From there, select 'Top Administrator', then click on the 'Edit' link to the right.

This will open up an edit window with multichoice dropdown lists for 'Access' and 'Modify' rights.

In both of them, you'll see a new entry for 'tool/export' which you can select by clicking
on their check boxes.





Further help and customized versions
====================================

This tool has been successfully tested for
a standard OpenCart 1.5.0.x.
Don't use other Opencart versions with this module.

If you need a customized version of
the Export/Import Tool,
let us know and we can create one for a charge.

You can contact us at <http://www.mhccorp.com>