Re: Libretto in Singapore
Date: Wed, 21 Mar 2001 21:32:02 +0800 From: "Raymond Tan" [EMAIL PROTECTED] Subject: Re: Libretto in Singapore I am one of the guys who met with Michael Berlant when I had a L50. (Very nice guy, missed the home cooked food. Mr Mrs Mike san, Ogenki Desuka?) Basically, Sim Lim Square is the only place that I must visit for computer related purchases. However it seems that a brand new lib is extint now! Oh yes, the authorities are doing a fantastic job in enforcing the anti-piracy law. However If you do not mind a resale unit of any other manufacturer, I may be able to help though. Just a few months back, my wife bought a "one week old" notebook c/w unfiled warranty card (not a lib) for S$1000 lesser than a brand new one. One gets lucky if the shop owner has a seller, it depends. - Original Message - From: Ken Hansen [EMAIL PROTECTED] To: Libretto [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 10:38 AM Subject: Re: Libretto in Singapore Date: Tue, 20 Mar 2001 21:30:52 -0500 From: "Ken Hansen" [EMAIL PROTECTED] Subject: Re: Libretto in Singapore Luckilly you "prize" will fit in your pocket, and the missus will never know... ;^) Ken (Who wound up buying a Portege 3020ct for $599 at www.hitechcafe.com w/96 Meg RAM, 6.4 Gig HD, etc... How do I get *that* past my wife ;^) - Original Message - From: "Michael Heathcote" [EMAIL PROTECTED] To: "Libretto" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 9:13 AM Subject: Re: Libretto in Singapore Date: Tue, 20 Mar 2001 14:02:40 - From: "Michael Heathcote" [EMAIL PROTECTED] Subject: Re: Libretto in Singapore Thankyou to all who have kindly replied to my request for possible places to shop in Singapore. All I need to do now is work out how to 'loose' the wife for a few hours !!! Mike. ** http://libretto.basiclink.com - Libretto mailing list http://libretto.basiclink.com/archive - Archives http://www.picante.com/~gtaylor/portable/faq.html - FAQ ---UNSUBSCRIBE--- mailto:[EMAIL PROTECTED]?subject=cmd:unsubscribe UNSUBSCRIBE DIGEST-- Use above but add DIGEST to the subject line... ** ** http://libretto.basiclink.com - Libretto mailing list http://libretto.basiclink.com/archive - Archives http://www.picante.com/~gtaylor/portable/faq.html - FAQ ---UNSUBSCRIBE--- mailto:[EMAIL PROTECTED]?subject=cmd:unsubscribe UNSUBSCRIBE DIGEST-- Use above but add DIGEST to the subject line... ** ** http://libretto.basiclink.com - Libretto mailing list http://libretto.basiclink.com/archive - Archives http://www.picante.com/~gtaylor/portable/faq.html - FAQ ---UNSUBSCRIBE--- mailto:[EMAIL PROTECTED]?subject=cmd:unsubscribe UNSUBSCRIBE DIGEST-- Use above but add DIGEST to the subject line... **
Off topic: My adventure of migrating hp database to palm.
Date: Sun, 25 Feb 2001 23:09:22 +0800
From: "Raymond Tan" [EMAIL PROTECTED]
Subject: Off topic: My adventure of migrating hp database to palm.
I am reporting my little adventure of migrating the hp200lx database to palm; for
anybody who may be interested, if not do not waste your time reading this message,
apology.
I have been using the lib50 until I sold it away last year but I am still on the list
(evesdropping?)
Case history:
Owns a hp200lx and uses the database application that has an extention *.gdb. For
me, this database is more than a PIM and I have a few hundred records (mainly my
clients' particulars and their very confidential financial information; no price for
guessing my occupation.) For each record, I have created more than 80 fields, some
radio buttons, text fields etc...
Limitations:
Copied my client.gdb to the harddisk and used MS Excel to import it. Informations
appear together with garbage in random. How do I proceed from there?
HP support wasn't helpfull at all. After bouncing a few mails thru' and fro with them,
I decided to try my luck here. And here is where it takes off.
Finally:
Followed Casey's link to www.palmtop.net/super.html
Thanks to Casey, found one freeware named "OL2LXinst.exe", downloaded and unzipped it.
Also thanks to E. Smith and Yeshiah.
With this, I can supposingly migrate the data to outlook. But the challenge come when
I have so many fields to map into outlook contact's limited PIM field. (How now?)
Solution:
In the OL2LX windows, check "pause to allow manual editing of text data", then click
on convert data. The default text viewer for your computer will open now. Close it,
and then choose cancel.
A new client.txt is now created in the directory C:\OL2LX
Now I use MS Excel to open this "client.txt". You will need to "parse" it as the data
are all in one column. Parsing the file will split the "string of data" in column "A"
of the spreadsheet to many columns; ie "A", "B", "C", and so on
Now I have 80 over columns and a few hundrew rows of data (column denotes the fields
and rows denotes the records of the original database.)
The next step is to join some of the columns into one column by using the Excel
function. ("")
Repeated this joining until I am finally satisfied with the rearranging and save the
client.txt
Now I am ready to import the data to Outlook.
In the Outlook Contact folder, I did the importing and mapping of the fields which is
straight forward from the importing wizard.
Yes, all the data now appears in Contact, and I am thus able to sync them to the Palm.
That it, hope this will benefit someone, someday.
**
http://libretto.basiclink.com - Libretto mailing list
http://libretto.basiclink.com/archive - Archives
http://www.picante.com/~gtaylor/portable/faq.html - FAQ
---UNSUBSCRIBE---
mailto:[EMAIL PROTECTED]?subject=cmd:unsubscribe
UNSUBSCRIBE DIGEST--
Use above but add DIGEST to the subject line...
**
Re: Off topic: transfer database to palm
Date: Fri, 23 Feb 2001 00:27:15 +0800 From: "Raymond Tan" [EMAIL PROTECTED] Subject: Re: Off topic: transfer database to palm Thank-you sir, I followed your recommended link and managed to do it, at the expense of taking off from work :) I have to do a few tedious steps though. I will post my adventure for the benefit of whoever interested when I can squeeze some time. Once again, thank-you from Singapore - Original Message - From: Casey Karp [EMAIL PROTECTED] To: Libretto [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 11:33 PM Subject: Re: Off topic: transfer database to palm Date: Wed, 21 Feb 2001 07:26:56 -0800 From: Casey Karp [EMAIL PROTECTED] Subject: Re: Off topic: transfer database to palm Raymond, Before you import it into Excel, you need to export it from the GDB into CSV. Your best bet for that is to check the HP Super Site at http://www.palmtop.net/super.html for the program GDBIO. You might also look at the Super Site for a program called GDBWin, which is a Windows program to let you use the HPLX GDB files. Works great on my Libretto. C. Witty, wise, weird, and wonderful, Raymond Tan wrote at 06:32 AM 2/21/2001 Date: Wed, 21 Feb 2001 22:10:59 +0800 From: "Raymond Tan" [EMAIL PROTECTED] Subject: Re: Off topic: transfer database to palm Thanks for replying, I am able to open the *.gdb file in MS Excel (appear as funny characters) and save as *.csv and *.txt But I do not know how to proceed from there. The palm desktop software only allows import garbage. Thanks ** http://libretto.basiclink.com - Libretto mailing list http://libretto.basiclink.com/archive - Archives http://www.picante.com/~gtaylor/portable/faq.html - FAQ ---UNSUBSCRIBE--- mailto:[EMAIL PROTECTED]?subject=cmd:unsubscribe UNSUBSCRIBE DIGEST-- Use above but add DIGEST to the subject line... ** ** http://libretto.basiclink.com - Libretto mailing list http://libretto.basiclink.com/archive - Archives http://www.picante.com/~gtaylor/portable/faq.html - FAQ ---UNSUBSCRIBE--- mailto:[EMAIL PROTECTED]?subject=cmd:unsubscribe UNSUBSCRIBE DIGEST-- Use above but add DIGEST to the subject line... **
Off topic: transfer database to palm
Date: Mon, 19 Feb 2001 20:07:40 +0800 From: "Raymond Tan" [EMAIL PROTECTED] Subject: Off topic: transfer database to palm Hello guys, I know this is off topic but just can't help asking members from the list as this is where the expertise are. Does anyone ever used a HP200lx palmtop and make use of the database and sucessfully ** http://libretto.basiclink.com - Libretto mailing list http://libretto.basiclink.com/archive - Archives http://www.picante.com/~gtaylor/portable/faq.html - FAQ ---UNSUBSCRIBE--- mailto:[EMAIL PROTECTED]?subject=cmd:unsubscribe UNSUBSCRIBE DIGEST-- Use above but add DIGEST to the subject line... **
Fw: Off topic: transfer database to palm
Date: Mon, 19 Feb 2001 20:13:19 +0800 From: "Raymond Tan" [EMAIL PROTECTED] Subject: Fw: Off topic: transfer database to palm Sorry clicked on send before finished typing. - Original Message ----- From: Raymond Tan To: [EMAIL PROTECTED] Sent: Monday, February 19, 2001 8:07 PM Subject: Off topic: transfer database to palm Hello guys, I know this is off topic but just can't help asking members from the list as this is where the expertise are. Does anyone ever used a HP200lx palmtop and make use of the database and and exported them to the palm. Appreciate any comments as I am unable translate/export the *.gdb for the HP200Lx to the palm. My problem is not with synchronizing but with importing/ exporting; and I can't afford to re-input a few hundred clients record. Thanks in advance ** http://libretto.basiclink.com - Libretto mailing list http://libretto.basiclink.com/archive - Archives http://www.picante.com/~gtaylor/portable/faq.html - FAQ ---UNSUBSCRIBE--- mailto:[EMAIL PROTECTED]?subject=cmd:unsubscribe UNSUBSCRIBE DIGEST-- Use above but add DIGEST to the subject line... **
