Category: Published

Examples of Advance HubSpot Form Method [Hacks]




See more at The Stack.

How To Authenticate Everything with Zapier – Part 2: Marketo




See more at The Stack.

How To Authenticate Everything with Zapier – Part 1: Salesforce




See more at The Stack.

Marketo UI sidebar defaults to RTL? simple fix [Hacks]




See more at The Stack.

Sample Data File [Hacks]




See more at The Stack.

Winning reports with Google Sheets and G-Connector for Salesforce [Hacks]




See more at The Stack.

Filling the Marketing Automation Voids [Hacks]




See more at The Stack.

Watch Youtube as a pop-up window while working on other stuff

Let’s say you are working on a monotonous task that does not require your full attention, but still requires a hefty amount of time to complete – How do you entertain yourself while doing your job?
Usually, I tend to listen to music while working on some tasks, but I also like the ability to watch videos from time to time. But can you watch a video and continue working on your spreadsheet at the same time?
Well, of course – the most common way is to split screens:
split screen
 
The problem with this method is that a lot of screen-space is being wasted – if you watch a YouTube video, it’s probably ok if the video will be shown on a small part of the screen.
A better solution would be a floating window – but how do you that in Windows?
Here’s the solution:

  • a software called “Turbotop” will allow you to set any open window to be ‘always on top’, thus even if you work on a different application, the window you set to be shown on top, will always remain on top.
  • a shortcut to startup your browser without menus (aka ‘kiosk’ mode) – this will allow you to open YouTube directly in a minimal window, resize it to take a small portion of the screen, and keep it in one of the corners of the screen. Combine this with Turbotop and voila – you can now work on your spreadsheet, and watch Youtube without splitting the screen or hinder your work.

So let’s say you wish to do this trick with YouTube and Chrome:

  1. To open Chrome in ‘kiosk’ mode, create a shortcut with the following properties:
    “C:\Program Files (x86)\Google\Chrome\Application\chrome.exe” –app=http://youtube.com
  2. Download, install and run Turbotop. Then open the Chrome shortcut.
    Choose the Chrome window and enjoy your minimalist floating YouTube video.on top window
  3. I keep the Chrome shortcut as pinned icon in my task-bar, coupled with a ‘play’ button:
    great success
  4. Great Success!
    GREAT_SUCCESS (1)

 

How did I turn an alarming email to a list of potential clients

Recently a client of mine sent me an alarming email he received – it was a mention.com mention that showed that a website he owns is listed under an website vulnerability list. The website is actually mentioned a sub-domain address for a marketing software that my client uses, thus, the potential exploit is not on his server – but on the marketing software itself. Also, this particular potential-exploit isn’t of a real concern to us (nor to the marketing software development team, apparently 🙂 ).
exploit
I quickly realized that if the reported exploit is global to all the users of the software, I can use the list of exploitable websites to find out all the clients of this marketing software. This is important as everyone who uses that particular software is a potential prospect for my client.
But how do I take a list of thousand of potentially exploitable domains and check who uses this specific marketing software?
Luckily, this is rather easy in theory – when trying to surf directly to a sub-domain that is redirected to the marketing software servers, the user is redirected to the main website, coupled with a unique URL parameter.
So let’s say that the URL for the marketing software is marketing.clientdomain.com, surfing to this address will redirect the user to clientdomain.com/?ms=1.
I knew then, that in order to filter the domains that uses the marketing software, I’ll have to check each domain for the URL it redirects to, and than filter this list in a spreadsheet software. However, manually checking each link in a browser is definitely not an option when you got a list with hundreds or more of potential domains.

So how did I get to filter the list?
Obviously I googled. It is important to know what to google. We are looking on a way to check domain redirection. If you do SEO, you already know the answer, but for the rest of you out there, the answer has to do with the HTTP header response. What I needed is a tool that will check redirection per URL so I googled for ‘check redirect url’, which resulted for many SEO tools, usually online websites that offer you the ability to check one particular URL for redirection. This, of course, isn’t sufficient when you have many URLs to check:

example URL checker service

