Tuesday, June 8, 2010

How to: Disable all the external data connections included in a workbook in Excel 2007.

How to: Disable all the external data connections included in a workbook in Excel 2007.

How to: Disable all the external data connections included in a workbook in Excel 2007.

Solution Open the Microsoft Excel workbook. Click the 'Microsoft Office' button. Click the 'Excel Options' button. In the left pane, click 'Trust Center'. In the 'Microsoft Office Excel Trust Center' section, click the 'Trust Center Settings' button. In the left pane, click 'External Content'. In the 'Security settings for Data Connections' section, select the 'Disable all Data Connections' check box. Click 'OK'. Click 'OK'.

Details

Microsoft Excel 2007 is configured to protect worksheet elements from external threat such as viruses. If the worksheet is not protected properly, the malicious content can corrupt or damage the worksheet data. To protect the worksheet against external threats, you must disable all the external data connections included in a workbook.

To disable all the external data connections included in a workbook:

1) Open the Microsoft Excel workbook.
2) Click the 'Microsoft Office' button.
3) Click the 'Excel Options' button. (The 'Excel Options' dialog box appears.)
Screen: 'Excel Options' dialog box
4) In the left pane, click 'Trust Center'. (The 'Trust Center' screen appears.)
Screen: 'Trust Center' screen
5) In the 'Microsoft Office Excel Trust Center' section, click the 'Trust Center Settings' button. (The 'Trust Center' dialog box appears.)
Screen: 'Trust Center' dialog box
6) In the left pane, click 'External Content'. (The 'External Content' screen appears.)
Screen: 'External Content' screen
7) In the 'Security settings for Data Connections' section, select the 'Disable all Data Connections' check box.
8) Click 'OK'.
9) Click 'OK'.

Knowledge-Paks Online and Knowledge-Paks On Site Copyright (c) 2008 by RightAnswers, Inc. Subject to the terms set forth in the end-user license agreement. All rights reserved.

Details

Monday, May 31, 2010

restore ms sql 2008 db to ms sql 2005

How To Convert Database of SQL Server 2008 to SQL Server 2005?

Requirements

If you are trying to restore database backup of SQL Server 2008 to SQL Server 2005, you are bound to fail. Database backup of SQL Server 2008 is not compatible backward, you cannot restore it to SQL Server 2005. The following is a solution to convert databases of SQL Server 2008 to 2005

Step by Step Guide

1) Start convert wizard

Open SQL Server Management Studio2008. in 'Object Explorer', right click the database that you want to convert. Select 'Tasks' > 'Generate Scripts...'.

Change Hyper-V Default Folders Step 1

2) Next

Click 'Next'.

Change Hyper-V Default Folders Step 1

3) Select database and objects

Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'

Change Hyper-V Default Folders Step 2

4) Convert Options

Set options:

'Script for Server Version' = 'SQL Server 2005' 'Script Data' = 'True' 'Scirpt Database Create' = 'True'     

Change Hyper-V Default Folders Step 2

5) Output Option

Select option 'Script to file', 'Single file' and 'Unicode text'.

Change Hyper-V Default Folders Step 1

6) 'Finish'

View summary and click 'Finish'.

Change Hyper-V Default Folders Step 1

7) Result

Now you got a complete database creation script with data. It can be executed on target database server.

Change Hyper-V Default Folders Step 1

8) Amend Script

Open the generated script in SQL Server Management Studio 2005. Find the following section and amend the path to proper data folder
    CREATE DATABASE [StockTraderDB] ON  PRIMARY  ( NAME = N'StockTraderDB',  FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB.mdf ,  SIZE = 4352KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )  LOG ON  ( NAME = N'StockTraderDB_log',  FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB_log.LDF',  SIZE = 6272KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) 

9) Execute the Script

When finished, You should get converted database of SQL Server 2005

Friday, June 6, 2008

How do I...Troubleshoot problems running updateWiki.sh from behind a proxy server? - Open Garden

How do I...Troubleshoot problems running updateWiki.sh from behind a proxy server? - Open Garden

How do I...Troubleshoot problems running updateWiki.sh from behind a proxy server?

  • We have highlighted your search term http_proxy for you. If you'd like to remove the search term, reload this page.
Table of contents
No headers

updateWiki.sh uses the svn up command to get the latest dekiwiki bits. If your wiki is behind a proxy server it may fail. SVN allows you to set your proxy server like this:

nano /root/.subversion/servers

Then set these values in the [global] section

http-proxy-host = defaultproxy.whatever.com
http-proxy-port = 7000
http-proxy-username = defaultusername
http-proxy-password = defaultpassword

NOTE: This may not work if you're using a Microsoft ISA proxy server.

For more informaiton about configuring SVN options see this page:

http://svnbook.red-bean.com/en/1.4/s....confarea.opts

Unofficial ISS Linux Web Pages - Proxy Settings

Unofficial ISS Linux Web Pages - Proxy Settings: "Environment Variables

Some software, mostly command line based software, get their proxy settings from a group of enviroment variables.

http_proxy='http://wwwcache.ncl.ac.uk:8080'
https_proxy='http://wwwcache.ncl.ac.uk:8080'
ftp_proxy='http://wwwcache.ncl.ac.uk:8080'

export http_proxy https_proxy ftp_proxy

You can setup these variables automatically for all users by adding them to the file /etc/profile or the proxyenv files in /etc/profile.d/ depending on your distribution."

Saturday, May 31, 2008

Upgrading Deki Wiki From 1.9.0 (Itasca) to 8.05 (Jay Cooke) VM Only - MindTouch Deki Wiki

Upgrading Deki Wiki From 1.9.0 (Itasca) to 8.05 (Jay Cooke) VM Only - MindTouch Deki Wiki

Upgrading Deki Wiki From 1.9.0 (Itasca) to 8.05 (Jay Cooke) VM Only

This guide assumes you are upgrading the MindTouch Deki Wiki VMWare-Certified Virtual Appliance from v.1.9.0 to v.8.05. If you are upgrading from an earlier version, please visit http://wiki.opengarden.org/Deki_Wiki/Installation_and_Upgrade to find your appropriate guide.

While the upgrade script does not affect the MySQL database and settings files, it is recommended in case a full reinstall is needed.


Back Up Attachments

Type the following commands to create the backup directory and back up your attachments:

# mkdir ~/deki_backup
# cd /var/www/dekiwiki/
# tar cvzpf ~/deki_backup/attachments.tar.gz /var/www/dekiwiki/attachments

Back Up Settings Files

Enter the following commands to back up the files that Deki Wiki uses to determine settings:

# cp /var/www/dekiwiki/LocalSettings.php ~/deki_backup
# cp /etc/dekiwiki/mindtouch.deki.startup.xml ~/deki_backup
# cp /etc/dekiwiki/mindtouch.host.conf ~/deki_backup

Backup your MySQL Database

Use the following line to back up the MySQL database:

# mysqldump -u -p wikidb > ~/deki_backup/wikidb.sql

If you did not change the default username and password, then it would be root and password for and , respectively.

Upgrade the Wiki

Type the following command to upgrade DekiWiki to the newest version:

updateWiki.sh

After that script has completed, go to the IP of your wiki and click on Tools, and then About to confirm you are at the latest version.

Rebuild the Index

In the wiki, click on Tools, then Control Panel, and then Site Settings.Click Rebuild Index to re-index the wiki.

Monday, May 12, 2008

i-Installer for netpbm

i-Installer Home Page
i-Installer is unsupported software as of Jan 1, 2007. For the foreseeable future I will be using i-Installer myself for several of my installs for personal use (mainly TeX) and as such I will maintain the program and some of my i-Packages.

What ends is e-mail support for people using i-Installer or any of my i-Packages. If you are looking for help, please join the Mac OS X TeX mailing list, which is the most active user community at the time I am writing this.

Bug reports can still be sent to me, but you will not get a reaction and it is uncertain if and when I will be paying attention to them. If it is something that does work for me (and thus something with your particular setup, I will most likely not pay any attention to them).


I will be announcing the actual end of support on ii2-announce@mail.rna.nl. Until then, I am still actively working to get to the situation that I can drop supporting the community.
i-Installer is open source under a BSD License. i-Installer is hosted on
SourceForge.net Logo
You can get to the i-Installer project home page by following this link.

i-Installer code is not particularly good. This is the result of the fact that it has been written as a pilot-project-gone-awry in combination with the fact that certain aspects of the environment (Mac OS X) played foul with my original architecture ideas (it just did not work at that time). Mac OS X has improved since, but i-Installer would have to be rewritten to benefit. That is only going to happen if I win the lottery and do not have to work for al living anymore...

