Change All Listings to Claimed After Import

This topic contains 3 replies, has 3 voices, and was last updated by  Kenny Eliason 9 years, 6 months ago.

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

Open Support Ticket
  • Author
    Posts
  • November 3, 2014 at 8:01 pm #20441

    Kenny Eliason
    Expired Member
    Post count: 54

    Hey guys! Any way to change all listings in the db to claimed? Thanks!

    November 3, 2014 at 10:44 pm #20455

    Guust
    Moderator
    Post count: 29970

    Assign them all to a particular user first:
    Places > bulk edit > author > change.

    In the database, change claimed from 0 to 1 in the geodir_gd_place_detail table.

    November 3, 2014 at 11:09 pm #20460

    Simone
    Expired Member
    Post count: 3515

    Or while importing you can set the author to some other ID (if you know the ID of the author), and..not sure but..you can create a column in the CSV named “claimed” and set it to 1 (try it, it should work)

    November 3, 2014 at 11:12 pm #20463

    Kenny Eliason
    Expired Member
    Post count: 54

    Ah yes, that’s what I needed. Couldn’t find that table. Used this to update ALL of them at once:

    UPDATE 'geodir_gd_place_detail' SET 'claimed'=1

    Thanks guys!

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

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

Open Support Ticket