General ⇒ Labels from CSV File

[renareto]

Hi,
I need to print some labels. Is there some class (or package) that can do that well?

I'm using \makelabels command of the letteracdp class.
It produce just the first 25 labels, then stops. I've tried with 2 or 3 files, but always the same result.

TIA

Renato

[nlct]

Can you produce a minimal example? Do you get any error messages?

Regards
Nicola Talbot

[renareto]

emh... could it be a 'minimal exampe'?

Code: Select all

Code, edit and compile here:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
\documentclass{letteracdp}
\usepackage[italian]{babel}
%\usepackage{envlab}
\usepackage{graphicx}
\usepackage{fancyhdr}
\usepackage{datatool}
\usepackage[usenames]{color}
\usepackage [normalem]{ulem}
\usepackage[utf8x]{inputenc}
\usepackage{textcomp}
\usepackage{tabularx}
\DTLloaddb{indirizzi}{/home/kde/Dropbox/edil_150/associazione/documenti/ind_sas.csv}
%
\pagestyle{fancy}
%\fancypagestyle{firstpage}{    % note opening bracket
 % \fancyhf{}  %<<<<----- clear all fields
  %\fancyhead[L]{\includegraphics[width=.2\columnwidth]{edil150}\quad \hrulefill}
%\fancyfoot[c]{\tiny
%\begin{tabularx}{\textwidth}{|X|X|X|}
%\textbf{sede Legale}&\textbf{sede operativa}&\textbf {tel.} 0575 38 28 34 - \textbf{fax } 0575 98 38 78\\
%----------------fine prima riga--------------------- 
%Via Misericordia, 1/Q &Via Luigi Galvani, 25&www.edil150.it\\
%----------------fine seconda riga --------------------
%52042 C. Fiorentino (AR)&52100 Arezzo&presidente@edil150.it\\
%----------------fine terza riga----------------------
%\includegraphics[width=.1\columnwidth]{federterziario}&\includegraphics[width=.03\columnwidth]{cenai}&c.f. 92067640513\\
%---------------fine quarta riga----------------------
%\end{tabularx}}%
%}   % closing bracket
%\fancyhf{}
%\fancyhead[R]{ \includegraphics[width=.2\columnwidth]{edil150}\quad }
%\fancyfoot[C] {\hrulefill}
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Run LaTeX here

the .csv file

Code: Select all

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
nome,via,,cap,localita,prov
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

the most important error, is that it doesn' produce more than 25 labels


TIA

Renato

[nlct]

You have errors in your assignment list:

Code: Select all

1
2
\DTLforeach*{indirizzi}{%
\nome=nome,\cognome=cognome,\via=via,\civico=civico,\cap=cap,\localita=localita,\prov=prov,}{
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Don't have a trailing comma (after \prov=prov), and your CSV file doesn't contain the fields cognome and civio, but those don't cause the problem you describe.

The following works fine for me:

Code: Select all

Code, edit and compile here:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
\documentclass{letteracdp}
\usepackage{datatool}
\DTLloaddb{indirizzi}{test.csv}
\address{Sign. Topolino,\\
via Astuti, 34 \\
 Topolinia}
\makelabels
\begin{document}
\DTLforeach*{indirizzi}{%
\nome=nome,\via=via,\cap=cap,\localita=localita,\prov=prov}{
\begin{letter}{\emph{\textbf{\nome \space }\\\via\space
\\\textbf{\cap},\space \localita\space  \prov}}
\end{letter}
}
\end{document}
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Run LaTeX here

(where test.csv is the name I gave to your CSV file.)

Regards
Nicola Talbot