Questions tagged [datatool]

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

32 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
0 answers
120 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[...
user avatar
  • 4,449
4 votes
0 answers
222 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 ...
user avatar
  • 41
3 votes
0 answers
137 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 ...
user avatar
  • 2,051
3 votes
0 answers
63 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 ...
user avatar
  • 1,185
2 votes
0 answers
77 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 ...
user avatar
2 votes
0 answers
68 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, ...
user avatar
  • 145
2 votes
0 answers
74 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 ...
user avatar
2 votes
0 answers
510 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'. ...\...
user avatar
2 votes
0 answers
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 ...
user avatar
  • 21
1 vote
0 answers
11 views

Is it possible to change cell color conditionaly in datatool?

I have a .csv which is something like this: N,A,B 64,50,64 128,128,120 Reading it with: \begin{table}[ht] \footnotesize \DTLloaddb{mytable}{mytable.csv}% Load CSV data \centering \...
user avatar
  • 77
1 vote
0 answers
107 views

Template to write cheque

I would like to use latex to write cheques as perfect word placement is only possible with it. For this, I would require to do following things Set page size to cheque size Write current date in ...
user avatar
  • 6,237
1 vote
0 answers
20 views

where should my .csv file be for the package datatool to read it?

I apologize for the newbie question. I just started using LaTeX. Where should my .csv be located if I want the package datatool to read it? I am so sorry for posting such as question.
user avatar
1 vote
0 answers
16 views

datatool - Precautions for lines not becoming too long when writing .csv-file/text-file from database?

This question refers to the LaTeX 2ε-package datatool: You can save a database to .csv-file, which is a text-file, via \DTLsavedb{⟨db name⟩}{⟨filename⟩} You can load a database from .csv-file, which ...
user avatar
  • 23.9k
1 vote
0 answers
42 views

datatool sorting problem - wrong data type?

I created a very small DB with datatool to store two values at each line of the table. First a running ID and second a generated dimension (converted to mm) which I calculated of the width of each ...
user avatar
1 vote
0 answers
71 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*...
user avatar
  • 826
1 vote
0 answers
37 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 ...
user avatar
  • 1,109
1 vote
0 answers
30 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 ...
user avatar
  • 6,335
1 vote
0 answers
69 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 ...
user avatar
  • 107
1 vote
0 answers
58 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 ...
user avatar
  • 433
1 vote
0 answers
70 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 ...
user avatar
1 vote
0 answers
61 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} \...
user avatar
  • 113
1 vote
0 answers
114 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 ...
user avatar
  • 1,389
1 vote
0 answers
46 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. ...
user avatar
  • 11
1 vote
0 answers
63 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 ...
user avatar
  • 219
1 vote
0 answers
164 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 ...
user avatar
0 votes
0 answers
15 views

How to apply a dynamic name for a key in DTLforeach*?

I want to create a new command to quickly get the amount of values of a filtered column. My MWE is: \documentclass{scrbook} \usepackage{datatool,xstring,siunitx} \begin{filecontents*}[overwrite]{PI....
user avatar
0 votes
0 answers
47 views

Looping through values from other database using the ID (primary key) with datatool (using expl3?)

I have set up a database structure for projects and people. The aim is to have the IDs of the people as a value stored in a column of the project database. Now I would like to refer to the people, ...
user avatar
0 votes
0 answers
29 views

Using datatool and xkeyval for calculating sums in tables

I want to build a nice and easy to use interface for users to fill a table with information. Therefor I use xkevval and pass its values to datatool for a proper processing. Now I have a table for ...
user avatar
0 votes
0 answers
34 views

create multi column (icon and text) from database

i create pdf file from my data file (see image) Now i want to create multi column with icon and number (get from data file) logo | logo | logo number 1 | number 2 | number 3 logo | logo | logo number ...
user avatar
  • 1,921
0 votes
0 answers
44 views

Appending Text to Each Line of an External File Using expl3 Syntax

Let us suppose I have an external questionfileone.tex file where each line of this external file represents a particular question text. It is something that I can use, for example, as a test database ...
user avatar
0 votes
1 answer
81 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 ...
user avatar
0 votes
0 answers
122 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 ...
user avatar
  • 129