Adding Members to External Business Location through Transform Map

[Ashuthosh_s_p]

I have some set of data which I have in External Business location table. Now when I register a member, A user is created in sys_user table also a record in service organization external staff. Now instead of registering, how can I add the data through import sets and transform map so that the value is mapped in the external Business location and service organization external staff.

[Sharath Chandra · Accepted solution]

If you are trying to associate Users to an External business location. 

It is a 3-step process i.e., you need to import data into 3 tables:

1. First create the user --> Service Organization external staff (sn_csm_service_organization_external_staff)
2. Make them a member of the business locaiton --> Service organization member (sn_csm_service_organization_member)
3. Assign the right responsibility --> Service Organization Member Responsibility (sn_csm_svc_org_member_responsibility)

Regards,

Sharath

[dman2969]

So, this is the only post I found on how to do this, but the answer is a bit vague.  I'm using a transform map to import data.   

I can do #1 and #2 above via a transform script without issue. HOWEVER, when I insert a record into #3 it only allows me to associate the responsibility with the Member but not the Service Org (not directly) there is not field in that table pointing to Service Org.  

BUT that table acts as if there is a relationship there and you will see multiple records for the same user with the same responsibility.   The difference is that each is for a different location, which makes sense.   But there is no way for me to match location to these records to differentiate them so that I can match to them and remove them etc.   I need to be able to add and remove or update these roles as needed, but I cannot do this via normal query.

What am I missing here?   Can I add a reference and insure it's getting populated that's the only think I can think of, and probably my next move.   Any thoughts?

[Sharath Chandra]

Can you check this and let me know if it addresses your queries?  https://www.servicenow.com/community/csm-articles/part1-import-members-to-an-internal-external-busin...

[dman2969]

Sharath, this did help!  Thank you.  Reviewing the code in the update set helped me figure out what I was doing wrong.  Basically, I wasn't dot walking properly the keep the records related.   I may run into an issue when I need to update or remove these.  But I think I have a plan for that.  I appreciate you pointing me to this article.