Question

Quick Fields Session Field Lookup

Quick Fields

Updated April 21, 2014

asked on April 18, 2014

I have a quick fields session reading my invoices. I would like it to return a value from a spreadsheet. It works perfectly on most invoices. However if the lookup field off of the invoices has a space, we have to remove the space to return the value. If the lookup field is alpha or alpha numeric it will not return an data and i receive the error below.

I have verified both the spreadsheet column is set to text and the field it is pulling data into in Quickfields is Text.

"An error occurred accessing Excel. Please make sure the Excel file used by "Vendors" is closed. [0870-LPD1][Message=ERROR [22018] [Microsoft][ODBC Excel Driver] Data Type mismatch in criteria expression.] [File=T:\\Vendor List.xls] [Method=Execute First Result]

0 0

Answer

APPROVED ANSWER

replied on April 21, 2014

You could run pattern matching on the invoice value before putting it into the field (if I'm reading this correctly, the invoice value is not supposed to have spaces anyway?)

0 0

Replies

replied on April 18, 2014

This is a limitation in Excel. Excel looks at the first few rows of data in the column and decides the data type for it (this is done in the background regardless of the data type the user specified for the column). Any data not matching the data type is not returned.

0 0

replied on April 18, 2014

Is there a way around this, because actually the types that are not reading are in the first few rows.

0 0

APPROVED ANSWER

replied on April 21, 2014

You could run pattern matching on the invoice value before putting it into the field (if I'm reading this correctly, the invoice value is not supposed to have spaces anyway?)

0 0

You are not allowed to follow up in this post.

Question

Question

Quick Fields Session Field Lookup

Answer

Replies

Sign in to reply to this post.