Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #1237644
Not picking up field data
Closed

Comments

  • SteveCliffAtos started the conversation

    I've created a new test site (http://test.devcloud.guru) with no plugins other than wpDataTables (v 1.7.1) and Report Builder for wpDataTables (v 1.0.3)

    I've created a new wpDataTable using MySQL of "SELECT user_login, user_email FROM wp_users"

    I've created a new report based on the above table along with the following Word template:

    Test Report – single report with all data
    ${wpDataTable.row}
    ${user_login} (${user_email})
    ${/wpDataTable.row}
    End.

    The report runs but the output is simply the same as the template, I.E. no ${} fields have been replaced with data.

    Can you tell me what I'm doing stupid please? :)

  • SteveCliffAtos replied

    N.B. I had to downgrade wpDataTables from v2 to v1.7.1 in order for the report builder to pick up the table I created - I presume this is correct and is simply that the report builder isn't yet compatible with v2?

  • [deleted] replied

    Hi Steve,
    Thank you for the purchase.

    Report Builder 1.0.3 is not compatible with version of wpDataTables 2.0 but we'll release new version that is compatible with 2.0 tomorrow. After that it takes at least 48 hours to be approved by Envato team.

    About your issue please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check PRIVATE so nobody can see it except us.

  •   SteveCliffAtos replied privately
  • [deleted] replied

    Hi Steve,

    Sorry for delayed reply.

    We were really busy with creating Report Builder 1.1 that is compatible with wpDataTables 2.0. We pushed it today on CodeCanyon and it needs 24-48 hours to be approved by Envato team.

    It seems that there is a bug when try to use this form with column that have _ (underscore) in column header:

    ${wpDataTable.row}
    Column1: ${column1.all}
    Column2: ${column2.all}


    ${/wpDataTable.row}

    You can try to use this template from the attachment. Just create the table in .docx file and place in it variables. You can find example on your website.

    Probably tomorrow you'll be able to download Report Builder 1.1 from CodeCanyon. If you have any more questions don't hesitate to ask.

  • SteveCliffAtos replied

    Thanks Milos - I will look again over the weekend then and see whether it's available and then try producing the report again. Thanks for the feedback / template.

  • SteveCliffAtos replied

    Just had notification from CodeCanyon that the new version was there so wiped everything out and installed wpDataTables 2.0 plus latest ReportBuilder (1.1).

    The table now shows up but I can no longer progress to the next screen ... I.E. I click the Next button (it registers the click with an animation) but still stops on that screen.

    NB. Just in case, I've also changed the query I'm using so that it doesn't return underscores in the field name but no difference.

    Any thoughts?

  • [deleted] replied

    Hi Steve,

    "The table now shows up but I can no longer progress to the next screen ... I.E. I click the Next button (it registers the click with an animation) but still stops on that screen."

    - You are talking about Report Builder wizard or wpDataTables? I checked RB wizard and it seems that is working for me. Next button is going on the next step.

    "NB. Just in case, I've also changed the query I'm using so that it doesn't return underscores in the field name but no difference."

    - You've created a template with form like this:

    ${wpDataTable.row}
    Column1: ${column1.all}
    Column2: ${column2.all}


    ${/wpDataTable.row}

    Or you added variable in the table in .docx file?


  • SteveCliffAtos replied

    Sorry but still getting the same problem with the Next button (when trying to create a report). I'm using Chrome browser btw.

    Would you mind watching the video below and seeing if you can spot anything I'm doing wrong?

    https://cloud.familycliff.co.uk/s/I0QJFDuLgLCzI7C

    NB. Obviously at this point I haven't even uploaded a template so it's nothing to do with that I suspect :)

  • [deleted] replied

    Hi Steve,

    Could you try to clear browser cache and to see does it work then? You can do that by clicking CTRL+F5 while you are on Report Wizard Page. You've updated the plugin and probably the old script is still loaded.

  • SteveCliffAtos replied

    Doh - I should have tried that Milos - sorry ! Yes, that got me past the "Next" issue :)

    However, the original issue is still there - if you log on to the site you will see two reports with two templates, one with underscores and one without. Neither report will extract data .... just can't figure out why :(

  • [deleted] replied

    Hi Steve,
    Sorry for delayed.

    We are not working during the weekends. I tried to login with credentials that you've provided me before but I couldn't. Can you provide me again your credentials so I can take a look at the issue?

  •   SteveCliffAtos replied privately
  • [deleted] replied

    Hi Steve,

    I will debug this issue today, and come back to you when I resolve it.

  • [deleted] replied

    Hi Steve,

    I guess that I found the issue. I am using Ubuntu 16.04 and for creating template I've use LibreOffice Writer and report was not working. Then my colleague created template with Word on Mac Book and Report was working fine. I have added that template to your report with ID 1 and it's called template3-1.docxYou can check that report is working.

    What software did you use to create template? Can you try to use something else and see does it work then?

  • SteveCliffAtos replied

    Aha! Yes, I can confirm the report works with the template you've posted. I created my templates with Word 2016 - I will try a couple of things (using Word 2013 and then using Word 2016 but in compatibility mode) and see what happens. Will post back my results shortly ...

  • SteveCliffAtos replied

    Scenarios tested so far:

    Word 2016 - saving as "Word 2003 compatible"
    Error 500 when trying to download/produce the report.

    Wordpad - saving as "Office Open XML Document":
    Produces report however, loading back in to Wordpad is fine but Word 2016 fails. 
    (NB. Word 2016 loads the original Wordpad file - it's only after it's gone through the plugin that it can't open it any more)

    Definitely some capability issues to work on by the looks of it  :(

    I will try and find a Word 2003 install and try that ...

  • SteveCliffAtos replied

    Ok, as I was going through testing I decided to double check just a normal Word 2016 document - it worked fine!

    It looks like I've found the original issue - if you simply hit enter at the end of each line when you are creating the template it works fine and pulls in data. However, if you use shift-enter (in order to keep the text in the same paragraph) it doesn't. I.E. the attached shows a picture of my template with the paragraph marks - the top section didn't work but the bottom section did.

    [Update]
    It seems that as long as the ${wpDataTable.row} & ${/wpDataTable.row} statements are in separate paragraphs then anything between is handled correctly.

  • [deleted] replied

    Hi Steve,

    I am glad that you have resolved the issue. This explanation helps me as well Thank you.

    We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!