SunilReddy さんのグループアクティビティ

How do you import Excel BOM data into Aras Innovator open version?

Veyzo — Tue, 05 Jan 2021 23:13:59 GMT

Hello, I currently use the open, free version of Aras Innovator and am having difficulty figuring out how to store BOM data within the tool. I have seen from other posts that subscribers have access to a direct import functionality and also some kind of batch loader. For the latest free version of ARAS, what are the exact steps to import an excel file containing BOM data into Aras? Any help would be greatly appreciated.

Aras 12: Error: Cannot access OAuth Server due to 500 (Internal Server Error)

SunilReddy — Fri, 14 Jun 2019 06:51:47 GMT

Hi,

We are getting an error as "Error: Cannot access OAuth Server due to 500 (Internal Server Error)" while accessing Aras12. Please help me how to resolve this error.I'm attaching screenshot for your reference.

Thanks

Sunil

How to get the relationship count before the parent itemtype save

tenny — Fri, 05 Feb 2021 06:38:55 GMT

Hello everyone,

I need to check that user has added at least one relationship before save base on some item types fields， anyone know which event I should use and how to do that? Example is just like the picture below.

Not a single item

hkhan — Tue, 09 Feb 2021 04:26:15 GMT

I wrote down the following to get data from a relationship and insert it in an item type but unfortunately im having the following error

I dont see an issue with my logic if someone can take a look i would really appreciate it.

Not a single item

Item ecrtask = this.newItem("ECR Task", "get");
ecrtask.setProperty("source_id", this.getID());
ecrtask = ecrtask.apply();

for(int i=0; i < ecrtask.getItemCount(); i++)
{
Item relDoc = ecrtask.getItemByIndex(i).getRelatedItem();
string title = ecrtask.getProperty("vsy_title","");
relDoc.setProperty("vsy_title",title);
string relDocid = relDoc.getProperty("id","");

string sql = "update [innovator].[VSY_Task] set vsy_title = '" + title + "' where id = '" + relDocid + "'";
Item result = inn.applySQL(sql);
}

Item action permissions based on item state

VicBazzi — Fri, 29 Jan 2021 14:03:06 GMT

Hello,
Is there a way to restrict permissions on an item Action based on the Item state. Gray out the action if the Item state is 'Preliminary'. Enable the Action if the state is 'Released'.

Technical document PDF publication Conversion task error

Suhas — Thu, 21 Jan 2021 14:10:26 GMT

Hello All,

While publishing Technical Document in PDF format I'm getting below error:

Aras.ConversionFramework.Exceptions.EventCallbackErrorException: See inner exception for details: ---> System.Exception ---> System.Web.Services.Protocols.SoapHeaderException: An error occurred creating the configuration section handler for ConverterSettings/PdfPublishingConverter: Could not load type 'Aras.Publishing.Configuration.PdfConverterConfig' from assembly 'System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' (C:\12_Aras_New\ConversionServerConfig.xml line 8)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.EndInvoke(IAsyncResult asyncResult)
at Aras.ConversionFramework.Proxy.ConversionService.EndConvert(IAsyncResult asyncResult) in C:\Builds\CI\14740\Innovator.git\CompilableCode\_CommonFiles\ConversionService\ConversionService.cs:line 85
at Aras.Server.Core.InvokeStandardConverter.ConvertCallback(IAsyncResult ar) in C:\Builds\CI\14740\Innovator.git\CompilableCode\Core\InternalMethods\InvokeStandardConverter.cs:line 131
--- End of inner exception stack trace ---
at Aras.ConversionFramework.Models.ConversionTask.<>c__DisplayClass40_0.<OnConvertCompleted>b__1() in C:\Builds\CI\14740\Innovator.git\CompilableCode\ConversionFramework\ConversionManager\Models\ConversionTask.cs:line 281
at Aras.ConversionFramework.Models.ConversionTaskEventHandler.Execute(ConversionTask task) in C:\Builds\CI\14740\Innovator.git\CompilableCode\ConversionFramework\ConversionManager\Models\ConversionTaskEventHandler.cs:line 143
--- End of inner exception stack trace ---
at Aras.ConversionFramework.Models.ConversionTaskEventHandler.Execute(ConversionTask task) in C:\Builds\CI\14740\Innovator.git\CompilableCode\ConversionFramework\ConversionManager\Models\ConversionTaskEventHandler.cs:line 185
at Aras.ConversionFramework.Models.ConversionTask.ExecuteEventHandlers(ConversionTaskEventType eventType) in C:\Builds\CI\14740\Innovator.git\CompilableCode\ConversionFramework\ConversionManager\Models\ConversionTask.cs:line 349

XML & HTML publication conversion is working fine.

Regards,

Suhas

Catch 'ItemCannotBeLockedException' when state=Released

Former Member — Wed, 14 Mar 2018 04:43:36 GMT

