Plug-ins

I want to click on card choice fields, can someone tell me what script should I write? The following is the card choice field that we are using a!cardChoiceField(label: "Activity Choices", labelPosition: "COLLAPSED", data: local!activities, cardTemplate: a!cardTemplateTile( id: fv!data.zlkActivityType, primaryText: fv!data.zlkActivityType, icon: choose( fv!index, "briefcase-medical", "microphone", "briefcase-medical", "microphone", "microphone", "briefcase-medical", "microphone" ), showWhen: isnull(fv!data.zatParenttype) ), value: local!selectedActivity, saveInto: local!selectedActivity, maxSelections: 1, align: "CENTER", showShadow: true )

Need to read the data from the excel and save it into an variable

Hi, We have a project requirement where we need to pass an array of images into a grid, each row with a different image. The grid is already configured, but we can't seem to manage to pass dynamically an array of images into the grid - they are appear repeated across all rows and for each row, we want the image that corresponds to that row position. For row 1, we want image 1, for row 2, image 2... Current output Expected output Currently, we are defining the barcode image column like this: And the node is configured currently as: My suspicion is that Appian can't iterate automatically throughout the array and position each image in each row but I'm not really sure how this can be achieved. Kind regards

Hi Team We use the jsonvalidator_isvalid() function to validate if the given text is in JSON format or not and then we use a!fromjson() function to format it. We get "true" boolean value in output for jsonvalidator_isvalid() function but a!fromjson() gives us error : "The jsonText parameter was not valid JSON." We also get  "true" boolean value in output for isjsonvalid() function. How can we resolve this? Appian version 21.1 Text used for validation is in format similar to the one mentioned below :  "You have issue:test to fix." "Test Description:" "test issue..." "For more details login to site" NOTE : We also have valid json texts, null texts and string values to validate.

We are using MS Graph plugin to read emails and save the data into APP_MAIL_POLLER table but nothing gets populated for field "BODY_ HTML".  We have followed the instructions of the plug-in in regards table structures. When setting the node in a process model, for Content Type input parameter we are trying with "Both" and "HTML", but same results, no value for "BODY_HTML" field. Any ideas on what to try?

Hi all, from the admin console, i went to the plug ins, i deployed a few plug ins but how do i access these? So far i couldn't see them in the pallette view in designer mode. 

We are trying to get the token out of the Client API in the Connected System from the Component. We need the username or any user details to generate the token for those requesting the token from the Component. We can send the logged-in user information in the payload of the request, but due to security concerns, we shouldn't pass any user details in the request. Is there any way that we can get the requester details from the Connected System? We tried getting a username from ProxyConfigurationData(Java object) got from ExecutionContex(Java object). It returns a null value if a proxy is not configured. We didn't get any user details from the SimpleClientApiRequest object. Please let us know if there is any other way or workaround to get the requester details from Connected System. Also is there any possibility that we can get requester details in servlet? Thanks, Santhosh Kumar A

Hi All, Anybody faced this KB-1097 error .can you please tell me how can we fix this .In knowledge base i can see only limited details Thanks in Advance

Hi, I have a requirement  to export and download an excel file with more than 50 columns. As the Appian OOTB functionality allows to export only 50 columns I tried using the plug-in "Excel Template Merge" - Append Sheets smart service. But the downloaded file is not an excel file even though the result parameter doesn't contain any error. If anyone has a solution, please let me know.

Hello, Is it possible to embed an image (dynamically) with excel while using Export Datastore Entity to Excel Smart service or Export SQL to excel? Regards, Priyajit

When the editor loads for the 1st time, whether passing in anything (valid HTML, text) to richTextValue via local variable or rule input, the editor does not display the value. As soon as designer edits the SAIL, e.g. remove the richTextValue parameter and undo (ctrl-z), or toggle isReadOnly, the value is displayed., Usage bar shows % as >0, so it seems to think that there is value there, but is not displaying them. Steps to reproduce: Create new UI object, and add Advanced Rich Text Editor component Create a rule input of type Text Set richTextValue to rule input Supply a text value, e.g. "Hello" as rule input, set as default value Save object and close Open object - observe that "Hello" is not shown on load Toggle to Expression Mode, delete richTextValue parameter, and undo (ctrl-z) - observe that "Hello" is now displayed this comment is from [mention:33845a86f6114d5582c6d5fb658efbe2:e9ed411860ed4f2ba0265705b8793d05] and i have the s

