OESF Portables Forum

General Forums => General Discussion => Topic started by: donaldfr on November 10, 2004, 05:28:00 pm

Title: Export Address Book to spreadsheet or csv
Post by: donaldfr 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

Title: Export Address Book to spreadsheet or csv
Post by: ulf1 on November 10, 2004, 06:48:58 pm

Import Addressbook into KA/Pi and then export from there into CSV


~
Ulf

Title: Export Address Book to spreadsheet or csv
Post by: donaldfr 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

Title: Export Address Book to spreadsheet or csv
Post by: ulf1 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 (http://sourceforge.net/project/showfiles.php?group_id=104103)

~
Ulf

Title: Export Address Book to spreadsheet or csv
Post by: doseas 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.

Title: Export Address Book to spreadsheet or csv
Post by: donaldfr 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 (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

Title: Export Address Book to spreadsheet or csv
Post by: doseas 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) (http://www.zaurususergroup.com/modules.php?op=modload&name=phpWiki&file=index&pagename=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.