I saw the other topic posted. Unfortunately the solution does not fit my needs. I have a pdf file that contains information regarding payslips of employees, so each page a different employee.
Is there a way I could extract info from each page to export a database with all the employees? What I could do so far is to import the pdf file and get 1 huge line of characters from the file. And there's not much I can do with it.
There is an example pdf file attached, having 2 employees' info (2 pages).
The recommendation will be not to use the PDF file for processing important data like payslips as the data will not be in a format directly expected by target database. It will be a good idea to go to the corresponding source system and create a new data flow from that source to your new target database.
If the data is provided by third party, then you will have to create an agreed interface in the form of a file or web request payload to send the data so that it can be processed by Talend easily.
I found a way to read the PDF and export it in txt using Talend. Now I process the txt file in Java(eclipse) and right now I am struggling to implement the script in Talend.
I have two java classes written, one with the getters/setters and the main one that reads the pdf and exports it in Excel.
Do you know what components and how should I set them up in Talend?
Hope this has helped you to resolve the query. Could you please post the method you have employed to convert the PDF file so that it will benefit other Talend community members?