Hi All, We have a requirement to read login audit files from all the application servers on a High Availability cloud environment. We have researched about the plugin 'Log Reader' which can read login audit files. However, from the discussions on its AppMarket page, we are unsure if it can read the log files from ALL the application servers, and not just the default one. We have also seen a note about its latest version which reads 'This version is to support HA environment'. However, we could not determine the exact steps required to read the log files from all the HA nodes. Has anyone actually implemented a similar feature using this plugin? If so, please share how you managed to read the log files from all the HA nodes. Many thanks!

Hi Team, I almost have 2 Lakhs records and 134 columns to export into excel sheet from the Appian database. I am already using Export SQL to excel as Export data store entity to excel doesnt allow me to export more than 50 rows. when i do this it exports till certain set of data for example 1 Lakh records. But after that it is not exporting the data. I tried exporting them in batches of 5000. so first 5000 will be exported into a template. and the next 5000 the output of this will become the template. we tried merging of Excel sheets to but it also fails after 10 Excel sheets. Is there any other better way to do this please. TIA [emoticon:c4563cd7d5574777a71c318021cbbcc8] Harsha

we have an requirement where we need to populate some fields from pdf using fill pdf smart service.fields not having special character or symbol are populating successfully but fields those are having special character unable to populate.so anyone can help to resolve this issue.snippet for the code are as below. { {name : "County", value : "Adam"}, {name : "Parcel No", value : "98765"}, {name : "Price/Consideration", value : "77777"}, {name : "Doc. 1 â`“ Grantor(s) Name(s)", value : "Mike"} }

Hi community, ProcessDesignService pds = ServiceLocator.getProcessDesignService(sc); TypedValue tv = pds.evaluateExpression(expression); pds.evaluateExpression(expression) is giving the following error: The type com.appiancorp.process.expression.ExpressionEvaluationException cannot be resolved. It is indirectly referenced from required .class files I am not sure what jar file is required to be included on the build path to resolve this error. Appreciate if someone could please let me know the details. Thanks, Arun

Hi , We want to develop customized card layout component with custom styling, this layout should allows other APPIAN sail component  as contents inside it as Appian card layout allows . Is there any possible way to achieve it by creating component plug-in ? 

Hi, we are using on-premise dev environment. We want to create our own custom button with some different style. Could you please suggest what all methods need to be implemented and how to register plug-in to our own environment without registering it to Appian App marketplace? Can it be achieved from Appian web designer as server access will be limited? 

Hey everyone, is there a way to automatically retrieve the XMLs of objects (Integration objects in particular) of an application?

Hey, I am using the TypeService interface and calling the getType() method to return Appian DataType value for a CDT passed into a smart service. cdt variable is of class TypedValue Long cdtTypeId= cdt.getInstanceType(); Datatype cdtType= ts.getType(cdtTypeId); But I get this error.. The type com.appiancorp.cache.CoupledValue cannot be resolved. It is indirectly referenced from required .class files This shows up in in the IDE during build for the line ts.getType(cdtTypeId). Does anyone know what is needed to get this to work. Or another way to get Datatype from the TypedValue class

Hi I have an excel file contains data as shown above. I want to update the calendar by reading the excel file by programmatically or using any plugin. Is this possible? if yes, how? Thanks. 

Hi, We are using Import Excel to Database plugin to import data to Oracle DB. We are facing issue related to the primary key auto generation. We have sequence to autogenerate the primary key. But while using the plugin, we are facing the below error "???ORA-01400: cannot insert NULL into (Table_Name.Primary_Key)???". When we are trying to have a column of primary key with value, its working fine but auto generation of primary key is not happening. Is there any limitation to the plug-in? 

Hi team, can any one please suggest me the steps or any link  to download the  plug-ins of  time line chart and  google chart component in my application and how to show Gantt chart data in interface  i am not understanding from where to start

Hi all, I have a requirement to retrieve the list of applications and display for each user the applications that he can view them. Any ideas ?

Hi  My dataset has multiple entries of working and non-working days in excel. I want to update the working and non-working days in a calendar. I am reading excel file using readexcelsheet paging function and generating calendar process variable by using read calendar method . While iterating the rows in excel as an output it just updates the first row only. How to read all the rows in excel.

We have a requirement to embed excel on the Appian UI and this Online Office Integration Plugin seems to be useful for us. However, we are getting below error   I know this might be a silly question , from where we get WOPI Client URL. If anybody has already implemented this can you please help us here. We are trying to do a short POC so that we can show it , we are using our own office 365 account for testing purpose.