It seems that the proposed import/export fields in CSV tables (according to
import_sample.csv) do not match the fields that are actually
imported/exported.
AND the actually importd/exported fields do not match the fields in the
database (for example, there are export fields such as "ZIP" and "City" which
are not visible/editable via the PHP frontend.
AND ALSO, fields such as "Company" that can be edited in the PHP frontend
cannot be imported/exported.
What gives?
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:
It seems that the proposed import/export fields in CSV tables (according to
import_sample.csv) do not match the fields that are actually
imported/exported.
AND the actually importd/exported fields do not match the fields in the
database (for example, there are export fields such as "ZIP" and "City" which
are not visible/editable via the PHP frontend.
AND ALSO, fields such as "Company" that can be edited in the PHP frontend
cannot be imported/exported.
What gives?
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!