Hi Sudhir, to update or insert data into a table based on PDF content read as a string,
Parse the PDF content string into rows and columns.
Usually, the PDFReader returns raw text, so you’ll need to split it (e.g., by line breaks for rows and by delimiters like spaces or tabs for columns).
Create or update entities in Mendix:
Loop through each parsed row in a microflow.
For each row, create a new entity or update existing records with corresponding attribute values.
Map the parsed columns to your entity attributes carefully to match your table structure.
If your PDF content is complex, consider exporting it as CSV or Excel instead, which is easier to parse.
Hope this one helps you! :)
Hi Sudhir,
As per the documentation of the widget, you need to call the custom java action which is mentioned in the documentation. It gives in String format and later you can use that String to use.
Otherwise you can create your own logic to read this content to convert into JSON and from that JSON you could build an import mapping to store in Mendix DB
Regards
Ajay
Dear Mouli Dharan,
Separating column is the problem. I found space is the delimiter for the text stream. This text stream contains date (format dd/mm/yyyy hh:mm), name (example: RAMESH KUMAR K).
Here, I can manage with date, but name is the problem because name can have first, middle and last name, it is may or may not. what to do?
Regards
Sudhir
Hi All,
Is there any way to read the scanned document ?
Regards
Sudhir