MS Dynamics 365 CRM Import Job - Update

(0) Share

Report

Posted on by dxshyam

230

Greetings !

I have a view called Bulk Update, which I opened using Excel Online and updated values for several rows of a column and press save.

Internally, a job is submitted as shown below

The details of the job can be seen as below, I am trying to build an Advanced Find View to include the highlighted values (Successes, Failures etc)

This is my Advanced View

I am able to pull only the below details, do we know how to include columns that shows number of success, failures?

My over all intention is to explore options to inform my end user about the completion of the job with some additional information like status, record count for success, failure etc using MS Flow or any other option.

My end user wouldn't prefer to visit Data Management > Import Data and check the details.

Regards,

Shyam

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

drewt_MS on at

Like (0)

Report

Hello Shyam:

In the previous Web version of CRM there was a link in the import dialog that would take the user to the My Imports page. Customers have requested this link be restored in the new Unified Client Interface (UCI) and the Engineering Group are currently working on this feature.

Further investigation into the metadata for this entity using the Web API:

<org>/api/data/v9.0/EntityDefinitions(LogicalName='importfile')

"LogicalName": "importfile",

"ObjectTypeCode": 4412,

"SchemaName": "ImportFile",

"LogicalCollectionName": "importfiles",

"ExternalCollectionName": null,

"CollectionSchemaName": "ImportFiles",

"EntitySetName": "importfiles",

The page being displayed is not a view of the importfile entity but instead an Entity Set.

The entity set can be retrieved using the Web API in JSON format:

<org>/api/data/v9.0/importfiles?$filter=_ownerid_value eq '<guid of the systemuser>'

and includes the fields your are looking for:

"successcount": 3,

"partialfailurecount": 0,

"failurecount": 0,

"totalcount": 3,

This information could be formatted in a HTML web resource and then opened with Xrm.Navigation.openWebResource.

The previous form My Imports is still available so this URL can also be opened using Xrm.Navigation.openUrl:

function DoOpenImports()

{

  var globalContext = Xrm.Utility.getGlobalContext();

  var baseURL = globalContext.getClientUrl();

  Xrm.Navigation.openUrl(baseURL+"/main.aspx?etn=importfile&extraqs=etc%3d4412&pagetype=entitylist&forceUCI=1")

}

I was wondering if any of these work arounds will help the users while the Engineering Group works on the feature for UCI?

Was this reply helpful? Yes No