Welcome to Julian Kuiters Saturday, July 21 2018 @ 06:06 PM AEST

Adobe Business Catalyst Adds FTP Access to Templates

  • Contributed by:
Adobe Business Catalyst

There's been many Business Catalyst customers looking to access their website templates via FTP.

Up until now the only way to edit your website templates was the admin panel (Admin -> Templates) or using Triangle (the Adobe Dreamweaver plugin).

As of today Business Catalyst has allowed access to edit and backup your templates via FTP.

To access you templates in FTP:

  1. Connect to your Business Catalyst website via FTP
  2. Browse to the /Templates folder

You can then download the .html file contents to create a backup, or edit the files on FTP.

Google Analytics code in Business Catalyst Website

  • Contributed by:
Adobe Business Catalyst

Business Catalyst already includes a great reporting tool - but Google Analytics is still my prefered report engine. You can gain so much information about who and why people are visiting your business catalyst site - more importantly it can help you figure out why sales or contact forms are not being completed.

Eventually this page is going to hold all the tips I have about using Google Analytics with Business Catalyst, but for now I have one tip and that is how to add the analytics tracking code to your templates in a way that works with Business Catalyst and the Dreamweaver plugin Triangle.

Business Catalyst (BC) has a habit of decoding the tracking code and breaking it. (Those "%3C" you see in the google code are actually "<"  but they need to be encoded to work).

The problem comes in with this part of the tracker code:

<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));

Notice the unescape() call - this is what tells the browser to decrypt the %3C - BC should not touch this - but it does.

So the work around I have been using is:

<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write("<scr" + "ipt src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'></scr" + "ipt>");

Notice that I've pre-decoded the string, removed the call to unescape() and broken up the string.

The important part here is that you must break up the <script  tag into something like <scr" + "ipt  ... this stops the webbrowser from seeing the script tag until the javascript tells it to (with the document.write() ). If you skip this bit you google analytics code will still not work and you will probably get javascript errors on the page.

Queensland SQL Server User Group Meeting Tonight

  • Contributed by:
SQL Server User Group

QSSUG Meeting This Thursday – 26th of November

The emerging field of "Location Intelligence" brings the worlds of Geographic Information Systems (GIS) and Business Intelligence (BI) together. These capabilities are now available with SQL Server in a no-coding, user-driven environment provided by the Integeo (www.integeo.com) Map Intelligence product. SQL Server 2008 also introduces a number of spatial features to support the development and extension of spatial applications. In this session, you will see how SQL Server Reporting Services can be used to extend your corporate data to provide interactive, spatial analysis through dashboards, reports and .NET applications.
About the Speaker
Brad Culbert is the Lead Technology Strategist and Solution Architect at Bistech (www.bistech.com.au), the Performance Management experts. Brad has a wealth of experience deploying Performance Management solutions to a number of QLD?s largest corporations and is a leading expert in the field of Location Intelligence.
WHERE Microsoft Brisbane Office, Level 9, Waterfront Place, 1 Eagle Street http://www.microsoft.com/australia/technet/usergroups.aspx    
WHEN Thursday, 26th of November | 5:30PM for a 6:00PM start (finishing at approximately 7:30PM)
The QSSUG website can be found at www.qssug.org and contains a repository of materials from past meetings as well as details of upcoming meetings.  Other Australian SQL Server related material can be found at www.sqlserver.org.au.

Searching Help for Business Catalyst Sites

  • Contributed by:
Adobe Business Catalyst

Sometimes finding the help you need with Business Catalyst (BC) or Good Barry websites can be a bit tricky.

There is the online business wiki - their white label help as well as the Business Catalyst Forums.

To save time searching for the answer on both sites I've build a Google Custom Search engine that allows for searching both sites at once. I find this to be very useful so I'm posting the search box here so everyone else can use it too.

Custom Search

Of course you can search directly on each of their own sites - but the above search could save you time.

How To: Configure a For Loop Container

