Line-breaking long cell contents when using longtable through datatool

Question

I'm trying to display a table loaded from a CSV file and displaying it like this:

\DTLloadrawdb[]{myDB}{myDB.csv}
\DTLdisplaylongdb[%
    caption={myDB caption},%
    label={tab:myDB},%
    contcaption={myDB (continued)},%
    foot={\em Table continued on next page},%
    lastfoot={\em End of Table}%
]{myDB}

This works except that one of the columns contain some long text strings that push the rest of the table off of the side of the page.

The datatool documentation says that it is using the longtable environment for this and to look up how to align contents in the longtable documentation, but I can't figure out how to get this to work. I want the table centered on the page and all the cell contents left-aligned and lines broken if there is too much content.

I'm not trying to break the cells across multiple pages, just the cell contents over multiple lines on the same page.

Answer 1

Looking at the datatool doc (section 5.4) you can have full control over the table column specification if you use \DTLforeach So if your third column needs to be text justified to lines broken to 5cm, you can do something like

\begin{longtable}{llp{5cm}}
\bfseries heading one &
\bfseries heading two &
\bfseries heading for long text column%
\DTLforeach{mydb}{%
\firstname=FirstName,\surname=Surname,\score=Score}{
\\
\firstname & \surname & \score}
\end{longtable}