On Fri, Jan 16, 2015 at 08:30:47AM +0100, Alexander Burger wrote:
Then something else must be wrong. The expression
Sorry! My fault!!
Jon was in the unlucky situation of having installed an intermediate
version, where the behavior of '+IdxFold' was just in the process of
small modifications.
Hi Jon,
(de importAddr (F)
(let (Cnt 0 L NIL)
(in F
(while (setq L (split (line) ^I))
(dbSync)
(let Obj (request '(+Prs) 'nm (pack (car L)))
(put Obj 'adr (pack (cadr L)))
(put Obj 'em (pack (caddr L)))
Hi Alex,
Now I have got this import thing working. I added the following code at the end
of the minDbGui.l file:
# To import from tab-separated file, use: (importAddr myAddrDB.csv)
(de importAddr (F)
(let (Cnt 0 L NIL)
(in F
(while (setq L (split (line) ^I))
Hi Alex,
From: picolisp@software-lab.de picolisp@software-lab.de on behalf of
Alexander Burger a...@software-lab.de
Sent: 15 January 2015 16:42
To: picolisp@software-lab.de
Subject: Re: A Minimal PicoLisp DB/GUI Application, Importing
Hi Jon,
(de
Hi Jon,
Yes, I have now repeated my experiment from scratch, importing same
file twice. I get duplicates. Here is my myAddrDB.csv file, just replace
the vertical bars with tabs:
Per|Veien 1|p...@no.no|11223344|712582
Pål|Veien 2|p...@no.no|11223345|712583
Espen Askeladd|Veien
Hi Jon, maybe this script will be of help:
https://bitbucket.org/hsarvell/ext/src/tip/sqlimport.l?at=default
It's very crude but it is trying to handle the SQL - PicoDB
conversion through the constraint that you have to first run it on
table A if A is referenced in table B, and then run it again
On 2015/01/14-14:37, Luis P. Mendes wrote:
Hi,
2015-01-14 12:09 GMT+00:00 Alexander Burger a...@software-lab.de:
I see. So Norway has different systematics with telephone numbers.
I don't understand them, though. In Germany we have the rule that both
0049 123 456 and +49 123 456 are
Hi Alex,
On 13. Jan, 2015, at 15:37, Alexander Burger a...@software-lab.de wrote:
. . .
How difficult would it be to create export and import functions, e.g.
to and from tab-separated files? This could be separate utilities, i.e.
not a part of the GUI.
That's very easy. There is a report
Hi,
2015-01-14 12:09 GMT+00:00 Alexander Burger a...@software-lab.de:
I see. So Norway has different systematics with telephone numbers.
I don't understand them, though. In Germany we have the rule that both
0049 123 456 and +49 123 456 are the same as 0123 456.
The 00 to + conversion is of
Hi Alex,
On 14. Jan, 2015, at 13:09, Alexander Burger a...@software-lab.de wrote:
Hi Jon,
I don’t quite get this. I have done as you suggested, (locale NO
no) and leading 0, so I can now enter a phone number as 099887766. You
say it will be stored internally with leading 47 instead of that
On Wed, Jan 14, 2015 at 05:54:17PM +0100, Alexander Burger wrote:
A simple example would be
(in myAdrDB.csv
(while (split (line) ^I)
(dbSync)
(let Obj (request '(+Prs) 'nm (pack (car L)))
(put Obj 'adr (pack (cadr L)))
(put Obj ...)
Hi Jon, Luis, Rowan,
thanks!
I see that this problem is non-trivial. We need to extend the
localization files loc/??.l
Probably some functional expression or pattern needs to be stored there,
in addition to (or as a replacement of) the country code '*CtryCode'.
Perhaps the Google library gives
Hi Jon,
I’ve got the dump and load working, but I have not yet figured out how
to use the 'csv’ function for import from a file (I took a look at
The 'csv' function can only generate the CSV file (TAB-separated data).
It is not suitable for import.
To import a CSV file, you need to write
Isn't this a non-issue, simply enter and store all numbers regardless
of location with country code + number without leading zero, eg
4912345678?
Will work for all countries everywhere, I never store numbers without
the country code in my mobile nowadays and always works regardless if
I'm in said
On Wed, Jan 14, 2015 at 05:52:02PM +0100, Henrik Sarvell wrote:
Isn't this a non-issue, simply enter and store all numbers regardless
of location with country code + number without leading zero, eg
4912345678?
Yes, as I said, simply use +TextField instead of +TelField.
However, local
Hi Jon,
I don’t quite get this. I have done as you suggested, (locale NO
no) and leading 0, so I can now enter a phone number as 099887766. You
say it will be stored internally with leading 47 instead of that 0, but
Right. You see that if you look directly into the DB.
when I put the mouse
On Wed, Jan 14, 2015 at 01:09:12PM +0100, Alexander Burger wrote:
The '+TelField' (based on the functions 'telStr' and 'expTel') handles
this. What are the exact rules for Norway? And how can we handle this
flexibly?
Alternatively, of course, you could replace '+TelField' with
'+TextField'.
Hi Jon,
I would like the Telephone field to accept 8-digit numbers, which is
common in Norway. At the moment I have to prefix with +47, otherwise I
get Bad phone number format.
You should change the line in the 'main' function
(locale UK)
to
(locale NO no)
Then, entering a number
Hi Alex,
Thanks. A few more questions:
I would like the Telephone field to accept 8-digit numbers, which is common in
Norway. At the moment I have to prefix with +47, otherwise I get Bad phone
number format.
How difficult would it be to create export and import functions, e.g. to and
from
Hi Jon,
When I’m typing in one of the search fields (Name or Address), a box
with possible matches pops up, but quite often there are names/addresses
missing in this box, and I haven’t been able to find a pattern in this.
If I type a (single) j, k, l, e, i or s, then my name comes up, but not
On 2015/01/12-08:34, Alexander Burger wrote:
Hi all,
perhaps this is useful:
A Minimal PicoLisp DB/GUI Application
http://picolisp.com/wiki/?minDbGui
♪♫ Alex
Such clear, precise and informative little gems like this are why I am a fan of
picolisp (the language and the
It's a really good example.
On January 12, 2015 8:34:08 AM CET, Alexander Burger a...@software-lab.de
wrote:
Hi all,
perhaps this is useful:
A Minimal PicoLisp DB/GUI Application
http://picolisp.com/wiki/?minDbGui
♪♫ Alex
--
UNSUBSCRIBE:
Hi Alex!
That's great, thanks!
Best regards,
Mansur
12.01.2015 12:34, Alexander Burger пишет:
Hi all,
perhaps this is useful:
A Minimal PicoLisp DB/GUI Application
http://picolisp.com/wiki/?minDbGui
♪♫ Alex
--
UNSUBSCRIBE: mailto:picolisp@software-lab.de?subject=Unsubscribe
23 matches
Mail list logo