Skip to main content
All CollectionsFilesPublish File on a Project
Upload Files in Bulk via MS Excel Plug-in
Upload Files in Bulk via MS Excel Plug-in

This help article describes how to bulk upload through the Asite MS excel plug-in.

Updated over 2 weeks ago

Users on Asite can bulk upload revisions of files directly to Asite using the MS Excel plug-in.

1. Open the MS Excel file and in the Asite tab select the 'Never' option for 'Save to Asite'.

To use the 'Save to Asite' feature instead of bulk upload, click here for more help on the MS Excel plug-in (Navigator).

2. Click the 'User Login' option and provide the login credentials.

3. Click the 'Select Workspace' button next to 'User Login' and select the desired project.

4. Define the file naming convention for files to be uploaded. Click 'Add' for the new field and then click 'Modify' and 'Remove' to modify and remove respectively.

Existing naming conventions are visible after clicking 'Naming Convention', and if there are no existing conventions create a new one.

5. Selecting files, click on 'Add Files' or 'Add Folder'. 'Add Files' allows you to select files to be uploaded from your device. 'Add Folder' allows you to select a folder on your device containing files to be uploaded.

The point to keep in mind is the files should be named as per the naming convention selected. Click on 'Add Files'/'Add Folder', and select the files/folder containing files to be uploaded.

6. File attributes will be auto-selected and captured in the Excel sheet.

7. Click on 'Retrieve Metadata' to retrieve the metadata of selected files from their previous revisions which are already uploaded to Asite.

If there is no default folder selected, then please select one. Default folders can be different for files or the same folder can be applied to all files.

8. Click on 'Prepare Upload' to prepare an MS Excel file for uploading. Once prepared, the system will prompt you with the file location on your device.

9. Log in to the Asite Web Application and in the 'Files' tab, navigate to the project and folder selected in Excel described above.

10. On the files listing area, click on the 'Upload' dropdown at the top right and select 'Files' to upload files to Asite. This option validates your permission to upload new files to the selected folder.

11. The listing page displays a page with an upload window.

12. Select the files to be uploaded and drag them to the upload area or click the 'Select Files' button to browse and select required files.

Upload of file revisions may depend upon whether the 'Revision Upload' activity is locked or unlocked for the existing file (with the same doc ref). While uploading multiple files at a time, the files that have the 'Revision Upload' file activity locked will be filtered out automatically.

13. Click on the icon to download the MS Excel template for importing file attribute details and save it on your computer.

14. Open the downloaded Excel template file. The first sheet of the Excel file shows 'Notes' which gives important information about uploading files.

15. Capture the required details of the files to be uploaded in the second sheet - named 'Import-Data' and save the file.

16. Return to the file upload screen of Asite.

17. Click the icon to upload the updated MS Excel file. The 'Import from Excel' screen will appear.

18. Drag and drop the updated MS Excel file or click 'Browse' to select the file manually. Once done, click 'Import'.

19. Details of the files captured in the Excel sheet are updated on the user interface. Click on 'Select Files' to modify the file selection if required. You can also edit the file attribute details directly from the user interface at this step.

20. Click on 'Upload' to upload files with attributes.

21. The activity center displays the progress of file uploads. The activity center screen automatically closes once all the files are uploaded successfully.

22. In case, selected files already exist in the folder then all the attributes will be automatically pre-populated. The attributes will be included in the upload of the revision.


Check: FAQs


Did this answer your question?