General - Revision history

John.devonshire: /* Backing Up Data */

2016-02-12T12:42:45Z

‎Backing Up Data

John.devonshire at 15:39, 20 November 2014

2014-11-20T15:39:02Z

Show changes

John.devonshire: /* Why Security */

2014-07-28T11:12:19Z

‎Why Security

John.devonshire: /* Changes to Software */

2014-03-12T13:46:42Z

‎Changes to Software

John.devonshire: /* Upgrading Ad Manager Versions */

2014-03-12T10:55:32Z

‎Upgrading Ad Manager Versions

John.devonshire: /* Importing Your License */

2014-03-10T10:28:51Z

‎Importing Your License

John.devonshire: /* Importing Your License */

2014-03-10T10:28:29Z

‎Importing Your License

John.devonshire: /* Importing Your License */

2014-03-10T10:15:25Z

‎Importing Your License

John.devonshire: /* Importing Your License */

2014-03-10T10:08:35Z

‎Importing Your License

Alex.tso at 13:41, 13 August 2013

2013-08-13T13:41:25Z

← Older revision		Revision as of 12:42, 12 February 2016
Line 34:		Line 34:

	Backup software can be purchased off the shelf, or you can use the backup routines already in use on your network server. We would also recommend that you test the backup software by backing up data and trying to retrieve it. If your backup software does not work properly, it is best to find out before you really need to use it.		Backup software can be purchased off the shelf, or you can use the backup routines already in use on your network server. We would also recommend that you test the backup software by backing up data and trying to retrieve it. If your backup software does not work properly, it is best to find out before you really need to use it.
		+
		+	=== SQL Server backups ===
		+
		+	Microsoft SQL does come with the ability to back up your databases. This is done through a program provided as part of the installation tools called SQL Server Management Studio. While each version of SQL can be slightly different in the way backups are created, the general steps are below. We recommend undertaking an internet search for specific instructions on how to back up your data for the version of SQL you have.
		+
		+	The first step is to log into SQL Server Management Studio. This can be done by going to your Start menu and looking for the folder containing the version of SQL you are on. Launch SQL Server Management Studio. At this point, you will be prompted to log into the database.
		+
		+	[[File:SSMSLogin.PNG]]
		+
		+	Please check the name of the server you use when logging in to Ad Manager and make sure it matches the name presented on this login page. If you have windows authentication or mixed mode authentication set up, you most likely can click Connect to get into Management Studio. If you only have SQL Server authentication set up, you will need your username and password to log in. Please note that certain users may not have privileges to create backups.
		+
		+	Once you are in SQL Server Management Studio, open the Databases folder. Once this has expanded, you should see a database that matches the database name you access when logging into Ad Manager. If you are using Ad Manager or a later version of Charting Pro, you will also see a second database with the same name, followed by "_bin". If you do not see the databases, then you may be accessing the wrong SQL Server.
		+
		+	Right click on the either of these databases and look for Tasks-Backup. A window will appear allowing you to create your backup. If a filename appears in the Destination section at the bottom, click Remove. Check the other settings on this page against the recommended settings found during your search. You should have the database set to the name of the database you selected, and the backup type should be full.
		+
		+	[[File:Backup1.PNG\|600px]]
		+
		+	Once you have checked these settings, click Add in Destination. At this point you will be asked for a location to save the backup and the name of the file. Click the ellipsis (...) in order to specify a directory and a name. Highlight the folder you want the backup placed in and enter the name at the bottom under file name. Be sure to put a .bak at the end of the file name to make it easier to find later.
		+
		+	[[File:Backup2.PNG\|600px]]
		+
		+	Once you have specified where to backup your data, click OK, then OK again, and double check your settings. It is suggested that you also go to the Options tab and select "Overwrite all existing backup sets" before proceeding. When you are ready, click OK. SQL will back up your database and notify you when the backup is completed.
		+
		+	Once you have backed up the first database, go to the second Ad Manager database and repeat the procedure. Be sure to use a different name for this file, otherwise you will overwrite the file you created for the other database.
		+
		+	At this point, you can check the directory you saved these files in and make sure the 2 .bak files are present. You can now leave them where they are, copy them to offsite storage or follow any other procedures suggested.

	== Entering the Software ==		== Entering the Software ==

