Plug-ins

There is a database table where user can write into. I need to generate a dynamic template using the data from the table. Meaning I have a button or a link, whenever user click it, the latest template should be generated and downloaded. 2. And I want one of the column to be populated with a dropdown and user can only choose value from the dropdown, which also means the excel should be protected. Can we generate protected excel with only specified cells that can be edited How can I implement this?

Hi, I'm using readexcelsheetpaging() to read an excel, it has a blank row so I want to set stopReadingAtFirstBlankRow: false But I got following error: Expression evaluation error at function 'readexcelsheetpaging' [line 26]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=26,v=0] as java class java.lang.Integer. But when I removed stopReadingAtFirstBlankRow it works fine.

Hi, When I was reading an excel file uploaded by user, how can I identify the max row that has values? Otherwise if I read to the row that has no values I'll get error, I'm using excelreadcellsbynumber()

I am trying to move the file into file system by creating a folder on the destination path. I am passing folder parameter using constant. This is moving file in file system but not creating folder. Please guide me what I should configure so that it will create folder and move file in it. ++[mention:9a3c4b933d674b319102bb3e59083770:e9ed411860ed4f2ba0265705b8793d05] 

Hello, I have an issue with the map, which just won't appear in the interface. I had this issue a month ago, when I couldn't see the map, but my colleague did. A couple of weeks later the situation was the opposite (I saw the map, but my colleague didn't). Now the problem is worse - none of us sees the map...

Hi Appian Community! Does anyone have good recommendations for replacements for the unsupported plug-in Republish Model as Different User? My organization uses it in lower environments whenever an individual developer modified a process model and daily, there is a scheduled process that republishes all the modified process models as a service account to prevent issues of process models being "stuck or frozen" when a developer leaves and their account becomes inactive. TIA

Hi,  I am running into this error  "An error occurred in executing an Activity Class."  while attempting to Export Data Store Entity to Excel (smart service). We are only facing this issue only in one of our ENV after upgrading from 22.3 to 24.2 (On-prem). I have checked to see if the PM and datastore is published, no strings are used in pointing the Datastore entity. Please help me understand this.

I am looking to make some changes to the MS Graph Mail Poller plugin ( [mention:52a1e126f08841948bffc2d3bceb5e2a:f7d226abd59f475c9d224a79e3f0ec07] ) and came across an issue between 24.3 and 24.2.  The plugin makes use of the ContentUploadOutputStream class, which exists in 24.2 (https://docs.appian.com/suite/help/24.2//api/com/appiancorp/suiteapi/content/package-summary.html) but does not exist or is not accessible in 24.3 (https://docs.appian.com/suite/help/24.3/api/com/appiancorp/suiteapi/content/package-summary.html) and there is no mention of it being deprecated.  Along with that, the UploadDocument method on the ContentService interface still returns a ContentUploadOutputStream object (https://docs.appian.com/suite/help/24.3/api/com/appiancorp/suiteapi/content/ContentService.html#uploadDocument(com.appiancorp.suiteapi.knowledge.Document,java.lang.Integer)). It seems like this is a bug and the ContentUploadOutputStream class should stil

Hello Everyone, We have a requirement to unzip/extract a .gz file, any ideas on how can this be achieved. Thanks

When I am trying to use the adobe plugin onto on-prem env it is throwing below error: While with the same integration key it is working fine on cloud env. Does anyone  have any idea how we can fix this

I have a file that have around 80000+ records and size is around 35MB. I would like to understand the way to read the data in it but need paging to be part of the process as i want this to be inserted into DB.

Hi All,   I have a template document where it has 3 statements and then a table which will display data . But if the data is empty, the table header is also not displaying . But I need the output doc to display the template. table with header row showing no data available. Is this possible, Please suggest some solutions. a!localVariables( local!queryXML: if( toboolean(ri!isFormat)=true(), ri!data, a!forEach( items: reject(fn!isnull,{ri!data}), expression: "" ) ), if( a!isNullOrEmpty(ri!data), "", if( toboolean(ri!isSplit)=true(), local!queryXML, ""& ""&ri!product&""& ""&rule!DIL_testNewDateFormat(date: ri!dateFrom)&" to "&rule!DIL_testNewDateFormat(date: ri!dateTo)&""& ""&ri!type&" listing"& if( ri!type = "Unblinded", "Unblinded Safety Data : Do not share with blinded study personnel", "" )& local!queryXML& "" ) ) )see attachment/resized-image/__size/640x480/__key/communityserver-discussions-

I am using one function readcsvlogpagingwithheaders to read login-audit.csv file and this function is working fine in lower enviroment and reading all the data but in prod we have 3 servers and its reading log data from all the 3 servers but not reading all data. Any idea or has any one faced this issue before? Thanks in advance.

Hi Team,    We are using CSV Parser Plugin smart service in our project currently it is going to deprecated in few days is there any alternate smart service or function for replacement please suggest.

I am updating a custom plugin that utilizes the Knowledge Document Type and uses the getInternalFilename() to get the absolute path of the document. That function has been deprecated, what is the preferred replacement, as I still need the absolute path of the document. Would getExternalFilename() return a similar value. 

Using plugin DOCX From Template to generate word doc and using image bookmark to display image, how can we display image conditionally, it should display image if i pass any image data from PM.

I want to edit the group's membership rules dynamically from Appian UI, do we have any smart service/function available to achieve the same? Thank you in advance.

Hello, I looked at the updates version of the Pinecone connected system V3.0, the embedding model is hardcoded to text-embedding-ada-002. Is there a way to make this configurable, so we can pass other models?

Hi, Iam getting error “An error occurred in executing an Activity Class” for ‘Docx from dynamic template”smart service .The plugin which used needs to be updated.Is the issue will resolve after updating this plugin?If its not please help me to resolve this as we faced this issue from aug 19 onwards and it is working fine before that, Attached the screenshots of node outputs ,node inputs ,system logs for reference.

Hello Team, As you all know that few of the functions from 'People Function' plugins are deprecated and can be removed at any time. Can you please help me with the replacement of functions with Appian out of box function. Below if the list of functions which have been used in our code, aregroupsaddedbyruleareusersaddedbyruledoesuserexistgetadmingroupspaginggetadminusersdirectpaginggetadminuserspaginggetallgroupsnamesgetdirectadmingroupidsgetdirectgroupmemberuserspaginggetgroupprofilegetgroupuuidgetmembergroupsdirectpaginggetmembergroupspaginggetmemberusersdirectpaginggetmemberuserspaginggetuseruuidgroupprofilerecordtypesourceisusermemberofallgroupsvalidatenameforuser Please let us know if anyone has already implemented code to replace above functions.

Hi All,  We are currently on Kafka version 2.6.2 and using the Kafka Tools plugin(1.4.1). we are planning to migrate to Kafka version 2.8.2 or higher. I would like to know if the plugin supports this version. Thanks!!

Hi , Is there any plugin to convert html file to docx file? I see document utilities (plugin from aspose) says they have this option. But they only have docx to html but i need the vice versa.

Hi,  I am currently working on a use case  that requires the generation of JWT tokens based on PKCS#8 standards.  I've chosen JWT plugin for this task. However, it seems that this plugin is compatible only with private keys that are based on PKCS#1 (RSA) standards. Is there any known workaround  to fulfill this requirement ?   Thanks, 

Hi people. I'm in need of a solution for this situation: I'm using the OSM map component and I need to render a polygon / region in the map by passing a list of coordinates.Basically, a user can select from a list of regions. When the user selects region X, the map updates and shows the region X.Sadly I can't find a way to render polygons with this plugins, I can only render markers individually.

Hi All, I'm using the Aspose plugin for converting DOCX to PDF, specifically the Convert DOCX to PDF feature. The original DOCX file uses the Open Sans font, but when converting to PDF, the font formatting changes. The plugin has an input variable for font IDs, which is an integer. what could be Could  provide the font ID for Open Sans? Alternatively, is there a way to ensure that the PDF retains the same formatting as the DOCX? Thanks in advance!