Re: [pilot-db-list] Import data in dbase with calculated fields

[Yedidyah Bar-D. <di...@ta...>]

On Fri, Jul 09, 2004 at 05:38:19PM +0200, ft...@li... wrote:
> Hi,
> 
> I created the database file with palm (db 1.1), I set up all the fields.
> Some of them are "calculated" type.
> I've in the desktop (Windows XP) some data (excel, csv and so on).
> 
> The query is that I would like to import the data into the dbase in my palm, and obviuosly I would like that calculated field will work and being correctly fill in.
> 
> In Dbeditor (v 0.7.4.0) using import it create a new pdb file, by the way dbeditor do not support calculated fields, also paste and copy do not work.
> 
> Periodically I need to import data in the pdb file..... so import with db and after to create calculated fields (4 and a little complicated it is not easy).

Exporting calculated fields is known to not work well. I don't know why
yet, but it's probably not very hard to fix. Exporting and Importing the
scripts is much more work. I do now know of a problem to import them, in
the following meaning: Suppose you have a table with one data field f1
and one calculated field c1. You enter some lines of data into f1 and c1
is calculated. Now you export the db to a csv/inf, add some more lines
in your PC, and import it back. Sadly, as I said before, the export you
did before did not export the scripts, and obviously the import dropped
them. But there is a workaround: There is a program called par (hit 4 in
google) that can take out the appInfo part from the pdb. So you can try
to do the following: keep the appInfo of the original pdb, then do what
you want (pdb2csv, edit, csv2pdb), then take the data (with par) from
the new one, and the appInfo from the original. Not everything will work
well - e.g. if you have integer fields with autoincrement they won't
work well. But you can try playing with this.

I had intentions to make a new tool that will export/import everything,
but did not progress much. Maybe in a few weeks I will have time again
to work on this.

> 
> By the way... this is my first query in this mailing list, so .... hi to everybody.

Hi :-)
-- 
Didi