DEVELOPERS FORUM - Extracting Data from Database for comparing two Part revisions

aravinth_r - Friday, April 6, 2012 9:05 AM:

Our primary intention is to implement BOM Comparison for comparing two parts. The comparison should show Quantity, Reference Designator and the Manufacturer Part number for the children. User should also be able to export the comparison to an excel.

The Structure browser coming with OOTB supports BOM Comparison but does not provide information on Quantity and Reference Designator. And it does not have export to excel.

So, we are planning to develop a custom java utility to get the name of the part revisions from the user, extract the data out of ARAS, compare it using Java logics and report it in an excel.

I will require help in how to connect to the ARAS database externally and extract data out of it. Can anybody help?

Regards, Aravinth

fli - Wednesday, April 11, 2012 8:07 AM:

hi, 

You can use this:

string innovatorServerUrl = "__.__.__.__/.../InnovatorServer.aspx";

            string database = "XXXXXX";

            string userName = "admin";

            string password = Innovator.ScalcMD5("innovator");

            //MessageBox.Show("startet");

            HttpServerConnection httpConnection = IomFactory.CreateHttpServerConnection(

              innovatorServerUrl, database, userName, password);

            httpConnection.Login();

Innovator innovator = IomFactory.CreateInnovator(httpConnection);

/ Christoffer

aravinth_r - Thursday, April 12, 2012 2:53 AM:

Hi Christoffer,

How do i run this code? From which IDE I should run this? Can you please help?

fli - Thursday, April 12, 2012 4:25 AM:

 Hi, 

You can use any IDE, I use Microsoft VS

Reference the IOM.dll, execute the query, then you got the data

Else, you can have the java run in a HTML field in an Aras form

/ Christoffer

aravinth_r - Thursday, April 12, 2012 5:11 AM:

Hi Christoeffer,

Thanks for the reply. I am trying to run it from an eclipse code. What is the extension that I should use to save this code? Also, how do i reference IOM.dll?

Can you kindly explain me in detail how this is done? Thanks in advance!

Regards, Aravinth

aravinth_r - Thursday, May 17, 2012 2:42 AM:

Hi Christoffer,

When i try to reference the IOM.dll, I get the following error:

Can't add reference to the specified file.

I use the IOM.dll that I got from the Aras InnovatorInnovatorClient.

Please help me in understanding how to refer the IOM.dll file. Thanks

Regards, Aravinth

fli - Thursday, May 17, 2012 5:35 AM:

Hi Aravinth,

also try this. 

for your csproj file set target framework to .net 4.0 NOT .net 4.0 client    

then.

To add a reference in VS Visual C# or Visual J#

Brian - Monday, May 21, 2012 9:43 AM:

Hi Aravinth,

Can you run .Net code from eclipse? I didn't think you could.

The instructions that Chirstoffer is giving are for Visual Studio.

Cheers,

Brian.

aravinth_r - Tuesday, May 22, 2012 8:37 AM:

Hi,

I was able to find the IOM.dll from the Aras Innovator/Innovator/Client/cbin and I ran the following command from the command prompt

regasm <Path to IOM.dll>/IOM.dll /tlb /codebase /verbose

After the execution of the this command, I opened the excel sheet and navigated to the Developer Tab - View Code - Tools - References and selected ARAS 9.2 - IOM.API

After I selected and referred the IOM.API, I am able to use the ARAS API. Thanks for all your help

Regards, Aravinth