{"id":9,"date":"2011-03-16T11:33:00","date_gmt":"2011-03-16T09:33:00","guid":{"rendered":"https:\/\/blog.avxt.fr\/fr\/master-data-services-getting-errors-out-of-a-modelmembersbulkupdatemerge-with-api\/"},"modified":"2011-10-16T13:08:09","modified_gmt":"2011-10-16T11:08:09","slug":"master-data-services-getting-errors-out-of-a-modelmembersbulkupdatemerge-with-api","status":"publish","type":"post","link":"https:\/\/blog.avxt.fr\/fr\/master-data-services-getting-errors-out-of-a-modelmembersbulkupdatemerge-with-api\/","title":{"rendered":"Master Data Services : Getting Errors out of a ModelMembersBulkUpdate\/Merge with API"},"content":{"rendered":"

<\/span><\/p>\n

In fact, you can get the error codes on MDS website : in \u00ab\u00a0Integration Management\/Staging Batches\u00a0\u00bb clicking on the batch you want and clicking on button \u00ab\u00a0view details for selected batch\u00a0\u00bb<\/span><\/div>\n
in order to do the same thing with API (get error codes), you’ll need to get back the batch after <\/strong>it is inserted. <\/span><\/div>\n
\"\"<\/div>\n

<\/span><\/div>\n
<\/div>\n
\n
\/\/get information related to a staging batch<\/span>
 public<\/span> Collection<StagingBatch> StagingGet(Collection<Identifier> stagingBatch, bool<\/span> ReturnAllCriteria, bool<\/span> ReturnMembers, bool<\/span> ReturnAttributes, bool<\/span> ReturnRelationShips, ref<\/span> OperationResult or)
 {
 Collection<StagingUnbatchedInformation> colUnbatched = new<\/span> Collection<StagingUnbatchedInformation>();
 Collection<StagingBatch> colBatches = new<\/span> Collection<StagingBatch>();
 using<\/span> (ServiceClient c = MDS_WSConnect.CreateMdsProxy())
 {
 or = new<\/span> OperationResult();
 colBatches = c.StagingGet(new<\/span> International(), true<\/span>, new<\/span> StagingResultCriteria() { All = ReturnAllCriteria, Attributes = ReturnAttributes, Members = ReturnMembers, Relationships = ReturnRelationShips },
 new<\/span> StagingSearchCriteria() { StagingBatches = stagingBatch, StagingDataStatus= StagingDataStatus.All<\/strong> }, out<\/span> or, out<\/span> colUnbatched);
 List<string<\/span>> lstErr = new<\/span> List<string<\/span>>();
<\/pre>\n<\/div>\n
\n
\/\/...do what you need with the error collection<\/span>
<\/pre>\n<\/div>\n
\n
foreach<\/span> (<strong>StagingBatchError err in<\/span> colBatches.First().Errors<\/strong>)
<\/pre>\n<\/div>\n
\n
{
 lstErr.Add(err.ErrorCode + \" - \"<\/span> + err.TargetCode);
 }

 return<\/span> colBatches;
 }
 }
<\/pre>\n<\/div>\n
so, complete process would be:<\/div>\n
<\/div>\n
\n
DateTime dtBefore = DateTime.Now; 
OperationResult or = new<\/span> OperationResult();
  \/\/filling new staging batch with entityMembers<\/span>
  Collection<Identifier> colStaging = ModelMembersBulkMerge(colEntMembers);
  \/\/initiating the staging process (not sure I really need that here in fact)<\/span>
  Collection<StagingBatch> colBatches = StagingGet(colStaging, true<\/span>, true<\/span>, true<\/span>, false<\/span>, ref<\/span> or);
  \/\/triggering staging<\/span>
  ProcessUnbatchedStaging(pModelId, pVersionId);

  DateTime dtAfter = DateTime.Now;
  TimeSpan ts = dtAfter.Subtract(dtBefore);

  MessageBox.Show(\"members (bulk) inserted : \"<\/span> + colEntMembers.First().Members.Count() + \"\\r\\n\"<\/span> + \"time elapsed (seconds):\"<\/span> + ts.TotalSeconds.ToString());
  \/\/get back the batch to see if any errors <\/span>
  
  colBatches = StagingGet(colStaging, true<\/span>, true<\/span>, true<\/span>, false<\/span>, ref<\/span> or);
<\/pre>\n<\/div>\n
note: StagingDataStatus= StagingDataStatus.All –> get all including Errors<\/strong><\/span><\/div>\n
<\/p>","protected":false},"excerpt":{"rendered":"
In fact, you can get the error codes on MDS website : in \u00ab\u00a0Integration Management\/Staging Batches\u00a0\u00bb clicking on the batch you want and clicking on button \u00ab\u00a0view details for selected batch\u00a0\u00bb in order to do the same thing with API (get error codes), you’ll need to get back the batch after it \u2026  Continue reading → <\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[14],"tags":[],"class_list":["post-9","post","type-post","status-publish","format-standard","hentry","category-mds"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/posts\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":5,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/posts\/9\/revisions"}],"predecessor-version":[{"id":212,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/posts\/9\/revisions\/212"}],"wp:attachment":[{"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/media?parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/categories?post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/tags?post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}