Questions tagged [datatool]

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

28 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
103 views

tcolorbox longtabu breakable don't repeat the header

I make a long table using tabu in tcolorboxenvironment but I do not manage to get the headline repeat on the second page : I try with and without endfirsthead \documentclass{article} \usepackage[...
4
votes
0answers
211 views

Checkboxes and TextFields within Datatool csv tables

I've got a sample csv table with three columns - Pet, Names and Number. It's a list of Cats and Dogs, their respective names and the occurrence of each name. i.e. The order of Cats or Dogs in the ...
3
votes
0answers
78 views

Search paths for DTLloaddb from datatool

I have a couple of CSV files I read via DTLloaddb. And these files are scattered over multiple folders. So far, DTLloaddb seems to require a direct (absolute or relative) path to the filename. Is ...
3
votes
0answers
57 views

How to create template longtable/datatool code?

Consider the MWE below (TexLive '15, pdflatex). I have multiple datafiles which need to be displayed in different tables. Currently I have copied table code like MWE multiple times. Q1: But, what is ...
2
votes
0answers
49 views

Check if a datatool DB has an existing member

Using the code from How to check if a datatool db has an existing member with the same problem (build a datatool DB with unique strings) it works well as long if there is not an additional level (here ...
2
votes
0answers
59 views

Is there a way to create a database and extract data from it through a command?

I have looked up packages such as datatool, but I am not quite sure if they would be able to perform this function. The basic idea is that I would like to have a database similar to a bibtex file, ...
2
votes
0answers
59 views

Using package datatool in standalone class

I wish to use package datatool in the standalone class (or with the standalone package, whichever works). I want datatool to print each row in the csv file on different page and standalone to crop ...
2
votes
0answers
53 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 ...
1
vote
0answers
46 views

\rowcolor and nested loops with datatool package

I can't explain why using \rowcolor into a nested datatool loop gives this strange behavior: The code: \documentclass{article} \usepackage[table]{xcolor} \usepackage{datatool} \begin{filecontents*...
1
vote
0answers
32 views

Where should the datatool package be loaded?

Trying to build the following MWE fails (at least here: TL2019, lualatex) \documentclass{article} \usepackage{fontspec} \usepackage{unicode-math} %\usepackage{datatool}%<-- loading the package ...
1
vote
0answers
25 views

datatool: How to read out values, if *.table-format is given

I have an external file, named jobname.word.table (*.table-format!), with its content # aaa # bbb # x y type 3.1415927e+000 5.0000000e+000 i 2.0000000e+000 3.0000000e+000 i (BTW: I can not change ...
1
vote
0answers
50 views

How to load a non-separating comma with datatool/DTLloadrawdb

I would like to load in a key,value type list using \DTLloadrawdb: \DTLloadrawdb{vars}{"variables.txt"} variables.txt: key,value customerName,Acme Corp customerAddress1,1600 Pennsylvania Ave NE ...
1
vote
0answers
52 views

Conditional execution based on existence of key/value pair in datatool

This question is a confirmation and a follow-up using the code from this question I'm preparing a template, which relies on some texts which will be provided in a CSV file (ex, disclaimer text, large ...
1
vote
0answers
58 views

Dynamic datatool group by

I found this code in datatool group by? \documentclass{article} \usepackage{filecontents} \begin{filecontents*}{ff14.txt} ClassID; Schueler_Name; Schueler_Vorname; Subject 5a; Stiner; Markus; Big ...
1
vote
0answers
386 views

Package datatool Error: Can't assign \company : there is no key `*' in data base `*'

Hy, i'm having problem with the \DTLforeach in my table. LaTeX returns the following error: Package datatool Error: Can't assign \company : there is no key Company' in data baseprodutosAloe'. ...\...
1
vote
0answers
56 views

datatool & etoolbox - more expansion shenanigans

This is the code in question: \documentclass{article} \usepackage{etoolbox} \usepackage{datatool} \usepackage{longtable} \usepackage{fp} \def\initialValue{10} \DTLnewdb{thisEntryDBWarehouse} \...
1
vote
0answers
105 views

Datatooltk doesn't show text in greek

I would like to create a database of exercises using the datatooltk program along with the datatool package. My text is in greek and this is a snapshot of two exercises written within datatooltk in a ...
1
vote
0answers
43 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
59 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 other ...
1
vote
0answers
158 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 ...
0
votes
0answers
23 views

Access specific db rows with datatool

tl;dr: I am looking for the datatool equivalent of what, in pure SQL, would be SELECT MembershipType FROM members WHERE ID = 1. I have a problem with datatool. I can load and loop through my db with ...
0
votes
0answers
22 views

A bubble-plot graph and labels from time series with repeating series data

I have a time-series and multiple lines for the same dimension (each for a diferente year). How can I get yticklabels from CSV data to have the right label at Y axis? I tried to set the labels using \...
0
votes
1answer
30 views

How to do custom ordering with Datatool

So I have some data for a rock climbing guide I'm writing. In the last page I want to list all the routes, sorted by grade. The thing is that the conventional sorting doesn't apply here. Quick ...
0
votes
0answers
18 views

Displaying author names with initials of the first name with databib

I'm using the databib package to load a bib file but I can't find how to display the author's first name with initials (i.e. instead of John Doe display Doe, J.). \usepackage{databib} \begin{document}...
0
votes
1answer
65 views

A database for a Psalter

I would like to create a book (to be exact a psalter). Basically it is a database issue. I have on one hand a tex document (to be exact currently it's still a word document) with all the psalms and on ...
0
votes
0answers
14 views

Code with “exam” and “datatools” to generate questions with random wrong choices + correct choice from database?

I have to make several questions with 3 wrong definitions and 1 right definition, that are inside a database. Supposing I have a file like this: color|object red|blood white|horse blue|sky I should ...
0
votes
0answers
34 views

sorting using multiple criteria using datatooltk

in LaTeX, using the datatool package, we can sort databases using \dtlsort and using multiple criteria. for small databases, this is fine -- the compilation time is minimal. for large databases, it ...
0
votes
0answers
107 views

datatool, import from same file or subfile

is it possible to import a database from a normal tabular in the same file or subfile? im thinking about something like this: \documentclass{article} \begin{document} \begin{tabular}{ccc} C1 & C2 ...