Author Topic: Export Address Book to spreadsheet or csv  (Read 2447 times)

donaldfr

  • Newbie
  • *
  • Posts: 23
    • View Profile
Export Address Book to spreadsheet or csv
« on: November 10, 2004, 05:28:00 pm »
Does anyone know a way to export a Zauras default Address Book database to a spreadsheet or a CSV file?  Alternatively, is there a way to open an Address Book file in a PC database or spreadsheet application?

What is the default path to the Address Book data file?

Thanks!

-- Donald

ulf1

  • Jr. Member
  • **
  • Posts: 77
    • View Profile
    • http://
Export Address Book to spreadsheet or csv
« Reply #1 on: November 10, 2004, 06:48:58 pm »
Import Addressbook into KA/Pi and then export from there into CSV


~
Ulf
« Last Edit: November 10, 2004, 06:49:43 pm by ulf1 »

donaldfr

  • Newbie
  • *
  • Posts: 23
    • View Profile
Export Address Book to spreadsheet or csv
« Reply #2 on: November 10, 2004, 07:27:11 pm »
Thanks!

But, what is KA/Pi and where is the address book file on the Zauras?

Thanks!

-- Donald

ulf1

  • Jr. Member
  • **
  • Posts: 77
    • View Profile
    • http://
Export Address Book to spreadsheet or csv
« Reply #3 on: November 11, 2004, 02:54:59 pm »
Quote
Thanks!

But, what is KA/Pi and where is the address book file on the Zauras?

Thanks!

-- Donald
Ka/Pi: addressmanagementsystem based on KDE's KAddressbook

can be found here:
http://sourceforge.net/project/showfiles.php?group_id=104103

~
Ulf

doseas

  • Full Member
  • ***
  • Posts: 207
    • View Profile
    • http://
Export Address Book to spreadsheet or csv
« Reply #4 on: November 16, 2004, 01:52:50 am »
Quote
Does anyone know a way to export a Zauras default Address Book database to a spreadsheet or a CSV file?  Alternatively, is there a way to open an Address Book file in a PC database or spreadsheet application?

What is the default path to the Address Book data file?
Which ROM?  On the Sharp 2.x ROMs the PIM data files were XML files that could easily be parsed by Perl & the like.  On the Sharp 3.x ROMs, the data is stored in a proprietary format "DTM" database.  There are a couple of utilities that can read the DTM files and spit out the data in a usable format.

The location of the data files again depends on which ROM you have.  The XML files are in: /home/root/Applications/<appname>.  The DTM files are in: /home/zaurus/Applications/dtm.

donaldfr

  • Newbie
  • *
  • Posts: 23
    • View Profile
Export Address Book to spreadsheet or csv
« Reply #5 on: November 18, 2004, 01:59:11 pm »
Thanks!

Can you point me to some of those utilities?

I found this, but it refers to the XML format,

http://www.killefiz.de/zaurus/showdetail.php?app=1430

I'm not certain which ROM I'm running (the Info app is confusing), but, since there is a DTM directory, I'm assuming it's the later one.  The machine is a z860.

Thanks!

-- Donald

doseas

  • Full Member
  • ***
  • Posts: 207
    • View Profile
    • http://
Export Address Book to spreadsheet or csv
« Reply #6 on: November 19, 2004, 01:09:28 am »
There's dtm2xml, (http://www.dsitri.de/download/dtm2xml-1.2_arm.ipk).  
Also zdbat (http://yakty.s31.xrea.com/cgi-bin/misc/dl.xcg?file=zdbat_0.2.9-1_arm.ipk).
Also, dtmdump (see link about 1/3rd way down this page: http://www.zaurususergroup.com/modules.php...DTM%20database).  

I haven't tried them myself, so I can't recommend one above the other, except that I've pretty much listed them from newest to oldest, so, possibly. the newer one might have more/better functionality.