Media Hub Bulk Import & Export Guide

The Vennture Media Hub allows you to bulk import media content and related information, which is useful when you are trying to add all of your media content in at the start of a project, or make bulk updates.

The bulk import is done using an Excel spreadsheet provided by the Vennture Media Hub app. This guide will explain how to complete the spreadsheet accurately.

For more information on generating the spreadsheet, read our guide here.

The spreadsheet includes different tabs for each type of information that is to be uploaded.

Authors

In this first tab, you can add all details around author profiles to be created for content in the media hub; including the following;

• Folder: This is used if you have multiple country folders on your website so that authors can be attributed to each folder. If you only have a single folder, the default value to enter here is 'uk'
• First Name: Enter the first name of the author
• Last Name Enter the last name of the author
• Slug: This field is needed as a unique identifier for each author - this can just be their name but must be all lowercase with no spaces included, e.g., johnsmith or firstnamelastname
• Email: Add in the email address for the author - each email address can only be used once 
• Job Title: Add in the author's job title
• Bio: Optional field to add in some background on the author
• Image: Add in the filename for the corresponding headshot for the author. This needs to include the file type e.g. .jpg. These headshots should be grouped together in a zip folder and sent to our team so that we can upload these in bulk for you. Alternatively, you can add a placeholder image file name in here and manually upload your headshots after the bulk import is complete.
• Meta Description, etc.: These are optional fields to populate to add meta information for each author
• Publishing Status: In this field, set whether you want the author to appear on the live website or not. The values to use here are Live, Staging or Draft.

Speakers

Speakers are the secondary creators in the media hub and are usually guest speakers on events or podcasts. These tend to be individuals who will appear on one or a few pieces of content within the media hub but are not the main creators, so they do not have an author profile created. 

• Folder: This is used if you have multiple country folders on your website so that speakers can be attributed to each folder. If you only have a single folder, the default value to enter here is 'uk'
• First Name: Enter the first name of the speaker
• Last Name Enter the last name of the speaker
• Email: Add in the email address for the speaker - each email address can only be used once 
• Job Title: Add in the speaker's job title
• Image: Add in the filename for the corresponding headshot for the speaker. This needs to include the file type e.g. .jpg. These headshots should be grouped together in a zip folder and sent to our team so that we can upload these in bulk for you. Alternatively, you can add a placeholder image file name in here and manually upload your headshots after the bulk import is complete.
• Publishing Status: In this field, set whether you want the speaker to appear on the live website or not. The values to use here are Live, Staging or Draft.

Tags

Tags are used to organise content and there is no limit to how many can be added to the media hub;

• Folder: This is used if you have multiple country folders on your website so that tags can be attributed to each folder. If you only have a single folder, the default value to enter here is 'uk'
• Title: This would be the name of your tag as you expect it to appear on your website.
• Slug: This is a unique identifier for each tag and should be in all lowercase with no spaces.
• Publishing Status: In this field, set whether you want the tag to appear on the live website or not. The values to use here are Live, Staging or Draft.

Categories

Categories are also used to organise content in the media hub and you can add in as many as needed.

• Folder: This is used if you have multiple country folders on your website so that category can be attributed to each folder. If you only have a single folder, the default value to enter here is 'uk'
• Title: This would be the name of your category as you expect it to appear on your website.
• Slug: This is a unique identifier for each category and should be in all lowercase with no spaces.
• Image: This is an optional field to add in an image for each category. Add in the full filename including the image type which corresponds with the image saved in a zip folder to upload.
• Description: This is an optional field to add in a description for each category
• Publishing Status: In this field, set whether you want the category to appear on the live website or not. The values to use here are Live, Staging or Draft.

Blogs

Import multiple blogs by adding each blog as it's own row in the spreadsheet with the following details which are commonly used for all content types added to the media hub;

• Folder: This is used if you have multiple country folders on your website so that the blog can be attributed to each folder. If you only have a single folder, the default value to enter here is 'uk'
• Title: The title of your blog.
• Slug: This is a unique identifier for each blog and should be in all lowercase with no spaces.
• Sticky: This field controls whether the blog appears in the top section of the media hub landing page under the 'Must Read' heading. Values to use here are True and False
• Featured: This field controls whether the blog appears in the top section of the media hub landing page as a featured post. Values to use here are True and False
• Post Date: Enter the post date for the blog in the format DD/MM/YYYY HH:MM:SS. This data can be in the future, or you can backdate your posts if you wish.
• Image: This is the header image that appears at the top of each blog post. Add in the filename for the corresponding image to use which should include the file type e.g. .jpg. These images should be grouped together in a zip folder and sent to our team so that we can upload these in bulk for you.
• Author: Add in the slug for the author for the blog, this must match the information provided in the authors tab on the spreadsheet.
• Content: Add your full blog content to this field ensuring it is wrapped in HTML tags - if you are copying this content over from another supplier, copy the HTML code of the blog over rather than just the text itself to retain any formatting.
• Read Time: Enter the read time for your content
• Tags: Add the slug for any tags you'd like to use on the content. This must match the information provided in the tags tab of the spreadsheet and multiple tags should be separated by a ;
• Categories: Add the slug for any categories you'd like to use on the content. This must match the information provided in the categories tab of the spreadsheet and multiple categories should be separated by a ;
• Meta Data: There are three fields for you to fill in here - meta description, meta keywords, and meta canonical. These are optional to complete, but it is good SEO practice to have them filled in. For more guidance and information on meta tags, see our guide here.
• Publishing Status: In this field, set whether you want the content to appear on the live website or not. The values to use here are Live, Staging or Draft.

Downloads

The fields for a download are similar to blogs, with a few additional fields to complete;

• Overview: This field is shown at the start of the page and is to give a short overview of what the download is about
• Document: In this field add in the full filename of the document for users to receive including the file type extension e.g. .pdf. For documents users will receive, group these together into a zip folder and send to our team so that these can be uploaded in bulk for you.

Events

Events have some specific fields to complete when importing to the media hub;

• Post Date: This field will dictate the date that the event will appear on your website, not the date of the event itself
• Location: Add in the location of your event, whether a physical address or just an online
• Link: You can add a link here, which will redirect your user to the booking process to sign up for the event, whether that's on an external website like Eventbrite or elsewhere. This is displayed as a Register button on your event page
• Overview: This field is used to give an overview of the event you are hosting
• Date/Time: Add in the date and time of your event.
• End Date/Time: In this field, add the date and time when registration for the event will close. After this point, the register button on the event page will be hidden.
• Speakers: Add in the slug of any speakers for this event, ensuring the information matches that in the speakers tab in the spreadsheet and multiple speakers are separated by a ;

Podcasts

Podcast specific fields to complete in the bulk import are as follows;

• Speaker: This field is used to show the host of the podcast and data entered here should be the slug matching an author profile as completed in the author tab of the spreadsheet
• Guest Speakers: Add in the slug of any guest speakers for this event, ensuring the information matches that in the speakers tab in the spreadsheet and multiple speakers are separated by a ;
• Embed Link: In this field, add the embed link for your podcast so users can listen to it without leaving the page. This can be from various platforms, including Spotify, Anchor and Apple Podcasts. For guidance on generating an embed link, see our guide here.

Videos

Additional fields to fill in to import videos are below;