The CreatorCon Call for Content is officially open! Get started here.

populate reference table fields using transform maps

daggupati
Tera Contributor

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.

5 REPLIES 5

daggupati
Tera Contributor

Any suggestions on above script.




Thanks