You won't believe it, but this program actually has attracted fan mail (and some hate mail). An edited selection of fan mail can be found here

Introduction

Welcome to the i-Installer Home page. i-Installer is a network-aware installer application for Mac OS X 10.2 or higher. It installs i-Packages which are directories with a name ending on .ii2 and which contain a set of files. An in-depth introduction (in fact: the i-Installer Help Book) can be found here.

i-Installer is a generic software install and configuration application. It can install socalled i-Packages, which are wrappers (directories containing files) with names ending on .ii2 and which will look like files in most applications (like the Finder). i-Packages can be updated and downloaded from remote locations. Most of this will happen automcatically.

i-Packages may have the following functionality:

  • Installation (and subsequent Configuration)
  • (re-)Configuration
  • Uninstallation (removal)

i-Packages may be interactive in a limited way. i-installer provides the package with access to several predefined sheets that can be displayed on the package window. That way, especially configuration can involve the user. (In other words: install TeX and select formats, languages in a GUI, install ghostscript and be offered a choice to add TeX's type1 fonts to an installed ghostscript).

i-Packages exist just like other wrappers: on your hard disk. You can create packages from remote URL locations by entering an URL (like http://www.ntg.nl/macosx-tex/i-packages/texmf.ii2 in a panel.

However, the easiest way to create packages on disk from remote locations is using a "Known Packages" menu. This will list a series of packages and their location for you to choose from, called an i-Directory. The i-Directories may be local files or web based. As of Jan 1, 2007, the current set is (this may change without notice):

  • http://tug.org/i-packages/iid/gwrelative.iid (default)
  • http://www.ntg.nl/macosx-tex/i-packages/iid/gwrelative.iid
  • http://www.math.utah.edu/ftp/pub/i-packages/iid/gwrelative.iid
  • http://bloch.ling.yale.edu/i-packages/iid/gwrelative.iid
These refer to each other in a circular manner . You can influence both the default i-Directory to use and the amount of descend into te web of i-Directories in i-Installers preferences. You can travel the i-Directory web in the Known Packages window. There exists a separate repository for experimental versions of my i-Packages:
  • http://bloch.ling.yale.edu/i-packages/experimental/iid/gwrelative.iid

The following packages are available from me (unsupported):

  • TeX-related:
    • TeX (based on a subset of TeX Live). This include installs of TeX4ht, Latin Modern fonts (scalable fonts for PostScript/PDF) and XeTeX
    • CM Super (PostScript/PDF vector versions of TeX fonts). This provides support for vector versions of TeX fonts so you can make scalable PDF documents that look good at any resolution, including screen resolution. This package is not required. It is roughly 60MB in size. These are deprecated, you should use the Latin Modern fonts instead.
    • CB Greek (Greek fonts and support)
    • MusixTeX (Support for typesetting music)
    • ConTeXt updater. ConTeXt is a powerful alternative to LaTeX. It is very actively maintained and regularly updated versions or betas are released by its author Hans Hagen of Pragma ADE. My server checks for updates every night and if there has been a change, automatically rebuilds the i-Package from the new materials. Combined with i-Installer's check for updates this provides with a completely automatic way to check for ConTeXt updates.
    • Gerd Neugebauer's BibTool. Command line bibliography file (.bib) manipulation.
    • LaTeX to RTF Converter
    • RTF 2 LaTeX2e converter
  • Support for various graphic formats and conversions.
    • Ghostscript 8 the free PostScript interpreter. You need this for TeX if you want to use PS-dependent TeX tricks, old projects, etc
    • Autotrace
    • Eddie Kohler's LCDF Typetools (these are also part of the TeX i-Package)
    • ImageMagick (image conversion and manipulation)
    • JPEG Tools and Library
    • PNG Library
    • TIFF Library
    • Netpbm Tools and Library
    • libwmf conversion support
    • libiconv conversion support (only required on Mac OS X versions before 10.3)
    • wvWare (MS Word conversion)
  • Support for font conversions.
    • Freetype2
    • Fondu (tool for unpacking Mac Fonts)
    • FontForge (formerly PfaEdit)
    • ttf2pt1 TrueType to PostScript Type1 font conversion
  • System utilities and libraries
    • MacBinary and binhex cli utils
    • i-Installer itself (naturally)
    • Xaw3d Library for X11R6 (3D widgets)
  • Applications
    • Ghostview PostScript viewer (requires an X11-installation)
    • XFig drawing program (requires an X11-installation)

Some others provide i-Packages as well. There is a package for the JOVE emacs-like command line editor, provided by Tom Hageman.

Warning: as i-Installer depends on the web, you may encounter long time outs when servers are busy. See the performance section in i-Installer Help for more info.

i-Installer offers the possibility for regular backgound (no need to start i-Installer, no need to be logged in) checking for new releases of packages you have available.

The i-Installer application download can be found here: II2.dmg. This will download a disk image. A disk image is a file that contains an image of a disk. Such a file can be used just like a disk can. You need to mount that disk image. Mounting a disk image can be done by double clicking it in the Finder.

When the disk image has been mounted, you will have an extra `disk' listed in your Finder window. On it you will find two files, a README file and an APple Installer.app .pkg. To install i-Installer, install the .pkg. Once installed, i-Installer can be used to update itself.

Run i-Installer and (if you are connected to the internet) select the Known Packages submenu. You will be presented with a list of known packages. See my TeX page for more information on the TeX i-Packages and volumes and possible mirror locations.

The i-Installer volume is also mirrored. The following mirrors are available:

You are hereby granted permission to mirror the i-Installer volume, under the following conditions:

  • The mirror image should not be older than a day (you need to synchronize at least once a day)
  • You make clear on your distribution site that you are offering a copy of my distribution and you link to this web page

There is a mailing list for announcements about i-Installer.

i-Installer was designed and written by Gerben Wierda. The beautiful icons were designed by Jérôme Laurens.

i-Installer Know How

How and where do I report problems?

E-mail about i-Installer can be sent to ii2 at rna dot nl. Note that this address may be protected by an anti SPAM system, in which case you'll get a robot-reply to tell you how to reach me.

Please read the top of this page carefully. Bugs may be reported but I do not support this software anymore except for my personal use, hence, fixes may or may not come and may take a long time to come. If you report a bug, make sure to include.

  • What you did.
  • Your OS version and what you can tell me about what is installed.
  • For i-Installer and i-Packages
    • In case of an i-Installer crash: the crash log.
    • In all cases: the log output in Console.app. If the problem is reproducible, set i-Installer to a higher log level (e.g. 6) and recreate the problem. Send me that Console.app output.
    • The contents of a report (see below) *after* the error has occurred. In case of a crash, from before the crash occurs.

i-Installer has a menu option Create & Display Report in the i-Package menu, which you should use preferably and if possible. This creates a report on settings, properties, output, etc. of you i-Package. If you select the menu item, a special tab view opens in the i-Package window. There you find a mail button to send it to me.

i-Installer or i-Package Foo does not work on 10.2 and older!

Correct. Mac OS X 10.2 and older versions are not supported. Mac OS X 10.1 and older are not supported at all and no i-Installer version will run on them. For Mac OS X 10.2 you can download a volume of 357MB which contains a snapshot of i-Installer.app and all my i-Packages from Jan 24, 2006. All of these should install and work on Mac OS X 10.2. However, there have been so few users actually running 10.2 lately that this is not guaranteed.

Does i-Installer support authenticating proxies?

Sadly, No. The problem is mainly that the stuff in Cocoa I have used did not support this in the past. Only later versions of Cocoa have support for this and enabling this would require a complete rewrite of the download object (and dropping support for Mac OS X 10.2). This might happen, but not soon, and the main problem for me would be that I would be unable to test it (as I am not behind such a proxy myself).

What you can do instead is to download the package entirely through other means (like wget) and then use it from disk with network access for i-installer turned off.

The check of the remote package md5 checksum failed

A possible reason is that there is a cache between you and where your are downloading from and this cache is misbehaving. It is offering you an old version of the checksum or the table of contents even if there is a new version available *and* it is instructed by i-Installer to ignore caching (check your preferene setting on this).

An other possible reason is that you have been trying to update while the package was being updated. There is a protection against this in i-Installer, but this is not 100% proof as it would lead to unacceptable response times. If this is reproducable (i.e. it happens when you hit update again say one hour later) this update problem is not the cause.

It is as far as I know impossible for there to be another cause. i-Installer downloads the new table of contents and saves this (reporting download or write errors along the way). Then it checks the new table of contents (which has been downloaded) against the remote md5 checksum.

How do I check the up-to-dateness of i-Packages without running i-Installer?

i-Installer has a preference for this. You can tell it to check all i-Packages in the default save directory on a regular basis. You will get mail when one of them have been updated. See i-Installer help for details.

If you want to create a background check for packages in other locations, or just a few of the packages in your default save location, you need some unix knowledge. i-Installer writes its setting for this feature in the cron system. If you know how to edit this, you can easily copy and adapt the example that i-Installer writes there itself.

How do I minimize web traffic?

i-Installer itself minimizes web traffic by only downloading what is necessary for the action you want to perform (i.e. for removal, only the removal script is downloaded, not the archive itself). Read the help on inspection of archives to find out how inspection web traffic is minimized.

However, there is one thing you can do yourself. Suppose you have a package installed and an update has become available. You want to know if it is necessary to update and what will be downloaded, before actually doing the download, which you may want to do at another time. Here is how you go about it:

  • Update the package (in the properties tab, click the update button). Note: this will remove any parts of the local package that have changed. So if your package is complete (fattened), back it up first en restore it if you decide you want to go back to the old situation. The message view will tell you which files have changed and have therefore been removed locally.
  • Now, in the inspect tab, you can see which files are available. Suppose the archive (normally the biggest part) has been removed because it has changed. Inspect the README (which should have been changed as well). The README should tell you (if the package maintainer is doing his work properly) what has changed and you can decide if you want the update or not. If you do not, you may restore the backup to get your old situation back.

I do not have a (fast) internet connection. What should I do?

Note: This procedure is very wasteful. You will be downloading everything in an i-Package, far more than you need. Also, this only works for my repository which is available via ftp.

Go to a machine that has a fast internet connection. Any machine will do, but the following instructions are based on a unix machine using the ncftp command. If you go to a Windows machine, do the equivalent, but then in Windows (and I do not know how).
  1. Change directory to where you want the i-Packages. E.g. cd ~/Desktop
  2. Get the i-Packages (approximately 300MB!):
ncftpget -R ftp://ftp.nluug.nl/pub/comp/macosx/i-packages
  1. Get i-Installer:
ncftpget ftp://ftp.nluug.nl/pub/comp/macosx/volumes/ii2/II2.dmg
  1. Copy the i-packages directory and II2.dmg to an USB stick or a CD and bring it to your Mac.
  2. On your Mac, open II2.dmg and install the Installer.app .pkg on that volume.
  3. Log out and log in (to get .ii2 and .iid recognized by the system, this might not be needed on recent versions of the OS)
  4. Double click /i-packages/iid/gwrelative.iid
  5. Open and install the i-Packages you require
Ignore all i-Installer warnings you get about not being able to find stuff on the internet. Best is to start i-Installer, and set network preferences to no network traffic at all.

Why is button X disabled?

When i-Installer is performing a set of activities, most buttons are disabled. This is because the implementation of a combination of parallel activities is incomplete. When you download the archive because you want to install, hitting Inspect for that archive would start the same download and check set. These two sets would currently interfere.

Secondly, a package may be 'locked' (you see the small lock button on the package window). This is a protection against accidentally modifying a package hat is in 'useful' state. i-Installer will not modify the locked package (e.g. updating, fattening, etc). For instance, I ship a TeX volume with on it the latest i-Installer program and two i-Packages (TeX and ghostscript). Ghostscript is complete (fat). TeX is complete for a standard installation. Both are locked. They cannot be changed because they are on a read-only volume. But locking them also prevents i-Installer from actually trying. If you want to change such a package (e.g. update it), the best thing to do is first copy it to the default save directory of i-Installer, open it and unlock it.

Thirdly, i-Packages may be retired and these only support uninstalling.

After installing package Foo, the ownerhip of files and directories has changed!

This means that the package provider has included existing directories in the gnutar archive and gnutar creates these with the ownership in the archive, even if they already exist with another owner. The package provider can solve this problem by not providing directories, only the files in the directories. In that case directories are created when unavailable but not recreated or changed ownership when already available.