Extending the Platform FAQ
No. You may not rename database tables, fields or stored procedures that are part of the core MinistryPlatform schema that came with your system or has been updated by ACS Technologies. Renaming custom fields you added or custom tables and pages is allowed but should be done carefully as any views, reports, or tools built against those original objects will break.
Never delete items in System Lookup pages. Renaming them is generally not wise as it makes this Help Center less useful to your church. Adding values is generally acceptable, but there are certain system lookup pages like Contact Status and Group Role Types where this would be a huge liability to your church's use of the existing reports and tools. Consequently, always ask before adding values to system lookups. It is expected and natural that your church would rename or add values to the pages under "Lookup Values".
This is unwise and should be avoided for all pages that came with MinistryPlatform. It would be better to leave that page alone and create a filtered page (a copy of that page with a value in the Filter Clause). Changing the internal name of a page will not update reports and other hard-coded applications. Where possible and requested by our churches, we will give the church the ability to rename a value like "Congregation" on the external, public facing applications like the Portal.
You can do this, but it is unwise as it makes your system inconsistent with this Help Center. Doing this for your custom reports and tools is acceptable.
Always add a filter clause to your copy of the page. Having two unfiltered pages results in ambiguity for tools that dynamically draw the database using foreign key information from SQL Server and Page information in MinistryPlatform. Make sure people who will create advanced searches retain sufficient rights to the original, unfiltered page.
No, if you make changes to our RDL file or to an underlying stored procedure then a future upgrade of that report may overwrite your changes. Instead, copy the RDL file and deploy it with a different name so that you will have "forked" or "cloned" the report and taken your copy of it out of the upgrade path.
Yes, first go to the page in the Platform that you want to add a field to the default field list on. Use the Advanced Search tool to grab the field you want to add. Then switch to the SQL view and copy the Field List SQL code. Then go to the Set-Up section of MinistryPlatform. Go to the Pages page, open the page record you want to update. It is always best practice to copy what is there and paste it into another document before you edit the field list in case something is wrong you can easily revert. Edit the page and add the SQL code to the field list in the appropriate place. Ensure to add a comma in the appropriate place. Click Save. Go to the page you edited and switch to the default view to ensure that you can open the page without any errors.
Yes and no. If the field is required, the field labels are presented as a question to be answered as a yes or no, and the default is always negative.
For tri-state (nullable) bit field, the default is undefined, but this can be changed in the database. In this case, the default value does not appear initially, but when the record is saved and displayed, the value is changed to the default.
No, we would not recommend importing anything directly to database tables. That would not create all the needed records and linkages. If the people are already in MinistryPlatform, then you can add people en masse to Groups, by using the Add button. However, if they are not in MinistryPlatform yet, then currently there is not a way to add new people en masse. The fastest way to manually add people is to use the Add/Edit Family Tool. Another option is to use the Group Finder on the Portal. You can direct everyone to sign up for Groups on the Portal. By doing so, they are added to the Group, and if new, are added to the Platform.
Yes, you can create a read-only page in the Platform from a database view. Examples include the Giving Unit Summary and User Rights & Restrictions.
In this case, the Auto Date still works because it is a trigger on the table.
Yes, you can change the friendly name for drop-down menus. Go to Selected Record Expression field. In this example, you'd change the Selected Record Expression from the default Rooms.Room_Name to the appropriate Rooms.Room_Number + " - " + Rooms.Room_Name.
, open the Page, and change theThis is most likely just the system needing time to update/recognize this new page. To move it along, we need to help MP know that something changed. A go-to method for this is to edit the Addresses page in MinistryPlatform reloads/re-reads all the MetaData from SQL.
and simply modify the description. Once you save any changes in the Pages section,Sometimes the system needs to track information in a field that does not need to be seen on the front-end, typically to help when processing, notifying, and so on. The underscore at the beginning of the field hides the field from users, making the field hidden and valuable, which allows the system to run smoothly.
Technically, yes, it is possible to change a field length. For example, a Notes field could be changed from nvarchar(500) to nvarchar(2000). It's not advisable to go over 2,000 due to the tax it puts on the server. Consult Support if you're uncertain whether changing a field length is a good idea.
Yes, you can combine two fields into one in a view by adding SQL to the Field List. The SQL which would need to be added to the Field List depends on which table or page the view is on. Contact Support if you need assistance.
The metadata you're looking for can be found in these two tables: dp_Sequences and dp_Sequence_Records. If you need help writing an SQL statement, we can do that as a Professional Service.
Creating a sandbox and testing changes there is absolutely necessary. While you can technically write changes directly into a Production system, it is very unwise to do so. Also, problems created by changes to your database - especially outside a sandbox - will incur a fee for corrective action.
Yes, setting up your own jobs is fine. That said, we do not recommend editing MinistryPlatform-created jobs.
This field is deprecated and is no longer in use by the system.
Yes. In general, this is supported in the Platform. There may be limitations on what may be accomplished using this approach which can be determined by testing in the database or Platform.