nuBuilder Forum

kev1n wrote: ↑Mon Apr 04, 2022 11:20 pm Hi,

Try this:

Remove the line

Code: Select all

include("nuconfig.php");

and replace it with

Code: Select all

global $nuConfigDBHost;
global $nuConfigDBName;
global $nuConfigDBUser;
global $nuConfigDBPassword;

pmjd wrote: ↑Tue Apr 05, 2022 3:56 pm Try setting the delimiter (the character that will be used to seperate out the entries) as follows

Code: Select all

// Set the CSV delimiter
$delimiter = ',';

Also Excel will import CSV files in different ways, can be worth going through the menu
Data > Get External Data > From Text
to manully select the format and delimiter.

kev1n wrote: ↑Tue Apr 05, 2022 4:48 pm Maybe by using tab-separated values (\t) ?

This article describes some tweaks.

//Get the column names.
$columnNames = array();
if(!empty($rows)){
    //We only need to loop through the first row of our result
    //in order to collate the column names.
    $firstRow = $rows[0];
    foreach($firstRow as $colName => $val){
        $columnNames[] = $colName;

kev1n wrote: ↑Sat Nov 23, 2019 10:49 am Only add the "Download to CSV" button if the Print button exists:

Code: Select all

if(nuFormType() == 'browse'){
    if ($('#nuPrintButton').length == 1) {
       nuAddActionButton('nuRunPHPHidden', 'Download to CSV', 'nuSetProperty("browse_sql",nuCurrentProperties().browse_sql); nuRunPHP("DownloadCSV")');
   }
}