Hi, I'm trying to figure out how and where to catch the Aras.Server.Core.ItemCannotBeLockedException exception so I can display a custom error message to the users. The executed AML is: <Item type="MyCustomDocument" id="123134234234" action="lock" />. I have implemented "OnBeforeLock()" on my custom ItemType, but this method isn't hit when the ItemType is in Released state. So the question is at which stage in code is the exception thrown and can I sort of catch it or handle it?

loging failed Aras innovator 11 sp15

mouad — Mon, 14 Dec 2020 16:10:01 GMT

Hello All,

I do a successful installation using an existing database 'X' but I encountered an error :

When i restored the database 'X' and finished the installation, i run all the sql scripts without error except the first one:

Even if I mount the user innovator_regular from Sql Server, db => security => logins => right-click innovator_regular, go to properties, assign it to the database 'X' in the User Mapping property and run again the query successfully(see pic below). The probleme still persist when tried to logged in (Invalid object name 'LOCALE'.).

NOTE: i am able to connect using the InnovatorSolutions database.

How to query Content Property in Technical Documentation

SowmyaK98 — Thu, 15 Oct 2020 06:21:32 GMT

Hi Team,

Could you please explain how we can query 'Content' property in tp_Block itemtype.

As per my knowledge, all root and node elements along with id's will be wrapped up inside Content property/column in tp_Block table. If I have to find/fetch any id of certain elements like Title/Subtitle/Graphic, is there any way to achieve through Custom code? or should we have to write any SQL query in custom method.

Kindly help.

Thanks,

Sowmya

How can i configure email to send a report on a lifecycle

hkhan — Mon, 30 Nov 2020 21:12:01 GMT

I want to send a report using email notification on Aras how can i do that?

Different Sequence Number for different Classification

SowmyaK98 — Wed, 09 Dec 2020 09:50:39 GMT

Hi Team,

I have a scenario where in I need to generate different document sequence number - for Document Number field based on classification.

Ex : Class structure - Subtype - Class A - AXXX0001, Subtype - Class B - BXXX0001, Subtype - Class C - CXXX0001 - All these classification have different form configured and each form has Document Number field. Accordingly created respective custom properties with datatype - sequence and added datasource.

Is it possible to achieve generating sequence number without custom code? Kindly suggest. I am facing issue with configuration - while saving document, it shows all sequence numbers concatenated at header as 'Keyed_Name' which is not valid.

I am able to generate different sequence number based on classification by custom code added under server events - OnBeforeAdd.

Thanks,

Sowmya

Tech Doc : Rearrange content inside the Tech Doc Editor

SowmyaK98 — Thu, 10 Dec 2020 07:18:35 GMT

Hi Team,

Is it possible to rearrange the content inside the Tech Doc Editor in the left side TOC panel.

If I have wrongly inserted content and wanted to rearrange the position, can it be achieved using custom method or configuration?

Kindly suggest.

Thanks,

Sowmya

Tech Doc : Print Filename instead of ID after Publishing document

SowmyaK98 — Thu, 10 Dec 2020 05:47:47 GMT

Hi Team,

When we are trying to publish technical document in PDF format, after publishing it generates document and gets downloaded. Please find the attached screenshots

We have noticed that instead of Filename, it is having ID. Is it possible to change naming convention i.e instead of ID, can I publish tech doc with tech doc name as file name?

Any customizations required? or should we have to change existing code methods? Kindly suggest.

Thanks,

Sowmya

Disable Edit button

SowmyaK98 — Fri, 04 Dec 2020 07:10:54 GMT

Hi Team,

How can I disable Edit button in toolbar once document state reaches to Released? Is it possible to control it using permissions or do we need to write any custom method - OnFormPopulated event.

Please guide me.

Thanks,

Sowmya

What is equivalent to "SetAttribute" function in REST API?

Sathish — Tue, 17 Nov 2020 07:59:45 GMT

We have several server methods which expects custom attribute values using "getAttribute". While we can pass the property value in the API call, I am not sure how do we pass custom attribute values to the server method call??

SunilReddy さんの グループ アクティビティ

How do you import Excel BOM data into Aras Innovator open version?

Aras 12: Error: Cannot access OAuth Server due to 500 (Internal Server Error)

How to get the relationship count before the parent itemtype save

Not a single item

Item action permissions based on item state

Technical document PDF publication Conversion task error

Catch 'ItemCannotBeLockedException' when state=Released

loging failed Aras innovator 11 sp15

How to query Content Property in Technical Documentation

How can i configure email to send a report on a lifecycle

Different Sequence Number for different Classification

Tech Doc : Rearrange content inside the Tech Doc Editor

Tech Doc : Print Filename instead of ID after Publishing document

Disable Edit button

What is equivalent to "SetAttribute" function in REST API?

SunilReddy さんのグループアクティビティ