Question

troubleshooting quick fields "cannot store field data"

Quick Fields

Updated July 23, 2014

asked on February 20, 2014

I have a quick fields session that requires DOB. I get the error "Cannot store field data '%(DOB)' in field 'R.DateOfBirth' for document '2/18/2014%(LastName), %(FirstName)'."

The DOB is a required short date field. The document being scanned is accurately picking up the date, dd/dd/dddd.

What else can I check?

1 0

Replies

replied on February 20, 2014 • Show version history

Many times I use (\d\d?)\s?(\/)\s?(\d\d?)\s?(\/)\s?(\d\d\d?\d?) when I scan dates. I've found that certain combinations of numbers will leave an extra space before or after the slash.

If it's a QF agent session I also scan into a text field and then convert that text field to a date field in workflow. This way if it's an invalid date (maybe it scans 12/24/2013 as 12/74/2013) it doesn't get "stuck" in quick fields. This is even easier with QF9 since you can pass that to workflow as a token.

Inside workflow you can use the date token calculator to parse out the date by using this:

(\d\d?)\/\d\d?\/\d\d\d?\d?

For month, day and year you use the same pattern match above but just move the () to the correct number set. Then just do a check to make sure that token has a date now (to make sure it was successful) and route it to a failure process for manual entry if it fails.

Now you have nothing that gets stuck in the QF session!

Edit: now that I am in the office I thought I'd show you how it looks in Date token calculator:

And here's a simple workflow screenshot:

1 0

replied on February 20, 2014

Can you confirm that a valid date is being picked up by the process that generates the %(DOB) token? As a test, you can just hard code the R.DateOfBirth field with some date and try using the %(DOB) token inside another text field and then verify that you see a correct date there.

If there's still an issue, then please contact your Laserfiche reseller and open a case with Support. We'll need the session file, some sample documents, and a briefcase containing the template that the session is using.

0 0

replied on February 21, 2014 • Show version history

Thank you for your responses. I will try these ideas and see what happens.

BTW - Your examples are extremely helpful!

0 0

replied on July 23, 2014

If a response answered your question, please click "This answered my question" to let us know.

0 0

You are not allowed to follow up in this post.

Question

Question

troubleshooting quick fields "cannot store field data"

Replies

Sign in to reply to this post.