Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Lost data after merging duplicate custom fields

custom-fields
database

After we upgraded to 3.7, I noticed that when I went to the custom fields area, I saw duplicates of each custom field PER project. For example:

Custom Field 1 (002) Custom Field 1 (005)

Where 002 and 005 correspond to specific projects.

I saw that I could now assign a single custom field to MULTIPLE projects just selecting the projects in the select box -- so using the example above, I modified the first Custom Field 1 field to be associated both 002 and 005 projects, then I removed the 2nd Custom Field 1 entry entirely.

After this, some issues in one project lost all of its data for the custom fields.

Any idea on why this happened and what we can do to restore it?

jg

tresstylez
· 1
tresstylez
Replies (9)
helpful
0
not helpful

What type are these 2 custom fields? Do you have a database backup?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

One was a text box, one was a list box. I'm checking for DB backups -- but I'd still like to know where the data went if you could assist.

Thanks.

jg


tresstylez
· 1
tresstylez
helpful
0
not helpful

Did you merge the text to the listbox? The data is probably still there but becuase the type is mismatch you won't see it in the front end. Can you check it in the database (gemini_customfielddata table)


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Sorry, I didn't mean to say we 'merged' the fields themselves -- I meant instead of having separate instances of the same custom field for EACH project -- we kept only a single instance of that custom field and simply configured it to apply to multiple projects (on the 'Edit Custom Field' screen).


tresstylez
· 1
tresstylez
helpful
0
not helpful

I see, so all you did was to apply Custom Field 1 to all the projects correct? If that is the case then of course that for all other projects it will be empty as the other project's data is still associated with Custom Field 2.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hmm.. by Custom Field 2, you mean the 2nd instance of Custom Field 1? :)

Its the same identical custom field, except we had one instance of the field per project. All the details and lookup tables were exactly identical -- so we figured we could get rid of the duplicates as long as we associated the remaining custom field with each project it needed to be associated with.

I'm trying to wrap my head around why some issues in the SAME project lost all of its custom field data -- and data for other issues (in the same project) remained.


tresstylez
· 1
tresstylez
helpful
0
not helpful

Unfortunately, it is not the same custom field. Even if the name is the same (or similar) it doesn't mean that it is the same custom field.

You shouldn't loose any data, can it be that the custom field wasn't populated for these issues?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

So, what you're saying is -- I could potentially delete a custom field but the data would still persist?


tresstylez
· 1
tresstylez
helpful
0
not helpful

No, if you delete the custom field the data will be deleted. But if you simply remove a custom field from a project by unselecting the project from the listbox then the data will still be there.


Saar Cohen
· 5000
Saar Cohen