Script to write to new import set and then kickoff transform map to process records

[tpoeckes]

Hello All,

I have a CMDB import set called u_cmdb_import.  I also have a transform map called cmdb_process that will process the records and insert/update into CMDB.  The import set and transform map are defined as a data source.  I would also like to process two (2) more tables of data that are brought in via import set and then written to custom table 1) cmdb_data_1 2) cmdb_data_2.  I would like to use the same import set and transformation map.  Is there a way that I use a script to LOAD to a new import set, kick off the transform map to process the records.  The two (2) new tables would use the same fields in the import set.  Any help would be greatly appreciated.

[VaranAwesomenow]

Hi @tpoeckes Yes or you can use a data source of type script and run that via scheduled import and call that, which will do the work of creating import set automatically but of data of your choice since you are using a scripted data source.

Once import set is created transformation happens automatically.

[ARG645]

You need to use different transform maps. As Michale Ritchie said, each transform map is tied to a specific table. Are you also looking for a way to kickoff the transform map via script?

[codycotulla]

Hi T,

You might already have solved this problem, but if you haven't.

What you can do to get your data into your import set is to simply create a new record in your u_cmdb_import.

When you add the record, if there is no synchronous import set active, then a new synchronous import set will be created, and the record that you just added will be transformed by the transform map.

So ... you can create a script that gets the data you need from the cmdb_data_1 and cmdb_data_2 tables, then create records in the u_cmdb_import set. Each time a new record is created it will be added to the active synchronous import set, and then the record will be transformed.

Hope this helps.

Let me know if you have any questions.

Thanks,

Cody