populate reference table fields using transform maps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2017 07:20 PM
Hi,
I have a question regarding to reference table fields populate using transform script. I am importing data from excel sheet and transforming into computer table(cmdb_ci_computer). In the excel sheet i have serial number, model name, model number, manufacturer, OS version, RAM and hard disk. I can import all the fields except model name, manufacturer. In the computer table(cmdb_ci_computer) we have a field called model id(refernce table: cmdb_model) which is reference field, i want to populate model name in the cmdb_model table field called "name" and manufacturer in the "manufacturer"(Refernce to company table) field in the cmdb_model table.
Any suggestions!
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-06-2017 01:52 AM
Any suggestions on above script.
Thanks