Avensoft
On-Demand Help Desk Help Desk Software Free Trial How To Buy Support More Products About Us
nService Upgrade Instructions

How do you know which release of nService you are using?

Click the “Powered by nService” link at the low left corner of any page on your nService website.

Upgrade from an older build of 4.19 to the latest build

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Copy the old web.config back to \Inetpub\wwwroot\nService4\.
  6. Restart nService4AppPool application pool in IIS Manager.

Version 4.19 (March 1, 2010)

This version provides a new Active Directory integration import page. Please take the following steps to upgrade from version 4.18.

  1. If you are using Active Directory to authenticate users, go to nService, Users, Import From Active Directory. Print out that page.
  2. Go to IIS manager to stop the nService4AppPool application pool.
  3. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  4. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  5. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  6. Open \Inetpub\wwwroot\nService4\Upgrade\nService418to419.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  7. Restart nService4AppPool application pool in IIS Manager.
  8. If you are using Active Directory to authenticate nService users, go to nService, Organizations, Directory. Add one or more organization units to map to your Active Directory user containers according to the print out from step #1.

Version 4.18 (Feb 14, 2010)

This version added the secure email support and capability to customize the request detail for service users. Please take the following steps to upgrade from version 4.17.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService417to418.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Restart nService4AppPool application pool in IIS Manager.

Version 4.17 (January 29, 2010)

This version added the capability to customize the Submit Request form. It also added the multi-line text box support to the custom fields. Please take the following steps to upgrade from version 4.16.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService416to417.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Restart nService4AppPool application pool in IIS Manager.

Version 4.16 (January 22, 2010)

This version added the capability to customize the Respond, Resolve and Close form. Please take the following steps to upgrade from version 4.15.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService415to416.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Restart nService4AppPool application pool in IIS Manager.
  7. To fix common problems, please refer to this article

Version 4.15 (January 18, 2010)

This version added the capability to customize the action forms. Please take the following steps to upgrade from version 4.14.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService414to415.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Restart nService4AppPool application pool in IIS Manager.
  7. Go to nService website, Services. Remove Request ID and Subject from all View action fields.

Version 4.14 (January 1, 2010)

This version added the capability to customize the request detail page. Please take the following steps to upgrade from version 4.13.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService413to414.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Restart nService4AppPool application pool in IIS Manager.
  7. Sign in to nService as a nService system administrator. Point your browser to /Upgrade/Upgrade413to414Page.aspx. Click Update Database.

Version 4.13 (November 6, 2009)

This version added the "Assigned To" in the request history. Please take the following steps to upgrade from version 4.12.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService412to413.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Restart nService4AppPool application pool in IIS Manager.

Version 4.12 (November 1, 2009)

This version added 10 custom fields to the requests. These fields can be displayed on tabular reports. Please take the following steps to upgrade from version 4.11.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService411to412.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Restart nService4AppPool application pool in IIS Manager.
  7. Sign in to nService as an administrator. Go to Products and edit all product categories that are on the 3rd, 4th and 5th level of the product catalog tree. Save them without change. Don't edit the products, just the categories. This would set the ancester IDs of all records in the product table. This is needed by the new product based request and asset search feature.

Version 4.11 (September 27, 2009)

We added a new HTML editor to this version along with some bug fixes. Please take the following steps to upgrade from version 4.10.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService410to411.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Restart nService4AppPool application pool in IIS Manager.

Version 4.10 (July 7, 2009)

Please take the following steps to upgrade from version 4.9.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService49to410.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Modify table ns4_user. Change the usr_email column from nvarchar(90) to nvarchar(250).
  7. Edit the content of table ns4_req_query. Go over each record that has rq_type = 2, 3 or 4. Copy the content from the rq_sql_select column to the rq_aggr_functions column.
  8. Open up \Inetpub\wwwroot\nService4\web.config and copy the following section <location path="Images"> ... </location>
  9. Copy the old web.config back to \Inetpub\wwwroot\nService4\. Open it up in notepad and paste the code from last step.
  10. Restart nService4AppPool application pool in IIS Manager.

Version 4.9 (June 27, 2009)

