Step 3: In column B, fill in the name of the document to be uploaded, including its extension. See in the image below: "test.pdf" where ".pdf" is the file extension.
Step 4: In columns C-L, fill in the required document details including the Spatial Structure, Document Type, Discipline, Author, Document Date, Descriptions 1-3, Labels, and Work package codes.
Step 5: In columns M-S, fill in the version details which include the Version number, Version Date, Status, Version Description, Scale, Paper Size, and Attachments. Fields with an asterisk in the upload list should be filled in; alternatively, they can be filled in on the "Add documents" page.
The Game Rules
The use of a document list does have some rules. This way, the Excel file is only read by Twin specifically for its purpose as an Upload list and not as an Excel file that needs to be uploaded as a document. The file should be updated whenever a new file version is available, and it must be uploaded together with the documents to be uploaded every time. If the upload list meets the requirements below, it will be read correctly:
- The file name of the upload list contains the word “upload list”. Text may be placed in front or behind.
- The file extension is .xlsx .
- Use the same column names as in the template.
- These column names must always be on the 4th line of the Excel file.
- The order of the columns does not matter, so this may be adjusted compared to the example.
- Lines 1 to 3 are not read, project data, logos, or own explanations may be placed here.
- Each line with a document number is considered a file. So do not place subheadings in this column.
- The file name column must also contain the file extension, for example: drawing.pdf
- The contents of cells must be an exact match with the metadata set on BIMcollab Twin.
BIMcollab Twin looks up the file names in the upload list when uploading. Only the files that are uploaded together with the upload list are read. The upload list may therefore contain additional lines for other files, but these will not be read. BIMcollab Twin reports that this file has not been found.
The upload list may contain additional information and can be formatted with, for example, colors and subheadings. Make sure that this information is always in its own column, which is not read by BIMcollab Twin.
Upload with upload list
To upload your documents with your upload list, follow the steps below:
Step 1: Select the level you would like to save your project on (Location, project, or phase). Move to the Documents page and click on "Add". It could be "Add to location", "Add to project", or "Add to project phase" depending on the level you have selected.
Step 2: Drag and drop, or choose the file(s) together with the upload list to be uploaded and click "Upload"
Step 3: Review notifications, if any.