Easy import or Quick import in Domain separated tables.

[rohanhd]

Hello Peers,

Currently I am using quick or Easy import functionality within servicenow to upload data. It is on Fuji instance and the domain separation plugin is activated. When I create the template for a domain separated table eg sys_user it doesn't show the domain field hence I cannot assign the domain to the data loaded rather I have to upload the data for each domain separately or using a script assign the correct domain.

To overcome this I made change to the system property that tells easy import to ignore certain field types. Property is glide.import_template.field_types_to_ignore. From this property I removed the domain_id, hence easy import should not ignore domain_id type fields. But even then when servicenow creates the import template for insert the Domain (type domain_id) field is ignored.

My property value looks as below after removing domain_id:

table_name, order_index, collection, user_image, video, timer, translated_field, conditions, field_name, sys_class_name, journal, journal_input, due_date, user_input, image, workflow, template_value, documentation_field, user_roles, glide_list

Any ideas on what else might be blocking it? or is this an unreported bug.

Thanks

Rohan

[rohanhd]

Well the tables are mainly user created but some core tables such as company and locations are also involved. I do know we can use transform map and do it via script but that would be my last call since I don't want to spend time on dev work for data migration. Also if the table structures etc change means a change to the map.

But for now I am interested via its not working for me. When I see the system created transform map that easy import uses the target table list doesn't list domain field. I am wondering whether this is due to ACL or something of that sort.

[Michael Fry1]

So using company or locations, it should work fine as those are out of the box. Custom tables: same scope? access control set correctly?

[rohanhd]

Unfortunately for me it isn't working for Company or locations either. The transform map lets me insert into domain by using an onBefore script but the mapping assist doesn't show the domain field on the target table. Mind you though if I use Auto assist it maps to the domain field.

Easy import actually creates a system transform map imp_tmpl_<table name> and that doesn't have th domain field listed.

[Michael Fry1]

I would try clearing your cache (cache.do) since you've changed a system property and it's not working.

[rohanhd]

Well I moved to using transform maps since setting domain via easy import did not work even after I removed the sys_domain from the property.