This version doesn't use an ODBC data source to connect to the database. Instead, it uses the connection string in web.config to do that. So make sure you correct this connection string to point to your server and database. Please take the following steps to upgrade from version 4.8.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService48to49.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Open up \Inetpub\wwwroot\nService4\web.config and correct the database connection string. If your SQL Server uses Windows integrated authentication, just correct the server and databaes. connectionString="Server=localhost\SQLEXPRESS;Database=nService4;Trusted_Connection=Yes;" If your SQL Server uses SQL Server authentication, change it to something like: connectionString="Server=MyServer;Database=pubs;User Id=MyUser;Password=MyPassword;" .
  7. If you use Active Directory authentication with nService, follow the instructions for the authentication tag in web.config.
  8. Restart nService4AppPool application pool in IIS Manager.
  9. Change all custom color schemes in user accounts to the "winter" theme. Users can recustomize their shemes. This ensures their custom schemes are compatible with this new version.

Version 4.8 (April 25, 2009)

Please take the following steps to upgrade from version 4.7.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://www.avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Open \Inetpub\wwwroot\nService4\Upgrade\nService47to48.sql in SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button and then execute it.
  6. Copy the old web.config back to \Inetpub\wwwroot\nService4\.
  7. Restart nService3AppPool/nService4AppPool application pool in IIS Manager.
  8. Change all custom color schemes in user accounts to the "winter" theme. Users can recustomize their shemes. This ensures their custom schemes are compatible with this new version.

Version 4.7 (Jan 28, 2009)

This version added new features including the capability to update the user of multiple assets in one shot and the capability to hide the Reference # and the Closing Due fields on the new request page. Please take the following steps to upgrade from version 4.6.

  1. Go to IIS manager to stop the nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://www.avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Run \Inetpub\wwwroot\nService4\Upgrade\nService46to47.sql in your SQL Server Management Studio. Make sure you select the right database (nService4) from the database list next to the Execute button before you run it.
  6. Copy the old web.config back to \Inetpub\wwwroot\nService4\.
  7. Restart nService3AppPool/nService4AppPool application pool in IIS Manager.

Version 4.6 (October 1, 2008)

This version added fields for user defined theme and the request progress field. Please take the following steps to upgrade from version 4.5.

  1. Go to IIS manager to stop the nService3AppPool/nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://www.avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Run \Inetpub\wwwroot\nService4\Upgrade\nService45to46.sql in your database to update it. Make sure you select the right database (nService4) from the database list next to the Execute button in MS SQL Server Management Studio.
  6. Copy the old web.config back to \Inetpub\wwwroot\nService4\.
  7. Restart nService3AppPool/nService4AppPool application pool in IIS Manager.

Version 4.5 (September 1, 2008)

This version added support for request workflow. There is no version 4.4. Please take the following steps to upgrade from version 4.3.

  1. Go to IIS manager to stop the nService3AppPool/nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://www.avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Run \Inetpub\wwwroot\nService4\Upgrade\nService43to45.sql in your database to update it. Make sure you select the right database (nService4) from the database list next to the Execute button in MS SQL Server Management Studio.
  6. Copy the old web.config back to \Inetpub\wwwroot\nService4\.
  7. Restart nService3AppPool/nService4AppPool application pool in IIS Manager.

Version 4.3 (April 1, 2008)

This version added support for site management and allow reference numbers for service requests. Please take the following steps to upgrade from version 4.2.

  1. Go to IIS manager to stop the nService3AppPool/nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://www.avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Run \Inetpub\wwwroot\nService4\Upgrade\nService42to43.sql in your database to update it. Make sure you select the right database (nService4) from the database list next to the Execute button in MS SQL Server Management Studio.
  6. Go to the Object Explorer in SQL Server Management Studio, right click nService4 database and select design.
    7. Change column width of the following fields to to NVARCHAR(100): ns4_article_file.af_mime_type, ns4_asn_file.anf_mime_type, ns4_sc_file.scf_mime_type, ns4_srn_file.snf_mime_type.
  7. Copy the old web.config back to \Inetpub\wwwroot\nService4\.
  8. Restart nService3AppPool/nService4AppPool application pool in IIS Manager.

Version 4.2 (November 27, 2007)

This version increased the size of the ns4_req_query.rq_where field from 200 to 500. It also has the latest French translation. To upgrade, take the same steps as the section before for 4.1. In addition, make the following change to the database.

  1. Run SQL Server Management Console, locate the ns4_req_query table, right click it and select Modify. Change the size of rq_where from 200 to 500.

