Import featured column

This topic contains 9 replies, has 2 voices, and was last updated by  Mike Anderson 7 years, 8 months ago.

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

Open Support Ticket
  • Author
    Posts
  • September 20, 2018 at 12:39 pm #447104

    Mike Anderson
    Expired Member
    Post count: 53

    Hi,
    I am just about to import my first data set from another business directory, in the example csv there is a column heading for is_featured what are the implications of setting this 1 or 0 on the import. The old business directory didn’t have this so it is not populated. But I am wondering if it cross relates to another setting from the old directory.
    TIA
    Mike

    September 20, 2018 at 12:47 pm #447106

    Mike Anderson
    Expired Member
    Post count: 53

    Also the same question for post_author, the example is a 1 or 0 what does that set?
    Mike

    September 20, 2018 at 2:12 pm #447113

    Alex Rollin
    Moderator
    Post count: 27815

    Featured is a special ‘status’ for listings, and it is sortable in listings and widgets. It is a function of the Price Package, usually an ‘upsell’.

    https://wpgeodirectory.com/docs/prices-and-payments-add-on-overview/

    post_author is the ID of the user account belonging to the author of the post itself, also known as the listing owner. This is important for allowing the right user to login and edit their listing.

    September 20, 2018 at 3:25 pm #447127

    Mike Anderson
    Expired Member
    Post count: 53

    Thanks for that, its what I thought but wanted to check:-)

    Bit of advice if I may, the directory we are importing has an email list which we could use to create WordPress users and then use post_author to connect them. But the list owners have concerns that the email list may be very out of date. Would we be better adding the listing with no post_author and letting them claim there listings?

    September 21, 2018 at 8:22 am #447199

    Alex Rollin
    Moderator
    Post count: 27815

    All the listings should be assigned a post author, as it is a required field. This could be some “editor” with a friendly username, but it will not show the username if the listing is not claimed.

    On import, you can set the “claimed” column to ‘1’ for the listings where the author should be the listing owner.

    For listings you want to leave unclaimed, leave the “claimed” column blank or add a ‘0’.

    Let us know how it goes 🙂

    September 24, 2018 at 2:31 pm #447524

    Mike Anderson
    Expired Member
    Post count: 53

    Thanks for the info,

    I don’t see a claimed column in the example import csv I download, can I just add a ‘post_claimed’ column to the csv and populate it?

    Would the users email address be OK for the post author, all these listings will be loaded unclaimed from the outset, we don’t actually have a username for most of them as yet.

    Mike

    September 24, 2018 at 9:13 pm #447567

    Alex Rollin
    Moderator
    Post count: 27815

    No, you should install the Claim Manager addon, then export to confirm the presence of the column and the column order.

    Author takes an ID for a user account not an email address.

    Best practice is to setup all your addons and custom fields, then export a sample of listings to get your CSV format. Then merge your data into it.

    September 25, 2018 at 1:04 pm #447650

    Mike Anderson
    Expired Member
    Post count: 53

    Hi Alex,

    I do have the claim manager installed, but there are no columns for claim in the export example. I don’t actually see the custom fields I created in the export either.

    Mike

    September 25, 2018 at 2:24 pm #447662

    Alex Rollin
    Moderator
    Post count: 27815

    Ok, try adding some dummy data to your CPT and then export the listings for that CPT.

    Let us know how it goes

    September 25, 2018 at 4:44 pm #447690

    Mike Anderson
    Expired Member
    Post count: 53

    You know if I had a brain, I would be dangerous!!
    I exported the listing set and everything is there as it should be.
    thanks for the help,

    Mike

  • 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