Menu
▾
▴
pilot-db-list
You can subscribe to this list here.
| 1999 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(23) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2000 |
Jan
(15) |
Feb
(11) |
Mar
(6) |
Apr
(47) |
May
(14) |
Jun
(13) |
Jul
(20) |
Aug
(4) |
Sep
(15) |
Oct
(28) |
Nov
(40) |
Dec
(11) |
| 2001 |
Jan
(28) |
Feb
(9) |
Mar
(17) |
Apr
(10) |
May
(26) |
Jun
(31) |
Jul
(83) |
Aug
(66) |
Sep
(106) |
Oct
(82) |
Nov
(139) |
Dec
(76) |
| 2002 |
Jan
(138) |
Feb
(140) |
Mar
(118) |
Apr
(179) |
May
(85) |
Jun
(92) |
Jul
(53) |
Aug
(39) |
Sep
(60) |
Oct
(48) |
Nov
(114) |
Dec
(71) |
| 2003 |
Jan
(76) |
Feb
(58) |
Mar
(83) |
Apr
(70) |
May
(23) |
Jun
(63) |
Jul
(27) |
Aug
(233) |
Sep
(74) |
Oct
(35) |
Nov
(24) |
Dec
(42) |
| 2004 |
Jan
(85) |
Feb
(99) |
Mar
(33) |
Apr
(43) |
May
(17) |
Jun
(29) |
Jul
(17) |
Aug
(16) |
Sep
(17) |
Oct
(5) |
Nov
(3) |
Dec
(15) |
| 2005 |
Jan
(38) |
Feb
(24) |
Mar
(11) |
Apr
(14) |
May
(4) |
Jun
(15) |
Jul
(11) |
Aug
(5) |
Sep
(3) |
Oct
(14) |
Nov
(9) |
Dec
(3) |
| 2006 |
Jan
(9) |
Feb
(4) |
Mar
(4) |
Apr
(2) |
May
(6) |
Jun
(1) |
Jul
(3) |
Aug
(10) |
Sep
|
Oct
(1) |
Nov
|
Dec
(7) |
| 2007 |
Jan
(1) |
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
(3) |
Oct
|
Nov
(2) |
Dec
|
| 2008 |
Jan
(1) |
Feb
|
Mar
(2) |
Apr
(2) |
May
|
Jun
(3) |
Jul
|
Aug
(4) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2009 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Roy, Jean-B. <Jea...@jt...> - 2002-12-12 12:51:30
|
Dear all, Has somebody already succeeded in computing the difference from to date fields in order to calculate a time difference ? I always have a bad argument error message. Is it possible to use current date in scripts ? Thanks for your help. JB |
|
From: ratanachai <rat...@th...> - 2002-12-12 11:45:25
|
ÍÂèҹ͹µ×è¹ÊÒ ÍÂèÒÍÒ·ӡԹ ÍÂèÒËÁÔè¹à§Ô¹¹éÍ ÍÂèÒ¤ÍÂÇÒÊ¹Ò ¶éҤسµéͧ¡ÒÃÃÒÂä´éàÊÃÔÁ·Õè´Õ ¤Çº¤Ùè¡Ñº§Ò¹»ÃÐ¨Ó «Öè§ä´éÊÃéÒ§°Ò¹Ð¤¹ÁÒÁÒ¡ÁÒÂáÅéÇ «Ö觷Óä´é¨ÃÔ§ áÁéáµè˹ѧÊ×Í ¾èÍÃÇÂÊ͹ÅÙ¡ Âѧ¾Ù´¶Ö§¸ØáԨ¹Õé Ëҡʹ㨠¡ÃØ³Ò CLICK ÁÒ´Ù·Õè: www.workforlifestyle.com/max |
|
From: kefadn <ke...@ke...> - 2002-12-11 15:13:48
|
<html>
<head>
<STYLE type=text/css>TABLE {
FONT-SIZE: 10pt
}
BODY {
FONT-SIZE: 10pt
}
A:hover {
COLOR: #ff0000; TEXT-DECORATION: underline
}
A:link {
COLOR: #000000; TEXT-DECORATION: none
}
A:visited {
TEXT-DECORATION: none
}
.hide {
DISPLAY: none
}
.timu {
FONT-SIZE: 11pt
}
</STYLE>
</head>
<body>
<a href="http://www1.mmm666.com" target="_blank"><font color=red>阳光链文本交换</font></a>今日开业,站长特邀你的加盟<br>
阳光链文本交换经过几个月的酝酿,今天终于和大家见面了。阳光链广告交换
系统有多种样式可选，可放置于主页的不同区域、不同位置，更可多选配合使
用以达到更好的宣传效果！<br>从这里进入
<a href="http://www1.mmm666.com" target="_blank">阳光链文本交换主页注册</a>取得代码。<br><br>
<a href="http://www1.mmm666.com" target="_blank"><font color=red>加入阳光广告交换，使你的流量爆增，
让你的网站在最短的时间成长起来......</font></a><br>
<br><center>
<iframe src="http://www1.mmm666.com" width="700" height="600" marginwidth="0" marginheight="0" hspace="0"
vspace="0" frameborder="0" scrolling="NO"> </iframe></center>
</body>
</html>
|
|
From: <aji...@t-...> - 2002-12-09 20:22:42
|
Hi, There were a few mistakes in the csv-file. 1) the comments had to be removed (beginning and end of the file) 2) the first line with headings had to be removed. The headings are defined in the ifo file. Even if you wanted it as the first line, it had a comma to much. 3) I changed the local and GMT format to "time" in the ifo-file 4) I changed the frequency format to "float": This makes it easier to sort. Attaced are the changed thu.ifo, thu.scv files and the csv2pdb_thu.bat file as well as the created thu.pdb-file as a zip-file. copy these to the directory in which the csv2pdb.exe file is and doubleclick on the bat file: it will generate the thu.pdb file! Hans -----Ursprüngliche Nachricht----- Von: pil...@li... [mailto:pil...@li...]Im Auftrag von William P Tracy Gesendet: Montag, 9. Dezember 2002 16:00 An: pil...@li... Cc: William P Tracy Betreff: [pilot-db-list] csv2pdb windows I've seen you product, on my Visor, after the DB was created on Linux. I like it!! I own a Windows machine and I'm having trouble creating a DB for my Visor, using csv2pdb.exe. I would also like to use the html creator version, but can't make it work either. I've attached the info, and csv files that I am using. Can you help me make this work? The command line that I'm using is: csv2pdb -i dailybbcifo.txt thu.csv thu.pdb it complains about title and wrong fields. Thanks, Pat |
|
From: William P T. <wp...@at...> - 2002-12-09 15:00:34
|
title "Daily BBC Program Schedule" field "Local" string field "GMT" string field "Programme Title" string field "Description" string field "Frequency" string option read-only on |
|
From: Larry K. T. <lk...@me...> - 2002-12-06 16:07:46
|
I would suggest that most of these questions come from Windows users (befor= e you flame me - I'm a Windows user, and I didn't say Windows users were st= upid. Windows just allows the novice break into the world of computers).= =20 My recommendations would be to get someone to build a Windows istall app th= at would include the help overlay during the installation process. Then th= e experienced db users can delete the overlay later.=20 =20 Larry=20 =20 =20 Thomas Rohmer <tho...@or...> wrote on 11/28/02 1:10 pm:=20 =20 >I would let the developers =20 >say how they feel about =20 >coding a reduntant =20 >feature, I think I already =20 >know the answer :-)=20 >=20 >My suggestion is to pop up =20 >automatically the main help =20 >box the first =20 >time DB is launched, because =20 >it already answers to those =20 >basic =20 >questions. But we cannot be =20 >sure that the user has =20 >installed the Help =20 >overlay.=20 >=20 >Thomas=20 ---------------------------------------------------------------------------= ---------------- Note: Please update your email address for this user to reflect the=20 new MeadWestvaco Corporation. MeadWestvaco employee=20 email addresses are in the format of us...@Me... This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at pos...@Me.... ---------------------------------------------------------------------------= ---------------- |
|
From: Larry K. T. <lk...@me...> - 2002-12-06 14:02:58
|
Not that these two examples make it a standard, but both Data Viz's Docs2Go= and Plucker use a very similar interface. They both have icons beside the= title that you tap to get a list of options for that database. Secondly, I have an older version of db, but the Help on the main database = page is empty. If this is still the case with the in the newest release I = would suggest that instructions for manipulating databases be added there. Larry >>> Hans Ajiet Holtkamp <aji...@t-...> 11/27/02 06:07PM >>> My second suggestion is to consider why these questions are asked so often. I have pondered over this for quite a while and have come to the conclusion that this must be due to a non-standard user-interface - I hope the software developers will not undestand this as a criticism - it does not mean that the one used at the moment is a bad one - it is just that it does not seem to be a standard, although it is very nice and elegant. In my opinion there are two possiblities - either we keep this non-standard (and elegant and nice) user interface and take into account that we will keep getting such inquiries and keep getting upset about it since the no. of users keep increasing, or else we should change the user interface to be more 'intuitive'. ---------------------------------------------------------------------------= ---------------- Note: Please update your email address for this user to reflect the=20 new MeadWestvaco Corporation. MeadWestvaco employee=20 email addresses are in the format of us...@Me... This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at pos...@Me.... ---------------------------------------------------------------------------= ---------------- |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-06 09:27:27
|
> I've started using Pilot-DB and like it.=0D=0A> My biggest problem righ= t now is the LIST field type=0D=0A> when importing from a .csv (csv2pdb).= =0D=0A> Is there anyway to get the list to be generated from=0D=0A> the i= tems in the .csv file?=0D=0A=0D=0ANo, i tried, but i spent to much time.=0D= =0A=0D=0A> If this is not a feature, what is the chance that the=0D=0A> s= ource code will stable (meaning not changing) long=0D=0A> enough for me t= o take a stab at this featue and send=0D=0A> it back?=0D=0A=0D=0ATo add s= omething, you have the time that you need. If we need,=0D=0Awe will merge= your version :D=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste : = www.laposte.net ;=0A3615 LAPOSTENET (0,13 =80/mn) ; t=E9l : 08 92 68 13 5= 0 (0,34=80/mn)"=0A=0A |
|
From: Mike H. <mik...@ya...> - 2002-12-05 19:31:37
|
I've started using Pilot-DB and like it. My biggest problem right now is the LIST field type when importing from a .csv (csv2pdb). Is there anyway to get the list to be generated from the items in the .csv file? If this is not a feature, what is the chance that the source code will stable (meaning not changing) long enough for me to take a stab at this featue and send it back? __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-05 07:59:35
|
> Thanks you for your help.=0D=0A> =0D=0A> However, I had already used th= is possibility to have a list=0D=0Asorted but for =0D=0A> me I don't unde= rstand interest of list if we can't sort it.=0D=0AMore over, it's =0D=0A>= not really easy to organise all link list created in the=0D=0Afuture wh= en you =0D=0A> have a lot database.=0D=0A> =0D=0A> Dominique.=0D=0A=0D=0A= I think you answer your-self:=0D=0A"FOR ME I don't understand interest of= list if we can't sort it"=0D=0Amy-self i prefer to sort the data by hand= , i prefer to have=0D=0Athe most used item at the top. And i remember tha= t one idea of=0D=0APilot-DB is to have a light database browser.=0D=0AAft= er you can sort by hand your item, when you add new ones in=0D=0Athe list= . I think that it's not so difficult.=0D=0AThat it's my idea, and i don't= speak for the rest of the team.=0D=0ASalut,=0D=0AMarc.=0A=0AAcc=E9dez au= courrier =E9lectronique de La Poste : www.laposte.net ;=0A3615 LAPOSTENE= T (0,13 =80/mn) ; t=E9l : 08 92 68 13 50 (0,34=80/mn)"=0A=0A |
|
From: =?iso-8859-1?Q?<mar...@la...> - 2002-12-05 07:41:56
|
> 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 |
|
From: BURBAN D. <dom...@fr...> - 2002-12-04 22:27:19
|
Thanks you for your help. However, I had already used this possibility to have a list sorted but for me I don't understand interest of list if we can't sort it. More over, it's not really easy to organise all link list created in the future when you have a lot database. Dominique. -----Message d'origine----- De: Uwe Klo? [SMTP:Uwe...@t-...] Date: mercredi 4 decembre 2002 15:03 A: Scott Wallace Cc: BURBAN Dominique; 'pil...@li...' Objet: Re: [pilot-db-list] sort a list Scott Wallace wrote: > On Wed, 4 Dec 2002, BURBAN Dominique wrote: >>Actually, what you answered my question because you say this can be done >>(sort the items in the pop-up menu for a list field). Do you know if it >>possible to add easily in the future this option? > I don't think it is easy. But I will look at it more this week > sometime. In the meantime you can work aroud this using link fields instead of list fields. Put your list in a separate table. Then sort this table. The sort order of the separate table will still be in effect when you select values for the link field. At least it was when I tried this. HTH, Uwe |
|
From: <aji...@t-...> - 2002-12-04 21:18:37
|
Hi, I have a few more questions re pdbtools. I created the foll ifo file: title "Demo" field "String" string "Str" field "OK" boolean field "Int." integer "45" field "Float" float "1.2345" field "Date" date "now" field "Time" time "now" field "Note" note field "Calc" calculated "(+ %2 %3)" view "special" "String" 45 "OK" 15 "Int." 20 "Float" 25 "Date" 30 "Time" 25 "Note" 60 "Calc" 60 option backup true extended on format time "%H:%M" format date "%d.%m.%Y" with the foll txt file "Teststring1","true","3","1.2345","31.01.1997","21:00","Test\nline1\nline2", "" "Teststring2","false","5","2.34568","24.01.1999","21:01","Note2\nlinie1\nlin ie2","" 1) now field "Calc" calculated "(+ %2 %3)" was just a guess and it did not work. how is the script passed on? 2) re the note "Test\nline1\nline2" can the ifo file define that the first line is the heading? i.e. is something like this possible: field "Note" note "true" whereby "true" would mean use first line as heading? 3) On my palm, I edited the script to read (+ %2 %3 ) which worked. when I reconvert the pdb file to csv, using pdb2csv -e demo.pdb out.txt out.ifo I get the foll txt file: "Teststring1",true,3,1.2345,01/31/1997,21:00,"Test\nline1\nline2","4.2345N/A " This is not the extended csv format in spite of the pdb2csv -e. In my opinion each column shoud be within "". Am I correct in inferring that this is an bug? 5) why is value of the calc. field transfered? In my opinion only the script should be transfered to the ifo file something like field "Calc" calculated "(+ %2 %3)" and the txt file should read "Teststring1",true,3,1.2345,01/31/1997,21:00,"Test\nline1\nline2","" i.e. the last field should be empty. 6) In the output text "4.2345N/A",what does N/A stand for 7) The date format is reconverted to "%m/%d/%Y" althouth I have "%d.%m.%Y" on my palm and in my original ifo file Is this a bug? Thanks, Hans |
|
From: kefadn <dd...@16...> - 2002-12-04 18:53:31
|
你好： 这是一封邀请函，收到这封信说明有朋友邀请你来阳光女孩音乐听吧 地址： http://music.kefadn.com http://www.kefadn.com 还有免费电影，软件下载，美眉写真等等。。。绝对不要错过哦！ |
|
From: <Uwe...@t-...> - 2002-12-04 14:03:33
|
Scott Wallace wrote: > On Wed, 4 Dec 2002, BURBAN Dominique wrote: >>Actually, what you answered my question because you say this can be done >>(sort the items in the pop-up menu for a list field). Do you know if it >>possible to add easily in the future this option? > I don't think it is easy. But I will look at it more this week > sometime. In the meantime you can work aroud this using link fields instead of list fields. Put your list in a separate table. Then sort this table. The sort order of the separate table will still be in effect when you select values for the link field. At least it was when I tried this. HTH, Uwe |
|
From: Scott W. <swa...@my...> - 2002-12-04 13:29:52
|
On Wed, 4 Dec 2002, BURBAN Dominique wrote: > Actually, what you answered my question because you say this can be done > (sort the items in the pop-up menu for a list field). Do you know if it > possible to add easily in the future this option? > > Dominique. > I don't think it is easy. But I will look at it more this week sometime. -Scott |
|
From: Thomas R. <tr...@or...> - 2002-12-04 08:56:45
|
Thomas Rohmer wrote... without thinking: > > the -i option does not read metadata from in.ifo but only format options. > For instance, in your in.ifo file, the only useful lines are: > > > format date %d/%m/%Y > > extended on > > separator , > > all other lines are ignored > This remark applies to pdb2csv only. With csv2pdb (as in your example), the -i option actually reads all metadata from the ifo file, plus format options. |
|
From: Thomas R. <tr...@or...> - 2002-12-04 08:45:15
|
Hi Hans, Here are some answers to your question. I hope I'll have time to answer all your questions later. > ********** > Question 1 > ********** > > In the manual it says: > The english manual is out of date, I beleive a new manual is on the way. If you can read French, there is an html doc in the archive. > > ********** > Question 2 > ********** > > Are other types supported too, such as date? > all types are supported excepted link and linked. Calculated fields are partially supported: the scripts are lost in the pdb->csv process, but if you do csv->pdb using the merge mode you can retreive the scripts from the original pdb file. Note fields are supported but you must use the extended CSV mode if the note contains some carriage return characters. > ********** > Question 4 > ********** > > the option > option systemPWD on > does not have any effect! Why is this? I don't know. I will try to look in the code later. > > I created a general csv2pdb.bat file with the foll line in it: > > csv2pdb -i in.ifo in.txt out.pdb > > whereby the -i stands for "Read the info FILE for the metadata" > the -i option does not read metadata from in.ifo but only format options. For instance, in your in.ifo file, the only useful lines are: > format date %d/%m/%Y > extended on > separator , all other lines are ignored > ********** > Question 5 > ********** > > Is there a reason for not mentioning time separately? you can use format time... exactly as you use format date... Thomas |
|
From: BURBAN D. <dom...@fr...> - 2002-12-04 07:49:45
|
Actually, what you answered my question because you say this can be done (sort the items in the pop-up menu for a list field). Do you know if it possible to add easily in the future this option? Dominique. -----Message d'origine----- De: Scott Wallace [SMTP:swa...@my...] Date: mardi 3 decembre 2002 18:53 A: BURBAN Dominique Cc: 'pil...@li...' Objet: Re: [pilot-db-list] sort a list If you mean sort the items in the pop-up menu for a list field, then I don't think this can be done. If you mean sort the records according to some column's data, this easiest way is to tap on the column header (i.e. the title of the column) and then tap the sort ascending or descending. I'm not sure if this answers your question... -Scott > Hi all, > > One time I input all item in a list inside a database, I dont know how > do I sort list before opening of this latest? Thanks you for your help. > > Dominique. > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Get the new Palm Tungsten T > handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en > _______________________________________________ > Pilot-db-list mailing list > Pil...@li... > https://lists.sourceforge.net/lists/listinfo/pilot-db-list > -- ------------------------------------------------------- This SF.net email is sponsored by: Microsoft Visual Studio.NET comprehensive development tool, built to increase your productivity. Try a free online hosted session at: http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en _______________________________________________ Pilot-db-list mailing list Pil...@li... https://lists.sourceforge.net/lists/listinfo/pilot-db-list |
|
From: <aji...@t-...> - 2002-12-03 21:27:32
|
Hi,
I have a few questions re. the new pdbtools:
**********
Question 1
**********
In the manual it says:
quote:
The items in capitals are parameters which you should replace with
actual values. Replace NAME with the name of the field. The TYPE of
the field should be "string", "boolean", or "integer" if the type of
the field is a string, checkbox (true/false), or a number
respectively. The ARGUMENT parameter is used to pass informations
about the field:
string: ARGUMENT = default value (string)
integer: ARGUMENT = default value (integer)
float: ARGUMENT = default value (float)
unquote:
Well, in the first part of the explanation, float is missing, and
float works, so it should read
The items in capitals are parameters which you should replace with
actual values. Replace NAME with the name of the field. The TYPE of
the field should be "string", "boolean", "integer" or "float" if the
type of the field is a string, checkbox (true/false), a whole number
or a floating-point number respectively. The ARGUMENT parameter is
used to pass informations about the field:
string: ARGUMENT = default value (string)
checkbox: ARGUMENT = default value (boolean)
integer: ARGUMENT = default value (integer)
float: ARGUMENT = default value (float)
I would also add that the float must be entered with a "." and not
a "," if that is correct.
**********
Question 2
**********
Are other types supported too, such as date?
**********
Question 3
**********
I have created file called in.ifo:
title "Demonstration"
field "String" string "Str"
field "Check" boolean "-1"
field "Int." Integer "45"
field "Float" float "1.2345"
view "special" "String" 60 "Check" 20 "Int." 25 "Float" 55
format date %d/%m/%Y
extended on
separator ,
option backup on
option inROM off
option copy-prevention off
option systemPWD on
option read-only off
and a text file called in.txt:
"Teststring1","-1", "12","1.233"
"Teststring2","0", "24","2.344"
what is the difference between
option inROM off
and
option read-only off?
**********
Question 4
**********
the option
option systemPWD on
does not have any effect! Why is this?
I created a general csv2pdb.bat file with the foll line in it:
csv2pdb -i in.ifo in.txt out.pdb
whereby the -i stands for "Read the info FILE for the metadata"
I renamed the created file to in.pdb
I created a pdb2csv.bat file with the line
pdb2csv -e in.pdb out.txt out.ifo
and executed the pdb2csv.bat file.
The created out.ifo file reads:
title "Demonstration"
field "String" string "Str"
field "Check" boolean
field "Int." integer "45/0"
field "Float" float "1.2345"
view "special" "String" 60 "Check" 20 "Int." 25 "Float" 55
option backup true
extended on
format time "%H:%M"
format date "%m/%d/%Y"
csvfile "out.txt"
This shows that time can be formated separately. This is not mentioned in
the manual.
**********
Question 5
**********
Is there a reason for not mentioning time separately?
**********
Question 6
**********
what does the default value "45/0" mean? what does "/0" stand for.
I had not defined it in the original ifo file!
You will find these files in the attachment.
It might be a good idea to add these bat files and the example files to
the distributed version since it is easier to edit an existing file for
someone new to command-line based programs than to make one from scratch!
Please comment!
Thanks,
Hans
|
|
From: Scott W. <swa...@my...> - 2002-12-03 16:58:17
|
If you mean sort the items in the pop-up menu for a list field, then I don't think this can be done. If you mean sort the records according to some column's data, this easiest way is to tap on the column header (i.e. the title of the column) and then tap the sort ascending or descending. I'm not sure if this answers your question... -Scott > Hi all, > > One time I input all item in a list inside a database, I dont know how > do I sort list before opening of this latest? Thanks you for your help. > > Dominique. > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Get the new Palm Tungsten T > handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en > _______________________________________________ > Pilot-db-list mailing list > Pil...@li... > https://lists.sourceforge.net/lists/listinfo/pilot-db-list > -- |
|
From: Scott W. <swa...@my...> - 2002-12-03 16:55:13
|
I believe that the concatenate operator is included in the 1.1beta. I will make sure. Currently, this version is available only as a snapshot. I've been doing some debugging on it, and hope to release a real beta version in the next week or two. -Scott On Mon, 2 Dec 2002, Art Sherwood wrote: > Is there (or will there be) any support for a concatenation operation > (combine 2 or more strings) in the script engine? I can't seem to find one > documented. > Perhaps something like (& [a] .. [n])? > > Just think it would be useful. |
|
From: BURBAN D. <dom...@fr...> - 2002-12-03 08:29:23
|
Hi all, One time I input all item in a list inside a database, I dont know how do I sort list before opening of this latest? Thanks you for your help. Dominique. |
|
From: Art S. <art...@qu...> - 2002-12-03 00:14:19
|
Is there (or will there be) any support for a concatenation operation (combine 2 or more strings) in the script engine? I can't seem to find one documented. Perhaps something like (& [a] .. [n])? Just think it would be useful. Thanks, Art Sherwood art...@qu... |
|
From: Anne J. <ann...@al...> - 2002-12-02 16:38:33
|
At 12:27 PM +0100 12/2/02, Chalain Marc wrote: >There is somes trouble to install Pilot-DB databases from Mac, the >PalmDesktop for Mac cuts a part of the database header. Some people >who use Mac know how to shortcut this problem . . . If a Mac user here has found a workaround that allows us to still use all the Pilot-db field types, I'd love to hear it!!!! (In my attempts to work around by using Jfile or MobileDB format databases, I found that I lost all the really useful field types.) Installing the application itself is no problem, but it's of limited use if I lose all my databases (& have to recreate from scratch) next time my Palm Pilot goes kablooey. Anne |
240 messages has been excluded from this view by a project administrator.
