Sample Installation

1. Open up a shared hosting account at sqlservermart.com. We will use this example with a hosting account we opened for testing officeclip.info.
   
2. Login to the Helm Control panel with the id and password that is supplied to you and click on the My Domains icon. Then click on the domain name.
   
3. On the domain screen click on the MS SQL Server 2005 icon.
   
   
4. On the Databases table click on Add to create a new database.
   
5. On the Users table click on the Add icon. Enter a new user name and password and assign the database you created to the user.
   
   
   
   
   
6. From the MS SQL Server 2005 screen click. On the next screen note the Connecton String with is in the format:
   "SERVER=ipaddress,port#; DATABASE=yourdatabasename; UID=yourusername; PWD=yourpassword" where yourdatabase name is the name of the database you created, username and password are the username and the password of the user you just created.
   
   
   
7. Download manualInstall.zip from the OfficeClip website and uncompress in a folder on your machine. Make sure that your machine has .Net Frameword 2.0 installed.
   
8. Run OfficeClip.Install.SetupDb.exe -1 "name@mail.com" where name@mail.com is your email address.
   
9. Run octools.exe and change the following parameters:
   1. Select Option 6 (Set Sql Server...), enter the database parameters for the database that you got from the control panel and Test the database. Then click on the Apply button.
      
      
   2. Select Option 3 (Change Application Settings), then do the following:
      1. Select HOSTStr from Key and change the domain. For example if your site is http://myhost/officeclip/default.aspx, change it to myhost. Then click on the Apply button.
      2. Select VDIRPath and change it to the location of virtual directory (in this case /officeclip/). Note the slash before and after. Then click on the Apply button.
      3. Select AdminEmailAddress and change it to your email address. Then click on the Apply button.
      4. Select supportEmailAddress and change it to your email address. Then click on the Apply button.
      5. Select Option 4 (Set Http Handlers ...) and disable the crystal reports. Then click on the Apply button.
         
10. Run OfficeClip.Install.OcConfigure.exe, Set the smtp parameters and timeout parameters.
    
    
    
11. Run OCmd.exe -c 1. This will create all database entries and may take some time. Check the log files (in the log folder) in case of any error.
    
12. Run OcTools.exe and select Option 3 (Change Application Settings). Select UploadFolderPath and set the path to RootFolder\upload\. Where RootFolder is the full path (e.g. c:\Domains\path) of the folder where OfficeClip is supposed to be installed. See below on how to get this path. Note: The path should end with a backslash.
    
    • Login to the Helm Control Panel at sqlservermart.com.
    • Click on My Domain and then click on your website.
    • Click on Website Settingss.
    • Note the Physical path to root. Use this a RootFolder above.
      
13. ftp all the files from your local machine to your service provider location in your wwwroot folder.
    
14. Login to the Helm Control Panel at sqlservermart.com and click on My Domain and then click on the website. Then click on the Virtual Directories icon. Click on Add.
    
    
    
15. Create a new virtual directory called officeclip and point it to the \wwwroot\officeclip folder.
    
    
    
16. Go back to your website in Helm Control Panel and now click on the icon called Scripting Support. Make sure that the Asp.Net version is set to Version 2.
    
    
    
17. To test the installation run http://yoursite/officeclip/systemtest.aspx