Personal
MediaClassified x NextHome
SyndiHub
How to manually inject images into SyndiHub

How to manually inject images into SyndiHub

Warning

Currently, this is only setup to handle new images, or modifications to existing images within SyndiHub for New Construction. At this time, Rental properties are not yet supported, as the automation script has not been tested with these property types.

Table of Contents:

Preparing images for upload:

Which ever method you choose to upload the images, you will need to ensure that your images have been properly prepped. To do so, you will need to convert the images into 3 additional size formats.

These images should be located, and organized and uploaded to Amazon S3 as per the examples below. (Details on uploading the images can be found further in this document.)

Important
  • When you are resizing your images, you only need to constrain to the width. This means that your image may end up being 130x75 for example. As long as the width is correct, you should be fine.
  • Make sure that each size variant of the photos shares the same name as the parent, as demonstrated below.
  • In terms of Project Photos, you can append as many photos as you wish, and the names do not matter. (They must still match their size variants as stated above.)

Uploading images to Amazon S3:

Whether you are uploading new images, or simply modifying images that exist currently, you will need to append the images to Amazon S3. There are two ways this can be achieved.

Generally, using Cloudberry is a much easier method of managing content in S3, as it provides you a simple FTP-esc interface to simply drag and drop files in and out. It's the overall preferred method.

Documentation for using the Amazon AWS Web Console is ultimately provided as a backup, in the event that the user doesn't have CloudBerry is unavailable.

Using the Amazon AWS Web Console:

To upload images to Amazon S3 using the Amazon AWS web console, simply head over to https://aws.amazon.com/console/ and login with the [email protected] account.

Once you are logged in, select the S3 service.

Upon opening the S3 service, navigate to the appropriate bucket/path to upload your images.

Tip
Amazon S3 / Buckets / syndication / backend /
Info

Full paths can be found in the Preparing images for upload section.

Use the Upload Button to upload new images to the S3 bucket. Alternately, you can drag your files over to upload them as well.

Finally, you will be asked to confirm the images, and directory of your upload. Once confirmed, simply click the Upload Button at the bottom of the page to commit your changes.

Using CloudBerry Explorer

CloudBerry Explorer is a 3rd party tool, available for free, to manage content within an Amazon S3 environment. It is conveniently available for both MacOS and Windows.

To get started, you will need to download and install the CloudBerry Explorer software.

Tip

Download CloudBerry Explorer here!

Once you run CloudBerry Explorer for the first time, you will need to configure an S3 connection. If the login window does not appear, you can initiate the login by selecting File > Amazon S3.

To setup your S3 connection, give your connection a Display Name, and fill in the Access Key and Secret Key. The rest of the settings can remain default, as outlined in the example below. Click on OK to save your configuration.

After configuring your S3 connection, you should now be able to select your connection in the sources dropdown. This will allow you to navigate the S3 connection.

Navigate to the appropriate bucket/path to upload your images.

Tip
Amazon S3 / Buckets / syndication / backend /

From here, you can simply drag and drop images between your local workstation and the Amazon S3 bucket of your choice.

Using the custom SQL Script

To inject these images into the SyndiHub Database, a custom script has been written to help assist with the automation of injecting these images. Once you have prepared your images and uploaded them to the appropriate locations with Amazon S3, you can use this script to inject these images into the database.

To use this script, you will first need to login to the SyndiHub MySQL Database server. To do so, you will need to establish an RDP connection.

On a Windows computer, this can be achieved by running the native Remote Desktop Connection app installed on any Windows machine. You can find the Remote Desktop Connection app by searching for mstsc in your start menu, or within a Run dialog.

On a MacOS computer, you will need to download the Microsoft Remote Desktop software from the Apple App store.

Tip

Download Microsoft Remote Desktop here!

Run your RDP of choice, on your chosen Operating System. You will need to establish a connection to the following server.

Once you have connected to the remote server, you will need to launch the SQL Server Management Studio. An icon for this can be found on the desktop, or within the start menu.

Within the SQL Server Management Studio, open the custom script with File > Open > File.... The script is located at C:\Users\Administrator\Desktop\Custom Queries\Manual Image Updates\Upload Images v2.sql on the server.

When you open the script, please take a moment to read through the header notes. There are some very important points here. A copy of these notes have been appended below.

To use the script, you just need to fill out the appropriate variables in the -- USER INPUTS section.

At this time, the following configurable options include

Once you have configured the appropriate variables, and checked everything over twice for errors, you are then free to execute the query script to initiate your changes to the database. To do so, simply click on the Pasted image 20240524170735.png button in the toolbar to execute your script. As long as you have @Test_Mode set to False, your changes will be pushed to the live database.

After executing the script, you should copy and email your Messages output to j**********g@m**************.ca for review. This is primarily to investigate if anything went wrong, as well as to retain a log to revert any changes made, in the event that something does go wrong.

An example output from Messages can be found below.

Table Of Contents
How to manually inject images into SyndiHub
Table of Contents:
Preparing images for upload:
Uploading images to Amazon S3:
Using the Amazon AWS Web Console:
Using CloudBerry Explorer
Using the custom SQL Script