Question

ODBC Data Source Administrator

Workflow Quick Fields Laserfiche Version 9

Updated May 13, 2016

asked on April 24, 2014

I have two related issues:

One is a client with Win 7 Pro, 64bit Server;

I am trying to get Workflow to export data from Laserfiche to update an Access Database (2007).

The second is my demonstration pc, a Win 8.1 Pro, 64bit;

I am trying to get Quick Fields to pull data from a 2013 Excel Spreadsheet for indexing using Bar Code and or Zone OCR.

Both cases are failing. I am SO confused as to which version of Access Database, Excel Spreadsheet, ODBC Data Source Administrator, 32bit, 64bit, etc. to use with Quick Fields 9 and Workflow 9.1. It seems like I have tried every combination of 32bit, 64bit, 2007, 2010, 2013 with no results.

Can anyone clarify this for me or point to a White Paper with exact instructions. The Laserfiche Help files haven’t helped or I am interpreting them wrong. In the past I have done this with ease and it’s a beautiful thing to watch when it’s working.

0 0

Replies

replied on April 24, 2014

We'd need to know how it's "Failing". Any error messages? I have never had a problem in Quick Fields as long as you go through the ODBC setup/wizard from within Quick Fields and not through Control Panel.

At our clients we always install 32 bit Workflow since we always have issues with 64 bit ODBC drivers. (either weird errors but mostly no one has them on their server).

0 0

replied on April 24, 2014

What exactly is failing?

Quick Fields is a 32-bit application, so it needs 32-bit drivers for Office.

Workflow can be either 32-bit or 64-bit on a 64-bit OS, the installation defaults to x64. The Office ODBC drivers need to match the CPU-architecture for Workflow. If you decide to use 32-bit Workflow, installing Office will give you 32-bit drivers for Access. If you go with x64, then you will need to install Microsoft Access Database Engine 2010 in order to get x64 Office drivers.

In all cases, I would recommend going to the Windows ODBC Data Source Administrator through QF or WF. They will launch the correct version needed by the software. Launching the ODBC Data Source Administrator through Control Panel on a 64-bit OS will give you 64-bit version. If you want the 32-bit version, you can launch it from C:\Windows\SysWOW64\odbcad32.exe.

0 0

replied on April 24, 2014

Thank you for your very quick response. The main error I receive is;

"ERROR [22018] [Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression."

0 0

replied on April 25, 2014

Sticking to just the Excel one, so you can make it through the ODBC wizard then? Picking the appropriate driver, making it a system or user dsn, and get past authentication? Can you pick the sheet or is that when you get the error? Or do you get the error in the output pane when you try and scan? Also how about your Test Query button after it is set if you can get that far?

0 0

replied on April 25, 2014

I can choose a driver, worksheet and complete the Wizard. The error appears when I "Test Query" or run the session.

0 0

replied on April 25, 2014

I don't think that is going to be the driver. What is the format of your excel sheet? I have had this a few times and it ends up being that the columns need to be formatted as numbers, dates, text, etc. Have you tried changing the format of the columns or at least the one you are doing the lookup off of?

0 0

replied on June 12, 2015

Did you ever get an answer to this? I am having the same problem.

0 0

View 2 previous replies

replied on June 12, 2015

Same as above, there is not enough information to troubleshoot. What software are you using? Where are you seeing the error? What data are you passing in? Are you reading from or writing to the Excel file? Excel internally set the column types based on the data present, so the error is most likely indicating an issue with the actual value.

0 0

replied on June 12, 2015

I have an excel spreadsheet (I've tried it with both a 97 version and a 2015 excel version) that has the data set up. I have a field called Image Name. I have set up the Quick Fields session to pull the data for the fields when the data in the Image Name field equals the actual image name. I.E. I have an image named "1" and the Image Name field has a "1" in it. I have set it up to pick up the other fields in the spreadsheet to populate the template fields. When I run the Quick Fields session I am getting this error:

"ERROR [22018] [Microsoft][ODBC Excel Driver] Data type mismatch in criteria expression."

I have tried changing the data type to every data type possible and I am having no luck. My biggest frustration is that this is the exact same set-up that I have used in Quick Fields 7 and it works fine.

0 0

replied on June 15, 2015

There is no Office 2015, I expect you meant 2013. The column type set in the user interface has no impact on the ODBC driver. The driver decides the column type by sampling the first few rows. Anything that does not match that data type is ignored. I can't confirm it without looking at the spreadsheet, but I expect Excel thinks the column is a string rather than a number column.

0 0

replied on May 13, 2016

Did someone ever find a way to avoid this?

I got the same issue with an excel file (xlsx) and if i send a number to the query i got results but if i put another thing send the same error.

In the excel file the format of the column is general.

But the data goes from only numbers, numers and letters, numbers, letters and dash for put some examples.

This with Workflow 10.0.0.249

0 0

replied on May 13, 2016

It's a limitation/feature of Excel, there are no workarounds. Try switching to SQL or Access.

1 0

You are not allowed to follow up in this post.

Question

Question

ODBC Data Source Administrator

Replies

Sign in to reply to this post.