- Create a data file by converting the metadata into the format recognised by Asset Bank's 'metadata import'. Depending on the format of the existing data (it might be in spreadsheets, in a legacy database, etc) it is often useful to write 'data migration' code or scripts to process the data and generate the data file. MS Access can also be useful for this.
- Import all the files using a 'bulk upload'.
- Import the metadata file.
- Ensure that all filenames are unique.
- Maintain the directory structure when importing the files, and ensure that the data file's AssetId column contains the corresponding directory paths as well as the filenames. Note: this option requires Asset Bank version 3.1367 or higher.
- Login as an admin user and go to Upload-> Bulk Upload, and click 'Start a new bulk upload'. This ensures that a bulk upload directory has been created for that user on the server.
- On the server (or using a file explorer such as Windows Explorer) go to this user's bulk upload directory. By default this will be within the asset-bank webapp in bulk-upload/[username]. Otherwise, check the setting bulk-upload-directory for the location of Asset Bank's bulk upload directory.
- Create a sub-directory in the user's bulk upload directory called (for example) 'to-import'.
- Copy all the files to be imported into the 'to-import' directory by recursively copying all the directories containing the files, for example from the network drive or USB drive where they are located.
- If you want to create categories in Asset Bank to match the directory structure the files were in, set the following settingbulk-upload-match-dir-names-to-cats=true (if you are using access levels as categories then this setting will create access levels).
- As the user in step 1, go to Upload->Bulk Upload and start a new bulk upload. Click 'Next' on the Flash Uploader page (as you have manually copied the files into the user's bulk upload directory). Choose 'to-import' from the 'Import assets from a directory' dropdown. Enter any metadata values you want to set for all files and then start the import.
- Wait until all the files have been imported. This could take some time!
- Check that the metadata file is in the right format (see help for metadata import) and then import it (Admin > Attributes > Metadata Import). As an example, if we want to populate an attribute with label 'Description' and ID 4 and an attribute with label 'Keywords' and ID 5, and filenames are unique, then the following will work:
This is my description
keyword 1, keyword 2
If filenames are not unique, and (for example) the file above was located in the directory images/people/staff then the format would be as follows:
|images/people/staff/image1.jpg||This is my description||keyword 1, keyword 2|
Converted to map into newly uploaded version that has a different assetId in the Cloud version:
This addition to help section was added by Stewart Oak on 15/1/19