To enable a round-trip from export to import without any file format modifications, Products and Web-apps export now generate files in raw CSV format so they can be directly re-imported after you make modifications to the data only. A couple of caveats to be aware of:
The extension of the generated file is still ".xls" so that Excel will be the default application used to open the export file. However, if you open the file using a text editor such as UltraEdit, you will see the data conforms to the CSV RFC meaning that linebreaks within fields are allowed if the field is enclosed with a double quote "".
When saving the file in Excel you need to explicitly choose the Save As '.csv' format to ensure that Excel doesn't convert the file into a proprietary Microsoft format which can't be imported.
These changes have vastly improved the performance and reliability of Product and Web-app items export functionality.
A Content Management System (CMS) is a piece of serverside software that makes it easy to Create, Reveiw, Update, and Delete content on your website. Basically this means you can easily manage your website without specialist computer skills. Basic knowledge of a web browser and a single session with one of our qualified trainers is all that is required in or..
View all Tips
