Author Topic: Gpe Address Book Information  (Read 5827 times)

omro

  • Hero Member
  • *****
  • Posts: 796
    • View Profile
    • http://
Gpe Address Book Information
« on: June 18, 2006, 03:23:43 pm »
Hi there

I have all my address info in a spreadsheet. I'd like to import it into the GPE Address book. I'd also like to be able to export any changes out again.

Is that possible?
Zaurus C-1000

jan

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
    • http://www.spacezone.de/zaurus/articles/
Gpe Address Book Information
« Reply #1 on: June 29, 2006, 10:32:10 am »
Quote
Hi there

I have all my address info in a spreadsheet. I'd like to import it into the GPE Address book. I'd also like to be able to export any changes out again.

Is that possible?
[div align=\"right\"][a href=\"index.php?act=findpost&pid=131700\"][{POST_SNAPBACK}][/a][/div]

Write a plugin for opensync. (I don't think a simpler solution exists.) opensync to spreadsheet/csv would be cool.

jan

SL-C860 (Boxer), OZ 3.5.4.1 GPE 2.7
my blog

mimeca

  • Hero Member
  • *****
  • Posts: 682
    • View Profile
    • http://www.innerzaurus.com
Gpe Address Book Information
« Reply #2 on: July 02, 2006, 12:39:04 pm »
You want sync on both sides (gpe <=> pc), aren't you?

One option would be convert the spreadsheet to cvs, and then, create a SQL sentence witch intesert it on the addressbook. Is a easy (more or less) task with Python on Zaurus side. Sync with PC after would use the opposite steps.
Nunca hagas de un lugar tu hogar. Construye tu hogar en el interior de tu propia cabeza. Encontrare¡s todo lo que necesites para amueblarla: recuerdos, amigos en los que puedes confiar, pasión por el conocimiento y otras cosas por el estilo. De esa forma podrás ir a donde te vayas. Nunca te faltará un hogar..., a menos que pierdas la cabeza, claro...

Innerzaurus => www.innerzaurus.com (Spanish Zaurus Site)

omro

  • Hero Member
  • *****
  • Posts: 796
    • View Profile
    • http://
Gpe Address Book Information
« Reply #3 on: September 26, 2006, 02:13:32 pm »
So....

How do you transfer the data from GPE Address book when you update GPE to another version of the GPE Address book?

Surely there has to be a way to export the data safely out and then back in again?
Zaurus C-1000

koen

  • Hero Member
  • *****
  • Posts: 1008
    • View Profile
    • http://dominion.thruhere.net/koen/cms/
Gpe Address Book Information
« Reply #4 on: September 26, 2006, 03:47:14 pm »
Quote
How do you transfer the data from GPE Address book when you update GPE to another version of the GPE Address book?
[div align=\"right\"][a href=\"index.php?act=findpost&pid=142376\"][{POST_SNAPBACK}][/a][/div]

libcontactsdb takes care of that automagically
Forums are not bugtrackers!!! Smart questions
Ångström release team
iPAQ h2210, iPAQ h5550, iPAQ hx4700, Zaurus SL-C700, Nokia 770, all running some form of GPE
My blog

omro

  • Hero Member
  • *****
  • Posts: 796
    • View Profile
    • http://
Gpe Address Book Information
« Reply #5 on: September 26, 2006, 04:33:50 pm »
I'm sure it does, but I have no idea how it does. Any more information you can provide?

is there a way to turn the data into a CSV or XLS?
Zaurus C-1000

lardman

  • Hero Member
  • *****
  • Posts: 4512
    • View Profile
    • http://people.bath.ac.uk/enpsgp/Zaurus/
Gpe Address Book Information
« Reply #6 on: September 27, 2006, 06:45:55 am »
I just had a word with Florian on #GPE and he gave me the following info:

One can import/export using vcards from either the command line or using gpesyncd.
http://gpe.handhelds.org/projects/gpesyncd.shtml and try running contacts from the command line with a -help switch and see what it says.

To access the database itself one can use libcontactsdb (documentation not finished yet):
http://www.kernelconcepts.de/~fuchs/gpe/do...tsdb/index.html

And for raw access here's some info about the database layout:
http://handhelds.org:8080/gpe/wiki?p=GpeDatabaseScheme

As and when you do work out the easiest way, would you mind adding some info to either the wiki.openzaurus.org FAQ or a HowTo (depending on how much you want to write),

Thanks,


Si
« Last Edit: September 27, 2006, 06:46:34 am by lardman »
C750 OZ3.5.4 (GPE, 2.6.x kernel)
SL5500 OZ3.5.4 (Opie)
Nokia 770
Serial GPS, WCF-12, Socket Ethernet & BT, Ratoc USB
WinXP, Mandriva

omro

  • Hero Member
  • *****
  • Posts: 796
    • View Profile
    • http://
Gpe Address Book Information
« Reply #7 on: October 03, 2006, 08:28:17 pm »
Fantabulous

I shall do some investigating when I am on holiday

thanks :-)

Quote
I just had a word with Florian on #GPE and he gave me the following info:

One can import/export using vcards from either the command line or using gpesyncd.
http://gpe.handhelds.org/projects/gpesyncd.shtml and try running contacts from the command line with a -help switch and see what it says.

To access the database itself one can use libcontactsdb (documentation not finished yet):
http://www.kernelconcepts.de/~fuchs/gpe/do...tsdb/index.html

And for raw access here's some info about the database layout:
http://handhelds.org:8080/gpe/wiki?p=GpeDatabaseScheme

As and when you do work out the easiest way, would you mind adding some info to either the wiki.openzaurus.org FAQ or a HowTo (depending on how much you want to write),

Thanks,


Si
[div align=\"right\"][a href=\"index.php?act=findpost&pid=142445\"][{POST_SNAPBACK}][/a][/div]
Zaurus C-1000