Plug-ins

Hi, I'm trying yo configure the MSGraph Email Poller and I'm giving the required values in third party credentials as follows: secret tenant: login.microsoftonline.com/.../ applicationID:  But I'm getting below error: 2021-08-09 17:50:26,625 [Appian Work Item - 0 - execution00 : UnattendedJavaActivityRequest] DEBUG com.appiancorp.ps.msgraphmail.MSGraphMailPollerSmartServic e - Connecting to MS Graph authentication provider 2021-08-09 17:50:26,863 [Appian Work Item - 0 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.msgraphmail.MSGraphMailPollerSmartServic e - Unexpected error polling for mail java.util.concurrent.ExecutionException: java.lang.NullPointerException Does anyone knows what could be the root cause of this issue?

Hello -  We are trying to use the Poll Email from Microsoft Exchange EWS API Plugin to retrieve emails from the office 365 mailbox . Our Mailbox is on cloud and we have to connect to the EWS service URL via a proxy . So we need to set the proxy flag as yes while called this plugin . The issue is when we setup the proxy flag as Yes . The plugin is asking for proxyUsername and proxyPassword . Our server proxies do not authenticate so we don't have these credentials .  We are trying to pass them as null on the third party credential screen but the plugin keep complaining with the error " Required field proxyUsername does not exist in SCS " . It looks like when we add these fields on the third party credential screen , the key value changes to lower case but the plugin is looking for parameter "proxyUsername" . Has anyone else tried to pass the proxy details to this plugin ? 

I am patching some plug-in to meet our requirement. And it use some appian jar. for example : com.appiancorp.exceptions.jar. But I cannot find these jars in appian site, only see the API here. So how  can i get it?

Hi All, We have a requirement where we need to have a protected columns in excel. I am using CDT to excel plugin. But this works partially. Meaning I have getting the protected columns but it also marks all other columns as protected which I have not set as protected in my template & which has data. Prompt response will be appreciated. Thanks

Hi,When I tried to create a custom connected system template I’m getting error The System Has Encountered an ErrorHTTP Code: 500APNX-1-4198-000 Error Evaluating UI ExpressionExpression evaluation error [evaluation ID = LTZZ4L1B] : Error creating bean with name 'plugin.package.Template]': Failed to introspect bean class [package.Template] for lookup method metadata: could not find class that it depends on; nested exception is java.lang.NoClassDefFoundError: com/appian/connectedsystems/templateframework/sdk/configuration/FolderPropertyDescriptor$FolderPropertyDescriptorBuilderAppian version 19.1  On premises Sdk from https://github.com/appian/integration-sdk-examples/blob/master/Connected%20System%20Plug-in%20(CSP)%20Examples/Hello%20World/build.gradlebuild jar, how to guide docs.appian.com/.../develop-first-connected-system.htmlCan Anyone help me on this?Thanks in advance.

Is there any limitations on the rows or size of the csv to be used in Import CSV to Database. I am getting ArrayIndexOutOfBoundsException when I used a CSV with nearly 1,96,000 rows with 41 columns.

Hi Is there an easy way to find  what are the places pv is used in process model? Scenario is we have a pv in process model in which the values from db is stored. Need to find whether that pv is used anywhere else  Thanks in advance

While using Import CSV to Database when I am trying to have 41st column. I am getting the below error - Missing IN or OUT parameter at index:: 41 Is there any limitations on the number of columns to import or if I am missing something. Note - This is working absolutely fine for the 40 columns and its happening only when I try to have 41st column.

Hello All, Do we have any OOTB function or plug-in function to achieve series sorting ? Example : Input {1,1.1,1.1.1,4,1.2,3,2,2.1,2.2,10,13,12} Expected output : {1,1.1,1.1.1,1.2,2,2.1,2.2,3,4,10,12,13}

Hi All, Did any one know if we can integrate Appian with MS Access to fetch and update data? Read some ideas of using JDBC and ODBC connectors which were articled years ago. Please let me know if there are any other alternative solutions/ comments on this. TIA

T This smart service is working fine, only we are not able to write the 1st column(A) data of csv into database. Result displaying like below Is there any specific condition added to plugin code to read the data from 2nd column. If anyone knows the issue, could you please help me with the comments..

Hello guys, We just upgraded to 20.4 and found the plugin downloaddatasubsetfromrule is no longer working. We see the following error:        The system has encountered a problem        We’re sorry! A problem occurred while processing your last request.       Please contact the system administrator for more information. The plugin is available and loaded in the Appian. Anyone had this issue? Is there a fix for it or an alternate solution? Appreciate a quick reply. Thanks. Mahesh

Hi Team Is there any plugin or way to read .msg file which is having attachments in it?I know there is a plugin MSG File Read but for few cases it throws errorhttps://community.appian.com/b/appmarket/posts/msg-file-reader Any lead will be appreciable. Thanks

So I have figured out how to create a PDF template using the Fill-able form feature but I am very confused on how to add images.  I have an interface that allows users to upload pictures and need those to be added to the PDF that is created. I am using the PDF Doc from Template Smart Service.

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