Need Guidance on Robust Transformers for alm_asset/hardware

EricG
Kilo Sage

‎05-05-2023 11:07 AM

Hello Team:

 

I need guidance on using Robust Transformers RTE/ETL to import an excel report that I receive from Dell Inc. with my companies lasted Workstation Build.

I use this report to populate our ASSET Management Stockrooms, so that the team can receive them once they arrive.

 

Up to about last year, I was able to use 2 Transforms form maps linked together to achieve adding the Computer CI and alm_hardware information.

 

Now I need to run it manually and not from the Email inbound action.

I've just started getting familiar with the Robust Transformers and Service Graph connectors.

 

Can anyone provide some guidance on how to get my Dell information (e.g. PO, Model Costs, Stockroom, etc.) to populated the Hardware Asset entry.

 

I've been successful in getting the CI information in and can use the AssetCreateCI script include to map MOST information over to the Asset table.

 

I just can't figure out how to get:

1. The stockroom populated (old method used a GS to look at location address included in excel report)

2. Warranty Expiration (which is a GD adding 4 years to the actual shipped date included in excel report)

 

Thanks for the help and please let me know if i need to post elsewhere. 

0 Helpfuls
  • 466 Views
1 REPLY 1

Punit S
Giga Guru

‎05-05-2023 03:58 PM

To import an Excel report from Dell and populate your company's ASSET Management Stockrooms in ServiceNow using Robust Transformers RTE/ETL, you can follow these general steps:

  1. Create a data source for the Excel file in ServiceNow. Go to "Data Sources" in the ServiceNow navigator, and create a new data source for the Excel file. Make sure to specify the correct file location and format (Excel).

  2. Create a transform map to map the fields from the Excel file to the ASSET table in ServiceNow. Go to "Transform Maps" in the ServiceNow navigator, and create a new transform map for the Excel file. Map the fields from the Excel file to the corresponding fields in the ASSET table. For example, map the "PO" field to the "Purchase Order" field in the ASSET table.

  3. Create a transform to populate the Hardware Asset entry. Go to "Transforms" in the ServiceNow navigator, and create a new transform to populate the Hardware Asset entry. Use the AssetCreateCI script include to map MOST information over to the Asset table.

  4. Add additional transformation steps to populate the Stockroom and Warranty Expiration fields. To populate the Stockroom field, you can use a transform script to look at the location address included in the Excel report and map it to the corresponding stockroom in the ASSET table. To populate the Warranty Expiration field, you can use a transform script to add 4 years to the actual shipped date included in the Excel report.

  5. Run the transform manually to import the Excel file and populate the ASSET Management Stockrooms in ServiceNow. Once you have created the data source, transform map, and transform, you can run the transform manually to import the Excel file and populate the ASSET Management Stockrooms in ServiceNow.

Please note that the specific steps and details may vary depending on the specifics of your environment and the Excel report you are working with. It may be helpful to check  with specific instance version documentation and/or work with a ServiceNow partner SME/consultant for additional guidance and support.

I hope this helps! Let me know if you have any further questions or need more information.

 

Please mark my answer as a solution/helpful in case it adds value and moves you a step closer to your desired ServiceNow solution goal.

Thanks,
Punit

0 Helpfuls