Menu

Import - Export with Custom Fields...

Help
2011-03-07
2012-06-07
  • Christopher Cooley

    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?

     
  • chatelao

    chatelao - 2011-03-07

    Which version did you use?

    Regards O.

     
  • Christopher Cooley

    6.2.11

     
  • chatelao

    chatelao - 2011-03-11

    Will check this, but i'm quite busy ..., so please be patient.

     
  • Anonymous

    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)

    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!

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.