I am using the latest version of "php-addressbook v6.2.11 - r444". I need to
use a text file with csv format to import address information into
AddressBook, but don't know the order of fields. Please help or point me to
where I can get help. Thanks in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
the fields used in your sample.csv are not all fields one can fill in when
adding a new entry: e.g. "company" or "notes" are missing.
is there a possibility to import csv files which also use those fields?
adding rows named "company" or "notes" after the rows used in the sample.csv
doesn't work.
best regards,
viola
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 am using the latest version of "php-addressbook v6.2.11 - r444". I need to
use a text file with csv format to import address information into
AddressBook, but don't know the order of fields. Please help or point me to
where I can get help. Thanks in advance.
Hi, did you try to do upgrade to 6.2.12, there is a sample included or just
get it here:
Good luck
hi!
the fields used in your sample.csv are not all fields one can fill in when
adding a new entry: e.g. "company" or "notes" are missing.
is there a possibility to import csv files which also use those fields?
adding rows named "company" or "notes" after the rows used in the sample.csv
doesn't work.
best regards,
viola
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!