This blog series demonstrate the data setup through uploading data from excel templates.
- Data Upload Part 1: Inventory Module
Here are some background about excel templates and data upload:
- An excel data template is generated for each table in Calem. Customers can download the archive of all the templates at http://support.calemeam.com/view.php?id=4046. A customer account is required to download the templates.
- The Data Upload Guide has information for some tables that should not be uploaded including transaction tables that are generated in Calem. Customers can reference the Data Upload Guide at http://support.calemeam.com/view.php?id=3983. A customer account is required to download the Guide.
- The excel templates can be used to create new data or update existing data. So, you can use the same excel file to create data and make changes by uploading the file more than once.
This is the second part of the data upload tutorial. This blog serves as the detailed walk-through for the steps defined in Calem Setup Part 1: Asset and Location.
Step 1. Inventory
Inventory module is referenced by asset module. Use resources below to set up inventory module:
- Upload via Excel Templates: http://www.calemeam.com/component/easyblog/upload-1-inventory-setup-by-data-upload?Itemid=250
- Setup steps via screens: http://www.calemeam.com/component/easyblog/data-setup-part-1-inventory-setup?Itemid=250
Step 2. Documents
Documents including photo, drawing, manuals are referenced by assets. Upload documents via Calem web client. See documents of Calem Setup Part 1: Asset and Location for more information.
Step 3. Asset Grouping and Categorization
- Asset group template: cm_in.Global_Items_AssetGroups.xls
- Asset group is a global item with "Asset group?" set to "1"
- Asset categorization template: cm_categorization.AssetCategorization.xls
- Asset categorization has "Asset" flag set to "1".
Step 4. LocationUpload location by the location template: cm_location.Locations.xls
Step 5. AssetUpload asset by the asset template: cm_asset.Assets.xls
- Asset grouping blog
- User Guide and Admin Guide (customer account required)
- Calem Enterprise Training Site
- Calem Enterprise Blogs
- Calem Enterprise demo