We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #1407657
Importing MySQL table into sandbox
Closed

Comments

  •  1
    N M Pattnaik started the conversation
    December 19, 2017 at 3:03pm

    Hello,

    I would like to see how a MySQL table with my own data functions in the wpDataTables sandbox. My particular concern is about Indian language fields (utf8) it contains. I see some problems with such data when generating tables from csv data with your free (lite) plugi. I want to make sure that such problems do not arise when the data are sourced from MySQL directly through query.


    Thanks.

  • [deleted] replied
    December 20, 2017 at 9:49am

    Hi N M Pattnaik,
    Thank you for your inquire.

    You have option to import your CSV into database through our plugin and test it that way. You can find more information about it in our - Documentation. 

    We are setting CHARACTER SET=utf8 COLLATE utf8_general_ci upon creating tables in MySQL so it should work properly.

    One more thing which I should mentioned here is that our support managers will gladly help you with any problem that you have with our plugin and that includes problems with character set. 

  •  1
    N M Pattnaik replied
    December 20, 2017 at 4:06pm

    Hello Miljko Milosevic,

    Thanks for the response. I would really like to see the results from my MySQL database. I am attaching a very small table (11 col x 7 rows) with a sample of my actual data. Can you please add this to any of your databases and post the output table somewhere? I will break up the data into two tables eventually, but right now output of the entire table will do.

    I will go for the purchase if the display comes out fine.

    Hope this can be done soon.

    Thanks.

    Nikhil

  • [deleted] replied
    December 22, 2017 at 10:51am

    Hi Nikhil,

    It is not easy for me to set up table where you can actually test it but I tested it in my local environment and record the output. As I can see it works normally. My only suggestion would be to use non special characters for column names in MySQL which will assure that all the functionalities working normally. Please take a look at the attachemnt to see it in action