General

How to read the cell locked and password protected excel(with multiple queries in it) to save it in db

Hi community, Don't know where to report this, so used the forum.In the exercise there is a variable declared like: local!purchaseOrder: rule!VOF_GetPurchaseOrderLineItemsByEntityId(),Instead of  rule!VOF_GetPurchaseOrderLineItemsRecordByEntityId(). Both in the excise and in the answer. VOF_AdvExpP1_L3_ExA_Answer This results in this error: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error in rule 'vof_orderlineitemgridview' at function a!textField [line 6]: Could not cast from List of Variant to VOF Order With Line Item. Details: CastInvalidCould not cast from List of Variant to VOF Order With Line Item. Details: CastInvalid. Kind Regards, Erik

HI I have changed name of PM but in instance it's coming old PM name how can i change instance name to new PM name? Instance  PM  Thanks 

Hi, can anyone let me know the meaning of infinity and why it is coming in the instances.  Thanks 

Hi, I am getting this error in process model

Hi  How to Enable Import package button in community edition i need for import IDP new version

I installed Appian version 21.4.340 and followed the quick installation guide. I was able to go onto the localhost site but when I tried to run the process model the flow is always stuck on the start node. When I start the Appian engines I notice the execution engines and process design are in stopping state. I tried using the engineRestart.bat but the result was the same. If anyone else ran into this issue or know how to resolve this please and Thank You. Waiting for services to start... analytics00 in RUNNING state, PRIMARY mode analytics01 in RUNNING state, PRIMARY mode analytics02 in RUNNING state, PRIMARY mode channels in RUNNING state, PRIMARY mode content in RUNNING state, PRIMARY mode download-stats in RUNNING state, PRIMARY mode forums in RUNNING state, PRIMARY mode groups in RUNNING state, PRIMARY mode notifications in RUNNING state, PRIMARY mode notifications-email in RUNNING state, PRIMARY mode portal in RUNNING state, PRIMARY mode execution00 in STO

Hi I am getting this UI error, but all values are correct only

Hello How long does it take to get the certificate updated on profile after giving ACD exam? I gave the exam yesterday and at end saw as PASS.  Its been a day but don't see that reflected on profile nor got any email from aAppian or examity either with a pdf or stating pass It was proctored exam. 

Hi, I have created a Appian DocuSign Connected System but my token gets expired every 8 hour and I did not find a way to refresh the token as well. Please help me with it. 

I have created new document channel after running after extraction error at reconcile process model  in node set var.

i have a requirement where I have to extract the data from a csv file to a cdt/database. Here row1 has fields and row2 has the values. Again 4th row has  few more fields and 5th row has the values. I tried using import to database v6 which works only for row 2.But I need to work for row 5 as well.

Can someone please help with the "Set search context" on Windows Automation Tutorial? The part of the workflow that Switch to Notepad sometimes works but does not work most of the time with this error message:  "The element could not be found". Below are the screenshots of the configuration set up:  Thank you in advance

Ref: KB-2204 Information about the Log4j2 security vulnerability https://community.appian.com/support/w/kb/2511/kb-2204-information-about-the-log4j2-security-vulnerability-cve-2021-44228 As all AppMarket plugins are open-source, customers also have the ability to inspect and update independently (and can publish their updates  We may use 1000s of plugins for our app, what would be the best approach to inspect to identify whether the specific plugin file uses Log4J and what version of it to confirm its affected by CVE-2021-44228 vulnerability? Is there any recommended tools / steps available please? Thanks

Do the original hotfixes on the 11DEC cover nvd.nist.gov/.../CVE-2021-45046

How can we use appian service instead of google cloud service for classification and extraction in appian idp

Hi All I am using Jmeter 4.0 , when I pass correct post request from Jmeter to Appian I am not getting correct response and due to this issue further tests are failing , this is happens randomly.

