Custom Fields - import

[ezykiwi]

Is there a way to import custom fields,

I know there is the idx_custom_field but i notice that it also adds rows into the

idx_link and idx_link_temp

I know there is a import for category but I cant see one for custom fields...

Any thoughts?

[dody]

The easiest way is using phpmyadmin. Logical step by step as below:

1) Assume you have custom field ready (create in indexu admin panel). Give one or two sample data with admin panel too.

2) In phpmyadmin, select idx_link table. Export data only to csv. It will provide you a correct field order. Open with excel or similar software.

3) With the above sample data, arrange your data to match field order perfectly. Give it a few example, 10 or 20 rows. Then save to csv.

4) In phpmyadmin, truncate/empty all idx_link data (to prevent duplicate key, unless you have unique link_id). Then import the csv to idx_link table.

You can also import categories using the same step. Just make sure you know the category_id and parent_id to construct the category structure.

[ezykiwi]

Cheers Dody,

I dont mean the links custom field data for the links , more just the custom fields itself so more the structure,

In a previous version i have about 30 custom fields , and im just wanting to bring them across , not the links at all , and wanting to keep the rest of the database in the same format as v2.4

Just wondering is there a faster way than having to add them one by one through the admin panel

[dody]

I see.

I assume you want to duplicate the structure from one indexu directory to another new directory. Am I correct?

1) Do fresh install on new directory

2) With phpmyadmin, export the structure only of the following table from old directory:
- idx_link
- idx_link_temp
- idx_custom_field
- idx_ default_field

Add Drop Table if table exist.

3) Now select the new database used by new directory, then import with the sql file generated from step 2.

I hope it is clear enough

[ezykiwi]

If there is a a new field in the new database .. will it keep that or will the drop option remove it and just put in the fields from the older database?

[dody]

They will be removed. Because there is drop table sql command if the table is exist.
Since the table drop, the table structure and data is removed. Then it will be replaced with the new one (from old directory).

Please tell me if it's not a solusion. If you need to keep the current data and custom field. Yes you can with different method, but it is more complicated. Feel free to ask if you need it.

[ezykiwi]

Cheers Dody,

Yeh its not really the solution im looking for.

basically i want to keep the 2.4 database structure and just add on customfields.

I think in the mean time its going to be faster for me to add them one by one through the admin section. But im just thinking when people upgrade does this automatically bring the customfields across with it?

What would be awesome is copying the custom field structure and data across via import , just like you can do with links, and then being able to run a update (just like updating path structure etc) which would then do all the database side of things such as putting them in the link and link_temp tables etc...

Cheers for the help,
Great to you have you back