Hi Rigo

Thank you for reaching out to us.

This happens when the source file is not formatted correctly.

Please note that there are some limitations when using Excel files to create tables in wpDataTables. Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.

Please refrain from using any special formatting in the source file as the plugin may not be able to read the data properly and may result with an error.

Hi Rigo

There was a similar issue one of our clients previously had, so let me share the solution with you, please try it, and let me know if that helps.

In file wp-content/plugins/reportbuilder/source/class.abstract.builder.php: around line 359

you will find this

break;

and you have to remove it, so your code will look like this:

This will be included in the next update, so you don't have to worry about that.

Looking forward to hearing from you.

Hey Rigo

The role you provided for us is not an administrator role, so could you please upgrade it to Administrator, and tell us which table ID this is, and we'll gladly take a look and see what's going on.

Thank you Rigo.

I tried with a template from our documentation, but that doesn't work either.

We'll need to take a look at the structure of your website, so can you please clone your website?

If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files that you can send me (along with the log-in credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.

The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, please use the All-in-One WP Migration plugin.

Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.

Also, since this is a public ticket, remember to enable the PRIVATE response.

Thank you in advance!

Thank you, Rigo

I forwarded the files to our development team, and as soon as I hear from them I will let you know.

Hello Rigo

Unfortunately, I haven't checked the files you sent and I just forwarded them to our developers. It turns out that the files you sent are not a duplicated site, but instead files from your site and the database.

We can't use that.

Please install either the Duplicator plugin or the All-in-One WP Migration plugin, generate a copy of your website, and send us that in a private response.

One thing to add, Rigo.

The CSV file you used was tested locally, and it works fine for us, so it's coming from your server. Can you also send us FTP access credentials, so we can debug the plugin on your site, and see what's going on?

Hey Rigo

Sorry for the delay. The ticket has been forwarded to our developer this morning (my bad, I haven't reached your ticket in time last week), so I hope we'll have a response for you tomorrow.

I apologize for the delay once again!

Hello again Rigo

The issue is coming from the server. Our developers added a fix with ob_end_clean(); without saving the file. So, in file wp-content/plugins/reportbuilder/source/class.spreadsheet.builder.php around line 251 you will find this:

$this->_phpExcelWriter->save($generatedFilePath);

We've added this above that line:

ob_end_clean();

So the code looks like this now:

ob_end_clean(); 
// Save the file 
$this->_phpExcelWriter->save($generatedFilePath);

Since this is a specific case, you'll need to do this again after each update.

Also, in the report, the reportname variable is not being rendered because you added a space after the code in the cell, so you'll need to edit the template and remove the extra space after ${reportname} .