WordPress.org

Ready to get started?Download WordPress

Forums

Exporting data from Database browser to CSV file (3 posts)

  1. matthearne
    Member
    Posted 1 year ago #

    I'm not a developer, but have had a friend of mine develop a website for me to promote a race I'm organising (www.svp100.co.uk)

    We have created a form to collect information from people signing up to the race, and they then pay via PayPal. I can view the data that people are inputting through the Database browser, however I have issues when trying to export the dataset into a CSV file.

    Basically, all of the information the people fill out in the form is collated into a column called 'data' in the Database browser. However, it does not seem possible to export this data to a CSV so that each individual piece of information creates a new column.

    Are there any clever ways of exporting the 'data' column, so that I can create a spreadsheet of the customer data?

    Many thanks in advance,
    Matthew

  2. bcworkz
    Member
    Posted 1 year ago #

    Everything in one column? That's odd. You're pretty limited on how you can export from phpMyAdmin, you pretty much get what you get. Most spreadsheet apps have fairly flexible import functions, but everything in one column? Hmm... I dunno.

    I've a few times resorted to writing a javascript to process text in a custom rudimentary manner. Paste data into one textarea. Click a button and copy/paste the output into a blank csv file, which is then easily imported. The script might be something like for every 8th comma, replace it with CRLF.

  3. matthearne
    Member
    Posted 1 year ago #

    Thank you for your response. Yes, I've come to the conclusion that due to the poor features in WordPress, I'll have to write some kind of javascript to undertake what should have been a simple operation. Amazing that this functionality is not provided as standard. I figured that people would want to export their customer data if they have developed an e-business site.

    Appreciate your comments / thoughts in any case. I figured there would not be an easy solution to this issue.

Topic Closed

This topic has been closed to new replies.

About this Topic