I need to figure out how to export/import all my custom fields. I've been
looking at export.xls-nokia.php, but I don't understand how it's determining
which fields to export. It won't export any of my custom fields. If I export a
XLS file and then import it right back in, it doesn't do it right and places
data in the wrong fields. Any help?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Will check this, but i'm quite busy ..., so please be patient.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2011-05-29
It takes some doing, but Importing can be accomplished.
First of all, under phpmyadmin, select the addressbook database and
addressbook table. Under Structure, change all Null to Yes (except Deprecated,
which apparently can't be changed)
Import your address book information (from whatever source) into this file.
Leave default value under Deprecated column. Under Address, ALT+ENTER will
create a line break (all address info should be entered here - there are no
city/zip/etc import fields). Values can be left blank.
Finally, import under phpmyadmin (check "Column names in first row" under
Options). Barring any errors, your information should have been imported
successfully. You can now add entries to groups, etc ...
Hope this helps everyone who has been having trouble with this (in my case
mainly due to severe lack of PHP experience). Good luck!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I need to figure out how to export/import all my custom fields. I've been
looking at export.xls-nokia.php, but I don't understand how it's determining
which fields to export. It won't export any of my custom fields. If I export a
XLS file and then import it right back in, it doesn't do it right and places
data in the wrong fields. Any help?
Which version did you use?
Regards O.
6.2.11
Will check this, but i'm quite busy ..., so please be patient.
It takes some doing, but Importing can be accomplished.
First of all, under phpmyadmin, select the addressbook database and
addressbook table. Under Structure, change all Null to Yes (except Deprecated,
which apparently can't be changed)
Next, download this sample addressbook.xls file: http://k002.kiwi6.com/hotlin
k/4khxp3vu5s/addressbook.xls
Import your address book information (from whatever source) into this file.
Leave default value under Deprecated column. Under Address, ALT+ENTER will
create a line break (all address info should be entered here - there are no
city/zip/etc import fields). Values can be left blank.
Finally, import under phpmyadmin (check "Column names in first row" under
Options). Barring any errors, your information should have been imported
successfully. You can now add entries to groups, etc ...
Hope this helps everyone who has been having trouble with this (in my case
mainly due to severe lack of PHP experience). Good luck!