Tuesday, 02 April 2024
  0 Replies
  167 Visits
-1
Votes
Undo
What are the parameters of the ImportUpdateItemsPDM RunAutomation? Have the parameters been changed lately?
I am running the automation with the following parameters

string sExcelfile = @"C:\Users\INRADON1\Desktop\test1 3.xlsx";
// Assuming the following variables are defined:
string sStartObjectID = EbaseApp.ActiveProject.Id;//"00000000-0000-0000-0000-00000034B2DC";
int lCoverID = 0;
int lTypeID = 0;
string sMapping = "From Cabinet";// "G_Artikel";
string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"" + sExcelfile + "\";Extended Properties='Excel 12.0;HDR=Yes'";
string slTableName = "Sheet1$"; // Table name in Excel sheet
int lStartRow = 2;
int lMode = 1; // Update Mode (0=All/1=Update/2=New)
var oMacro = EbaseApp.Automation;

oMacro.Parameters.Clear();

oMacro.Parameters.Add(sStartObjectID);
oMacro.Parameters.Add(lCoverID);
oMacro.Parameters.Add(lTypeID);
oMacro.Parameters.Add(sMapping);
oMacro.Parameters.Add(sConnection);
oMacro.Parameters.Add(slTableName);
oMacro.Parameters.Add(lStartRow);
oMacro.Parameters.Add(lMode);

oMacro.Run("ImportUpdateItemsPDM.Wizard.RunAutomation");
oMacro.Parameters.Clear();



The following error is prompting multiple times: attached

I set the priority to critical since our customer has to confirm the error message several times.

Thanks for your help