Return to Program Updates.txt CVS log

Up to [Development] / p2rx-programs

Directions to implement

CVS Folder --> P2Rx-Programs-Admin
	Files that are updated --> add1b.cfm,
				addNewOrg.cfm,
				delete.cfm,
				dummyOrganization.cfm,
				KeepCurrentDate.cfm (NEW)
				lists.cfm
				ProgramsDBUpdate.cfm (NEW to make necessary changed in our programs database)

CVS Folder --> P2Rx-Programs
	Files that are updated --> act_finalprocess.cfm
				application.cfm
				dsp_editcontact.cfm
				
				dsp_addservices.cfm
				act_addProgramTypes.cfm
				act_addServices.cfm
				dsp_addprogramtypes.cfm
				dsp_editservices.cfm
				dsp_deitProgramTypes.cfm
				dsp_editOrganization.cfm
				dsp_addOrganization.cfm
				dsp_addnewContact.cfm

DIRECTION (NOTE: IF YOU NEED HELP IMPLEMENTING ALL THESE FEEL FREE TO CALL ME BECAUSE SO MANY CHANGES ARE MADE)

1. Update  "p2rx-programs-admin" and "p2rx-programs" directory from CVS 
2. Retrieve ProgramDBUpdates.cfm from "p2rx-programs-admin" directory on CVS 
3.Retrieve Programs Database from your server. We will need to delete the dummy tables we created previously. I would definetly make a backup of those tables before you proceed to the next step.
4.Please put back the database in the server.
5.Visit that file via web browser
6.Click on link ensuring all steps have completed successfully
7.Open Programs Database
8.Open dOrganization in design view, change the following columns' "Allow Zero Length" property to 'Yes' - 

Division
Address2
Phone
Extension
HotLine
FaxNumber
EmailName
GraphicURL
Progress
Times

9.Highlight the "UpdateStatus" field. In the Properties Box, place a zero (0) in the "Default Value" field
10.Click Save
11.Change dOrganization to Datasheet View, find "UpdateStatus" field and place a zero there for all the records
12.Open dContacts in design view, change all of the columns' "Allow Zero Length" property to 'Yes'


Once you replace all the above listed files, everything should work like how we all want it.