Custom Fields Import CSV

This topic contains 9 replies, has 2 voices, and was last updated by  Alistair Williamson 8 years, 4 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • October 18, 2016 at 4:51 pm #287167

    Alistair Williamson
    Full Member
    Post count: 415

    Hi,

    I read

    https://wpgeodirectory.com/support/topic/custom-fields-and-csv-importing/

    Unfortunately, it is still am not clear where import fields must be placed.

    Please – see image attached.

    I have approx. 15 custom fields under gd_places – I checked the database for the field name.

    I added the field geodir_faxnumber at the far right of my csv file but it didn’t import?

    Please can you advise me what I am doing wrong.

    Thanks

    Al

    October 18, 2016 at 7:56 pm #287232

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    this is what i normally do instead of adding columns myself to the CSV files. I add the custom field value on 1 listing from the back end, then export listings.

    The custom field will be there and you’ll be able to see how the value is formatted too.

    Let us know how it goes this way.

    Thanks

    October 18, 2016 at 8:43 pm #287243

    Alistair Williamson
    Full Member
    Post count: 415

    Hi Paulo,

    Thanks for your advice.

    Appreciated 🙂

    Bests

    Al

    October 18, 2016 at 9:01 pm #287260

    Paolo
    Site Admin
    Post count: 31211

    You are welcome 🙂

    October 19, 2016 at 11:06 pm #288021

    Alistair Williamson
    Full Member
    Post count: 415
    This reply has been marked as private.
    October 20, 2016 at 8:52 am #288168

    Alistair Williamson
    Full Member
    Post count: 415

    Hi,

    Cocerned.

    I have imported data as per the procedure and there are gaps in my data.

    I have exported the data, edited the export, reimported the edited file and I still have gaps in my data?

    Just ran the GD Tools.

    Please advise.

    Thanks

    Al

    October 20, 2016 at 10:55 am #288208

    Alistair Williamson
    Full Member
    Post count: 415

    Hi,

    I am sitting manually editing listings that have not imported correctly.

    Just read https://wpgeodirectory.com/docs/core-export/ – see image attached.

    Very frustrating that data that has been anywhere near excel won’t import cleanly.

    Almost impossible to avoid the common excel file format.

    Short of keying every character manually into OpenOffice Calc how can I get round this?

    At the moment I am working with 10’s of listings but shortly 1 will be importing thoudands of listings.

    Please can you advise/help?

    Thx

    Al

    October 20, 2016 at 8:20 pm #288718

    Paolo
    Site Admin
    Post count: 31211

    Hi,

    please provide a link, admin credentials and attach the CSV file you are trying to import and we will let you know why it is not working.

    Thanks

    October 21, 2016 at 3:04 pm #289245

    Alistair Williamson
    Full Member
    Post count: 415
    This reply has been marked as private.
    October 21, 2016 at 4:08 pm #289278

    Alistair Williamson
    Full Member
    Post count: 415

    Hi Paolo,

    Having imported data I have noted also that the Autocompleter on ‘Search’ doesn’t appear to be working.

    Please could you advise?

    Thanks a million.

    Bests

    Al

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 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