Plug-ins

I am having some issues with the LDAP tools ldapSearch function.   I have imported their app and use their ldapConfig function, passing the result into ldapsearch.  There seems to be very little documentation and I was wondering if there are any glaring issues with my parameters as I am filling them based on data i collected for the https://community.appian.com/w/the-appian-playbook/520/ldap-synchronization prerequisite section Below is a altered version of the parameters and the secure credential store.   I get the following error when passing it in.   "Unable to bind LDAP server ... ... Unable to find valid certification path to requested target." Below is the altered security store Anything obvious that seems out of place?  

Hi, tried using this tool and whilst totalRows is correct, it is returning no data. fn!readexcelsheetpaging( excelDocument: ri!spreadsheet, sheetNumber: 5, pagingInfo: a!pagingInfo(1,-1)) DataSubset startIndex1(Number (Integer)) batchSize-1(Number (Integer)) sortList of SortInfo - 0 items totalCount302(Number (Integer)) dataList of Variant - 0 items identifiersList of Variant - 0 items Has anyone else seen this behaviour or explain what I am doing wrong?

Hi While converting docx which has Arabic characters to pdf, Arabic characters are displayed as #### etc. When I test conversion java code in eclipse it is working without any issues. After I deploy it as a plugin it is not working. Any idea what could be the possible reason. Is there any alternative I can use to convert docx to pdf.  Note: I cannot use PDF from xslfo transformation due to limitation with the requirement

Hi Experts, Earlier we were using Export SQL to Excel for generating the Excel from the db having 387 columns. This particular service has got deprecated, how can we get this undepreciated or if there is any other workaround to generate the same. Tried using Export Data Store Entity to Excel but it not working beyond 50 columns, when trying to break the colomn into set of 50 and then trying to right in next 50 column the previous column data is getting deleted.

 I was using  plugin  getdatasubsetdownloadlinkfromprocess   to give export the data in excel to user on 1 click. Now its not working in 20.4. I also used a!exportDataStoreEntityToExcel() function but this need to work on 2 clicks it work in saveInto. Can anyone suggest any other method to provide user the export of dynamic excel. Thanks in advance

I have written a code to be used as a appian plugin using C#. Does Appian supports C# language ? If yes, how can I deploy the code written using C# ? Or do I need to convert the C# code to Java code ?

I need to store original file name into database of the uploaded excel sheet. Please suggest if we have any smart service or plugin for the same.

Please suggest any Smart Service or Plugin to create copy of any uploaded excel document. The copy of uploaded excel document should have same formatting and tabs than the original document.

Do we have any plugin or smart service to modify the excel sheet without loosing it's formatting? We have requirement to upload large excel sheet with around 20k rows and modify cells values without loosing it's formatting. Keeping in mind that excel sheet have multiple tabs with formatted data and once excel edit done, formatting should not be removed in any of the tab.  We have tried Export database CTD to Excel to modify excel but it is removing excel sheets formatting.

Hi All, Tried triggering a process model via mail. The process model is throwing an error while reading the document using readexcelsheet(). The document comes as an attachment and is stored in a folder. Getting below error while reading the same. I have given viewers right to the folder as well. Started by Guest.

We have a requirement to find when a user last logged into Appian Env. We found a plugin which gives result if a user has logged into Appian within last 30 days else returns null. But clients want minimum 6 month period or 180 days past login data. Is there any Plugin or functionality to find out if a user has logged in within last 6 months or similar period of time

Hi All, I am trying to read excel data using readExcelSheet() function to read and transform the data into cdt type to right it into DB. With less data its working perfectly fine but when the amount of data increases server goes down while reading the data itself. I tried using Import Excel to DB smart service but it seems to have so many limitations. Is there any way possible to read the data and store it in DB. Note: File have 385 columns which are mandatorily to be stored. File size is from 38-100MB.

Hi All, Need help on how to read data from an excel file, if the relevant data can be in any of the sheets in the file? For readexcelsheet() if sheet number 'x' does not exist it would throw an error, so how to traverse through sheets?

Using code similar to the following I'm finding that record user filters are not always clearing. |populate record type user filter|Filter1|with|Value||clear record type user filter   |Filter1           ||populate record type user filter|Filter2|with|Value||clear record type user filter   |Filter2           | Watching the script execution I can see that the field is focused and FitNesse tries to do something the clear fails. Sometimes it throws the following error "clear record type user filter An error has occurred: User Filter" but there is no more details on the cause FitNesseForAppian Release v20.2.1FitNesse Release v20200501

