Question

Losing leading 0 when passing from QF to LF

Quick Fields

Updated July 20, 2016

asked on July 19, 2016

I have a QF session that is gathering the routing number off of a check. Once a scan is complete, the field correctly displays the routing number as 063206663 in QF. When I store to LF, the field in the repository displays as 63206663. I have the field configured as a text field, and I am able to add the 0 in manually to LF and it saves it correctly, displaying 063206663.

As a test, I set the field in LF to have \d{9} as a constraint. When I store from QF with this setting I get the following error message:

Cannot store field data '63206663' in field 'Routing Number' for document 'Cashiers Check'.

How can I ensure the leading 0 is retained when storing from QF to LF?

I'm using QF 10.0.0.976 and LF 10.1.0.151

0 0

Answer

SELECTED ANSWER

replied on July 20, 2016

I had opened and closed QF a few times to ensure it was updating metadata, as well as having manually updated while in an open session with no change. At some point I closed down both QF and LF to work on something else. When I returned later in the day and ran a session, everything was working as expected and the leading 0 was not dropped. I'll chalk this one up to a mystery and hope I don't run into it again.

Thanks for your suggestions.

0 0

replied on July 20, 2016

Strange! Glad it's working now - feel free to reply to this thread if it happens again.

0 0

Replies

replied on July 19, 2016

You're definitely on the right track with that. What I usually do is write to a temp field that is text and then convert that to a number using workflow. As part of the conversion you can set it to require the leading 0. You could make the QF field a number and enforce it there but do not do that if you are running the document through QF agent as you could get documents stuck if the cord text isn't numeric.

Incidentally I do this with all special format fields most of the time unless I know my customer wants to edit using Quick Fields. This way others can fix any documents that are missing metadata. I do this for dates and pick list values primarily, but formatted numbers are also good places to use this method.

0 0

replied on July 19, 2016 • Show version history

I can't think of a reason why it would remove the leading 0, especially not when it's in a text field. Can you provide a screenshot of the field before and after storage?

By the way, when you're changing Laserfiche field definitions frequently for testing you'll want to reopen your sessions after the changes and make sure that metadata updater is running each time you open the session. See Tools > Options > Metadata Updater:

0 0

You are not allowed to follow up in this post.

Question

Question

Losing leading 0 when passing from QF to LF

Answer

Replies

Sign in to reply to this post.