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

learn more… | top users | synonyms

0
votes
0answers
14 views

Load CSV file + landscape

I hope someone is able to help me. I'm trying to create landscape pages, that are holding my survey items. After several tries with CSV files, I wrote everything by hand, but it's just too inflexible, ...
3
votes
1answer
38 views

Datapie: gaps between slices

I need to remove the gap between the green and cyan slices as shown below: Mwe: \documentclass{article} \usepackage{datapie} \begin{filecontents}{test.csv} Name,Quantity "Apples",30 "Pears",25 "...
1
vote
1answer
11 views

datatool package: Looking for sth like \xDTLassignfirstmatch, but w/ partial (not exact) match

Problem statement I use the datatool package's \xDTLassignfirstmatch macro to determine the due date of a given assignment (which is identified by a short code such as ex1 or rd2) from a .csv file ...
0
votes
1answer
24 views

Datatool : automatically add a new entry / use

I am a newbie with latex I have a file, just for test, ListeEleves.csv nom,prénom Avogadro,Amédéo Bohr,Niels Copernic,Nicolas Einstein,Albert I would like to get nom,prénom,ID,IDInitials ...
8
votes
2answers
168 views

Suppress ampersand in external text

I am going to create a number of letters by using the datatool package to import data from external files. Everything works smoothly except getting the company names correct as these may contain ...
1
vote
0answers
21 views

DTLoad from Start to End Record?

Assume I want to use DataTool to display CSV data in a Latex Table. However, my CSV table, is say 1000 lines long, and I can only display 50 on a page. So I what I am looking for is a solution to ...
1
vote
0answers
41 views

import cvs file with special characters as table in latex

I am trying to import a cvs file with special characters to my latex file using scvsimple however, I am getting some errors. I tried many suggestions from the forum and net but non worked for me. ...
3
votes
2answers
67 views

Best way to align table cells at an operator?

I have some large upper triangular tables in csv form like this: , A, B, C D, $-10 \pm 2$, $52 \pm 40$, $9 \pm 3$ C, $8 \pm 300$, $411 \pm 1$ B, $9 \pm ...
5
votes
3answers
618 views

Can't use utf8 encoding with datatool

I am using datatool to manage tables and I am getting errors when the data.csv file (encoded either as UTF-8 or ANSI) has characters like 'á'. I can get it around by having data.csv encoded as ANSI ...
6
votes
2answers
101 views

bold or higlight first row and column of tabe created from csv file

I'm using csvreader from csvsimple package to read csv data and create table from it. My goal is to bold or somehow highlight first row and first column. Here is my MWE: \documentclass{article} \...
1
vote
1answer
45 views

Create table for each CSV file in a directory

Assume I have a directory which has a dynamic number of files match a certain pattern (e.g. tabledata0.csv, tabledata1.csv). Now I want to create automatically create tables out of it. Sometimes it is ...
2
votes
0answers
12 views

Combining \DTLgmeanforall with a conditional in a table created by datatool

I am organizing a list of students an there marks for exams in a .csv Document. These are printed in a tabular environment with the help of datatool. The Table lists the marks an the resulting mean. ...
1
vote
0answers
22 views

Fill column with random numbers using datatool and PGF