Hi All, Below is the issue we face while usinf SFTP plugins. The SFTP smart services are used in the application to receive files and post processing remove these files using Remove files over SFTP smart service. The process runs daily thrice where the files are picked up from different folders. The SFTP credentials , host , port used are same for all folders. Initially , in production all the folders did not have files at the same time. The files came in at different times so the scheduelers receiving the files and its removal were not impacted. Now a new folder is added and the files come into these folders at the same time and the process model instance runs simultaneously for 2 folders and thats when the error occurs. Even though the PM errors out at the Remove files over SFTP with the error as - 'Error removing file in the remote server. See application server log for more details. Error Message: Specified file path is invalid. '. Actually the files are remove

I ma trying to generate a new excel file with a dynamic table based on a template, I already tried passing a html table like this with no success <table border='1'><tr><th>Name</th><th>Department</th><th>Experience</th></tr><tr><td>John</td><td>Accounts</td><td>3 years</td></tr><tr><td>Philip</td><td>HR</td><td>5 years</td></tr><tr><td>Adam</td><td>Networking Services</td><td>2 years</td></tr></table>   any help? note: I am using this smart service beacuse it keeps the styles and formats from the template.

Hi Everyone, Is there any direct way to fetch the total no.of worksheets uploaded in the excel document and also what is the maximum limit of sheets that can be read in appian Thanks, Rakshna JG

Hi All, I'm trying to generate grid in pdf format using PDF from HTML, When Opening the html template in browser its working fine but the generated pdf is not properly aligned and text at the bottom are not even visible. Is this a know issue or do we have some workaround for this. Thanks, Ankita Singh

Hi all,I have facing issues were implementing googleGeoChartField in interface.Since googleGeoChartField not visible and not working.Here attached the code for your referencegoogleGeoChartField( mapApiKey: XXXXXXXXXXXXXXXXXXXXXXX, chartColumnData: { { type: "string", id: "Country", rowDataKey: "Country" }, { type: "number", id: "Sales", rowDataKey: "Sales" } }, chartRowData: { { Country: "Germany", Sales: 400, }, { Country: "United States", Sales: 1300 }, { Country: "Brazil", Sales: 500, }, { Country: "Canada", Sales: 1280, }, { Country: "India", Sales: 700, }, { Country: "Indonesia", Sales: 100, }, { Country: "Russia", Sales: 1000, }, { Country: "Mexico", Sales: 1000, }, { Country: "Australia", Sales: 1400, }, { Country: "Iran", Sales: 300, }, { Country: "Thailand", Sales: 100, }, { Country: "Laos"

We have used the plugin Move To Collab (v1.0.0) to copy files from filesystem to our knowledge center folder using the smart service provided by the plugin. However, we have observed that in some instances the smart service does not complete and the node is skipped resulting into process instance failure. The error is neither captured in process instance, nor in the server logs. The file path given as node input is a valid path (i.e., the file does exist at the given path). What could be the potential cause for this? Any help with this issue would be appreciated.

Is there a way to control the output color of the text when using the PDF fill Smart service?

Hi All, I'm trying to generate table in docx Using Docx From Dynamic Template. When trying with sample data and template as given below "<info> <rowvalues name = 'John Samuael' branch= 'CSE' rollNum= 'abc' /> <rowvalues name = 'Michelle Dsouza' branch= 'IT' rollNum= 'fgh' /> </info>"  Here its working fine and able to generate 2 row of data But when I'm trying to generate with actual data i.e as given below <info> <rowvalues name = 'Gaurav' dob= '4/1/2021' requestnumber= '1' /> <rowvalues name = 'Gaurav Singh' dob= '4/1/2021' requestnumber= '2' /> <rowvalues name = 'Shahid' dob= '4/2/2021' requestnumber= '1' /> <rowvalues name = 'Shahid Salman' dob= '4/2/2021' requestnumber= '2' /> <rowvalues name = 'Prachu' dob= '4/3/2021' requestnumber= '2&#3

Hello All, We have a requirement to re-authenticate a user from the SAIL form. When a user click on the submit button in SAIL form(After filling all mandatory fields), system should ask for their login credentials to re-authenticate them. Please let me know if there is a way to implement it in Appian cloud environment Thanks in Advance !

If we upgrade a plugin to the latest version and we are using smart services related to this plugin in process models. How will it affect the process model? Will it automatically be reflected on the process model smart services or we need to update anything in process model as well?

Need to validate any uploaded document which is password protected, display message and not allow those if they are password protected. Please help.