Use DTLforeach (datatool) within a tabularray table

datatooltabularray

After having populated a datatool database (EarlyCareerPhD) I would like to sort it and print its content within a tabularray-table.
I am aware of expanding macros within tabularray but expanding DTLforeach does not help here.

MWE

\documentclass{scrbook}

\usepackage{datatool,tabularray,xcolor}


\makeatletter
\define@key{EarlyCareerPhD}{project}{\DTLnewdbentry{\crcDB}{project}{#1}}
\define@key{EarlyCareerPhD}{periodStart}{\DTLnewdbentry{\crcDB}{periodStart}{#1}}
\define@key{EarlyCareerPhD}{periodEnd}{\DTLnewdbentry{\crcDB}{periodEnd}{#1}}
\define@key{EarlyCareerPhD}{name}{\DTLnewdbentry{\crcDB}{name}{#1}}
\define@key{EarlyCareerPhD}{nameFirst}{\DTLnewdbentry{\crcDB}{nameFirst}{#1}}
\define@key{EarlyCareerPhD}{fundingSource}{\DTLnewdbentry{\crcDB}{fundingSource}{#1}}
\define@key{EarlyCareerPhD}{topic}{\DTLnewdbentry{\crcDB}{topic}{#1}}
\makeatother




\NewDocumentCommand{\crcEarlyCareerPhD}{ m }{
  \def\crcDB{EarlyCareerPhD}
  \DTLifdbexists{\crcDB}{}{\DTLnewdb{\crcDB}}
  \DTLnewrow{\crcDB}
  \setkeys{EarlyCareerPhD}{#1}
}

\NewDocumentCommand{\crcEarlyCareerPhDtable}{ o }{
  \DTLsort{project,name}{EarlyCareerPhD}
\begin{tblr}[%
  expand=\DTLforeach,
  caption={Completed PhD Thesis}, %TODO
  long
  ]{
    colspec = {m{1cm}m{3cm}m{2.5cm}X[m]m{2.2cm}},
    rowhead = 1,
    column{1} = {font={\bfseries},
      fg = {blue}},
    column{4} = {font={\itshape}},
    row{1} = {font={\bfseries},fg={white}}
  }
  Project %
  & Surname, first name %
  & Type of funding %
  & Topic %
  & Duration\\
  {\DTLforeach{EarlyCareerPhD}{%
    \project=project,%
    \name=name,%
    \nameFirst=nameFirst,%
    \fundingSource=fundingSource,%
    \topic=topic,%
    \periodStart=periodStart,%
    \periodEnd=periodEnd%
  }{
    \project
    & \name, \nameFirst
    & \fundingSource
    & \fundingSource
    & \topic
    & \periodStart --\periodEnd}}\\
\end{tblr}
}
\begin{document}


\crcEarlyCareerPhD{
  project       = {A02},
  name          = {Surname},
  nameFirst     = {Firstname},
  fundingSource = {DFG},
  topic         = {My fancy PhD thesis},
  periodStart   = {YYYY-MM},
  periodEnd     = {YYYY-MM}
}

\crcEarlyCareerPhD{
  project       = {A02},
  name          = {Burname},
  nameFirst     = {Firstname},
  fundingSource = {DFG},
  topic         = {My fancy PhD thesis},
  periodStart   = {YYYY-MM},
  periodEnd     = {YYYY-MM}
}
\crcEarlyCareerPhD{
  project       = {A01},
  name          = {Aurname},
  nameFirst     = {Firstname},
  fundingSource = {DFG},
  topic         = {My fancy PhD thesis},
  periodStart   = {YYYY-MM},
  periodEnd     = {YYYY-MM}
}


\crcEarlyCareerPhDtable
\end{document}

Best Answer

You need to collect table body first (outside tblr environment):

\documentclass{scrbook}

\usepackage{datatool,tabularray,xcolor}

\makeatletter
\define@key{EarlyCareerPhD}{project}{\DTLnewdbentry{\crcDB}{project}{#1}}
\define@key{EarlyCareerPhD}{periodStart}{\DTLnewdbentry{\crcDB}{periodStart}{#1}}
\define@key{EarlyCareerPhD}{periodEnd}{\DTLnewdbentry{\crcDB}{periodEnd}{#1}}
\define@key{EarlyCareerPhD}{name}{\DTLnewdbentry{\crcDB}{name}{#1}}
\define@key{EarlyCareerPhD}{nameFirst}{\DTLnewdbentry{\crcDB}{nameFirst}{#1}}
\define@key{EarlyCareerPhD}{fundingSource}{\DTLnewdbentry{\crcDB}{fundingSource}{#1}}
\define@key{EarlyCareerPhD}{topic}{\DTLnewdbentry{\crcDB}{topic}{#1}}
\makeatother

\NewDocumentCommand{\crcEarlyCareerPhD}{ m }{
  \def\crcDB{EarlyCareerPhD}
  \DTLifdbexists{\crcDB}{}{\DTLnewdb{\crcDB}}
  \DTLnewrow{\crcDB}
  \setkeys{EarlyCareerPhD}{#1}
}

\NewDocumentCommand{\crcEarlyCareerPhDtable}{ o }{%
  \DTLsort{project,name}{EarlyCareerPhD}%
  \def\tblrbody{}%
  \DTLforeach{EarlyCareerPhD}{%
    \project=project,%
    \name=name,%
    \nameFirst=nameFirst,%
    \fundingSource=fundingSource,%
    \topic=topic,%
    \periodStart=periodStart,%
    \periodEnd=periodEnd%
  }{
    \edef\tblrbody{\tblrbody
    \project
    & \name, \nameFirst
    & \fundingSource
    & \fundingSource
    & \topic
    & \periodStart --\periodEnd\\
  }}%
  \begin{tblr}[%
    expand=\tblrbody,
    caption={Completed PhD Thesis}, %TODO
    long
  ]{
    colspec = {m{1cm}m{3cm}m{2.5cm}X[m]m{2.2cm}},
    rowhead = 1,
    column{1} = {font={\bfseries},
      fg = {blue}},
    column{4} = {font={\itshape}},
    row{1} = {font={\bfseries},fg={white}}
  }
  Project %
  & Surname, first name %
  & Type of funding %
  & Topic %
  & Duration\\
  \tblrbody
\end{tblr}
}

\begin{document}

\crcEarlyCareerPhD{
  project       = {A02},
  name          = {Surname},
  nameFirst     = {Firstname},
  fundingSource = {DFG},
  topic         = {My fancy PhD thesis},
  periodStart   = {YYYY-MM},
  periodEnd     = {YYYY-MM}
}
\crcEarlyCareerPhD{
  project       = {A02},
  name          = {Burname},
  nameFirst     = {Firstname},
  fundingSource = {DFG},
  topic         = {My fancy PhD thesis},
  periodStart   = {YYYY-MM},
  periodEnd     = {YYYY-MM}
}
\crcEarlyCareerPhD{
  project       = {A01},
  name          = {Aurname},
  nameFirst     = {Firstname},
  fundingSource = {DFG},
  topic         = {My fancy PhD thesis},
  periodStart   = {YYYY-MM},
  periodEnd     = {YYYY-MM}
}

\crcEarlyCareerPhDtable

\end{document}

Related Solutions

Datatool creating a matrix with 3×3 data \ DTLforeach

Try this code.

The code:

The Ncols parameter sets the number of columns in the width of the text. The figure was created with Ncols =3.

First we load the database index with the file names. They will be displayed in the same order. The file names are irrelevant.

Then we go through all the index entries, opening the named file and loading databases 1, 2, 3, ... and so on, using the [noheader] option.

To display its content we use an internal loop to create another tabular and insert it in a minipage with an auto-adjusted width, to be able to insert Ncols in the width of the text on the page, as a row of the outer tabular.

\documentclass[a4paper]{article}

\usepackage{datatool}
\usepackage{ifthen}% added <<
\usepackage{calculator}% added <<

\newcounter{nrow}
\setcounter{nrow}{1}

\newcounter{Ncols}
\setcounter{Ncols}{3} % set the number of columns in text width <<<<<<<<<<<<<<<<<<<<<<<

\newlength{\Mwidth}
\DIVIDE{1}{\value{Ncols}}{\Wcmd} 
\LENGTHSUBTRACT{\Wcmd\textwidth}{1.5em}{\Mwidth}

\begin{document}    
    \begin{filecontents}{index.csv}
        File
        ONE.csv
        TWO.csv
        alpha.csv
        beta.csv
        gamma.csv
        simon.csv
        dispa.csv
    \end{filecontents}
    \begin{filecontents}{ONE.csv}
        Header 1
        image 1
        description 1 
        xxxx
    \end{filecontents}
    \begin{filecontents}{TWO.csv}
        Header 2
        image 2
        description 2
    \end{filecontents}
    \begin{filecontents}{alpha.csv}
        Header 3
        image 3
        description 3
    \end{filecontents}
    \begin{filecontents}{beta.csv}
        Header 4
        image 4
        description 4
    \end{filecontents}
    \begin{filecontents}{gamma.csv}
        Header 5
        image 5
        description 5
    \end{filecontents}
    \begin{filecontents}{simon.csv}
        Header 6
        image 6
        description 6
    \end{filecontents}
    \begin{filecontents}{dispa.csv}
        Header 7
        image 7
        description 7
    \end{filecontents}
    
    \DTLloaddb{index}{index.csv}
    
            \noindent\begin{tabular}{@{}l@{}}
        \DTLforeach{index}{\one=File}{%
            \DTLloaddb[noheader]{\thenrow}{\one}%
            \INTEGERDIVISION{\value{nrow}}{\value{Ncols}}{\sola}{\solb}
            \ifthenelse{\solb =1}{\\}{}% Ncols m1nipages per line
        \begin{minipage}[t]{\Mwidth}% auto adjusted width
                \noindent%
                \begin{tabular}[t]{@{}p{\Mwidth}@{}}%
                \DTLforeach{\thenrow}{\one=Column1}{\one \\}%   display file content            
                \end{tabular}%
                \stepcounter{nrow}% 
            \end{minipage}\hspace*{2em}%    
        }
    \end{tabular}   

\end{document}

Using \setcounter{Ncols}{4}

UPDATE For longer descriptions (1) Write a long line (as #5) or (2) add more lines to the .csv file (as #1)

Test this code.

\documentclass[a4paper]{article}

\usepackage{datatool}
\usepackage{ifthen}% added <<
\usepackage{calculator}% added <<

\newcounter{nrow}
\setcounter{nrow}{1}

\newcounter{Ncols}
\setcounter{Ncols}{3} % set the number of columns in text width <<<<<<<<<<<<<<<<<<<<<<<

\newlength{\Mwidth}
\DIVIDE{1}{\value{Ncols}}{\Wcmd} 
\LENGTHSUBTRACT{\Wcmd\textwidth}{2.2em}{\Mwidth}
    
\begin{document}    
    \begin{filecontents}{index.csv}
        File
        ONE_long.csv
        TWO.csv
        alpha.csv
        beta.csv
        gamma_long.csv
        simon.csv
        dispa.csv
    \end{filecontents}
    \begin{filecontents}{ONE_long.csv} 
        Header 1
        image 1
        description 1a 
        description 1b 
        description 1c 
    \end{filecontents}
    \begin{filecontents}{TWO.csv}
        Header 2
        image 2
        description 2
    \end{filecontents}
    \begin{filecontents}{alpha.csv}
        Header 3
        image 3
        description 3
    \end{filecontents}
    \begin{filecontents}{beta.csv}
        Header 4
        image 4
        description 4
    \end{filecontents}
    \begin{filecontents}{gamma_long.csv}
        Header 5
        image 5
        a very long long description 5a     
    \end{filecontents}
    \begin{filecontents}{simon.csv}
        Header 6
        image 6
        description 6
    \end{filecontents}
    \begin{filecontents}{dispa.csv}
        Header 7
        image 7
        description 7
    \end{filecontents}
    
    \DTLloaddb{index}{index.csv}
    
    \section*{Long Descriptions}
    
    \noindent\begin{tabular}{@{}l@{}}
        \DTLforeach{index}{\one=File}{%
            \DTLloaddb[noheader]{\thenrow}{\one}%
            \INTEGERDIVISION{\value{nrow}}{\value{Ncols}}{\sola}{\solb}
            \ifthenelse{\solb =1}{\\}{}% Ncols m1nipages per line
        \begin{minipage}[t]{\Mwidth}% auto adjusted width
                \noindent%
                \begin{tabular}[t]{@{}p{\Mwidth}@{}}%
                \DTLforeach{\thenrow}{\one=Column1}{\one \\}%   display file content            
                \end{tabular}%
                \stepcounter{nrow}% 
            \end{minipage}\hspace*{2em}%    
        }
    \end{tabular}   

\end{document}

How to use \[\] in tabularray package

Apparently tblr doesn't like environments in X cells.

\documentclass[12pt]{article}

\usepackage{amsmath}
\usepackage{amssymb}
\usepackage{ninecolors}

\usepackage{tabularray}
\UseTblrLibrary{siunitx}
\UseTblrLibrary{counter}

\sisetup{output-decimal-marker={,}}

\DefTblrTemplate{contfoot-text}{normal}{Continued on next page}
\SetTblrTemplate{contfoot-text}{normal}
\DefTblrTemplate{conthead-text}{normal}{(Continued)}
\SetTblrTemplate{conthead-text}{normal}
\SetTblrTemplate{conthead-text}{normal}

\newcounter{mycnta}
\newcommand{\mycnta}{\stepcounter{mycnta}\arabic{mycnta}}

\newcommand{\hackequation}[1]{%
  \unskip\vspace{0.5\abovedisplayskip}\newline
  \makebox[\linewidth]{$\displaystyle#1$}\vspace{0.5\belowdisplayskip}%
}

\begin{document}

\begin{longtblr}[caption={Some text}]
  {
   colspec = {Q[c,gray9]X[l]Q[c]},
   vlines,
   hlines,
   row{1}={yellow9,font=\bfseries},
   cell{2,7,11}{2-3} ={teal9},
   %cell{7}{2-3} ={teal9},
   %cell{11}{2-3} ={teal9},
   hline{1,2,Y,Z} = {solid},
   cell{1}{2-3}={halign=c},
   column{1}={font=\bfseries},
   cell{2-Z}{1}={cmd={\mycnta}},
}
  Problem & Content & Point \\
  \SetCell[r=5]{m} &
    Solve the equation\hackequation{
      (2 x+3)\cdot \sqrt{4 x+5}+(6 x+7) \cdot\sqrt{8 x+9}=2.
    } & \num{1.00}   \\
  & $ \Delta =(-5)^2 - 4 \cdot 1 \cdot 6 = 1$, & \num{0.25} \\
  & $ x = \dfrac{-(-5) -1}{2} = 2$. & \num{0.25} \\
  & $ x = \dfrac{-(-5)  + 1}{2} = 3$ & \num{0.25} \\
  & The given equation has two solutions $x=2$ and $x = 3$. & \num{0.25} \\
\end{longtblr} 

\end{document}

It's also possible, if really needed, to number the equation and to cross-reference it.

\documentclass[12pt]{article}

\usepackage{amsmath}
\usepackage{amssymb}
\usepackage{ninecolors}

\usepackage{tabularray}
\UseTblrLibrary{siunitx}
\UseTblrLibrary{counter}

\sisetup{output-decimal-marker={,}}

\DefTblrTemplate{contfoot-text}{normal}{Continued on next page}
\SetTblrTemplate{contfoot-text}{normal}
\DefTblrTemplate{conthead-text}{normal}{(Continued)}
\SetTblrTemplate{conthead-text}{normal}
\SetTblrTemplate{conthead-text}{normal}

\newcounter{mycnta}
\newcommand{\mycnta}{\stepcounter{mycnta}\arabic{mycnta}}

\newcommand{\hackequation}[1]{%
  \unskip\vspace{0.5\abovedisplayskip}\newline
  \parbox{\linewidth}{%
    \setlength{\abovedisplayshortskip}{0pt}%
    \setlength{\belowdisplayshortskip}{0pt}%
    \noindent\begin{equation}#1\end{equation}%
  }\vspace{0.5\belowdisplayskip}%
}

\begin{document}

\begin{longtblr}[caption={Some text containing \eqref{test}}]
  {
   colspec = {Q[c,gray9]X[l]Q[c]},
   vlines,
   hlines,
   row{1}={yellow9,font=\bfseries},
   cell{2,7,11}{2-3} ={teal9},
   %cell{7}{2-3} ={teal9},
   %cell{11}{2-3} ={teal9},
   hline{1,2,Y,Z} = {solid},
   cell{1}{2-3}={halign=c},
   column{1}={font=\bfseries},
   cell{2-Z}{1}={cmd={\mycnta}},
}
  Problem & Content & Point \\
  \SetCell[r=5]{m} &
    Solve the equation\hackequation{\label{test}
      (2 x+3)\cdot \sqrt{4 x+5}+(6 x+7) \cdot\sqrt{8 x+9}=2.
    } & \num{1.00}   \\
  & $ \Delta =(-5)^2 - 4 \cdot 1 \cdot 6 = 1$, & \num{0.25} \\
  & $ x = \dfrac{-(-5) -1}{2} = 2$. & \num{0.25} \\
  & $ x = \dfrac{-(-5)  + 1}{2} = 3$ & \num{0.25} \\
  & The given equation has two solutions $x=2$ and $x = 3$. & \num{0.25} \\
\end{longtblr} 

\end{document}

Best Answer

Related Solutions

Datatool creating a matrix with 3×3 data \ DTLforeach

How to use \[\] in tabularray package

Related Question