Plug-ins

Hi all,  May i know how to extract data from an xml file Thank You In Advance

Hello All, My requirement is client is sending an csv file to Appian which we need to insert in Appian table. I am using "Import CSV to Database V6" smart service. But now client want to send the file with some header and footer. Can anyone tell me how to read a csv file in Appian which is having header and footer. In Appian we don't need to save the header and footer we can simply ignore that. But how to ignore that in the Appian because client is sending same file to multiple platforms, so we need to do that in Appian itself. Thanks in advance Regards Sahil Batra

I need to copy the First Sheet from an Excel Document and add the same to the new Excel Document as its FIrst Sheet. can you please suggest the best approach and the smart services. Note: The First sheet will contains the data, so it should not be altered while copying

Hi Guys, Please help me on the below! I need to import list users from excel to the process model and then add them to numberous group. Can you please help me on the same??

Hi all, may I know, how to extract the xml data in an xml file Thank You

Hi all, I notice that the HTML Display Functions plugin is not listed on the app market and therefore may not be supported in the future, but I'm sure that many of us have it deployed in our environments for one reason: the function ncolumntable(). For anyone looking to remove this plugin, I'm including here an expression rule that I wrote to perform a similar task, and it also has the benefit of having no limit on the number of columns. Given a list of column headers, a list of Dictionaries, Maps, or CDTs containing the data to display, identifiers for fields in the data (optional - if blank, a!keys() will be used to determine the list of identifiers for each row of data), and some optional formatting parameters, this rule returns HTML code to generate a table displaying the data. This expression rule has the following parameters: columnHeaders (List of Text) data (Any Type) columnKeys (List of Text) headerColor (Text) evenRowColor (Text) oddRowColor (Text) /*

Hi, I want to call a RFC interface by Appian but I just saw that only BAPIs are callable? Is this correct?  https://docs.appian.com/suite/help/22.1/Invoke_SAP_BAPI_Smart_Service.html#asapinvokewithcommit Is there any workaround?

Hi, I'm trying to configure an SFTP using third party credentials but when I click on test connection in the Admin Console Third-Party Credentials  I'm not being able to connect, has anyone connected to an SFTP that can share details on how to connect using Third-Party Credentials?, I'm able to connect using WinSCP

Hi All, I have an issue where CSV To Excel node (Generate Excel from CSV smart service) on the pm is not generating the excel file so the import is failing. Below is error log screenshot. Quick help is much appreciated. Please let me know if any further details are required. Thanks in advance.

Hi, I have a question I am using LDAP Tool to get users from AD and automatically create their profile in Appian.I am facing one issue which is in AD there are few fields which are not correctly coming in Appian profile. for instance user manager is not coming even though I have mapped AD "manager" attribute to "User Supervisor username " Appian field. below is the screen shot of LDAP User Profile Synchronization process model input node. also for few users state is not coming and few custom fields are also not coming ?

Hi , Does anyone have experience with using Sign PDF plugin and display timestamp information in singed document? BR,Natasa

Hello All, I am using the smart Service "Import CSV to Database v6" for saving the data to my Appian table. I have tried with multiple columns and with single column also but getting same error. Error Message:- java.nio.charset.IllegalCharsetNameException: Sharing the    Please help to resolve the issue. Thanks in advance. Regards Sahil Batra

Hi , We have a requirement with the third party(old system) to have csv with comma delimiter delivered with data enclosed in double quotes. Below is sample data: Data in Database table: column1 column2 column3 testdata11 testdata12 testdata13 testdata21 testdata22 testdata23 Expected export of csv by third-party should look like below "column1","column2","column3" "testdata11" ,"testdata12" ,"testdata13" "testdata21" ,"testdata22" ,"testdata23" This was not possible 2 years back with smart service "Export Data Store Entity to csv" so we ended up 1. creating an expression rule that queries data from database and concatenates data of each column and each row with double quotes. 2. generate a text string 3. pass the text string to "Text doc from Template" smart service that creates a csv as expected by third party But the problem is as the data keeps growing ,

Hi, I am trying to use readexcelsheetpaging(), it shows totalCount value but not retrieving any data *note: the excel is generated using export to excel smart service what may be the issue, is there any work around?

getapplicationprocessmodelsuuids() this will give us the complete list of all process in a specified application. looks like its no more working. Can someone please let me know the equivalent for the same.

I just downloaded and imported the https://community.appian.com/b/appmarket/posts/adhoc-collaboration application plugin and couldn't find the below components: ACC_API_compactView ACC_compactTaskDisplay ACC_compactCommentDisplay ACC_API_queryEntries ACC_API_createNewEntry ACC API Create New Entry process model ACC API rule folder Can anyone help me with this?

Hi Everyone, I have a requirement to combine all excels having each sheet into a single file which contains multiple sheets together. I assume the combine excel sheet plugin will work but I am not getting the output document stored in the folder. Can you please suggest how to use combine excel sheet plugin? Thanks in Advance!!!

Hello, we're attempting to use the "Word Doc from Template" Smart Service on a Merged word document, but the smart service only replaces the placeholder from the first document that was merged. For example if we have 3 docs with placeholders, merge them, then run the Word Doc from Template Smart Service, the output document will only have replaced the placeholders that were contained within the content or the first document. We've checked all of the formatting of the placeholders in the XML and everything looks correct. The issues aren't caused by what's outlined in this KB document. Any idea what might be causing this? Merge document plugin community.appian.com/.../dynamic-document-generator

Hi Team, after update to 22.3 all our create user smart services with i18n are failing with  below error in UI as it is chained activity  An error occurred while executing a save: java.lang.NoSuchMethodError: com.appiancorp.suiteapi.personalization.UserValidationUtils.isValidNameLength(Ljava/lang/String;I)Z Is anybody found the route cause ? even the node is failing with below error . The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete Commented on below link as well ? community.appian.com/.../personalization-utilities

If I'm using a deprecated smart services, how can I check it in my app if I'm using it? For example: Export SQL to Excel and [Deprecated] Export SQL to Excel What would be the difference? Would you throw me any warnings or errors?

I have multiple excel sheets and can I assign the which sheet number to open(as Default) when I open excel after download.

Hi Friends I need to amend signature/image on pdf template. this pdf template having 6 pages and image should be amended over all pages all together . Is there any way or smart services or plugins in process model which help us to do the same. Regards Prabhat

It is showing like this 

Hello,  I downloaded the Fitnesse version for Appian and to run a test example I need the file log4j.properties which is missing. Has anybody had this same issue?

Hi,  I have three new columns i need to pass to database table which doesnot comes from excel sheet. I tried using import excel to database plugin, it says below way to configure for new columns and values but same not working saying expression is open ended , has anyone able to use it ?