Export Database

Video tutorial on this topic: 8: Exporting the database

 

You can export your database (products, accessories, materials) as a spreadsheet and also include your item image files in the export.

Exporting your database serves the following main purposes:

• Create a full backup of your database. We strongly advise doing regular backups so you can recover your database in case you have accidentally cleared it or deleted items.
• Create a template file in the correct format and Batch Import Database Items from a spreadsheet. We strongly advise performing this step before your first batch import.
• Create a spreadsheet with your current database items to resynchronize in your spreadsheet editor any database changes made within Database Editor.

There are two commands to export your database:

Export L exports the list of all your materials, products and accessories including their properties, from your PlanogramBuilder Database to your computer. Use this command to create a template file for batch importing items, or to resynchronize items when you don’t need to backup the item images.

Export L+I does the same and also exports all images stored in the database. Use this command to create a full backup of your database, or to resynchronize items when you need to also backup the item images.

 

The exported item list can be either in Microsoft Excel format (*.xls or *.xlsx), or in Unicode Text format (*.txt), compatible with any Spreadsheet application.

The exported images are in the same format as they were originally uploaded.

Follow these steps to export your product database:

1. In Database Editor, click on the Export L or Export L+I button.
2. You will be prompted to select a folder in which to save the files and to type a filename for the list of products. We strongly advise to select an empty folder or to create a new folder, so that your exported files won’t get mixed-up with other existing files on your computer.
3. Once you have selected a folder, chosen the file type and typed a filename, click on the Save button.
4. Wait for all the files to be downloaded onto your computer. The first file to be exported is the listing of items, which is very fast to download, then the images if you chose Export L+I.

Tip: you can abort the export process by simply clicking on the Export button once again during the export process.

Tip: We advise choosing the *.xls or *.xlsx format. Otherwise if you select the *.txt format, a number sign [#] is automatically added in the exported txt file as a prefix to all item References that start with a [0] or that are large numbers (more than 11 digits). This convention is a work-around to display these numbers correctly if you open the exported list in Excel, which doesn’t support long numbers.

Note: The images are saved in a new folder named Images (or an equivalent translation if PlanogramBuilder is set to another language than English). Images can take a long time to export depending on the number of images, their size and the speed of your Internet connection.

Note: The dimensions of your items (width, depth and height) are exported in the current active measurement unit. Please see Measurement unit for details on setting this preference.