Re: issue with t-scancsv.lua

[Pablo Rodriguez <oinos@gmx.es>]

On 12/09/2014 12:45 AM, Jaroslav Hajtmar wrote:
> Hi Pablo.
> I am glad that my library for you to use ...
> I noticed that you have in your CSV file header with column names (ie. 
> head of CSV document). I do not know if you noticed the option put this 
> information into scancsv.lua library. This is done via the command 
> \setheader. In this case library does not consider the first line of the 
> CSV file as a data line.

Hi Jaroslav,

I know that, ubt I removed it in the sample I sent because I edited the
CVS file with gedit and I forgot that the first line was the header (I
was in a hurry).

I actually use \setheader to ignore it, since headers with non-ASCII
characters or spaces are problematic. I’m fine invoking \cA, \cB, \cC...

> From the header of CSV file are now macros (from header names)
> contain later data from rows of the CSV file (changing in cycle). In
> addition, you can also use internal hooks. CSV file can even contain
> macros (must be defined before processing the CSV file).

Well, your sample needs further study. Internal hooks are fine (once I
know what they really are and how to use them ;-)), but macros are
totally out of question. CVS files come from Excel users (I don’t even
mention what TeX or ConTeXt might be).

Many thanks for your help,


Pablo


> Example of use hooks etc. eg. Here:
> 
> \usemodule[scancsv]
> 
> \setuppapersize[C6, landscape]
> \setuppagenumbering[location=]
> 
> % Structure of CSV file - you can use macros in CSV table too
> % name;address;postcode;city;linecolor
> % ME;STREET;0000;HERE;\green;
> % You;Square;9999;There;\red;
> % we;another Square;111;anyplace;\blue;
> 
> 
> % Library is making \name, \address, \postcode, \city and \linecolor macros
> % when you using \setheader command.
> 
> % Your example:
> \unexpanded\def\lineaction{
> \edef\lowercasename{\lowercase{\name}}
> \edef\uppercaseaddress{\uppercase{\address}}
> name: {\linecolor\name}\ -- lowercase name: \lowercasename\crlf
> address: \address\ -- upercase address: \uppercaseaddress\crlf
> \postcode\ \city\crlf
> 
> \page
> }
> 
> 
> % My example with hooks:
> \unexpanded\def\tablelineaction{%
>      \edef\ehname{\hname}%
>      \edef\ehaddress{\haddress}%
>      \edef\ehpostcode{\hpostcode}%
>      \edef\ehcity{\hcity}%
> \ehname \ehaddress \ehpostcode \ehcity %
> }
> 
> % My simple example with hooks:
> \def\simpletablelineaction{%
> \bTD{\linecolor\numline}\eTD\hname\haddress\hpostcode\hcity%
> }
> 
> 
> \setsep{;} % set separator
> \setheader % set information about header
> \setfiletoscan{mailmergedatatable.csv}
> 
> \starttext
> % process all file
> 
> Here is begin of processing...
> 
> \filelineaction
> 
> And here is end....
> 
> \page
> 
> And now we can use internal hooks:
> 
> \def\bch{\bTD } % begin column hook
> \def\ech{\eTD} % end column hook
> \def\blinehook{\bTR } % begin line hook
> \def\elinehook{\eTR} % end line hook
> \def\bfilehook{\bTABLE } % begin CSV file hook
> \def\efilehook{\eTABLE} % end CSV file hook
> 
> Here is begin of processing...
> 
> %process all file too (endless cycle)
> \doloopif{1}{==}{1}{\tablelineaction}
> 
> And here is end....
> 
> \page
> 
> Printing only specific data:
> 
> \doloopif{\name}{eq}{You}{\tablelineaction}
> 
> \page
> 
> Simpletablelineaction:
> 
> \doloopif{1}{==}{1}{\simpletablelineaction}
> 
> \page
> 
> Another using of hooks:
> 
> \def\bch{\bgroup\linecolor\bf } % begin column hook
> \def\ech{\egroup,\ } % end column hook
> \def\blinehook{Here is new \numline. line of CSV file:\crlf } % begin 
> line hook
> \def\elinehook{\hairline\par} % end line hook
> \def\bfilehook{Here is all CSV file:\blank[2*big] } % begin CSV file hook
> \def\efilehook{\par Here is end of file processing\par} % end CSV file hook
> 
> \doloopif{1}{==}{1}{\tablelineaction}
> 
> 
> 
> \stoptext


-- 
http://www.ousia.tk
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : http://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________