Cyprich.com

Occasionally Relevant Insights from a Software Builder

By

Downloading the Standalone Version of SQL Server 2008 Express

The default options for downloading Microsoft’s SQL Server 2008 Express at www.microsoft.com/express/Database/ will have you downloading the application through the Web Platform Installer. This is suitable for installing on a local computer, but if you want to install it on multiple machines, especially those that do not have an Internet connection, its best to do it with a standalone version of the installer.

There are no direct links on the download page to get the installer, but you can find it at:

http://www.microsoft.com/downloads/details.aspx?FamilyId=7522A683-4CB2-454E-B908-E805E9BD4E28&displaylang=en

There is a 32 and 64-bit version and you may need to download other applications in order to install the database server, i.e. .NET Framework 3.5 SP1, Windows Installer 4.5, and PowerShell 1.0. There is also an option for download documentation for offline viewing.

By

Fixing Errors with Attaching Transmittals to DFS

If transmittals can’t be attached to an Adenium DFS order, you need to give the aspnet account in IIS full control over the GlobalCache folder in the theme. In Windows 2000, full control is given to the ASP.NET account (see below).

Giving full control to the ASP.NET account to the GlobalCache folder in a DFS theme.

Each theme needs these permissions on the GlobalCache folder. Transmittals can then be attached with each order.

By

Find the URL of a Joomla Article

When building a Joomla web site, you may need add a link to an article to a page. The easiest way to do this is open the article through a menu option, and cut and paste the URL in the other page. The problem is that you need to have the article in an existing menu item for this to work. If it isn’t in a menu item, you will need to use one of the methods below to get its URL.

 

Getting the URL with SEF Enabled

If SEF URL’s are enabled in your site, you can reference the article by opening it in Article Manager and build the URL using the text in the Alias box,

     http://www.website.com/contact

 Viewing Alias while editing article.

Getting the URL with Default Settings

The default setting for a Joomla site is for SEF to be not enabled, so a standard form URL is used to reference an article. Open the article in Article Manager and you’ll see the following information:

Viewing Article ID while editing article.

A URL can be built using the Article ID above, i.e.

     http://www.website.com/index.php?option=com_content&view=article&id=47

If the article has modules that appear around it and their appearance depends on Menu Assignment (in the Module Manager), you’ll have to add the Itemid it uses in the Menu Manager. Find the menu item that links to the article get the ItemID (see below).

Viewing ItemID in Menu Manager.

You can then build the URL to view the article,

     http://www.website.com/index.php?option=com_content&view=article&id=47&Itemid=56

By

Assigning Drive Letters to Network Shares

It can be time consuming typing a network share (i.e. \\computer\share) or browsing to it in Windows Explorer. A drive letter can be assigned to the share with the following steps:

  1. Left click the Start button and then select My Computer. If this option is not available, then right click the Start button and select Explore. My Computer will be in the folder list.
  2. If My Computer is open, select Map Network Drive from the Tools menu, or alternately, if Explorer is used, right click on My Computer and select Map Network Drive.
  3. Select the drive letter that you want to use and the network folder that it will be assigned to.

    Map Network Drive

  4. Press the Finish button and open Windows Explorer. You will see a new drive letter that will open the network folder that you assigned to it.