a!localVariables( local!seg, loca!nombre, local!apellidopat, local!apellidomat, local!buc: 00000121 local!buc: 00000187, a!textField( label: "BUC/NÚMERO DE CUENTA/NÚMERO DE TARJETA", labelPosition: "JUSTIFIED", instructions: "", placeholder: "Ingresa los datos a buscar", value: ri!busqueda, saveInto: {ri!busqueda, if(local!contador <= 17,{ a!save(local!seg,rule!PE6A(local!buc).result.body.partyRec.partyInfo.serviceLevelDesc), a!save(local!nombre,rule!PE6A(local!buc).result.body.partyRec.partyInfo.personPartyInfo.personName.givenName), a!save(local!apellidopat,rule!PE6A(local!buc).result.body.partyRec.partyInfo.personPartyInfo.personName.paternalName), a!save(local!apellidomat,rule!PE6A(local!buc).result.body.partyRec.partyInfo.personPartyInfo.personName.maternalName) /* realiza la busqueda por numero de Tarjeta */ }, if(local!contador < 12, { a!save(local!seg, rule!PE6A(local!buc2).result.body.partyRec.partyInfo.serviceLev

Hi Community, I followed the Appian quick start installation guide, and ran all commands:  <APPIAN_HOME>\services\bin\start.bat -p <password> -s all <APPIAN_HOME>\data-server\bin\start.bat <APPIAN_HOME>\search-server\bin\start.bat <APPIAN_HOME>\tomcat\apache-tomcat\bin\start-appserver.bat Everything ran successfully, but when I went to my browser and navigated to http://<FQDN>:8080/suite/design/users, it wasn't connecting, tried different browsers same result. I replaced the FQDN with what I entered in conf.suite.SERVER_AND_PORT= and it is un-commented so is conf.suite.SCHEME=. I'm not sure what else could have went wrong. If anyone have resolved a similar issue your input would be most welcome. Thanks, Eric

Hi, I am facing an issue while importing applications into different environments due to nested CDTs. Getting error "An error occurred while creating datatype [uuid={urn:com:appian:types:ADMIN}ADMIN_DF_PI_createConfig]: The XSD could not be imported because it references a missing type: {urn:com:appian:types: Q1}ADMIN_DF_PI_resource. No types have been imported. (APNX-1-4049-001) (APNX-1-4071-007)" here ADMIN_DF_PI_createConfig is parent CDT, and ADMIN_DF_PI_resource is child CDT, both are existing in the same application Due to this remaining CDTs also not imported "The datatype [{urn:com:appian:types:ADMIN}ADMIN_CRE_siteDetails] could not be transported. Cause: The data type [{urn:com:appian:types:ADMIN}ADMIN_CRE_siteDetails] could not be imported because another data type failed to import. In order to ensure consistency, unless all data types inside and outside the package successfully import, no data types are created or updated. (APNX-1-4071-019) (APNX-1-4071

Hi  I want to record my own voice and play it via button or link. is that possible?

    How to remove values in this grid?

Hi , My requirements are i need to get the above images based on the no of listing id's i have. I also need to get  the address  and price and all details should be dynamic also . Can anyone please help me out here .  Below i have attached my  code  a!localVariables( local!houses:rule!SHA_qe_getDocuments( entityId: index(ri!Document,"entityId",null) ), local!address:rule!SHA_qe_toGetPropertyAddressDetails( listingId: ri!listing.listingId ), local!listingData:rule!SHA_LISTING_EXPRUL(listingId:ri!listing.listingId), local!numCols: 3, local!selectedCard, local!selectedInterface, { a!columnsLayout( columns: a!forEach( items: enumerate(local!numCols)+1 , expression: a!localVariables( local!colIndex: fv!index, a!columnLayout( contents: { a!forEach( items: local!houses, expression: a!cardLayout(

Hello,  I am thinking how I can achieve something like this with seal only,  a!localVariables( local!data: if( isnull(local!a1), updatedictionary(), /* Second Condition */ if(isnull(local!b1), ), ), null ), local!data ) basically if condition for null value, if it is null exit, if it is not null do action and that check next value, problem is that in the if there are condition, true(), false()) where it does not allows a action with another if inside the result part.  Any idea which is the best approach ?

Hi Friends, Logically how to change the date field mm/dd/yyyy to dd/mm/yyyy. Tried many way but to me not getting correct answer. Please share your ideas.