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 #1383334
previewed column not being imported
Closed

Comments

  • Marv started the conversation
    November 27, 2017 at 9:00pm

    Hi - just purchased plugin. I am trying to import an excel file datasource into MySQL, the preview looks fine but upon creating the table the first column is not imported. Tried with both xlsx and cvs files and same thing. Here's a portion of the data. The first column does not get imported (linkName). Also, how does a link url column get created (using the || format)? Do I create from fields generated by an Sql query after my table is created in MySql? Thanks for your help. 

    LinkName URL
    Benefits Checkup http://www.benefitscheckup.org
    Centers for Medicare and Medicaid Services http://www.cms.gov
    Federal Drug Administration for Seniors http://www.fda.gov/ForConsumers/ByAudience/ucm062130.htm
    Healthcare Fraud http://www.nhcaa.org
    Medicare Interactive (Medicare answers at your fingertip) http://www.medicareinteractive.org/
  • Marv replied
    November 28, 2017 at 3:30am

    OK, I figured out what my problem - I didn't import the excel/csv file using wpdatatables ( I used the media importer - my bad) . So, problem solved.

    Second part of my question: How does a link url column get created (using the || format)? Do I create from fields generated by an Sql query after my table is created in MySql? I have a NAME column and a corresponding URL column. how do I create a link column as URL||NAME"  so that the name is a link?


  •  472
    Isidora replied
    November 28, 2017 at 10:14am

    Hi Marv,
    Thank you for your purchase.

    We are glad that you solved he issue.

    There is couple of ways how to insert || in url column. You can do manually when you make a table to insert || for every row, if you are using file for making wpdatatables you can make column that contains url with pipes and name or if you are using mysql you can try with CONCAT( url, '||', name) AS URL, where url is column in mysql with urls, and name is column with names in mysql table. 

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables