To create many products at once, fill in an import template in Excel and drop it onto the product list. You check every row before Triark EDM creates anything. You fix errors in the import window and import the rows that are ready. The import only creates new products. It does not change products that already exist.
Note: Products are part of the Product add-on, which is sold separately. An import into the product library also needs the Product library add-on.
Before you start
- Turn on edit mode (the switch top right, or F2). Triark EDM refuses the import when edit mode is off.
- You need the right to create products in the projects you import into.
- Select the projects you import into in the Working on: filter above the list. The import only accepts projects that are in the filter.
- Keep the file as an Excel workbook (
.xlsx). You cannot import CSV files. Save older formats such as.xlsas.xlsxfirst.
Import products into a project
- Click Products in the left menu.
- Right-click the list.
- Choose Import → Download template.
- Fill in one row per product. The required columns are in bold: Project Number, Product Number and Product Description. Remove the columns you do not need, or leave them empty.
- Drag the file onto the product list, or right-click the list and choose Import → From file.
- The Product import window lists every row. Fix the cells shown in red (see below).
- Tick the rows you want to import.
- Click Import.
To stop along the way, click Stop. Triark EDM finishes the row that it is importing, and the rest wait until you click Import again.
The columns
| Column | What to enter |
|---|---|
| Project Number | The project the product belongs to. Required. |
| Product Number | Must be unique in the project. Required. |
| Product Description | Required. |
| Parent | The product number of the parent product, in the same project. The parent can already exist, or be another row in the file. That row is then created first. |
| Product Category | The category as a path from the top, with | between the levels, for example Pumps | Feed pumps. Separate several paths with commas. |
| Product Status | Must be a status the product's categories allow. |
| Product Status Description | Needs a Product Status. |
| Access Tags | The project's access tags, separated by ;. Only with the Custom access control add-on. Otherwise leave the column empty. |
| Unit | At most 10 characters. |
| Quantity | A whole number. |
| Product Required Date to Documentation Received Date | The eight delivery dates. See Delivery. |
The template also has columns for Tag Number, Purpose, Delivery Location, Purchase Order, Purchase Package, Supplier Item Number, Stock Location, Pallet and Information. Many column headers in the template have a note that explains what to enter.
Tip: Enter dates as DD.MM.YYYY in cells formatted as dates. Do not change the cell format. A date typed as text is the most common reason a row fails.
Fix rows in the import window
- A cell in red has an error. Hover over the cell to see why.
- Click a cell to change the value. Lists such as categories and statuses filter as you type.
- You can also fix the file in Excel and drop it again.
- If you tick a product whose parent is a row in the file, Triark EDM imports the parent too. The window shows how many parents Triark EDM adds.
Triark EDM does not save the changes in the import window in your file. Click Export corrected file to save the rows as they are now, with your changes. The exported file does not include formulas, formatting, or rows and sheets hidden in Excel. If you close the window with changes that have not been imported, you can choose Export & close, Discard or Cancel.
After the import
Each row shows the result:
- Imported: Triark EDM created the product.
- Failed: Triark EDM created nothing. Fix the row and import it again.
- Partially imported: Triark EDM created the product, but a later step failed, for example its status in the product library. Finish the product in the product list.
Triark EDM does not import a row if its parent in the file failed. The new products appear in the product list.
Common errors
| Error | What to do |
|---|---|
| The number already exists, or is in the file more than once | Product numbers are unique in a project. Use another number, or remove the row if the product already exists. |
| The number is taken, perhaps by a product you cannot see | The number is used by a product your access does not let you see. Use another number. |
| The parent is neither in the file nor an existing record | Check the parent's product number, and that it is in the same project. |
| The category or status is invalid or no longer in use | Pick a category or status from the list. The status must be allowed in the product's categories. |
| You cannot create products in the project | You do not have the right to create products there. Ask the project owner. |
| The access tag is not found or not allowed | The tag does not exist in the project, or you cannot create products with it. In some projects a product must have an access tag. |
| At most … characters | The value is too long. Unit holds 10 characters, for example. |
Import into the product library
The product list in the product library (Product Library → Products) has its own Import menu and template. A library product has no project, so the template has fewer columns. The columns are Product Number and Product Description (required), Product Name, Parent, Product Category, Product Status, Product Status Description and Information.
- A product number must be unique in the whole library.
- You need the right to create products in the product library.
- Triark EDM adds the imported products to the product library's Working on: filter, which holds at most 30 products.
- You can drop a file made from the project template. The library imports its own columns, and the window names the columns it leaves out.
Read more in The product library.
Export products for import
To save the products in the import columns, right-click the product list and choose Export → For import. You can edit the file and import it into another project. Triark EDM imports a product added from the product library without the link to the library product.