Version 4.1 (October 1, 2007)

This version added support for service specific email template and user defined service request fields. Please take the following steps to upgrade from version 4.0.

  1. Go to IIS manager to stop the nService3AppPool/nService4AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService4\ by copying it to another location.  
  3. Delete \Inetpub\wwwroot\nService4\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService4\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://www.avensoft.com/ns/nService4c.zip and unzip it to \Inetpub\wwwroot\.
  5. Run \Inetpub\wwwroot\nService4\Upgrade\nService40to41.sql in your database to update it. Make sure you select the right database from the database list next to the Execute button in MS SQL Server Management Studio.
  6. Copy the old web.config back to \Inetpub\wwwroot\nService4\.
  7. Restart nService3AppPool application pool in IIS Manager.

Version 4.0 (September 1, 2007)

This version supports Unicode. You can now store text in multiple languages in to the database. In addition, it allows you to set up cascading services. Please take the following steps to upgrade from version 3.12.

  1. Install version 4 according to the instructions at http://avensoft.com/download.html.
  2. When you run ns4ms.sql to create the tables, run it in nService3's database.
  3. Run ns312to4ms.sql in SQL Server Management Studio. Make sure you select nService3 database before you execute the script.
  4. Modify your new nService4 ODBC data source from step #1 and set its default database back to nService3.

Version 3.12 (June 15, 2007)

This version fixed the Office 2007 attachment problem. Please take the following steps to upgrade.

  1. Go to IIS manager to stop the nService3AppPool application pool.
  2. Backup \Inetpub\wwwroot\nService3\ by copying it to another location.
  3. Delete \Inetpub\wwwroot\nService3\ and \Windows\Microsoft.Net\Framework\2.0…\Temporary…\nService3\. If you deployed nService as a website instead of a web application under one of your sites listed in your IIS Manager, then you need to delete the \Windows\Microsoft.Net\Framework\2.0…\Temporary…\root\ folder instead. That is because IIS puts the compiled web pages of nService in one of the subfolders of the above root folder. You can find that subfolder and delete it if you don’t want to stop your entire IIS to delete the root folder.
  4. Download http://www.avensoft.com/ns/nService3.zip and unzip it to \Inetpub\wwwroot\.
  5. Copy the old web.config back to \Inetpub\wwwroot\nService3\.
  6. Modify your SQL Server nService3 database. Change the following mime type fields from varchar(30) to varchar(100)
        ns3_asn_file.anf_mime_type 
        ns3_sc_file.scf_mime_type
        ns3_srn_file.snf_mime_type
        ns3_article_file.af_mime_type
        ns3_email_file.emf_mime_type
  7. Restart nService3AppPool application pool in IIS Manager.

To fix the problem with the existing attachments in the database, you need to use the Attachments link in the history section to reattach them. You can right click on an attachment link, save it as a file on your local disk, and then replace the one in the database with the one on your local disk. This way, the MIME type gets corrected.

Upgrade HD2 data

  1. Install nService 4.13 (http://avensoft.com/ns/nService4c.zip)
  2. Copy \Inetput\wwwroot\nService4\Upgrade\upgrade_hd2.hds to \hd2\webroot\script\folder.
  3. Open it up in Help Desk Studio. Correct the data source settings if needed.
  4. Select Debug | Start to run the script.
  5. Sign in to nService4 web site as user ns4.admin with no password. Point your browser to http://nService4_website/Upgrade/UpgradePage.aspx to encrypt all passwords.

Upgrade Perfect Tracker 7 Help Desk data

  1. Please upgrade your Perfect Tracker 7 to Help Desk Server 2 first and then upgrade from HD2 to nService4.

Upgrade Perfect Tracker 6 Help Desk data

  1. Copy \Inetput\wwwroot\nService4\Upgrade\upgrade_pt6hd.hds to \pt6\script\folder.
  2. Open it up in Perfect Tracker 6 Studio. Correct the data source settings if needed.
  3. Select Debug | Start to run the script.
  4. Sign in to nService4 web site as user ns4.admin with no password. Point your browser to http://nService4_website/Upgrade/UpgradePage.aspx to encrypt all passwords.
  5. Check everything to see if the data has been copied over. Set up routing rules if necessary.
© 1997-2010 Avensoft