Changes for page crm

Last modified by Kyle Hill on 2025/05/27 11:26
<
From version < 3.10 >
edited by Kyle Hill
on 2025/05/27 10:48
To version < 4.5
edited by Kyle Hill
on 2025/05/27 11:26
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -2,6 +2,8 @@
2 2  
3 3  * [[.NET 6 Hosting Bundle>>https://dotnet.microsoft.com/en-us/download/dotnet/6.0]]
4 4  
5 +(% class="wikigeneratedid" %)
6 +===== =====
5 5  
6 6  ===== **Ensure the following .NET Runtimes are installed:** =====
7 7  
... ... @@ -10,7 +10,7 @@
10 10  
11 11  ===== **Testing and Debugging:** =====
12 12  
13 -* Check the system event viewer for any errors. Framework related and logs appear here if not successfully written to the logs. This may point to folder permission issues.
15 +* Check the system event viewer for any errors. Framework and log related errors usually appear here if not successfully written to the actual log files. The cause might be folder permissions.
14 14  
15 15  ===== =====
16 16  
... ... @@ -37,78 +37,77 @@
37 37  ===== **Database Considerations:** =====
38 38  
39 39  * Some databases are setup to require a reference number when making structural changes to the database:
40 -** Create a session reference: (% style="color:#2980b9" %)//exec//(%%)// sp_set_session_context 'ReferenceNo', '123456789'//
42 +** Create a session reference: (% style="color:#2980b9" %)//exec//(%%)// sp_set_session_context 'ReferenceNo', '123456789'//
41 41  ** The reference number is the ticket number of the project, as found on our Issue log system.
42 -* Depending on the state of the database, there might be tables, procedures, views and even data that need to be added. Is a list of some of some these objects, that need to be present in the database for the CRM to work correctly (//Please feel free to added on//):
44 +* Depending on the state of the database, there might be tables, procedures, views and even data that need to be added. Is a list of some of these objects, that need to be present in the database for the CRM to work correctly (//Please feel free to added on//):
43 43  
44 -|=Object Type|=Name|=Dependencies
45 -|Procedure|api.sp_AddSupplier_Se|
46 -|Procedure|api.sp_BankAccountTypes_SelectV2|
47 -|Procedure|api.sp_Communication_Add|
48 -|Procedure|api.sp_Communication_AddProperty|
49 -|Procedure|api.sp_Content_Add|
50 -|Procedure|api.sp_Content_AddProperty|
51 -|Procedure|api.sp_CreateSupplier|
52 -|Procedure|api.sp_CRM_RegisterUser|
53 -|Procedure|api.sp_CRM_ResetPassword|
54 -|Procedure|api.sp_DocumentCategories_SelectV2|
55 -|Procedure|api.sp_Documents_SelectV2|
56 -|Procedure|api.sp_GetBBBEE_Levels|
57 -|Procedure|api.sp_GetPersonDetailsV2|
58 -|Procedure|api.sp_GetSupplierTypes|
59 -|Procedure|api.sp_GetUniversalBankBranch|
60 -|Procedure|api.sp_MemberBankDetails_SelectV2|
61 -|Procedure|api.sp_MemberBeneficiaries_SelectV2|
62 -|Procedure|api.sp_MemberClaimStatus_SelectV2|
63 -|Procedure|api.sp_MemberCouncilRates_SelectV2|
64 -|Procedure|api.sp_MemberNotes_InsertV2|
65 -|Procedure|api.sp_MemberNotes_SelectV2|
66 -|Procedure|api.sp_MemberNoteVariableGroups_SelectV2|
67 -|Procedure|api.sp_MemberNoteVariables_SelectV2|
68 -|Procedure|api.sp_MemberPayments_SelectV2|
69 -|Procedure|api.sp_MemberPaypoints_SelectV2|
70 -|Procedure|api.sp_MemberSalaries_SelectV2|
71 -|Procedure|api.sp_MemberSinglePremiums_SelectV2|
72 -|Procedure|api.sp_MemberTaxApplications_SelectV2|
73 -|Procedure|api.sp_People_SelectV2|
74 -|Procedure|api.sp_Scheduler_AddNote|
75 -|Procedure|api.sp_Scheduler_AddProperty|
76 -|Procedure|api.sp_Scheduler_CompleteActivity|
77 -|Procedure|api.sp_Scheduler_CreateProcess|
78 -|Procedure|api.sp_Scheduler_CurrentActivities|
79 -|Procedure|api.sp_Scheduler_GetActivityActions|
80 -|Procedure|api.sp_Scheduler_GetNotes|
81 -|Procedure|api.sp_Scheduler_GetProcessProperties|
82 -|Procedure|api.sp_SearchPersonDetails|
83 -|Procedure|api.sp_SearchPersonMembershipV2|
84 -|Procedure|api.sp_Workflow_AddNote|
85 -|Procedure|api.sp_Workflow_AddProperty|
86 -|Procedure|api.sp_Workflow_CompleteActivity|
87 -|Procedure|api.sp_Workflow_CreateProcess|
88 -|Procedure|api.sp_Workflow_GetActivityActions|
89 -|Procedure|api.sp_Workflow_GetLinkedContent|
90 -|Procedure|api.sp_Workflow_GetNotes|
91 -|Procedure|api.sp_Workflow_GetProcessProperties|
92 -|Procedure|api.sp_Workflow_LinkContent|
93 -|Procedure|api.sp_Workflow_Reallocate|
94 -|Procedure|api.sp_Workflow_SearchActivities|
95 -|Procedure|api.sp_Workflow_SearchProcess|
96 -|Procedure|api.sp_Workflow_SearchStreamResources|
97 -|Procedure|api.sp_Workflow_SearchStreams|
98 -|Procedure|api.sp_Workflow_UpdateProperty|
99 -|Procedure|dbo.sp_InsertImageToDocDatabase|
100 -|Procedure|dbo.sp_MaritalStatus|
101 -|Procedure|dbo.sp_SchedulerAddNote|
102 -|Procedure|dbo.sp_Update_frmPeople|
103 -|Procedure|dbo.sp_UserLevels|
104 -|Procedure|dbo.sp_WorkflowAddNote|
105 -|Procedure|prg.sp_ProviderParameters_select|
106 -|Procedure|scr.sp_BankBranches_Member|
107 -|Procedure|scr.sp_MFGMemberCFLO|
108 -|Procedure|scr.sp_MFGMemberPaypoints|
109 -|Procedure|scr.sp_Paypoints|
110 -|Procedure|web.sp_UserWebLogin|
46 +|=Object Type|=Name|=Latest Version|=Dependencies
47 +|Procedure|api.sp_AddSupplier_Se| |
48 +|Procedure|api.sp_BankAccountTypes_SelectV2| |
49 +|Procedure|api.sp_Communication_Add| |
50 +|Procedure|api.sp_Communication_AddProperty| |
51 +|Procedure|api.sp_Content_Add| |
52 +|Procedure|api.sp_Content_AddProperty| |
53 +|Procedure|api.sp_CreateSupplier| |
54 +|Procedure|api.sp_CRM_RegisterUser| |
55 +|Procedure|api.sp_CRM_ResetPassword| |
56 +|Procedure|api.sp_DocumentCategories_SelectV2| |
57 +|Procedure|api.sp_Documents_SelectV2| |
58 +|Procedure|api.sp_GetBBBEE_Levels| |
59 +|Procedure|api.sp_GetPersonDetailsV2| |
60 +|Procedure|api.sp_GetSupplierTypes| |
61 +|Procedure|api.sp_GetUniversalBankBranch| |
62 +|Procedure|api.sp_MemberBankDetails_SelectV2| |
63 +|Procedure|api.sp_MemberBeneficiaries_SelectV2| |
64 +|Procedure|api.sp_MemberClaimStatus_SelectV2| |
65 +|Procedure|api.sp_MemberCouncilRates_SelectV2| |
66 +|Procedure|api.sp_MemberNotes_InsertV2| |
67 +|Procedure|api.sp_MemberNotes_SelectV2| |
68 +|Procedure|api.sp_MemberNoteVariableGroups_SelectV2| |
69 +|Procedure|api.sp_MemberNoteVariables_SelectV2| |
70 +|Procedure|api.sp_MemberPayments_SelectV2| |
71 +|Procedure|api.sp_MemberPaypoints_SelectV2| |
72 +|Procedure|api.sp_MemberSalaries_SelectV2| |
73 +|Procedure|api.sp_MemberSinglePremiums_SelectV2| |
74 +|Procedure|api.sp_MemberTaxApplications_SelectV2| |
75 +|Procedure|api.sp_People_SelectV2| |
76 +|Procedure|api.sp_Scheduler_AddNote| |
77 +|Procedure|api.sp_Scheduler_AddProperty| |
78 +|Procedure|api.sp_Scheduler_CompleteActivity| |
79 +|Procedure|api.sp_Scheduler_CreateProcess| |
80 +|Procedure|api.sp_Scheduler_CurrentActivities| |
81 +|Procedure|api.sp_Scheduler_GetActivityActions| |
82 +|Procedure|api.sp_Scheduler_GetNotes| |
83 +|Procedure|api.sp_Scheduler_GetProcessProperties| |
84 +|Procedure|api.sp_SearchPersonDetails| |
85 +|Procedure|api.sp_SearchPersonMembershipV2| |
86 +|Procedure|api.sp_Workflow_AddNote| |
87 +|Procedure|api.sp_Workflow_AddProperty| |
88 +|Procedure|api.sp_Workflow_CompleteActivity| |
89 +|Procedure|api.sp_Workflow_CreateProcess| |
90 +|Procedure|api.sp_Workflow_GetActivityActions| |
91 +|Procedure|api.sp_Workflow_GetLinkedContent| |
92 +|Procedure|api.sp_Workflow_GetNotes| |
93 +|Procedure|api.sp_Workflow_GetProcessProperties| |
94 +|Procedure|api.sp_Workflow_LinkContent| |
95 +|Procedure|api.sp_Workflow_Reallocate| |
96 +|Procedure|api.sp_Workflow_SearchActivities| |
97 +|Procedure|api.sp_Workflow_SearchProcess| |
98 +|Procedure|api.sp_Workflow_SearchStreamResources| |
99 +|Procedure|api.sp_Workflow_SearchStreams| |
100 +|Procedure|api.sp_Workflow_UpdateProperty| |
101 +|Procedure|dbo.sp_InsertImageToDocDatabase| |
102 +|Procedure|dbo.sp_MaritalStatus| |
103 +|Procedure|dbo.sp_SchedulerAddNote| |
104 +|Procedure|dbo.sp_Update_frmPeople| |
105 +|Procedure|dbo.sp_UserLevels| |
106 +|Procedure|dbo.sp_WorkflowAddNote| |
107 +|Procedure|prg.sp_ProviderParameters_select| |
108 +|Procedure|scr.sp_BankBranches_Member| |
109 +|Procedure|scr.sp_MFGMemberCFLO| |
110 +|Procedure|scr.sp_MFGMemberPaypoints| |
111 +|Procedure|scr.sp_Paypoints| |
112 +|Procedure|web.sp_UserWebLogin| |
111 111  
112 112  
113 -
114 114  

Applications

Navigation

Need help?

If you need help with XWiki you can contact: