{datatool} is a tool to create and manipulate databases.

learn more… | top users | synonyms

3
votes
1answer
20 views

Generating gls from csv

I'm working off the excellent answer provided here: Creating a gls from a spreadsheet I want to store my entries for the glossaries package in a .csv file, which is (IMHO) easier to edit and ...
1
vote
1answer
25 views

Scrlttr2 and datatool compatability?

I'm interested in writing some form letters. I'm a big fan of scrletter2's features, notably placing the "to" address in just the right place for business envelopes. For the mail merge, I've used ...
3
votes
1answer
31 views

\uppercase with datatool does not work

I can't use \uppercase or \MakeUppercase on data imported using the datatool package. I have a .csv file with all of the author names, abstracts and titles of talks for a conference and I'm creating ...
1
vote
1answer
13 views

error when using expandafter for databib command in indexing command in foreach loop

I'm trying to create an author index using the databib package (datatool) bundle. I can loop over the entries in a BibTeX database and for each entry, loop over the authors using the \foreach command ...
0
votes
0answers
19 views

Datatool package: remove link between variable and value

When I try to create a subset from one db with the help of the datatool package, all my rows contain the same information as the last one. \DTLforeach[\DTLisieq{\tmpjob}{\jobnameoff}]{data}{ ...
2
votes
1answer
21 views

pgffor `foreach` loop over databib macro-generated list

The databib package from the datatool bundle allows one to import BibTeX databases and work with them from within LaTeX. The author field can be accessed as \DTLbibfield{Author}, which returns data ...
1
vote
2answers
43 views

Pre-expansion of moving macro argument

I am using databib package (datatool bundle) to get information out of a BibTeX database for arbitrary use in a LaTeX file. It provides a command to loop over the BibTeX entries. Within such a loop, ...
3
votes
2answers
49 views

Missing \endcsname inserted

I'm almost getting crazy with this TeX error, but however I can't find any effective method to solve this. Here is a mini example which cause the problem, and which i really need in my codes: ...
4
votes
1answer
44 views

csvsimple and longtable (automatic headerline)

Helping a other communitymember (see using csvreader to read from csv giving invalid output) on a csvreading task I have tried to solve a problem, like the following... ...
2
votes
2answers
26 views

Error in class lettre with datatool package

I would like automaticaly write 5 letter with \documentclass[10pt]{lettre}. I 've a CSV file with all my recipient information in mail_bd2.csv like : Titre,Apostrophe,Prenom,Nom,Organisme,Rue,Ville ...
1
vote
1answer
59 views

insert \hline in datatool importing .csv

I'm trying make a table with the datatool package and a .csv created from an Excel file. I'd like this code to be as generic as possible since I will have to import a lot of .csv in this document. ...
1
vote
1answer
48 views

Building a list of non-duplicated labels from text on the fly

As a followup to Difference in compilation time between two slightly different versions I wrote Deleting duplicates from a comma-separated list of strings. Summary of issue: The former question ...
2
votes
1answer
23 views

Spacing and embedded calls to \DTLifnullorempty

It seems that embedding calls to \DTLifnullorempty inside one another leads to an extra space for each call to \DTLifnullorempty. Is there a way to prevent this behavior? In particular, I would like ...
1
vote
1answer
63 views

“Misplaced \noalign” error with datatool

Attempting to compile the following file gives the following error: ! Misplaced \noalign. \pagebreak ->\noalign {\ifnum `}=0\fi \@testopt {\LT@no@pgbk -}4 l.47 \end{letter} ...
3
votes
1answer
73 views

Filesize command amount dependent?

When writing a cv I decided to separate tex file from content. I copied the content to a csv file in order to load it with datatool. But this greatly increases the size of the PDF: Complete content ...
2
votes
1answer
56 views

Difference in compilation time between two slightly different versions

This question is a byproduct of earlier questions: Creating a list of labels automatically for use by datatool and Automatically creating a table from datatool using references in the text. Here is a ...
1
vote
1answer
67 views

Creating a list of labels automatically for use by datatool

The following is partly a followup to an earlier question, and Enrico's answer, as given in Automatically creating a table from datatool using references in the text. The method outlined there works, ...
4
votes
1answer
120 views

Document using datatool is slow to compile

The following document uses the datatool package, and is slow to compile, though the resulting PDF file is only 3 pages long. On my computer it takes of the order of 17 sec. I'm hoping for suggestions ...
4
votes
1answer
87 views

Creating table using tabularx and datatool from csv file

I am trying to create a vocabulary list from a csv file containing the vocabulary using tabularx and datatool. This is what I have tried: \documentclass{article} \usepackage{datatool,tabularx} ...
1
vote
1answer
65 views

Speed up CSV loading with datatools package?

I am using the datatool package to read some CSV files. I've used the csvsimple package before, which I finally managed to break by adding more and more requirements to the mix. Now I'd like to switch ...
3
votes
1answer
47 views

Merging two datatool databases from different files but with the same columns

Consider the following example code. This is not quite an MWE, because it contains elements that are strictly unnecessary. I'd like to merge the two datatool databases, corrDB and docDB vertically ...
3
votes
1answer
75 views

Conditional table construction with datatool

The following minimal example creates a 3-row table width a horizontal rule separating rows 2 and 3: \documentclass{article} \usepackage{filecontents,datatool,booktabs} \usepackage[table]{xcolor} ...
1
vote
1answer
141 views

Creating lables - using data from excel sheets - selecting specific column

I have to create desk slips (labels). For this data is available in excel sheet. The column names are - RollNo, Subject, Venue of Exam (examination center). Presently we are creating desk slips using ...
3
votes
2answers
59 views

On sorting a string with multiple entries

In my LaTeX-file I create a variable \authors which could have content: [Doe] John Doe; [Potter] Harry Potter; [Clinton] Bill Clinton; [Obama] Barack Obama; ... This is dynamically created, so I ...
1
vote
0answers
71 views

Problem with packages siunitx, datatool and xkeyval

After having read several articles concerning the siunitx problem I am still struggling with my problem. Your comments and your help is highly appreciated. The following error occurs when I switch on ...
4
votes
2answers
72 views

Is there a way to store information in something like an array

I'd like to store some basic information on people in a file, and want to be able for LaTeX to process this information. More specifically, I'd like to store something like: id:john1; fname: John; ...
3
votes
1answer
445 views

I want to take a CSV file, process the data, and generate a report file, where can I go to learn how to do this?

I have access to MATLAB for data processing, and TeXstudio for the report. I am familiar with MATLAB about 100x more than LaTeX. The data flow I am trying to create: CSV file is generated with 50 ...
6
votes
4answers
306 views

Sending Same Letter to multiple addresses

I'm sending the same letter to multiple addresses. The addresses are stored in a csv document. I've so far created a loop to create multiple letters, but I have not been successful in finding a ...
1
vote
1answer
216 views

Custom table from csv file (multiple header rows)

I would like to create custom tables from .csv files. By custom I mean, that I only want LaTex to read in the body of the table, i.e. "a & b & ... \ ..." but I want to write my own header and ...
1
vote
1answer
80 views

Problem with gb4e's spacing when using datatool

Say that I have a .csv file with sentences in IPA, their glosses, and their translations that I want to incorporate into a document. However, using datatool to loop over the .csv doesn't work with ...
1
vote
1answer
113 views

bulk letter with datatool: how to handle linebreak csv-field

I'm generating a bulk letter using datatool. Therefore I import my data from an external csv-file using the following syntax: \documentclass[11pt]{dinbrief} \usepackage[T1]{fontenc} ...
0
votes
1answer
221 views

Dynamic Courtesy Receipt PDF Generator For PHP

The title needs a bit of help, but I'm wondering if it's possible to dynamically create a beautiful customized receipt for purchases from my website using LaTeX, where LaTeX gets its data from my ...
0
votes
0answers
42 views

Display bibtex entry in latex document

I'm trying to display a bibtex code written in a .bib file inside a document. Does anyone know how to include bibtex code, e.g. : @book{Darwin59, author={Darwin,Charles}, title={On the Origin of ...
0
votes
0answers
31 views

Logarithmic axes using \DTLplot

I am working with the dataplot package for quite some time and find it useful for my purpose. But now I have to display a log-log diagram and failed to find a suitable function; is there any command ...
3
votes
1answer
183 views

Mail merge using datatool with letter class

I am trying to adapt this question/answer on how to do mail merge to work with the letter document class. The linked answer works great for me, but when I try to change the document class to letter I ...
1
vote
1answer
180 views

Pie Chart with datatool

I am totally stuck with a problem. Is there any appropriate package for pie charts? I am using datatool right now. But there are a lot of problems: E.g. the labels are overlapping. Do you have any ...
2
votes
1answer
113 views

Modify Pie Charts (delete the labels)

I am totally new to LaTeX and pgfplots,... I copied an example for pie charts from another blog. The problem: I don't want the labels in my pie chart. Could you please help me? This is what I have ...
3
votes
1answer
137 views

Using \DTLforeach for defining multiple \newtcolorbox

Concerning this project, I'm now trying to define an own tcolorbox environment for every conversational partner by creating a "conversational partner database" with the datatool package and then using ...
5
votes
3answers
347 views

Use datatool to read a row from a CSV file, then use the variables in the document?

I'm confused about how to use "datatool" to read variables from a row in my database, and pass them on to be formatted in my text. I don't want to make a table, but that's about all there seems to be ...
8
votes
0answers
162 views

What kind of data can be gleaned from a PDF created in LaTeX?

As I use LaTeX for the creation of many of my business instruments, and since I send these all over the world to different clients I just wanted to know if there are any data embedded in a PDF that ...
4
votes
0answers
99 views

How can I typeset *some* fields from a (YAML) dataset?

I'm building a dataset of sorts with long strings, tags, some of which will be used for survey research (a q-sort, actually). This dataset needs to: be reasonably human-readable play nice with ...
4
votes
1answer
105 views

datatool group by?

I try to display the results of a survey where students of 2 different classes could choose their favorite subject. In the result table I find Surname, Name, ClassID, Subject. The data in the file ...
0
votes
0answers
21 views

Adding blank pages when generating multiple copies of a document [duplicate]

I'm generating multiple copies (right now, 2, but a general solution would be nice) of a letter with minor variations using datatool. I just realised that if I'm printing it double-sided. and if the ...
1
vote
0answers
491 views

File `datatool.sty' not found [closed]

I am making a latex document with class {article} I want to make a page for glossaries I added the below in my preamble \usepackage{datatool} \usepackage{datatool-base} \usepackage{glossaries} ...
1
vote
1answer
93 views

Inserting names on invitations, two per page in specific locations

I am doing a wedding invitation and I want the RSVP to have the person's name on it. I also need the name to appear in another, very specific location on the invitation. The invitation only takes up ...
4
votes
1answer
229 views

Rotating a pie chart

How can I rotate a pie chart with 50,50 distribution so that it is divided vertically rather than horizontally? \documentclass{beamer} \usepackage{multicol} \usepackage{datapie} \usetheme{Warsaw} ...
2
votes
1answer
62 views

datatool: why does \DTLifstringeq not work in the address part of a bulk letter

I'm trying to create a bulk letter using the package dinbrief and datatool. I created the whole letter and except from one problem everything works fine (that's why I don't want to change any major ...
2
votes
1answer
259 views

The datatool package is not reading the csv file

I have the csv file as follows: The csv file in sublime looks like this: Now the code reads each quote and author in the quote environment at the footer in the center. But it doesn't print the ...
1
vote
1answer
640 views

The footer styling in fancyhdr - Center text

\fancypagestyle{myfancy}{ \fancyhf{} \fancyhead[LE,RO]{\slshape\nouppercase{\leftmark}} \fancyfoot[LE,RO]{\tikz[baseline={(0,0)},anchor=center] ...
3
votes
1answer
174 views

Why does datatool/pgfplots only plot for last row in table?

I'm trying to use datatool to put a bunch of circles on a pgfplots plot. I tried the following: \documentclass{article} \usepackage{datatool,tikz,pgfplots} \pgfplotsset{compat=1.9} ...