question Re: ImportSet Error Messages in Developer forum

ImportSet Error Messages

questsal78 — Wed, 12 Sep 2018 15:38:06 GMT

Hi,

I'm using a record producer to import data into a custom table for updates. Everything is working fine except, I'm unable to show end user a message showing how many rows were there, how many are updated and how many ignored just like below: End user is not admin so they can only see messages via record producer.

Here is my code:

// Set the following variables with the name of your import set table and task id column

var importSetTableName = "u_integrate_renewal_orders";

var transformMapID = "xxxxxxxxxxxxx"; // removed actual sys_id with text

// Setup data source for attachment

current.name = "Renewal Import " + now();

current.import_set_table_name = importSetTableName;

current.file_retrieval_method = "Attachment";

current.type = "File";

current.format = "Excel";

current.header_row = 1;

current.sheet_number = 1;

current.insert();

// Process excel file

var loader = new GlideImportSetLoader();

var importSetRec = loader.getImportSetGr(current);

var ranload = loader.loadImportSetTable(importSetRec, current);

importSetRec.state = "loaded";

importSetRec.update();


// Transform import set

var transformWorker = new GlideImportSetTransformerWorker(importSetRec.sys_id, transformMapID);

transformWorker.setBackground(true);

transformWorker.start();

// Take user to task

gs.addInfoMessage("Data import may take time load, please reload record to see all the assets.");



// Since we inserted data source already, abort additional insert by record producer

current.setAbortAction(true);

I don't know how to get this information from import set/transform map for end user. Is there a way to achieve this in record producer script?

Please advise.

Re: ImportSet Error Messages

Ankur Bawiskar — Wed, 12 Sep 2018 15:42:46 GMT

Hi,

Since the transform may take long time depending on the import set rows you can't force the user to stay on the same page.

Why not send an email notification instead with details:

total records

ignored

skipped

inserted

updated

Notification table:

Transform History [sys_import_set_run]

Trigger condition: State is one of Complete or Complete with errors

Set.Data Source.Name => your data source name

template.print("Total:"+current.total+" ");
template.print("Inserts:"+current.inserts+" ");
template.print("Updates:"+current.updates+" ");
template.print("Ignored:"+current.ignored+" ");
template.print("Skipped:"+current.skipped+" ");
template.print("Errors:"+current.errors+" ");

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: ImportSet Error Messages

questsal78 — Wed, 12 Sep 2018 15:57:12 GMT

Thank you for quick response. Yes, emailing notification will work for me.

Re: ImportSet Error Messages

questsal78 — Wed, 12 Sep 2018 16:02:43 GMT

Sorry, where I can set Data Source Name in notification?

Re: ImportSet Error Messages

questsal78 — Wed, 12 Sep 2018 18:38:25 GMT

Hi, how I can set that data source to this notification unless doing a mailscript with glide record query.

Re: ImportSet Error Messages

Ankur Bawiskar — Thu, 13 Sep 2018 14:38:38 GMT

Hi,

In email notification trigger condition you can specify for which data source it should trigger.

No need for glide record since the current import set run should take card of that.

Regards

Ankur

Re: ImportSet Error Messages

questsal78 — Fri, 14 Sep 2018 14:51:01 GMT

Another question, can I use existing data source and attach spreadsheet that user has submitted in this record producer? how can I achieve this?

thanks for help!

Re: ImportSet Error Messages

Ankur Bawiskar — Fri, 14 Sep 2018 15:37:54 GMT

Hi,

Yes you can attach the attachment from record producer to data source.

Regards

Ankur