Category issues

  • ballboff

    (@ballboff)


    5 years, 5 months ago

    Hi, my blog is semi-automatic, in that I fill information out in my google sheets spreadsheet and then they automatically create a wordpress post for each new line item. I have a built in scraper that fetches the cover art, the info about the film such as writer, director and cast. I’m running into an issue with genres, which I am using as categories.

    It works great for films that only have one genre, such as horror. But if they have multiple genres like horror, thriller, mystery. It creates one category called “horror, thriller, mystery”. instead of 3 separate categories. Is there anyway I can fix this with a tag or a separator command or some HTML?

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    It sounds like you have an error in whatever you use to convert your spreadsheet entry into a post. How are you doing this?

    Thread Starter ballboff

    (@ballboff)

    5 years, 5 months ago

    well I use a tool called automate.io

    It takes the field headers I have in my google sheet and the values and just sends them over. So the automate.io website just sends through genre which I link to categories. My genres are separated by commas, which I assumed would split them out. I mean what would happen if I had a category that actually had a comma in it? So there must be a way of splitting them out properly.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    >> , which I assumed <<

    I will spare you the YouTube clip from The Odd Couple. There probably is a way, but it’s your script and you’ll need to debug it. How is it “sent over”?

    Thread Starter ballboff

    (@ballboff)

    5 years, 5 months ago

    Well it’s not a script per se. Well, it’s the website that does the conversion. I just need to know what format my categories need to be in to get them to aggregate. Automate.io just takes 2 connectors, 1 being google sheets, the other is wordpress. I tell the google connector which sheet i’m using and what fields to pull through, and then I tell the wordpress connector how to format them. At the moment, I don’t really have anything to convert it, it’s just being sent like for like from google straight to wordpress. In my formula it takes the JSON data from the imdb reference, and then pulls out the genres.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    Please ask the folks at automate.io how they communicate with WordPress.

    Thread Starter ballboff

    (@ballboff)

    5 years, 5 months ago

    Well I’m pretty sure it’s how wordpress interprets the categories, it’s not just automate.io i’m pretty certain there will be hundreds of connectors out there, such as microsoft flow and ifttt to name a couple. I can see i’m not going to get any help here, you could have just said you didn’t know.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    I can’t help if you can’t tell me how it works. Is it using the REST API? XMLRPC? Something else?

    Thread Starter ballboff

    (@ballboff)

    5 years, 5 months ago

    It’s alright, i’ll split the categories out myself, and feed those individual categories to wordpress. Thanks anyway.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Category issues’ is closed to new replies.