Questions tagged [database]
{database} is a structured collection of data.
1
vote
0answers
27 views
Document Database Scheme
I wonder if there is any good method to document the relations between tables from a MySQL (or any other database) in LaTeX?
I found this thread Which database documentation software do you use for ...
0
votes
1answer
58 views
Using bibtex to manage a question database
I'm trying to implement the database of problems at http://www.math.canterbury.ac.nz/~m.hickman/LaTeX/LaTeX.shtml
On my Mac, I can get the following to compile with the default file problems.sty, ...
1
vote
0answers
35 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
1answer
54 views
Merging different dbtex database files
I want to merge 2 database files in one file . I tried loading files 11g.dbtex and 2005it.dbtex as shown below
\documentclass[a4paper,9pt]{article}
\usepackage{amssymb,amsthm}
\usepackage{amsmath}
\...
1
vote
1answer
59 views
Importing database (created using datatool) to datatooltk
I have created database (very large database) of questions using datatool as
\DTLnewdb{finitemath}
\long\def\newproblem#1#2#3#4#5#6#7#8#9{%
\DTLnewrow{finitemath}%
\DTLnewdbentry{finitemath}{seq}...
0
votes
1answer
21 views
How do i change linecolors of plotted curves from dataset in tikzpicture?
im using pgfplots and was wondering why i cant change the color. I want to plot a set of data into a diagram as curves, but it seems that the colors seems unchangeable. the first curve in the data is ...
0
votes
0answers
109 views
refresh fndb doesn't refresh
I install miktex in a XPvirtual box on ubuntu
initexmf update fndb
doesn't update anything !
I put my personal files everywhere i could imagine
Always the same
My own files aren't put into the fndb
...
0
votes
0answers
80 views
\pgfplotstableread directly from database
I'm currently exporting CSV data from MySQL via command line, then using it in LaTeX with \pgfplotstableread[col sep=comma]{data.csv}{\mydata}. It would be really a workflow improvement to be able to ...
1
vote
1answer
97 views
TikZ Crow's Foot notation on only one side for documentation
I'm documenting the different versions of database drawing styles.
this link shows how it looks like in a real diagram but my intention is to document only one side of the connection lines. Now the ...
1
vote
1answer
115 views
Either batch transcode (character sets) a whole list of image filenames … or use a character encoding conversion function within the main Tex file?
I am very excited about this code by User @egreg which I will be using to display images of the stroke order of a Chinese character whenever you hover over a certain character.
I changed the code a ...
2
votes
1answer
59 views
How to line up the empty cells with filled cells for array of data structure?
I'm trying to line up the empty cells with filled cells for an array in data structure. Please help!! This is the code I have so far:
\documentclass[tikz,border=2mm]{standalone}
\usetikzlibrary{...
0
votes
0answers
175 views
PHP PDF generation with database (MariaDB) data inclusion
I am searching a way to establish an automated generation of LaTeX PDF documents which will transfer data from MariaDB database. I found this very interesting blog post where author shows, how to use ...
1
vote
1answer
46 views
Output of a tex file is sorted tex file after compilation?
I am using data tool to create the database of questions, where I provided Tag to every question. All database files(50 files) are included in one master file while compiling.After compilation output ...
2
votes
2answers
64 views
pdfs with datas from a special column in a table based database (like excel) + pictures
I am quite new in tex, but now I have to:
compile several pdfs with the same layout (not so important if separated physically in different files or just as pages in one file)
from 1 column of datas ...
3
votes
2answers
121 views
How to find the position of a word in a jumbled sentence?
I have an initial sentence:
The quick brown fox jumps over the lazy dog.
I have a new sentence (which is always a jumble of the original sentence):
The lazy dog jumps over the quick brown fox.
In ...
0
votes
0answers
261 views
How to generate question paper from question bank database?
I have a question bank(hard copy). Each question has multiple attributes(chapter, topics, year, difficulty, marks, no of choice etc.)
I will generate different types(by topics, by chapter, by marks) ...
3
votes
1answer
309 views
Crow's Foot ERM in nice way
I found this post about how to do Crow's Foot ERM Diagrams with Tikz, but it looks strange because the entity is outside the frame. However, it worked.
Then I found this even nicer version and tried ...
4
votes
2answers
95 views
Creating a database containing numbered blocks of TeX-code
I want to create a database consisting of numbered blocks of TeX-code. In particular, I want to do sth like \mycommand{counterName}{Some text} and save a new entry somewhere, to use the Some Text ...
5
votes
2answers
184 views
Read cell value from string array and it assign to macro
How it is possible to read some value from string array and assign it to macro
\documentclass{article}
\usepackage{readarray}[2016-11-07]
\begin{filecontents*}{myfile.txt}
Alfred; Koch
Mildred; Jane
\...
3
votes
1answer
183 views
How to create a database of coordinates to be used with TikZ?
The seeds of this question were planted in my mind and have been growing since I read this answer.
I think it'd be nice to have a database from which some newcommand making use of TikZ picks up ...
10
votes
3answers
307 views
Plotting a Property Graph in the most quick and convenient way
I have to plot some property graph data in LaTeX. When I try to do this task in LaTeX with TiKz, it usually takes me a lot of time, because I always have to
decide which is the best position of the ...
0
votes
0answers
39 views
Auto-generation of tables from previously declared data
Is there any convenient method of storing information and afterwards accessing it again in table format, while being able to modify these tables on-the-fly?
I think a MWE and some corresponding code ...
4
votes
0answers
122 views
Bake LuaSQL into luatex binary on Windows
Further to this question, I want to build luatex on Windows with the LuaSQL library baked in, at least with the ODBC drivers.
This post by Taco Hoekwater back in 2010 walks through the process for ...
5
votes
0answers
274 views
How to install LuaSQL for Lua(La)TeX on Windows with MikTeX [closed]
I would really like to be able to pull data directly from ODBC databases into LuaLaTeX and it seems as if the LuaSQL package is the way to go. But for the life of me, after a couple of days of trying, ...
2
votes
0answers
284 views
Exam class question library
I would like to create a question archive, and have a system to include selected questions in an exam document. I started using Latex last year, and made all my tests, homeworks and exams in Latex ...
12
votes
2answers
356 views
Compare ConTeXt with speedata publisher for database publishing and dynamic page layout
Context mkiv has xml capabilities and it can now publish a xml database. The Speedata publisher is based on LuaTeX and is made to do database publishing.
How do these systems compare? Can ConTeXt do ...
3
votes
0answers
254 views
Dynamic generation of a database ERD
I’ve written (and will open-source it once it’s finished; answers under MIT licence will be preferred, please indicate so if yours is one) a template for postgresql_autodoc that allows me to generate ...
3
votes
1answer
424 views
Link LaTeX Documentation to Excel Data
I am writing documentation for a build log that needs to have part numbers inserted. Rather than have someone go through and update part numbers in a document to reflect revisions and updates, I ...
1
vote
1answer
183 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
550 views
Biblatex & Biber in TexStudio on Windows - Central Bibliography [closed]
Introduction
I have a TeX file that contains a number of references built using TeXStudio on Windows 10 using TeXLive as a backend. Since migrating from BibTeX to BibLaTeX/Biber I haven't been able ...
1
vote
0answers
30 views
Compiling Documents Based on Keywords in a Longer Text
I'm a teacher and I use LaTeX for all my exams. I would like to create a database of exam questions and attach multiple keywords to each question. Then, I would like to be able to generate a ...
7
votes
3answers
3k views
Creating a relational database schema
A database systems book at our school depicts a relational schema like this :
I've been trying to recreate a similar schema using LaTeX, so far I use a whole bunch of single-row tabular environments ...
2
votes
0answers
41 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 ...
2
votes
1answer
176 views
How to read vCard information for envelope printing
I am planning to write a lot of letters in the near future. Since I am going to prepare the letters with LaTeX I also want to print the envelope addresses with it. All the address information is in a ...
2
votes
2answers
243 views
Looking for a LaTeX resource library
I'm a teacher, writing different kinds of documents with a lot of cultural resources that I have to organise with a catalog, then filter to retrieve ressources I want to import into my document, and ...
5
votes
1answer
303 views
Recommended database to handle large amounts of text for LaTeX automation [closed]
I am automating the production of LaTeX files but am noticing that depending on the selected database and scripting language there can be length limitations on the character strings being retrieved.
...
3
votes
0answers
657 views
Generating pdf after reading from database [closed]
I am new to Tex and I want to generate a PDF after taking some data from oracle SQL database. I researched a lot and I came to solution that I will have to write a C++ code for this. The C++ code will ...
3
votes
1answer
170 views
Which command to get words from table?
I have the following table:
\begin{filecontents*}{table.dat}
cane 1.5
gatto 3
\end{filecontents*}
from which I have to take cells separately for the plot. The numeric values can be easily gotten ...
1
vote
0answers
192 views
Select records from database based on condition/tags
I would like to build a database where each record has some tags. Then I want to output some fields of the records that contain a given tag. If it is possible, I would also like to output the ...
5
votes
1answer
4k views
Getting specific row/column values from a csv file to use in text, figures or table cells
I am trying to do the following:
read a csv (or other similar format) external file with numerical and string data into an object;
reference/get an specific value from such object to use into an ...
3
votes
1answer
997 views
Database style reports in LaTeX
I see plenty of questions around that demonstrate that csv files or database tables can be imported and formatted (based on templates and existing knowledge of the data structure) using LaTeX.
My ...
2
votes
1answer
860 views
How to merge data and create multiple documents?, similar to personalized mailings
I would like to use LATEX combined with EXCEL data files (or CSV if it were neccessary) to create "proof of payment".
Supose a list of people
John McEnroe, NYC (USA), 110.23$, 10$,May......
Mary ...
2
votes
1answer
5k views
citing an online database
I have to cite a dataset from World Bank.
What I write is the following:
\usepackage{natbib}
\begin{document}
..., Data from \cite{WB2014}.
\bibliographystyle{apa}
\bibliography{mybib}
\end{document}
...
7
votes
2answers
623 views
Extract data from excel file with lualatex
I have an Excel file that I use as a database. Of course, there are a lot of entries (more than 4000) and I don't want to use all the data to create my PDF.
So I was thinking of using LuaLaTeX to ...
2
votes
1answer
557 views
“pdflatex: Not writing to” error when using python [closed]
I use python3 (with code not from me) to insert data from a database (bsddb3) into a LaTeX document and I receive the following error messages:
pdflatex: Not writing to .aux (openout_any = p).
! I ...
7
votes
3answers
390 views
Importing text file into Latex by character
So I want to import a text file into latex character by character and format the individual characters by changing their color. So for instance, 'a' would be the color blue, 'b' would be red etc.
How ...
2
votes
1answer
258 views
A BibTeX-like package for images?
Is there something akin to BibTeX that can be used for images? It would be helpful to have an image database, wherein static information like image source and date could be kept and referenced.
2
votes
2answers
107 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 ...
4
votes
2answers
124 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; ...
1
vote
1answer
1k 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 ...
