There may be thousands of images for asset, work order, and other objects to be imported into Calem when migrating from an existing CMMS/EAM solution after years of usage. This blog discusses an approach to add massive number of images to Calem. The approach requires some programming skills. For instance, using scripting language to manipulate files.
1. Drag and Drop Not Practical
Calem provides a drag and drop screen to add more than one image and file to Calem as shared docs (see this blog), or as attachment to an object (asset, work order, etc). However, it is not practical when dealing with thousands of images or files.
Another option is to build out files in Calem server, and upload excel to Calem to link the files with objects (asset, work order, etc.) in Calem.
An attachment in Calem consists of a file and a database record.
We will discuss ways to build out the files and database records. Asset will be used as an example to demonstrate the approach.
2. Move Files to Calem Server
The first step is to transfer all the files to Calem server at Calem_Home/server/upload_files/attachment. Next, write a script to iterate through each file and change its file name to: MD5(filename)+"_"+filename where MD5 is the message digest algorithm.
The above steps make the files ready to be referenced in Calem.
3. Use Excel to Link Files to Asset
Follow the steps below to prepare excel file to be uploaded to Calem.