@@ Line 180: / Line 180: @@
 Ad Manager allows its users to set up user names and passwords to control access to the software. This is a very valuable and important feature for several reasons.
 By setting up user names, you can ensure that only authorized staff have access to the software and its powerful features.
 Each user may have different areas of responsibility. You may want to limit staff to be able to access only those areas of the software that they require. Restricting access to other portions of the software can aid in ensuring only those people responsible for a function have access to it.
 Each user will have their own "work environment". Users may prefer seeing information in a particular sort order, or filter their information to only see certain structures or contracts. Each user may also have a preferred printer they want to print to.
 Each user can set up predefined views. These views can be public (seen by all users), or private (available only to them)
 If a user makes changes to the scheduling of a contract, or if they schedule a face to a contract that may cause problems (e.g. line of sight issues, restricted from that location or not available during that time frame), the software will record which user made these changes. This allows you to follow an electronic paper trail, and follow up with the appropriate person as to why this change was made.
 As you can see, Ad Manager's security feature allows you greater control over your working environment, ensuring a more efficient and successful use of our software.

← Older revision		Revision as of 13:46, 12 March 2014
Line 20:		Line 20:

	Backup software can be purchased off the shelf, or you can use the backup routines already in use on your network server. We would also recommend that you test the backup software by backing up data and trying to retrieve it. If your backup software does not work properly, it is best to find out before you really need to use it.		Backup software can be purchased off the shelf, or you can use the backup routines already in use on your network server. We would also recommend that you test the backup software by backing up data and trying to retrieve it. If your backup software does not work properly, it is best to find out before you really need to use it.
