Bulk Attachment Importer

Bulk Importer application is designed to provide the tenants with the convenience of importing attachments to the AssetCloud application.

This application can be used for two different purposes:

1. Main Export Operation: Exporting the comma-delimited CSV file form from Wasp Mobile Asset 7 attachments for Assets/Asset Types.
2. Main Import Operation: Importing Attachments related to Asset/Asset type in Wasp Asset Cloud through a CSV file. The CSV file should match with our provided  template format in the application.  

Main Export Operation

In the main export operation tab, there are three different sections: Attachment Form, Export Attachment File For Import From Wasp IC/MA7 and Result.

Attachment Form

This field is required for both import and Export. You need to select your ideal form.

Export Attachment File For Import From Wasp IC/MA7

This section is used for exporting the comma-delimited CSV file form Wasp Mobile Asset 7 attachments for Assets/Asset Types. To use this application for export you should download SQL BCP utilities on your computer. You can download BCP Utilities by clicking on the provided links.

Note: During the download, if it asks for the SQ server 17 missed file just press Ok and continue.

• Application: This field is required for Export. Select your ideal application. The Options are MobileAsset and InventoryControl.
• SQL Server Name: Enter the SQL server management Server Name.
• Database User Name: Enter your Database User Name.
• Database Password: Enter your Database Password
• BCP Directory: After downloading BCP, Enter BCP in the search textbox next to your Windows Start button. The BCP will appear on search, right-click on it and select “open file location”. The file explorer will open. In the bar just select the directory path and copy it on the BCP Directory field.
• File Destination Directory: Enter your ideal directory where you want to find the exported file in the end.

Main Import Operation

In the main import operation tab, there are three different sections: Authorization Tab, Import File, and Result.

Authorization Tab

Authorization tab is required for importing the attachment.

• Tenant Url: Copy your Asset Cloud tenant Url from your browser.
• Token: Copy and paste the token from the View/Edit User screen. Refer Edit User.
• To generate the token, login to your cloud application. Click on Users > View Users. Click on the First Name of the user in the View Users screen. The First Name is a Link in the View Users screen and it will navigate to View/ Edit User screen. Generate the token.

Note: The token can only be generated by the user with an Administrative role. When you generate the token, it is the only time you get to see the token. Due to the security reasons, this token is not stored on our server. When you close the page, it will be gone. So we recommend you save the token for future use. The token will be saved by the Import utility for future use by Wasp Import utilities in the WaspUtilities.ini file.

Note: When editing the .ini file to add the Token and make any other changes, we highly recommend Notepad++ or similar. Under most current versions of Windows 'normal' users will not have sufficient the access rights to modify the .ini file directly. Notepad++ is a very safe and reliable way to edit this file.

Import File

This section is used for importing Attachments related to Asset/Asset type for Wasp Asset Cloud through any CSV file that matches with our CSV File template format in the application.

• Application: This field is required for Import. Select your ideal application.

• Import File: You can select any CSV file with the same format as our template to import. You need to make sure that the data type of your file_data must be Varbinary which would be appearing in the Hexadecimal format in database.
• CSV File Template: To make sure the import file matches with the “CSV File Template”, click on the “CSV File Template” link. The template will get downloaded and then add your file content in it.
• First row contains columns headers: Click on the checkbox, If your CSV file has a column headers.

Note - if you are using the exported file from the IC/MA7 you need not worry about the “datatype or the template format”  and the “First row contains columns headers”. The exported file automatically will be created in the right format.

Result Tab

The Result tab will display the Succes message as well as the Error messages.

Also Refer Import Data.