Plug-ins

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.

Hi All, I am using the PDF from XSL-FO smart service to generate a PDF.  I'm generating the XML/XSL docs for the smart service via expressions that query the database.  I'd like to let users enter text in a rich text editor, and have that rich text preserved in the PDF. For example, the user enters a list in the rich text editor.  The database value is something like <ul><li>item 1</li><li>item 2</li></ul>. Currently, my PDF generation just shows the HTML as the exact string <ul><li>item 1</li><li>item 2</li></ul>.  Does anyone know of a way to display the formatted HTML in the PDF?  The only thing I can think of is to build some expressions to generate the correct XSL and then strip the HTML in the XML.  Any easier approach?

I am new in Appian application development. Can any one please help me to know how can I use the Import CSV to Database smart service? Should I use any Plug-ins? If yes where from I can get it? I searched for it but did not get it.

I have a related action that will make updates to fields in a CDT so I need to inform all active tasks of the change. We are currently using Set External PVs Activity to update active processes with the updated information. However, we recently made updates to the CDT which caused some processes to still use the older version of the CDT (indicated with ^version) and the Set External PVs Activity plug-in clears out the CDT data in the active processes instead of updating due to version incompatibility.  Is there a way  I can cast an older version of the CDT to the newest version without things being cleared out? Or are there any other ways for me to tell the active processes that there was an update to the CDT?

Hello Community, Is there any alternate plugin for the following one: https://community.appian.com/b/appmarket/posts/download-file-to-disk (this seems to be old)  Requirement: We have to copy some files generated in Appian to different folder in server. Please share your thoughts for any plugin that suits this requirement. Even if the smart service renders the file path of the actual document would also suffice our requirement. TIA,Arun

Hi all, We use the EWS Mail poller in order to download mail from Exchange Web Service, with db mysql. We don't found any reference to use Maria DB. anyone have found any problem using Maria DB? thanks.

Hi all, I am using Import CSV to Database to import a file to a database table. So far I can see the file has to match everything with the table definition but I now I got a strange behaviour. I am using a file with a wrong header but the service return import success as true. Makes sense? The same happens if I use a file with more columns that defined in the table. Can you help me? Thanks in advance.

Hi all, I am using the plugin excel tools to import a csv file to db. But after that I want to validate the headers just to see if the column names are the same defined in the db. I tried the function readexcelsheet( excelDocument:local!doc, sheetNumber:0, startRow:0, numberOfColumns: 10 ) But I only got an error saying "evalution error at line ..." Can someone tell me what I am doing wrong? maybe something regarding data? Thanks in advance

Hi All, Can someone recommend under which plugin I can find the function: translateForUser() and the url for the plugin. Need this function for the multi language support

I have a word document with html tags that I need converted to formatted text. For example I would like <strong>Hello</strong> to display as Hello instead. Currently I'm using Open Office writer doc to generate word document and need to embed html text converted to formatted text which should also preserve coloring and formatting. Open Office Writer Doc From Template Smart Service Does anyone know a way to display code in Microsoft Word documents that preserves coloring and formatting? I have tried to include code as html to parse <b>, <i>, <a>, <li>, <div> and <p>, for example. But all the tags and formatted styles have ignored and resulted in a single normal text. But as of now, I could only display it as normal text as Appian ignores all the html formatted code example <div>, <p>, <li>, <b> etc.

Hello All,We are trying to do FTP over SSL using SEND FILE OVER FTPS (Basic credentials) smartservice (SFTP smart services plugin)We have deployed the necessary client certificate in the admin console yet the smart service gives the error message like ERROR READHANDSHAKE RECORDCan anyone help us identify the issue?

Has anyone successfully used the plugin available here - https://community.appian.com/b/appmarket/posts/imedidata-integration-function to call the iMedidata ?