Port from other cck data

matteoraggi,

Here are some basic steps for porting existing cck fields to the addresses module. Keep in mind that these are just basic steps and that these depend greatly on your knowledge of your database layout and you ability to safely manipulate your database.

1. Install the addresses module
2. Add an address to the content type you wish to use addresses with
3. Locate the database table created by cck for storing the address information. This should be something similar to "content_type_address" depending on the name you gave the field. You can also identify the table by it containing the following fields (vid, nid, delta, field_address_aname, field_address_street, field_address_additional, field_address_city, field_address_province, field_address_country, field_address_postal_code, field_address_is_primary). It could have additional fields.
4. Locate the database tables where your current data is. Again this should be something similar to "content_type_" plus the name give to the field.
5. This is the hard part. You'll need to write an SQL query that pulls all information from existing fields and populates the new table, all while keeping the information correctly grouped by vid and nid.
6. Once this is complete and you have verified the new address information is correct, you can remove the old field.

This could be a very dangerous process if you do not know what you are doing as you can scramble all you data. I suggest you perform this on a test server until you get your sql query figured out.

****This information is a basic layout of how you could port your information from existing cck fields into new cck fields. This information could have flaws in it and comes with no warranty should anything go wrong.****

Hope this helps.

Cheers,

Antoine