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

Question

Question

Can changing the Field Display Format delete or remove any existing data from the field?

asked on November 21, 2013

 I think the answer is no.

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on November 21, 2013 Show version history

Hi Ken,

 

Changing the field display format won't alter the actual value stored in a field, only how it is displayed to the user. The full value will still be stored in the SQL table.

 

Changing the type or width of a field, or applying or changing constraints on a field, could result in data loss, however.

0 0

Replies

replied on November 21, 2013

You may want to set up a secondary field to try this out with. 

 

Usually you will get a warning if there is a chance of data corruption.

 

If it looks like it will cause problems, What you might want is to set up a workflow to copy the information from the old field to the new field, then delete the old one and rename the new field. You can use the workflow to ensure the change will happen how you want it to appear after the change

0 0
replied on November 22, 2013 Show version history

As the others have said suggests, some field transitions will cause data loss, some won't.

 

For example, changing a Text (40 char) to a Number field will cause data loss. Changing a Number to Text (40 chars) won't.

 

In cases were data loss is inevitable, workflow is a good option, as stated above. Of course, going from text to integer or number is a difficult transition as some fields may contain incompatible data.

 

In case there are large number of documents in your system, I tend to use SQL to generate reports on fields that will cause problems (such as dollar signs in text fields) and get them sorted early, before using workflow or the SDK to migrate values to the new field.

 

-Ben

 

0 0
replied on August 27, 2015

do you know if changing a field contraint from 5 digits to 6 digits will result in loss?

0 0
replied on August 27, 2015

If you try to change from exactly 5 digits required to exactly 6 digits required, you will get an error in the admin console and unable to change the field constraint. If you are using version 9.0+, the error will help you locate the problematic documents.

To successfully make the transition, you could to the following

  1. Set the constrain to 5 OR 6 digits. For example, \d\d\d\d\d\d? (makes the last digit optional using the ?)
  2. Run a workflow to update the existing fields or correct them manually so that all fields meet your desired constraint
  3. Change the constraint to 6 digits exactly (you should be warned if there are any that do not match)

 

Alternatively, if you do not have a way to update existing fields, you could leave the constraint as 5 OR 6.

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

Sign in to reply to this post.