example URL checker service, with multiple redirection hops (final URL is the one under 200 OK status)

My next google check contained the word ‘Excel’ – obviously, if I have a list of domains, and I need to check who fit a criteria, doing the whole process of checking redirects would be most convenient from within Excel. And indeed, Excel can be used for this purpose, rather easily, with an Excel add on called “SEOTools for Excel“.  I recommend downloading and install their free version, it can be useful for many purposes including this one (but on small scale, I’ll explain further in this post).

multi redirect checker

https://www.mediaworks.co.uk/ provides an easy to use template, but it’s very easy to create one yourself using the included SEOTools unshorturl function.

Using the SEOTools for Excel, I manage to do a small scale test of multiple domains – and indeed, some of them included the URL parameter indicating they (almost certainly) use the marketing software I was looking for. The problem however, that again, I faced a scaling problem.
Excel is a great tool, but it’s actually one of the worse tools for this type of work – excel is very slow in executing URL retrieval and is built inherently for our purposes:  Excel UI will stuck while it execute its functions. while it’s not an issue for a list with 100 URLS, when you have over 10,000 of them, Excel will be hell to use. The fact that excel will refresh the cell content (thus requesting the information again and again) under many circumstances add insult to injury. So…

Excel is not the solution!
I knew at this point that I must find a way to automate this process with a dedicated tool. The online ones, which I mentioned earlier, were mostly focused on scanning one domain. Even those that support multiple domains are limited (to bulks of 100 per scan), and there is always the risk of your information being stolen.
If a tool doesn’t exists, build one – or get someone to build it for you.
I started by googling the same strings, but this time with the world ‘Python’. Python is a very common, simple to use and understand programming language. I knew that even though I’m not a programmer, the chances I’ll find a working example and would be able to understand how the code works is very likely. I was not wrong.
I found the following code somewhere over stackoverflow.com:

import urllib2
for url in [“http://url1”, “http://url2”, ]:
try:
connection = urllib2.urlopen(url)
print connection.geturl()
connection.close()
except urllib2.HTTPError, e:
print e.getcode()

This simple code checks the URLS included in it, for their header response and print that on screen. This is nice, but a bit too simple for our purposes.
I had the domain list in an external file, the list was very big, it also contained some broken URLS. The code that you see here can handle only specific type of exceptions (errors in execution). But URLs retrieval can fail for many reasons. Also, printing the results inside a command line window isn’t practical either.
In the end, with the help of a programmer friend, we’ve modified the code to do the following:

  1. Check all the URLs in a file called source.csv
  2. Write all the successful responses to a text file called output.txt
  3. Ignore all exceptions – we don’t really care why a URL can’t be retrieve in this use-case

The resulting code is attached, together with an example source CSV:
http://zedonstuff.com/uploads/python-redirect-checker-example.zip

The end result?
I’ve created a huge list of companies that uses a particular marketing software – all of them are potential leads for my client.
The list cost nothing to create and is based on a publicly available information that was harvest by someone else 🙂

Commercial alternative
There are, however, paid service that will do the scanning and technology identification for you, they are not cheap, but well worth the time if you build your potential lead lists based on technologies that companies uses – a known and recommended one is Built-with.

Before – After: Raw Data vs 16bit TIFF from SPP (Camera Reviews, Sigma DP2M)

The difference between the amount of data retained in the original DP2M capture, and the SPP produced TIFF file is amazing.
To test it, I’ve exported the photo with the default settings:
_P2M0056-default
Here, on the other hand – you can see the amount of data lost in the tiff when comparing the -2 stops images of both original RAW and TIFF:

The data in the sky is clearly lost in the TIFF, unlike what can be easily seen inside SPP editor.


Conclusion:
Multiple TIFF exposure exports are required from Sigma’s SPP program in order to capture the whole latitude range of the DP2M. This effectively means that in order to get the best out of your Sigma DP2M files – export 2 or 3 photos from SPP with different exposure values, and import them into Photoshop (or any other similar tool) as HDR tone-mapped material. That is of course, if the default exposure/latitude of the particular image is not to your satisfaction.