Consider the following csv file: column1,column2 line1, line2, I want to fill column2 with random numbers, preferably using PGF (simply because I already know a bit about PGF, but I am open to ...
1
vote
0answers
25 views

Alphabetically sort expanding (newcommand/def) list elements and conditional formatting by iteration

I am attempting to alphabetically sort an array of elements which need to be expanded. I have used a modification of the sorting code in this answer, but I am seeing an unsorted list of 'Doga, Kittya1,...
3
votes
2answers
352 views

API JSON in Latex

I want to know if it's possible to get data from a website using api json in a document .tex I want to do this without luatex because the idea is compile online with the sharelatex website, that does'...
6
votes
1answer
54 views

longtable extends unnecessarily to a second page

The following code displays what I think is a minor but annoying bug. The longtable shown extends to the second page, but there are no columns on the second page, so it is unnecessary to extend the ...
0
votes
0answers
10 views

Formatting datas with datatool package

I have a data file data.txt like First string name|rank|degree| Smith| major|PhD John|Lt| Eugen|St|PhD Part of MWE \input{data.txt} \DTLsetseparator{|} \DTLloaddb{...
3
votes
1answer
45 views

How to Define Variables with Numbers taken from a File?

While working on a scientific topic, I wondered if the following is possible: I want to plot several exponential curves using the \addplot command. The specialty lies in the fact that I need the ...
0
votes
1answer
117 views

Tablespecification and complex column

Based on 2 former questions I have found another problem, I am not aware about that this could be a problem. Question 1: Conditional complex column type Question 2: Generic table definitions But I ...
5
votes
2answers
89 views

How can I use \dtlsort with different alphabets?

Relevant to my other question regarding Norwegian, I need to sort a number of items alphabetically. I use this code to collect a list of items defined by \vocab into a database called vocabsort. \...
2
votes
0answers
20 views

Datatool Long Compilation Time without sorting

Hi this is my first time writing on the forum so please let me know if I do anything wrong. Here is my problematic. I was wandering if I could use LaTeX to help me generate automatically grades ...
7
votes
1answer
75 views

Problem while rendering tabu with data from datatool

I have this strange problem while trying to render a table with tabu package from data gathered with datatool package. Here is a working example: \documentclass[a4paper,10pt]{article} \usepackage[...
1
vote
1answer
40 views

Problem using datatool with longtabu

I'm trying to render some tables with data collected from a CSV file with datatool package and I have a set of data that I want to render that is large enough to span across several pages, so I'm ...
2
votes
1answer
67 views

Datatool CSV file with column having multiple rows of a table

I'm using datatool package to load a CSV file and then print the data in it in several parts of a document. I include a few rows of the CSV file: "mnemonic"|"args"|"shortdescription"|"description"|"...
6
votes
1answer
123 views

Datatool DTLifnull not working

Considering the following database: Name,ID,Gender,Years in Service ,382473856,M,15 Francesca Joestar,461276432,F,10 Chan Ker Mei,463724631,F,5 Hikaru Yagami,154954739,M,10 The first line has the ...
2
votes
1answer
31 views

Datatool can't evaluate email as empty?

Given a test.csv file w/ the content: "BILL TO EMAIL" "test@att.net" "" "test.test@test.org" "test.test@test.org" Processing it w/ datatool in xelatex w/: \documentclass{memoir} \usepackage{...
6
votes
2answers
175 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
50 views

How to compare and see if an expanded command is equal to another

Okay, I'm processing a CSV file using datatool: "TRANSID","DATE","QUANTITY" "141f8b4a-e83e-4222-911a-5a977b4d0afca","11/9/2015","10" "88cdad7e-eb21-4010-94c5-acca8ac2e559a","11/9/2015","5" "f15c1ef0-...
1
vote
1answer
27 views

Datatool and Siunitx - ERROR: Can't break out of anything

i'm constantly getting "! Package datatool Error: Can't break out of anything. " when using data tool and siunitx, if i change the S column definers to normal centered columns (thus not using siunitx) ...
5
votes
1answer
72 views

How to iterate over a comma separated list passed through the datatool interface

I'm trying to iterate over a comma separated list that is itself inside a cell in a .csv file, which I'm reading and iterating over with datatool. As per, How do I process a comma separated list ...
2
votes
1answer
45 views

datatool copy filtered database source to new database target

Look at the following example. Goal is to have to columns which all values of AD and AA as varnames and the corresponding values in each columns.... The file has to be filtered because there are much ...
1
vote
1answer
38 views

Using “datatool” to assign values to newly created commands ends filling all with the last value

I'm trying to create new commands by taking their values via a CSV file and datatool to load them into a DB. The problem is that every created command with this process ends with the values assigned ...
4
votes
2answers
123 views

Iterating through a table using values on the next row

This question is related to Plot Gantt-like plot from csv. Consider the following file data.cvs x,y 0,5 4,7 10,5 13,6 17,5 20,7 24,6 28,5 The second column represents some tasks (there are three ...
3
votes
1answer
50 views

Calculating time difference within datatools foreach

I'm trying to build a table with some calculations from an external file. data.csv: From,To,Task 10:00,11:00,Task1 11:00,13:13,Task2 I'm using datatool to read the csv and it's foreach to output ...
1
vote
1answer
71 views

How to use variable in function call

I get data from a csv file using the datatool package: DTLgetvalueforkey{\thenames}{NAMES}{data}{BD}{#2} \ifthenelse{\equal{\thenames}{\dtlnovalue}}{}{ \specialtext{\thenames} } based on datatool:...
0
votes
0answers
42 views

Labels with envlab not creating separate sticker

I am trying for some time now to basically create letter stickers / labels from a .csv file using TeX. I came up, also looking at this and other sites, with the following code: \documentclass[12pt]{...
2
votes
1answer
104 views

display csv database content

I am a newbie. I need to create a catalogue of the main opera (classic voice) courses in Europe. Each school gets its own page. Each page has specific information about the school: name of the school, ...
2
votes
1answer
114 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} ...
4
votes
1answer
91 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 ...
2
votes
1answer
83 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
78 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
20 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
36 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
38 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
84 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
140 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
296 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... \begin{filecontents*}{test-...
2
votes
2answers
89 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
136 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
53 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 ...