Page 1 of 1
Version 6.4.22 - Export data to excel
PostPosted:Thu Apr 27, 2017 5:13 pm
by tiagoeclt
Hi, I'm new in this project and I already configurated my machine but I can't export the data from my invoices/files to any exterior font (in my case Excel).
Is it any type of export data to excel or other source near?
PS: I haven't explain myself.
I use the OCR to extract the data from the invoices/files and what I want is to extract the extracted data to excel or other source.
Re: Version 6.4.22 - Export data to excel
PostPosted:Fri Apr 28, 2017 6:50 pm
by jllort
Before giving you some clue about how solve it I would like understanding the scenario with more detail. You want to export periodically based on new documents creation, choosing manually one document. Basically what is the problem you are trying to solve.
Re: Version 6.4.22 - Export data to excel
PostPosted:Tue May 02, 2017 4:30 pm
by tiagoeclt
Basically, I scan the invoice of any company them the data go to OpenKM.
After that, I want to know, if it's possible to export those numbers, names, dates, whatever, for the excel.
Re: Version 6.4.22 - Export data to excel
PostPosted:Wed May 03, 2017 8:33 pm
by jllort
Yes can be done in several ways. You want a list of rows, one by document based in some query ? or csv for single document ?
Re: Version 6.4.22 - Export data to excel
PostPosted:Fri May 05, 2017 12:37 pm
by tiagoeclt
Yes. I want to scan some files and after that, with all those datas, export to excel.
Re: Version 6.4.22 - Export data to excel
PostPosted:Sat May 06, 2017 3:56 pm
by jllort
A good option might be a crontab tool, what daily looking for new documents with some metadata group and then create a csv and send to you by mail. Also might be done with report ( ireport can export to CSV format) .
For it must have some JAVA knowledge, tell me which of the two options do you prefer ? and I will try to give you some clues for it.