Import issues into BIMcollab Cloud from a BCF or CSV file

Import issues into BIMcollab Cloud from a BCF or CSV file

Import issues from a BCF file

Follow these steps to import a BCF file in BIMcollab Cloud:
  1. In BIMcollab Cloud, choose the project in which you want to import issues
  2. Go to the Import tab of the project
  3. Click on 'Browse', and choose the BCF file you want to import
  4. If necessary, select default properties to add to the issues when missing
  5. Click 'Import'
When importing BCF files, the following data from existing issues will not be copied:
  1. Area
  2. Custom fields
  3. Change log
  4. Visibility
  5. Links to a Navisworks clash test
These values will need to be created and reassigned to the issues manually. A default value can be chosen for these fields during the import of the BCF file.

Import issues from a CSV file

In some cases, you may need to import a list of issues, from a source other than a BCF file, into BIMcollab Cloud. In that case, the easiest way is to save your issue data into a CSV file. Creating a CSV file can be done using Microsoft Excel or any other spreadsheet applications such as Google Sheets or Numbers.

Follow these steps to import a CSV file in BIMcollab Cloud:
  1. Download one of our template files (Template to import issues) from the BIMcollab download page. You can now open the file using your preferred spreadsheet application and start entering the data.

    While entering your data you must follow the following rules:
    1. Each row represents an individual issue
    2. Using the column names in the defined order is mandatory
    3. Additional columns appended to the list are ignored
    4. The column names are not case sensitive
    5. All cells should be in TEXT format
    6. All dates must be entered as dd-mm-yyyy or yyyy-mm-dd (But leading zero’s are not mandatory so both 04-05-2016 and 4-5-2016 are valid entries.)
    7. Users which are entered in the columns 'Creator', 'Assigned to' and 'Approval', need to be entered using their unique email address as defined in BIMcollab
    8. The type, priority and status fields must correspond with those defined in your BIMcollab cloud
    9. Any images URLs must refer to an image in JPEG, PNG, GIF or BMP format
    10. Any URL must be accessible from our servers so paths to local files or your intranet are not supported
    11. If multiple email addresses needed to be added as "approvers", they must be separated by commas

  2. Once all of the data is entered, you can now save the file as a CSV file:
    1. In Numbers, go to "File> Export to> CSV"
    2. In Microsoft Excel, go to "File> Save As> CSV" (Read the more detailed article on the Microsoft site.)
    3. In Google Sheets, go to "File> Download> Comma Separated Values (.csv, active sheet)"

  3. In BIMcollab Cloud, choose the project in which you want to import issues
  4. Go to the Import tab of the project
  5. Click on 'Browse', and choose the CSV file you want to import
  6. If necessary, select default properties to add to the issues when missing
  7. Click 'Import'
When importing issues via CSV there are a number of things one must be aware of:
  1. Every issue imported will be added to the project as a new issue. It is not possible to update existing issues when using CSV files.
  2. When a due date and a cause of delay are defined, a comment will be created on this due date containing the cause of delay.
  3. When a modification date and a comment on modification are defined, a comment will be created on this modification date containing the comment.
  4. Users in the list are mapped to existing users in BIMcollab based on email-address.
  5. When a new user is found in the list then that user will be created in BIMcollab Cloud and added to the project. They will then need to be approved by the project leader or the space administrator before they can log into BIMcollab and work on the project.
  6. Microsoft Excel is not able to create CSV files using Unicode encoding. Therefore any special characters or non-latin characters may be lost.

SmallBestOriginalRemove
    • Related Articles

    • Import users into BIMcollab Cloud from a CSV file

      In some cases you may wish to import a list of users from another source into BIMcollab Cloud. In that case the easiest way is to save your user data into a CSV file. Creating a CSV file can be done using a spreadsheet application such as Microsoft ...
    • Edit and comment on issues

      In BIMcollab Cloud, as well as with BIMcollab ZOOM or the BCF manager you can add comments to existing issues and edit it’s properties, BIMcollab Cloud From BIMcollab Cloud, you can add comments and edit issues from the Issues page of your project Go ...
    • Manage a BIMcollab Cloud

      Administrators can reach the administration page by clicking on the settings icon, and choosing 'Administration' in the pull down menu.    The administration page is easily recognizable by the red ribbon at the top of the screen.  From there you can ...
    • Set your language of your BIMcollab account

      Join.bimcollab.com On join.bimcollab.com, users can choose the prefered language by going to Settings  > Preferences and selecting the one they prefer. Private BIMcollab Cloud spaces Every BIMcollab Cloud space has a default language which is set by ...
    • Import user names that contain special characters

      BIMcollab Cloud does support special characters, but it depends on the encoding of the file that you want to import. Like most web applications, BIMcollab Cloud uses Unicode encoding to ensure that all special characters are supported and can be ...