By asb on

Hi,

is there a non-programmatic way (meaning: a working module or a way that does not require writing code) that allows to migrate CCK fields between field types?

Example: I have a text field that stores (mostly) numeric values (e.g. 320 g); now I have to perform calculations with those values and thus need a more precise field type like integer. Ideally this "field type migrator" would allow me to discard all illegal values (i.e. the "g").

Is there something like this already available?

Thanks & greetings, -asb

PS: I'm also looking for a way to move/migrate data from certain CCK fields into Drupal core's taxonomy. Again, the real-world logic would be trivial: Look in a given CCK field, select a vocabulary and create a new term for every value from the CCK field that does not exist yet in the vocabulary. Again, as it seems, Drupal's data model makes this complicated... Or are there any solutions for this?

⋅ Categories: Drupal 5.x, Drupal 6.x

Comments

asb’s picture

asb commented

Some pointers:

tinem’s picture

tinem commented

Did you get this to functioning and if yes please share?

And please step-by-step so I don't make any stupid things. :-)

Maybe someone has made a tutorial? Think it should be done in mysql but how, please?

asb’s picture

asb commented

No, this isn't possible. You have to custom-code it yourself. The pointers above might help for starters.

If you're a non coder like myself, you'll either have to hire a programmer for this, or to do this manually (create a new field, copy & paste the old values). Depending on the amount of data you have to convert, this might take the rest of your natural lifespan, or a couple of reborn existences more ;-/

tinem’s picture

tinem commented

Read all about it here http://drupal.org/node/643646

asb’s picture

asb commented

Most of us might want to thoroughly re-read the last sentence of reply #1 in the mentioned posting and keep in mind that most of us do not have the skills and experience Markus has ;) However, set up a testing environment and go ahead - in the worst case you'll waste some quality time...