Community & Support

Convert CCK text field to integer

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?

Comments

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

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?

No, this isn't possible. You

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 ;-/

I succeded changing CCK text to integer

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

Most of us might want to

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...

nobody click here