pilot-db-list

[pilot-db-list] Merge databases

[Mike <pa...@mi...>]

Is there any plan to allow two databases (same format) to be merged =
together
during a beam, or some other way?  My wife and I both have palms (m500s) =
and
keep DVD and book lists on them using pilot-db (which is wonderful, I =
found
it easier to use 'out of the box' than the trials of several other
commercial products) and would like to each be able to add entries and =
then
merge them together.

Thank you,
Mike

Re: [pilot-db-list] Merge databases

[John S. W. <web...@qw...>]

Hi,

Since you have mention of Linux in your signature...

I use Linux and I like the utilities csv2pdb and pdb2csv, available on
the pilot-db site (compile yourself programs). I would try something
like "pdb2csv db1.pdb" and likewise for your other db, db2.pdb, to
create text csv files. then use Linux/unix tools to merge them.

Maybe something like
$ cat db1.csv db2.csv > db_all.csv
$ cat db_all.csv | sort | uniq > db_merged.csv

Then use csv2pdb to create the pdb file. csv2pdb also works well if you
create a database in a spreadsheet and then export it to csv from the
spreadsheet. I did a reference of win2000 commands in a spreadsheet and
then used csv2pdb like this to create the pdb, for example...

$/usr/local/bin/csv2pdb -o NAME="w2k_commands" -f "Command,String" -f
"Note,String" -f "Category,String" -b -T "W2k_Commands" -m Rebuild 
./w2k_commands.csv ./W2k_Commands.pdb

The above unix commands should be pretty close to what you want. The man
pages can help if they don't do quite what you want.

I hope this helps.

John

On Tue, 2003-12-30 at 13:27, Mike wrote:
> Is there any plan to allow two databases (same format) to be merged together
> during a beam, or some other way?  My wife and I both have palms (m500s) and
> keep DVD and book lists on them using pilot-db (which is wonderful, I found
> it easier to use 'out of the box' than the trials of several other
> commercial products) and would like to each be able to add entries and then
> merge them together.
> 
> Thank you,
> Mike
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: IBM Linux Tutorials.
> Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
> Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
> Click now! http://ads.osdn.com/?ad_id78&alloc_id371&opk
> _______________________________________________
> Pilot-db-list mailing list
> Pil...@li...
> https://lists.sourceforge.net/lists/listinfo/pilot-db-list
-- 
John S. Weber
web...@qw...
http://www.users.qwest.net/~weberjohns/