[pilot-db-list] =?iso-8859-1?Q?Re:[pilot-db-list]_pdbtools_questions_2?=

[=?iso-8859-1?Q?<mar...@la...>]

> Hi, I have a few more questions re pdbtools.=0D=0A> =0D=0A> I created t=
he foll ifo file:=0D=0A> title "Demo"=0D=0A> field "String" string "Str"=0D=
=0A> field "OK" boolean=0D=0A> field "Int." integer "45"=0D=0A> field "Fl=
oat" float "1.2345"=0D=0A> field "Date" date "now"=0D=0A> field "Time" ti=
me "now"=0D=0A> field "Note" note=0D=0A> field "Calc" calculated "(+ %2 %=
3)"=0D=0A> view "special"  "String" 45 "OK" 15 "Int." 20 "Float" 25=0D=0A=
"Date" 30 "Time" 25=0D=0A> "Note" 60 "Calc" 60=0D=0A> option backup true=0D=
=0A> extended on=0D=0A> format time "%H:%M"=0D=0A> format date "%d.%m.%Y"=
=0D=0A> =0D=0A> with the foll txt file=0D=0A> =0D=0A>=0D=0A"Teststring1",=
"true","3","1.2345","31.01.1997","21:00","Test\nline1\nline2",=0D=0A> ""=0D=
=0A>=0D=0A"Teststring2","false","5","2.34568","24.01.1999","21:01","Note2=
\nlinie1\nlin=0D=0A> ie2",""=0D=0A> =0D=0A> 1) now field "Calc" calculate=
d "(+ %2 %3)" was just a guess=0D=0Aand it did not=0D=0A> work.=0D=0A>   =
 how is the script passed on?=0D=0A=0D=0ANow dbtools doesn't support the =
script of a calculated field,=0D=0Ayou must run "rebuildb database" on yo=
ur palm to generate the=0D=0Avalue. But if you use the normal mode of gen=
eration of=0D=0Adatabase with csv2pdb you lose yet the script and you mus=
t=0D=0Arewrite it on your Palm. The only way to keep the script in=0D=0Ay=
our database is to use the merge option of csv2pdb, the new=0D=0Aoption i=
n 0.3.5.=0D=0A=0D=0A> 2) re the note "Test\nline1\nline2"=0D=0A>    can t=
he ifo file define that the first line is the heading?=0D=0A>    i.e. is =
something like this possible:=0D=0A> =0D=0A>    field "Note" note "true"=0D=
=0A>    whereby "true" would mean use first line as heading?=0D=0A> =0D=0A=
=0D=0ANow this feature are not supported and i haven't enough time=0D=0At=
o do it quickly. But if you want to wait a little i can=0D=0Aimplement it=
 soon.=0D=0A=0D=0A> 3) On my palm, I edited the script to read  (+ %2 %3 =
) which=0D=0Aworked.=0D=0A> =0D=0A>    when I reconvert the pdb file to c=
sv, using=0D=0A> =0D=0A>    pdb2csv -e demo.pdb out.txt out.ifo=0D=0A> =0D=
=0A>    I get the foll txt file:=0D=0A> =0D=0A> =0D=0A>=0D=0A"Teststring1=
",true,3,1.2345,01/31/1997,21:00,"Test\nline1\nline2","4.2345N/A=0D=0A> "=
=0D=0A> =0D=0A>    This is not the extended csv format in spite of the=0D=
=0Apdb2csv -e.=0D=0A>    In my opinion each column shoud be within "".=0D=
=0A>    Am I correct in inferring that this is an bug?=0D=0A> =0D=0A=0D=0A=
first to use the ifo file in entrance of pdb2csv you must=0D=0Alaunch pdb=
2csv like that:=0D=0Apdb2csv -i in.ifo -e demo.pdb out.txt out.ifo=0D=0As=
econd i don't remember if the others field as string and note=0D=0Acan ha=
ve quote, i'm not sure.=0D=0A=0D=0A> 5)  why is value of the calc. field =
transfered? In my=0D=0Aopinion only the=0D=0A> script=0D=0A>    should be=
 transfered to the ifo file something like=0D=0A> =0D=0A>    field "Calc"=
 calculated "(+ %2 %3)"=0D=0A> =0D=0A>    and the txt file should read=0D=
=0A> =0D=0A>   =0D=0A"Teststring1",true,3,1.2345,01/31/1997,21:00,"Test\n=
line1\nline2",""=0D=0A> =0D=0A>    i.e. the last field should be empty.=0D=
=0A> =0D=0A=0D=0ANo i write the value if it's possible, and i will keep t=
his=0D=0Aoption if no other people reclame the modification. I think=0D=0A=
it's better to have a usable csv file.=0D=0A=0D=0A> 6) In the output text=
 "4.2345N/A",what does N/A stand for=0D=0A> =0D=0A=0D=0Ai don't rememeber=
, it could be a bug.=0D=0A=0D=0A> 7) The date format is reconverted to "%=
m/%d/%Y"=0D=0A>    althouth I have "%d.%m.%Y" on my palm and in my origin=
al=0D=0Aifo file=0D=0A> =0D=0A>    Is this a bug?=0D=0A> =0D=0A=0D=0Ano b=
ecause you don't have ifo file in entrance of pdb2csv=0D=0A=0D=0A> Thanks=
,=0D=0A> =0D=0A> =0D=0A> Hans=0D=0A> =0D=0A=0D=0ASalut,=0D=0AMarc.=0A=0AA=
cc=E9dez au courrier =E9lectronique de La Poste : www.laposte.net ;=0A361=
5 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A