Questions tagged [datatool]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
22 views

Datatooltk in windows 10 - working in GUI-mode, not working in batch mode or by invocation from arara

From my latest question, asking for help (Automatic indentation done for subfiles with arara and latexindent not working) I am now also having problem with great database-management program datatooltk....
1
vote
1answer
28 views

if odd even number from datatool

follow topic tcolorbox: specific width and height settings for odd and even pages minimal code: \documentclass{article} \usepackage{datatool} \usepackage{filecontents} \usepackage[strict]{...
1
vote
1answer
65 views

algorithm Logic: Make Loop for each 3 rows in datatools

i want to make loop with process: Current: (with below code) each row create one page Box A, B, C: Same data from one row of datatool Need update: Create one page only \Break=break or each 3 ...
3
votes
1answer
47 views

Can DTLinitials access \fnames?

Question UPDATED with MWE Using datatool to read a CSV file into LaTeX, I am able to obtain first names using {\fnames=fnames}, and then print using \fnames. Sometimes, though, I would like to show ...
4
votes
1answer
46 views

Print range of many group rows in datatools

I use this code from this answer: \documentclass{article} \usepackage{filecontents} \begin{filecontents*}{product.tex} %Type =1,2...10 No,Type,Name,Description 1,1,A1,D1 2,1,A1,D2 3,1,A1,D3 30,1,A1,...
1
vote
0answers
27 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 ...
2
votes
0answers
46 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, ...
3
votes
1answer
49 views

update values in datatool

i try to update single values within a datatool DB. unfortunately, it only works for the first time. when i update the second values the first one will be also set to the value of the second one. when ...
1
vote
0answers
20 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 ...
3
votes
1answer
45 views

How display next row before current row when use datatool?

i use datatool, and want display next data before current data, is possible? I need help in code "diplay here data of (AAACoding+1), CCCCoding+1...)" My Minimal Coding: \documentclass[a5paper,...
0
votes
1answer
17 views

Null/blank in last column when use datatools

i use datatools to create pdf But last column display Null or blank My minimal coding: \documentclass[a5paper,oneside,8pt]{article} \usepackage[a5paper,landscape,left=1.0cm,right=0.3cm,top=0.5cm,...
0
votes
1answer
91 views

Color rows with \rowcolor and datatool \DTLforeach loop

I try to obtain alternate colored rows (just like the table is shown in the figure) using the datatool package and the \rowcolor command. I am following the datatool user manual example for striped ...
0
votes
0answers
34 views

automating job application process with datatool and awesome-cv

I wish to produce attractive cover letters as a result of a mail-merge process using datatool and awesome-cv. Details of target employers and job posts are stored into an external csv file called "...
1
vote
2answers
84 views

How to treat with dcolumn tabular format and colored values?

I found here this trick for formated text coloring for use with dcolumn package. However, it seems roughly redefine the \DC@endright statement and gives two wrong behaviours with values which have ...
2
votes
1answer
39 views

Replace zero with blank in datatool

I have merge 3 tables from code in link: merge 3 csv file and create new file Table E = Merge of 3 Tables (A,B &D) But how i can change cell in Table E = 0 with blank? If cell in Table A, B, D ...
3
votes
1answer
70 views

Display Box A or Box B if then condition

I am using datatool and want to display \posterbox A, hide box B if \TextA = value, if \TextA = blank display \posterbox B and hide box A. Box A & Box B are different: Image, item, color, ...
1
vote
1answer
54 views

merge 3 csv file and create new file

i read topic: Merge two .csv files and add missing rows? And i want change some things when i merge 3 different files This minimal working example: \documentclass{article} \usepackage{filecontents} ...
3
votes
1answer
43 views

Text instead of dotted line if text is not blank

I use datatool. And I have this flow: if text A or text B is blank, a dotted line is displayed if text A or text B is not blank, a dotted line is removed and text A/text B is displayed My ...
0
votes
1answer
33 views

How to replace last comma by dot after last encountered word?

My question is related but with some complication. How to replace last comma by dot after last encountered word? % !TeX program = pdflatex % !TeX encoding = utf8 \...
1
vote
1answer
20 views

How to replace last comma by dot in comma-separated words from datatool's database?

How to replace last comma by dot in comma-separated words from datatool's database? Can it be done without calculating the number of entries in the database? % !TeX program = pdflatex ...
4
votes
1answer
136 views

Overhanging vertical bars in tabular

My question stems from an adaptation of the solution shown here : Generating lists and tables of items from commands in the document The idea is to sum up the reviews of a given document in a table. ...
2
votes
0answers
40 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 ...
0
votes
1answer
50 views

Add created parameters in child file to main.tex

My code/idea from 2 topics: Input a parameter from another file filecontents: select rows of group to display File parameters.tex: \documentclass{article} \usepackage[utf8]{vietnam} \usepackage{...
3
votes
1answer
64 views

Possible Bug in passing variables from CSV

I think there's a bug in calling decimal numbers from CSV files. Have a look. Create a Folder. Add a CSV file called texDemo.CSV with the following in it. UniqueID,Name,DecimalPercentageComplete,...
2
votes
1answer
30 views

Macro for expanding macro arguments to gb4e's \gll

This is a followup question to Problem with gb4e's spacing when using datatool, where I was trying to loop over glosses stored in a CSV with datatool and print them with gb4e's \gll. The issue was ...
1
vote
1answer
59 views

When DTLforeach is used with a condition, DTLiflastrow does not work

In the following code, my dataset is {1,2,3,4}. With no filter, DTLiffirstrow will return true at "1" and DTLiflastrow will return true at "4". This is what I expect from these functions. When I ...
1
vote
1answer
36 views

How to make tikz macro work with two arguments in this MWE?

I want to generate a table from a csv file using the very helpful tool datatool and insert a round photo of each person surrounded by a circle, the color of which should be taken from the provided csv ...
2
votes
1answer
126 views

Plotting a smooth curve in 3D from external coordinate file

I want to create a 3D plot from previously calculated coordinates saved in a file, like "xz.dat". This contains the data as : x z 0.5 0 0.54 0.01 0.58 0.01 0.62 0.02 0.66 0.03 0.7 0.03 0.74 0.04 0....
13
votes
3answers
526 views

Populate information from a csv file into a LaTeX document (specifically into the fields/arguments of commands therein)

I have some personal information stored in a plain CSV file personal_info.csv in the following format: personal_info.csv 83 Fancy Avenue,Nowheresville,Gotham City 24061 123 456 7890 someone@xyz.com ...
5
votes
4answers
184 views

use foreach to read columns from a csv file?

How can I read columns from a external csv file using a foreach statement? e.g. if the content of the csv file is as follows: {0,0,0},black, {1,1,0},yellow, {1,0,1},pink And I would like to use it ...
1
vote
1answer
67 views

pgfplots/datatool: automatic standard error ellipse calculation and plotting

I am looking for a way to automate the process of calculating the standard error ellipse from tabular data in pgfplots. In some sense, this is a generalization of this question and this one I assume ...
2
votes
1answer
48 views

Use datatool input to enable beamer frame

I want to use the value of a flag imported from a datatool database (stored in an external .csv file) to enable (or disable) a beamer frame. The .csv file is of the form: \begin{filecontents*}{test....
0
votes
1answer
39 views

Creating invoice iterating over a database with datatool

I'm trying use datatool to iterate over a CSV file in order to create an invoice. This is what I have: \documentclass[12pt]{letter} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{...
2
votes
1answer
112 views

Create invoice retrieving data from a CSV file

I'm trying to assemble invoices based on CSV data. I found this example: Combining invoice and datatool to create serial invoices This is the code: \documentclass{letter} \usepackage{invoice} \...
0
votes
0answers
31 views

How to fill in a tex template using csv file (datatool and subfile packages?) [duplicate]

I would like to create several index cards from information stored in a csv file, such that for a csv file such CSV.csv{ name,letter,LETTER,number Name1,a,A,1 Name2,b,B,1 Name3,c,C,1} I get single ...
1
vote
1answer
75 views

LaTeX is not working fine with Datatool

I created Database of questions in LaTeX using datatool (named nayi17n-ii) as shown below \DTLnewdb{CS2} \long\def\newproblem#1#2#3#4#5#6#7#8#9{% \DTLnewrow{CS2}% \DTLnewdbentry{CS2}{seq}{#1}% ...
3
votes
1answer
53 views

Datatool: File ended while scanning use of \@dtl@next

I am trying to operator on a CSV file on a row-by-row basis with the following dummy code. \documentclass{article} \usepackage{datatool} \usepackage{filecontents} \begin{filecontents*}{data.csv} x,...
3
votes
1answer
114 views

Modifying A Specific Example of Interlinear Text and Running it on Tex Live 2018

I am trying to modify this specific solution to interlinear texts, which I found here. % !TEX TS-program = XeLaTeX \documentclass[11pt]{book} \usepackage[margin=1in]{geometry} \usepackage{titlesec} \...
0
votes
1answer
40 views

\DTLfetch not working with Variable

I have csv database loaded in data variable. I am trying to fetch value from particular column given an another column name and its value. I am using following code \forloop{i}{1}{\value{i} < 30} {...
1
vote
0answers
32 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 ...
3
votes
2answers
134 views

How to align the last element on the right when using \hfill?

I am making a wine list from a CSV file (see my first question here: How to import data from excel and format it as text in LaTeX?) and I need to align the prices on the right. To do this, I used ...
2
votes
1answer
169 views

How to calculate a contingency table?

I am trying to calculate a contingency table of two discrete variables name and location. Missing levels should be 0, while each cell should be the count of each name-location combination. My initial ...
2
votes
1answer
33 views

How to count discrete variables in a dataset?

I am trying to count how many times each gender occurs in the table. The I would like to print those values inline with the rest of the text (I don't need any tables, but I am \documentclass{article}...
1
vote
1answer
48 views

Package datatool Error: \DTLforeach nested too deeply

I'm using datatool, and I have tried to nest the \DTLforeach function four times, to create multiple tables from various csv files. Naturally the title error comes up. How come the \DTLforeach ...
1
vote
1answer
211 views

Highlight maximum values for each row in large csv

I am loading a rather large .csv file (>100 rows) that I need to print in longtable format and highlight the maximum value in each row. I found this thread Highlighting Extremal Values in Table which ...
1
vote
0answers
40 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 ...
2
votes
1answer
58 views

Case insensitive data fetch (DTLfetch) with package datatool

In one of my setup, I'm making simple setup for my users, meaning that most of the strings are saved in a data tool DB, and they can retrieve it by activating a command. So I've created simple ...
1
vote
2answers
50 views

\DTLifinlist crashes when used with \dtlexpandnewvalue & the character 'é'

The following code gives the error ! You can't use `macro parameter character #' in horizontal mode. \DTLifinlist ...4->\def \@dtl@doifinlist ##1,#1,## ...
4
votes
2answers
338 views

How to extract the currency symbol?

Within the Datatool package, we find the currency data type. A currency data type is a currency symbol followed by an integer or real number. How can I extract the currency symbol out of a currency ...
2
votes
3answers
44 views

Vertical spacing with \cmidrule with datatool table

I would like to insert a cmidrule when I have an empty line in a table produced by the datatool package and also use \bottomrule. Both of these yield excess vertical space above the line: How do I ...