Easy Import Bulk Load Issues

[kailashthiyagar]

I m in Istanbul Release and we have bulk load requirement in PRD environmentwe

Using "Load Data" , "Transform Map" , we can do the bulk load in DEV environment but when it comes to PRD environment, whats the best way?

We would be getting multiple bulk load request and each time, we would like to test it in the DEV environment before doing it in PRD. We thought of doing it through Easy import process.

But the excel template which we download doesnt have the "List collector " fields even though the field has been selected in the list..

Whats the suggestion

ctomasi pradeepksharma abhinay

[kailashthiyagar]

alikuttyka

If its the transform maps, so when it comes to PRD, we would be following similar procedure, right?

Like Loading the data to stage table and then loading it to the target table using transform map..

[Alikutty A]

If you do not want to load data manually on production, You can automate it using a record producer. You create a request, attach the file and submit, It is done!

Check this out: https://www.servicenowguru.com/system-definition/imports/simplifying-data-imports-parties/

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[kailashthiyagar]

alikuttyka

One last question.. Is there any validation script examples available for validating the "Reference"/"List" values before uploading the data using the transform map?

The reason is most of the fields in our application is a reference or List(multiple values seperated by comma).. In this case, if there is some mismatch in the spelling or space, new record would be created in the reference tables.. So if there is any example, it would be great.

[mikereaves]

Kailash, There aren't validation scripts per se, personally, I rely on the Transform History and Transform log.   Also, I require that anyone doing this type of work to become extremely familiar with the numbers. You have to know how many records are being imported for each table and the relationships. In the end, you have to stand up for the accuracy of the data migration therefor intimate familiarity with the data is essential. ServiceNow has never let me down in this regard... all of the data is programatically managed with an extremely low probability for error.   I hope that helps. Mike Reaves / Acorio Please confirm with "Answered" or "Helpful".

[mikereaves]

a list collector is an array of foreign key references. there will be a variable number of items in a list collector. it would be very difficult to represent this in an excel spreadsheet.