Welcome to Julian Kuiters Friday, October 19 2018 @ 09:45 AM AEDT

Adobe Business Catalyst Adds FTP Access to Customise Layouts

Adobe Business Catalyst

Following on from Adobe Business Catalyst Adds FTP Access to Templates  - Business Catalyst now has access to all the custom layouts available via FTP.

You can access the layouts in the /Layouts folder via FTP.

You can now customise the layout via FTP for these modules:

  • Affiliate
  • Announcement
  • Blog
  • Booking
  • Comments
  • Customer Cases
  • Customer Orders
  • Faq
  • Favourite
  • Forum
  • Literature
  • Online Shop
  • Outbound Emails
  • Site Search
  • System Messages
  • Tell A Friend
  • Webapps

(Screenshot from my FTP)


Adobe Business Catalyst Adds FTP Access to Templates

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

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

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

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?

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!

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.