How do I connect imported assets with contracts in an import set

[Robin Chadwick]

I have a spreadsheet of hardware assets that I need to import.  Each of the assets is related to a contract that exists in the contracts table.  I have the contract number included in the hardware asset import spreadsheet for each asset.

How do I import the assets into the table [alm_hardware] and connect each asset to its corresponding contract through the import.  

I am not interested in adding the contract to each asset manually as there is over 3500 assets.  Also, I am not interested in adding the assets to the contracts manually as there is over 3500 assets.  

I'm looking for how to do this with an import set and transform map.

Here is some example data

[Robin Chadwick]

No, not the correct answer.

Through my own research and some playing around in my development instance, I have come up with the solution.

You need to make sure you have the Display Name and the Contract number for each asset in each row.  Then you are going to create 2 transform maps for the import.

• 1st Transform Map - imports the asset data from the spreadsheet to the "Hardware [alm_hardware]" table.  
• 2nd Transform Map - maps data to the table "Asset Covered [clm_m2m_contract_asset]"
  The field mapping required is as follows
  Display Name --> Asset
  Contract --> Contract

When you execute the transform, the Asset Import transform map Must be first, followed by the Asset to Contract transform map.

[Abdul Khan4]

Thanks for the reply. There are multiple ways of solving the problem. We cant say if one is correct and other is wrong. Yes, we can say one is more efficient or easy to implement then other. 

You have implemented the same behavior as i mentioned in step one. In your solution, you are using two transformation map which is not required at all.   Just use one transformation MAP is sufficient and add the insert code to after script. 

[Ankita34]

Did this solution worked for you. I also did the same step but mapping script is creating blank assets.