Import parts

To import multiple colors automatically you can provide a file or manual input. You can even combine both methods.

Columns can be split by one of the following characters:

Comma ,
Semicolon ;
Colon :
Hash #
Star *
Tilde ~
Pipe |

You can use only one character per file / manual input. If you mix multiple characters only the first one will be used as delimiter and the others as normal characters.

Text columns can be wrapped in double quotes. This is needed if the delimiter character or double quote is used within the text. To add double quotes as text write two of them. Example: "This cell contains ""double quotes"""

If there is any problem in a line the line will be skipped.

Columns for this import:

Part number (text) *
LDraw ID (text)
Name (text)
Color (number)
Length (number or fraction)
Width (number or fraction)
Height (number or fraction)

* required columns

File

Contains header line

Assign columns

Assign columns from file to columns from above. To skip columns from file use 0.

Manual input

Import mode

Import all lines

Update only existing entries

Overwrite options for import / update

Ignore (no import at all)

Overwrite (replace original entry)

Update (write value if not empty in source)

Merge (write value only if empty in database)

Identify existing part by

Switch to element import

Back