−
−
−	~~== Changes to Software ==~~
−	~~As changes are made to the Software, this page will summarize what is new in the most current version.~~
−	~~Ad Manager for Windows, Release 2000~~
−
−	The most obvious change for users of the Ad Manager Suite of Products is the appearance of the software. Ad Manager has now been designed to mimic the appearance of Microsoft Outlook, a standard in many workplaces. This change allows users not familiar with Ad Manager to be able to [[FAQ and General Info#Moving Around the Software\|move around the software]] in a more intuitive manner. This environment also allows users to open multiple windows and flip back and forth between different areas of the software quickly and efficiently. Information can be retrieved from the Shortcuts Bar or the Folders List with the click of the mouse button.
−	The software has also been completely integrated with this latest release. All components of the software (Inventory Management, Advanced Mapping, Maintenance, Multimedia and Financial modules) are now available through the one common interface. This allows users to see all aspects of their operations in one place. Different functions have now been bundled together to help our users operate more efficiently. The basic package, for example, now comes with basic mapping capabilities. Depending on which components you have purchased, different portions of each screen will be accessible to you. Our eAd Manager functionality also allows you to extend this power to the Internet and service your organization and your clients better.
−
−	~~=== New Features ===~~
−
−	The biggest change in the software is the structure of contracts. Contracts have 3 components; a contract level, a sub-contract level and a flights level. Each level tracks different information and allows you greater control over your charting.
−	Other new features include the ability to assign faces to networks and sell them in this manner. Virtual faces allow you to sell the same face as different media types without having to disable the other face definition. A new lighting tracking screen has been added to provide complete information on your lighting controls.
−	~~Ad Manager designs have now been set up to include a overlay database. This is where location or time specific copy can be stored and added to designs accordingly.~~
−
−
−	~~=== Improved Features ===~~
−
−	~~Dates in the system are now displayed based on how you have set up your operating system.~~
−	~~Ad Manager now allows you to keep multiple records for permits and inactive dates for sites, and multiple agencies and sales people can be assigned to a contract.~~
−	~~Contracts can now be defined as Proposals, Dead Proposals, Limited Holds (with an expiry date), Unlimited Holds, and Contracted.~~
−	The charting component has been revised and expanded to allow you greater control over how the charting is to be completed. The system also allows a "Dry Run" option to see what faces meet your criteria before selecting them.
−	~~Skewing has been modified to allow you to specify which skewing conditions MUST be met, and which are desirable.~~
−	~~The user security has also been modified to give greater control over access to different areas of the software.~~

@@ Line 108: / Line 108: @@
 The feature sheet of what is included in the upgrade can also be downloaded from here as well.
-Place the ChartPro installer in a share folder on the server.
+Place the Ad Manager installer in a share folder on the server.
 Make sure no users are in the database.
@@ Line 128: / Line 128: @@
 The database is now ready to use.
-Double-click on the Chartpro.msi file and install the new version of the software on the server.
+Double-click on the AdMgr.msi file and install the new version of the software on the server.
 Launch Ad Manager on the server to test connectivity.

@@ Line 68: / Line 68: @@
 Periodically, the license for Ad Manager will require updating. When this occurs, Dot2Dot will issue and send a new license for your company. Once this license file has been received, it should be saved on a common area of the network where all users that use Ad Manager will have access to.
-To update your license, the user on each machine will need to go Ad Manager.  Make sure you are not in the middle of doing something else as the license update procedures will log you out of Ad Manager as soon as the license is updated.  Go to TOOLS - LICENSE - UPDATE LICENSE and select the file provided.  You will receive a confirmation that you've updated the license and be logged out immediately.  If you are notified that the license file is invalid or does not match, re-import the corresponding dongle file by going to TOOLS - LICENSE - UPDATE SERIAL NUMBER and select the dongle file.  You will be logged out of Ad Manager and, when you log back in, repeat the process to import the license file.  If you continue to have trouble, please contact the Dot2Dot support team.
+To update your license, the user on each machine will need to go Ad Manager.  Make sure you are not in the middle of doing something else as the license update procedures will log you out of Ad Manager as soon as the license is updated.  Go to TOOLS - LICENSE - UPDATE LICENSE and select the file provided.  You will receive a confirmation that you've updated the license and be logged out immediately.
 When you log back in again, you will have the new license. If you wish to confirm the new license settings, go to HELP-ABOUT.

@@ Line 68: / Line 68: @@
 Periodically, the license for Ad Manager will require updating. When this occurs, Dot2Dot will issue and send a new license for your company. Once this license file has been received, it should be saved on a common area of the network where all users that use Ad Manager will have access to.
-Each Ad Manager user will need to log into the Ad Manager installation on their machine and click on Tools-License-Update. Ad Manager will prompt the user to select the location of the new license file. The user will find the appropriate file in the appropriate directory and highlight it. Once the file has been selected, click Open to update the file.
+To update your license, the user on each machine will need to go Ad Manager.  Make sure you are not in the middle of doing something else as the license update procedures will log you out of Ad Manager as soon as the license is updated.  Go to Tools - License - Update License and select the file provided.  You will receive a confirmation that you've updated the license and be logged out immediately.  If you are notified that the license file is invalid or does not match, re-import the corresponding dongle file by going to Tools - License - Update Serial Number and select the dongle file.  You will be logged out of Ad Manager and, when you log back in, repeat the process to import the license file.  If you continue to have trouble, please contact the Dot2Dot support team.
-Ad Manager will close.  Launch Ad Manager again and go to Help-About to make sure the correct license is now in place.
+When you log back in again, you will have the new license. If you wish to confirm the new license settings, go to Help-About.
 == Providing and Restricting Access ==

@@ Line 19: / Line 19: @@
 Backup tapes are cheap. Missed deadlines and redoing work may not be.
-Backup programs can be purchased off the shelf, or you can use the backup routines already in use on your network server. We would also recommend that you test the backup program by backing up data and trying to retrieve it. If your backup program does not work properly, it is best to find out before you really need to use it.
+Backup software can be purchased off the shelf, or you can use the backup routines already in use on your network server. We would also recommend that you test the backup software by backing up data and trying to retrieve it. If your backup software does not work properly, it is best to find out before you really need to use it.
@@ Line 26: / Line 26: @@
 Ad Manager for Windows, Release 2000
-The most obvious change for users of the Ad Manager Suite of Products is the appearance of the software. Ad Manager has now been designed to mimic the appearance of Microsoft Outlook, a standard in many workplaces. This change allows users not familiar with Ad Manager to be able to [[FAQ and General Info#Moving Around the Software|move around the software]] in a more intuitive manner. This environment also allows users to open multiple windows and flip back and forth between different areas of the program quickly and efficiently. Information can be retrieved from the Shortcuts Bar or the Folders List with the click of the mouse button.
+The most obvious change for users of the Ad Manager Suite of Products is the appearance of the software. Ad Manager has now been designed to mimic the appearance of Microsoft Outlook, a standard in many workplaces. This change allows users not familiar with Ad Manager to be able to [[FAQ and General Info#Moving Around the Software|move around the software]] in a more intuitive manner. This environment also allows users to open multiple windows and flip back and forth between different areas of the software quickly and efficiently. Information can be retrieved from the Shortcuts Bar or the Folders List with the click of the mouse button.
 The software has also been completely integrated with this latest release. All components of the software (Inventory Management, Advanced Mapping, Maintenance, Multimedia and Financial modules) are now available through the one common interface. This allows users to see all aspects of their operations in one place. Different functions have now been bundled together to help our users operate more efficiently. The basic package, for example, now comes with basic mapping capabilities. Depending on which components you have purchased, different portions of each screen will be accessible to you. Our eAd Manager functionality also allows you to extend this power to the Internet and service your organization and your clients better.
@@ Line 113: / Line 113: @@
 Install the new version of Ad Manager on the server.
-Launch the DatabaseMaker utility located in the Ad Manager Tools Program directory.
+Launch the DatabaseMaker utility located in the Ad Manager Tools Software directory.
 A wizard will take you through the various steps of upgrading. Be sure to use a login account that has SQL administrator privileges and is a user of the database. The most common reason for the upgrade failing is incorrect credentials.
@@ Line 123: / Line 123: @@
 The database is now ready to use.
-Double-click on the Chartpro.msi file and install the new version of the program on the server.
+Double-click on the Chartpro.msi file and install the new version of the software on the server.
 Launch Ad Manager on the server to test connectivity.
@@ Line 197: / Line 197: @@
 == Why Security ==
-Ad Manager allows its users to set up user names and passwords to control access to the program. This is a very valuable and important feature for several reasons.
+Ad Manager allows its users to set up user names and passwords to control access to the software. This is a very valuable and important feature for several reasons.
-By setting up user names, you can ensure that only authorized staff have access to the program and its powerful features.
+By setting up user names, you can ensure that only authorized staff have access to the software and its powerful features.
-Each user may have different areas of responsibility. You may want to limit staff to be able to access only those areas of the program that they require. Restricting access to other portions of the software can aid in ensuring only those people responsible for a function have access to it.
+Each user may have different areas of responsibility. You may want to limit staff to be able to access only those areas of the software that they require. Restricting access to other portions of the software can aid in ensuring only those people responsible for a function have access to it.
 Each user will have their own "work environment". Users may prefer seeing information in a particular sort order, or filter their information to only see certain structures or contracts. Each user may also have a preferred printer they want to print to.
 Each user can set up predefined views. These views can be public (seen by all users), or private (available only to them)
 If a user makes changes to the scheduling of a contract, or if they schedule a face to a contract that may cause problems (e.g. line of sight issues, restricted from that location or not available during that time frame), the software will record which user made these changes. This allows you to follow an electronic paper trail, and follow up with the appropriate person as to why this change was made.
 As you can see, Ad Manager's security feature allows you greater control over your working environment, ensuring a more efficient and successful use of our software.