Solved

Not able to import excel to database using Receive Message vai email in Process mode

Forum|Forum|1 year ago
July 31, 2025
11 replies
0 views

I am sending an email attached with excel sheet to process model vai Receive Email at start node. I could able to extract the excel from email but the data is not written in the database.
FYI: Using Plugin Import Excel to Database, Using CDT

Best answer by shubhama926776

To properly debug this issue could you please run "Import Excel to Database" node as Run as Whoever Designed this Process Model.
Let's check if it's working or not.

stefanhelzle0001

We need more detail.

A

abhishekb065334Author

Hi [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] /[mention:9861aef97eb2483a8b76175d9eda1e37:e9ed411860ed4f2ba0265705b8793d05]
Please ingore the XOR gate.

[View:/cfs-file/__key/communityserver-discussions-components-files/14/Sample_5F00_data.xlsx:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/14/PWAB-IMPORT-EXCEL-_2D00_-Process-Model-Documentation.pdf:320:240]

stefanhelzle0001

Some inspiration for what could help us helping you.

https://appian.rocks/2025/02/11/the-art-of-debugging/

shubhama926776

Common causes are a mismatch between the Excel column headers and your CDT field names, inconsistency in data types, or issues with your data store configuration. Make sure the headers in your Excel file exactly match the names and data types of your CDT fields, that the data store entity is published and up to date, and review process logs for any errors such as type mismatches or missing required fields.

If you could provide more details would be great.

A

abhishekb065334Author

Hi [mention:9861aef97eb2483a8b76175d9eda1e37:e9ed411860ed4f2ba0265705b8793d05] ,
I have verifed all the common mismatch those are absoluate correct. The same process mode is working, If I am sharing same file throught UI(start process form) and data wriiten in database.

But when I am sending same excel vai email attachment throuht Receive Message, data is not able write to database.

FYI: using msg!properties.attachments to extract attached excel.

stefanhelzle0001

Do you see the attached file in the PV?

That process instance is start by a different user account when triggered by email. This might lea to a permission issue.

harshas2775

Are you receiving any errors or any details in the tomcat stdout log? How is it behaving currently

Sign up

Login with SSO

Login to the community

Login with SSO