CSV Import – Mandatory Fields

This topic contains 6 replies, has 3 voices, and was last updated by  Stiofan O’Connor 10 years ago.

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

Open Support Ticket
  • Author
    Posts
  • February 3, 2015 at 9:23 pm #29820

    martinwi
    Expired Member
    Post count: 34

    Is there any way to make the post_region (and others) non mandatory?
    I have thousands of records to import, none of them having all of the mandatory values set.

    I would like to initialise the database and have people update/fix their own entries, if possible.

    I can only think of entering a default for these values, as an override, but it’s not ideal.

    Martin…

    February 3, 2015 at 9:55 pm #29836

    Guust
    Moderator
    Post count: 29970

    Hi Martin, your suggestion is the only way to do it.
    Every listing needs an address, so every listing needs those fields.

    February 4, 2015 at 9:17 am #29878

    martinwi
    Expired Member
    Post count: 34

    Thanks Guust.

    Is there a way I can mark the post_category with some sort of identifier so that entries are present in the listings, but not shown on the map?

    I defaulted the lat / lon to zeros and obviously, I now have place markers in the sea, which doesn’t look very nice at all.

    February 4, 2015 at 9:57 am #29892

    Guust
    Moderator
    Post count: 29970

    That is not possible, you can either hide them all together or not at all (including the map location).

    February 4, 2015 at 10:19 am #29896

    martinwi
    Expired Member
    Post count: 34

    Can I import them all with default flags and then run some sql to set all those with a default flag to draft status?

    At least that way they would all be available for edit within the system.

    February 4, 2015 at 10:35 am #29900

    Guust
    Moderator
    Post count: 29970

    Why not do a bulk edit in your WP admin after you imported them, and set to draft?

    You might be able to add a column after post_title column called post_status with either publish or draft.
    Let’s ask Stiofan if that is possible.

    February 4, 2015 at 11:06 am #29904

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    I would go with Guusts suggestion..

    Stiofan

  • 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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount