Hi, I'm using ABBYY FlexiCapture (version 10.0.6.1589) standalone edition on Windows 10. I'm trying to export data and images to PostrgesSQL 9.4.4 database.
When images are exported to folder everything works (option "Save images to folder" selected) . Single table is created with column "PAGE_IMAGES" and with data tape "character" containing absolute path to images on my disk.
When I'm trying to export data and images ("Save images into a database" selected) to postgres database FlexiCapture shows error, ..type mismatch.". (see attached screenshot) Single table is created with column "PAGE_IMAGES" too but with data type "bytea".
Connection to database is configurated with provider "OLE DB Provider for ODBC Drivers" and with selected option "bytea as LO". (see http://www.z-space.com/kb/Article.aspx?ID=10275) Without above selected option "PAGE_IMAGES" column is created with "lo" data type, but error "..type mismatch..." occurs too.
I have odbc drivers installed with version: psqlODBC 09.05.0100 Release (earlier version tested too)
I've also tested MS SQL 2012 db. Export data and images works as expected ("PAGE_IMAGES" column with binary "image" data type is created)
I have to use postgres db so this is not the solution for me.
When images are exported to folder everything works (option "Save images to folder" selected) . Single table is created with column "PAGE_IMAGES" and with data tape "character" containing absolute path to images on my disk.
When I'm trying to export data and images ("Save images into a database" selected) to postgres database FlexiCapture shows error, ..type mismatch.". (see attached screenshot) Single table is created with column "PAGE_IMAGES" too but with data type "bytea".
Connection to database is configurated with provider "OLE DB Provider for ODBC Drivers" and with selected option "bytea as LO". (see http://www.z-space.com/kb/Article.aspx?ID=10275) Without above selected option "PAGE_IMAGES" column is created with "lo" data type, but error "..type mismatch..." occurs too.
I have odbc drivers installed with version: psqlODBC 09.05.0100 Release (earlier version tested too)
I've also tested MS SQL 2012 db. Export data and images works as expected ("PAGE_IMAGES" column with binary "image" data type is created)
I have to use postgres db so this is not the solution for me.
Comments
1 comment
Postgres database is not in the list of recommended databases (please see Administrator's Guide), and it was not fully tested with FlexiCapture. In such cases not all functionality is available with standard settings. In your case we would recommend using custom script export that will be able to connect to Postgres database and put your images there.
Best regards,
Maria
Please sign in to leave a comment.