With an import you register many documents at once, with revisions, files, persons and references. You fill in an Excel template and drag it, together with the files, into the document list. You check every row before Triark EDM creates anything.
Before you start
- With the Custom access control add-on, you need permission to create documents in the projects you import into. Without the add-on every user is Admin and has this permission.
- Turn on edit mode (the switch top right, or F2). Triark EDM refuses an import that you drop in read mode.
- Select the projects you import into in the project filter above the document list. See Navigation.
- Have the files you want to attach ready in one folder.
Download the template
- Open Project > Documents in the menu on the left. Import is only available here, not in the product library's document list.
- Right-click anywhere in the document list.
- Choose Import > Download template.
- Open the file Documents import template.xlsx in Excel or a similar program.
Each column is one field. Some column headers have a note with formatting tips: hover over the header cell to read it. Columns that hold codes are formatted as Text, so Excel keeps a code such as 0012 as you type it.
Note: Keep the file as an Excel workbook (.xlsx). You cannot import CSV and older Excel files (.xls).
Fill in the template
Enter one document per row. Only three columns are required, and they are shown in bold: Project Number, Document Number and Document Name. Leave the other columns empty if you don't need them.
| Column | Required | Format and notes |
|---|---|---|
| Project Number | Yes | Must exactly match a project number in Triark EDM, and the project must be in the project filter. |
| Document Number | Yes | Must be unique in the project, and cannot appear twice in the file for the same project. |
| Document Name | Yes | Free text. Becomes the document's name. |
| Document Category | No | Must be a category in your setup. Needed if you fill in Document Status. |
| Document Person | No | One or more persons from a company linked to the project, separated by ;, for example Kari Nordmann; Ola Hansen. If two persons in the project share a name, write Name - Company. |
| Document Person Role | When Document Person is filled in | One role per person, separated by ;, in the same order as the persons, for example Engineer; Reviewer. Two persons can have the same role. |
| Document Status | No | Must be a status that belongs to the document's category. |
| Document Status Description | No | Free text. |
| Access Tags | No | Only with the Custom access control add-on. Access tags in the project, separated by ;. Upper and lower case don't matter. In some projects a document must have a tag. |
| Revision Number | No | For example A, B, 01, 02. Requires Revision Date and Revision Responsible. |
| Revision Date | When there is a revision | Enter the date as DD.MM.YYYY in a cell formatted as a date. |
| Revision Responsible | When there is a revision | A person from a company linked to the project. Use first and last name, or Name - Company if two persons share the name. |
| Revision Status | No | Must be a revision status in your setup. Requires Revision Number (and so Revision Date and Revision Responsible). |
| Revision Status Description | No | Free text. |
| Files | No | File names, separated by commas, for example Draft.pdf, Summary.docx. A revision can have several files. Requires Revision Number, Revision Date and Revision Responsible. |
| WBS | No | WBS codes in the project, separated by commas, for example 10, 100. |
| Folder | No | Folder codes in the project, separated by commas. |
| Zone | No | Zone codes in the project, separated by commas. |
Note: Type dates into the date cells as real dates and don't change the cell formatting. The import rejects a date typed as text.
Several categories
- Use
|between levels, from parent to child:Operations | Reports. - Use
,to start a new category:Operations | Reports, Drawing, User manual.
See Categories and statuses and Folders, WBS and zones.
Import
- Put the spreadsheet and the files listed in the Files column in the same folder. File names must match the template exactly, including upper and lower case and the extension (.pdf, .docx and so on).
- Drag the folder, or the spreadsheet and the files together, into the document list. As an alternative, right-click the list and choose Import > From file. Then select the spreadsheet and the files. The Document Import window opens.
- Review the rows. Under the title you see how many rows were read from each file. The import skips rows and sheets you have hidden in Excel.
- Find the rows with problems. A row with a problem shows Invalid in the status column, and the cells with problems are red. Hover over a red cell to see the reason. You cannot tick such rows.
- To fix the problems in the window, click a cell and edit it. The pick lists filter as you type. As an alternative, fix the problems in the spreadsheet and drag it in again.
- Tick the rows you want to import.
- Click Import.
- If the PDF files contain review markup (comments, highlights, drawings), the app asks whether to remove it. Click Remove markup or Keep as is.
To stop part way, click Stop. The row in progress finishes, and the rest wait until you click Import again.
After the import
The status column shows how each row went:
- Imported: Triark EDM created the document and everything in the row.
- Failed: Triark EDM created nothing. Fix the row and import it again.
- Partially imported: Triark EDM created the document, but a later step failed, for example a file upload. The row is locked, so nobody can import it twice. Finish the document in the document list.
The new documents appear in the document list.
Your edits and the spreadsheet
Edits you make in the window change what Triark EDM imports, not your spreadsheet. Click Export corrected file to save the rows as they are now, with your edits. The file has only the import rows. It leaves out formulas, your own formatting, hidden rows and sheets, and the workbook's other sheets. Keep your original spreadsheet.
If you close the window with edits that you did not import, choose Export & close, Discard or Cancel. Reset all edits puts every cell back to what the file says.
Common problems
- not found (project, person or person role): the value does not exist, or the person's company is not linked to the project. Check the spelling, and that the person's company is linked to the project you import into. If the project is not found, check that it is in the project filter.
- Multiple matches found: two persons in the project share the name. Pick the right one in the list, which shows each person as Name - Company.
- invalid (category, revision status, WBS, folder or zone): the value does not exist in your setup. Or the WBS, folder or zone code is not in that project. Check the spelling and the codes.
- Invalid date: the cell holds text, not a date. Enter it again as a real date.
- is invalid within the specified categories: the status does not belong to the document's category. Choose one that does, or fix the category.
- already exists in project or Duplicate Document Number: the document number is already used in the project. Or it appears twice in your file for the same project.
- You cannot create documents in project: you don't have permission to create documents there. This only happens with the Custom access control add-on. Ask the project owner, or import the row into another project.
- Persons: 2, roles: 1: each person needs one role, in the same order. The import also flags an empty entry (
;;, or a;at the end) and the same person twice. - Access tags need Extended Authorization: your company does not have the Custom access control add-on. Leave Access Tags empty.
- Access tag errors: the tag does not exist in the project, two tags share the name, or you cannot create documents with it.
- Excel turned this value into a date: Excel changed a code such as 01.02 into a date. Format the column as Text in Excel and type the code again, or type it in the window.
- A cell with an Excel error, a merged cell, or a formula without a value: the import cannot read a value there. Fix the cell in Excel, or type a value in the window.
- The following files are missing: you did not drag in a file listed in Files, or the name does not match exactly.
- More than one dropped file is named: two files you dragged in have the same name. Drag in only the one the document should have.
Tips
- You can import into several projects from one file. Fill in the project number on each row, and select all the projects in the project filter.
- If you have many rows, test with a small sample first.
- To copy documents into another project, tick them in the document list. Choose Export > Selected for import. Change the project number in the file and import it there. The files are not part of the copy. An import only creates documents: it does not update the ones you have. See Export and download.
- To see which file types Triark EDM can preview, see File types.
