Area9 Code Updates

With the lack of details from how this was previously put together the following is a series of code and processes to upload new codes to a Area9 product. 

Unlike Vital Source area9 products require access codes to be uploaded into Aptify.  The following was performed for a ticket to add codes to a new product.  

First step is to determine the product ID for the new product.  Then upload the list of codes into a temp table on Aptify.  In this case I called it _tempCodes. Which just has one field named code for the Access codes.  Then I simply run the following Insert statement to create the new codes:

/****** Script for SelectTopNRows command from SSMS  ******/

SELECT TOP (1000) [ID]

      ,[AccessCode]

      ,[AccessCodeTypeID]

      ,[ProductID]

      ,[AccessCodeURL]

      ,[AccessCodeUsageTypeID]

      ,[AccessCodeRestrictionTypeID]

      ,[Status]

      ,[AvailableOn]

      ,[AvailableUntil]

      ,[NotifyAfterAvailableOnDateOnly]

  FROM [APTIFY].[dbo].[AccessCode__ahima]

  where AccessCodeTypeID=7

  Insert into AccessCode__ahima (AccessCode,[AccessCodeTypeID],[ProductID],[AccessCodeURL],[AccessCodeUsageTypeID],[AccessCodeRestrictionTypeID]

      ,[Status],[AvailableOn],[NotifyAfterAvailableOnDateOnly])

  Select Code,

  7, 66657, 'https://curator.rhapsode.com/learner.html?s=GVFMzM2XwUTOwIzXnlWcYZUVwMzYnlWc', 1, NULL, 'Available', '2022-01-22',1 From _TempCodes

After running this upload the codes should be available provided the product was set-up correctly.