redSHOP:Importing and Exporting CSV Files tutorial

From redWIKI
Jump to: navigation, search

In this tutorial we will teach you how: - Export data from redSHOP into a .csv format - Edit the unicode data file (.csv) with Excel, Open Office or Libre Office. - Send back the data to redSHOP without avoiding wrong characters issue.

Important note: If you have ever experienced problems in characters codification (è, ą, ś,ć,ż ) this is due to a wrong importing procedure. When importing .csv files the way to avoid issues is to use "UTF8 encoding" instead of open it directly the .csv file.

Contents

How to: Import a .csv file into EXCEL with with UTF8 Option (Step by step)

Step 1

- Select “Data” tab

- Click “From Text” button

- Choose CSV file

- Click “Import” button

1 Import csv file into excel with utf8 encoding html.png


Step 2

Check “Delimited” so you can choose separator you typed when file exported from redshop

Select “File origin”: Unicode (UTF-8) - encoding of the csv file


2 Import csv file into excel with utf8 encoding html.png


Step 3

Choose the separator you typed when you exported file (it is comma in this case)

Click “Next”

3 Import csv file into excel with utf8 encoding html.png



Step 4

Click “Finish”

4 Import csv file into excel with utf8 encoding html.png


Step 5

Click “OK” and we see the imported file

5 Import csv file into excel with utf8 encoding html.png


Step 6

Finally you can edit, save and import it back to redSHOP.

6 Import csv file into excel with utf8 encoding html.png

How to: Import a .csv file into LIBRE OFFICE / OPEN OFFICE with with UTF8 Option (Step by step)

Step 1

- Click on "File -> Open" and select the "product.csv files that you have exported from redSHOP - It will appear a new window, make sure that codification is set as "Unicode UTF8"

1-Import csv file into libreoffice with utf8 encoding html.png

Step 2

If you see at the bottom of the screen the preview looking wrong, that may be caused because the Separator options is not well setted.

2-Import csv file into libreoffice with utf8 encoding html.png

Test the different separators until you get the right preview of data. In the next image, the right "separator" is "TAB":

3-Import csv file into libreoffice with utf8 encoding html.png

Now you should be able to import all the data without issues. "Edit" it as you wish, "save" it as .csv and upload it back to redSHOP.

Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox