Training Partner – Rollback to previous version

The following is not recommended in a production environment.  Please test thoroughly if using in a production  as there are some macro differences between TP versions.

Training Partner stamps your database with the TP Admin client version to ensure the database and the version of the client are in sync. This is important since there can be incompatibilities between TP versions and the database schema.

Sometimes, the database and the TP Admin client get out of sync, either by accident or through testing another version of TP against the database. It is always recommended that you test different version of TP against copies of your database to avoid this issue.

Need to Reset Database Version Only

If you have already have the TP files installed, you simply need to reset the database version number as below:

  1. Find your TP Admin client version by going to Help menu and click About Training Partner.
  2. Your version number is actually both your Version and Build numbers. In the example below, your version number will be 2007.1.1.809
    About Training Partner
  3. Open up Microsoft SQL Server Management Server or Query Analyzer
  4. Connect to your TP database


SET NAME=’2007.1.1.809′


Rolling back to a previous version of TP is not hard if you have all the pieces:

  • TP executable
    Depending on your version of TP: TrainingPartner.exe or TP2005.exe
  • TP License file
    Depending on your version of TP: TPLicense.dll or TP2005License.dll
Posted in Training Partner | Tagged , | Leave a comment

Training Partner–PayFlow Pro .NET

Training Partner Build 1012 now supports PayFlow Pro .NET. Which is a great thing since the older COM version has been depreciated for quite some time now.

How do you know if your Training Partner build supports PayFlow Pro .Net?

Open the Tools/Options menu and go to the Act. Options tab. If you see Payflow .NET checkbox greyed out, you have support.


If you have Payflow Installed checked off you will need to uninstall the COM version of Payflow Pro. I will include instructions at the end.

The install is not too hard if you can find all the pieces. This is where things get tricky.

First, make sure .NET Framework is installed. It must be greater than 2. Windows Update is the easiest way to accomplish this.

These instructions were tested on 3.5 .NET Framework.

Next download the Payflow Pro .NET SDK . This is the confusing part, the link to Payflow Pro .NET SDK that is on the PayPal site is not pointing to the latest version which is v4.33. v4.31 does not have all the files you require to install Payflow Pro .Net and have TP recognize it properly.

  1. Download: (2.7 MB)
  2. Install Payflow_dotNET_Setup.msi by following the prompts.
  3. Open the Payflow SDK for .NET folder that was placed on your desktop during the install.
  4. Rename Payflow_dotNET_2.0.dll to Payflow_dotNET.dll
  5. Rename Payflow_dotNET_2.0.tlb to Payflow_dotNET.tlb
  6. Copy Payflow_dotNET.dll and Payflow_dotNET.tlb to C:\WINDOWS\SYSTEM32
  7. Register the Payflow_dotNET.dll. From the Command line:“C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\regasm” C:\WINDOWS\SYSTEM32\Payflow_dotNET.dll

  8. Another trick one here. You need to register Payflow_dotNET to the Global Assembly cache using gacutil.exe. The problem is that gacutil.exe is no longer distributed with the .NET framework.
    1. You need to find it on another workstation with v1.1 or v2 of .NET. Which I did.
    2. Another option is to download the .NET Framework 2.0 Software Development Kit (SDK) and install it. I have not tested this option.
  9. Once you have gacutil.exe execute the following at the command line:“C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\gacutil” /if C:\WINDOWS\SYSTEM32\Payflow_dotNET.dll


  10. Login to Training Partner as an Administrator and go to Tools/Options menu. Click the Act. Options tab.Options_After_Install
  11. The Payflow Installed and Payflow .NET should now be checked and you will be able to enter in your PayPal information. It is recommended you use a test account to confirm the installation.
    Posted in LMS, Training Partner | Tagged , , | 1 Comment

    Training Partner Online–Secure Page Setup

    Like most eCommerce systems, Training Partner Online requires Secure Socket Layers (SSL, also called HTTPS) to be setup. Depend on your version of Internet Information Server (IIS), you will need to set it up differently.

    If you do not have a valid SSL certificate, below are some reference links to create Self-Signed SSL Certificates and installing them for testing only:

    Once your have enabled SSL on your IIS server, test it by going to:


    Replace servername with the hostname of your IIS server with Training Partner Online installed.

    The above assumes you have a default install of Training Partner Online and the Online pages. Please replace with your relevant page name and TPOnline folder.

    If you used a self-signed SSL certificate, you will get the following warning in your IE browser:


    This is why self-signed certificates are for testing or internal use only.

    Click “Continue to this website (not recommended)” since we know it is our own certificates.

    Due to Training Partner Online using full qualified references rather than relative for all links, you will get the following warning message whether you use a self-signed certificate or a valid one:


    If you click Yes to the above Security Warning, you will notice that some images on the page will not be shown due to them not being delivered with SSL as is the case below:


    Once the SSL has been installed and tested, a new folder in the TPOnline folder needs to be created. This is normally located in C:\TPOnline for a default Training Partner Online install.

    Create a folder called SSL in C:\TPOnline and copy the TPOnline.dll from C:\TPOnline into it.


    You will now have two copies of TPOnline.dll.

    Tip: Remember on any upgrades of TPOnline to copy TPOnline.dll into the SSL folder.

    For IIS 6.0, the last step to enable SSL for Training Partner Online is to add the TPOnline.dll in the C:\TPOnline\SSL folder as an Web Service Extension.


    If you do not do this step, you will get a 404 file not found when you attempt to test it at:


    I have not tested IIS 7.0/7.5 for ISAPI and CGI Restrictions which is the equivalent to the above.

    You should see the same messages as when you did the original test with the exception of the certificates warning because you already agreed to continue to the site.

    Training Partner Online is ready for SSL.

    Posted in LMS, Training Partner Online | Tagged , , , , | Leave a comment

    Training Partner Online – Save Online Pages

    The Training Partner Online web pages are actually stored in the Training Partner database. The Online Designer allows you to add, update and delete those pages.

    It also allows you to save a copy to a folder and upload it into another copy of Training Partner Online. Very handy for us developers.

    To save a copy of your Training Partner Online web pages:

    1. Open the Online Designer
    2. Click on the disk save icon which is the second icon from the left.


    3. Save the file on your hard drive. Usually, the Save As dialog box will open in the C:\Training Partner – Server\Macros folder.


      In the above example, the file name will be TP-Pages.tpi in the C:\Training Partner – Server\Macros folder

    4. You will see the progress of the save. It can take up to 5 minutes to save a site depending on the size.


      The resulting file can be as much as 6 megs.

    5. Look for TP-Pages.tpi in the C:\Training Partner – Server\Macros folder

      Since the file is text, it will compress very well if you need to email it.

    6. DONE!
    Posted in LMS, Training Partner Online | Tagged , | Leave a comment

    Training Partner Online – Portal Access

    Training Partner Online allows you to create different portals for different user audiences. Part of the configuration of a portal is what your users will have access to.

    Access is controlled by folder of the following inventories:

    • Courses
    • Facilities
    • Equipment
    • Instructors
    • Reports
    • Programs
    • Materials
    • Vendors
    • Skills
    • Job Roles
    • Learning Groups
    • Remote Sites

    Unless a particular folder is exposed through the Portal Properties a user will not be able to access it.

    How to Give Access to a Folder

    The following walkthrough applies to any of the inventories listed above.

    In this example, we will be using a Course Folder. We wish to give online users access to all courses in the Office folder and all subfolder in the Office tree. Below is the sample folder structure:


    1. Open the Training Partner Online Designer
    2. Click on the portal icon. Circled in red below.TrainingPartnerOnlineDesigner
    3. This will give you access to the Portal SettingsPortalSettings
    4. Using the Portal dropdown, select the portal you wish to update. In this example, we will be using the Default portal.
    5. Right click the Default portal dropdown and select PropertiesPortalSettingsMenu
    6. The Portal Properties will open. Click on the Access tabPortalPropertiesAccess

      From here, you may update access for any of the inventories. Just click on the inventory you wish to update. We will be updating the Courses inventory that is already selected for us.

    7. To allow access to the Office folder, we must expand the Microsoft folder.MicrosoftFolderExpanded

      You will note that all folders are greyed out indicating no access for the online user.

    8. It is important that you first select folder you wish to update before right clicking for the menu. Left click on the Office folder to select it.
    9. Right click on the Office folder and select Allow Access then Child Folders to give access to all subfolder.OutlookFolderAccessChildFolders
    10. Expand the Office to see that the Office folder and all its children are not greyed out anymore.OutlookFolderAccessGranted

      Online users will now have access to any course in the  Office, Access, Excel, Outlook and Word folders.

    11. Click OK to access the change.

    Important Note

    Granting and denying access to different inventories assumes that you have not customized Training Partner Online. It is very easy to disable this feature.

    Please contact a Training Partner consultant to review your code if you have any concerns.

    Posted in LMS, Training Partner Online | Tagged , | Leave a comment

    Training Partner Online – Import SCORM Course

    There are a few tricks to get a SCORM course properly loaded and configured to ensure the student’s enrolment is completed when the course is completed.

    Actually, they are not really tricks but strict adherence to the SCORM standards. Some LMS implementations let your cheat when producing a SCORM course so it is critical that you test the SCORM course on your LMS platform because passing the SCORM Test Suite or running on another LMS does not guarantee it will work on Training Partner Online or another LMS.

    Loading the SCORM Course

    1. Copy the course into your elearning folder.
      This folder must on a server with the same domain name as Training Partner Online, this is usually the same server that Training Partner Online is installed on.


    2. I recommend that you next test to see if you can reach the course through a web browser without going through the LMS. Make sure you use the TP Online domain name.
      In the example above, I would type: http://localhost/elearn/scormlesson/index.htm into Internet Explorer or Firefox. Save this URL in NotePad, you will need it later.scormtestlaunch

      Don’t worry if you get an error message that the LMS API is not available, you are not launching through the LMS. You are looking for 404, page not found errors.

    3. If the course launches with no page not found errors, proceed to load the course into Training Partner. Otherwise, contact your system admin to help you configure your web server properly to launch the course.
    4. Launch the Training Partner Admin client and log in as an Administrator.
    5. Go to the File/Import menu and select SCORM 1.2/2004 Content Package from the radio buttons.FileImportSCORM
    6. Click the Data Source tab
    7. Click the Select File button and browse to where your SCORM course is located. You are looking for the imsmanifest.xml file to load into Training Partner.FileImportSCORMFile

      Please note that your web server where your elearning course are stored may be on a different server than the TP admin client. Contact your system admin for the proper path to the elearning folder. In this example, they are on the same server.

    8. Click the Open button and you will be prompted to Enter Base URL for the course. Remember above where you tested the course before and saved the URL? Copy and paste it into the Base URL textbox and remove everything after the last slash.SCORMBaseURL
    9. Click OK. You should see a success message for the import.SCORMImportSuccess

      Note that the import course name must be unique within the TP course catalog or you will get an error message that there is a duplicate course.

    10. Close the Import – SCORM 1.2 dialog and open the SCORM Imported Courses course folder. You should see your imported course.SCORMImportedCourses

      Note that if you already have the SCORM Imported Courses folder open, you will need to click into another course folder and back to refresh the contents.

    11. You have successfully imported a SCORM course. Now to configure it.

    Configure the SCORM Course

    1. Open the course properties in SCORM Imported Courses folder. In this example, it is called Saltwater Crocodiles.
    2. Click on the Units tabCourseUnitTab

      Note, depending on the course, you may see more than one unit. This example is dealing with only a single unit.

    3. Double click the unit to see the Unit Properties.SCORMUnitProperties
    4. Confirm the Max Score and Weight. The max score is not a percentage but that actual score the student will get when completing the unit.
    5. For Training Partner to set an enrolment to Completed when a SCORM course is completed, a score must be passed back to the LMS.

      It is critical that the Pass Score be filled in.
      If you just want the student to pass the course when they have reach the last page, have the course developer send a score of 1 at the last page. Below is an example if the configuration:


    6. Click OK to go back to the Course Properties.
    7. Unlike the Unit, the Pass Score is a percentage.It is critical that the Pass Score be filled in plus the Max Credits.

      In this example, since a 1 is being sent on the last page of the course, the Pass Score would be 100% and the Max Credits is 1.


    8. Click OK button.
    9. Your course is ready to test!
    10. In the example used here, when the last page of the course is reached, the student will get a score of 1 out of 1 and the enrolment will show completed.SCORMCompleted
    Posted in LMS, Training Partner | Tagged , , | Leave a comment

    Training Partner Online – Language Tags

    Language tags can be a blessing and a curse. If you are using a single language, it sometimes be labour intensive to update them and you probably don’t see the point of them but for multi-lingual sites, they are a must have.

    How do you know you have a problem?

    You will see something like the following when you bring up a TP Online page:


    To breakdown the “error” message above:

    • Tag = language tag
    • Public_Course_Options_End: CBT Anonymous = missing tag
    • Not Found = error message

    The one issue that I have with the above message is that it does not tell you which language the tag is missing from. The above error is actual from the French language. You have to know which language you or the user is in.

    To update a language tag, open the Online Designer

    1. Click the Language Tags button on the toolbar. Circled in red below:
    2. You will see the Language Tags dialog box. Select the Page dropdown and select [All Tags]

    3. Copy and paste the missing tag into the Tag: field and press Enter.
      In the example above, it would be:
             Public_Course_Options_End: CBT Anonymous
      Note that any trailing spacing should be removed.
    4. If the tag exists, it will bring you to the entry otherwise, it will create a new entry.
      Public_Course_Options_End_CBT Anonymous
    5. Click in the English Translation column that lines up with the missing tag and enter the text.

      Public_Course_Options_End_CBT Anonymous-E

    6. To enter in another language, just change the Language dropdown to language to French for example.
    7. You will see the English text and you may entry the French in the French Translation column.

      Public_Course_Options_End_CBT Anonymous-F

    8. Remember to stop and start the TP Online Service
    9. The Language Tag is now live


    Posted in LMS, Training Partner Online | Tagged , | Leave a comment

    Training Partner – How to Bill to a Student

    Training Partner billing is dependent on how the Address Formats are setup.

    By default, TP comes with three Address Formats:

    1. Billing Address


    2. Mailing Address


    3. Standard Address


    Any of the above addresses can be used for invoicing purposes. As can be seen above, the Billing Address is set as the default billing address. This means when an Organization is created the Bill To: will be defaulted to Billing Address, therefore there must be a Billing Organization defined in the organization tree.


    So in the example below, if Rod Fage is attached to the OSG Consulting Inc. organization, orders created on enrollments for Rod would be billed to OSG – Accounts Receivable.


    The above scenario allows for the ability to attach students to different organizations for reporting and communication purposes and still have a centralized billing address. This is a big benefit if you are dealing with large corporations or government agencies.

    What if you need to bill the student directly, on their personal credit card and send the invoice to them?

    An additional Address Format is required.

    1. Go to Tools/Options menu
    2. Click on the Addresses tab
    3. Right click in the grid and select New Address Format
    4. Give is a Name like Bill Student
    5. Change the Bill To: Personal
    6. The Format may stay the same. It will use the student’s address information on the invoice.

    To use Bill Student:

    1. Create an enrollment as usual
    2. Click on the Bill tab
    3. Select Bill Student in the Bill To: dropdown list
    4. Create the order as usual. You will notice that the Client is Fage, Rod (student’s name) rather than the organizations name.
    5. Click OK

    If you open the invoice, you will see that the address has been take from the student rather than the organization as well.

    Posted in LMS, Training Partner | Tagged , , | Leave a comment

    Training Partner – Version Numbers

    Those experienced in Training Partner know that the TP Admin Client and the TP database must be in sync.

    If the TP Admin Client has a version number higher than the database then the user login in to the client will be prompted to update the database.

    Training Partner Upgrade Dialog

    Make sure all installations of the TP Admin client and Training Partner Online are upgraded at the same time or you may face the situation below.

    If the TP Admin Client version is lower than the database version, the user will get an error message like the one below prompting the user to upgrade their version of the Admin Client.


    Below, I outline how to find the version numbers for both the Admin and database.

    Training Partner Admin Version

    To find the Training Partner Admin version number, look in the Help menu and click the About Training Partner… option.


    If someone is asking for your TP version, they want both the Version and Build below.


    In the above example, the version number is 2008.1.1.912.

    TP Database Version

    The database version number is stored in the ITEMS table.

    Run the SQL script below:


    The version number is stored in the NAME field.

    In the example below, the database version is 2008.1.1.912.


    On a side note, the UID of the the version number in the database is stored in the ITEM_NO column and is ITEM1999112517382603929944. I have not seen it change in the last 7 years but I use the ITEMTYPE and ITEMKEY fields in the query above, just in case it does.

    Posted in LMS, Training Partner | Tagged , | Leave a comment

    Training Partner – Invoice Print

    A Training Partner invoice has a Print button. The question is, what report is associated with that button?


    The documentation is not clear. Look for the report name “Invoices (Individual)” in your report folders.

    To find the report:

    1. Open your Reports inventory windows
    2. Click in the field beside the word Search:
    3. Type “Invoices (Individual)” without the quotesInvoices (Individual)
    4. Press the Enter key to jump to the report.
    5. If there is more than one “Invoices (Individual)”, you want the one that only has ““Invoices (Individual)” as its name.

    If the report does not exist, you can add the report:

    1. Open your Reports inventory windows
    2. Find a report, you wish to base the new report on and click it.
      It is important that you left click on the base report first before right clicking.
    3. Then right click the existing report, select New/New Report/New Quick Report (assuming you wish to format your invoice) Adding Invoices (Individual)
    4. You will be presented with a blank report to customize with the existing report’s data already populated expect for the General tab
    5. Type “Invoices (Individual)” without the quotes in the Name field.BlankReportProperties

    Alternatively, you can rename the original “Invoices (Individual)” and create a new report as above.

    Posted in LMS, Training Partner | Tagged , | Leave a comment