How Can I Bulk Import my Assets?

We allow you to import assets in Bulk using a .CSV file (spreadsheet). If you are not familiar with a .CSV file, take a look at this article on working with .CSV files.

To bulk import your Assets:

1. Head to the assets page in vWork here. Then manually create your first asset by clicking 'Add Asset' and filling out the details.

2. Then once your first asset is created, click the Export button to download the CSV file of your asset.

3. You can now use this CSV file as a template to add all of your additional assets.

4. Add your additional assets detail to the CSV file using your own spreadsheet editor (like MS excel), then save.

5. Go to the asset import tab 

6. Choose your CSV file, select that you are using a header row, then choose 'Start matching' as below:

7. Then drag your CSV fields to match the Asset fields as shown below:

The fields you can include on your asset import are below:

Along with any common asset fields that you may have set up.

Importing Groups, Hazards, and Tags with your Assets

When you import hazards or tags with your assets there are a few rules to follow.

• The group name must exactly match the existing group.
• You must use the hazard ID or tag ID (these are listed on your tags and hazard pages).
• These hazards and tags must already exist in vWork.
• When importing multiple hazards, tags, or groups with assets in a CSV file you must separate the ID's with a | symbol ("Shift+\" on your keyboard).

For example, to import tag ID's 123, 124, and 456 into one asset your .CSV cell would look like: 123|124|456
This is the same for importing multiple hazards and groups.