Hi,

Can someone help me with building a regular expression/dictionary for following: I want to import the actions if the action type from the file is not blank and if so I want to add the action date, action type & canvasser based on the action type from the file.

I have used the following to map the virtual field

*AC contains name of the action type

If the action type is blank, ignore adding an action

If action type is not blank and one of the values match then add the cos id as canvasser

I am getting an error

Required Field Missing: Records Id [Object: 'CActionSolicitor', PK: '-1', Import ID: '', Desc: '', Field: 'Records Id', Value: '']

Thanks

Bernadette

Do you have the solicitor's constituent ID or Import ID? It needs to be the latter

Hi Barbara,

I am using the solicitor's constituent id if the action type from the file is not blank.

Thanks

Bernadette

Can you try putting the solicitor's Import ID in the dictionary instead of the Constituent ID and see if it gives an error?