» Available only in Dotypos FULL and higher. « |
---|
If you edit custom file using the Excel application, you have to set the value of columns to Text and save the file. Otherwise, the file may not import back into Dotypos correctly or at all. The same applies to a text .csv file edited in Excel. Due to the behaviour of Excel, the format of the cells with numbers may change, which must then be edited before importing. Files exported from Dotypos Cloud already have the correct column formats set.
For importing/exporting data we recommend using Excel, working with this format is a bit easier than with pure text format .csv.
Export to Excel - How to edit an exported Excel file
1.Export and download data from Dotypos Cloud in Excel format.
2.Open the file and check the correct format of the columns with numbers - productId, categoryId, sortOrder and possibly others. Mark the columns with incorrectly displayed values and change the cell format to Text.
3.Edit the data and then save the file in the same format and import.
Export to CSV format - How to correctly import a CSV file into Excel
1.Export and download the data from Dotypos Cloud in CSV format.
2.Start Microsoft Excel.
3.Click the Data tab > From Text/CSV.
4.Select the .csv file you will edit in Excel.
5.In the dialog box that appears, keep the Windows 1250 encoding and comma separator. You can tell the correct encoding by the correct display of the diacritics in the preview.
6.In the dialog click the Transform Data button to display the source data table.
7.In the table click on the column headers for productId, categoryId, sortOrder, and any other columns that contain incorrectly transformed numbers (e.g., 4.13011E+15) and select Data Type: Text for each of the columns in the top panel on the Home tab.
8.In the Change Column Type dialog always click Replace Existing, the values in the columns will be converted to the correct number format.
9.After making the change in the top panel, click Close and Load.
10.Edit the displayed data in Excel and then save as a CSV (text file with separators).
11.Import the modified .csv file into Dotypos Cloud. Select Windows 1250 encoding when importing.
When editing, make sure that you: •when changing the price without VAT, delete the price with VAT and vice versa. This is the only way the program will be able to correctly calculate the second value, •do not have spaces before or after the values in the cells with numbers (codes). |