Loading contacts to SilverPop via API call & SFTP file transfer

API call & SFTP file transfer

API call & SFTP file transfer

API call & SFTP file transfer

Loading our contact lists into Engage via their Web interface (browser) takes around 7-9 minutes of focused attention per list.  Doing the same thing with an API call and Secure File Transfer (SFTP) takes seconds!  The below video demonstrates the process from using web scraping to grab the name /ID on our SharePoint server to uploading the file to Engage, creating the name in Engage and tying the new name to the contact list.  The video is longer because I also have it wait for the data job to complete and then write an email confirming the process is complete.

The API call & SFTP file transfer is free with Engage/SilverPop but it isn’t well promoted (on their website nor by their representatives.  Spending a bit of time to get it working is well worth the investment. For the SFTP file transfer I’m using WinSCP but any SFTP program will do.

 

 

API call & SFTP file transfer

API Call and – SFTP file transfer

AutoHotKey Menu Builder- save hours of time by streamlining menu creation

AutoHotKey menu builderAHK is simple enough for me, an non-programmer, to program in however their GUIs are very tricky.  I wrote an AutoHotKey menu builder to help automate the building of them.  This can save a lot of time when trying to build menus.

Just remember that sub-menus need to be placed above their parents!  This always confused me because I wanted to put them below their parent’s .  You can also review this video which helps educate you on some of the built in features of AHK to control GUI placement

AutoHotKey Menu Builder

Debug with SciTE – Reduce the amount of coding time in AutoHotKey

Debug with SciTE

Debug with SciTE and AutoHotKey

Debugging can be very time consuming. If you’re using SciTE with AutoHotKey, there is built-in functionality that is very helpful.  This video walks through some of the cool debugging features in SciTE.  I also have  a second debugging with SciTE video that you should check out after watching this one.

Make sure you take the time to review both videos!  I guarantee it will increase your speed of developing code and trouble-shooting issues!

Debug AutoHotKey with SciTE

Debug with SciTE

Below is the AutoHotKey script I used in the video:

 

 

Easy way to export all of your ZOHO contacts- API call’s are a life saver!

export zoho contacts

You wouldn’t think that exporting contacts from an online CRM would be difficult however when I went to export ZOHO contacts, it sure went out of their way to!  I also found trying to update them (via the web interface) time consuming and frustrating.  I wrote an API call that automated the exporting of contacts from my account.

The below video documents how the API call automated my export ZOHO contacts and then builds a hyperlink which allows me to easily link back to an individual record.  API / Web services are similar to but different than web scraping in that the API call allows you to be very specific with your query and doesn’t return all the HTML content (which greatly increases the size of the payload)

Export ZOHO contacts

ZOHO API Call-Exporting all Records

You might find this Kindle book interesting if you’re migrating your database to the cloud.