Export data

This topic contains 8 replies, has 3 voices, and was last updated by  Paolo 10 years ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • September 14, 2014 at 5:24 am #15301

    Peter
    Free User
    Post count: 11

    Hi has there been any plans to progress being able to export data out of GD. If not is there an alternative method. I would like to be able to take the listings data and export it into a more familiar programme such as eXcel or access for a client.

    September 14, 2014 at 9:30 am #15324

    Guust
    Moderator
    Post count: 29970

    You should be able to export the geodir_gd_place_detail table to a CSV or Excel file using phpMyAdmin.

    September 15, 2014 at 11:04 am #15395

    Peter
    Free User
    Post count: 11

    Thanks – this was the table I was looking for. It wasn’t in the first place I looked which was the website name and tables within that (which was blank)

    September 18, 2014 at 3:58 pm #15797

    Peter
    Free User
    Post count: 11

    Hi – is there a way that allows multiselect custom fields to be given a different heading on export. At the moment they are all included in the one column in excel.

    September 18, 2014 at 9:27 pm #15843

    Guust
    Moderator
    Post count: 29970

    Every different custom field should have its own column, I thought.
    I guess you mean whether the different selections in the one multiselect custom field can be separated into different columns?

    Let’s ask Paolo, he might know.

    September 18, 2014 at 9:35 pm #15846

    Paolo
    Site Admin
    Post count: 31206

    That’s how it should be… Multiselect is an array of values all in the same field.

    September 19, 2014 at 5:31 am #15861

    Peter
    Free User
    Post count: 11

    Yeah it was wondering if there was a way to separate the different selections within one field rather than having them in the one column.

    September 19, 2014 at 9:04 am #15862

    Peter
    Free User
    Post count: 11

    Hi I have now resolved this. Unless there is a better way i will just use excel and the delimit feature to separate the fields. This allows me to have info in separate columns which is helpful for what I need to do.

    September 19, 2014 at 3:54 pm #15888

    Paolo
    Site Admin
    Post count: 31206

    Yeah it was wondering if there was a way to separate the different selections within one field rather than having them in the one column.

    No, that is not feasilbe without writing an adhoc script to export the database, that would be cable of also separating that data.

    Thx

  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount