Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

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