You are viewing limited content. For full access, please sign in.

Question

Question

Quickfields metadata transfer is removing zeros

asked on June 19, 2017

I have a session that works perfectly in when I run it in QF but when I send the files to the repository, it edits the metadata. 

For example, the employee number is 00000101 and that populates perfectly in the QF session, but in the repository, all I see if 101. It is removing the zeros from the beginning of all numbers formatted that way. 

Any idea how to fix this? 

0 0

Answer

SELECTED ANSWER
replied on June 19, 2017 Show version history

You cannot store leading zeroes in a numeric field because they are essentially the same as "white space" and do not change the numeric value of the data.

If the leading zeroes are necessary, you will need to store the data in text field instead.

0 0

Replies

replied on June 19, 2017

Jason,

Thanks for the quick reply! I changed the field types for each template i'm using and unfortunately it still won't show the leading zeros.  If you have any other ideas about what I can try, please let me know!

0 0
replied on June 19, 2017

Have you forced a field sync in Quick Fields? It doesn't reflect changes immediately, so it might still be treating it like a numeric field.

Just to clarify, you're saying the 00000101 value is populated before the document goes into QF, but it is different after QF is done processing the document?

0 0
replied on June 19, 2017

I did restart and still no luck. The files are on a network drive, QF is creating the metadata and in the actual QF session, it shows the number correctly (with all leading zeros). When I send the files to the repository, that's where I lose the leading zeros.  

0 0
replied on June 19, 2017 Show version history

Depending on your settings, closing and re-opening it won't cause it to automatically refresh the metadata types/constraints.

First go into the field configuration for the document class and open up the "configure fields" section to check the "Type" listed for your field.

If it still shows up as "Number" try the following:

     Go into Tools > Options > Metadata Updater

     Then de-select "Run only once a day per session"

     Then close/re-open QF and check again

0 0
replied on June 19, 2017

Yay! Thank you! it worked! 

0 0
replied on June 19, 2017 Show version history

You're welcome. You might want to change the Metadata Updater setting back when you're done testing. Refreshing every time you load the session might slow performance down a bit.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.