Value of setting post id when importing?

This topic contains 6 replies, has 4 voices, and was last updated by  Paolo 8 years, 11 months ago.

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

Open Support Ticket
  • Author
    Posts
  • June 4, 2015 at 3:57 am #41502

    Josh Elledge
    Expired Member
    Post count: 11

    just thinking… Gonna be doing my big import soon – and was thinking that if I ever wanted to mass update a bunch of records, I’d better assign s post id in the csv I’m importing – otherwise there’d be no way to update records via import. Does this sound right?

    June 4, 2015 at 10:18 am #41516

    Simone
    Expired Member
    Post count: 3515

    Hi Josh, the post id is automatically assigned (incrementally) when importing and there’s no risk it could overwrite previously imported posts, is this your concern?

    June 4, 2015 at 11:32 am #41524

    Guust
    Moderator
    Post count: 29970

    I doubt you can update records by import, I think you will create duplicates instead.

    June 4, 2015 at 11:37 am #41525

    Simone
    Expired Member
    Post count: 3515

    oh gosh I read “upload” and not “update” and I was thinking Josh was talking about uploading a big list in multiple .csv *facepalm*

    Yes as Guust pointed out, you need a post_id in order to update a listing

    June 4, 2015 at 2:10 pm #41546

    Josh Elledge
    Expired Member
    Post count: 11

    Updating via import works well when assigning post_id and checking the update box. Just did some testing on that. Thanks!

    Kinda a dumb question – but just checking before I start the import – and don’t want to create long-term problems if it matters: Can I just come up with any number for post_id as long as its not taken? i.e. It doesn’t have to be sequential?

    Thanks so much!

    June 4, 2015 at 2:35 pm #41549

    Simone
    Expired Member
    Post count: 3515

    Yes, as long as they are unique

    June 4, 2015 at 9:20 pm #41585

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    under no circumstances you should add ids when importing new listings.

    They will be added automatically by the database and you shouldn’t be messing with it’s internal counting, you could be assigning an ID used by an option or a comment without knwowing and potentially crash your website.

    To have the file to edit with IDs, that you can re-import and update the listings, you can export it.

    It will come with the automatically assigned IDs already.

    Thanks

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

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

Open Support Ticket