View Issue Details

IDProjectCategoryView StatusLast Update
88Composrcorepublic2011-09-16 02:39
ReporterChris Graham Assigned ToChris Graham  
PrioritynormalSeverityfeature 
Status closedResolutionwon't fix 
Summary88: Catalogue/CPF field-type changing
DescriptionThe ability to edit the field types used in an existing catalogue.

There are three problems with this:

    * types for existing data may no longer be correct (e.g. a text field converted to an integer field may result in invalid data)
    * a lot of moving in/out of the translate table would need doing
    * and the above that would squash away internationalisations of strings in some cases (although we don't support it anymore, I don't want to break the internal support)


I propose a resolution system be added to fix the first problem, extra code for the second problem (there's no choice - the code'd be needed), and the third problem merely documented as existing.
The resolution system would be two phase:

    * the first would allow the definition of automated remaps (e.g. yes -> 1, no -> 0, Yes -> 1, No -> 1)
    * the second would provide edit boxes for all fields that could not automatically be fixed
TagsNo tags attached.
Attach Tags
Time estimation (hours)6
Sponsorship open

Sponsor

Date Added Member Amount Sponsored

Relationships

related to 85 ResolvedChris Graham Ability to switch between tree/non-tree catalogues 
related to 137 ResolvedChris Graham CPF/catalogue field unification 

Activities

Chris Graham

2011-09-16 02:39

administrator   ~187

This would be messy, and add quite a lot of UI bloat.

So documented a workaround instead, that works equally as easily as a new inbuilt UI resolver would:

"You cannot change field data types after you have created them (except between field types that have the same "storage" type) as this would affect the integrity of any data that may have already been entered into them. A workaround is to export to CSV, delete the field, create a new field with the same name and the new type, and reimport the CSV."

Essentially it means we switch creating our own resolution interface, to suggesting people do it themselves in Excel.

Issue History

Date Modified Username Field Change