Spreadsheet Upload

Loading video please wait.

The Upload Spreadsheet function allows for the importing of data into the Component Manager.

The spreadsheet must be formatted correctly otherwise the data will not be imported. The easiest way to ensure the formatting is correct is to download a sample spreadsheet using the download spreadsheet button.

Column Headings

The first column in the spreadsheet must be the quick find code. If the quick find code is specified then the component will be updated, if the quick find code is blank then a new component will be created.

The information within the component has been grouped into the following groups

Products, States, Specification, Preview, DataSheet and Models

The column titles will be in the format

group#parameter

For example quick find code column will have the heading Products#QuickFind, The value for the off state would have the heading States#Off.

A component may have more than one preview image or data sheet. In this case the column heading will be in the format 

group#number#parameter

For example the address of the first preview image will be

Preview#1#Address 

The heading for the address of the second preview image will be

Preview#2#Address 

Spreadsheet Format

The spreadsheet should be in CSV format. With comma separated data, speech mark deliminators and line breaks at the end of each line. 

Spreadsheet Processing

After uploading the spreadsheet, the spreadsheet will be entered into a processing queue. This is because the spreadsheet may contain thousands of updates. Waiting for the processing to complete would cause the browser to time out. After the spreadsheet has been processed, the components that have been updated will be rebuilt. 

Specific Column Notes

Products#QuickFind

The first column must be the quick find code. If the code is specified then the component will be updated, if the code is blank then a new component will be created. The quick find code must be in the format XXXX-XXXX.

Products#Cat

Cat is the category number for the category in which the component belongs, changing this number will move the component between categories.

 Products#KeyWords

This is a comma separated list of key tag words. 

Product#Obsolete

This is a boolean marker for changing the obsolete status. 0 = not obsolete, 1 = obsolete

Product#Private

This is a integer marker for changing the visibility of the product. 0 = public, 1 = organisation.

Products#SubmitedDate

The date on which the component was entered into the Component Manager, in the format DD/MM/YYYY.

State#????

The values in the state field should be the consumption rate for the state name given in kw.

Preview#?#Address

The address of the image. The image can be in JPG, GIF or PNG format, we suggest that you use PNG. The address is a relative address.

Preview#?#Priority

This is an integer number which is used to set the order in which the images will be shown. The images will be shown in ascending order. 

Preview#?#Title

Each image can be given a title. The title will be used as the alternative text for the image.

Preview#?#Type

The type field is a integer column defining the type of preview. Currently 1 = image, in the future other types will be available. 

 DataSheet#?#Address

The address of the datasheet, we suggest the data sheets are uploaded in a easy to read format such as PDF, but the system can accept documents in other formats such as word documents, spreadsheets.

DataSheet#?#Local

This is an integer column for specifying where the data sheet is stored. 1 = local on the Eco3D server and the address should be relative. 0 = remote the address should be the absolute url to the document starting with http:// or https://.  

DataSheet#?#Priority

The data sheets will be ordered in ascending order based on the integer priority value.


Tags

upload, batch, mass, components, many


Open in new browser new tab