-
Recently active
I am using the Import Excel to Database plugin along with a Connected System to download Excel files from a client’s Google Drive. Here is the behavior I am observing: When the Excel file is created using Microsoft Excel, the file is downloaded successfully via the Connected System, and the plugin works as expected. All the data present in the Excel file is imported correctly. However, when the Excel file is created in Google Sheets, or when an existing Excel file is opened/edited and saved using Google Sheets, the file is still downloaded successfully, and I can see the complete data in the file. But in this case, the Import Excel to Database plugin treats the file as null and does not return any data. In both cases, the file extension is .xlsx. Is this a known limitation of the Import Excel to Database plugin when handling .xlsx files generated or modified by Google Sheets? If so, is there any workaround or recommended approach to handle Excel files comi
Hi Team I am trying to convert word to pdf i have used this plugin Convert DocX to PDF Aspos. i am getting this error ErrorCode=99, ErrorMessage=Cannot invoke "com.appiancorp.suiteapi.content.ContentUploadOutputStream.close()" because "cos" is null] .I have configured necessary inputs. Thanks for the response in advance.
Hello, We are experiencing an issue with the PDF From HTML plug-in, as it generates the entire output on a single page. I would like to understand whether there is a way to render the content across multiple pages, preferably using a standard A4 page size. The problem becomes more pronounced when the generated content is very large and exceeds approximately 200 inches in page length. In such cases, Adobe has limitations when opening the file and truncates content at the top of the page. As a workaround, Adobe is only able to display the full content when opening the file in a web browser. I would appreciate any guidance or recommended solutions to address this limitation. Thank you.
We recently migrated our Appian environment from a legacy EC2-based infrastructure to Kubernetes. Following the migration, the below plugins have started failing. Affected Plugins: Rich Text Editor (Vuram): https://community.appian.com/b/appmarket/posts/rich-text-editor-vuram Timeline Chart Component: https://community.appian.com/b/appmarket/posts/timeline-chart-component Both plugins were working as expected prior to the infrastructure migration. Issue After moving to Kubernetes: The components are failing to load in the UI. Questions Has anyone experienced plugin compatibility issues after migrating to Kubernetes-based Appian environments? Are there any additional configuration steps required for custom plugins in Kubernetes deployments? Is there any known compatibility issue with these specific plugins in Kubernetes environments? Any suggestions or guidance would be greatly appreciated.
1. Responsiveness / iframe height (main priority)I have a custom component plugin that loads in an Appian interface. The plugin’s UI is responsive (e.g. adapts to mobile and different breakpoints), but the iframe and field layout do not adapt to the content height. In the interface designer I set the component Height to Auto. The parent div gets the class CertifiedSAILExtension---height_auto, but the iframe still has an inline style like height: 270px !important; overflow: hidden;. So the plugin content grows vertically (and is responsive), but the iframe stays at a fixed height and does not grow with it. Content is cut off or overflows below the visible area. The JavaScript API reference (e.g. 25.3) only documents how to receive the height parameter via Appian.Component.onNewValue(); I don’t see any documented way for the compon
Requirement is to display single color for first bar in each row and for 2nd bar in each row it show change dynamically as per status of the field. We are trying implementing timeline chart for one of the use case in which it should display 2 Bars in each row. One bar's color is fixed and another should be changing based on status. But when we try to implement logic then color is not coming properly using colors{} inside timeline chart. Output is not coming properly. Using two different loops for two bars in each row but it's not reflecting in the chart : googleTimelineChartField(chartColumnData: {{type: "string",id: "Name",rowDataKey: "name"},{type: "string",id: "Title",rowDataKey: "title"},{type: "date",id: "Start Time",rowDataKey: "start"},{type: "date",id: "End Time",rowDataKey: "end"} },chartRowData:{a!forEach(items:index(local!ccatAssesment,"data&q
Hi everyone, When I exported data using "Export Data Store Entity to Excel" from a proprietary Excel workbook that contains formulas, the Excel formulas get corrupted. Is there any limitation on the Excel workbook version that can be used with "Export Data Store Entity to Excel"? I am using Excel 365. Symptoms: (1) Formulas are shown as text and no longer calculated, for example:_xlfn.VSTACK({""}, _xlfn._xlws.FILTER(category!J2:J1001, TRUE, ""))IF(A9=0,,SUM(A9:B9))(2) Japanese phonetic (furigana) information appears in the same cell.
Hi everyone, To avoid ambiguity: my input is an excel document. The relevant sheet is the first sheet (index 0). In that sheet, the first row is completely empty, and the header starts on row 2 (e.g., A2, B2, …). When I try to read the data with readExcelSheetPaging(), Appian seems to interpret the sheet as empty and I get: List of Variant - 0 items Example Code: a!localVariables( local!excelData: readexcelsheetpaging( excelDocument: ri!excelInputFile, sheetNumber: 0, pagingInfo: a!pagingInfo( startIndex: 2, batchSize: 10 ), stopReadingAtFirstBlankRow: 0 ), local!excelData.data) What I have tried so far: Using the remove() function to remove the first row does not help. The empty row is removed but Appian still returns 0 row, interpretating the sheet as empty. If I modify the respective excel Input file sheet and put any dummy value in "A1", then the exact expression works as expected and returns data from row 2 onwards. In that case, removing/skipping the
Hi Appian folks, I am getting this error on Export SQL to Excel smart service - "The following error was raised by the Export SQL to Excel function: Name is insufficiently unique". I have configured "Document_name_to_create" on this node by appending now() after the document name i.e. "Document Name " & now(). I understand that this error comes up when document name is not unique, although I have appended now() in the end, the error doesn't seem to resolve. How do I fix this issue?
I am raising an issue with the Plug-in called Advanced Rich Text Editor (component: richTextEditorField) which is not loading or displaying to some users in some browsers from last few days, I am using it from last few months, but this issue is occurring from last few days!In appian environment the plug-in version is 1.7.3
Hi Team, We have custom registration plugin and we used to for our registration form, will show first and last names and email of the user and a captcha to verification then will allow to submit the button. Now, we are facing issue that input fields and some content in the page is no longer visible in the registration form. Could you please update me if you have any idea . Regards, Sireesha
Hi, I am getting the above duplicate data on the right side part of the screenshot as mentioned in the screenshot within the excel cells that are not mentioned with in the cdt to excel plugin smart service config. Can anyone provide the reason why this might be coming up.
Hi All, I am getting this error after upgarding the SFTP Functions Plugin version from 1.7.0 to 4.1.1 - Error copying the Appian document to the remote server. See application server log for more details. Error Message: Permission denied Can someone please advise urgently what changes are required to use this upgraded SFTP version. Regards, Nirupama
I'm using the Microsoft Document Editor Helper Servlets and Functions advanced plugin to display editable Word/Excel/PowerPoint documents from our Knowledge Center in an interface via microsoftDocumentEditorField().However, a failure popup appears when users try to open/view/edit the document (screenshot attached for reference).Please suggest the possible steps or configuration changes required to resolve this issue?
Hello All- We have created a connected system plugin which uses delegated permissions to authenticate the user As part of this plugin we are using the book definition route of pulling the access token from the context, The issue here is we had to authorize the connected system every single day to ensure the token remains active & not expired. If the user relogs in the token should always be a new one, we are pulling the token off the context why is there a need for us to click the authorize button every day Did anyone face this issue ? Any workarounds for this one.
Hi team, I am getting this error while executing SEnd meeting request smart service Unexpected error. (APNX-1-8000-000). Please let me know what other settings need to be done [View:/cfs-file/__key/communityserver-discussions-components-files/19/screenshot.docx:320:240]
Hi folks, As part of our requirement, we need to generate a letterhead in PDF format. The PDF should include the following: Header with the company logo and details — essentially two images: • Left: address & UEN • Right: company logo Standard document content with some dynamic fields (e.g., name, email address, reference numbers). A data table containing business information. The number of rows is dynamic (i.e., the table may have 1, 2, or n rows). I’ve been exploring smart services that can generate a PDF with all these elements — images (for the header), dynamic text fields, and dynamic table rows. From my research, these two smart services from the Dynamic Document Generator Plug-in seem relevant: HTML to PDF XSL-FO to PDF However, from what I understand, HTML to PDF may not fully support images (I’m not entirely sure, this seems to be a gray area). And I’m not very familiar with how to use XSL-FO for this type of transforma
Hi Everyone, As I couldn't find any documentation on SMT compatibility, can anyone confirm whether the Script Management tool is compatible with Microsoft SQL Server? We are planning to enable it in our environment.
I have been trying to generate a PDF file using the HTML template but I'm not getting the expected layout in the PDF file. below is the webpage view of HTML code below is the document i'm gettingcan someone suggest me an idea about how can i make the grid layout in the PDF file
Hi All, I'm trying to create a folder in external SFTP server and then send documents present in my appian folder to that sftp folder created. I have used SFTP Create Folder Smart Service. How do I map a customized folder name which is stored in a PV of type text to this SFTP Create Folder Smart Service? In the File path configurations, I don't see any parameter to which I can map the folder name. Please advise.
Hi, I am having issues with the sync between Appian data types and corresponding Java plugin objects. In Appian, I have two CDTs called ‘AttachmentList’ and ‘AttachmentDescriptor’. They were generated from ‘AttachmentList.xsd’ and ‘AttachmentDescriptor.xsd’, respectively. As seen in the screenshots above, ‘AttachmentList’ contains one field called ‘Attachments’, where ‘Attachments’ is an array of ‘AttachmentDescriptor’ data types. These two CDTs share the same namespace. I have a custom Java plugin node that takes an AttachmentList data type as input. In the process model that uses this Java plugin node, I set up AttachmentList as shown below. /resized-image/__size/640x480/__key/communityserver-discussions-components-files/19/Screenshot-2025_2D00_11_2D00_28-at-1.54.52_2F20_PM.png Here is the code in the Java plugin source file for setting up AttachmentList as input: @Input(required =
Hello - I am looking for some details on what jars do we need from Appian to build a connected System & where do we get these jars from? Its a bit confusing from the documentation Can someone please let me know. Regards Naveen
I am attempting to develop a feature for my application where a user can add a pin on a map using the esriMapMarkerField component. I've used it before with readOnly enabled, but not to gather user input. It seems like I'm supposed to add the relevant saves in the "onNewPointAdded" parameter, but the documentation is sparse on specific guidance with it. I would have assumed there would be some function variable to pass into the save, but I've come up with nothing. My code so far is below... does anyone have suggestions or an example they could provide?a!localVariables( local!pointData: {}, esriMapMarkerField( esriConnectedSystem: cons!MR_CS_ARC_GIS_MAP, baseMap: "oceans", secondaryMap: "satellite", zoomLevel: 3, mapCenter: { latitude: cons!MR_ESRI_MAP_CENTER_LATITUDE, longitude: cons!MR_ESRI_MAP_CENTER_LONGITUDE }, isReadOnly: false, maxSelection: {point: 1, polyline: 0, polygon: 0}, pointData: local!pointData, onNewPointAdd
For Appian version 24.2.1295.0 and Excel Tools version 2.6.3, I am getting following error. ERROR ImportExcelFileToDatabase ORA-17041: Missing IN or OUT parameter at index: 2 Is this due to a version miss match ? Which version will be suitable with my current version of Appian and will upgrading the plugin cause any issues with the older code?
I am using iCal Plugin 6.0.0 in OnPremise Appian environment, to send an invite to Outlook. The node gets completed successfully in the PM and even a meeting uId is generated. However, meeting invite is not received in recipients' inbox(this recipient is able to receive normal emails from the same environment). On further investigating the tomcat logs, it looks like an issue with smtp/server errors, which is not able to send the invite. Please share thoughts/suggestions. Thanks in advance. Nitika
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.