As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

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