Re: circular letter
I do stuff like this with LaTeX directly, though I do design the files
in LyX and then pull them into Perl :-)-O
There there is also a LaTeX package to pull in CSV files, but forgot
what its name is :-)-O
el
On 2012-04-05 21:20 , John O'Gorman wrote:
:
On 04/04/2012 02:25 AM, Jörg Kühne wrote:
Dear List
Is it possible to write (with Lyx) a circular letter with an
arbitrary letter pattern?
I have written perl programs which allow mail merge in insurance
companies for things such as renewal notices, price quotation, etc.
The main idea is that the user creates a normal LyX letter template
(using the article class - we found the letter classes were not suited
to NZ conventions). Where details particular to a client were to be
inserted, you put perl expressions e.g. ${title} ${firstname}
${lastname} etc.
A database program runs an SQL query and, for each row returned, builds
list of perl assignments
e.g.
${firstname}=John;
${lastname}=Smith;
...
and writes these to a file with a .rec suffix
Then the lyxmerge program loops through the .rec file, effectively
assigning the database values for each client then reads the template
and writes to an output file. Works beautifully giving the usual superb
typesetting.
Perl is most suitable for this because of its weird notion of using
distinctive syntax for variables. More pleasant languages like Python
do not.
When I wrote this many years ago, I also took the trouble to create
scripts to insert tables of data into the template. This involved using
some supplied perl library scripts which came with LyX.
The LyX developers now use python for this sort of thing and I haven't
kept my scripts up to date with current LyX versions.
If you want more detail, I'll happily pass on the scripts to those who
want them.
John O'Gorman
Re: circular letter
I do stuff like this with LaTeX directly, though I do design the files
in LyX and then pull them into Perl :-)-O
There there is also a LaTeX package to pull in CSV files, but forgot
what its name is :-)-O
el
On 2012-04-05 21:20 , John O'Gorman wrote:
:
On 04/04/2012 02:25 AM, Jörg Kühne wrote:
Dear List
Is it possible to write (with Lyx) a circular letter with an
arbitrary letter pattern?
I have written perl programs which allow mail merge in insurance
companies for things such as renewal notices, price quotation, etc.
The main idea is that the user creates a normal LyX letter template
(using the article class - we found the letter classes were not suited
to NZ conventions). Where details particular to a client were to be
inserted, you put perl expressions e.g. ${title} ${firstname}
${lastname} etc.
A database program runs an SQL query and, for each row returned, builds
list of perl assignments
e.g.
${firstname}=John;
${lastname}=Smith;
...
and writes these to a file with a .rec suffix
Then the lyxmerge program loops through the .rec file, effectively
assigning the database values for each client then reads the template
and writes to an output file. Works beautifully giving the usual superb
typesetting.
Perl is most suitable for this because of its weird notion of using
distinctive syntax for variables. More pleasant languages like Python
do not.
When I wrote this many years ago, I also took the trouble to create
scripts to insert tables of data into the template. This involved using
some supplied perl library scripts which came with LyX.
The LyX developers now use python for this sort of thing and I haven't
kept my scripts up to date with current LyX versions.
If you want more detail, I'll happily pass on the scripts to those who
want them.
John O'Gorman
Re: circular letter
I do stuff like this with LaTeX directly, though I do design the files
in LyX and then pull them into Perl :-)-O
There there is also a LaTeX package to pull in CSV files, but forgot
what its name is :-)-O
el
On 2012-04-05 21:20 , John O'Gorman wrote:
> :
>> On 04/04/2012 02:25 AM, "Jörg Kühne" wrote:
>>> Dear List
>>>
>>> Is it possible to write (with Lyx) a circular letter with an
>>> arbitrary letter pattern?
> I have written perl programs which allow mail merge in insurance
> companies for things such as renewal notices, price quotation, etc.
> The main idea is that the user creates a normal LyX letter template
> (using the article class - we found the letter classes were not suited
> to NZ conventions). Where details particular to a client were to be
> inserted, you put perl expressions e.g. ${title} ${firstname}
> ${lastname} etc.
>
> A database program runs an SQL query and, for each row returned, builds
> list of perl assignments
> e.g.
> ${firstname}="John";
> ${lastname}="Smith";
> ...
> and writes these to a file with a .rec suffix
> Then the lyxmerge program loops through the .rec file, effectively
> assigning the database values for each client then reads the template
> and writes to an output file. Works beautifully giving the usual superb
> typesetting.
>
> Perl is most suitable for this because of its weird notion of using
> distinctive syntax for variables. More pleasant languages like Python
> do not.
>
> When I wrote this many years ago, I also took the trouble to create
> scripts to insert tables of data into the template. This involved using
> some supplied perl library scripts which came with LyX.
> The LyX developers now use python for this sort of thing and I haven't
> kept my scripts up to date with current LyX versions.
>
> If you want more detail, I'll happily pass on the scripts to those who
> want them.
>
> John O'Gorman
>
>
>
>
>
>
Re: circular letter
On 04/04/2012 02:25 AM, Jörg Kühne wrote: Dear List Is it possible to write (with Lyx) a circular letter with an arbitrary letter pattern? I'm sure this can be done with pstricks or tikz, but I don't use them myself. Richard
Re: circular letter
:
On 04/04/2012 02:25 AM, Jörg Kühne wrote:
Dear List
Is it possible to write (with Lyx) a circular letter with an
arbitrary letter pattern?
I have written perl programs which allow mail merge in insurance
companies for things such as renewal notices, price quotation, etc.
The main idea is that the user creates a normal LyX letter template
(using the article class - we found the letter classes were not suited
to NZ conventions). Where details particular to a client were to be
inserted, you put perl expressions e.g. ${title} ${firstname}
${lastname} etc.
A database program runs an SQL query and, for each row returned, builds
list of perl assignments
e.g.
${firstname}=John;
${lastname}=Smith;
...
and writes these to a file with a .rec suffix
Then the lyxmerge program loops through the .rec file, effectively
assigning the database values for each client then reads the template
and writes to an output file. Works beautifully giving the usual superb
typesetting.
Perl is most suitable for this because of its weird notion of using
distinctive syntax for variables. More pleasant languages like Python
do not.
When I wrote this many years ago, I also took the trouble to create
scripts to insert tables of data into the template. This involved using
some supplied perl library scripts which came with LyX.
The LyX developers now use python for this sort of thing and I haven't
kept my scripts up to date with current LyX versions.
If you want more detail, I'll happily pass on the scripts to those who
want them.
John O'Gorman
Re: circular letter
On 04/04/2012 02:25 AM, Jörg Kühne wrote: Dear List Is it possible to write (with Lyx) a circular letter with an arbitrary letter pattern? I'm sure this can be done with pstricks or tikz, but I don't use them myself. Richard
Re: circular letter
:
On 04/04/2012 02:25 AM, Jörg Kühne wrote:
Dear List
Is it possible to write (with Lyx) a circular letter with an
arbitrary letter pattern?
I have written perl programs which allow mail merge in insurance
companies for things such as renewal notices, price quotation, etc.
The main idea is that the user creates a normal LyX letter template
(using the article class - we found the letter classes were not suited
to NZ conventions). Where details particular to a client were to be
inserted, you put perl expressions e.g. ${title} ${firstname}
${lastname} etc.
A database program runs an SQL query and, for each row returned, builds
list of perl assignments
e.g.
${firstname}=John;
${lastname}=Smith;
...
and writes these to a file with a .rec suffix
Then the lyxmerge program loops through the .rec file, effectively
assigning the database values for each client then reads the template
and writes to an output file. Works beautifully giving the usual superb
typesetting.
Perl is most suitable for this because of its weird notion of using
distinctive syntax for variables. More pleasant languages like Python
do not.
When I wrote this many years ago, I also took the trouble to create
scripts to insert tables of data into the template. This involved using
some supplied perl library scripts which came with LyX.
The LyX developers now use python for this sort of thing and I haven't
kept my scripts up to date with current LyX versions.
If you want more detail, I'll happily pass on the scripts to those who
want them.
John O'Gorman
Re: circular letter
On 04/04/2012 02:25 AM, "Jörg Kühne" wrote: Dear List Is it possible to write (with Lyx) a circular letter with an arbitrary letter pattern? I'm sure this can be done with pstricks or tikz, but I don't use them myself. Richard
Re: circular letter
:
> On 04/04/2012 02:25 AM, "Jörg Kühne" wrote:
>> Dear List
>>
>> Is it possible to write (with Lyx) a circular letter with an
>> arbitrary letter pattern?
I have written perl programs which allow mail merge in insurance
companies for things such as renewal notices, price quotation, etc.
The main idea is that the user creates a normal LyX letter template
(using the article class - we found the letter classes were not suited
to NZ conventions). Where details particular to a client were to be
inserted, you put perl expressions e.g. ${title} ${firstname}
${lastname} etc.
A database program runs an SQL query and, for each row returned, builds
list of perl assignments
e.g.
${firstname}="John";
${lastname}="Smith";
...
and writes these to a file with a .rec suffix
Then the lyxmerge program loops through the .rec file, effectively
assigning the database values for each client then reads the template
and writes to an output file. Works beautifully giving the usual superb
typesetting.
Perl is most suitable for this because of its weird notion of using
distinctive syntax for variables. More pleasant languages like Python
do not.
When I wrote this many years ago, I also took the trouble to create
scripts to insert tables of data into the template. This involved using
some supplied perl library scripts which came with LyX.
The LyX developers now use python for this sort of thing and I haven't
kept my scripts up to date with current LyX versions.
If you want more detail, I'll happily pass on the scripts to those who
want them.
John O'Gorman
circular letter
Dear List Is it possible to write (with Lyx) a circular letter with an arbitrary letter pattern? Best regards Joerg -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
circular letter
Dear List Is it possible to write (with Lyx) a circular letter with an arbitrary letter pattern? Best regards Joerg -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
circular letter
Dear List Is it possible to write (with Lyx) a circular letter with an arbitrary letter pattern? Best regards Joerg -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
personalized circular letter
hello, Lyx is a really professional tool to write good things! Now, i want to write a letter for the members of our charitable organization. Is it possible, to write personalized circular letter (german: Serienbrief), using an existing database (Ms Access, possibly exported as CSV)? this option would be really useful in Lyx! Thanks! Sincerely yours Christian
Re: personalized circular letter
Christian Kuhn schrieb: Lyx is a really professional tool to write good things! Now, i want to write a letter for the members of our charitable organization. Is it possible, to write personalized circular letter (german: Serienbrief), using an existing database (Ms Access, possibly exported as CSV)? This is possible. LyX's examples folder contains an example address database and 3 example LyX files showing how this is done. regards Uwe
Re: personalized circular letter
Christian Kuhn schrieb: but these are own layouts. Is it possible to use it in dinbrief or g-brief2, too? No, you need to use the Koma-Script letter class. But this class has the same features as the g-brief classes and even more. First, i have to export the .mdp to .txt/csv. Then this file to .adr? (– search suitable tools/converters) It should be easy to program a csv2adr converter. When this is not possible for you, look at the koma-script documentation ftp://ftp.ctan.org/tex-archive/macros/latex/contrib/koma-script/scrguide.pdf) what can be done. When you don't find anything there, ask at http://komascript.de/ (German website) I'm sure that some of the koma-script users already programmed a converter. (Googling gives me this converter: http://www.komascript.de/node/94 ) Would be nice, if these infos would be ‚findable‘ in the Wiki. It is not yet in the Wiki, so please create a Wiki page when you got it working for you. I could post your answers in the Ubuntuusers-Forum. Sure. regards Uwe
personalized circular letter
hello, Lyx is a really professional tool to write good things! Now, i want to write a letter for the members of our charitable organization. Is it possible, to write personalized circular letter (german: Serienbrief), using an existing database (Ms Access, possibly exported as CSV)? this option would be really useful in Lyx! Thanks! Sincerely yours Christian
Re: personalized circular letter
Christian Kuhn schrieb: Lyx is a really professional tool to write good things! Now, i want to write a letter for the members of our charitable organization. Is it possible, to write personalized circular letter (german: Serienbrief), using an existing database (Ms Access, possibly exported as CSV)? This is possible. LyX's examples folder contains an example address database and 3 example LyX files showing how this is done. regards Uwe
Re: personalized circular letter
Christian Kuhn schrieb: but these are own layouts. Is it possible to use it in dinbrief or g-brief2, too? No, you need to use the Koma-Script letter class. But this class has the same features as the g-brief classes and even more. First, i have to export the .mdp to .txt/csv. Then this file to .adr? (– search suitable tools/converters) It should be easy to program a csv2adr converter. When this is not possible for you, look at the koma-script documentation ftp://ftp.ctan.org/tex-archive/macros/latex/contrib/koma-script/scrguide.pdf) what can be done. When you don't find anything there, ask at http://komascript.de/ (German website) I'm sure that some of the koma-script users already programmed a converter. (Googling gives me this converter: http://www.komascript.de/node/94 ) Would be nice, if these infos would be ‚findable‘ in the Wiki. It is not yet in the Wiki, so please create a Wiki page when you got it working for you. I could post your answers in the Ubuntuusers-Forum. Sure. regards Uwe
personalized circular letter
hello, Lyx is a really professional tool to write good things! Now, i want to write a letter for the members of our charitable organization. Is it possible, to write personalized circular letter (german: Serienbrief), using an existing database (Ms Access, possibly exported as CSV)? this option would be really useful in Lyx! Thanks! Sincerely yours Christian
Re: personalized circular letter
Christian Kuhn schrieb: Lyx is a really professional tool to write good things! Now, i want to write a letter for the members of our charitable organization. Is it possible, to write personalized circular letter (german: Serienbrief), using an existing database (Ms Access, possibly exported as CSV)? This is possible. LyX's examples folder contains an example address database and 3 example LyX files showing how this is done. regards Uwe
Re: personalized circular letter
Christian Kuhn schrieb: but these are own layouts. Is it possible to use it in dinbrief or g-brief2, too? No, you need to use the Koma-Script letter class. But this class has the same features as the g-brief classes and even more. First, i have to export the .mdp to .txt/csv. Then this file to .adr? (–> search suitable tools/converters) It should be easy to program a csv2adr converter. When this is not possible for you, look at the koma-script documentation ftp://ftp.ctan.org/tex-archive/macros/latex/contrib/koma-script/scrguide.pdf) what can be done. When you don't find anything there, ask at http://komascript.de/ (German website) I'm sure that some of the koma-script users already programmed a converter. (Googling gives me this converter: http://www.komascript.de/node/94 ) Would be nice, if these infos would be ‚findable‘ in the Wiki. It is not yet in the Wiki, so please create a Wiki page when you got it working for you. I could post your answers in the Ubuntuusers-Forum. Sure. regards Uwe
