Bulk Materials Ideas
Idea and discussion portal for the bulk materials product line. Users may submit, view and vote on ideas submitted by all users.
Idea and discussion portal for the bulk materials product line. Users may submit, view and vote on ideas submitted by all users.
The current way that the Apex Upgrader handles UDF fields is not good. To retain the UDF columns you either have to break the installer so it doesnt delete the columns, or you need to have the columns be deleted and then update every row from a backup source when the columns are added back.
Can we get a Case created on this please. Currently a concern when upgrading.
That should not be happening. This sounds more like a bug than an enhancement. Can you call support and provide your upgrade logs? Then we can see what happened in the upgrade that removed the data.
Yes, that is the main issue.
Ok. So it is not that the fields don't exist after the upgrade. It is the data in the fields get wiped out after the upgrade?
From my experience, doing it this way the columns get removed during the upgrade and then those scripts will add the columns back into the tables, BUT they do not repopulate the data that was originally in them. We would then have to import that data back into the tables from a back up.
This is a problem.
Hi Logan, If you place the scripts used to create the UDF fields in the Apex\Config\Scripts folder, the upgrade will not remove the UDF fields. Here is a link to our version 7 help (works the same in version 6) that explains this process.
https://users.commandalkon.com/Releases/Apex/V7/Help/index.htm#Topics/User_Defined_Fields.htm?Highlight=udf