Integration Services 2005 / SSIS (DTS)
  1. Start in the package Control Flow, with no object selected (Press ESC in the main window).
  2. Right click the background in the package, and select Variables

  3. Add a variable called LoopIteration with the Int32 data type in the package.
  4. Add a For Loop Container to the package

  5. Edit the For Loop Container by double-clicking it, or right-clicking it and choosing Edit.
  6. Set the InitExpression to @[User::LoopIteration]=0
  7. Set the EvalExpression to @[User::LoopIteration]<5 where 5 would is the number of loops you want to run.
  8. Set the AssignExpression to @[User::LoopIteration]=@[User::LoopIteration]+1
  9. Your settings should now look like this:

Answer: How do you create a byte with the value of 00000001 in SQL Server?

  • Contributed by:
SQL Server 2005

My team mate Pi asked me today: how do you create a byte with the value 00000001 in SQL Server?

The answer is to create an integer representation of the byte's value, and cast it to binary.


The output in Management Studio is: 0x01 (Management Studio outputs binary fields in Hex format). Hex 0x01 = Bits 0000001.

Hey Yo! SQLCMD may truncate your XML!

  • Contributed by:
SQL Server 2005

While trying to use SQLCMD to produce an app.config file, I encountered problems with the output being truncated.

The script was similar to:

DECLARE @appconfig XML
SET @appconfig = '<configuration></configuration>'
... Insert configuration nodes
-- Output the config
SELECT @appconfig as ApplicationConfiguration

The default options for SQLCMD produced output like:


(the value was a little longer, but cut off at the end)

Clearly the xml was not valid. There's header text included, corrupted tags, and missing closing tags. So I hunted through books online and google for an answer.

Turns out I needed to use the -y 0 option, which will output xml columns up to 1MB in size.

Also the -h-1 (without any spaces) will remove the header from the output.

If you are planning to use SQLCMD to output XML, remember: Hey Yo! -h-1 -y 0!

sqlcmd -h-1 -y 0 ...

Read more on SQLCMD Utility Options

Working Remotely: Disable Effects for a Better Working Experience

General News Working from home using a remote desktop has turned out to be surprisingly responsive. There's little to no lag, and I can still do most things (except use some windows shortcuts).

My current gripe is that Menus take a while to display because of fancy fade-ins and smooth expansion. It all looks nice when you are sitting in front of a PC, but remotely, it just uses more bandwith and wastes time.

So when you start working remotely, save yourself sometime and turn off Window's lovely effects, and go for a responsive connection: disable the effects.

Julian!? Where are you?

  • Contributed by:
General News Well I've definitely been "missing" on my blog lately. Between work commitments, a long daily commute, and personal projects, I've had no time to post much content on my website.

As of last week, I started working some days remotely; from home. Its been quiet a good change, and now that I have less distractions: I get a lot more work done. I've be able to finish off a lot of interrupted tasks. Get my head around how to organise and structure my day when working from home. I'm more focused, planned, and driven. I'm delivering more results each day, and as a result having more time for taking on more responsibilities comfortably.

But working remotely isn't all about work. Its also about re-gaining some of your personal time. I was spending about 10-15 hours per week travelling to work in my car. I planned my travel to try and avoid peak hour traffic, but where my employer is situated there are no direct travel routes. Public transport (commuter train & bus or bus & ferry & bus or bus & bus & bus & bus) would have seen me spending twice as long driving each day. My car has an awesome stereo, so the drive is not too stressful most days.

Ah! Again! Talking about work and the commute! See how I never got time for myself?

So now that I'm actually getting a few days a week working from home, I have time to get more things done. I'm not as tired. My energy level has sky rocketed. And my relationship has definately benefited. I've got time to persue more study, more personal projects, art, catch up with friends, and get back to writing useful tips for other SQL Server users.

Work has also benefitted. I've started to take an interest in managing myself more and co-ordinating my work with others better. Whilst working from home is ultimately a selfish want, it is definately improving my team skills.

So over the next coming weeks, expect a lot more from me. I'll be posting regularly on SQL Server 2005, including scalability with Service Broker and Notfication Services, Management Studio, and Visual Studio for Database Professionals especially Unit Tests.

So if you have any lagging questions or a SQL problem you'd like some tips for, send me an email sqlquestiokuiters.id.au

Excitedly home,