Setting up CSV import file rules?

[Mat Gdowski1]

Hey all,

I'm hoping to get some suggestions on how to handle the importation of a CSV file into ServiceNow.

I am importing an Excel CSV file into ServiceNow, however, I'm trying to setup some "rules" to manage the importation of the CSV file.  What I mean by that is basically the following...

1) If the Name in the import record doesn't match a record with the same Name in the target field, then I want it to reject that record.

2) If the county, state or country name in the import record isn't in the same format as the target record (i.e. state code (AL) instead of being spelled out (Alabama)), then reject that record.

3) If the state in the import record matches a certain state (such as Hawaii or Alaska, etc.), then it is to set another field in the target record with a certain value.

I was thinking maybe there is a way to handle this in the transition map, maybe by scripting?  If so, are there any leads on how to handle this scripting in ServiceNow?  Is there any way to notify the person importing the file as to what records are rejected and maybe even why?

Any help would be appreciated.

Take care,

Mat G.

[Tony Chatfield1 · Accepted solution]

Hi, I would look at a before transform script to validate each rows data\fields, setting ignore = true of you do not want the import\update to proceed.

[SuhasPSalunkhe]

1. Use before transform script.

2. You can use coalese for Name field.

Also please read scripting in Transform map so you will get better idea

[Mat Gdowski1]

Thank you both.  I will look into those options and re-read up on the scripting in the Transform map.