Creating a new program for reports

Reference: https://linear.app/citydataservices/issue/CIT-2525/%5Bmil%5D-milpitas-action-items-public-services-fy24-set-up-monitoring

FY 24-25 Billing Summary Sheet (1).xlsx

Source code needed for this process: gencsnoapp.pl

For this example, we will be looking at City of Milpitas.

---

1. Verify Program in phpMyAdmin

• Open phpMyAdmin and navigate to the database Milpa, then go to the table progs.

  

• Locate the URL for the program to find the progs number (referred to as prop).
  • Example: If the URL shows the program number as 9, this is the progs number.

• Search the progs table by program and enter the number 9 to verify the program exists.

• If the program does not exist, you need to create the program first before generating any reports.

2. Create Program if it Does Not Exist

• Sort the data by id in descending order so that the newest entries are shown at the top.

• Identify the next available program number.

• Duplicate the newest program entry.
  • When duplicating, make sure to set the following:
    • name
    • program number
    • fyr
    • program number inside rpttext
    • name inside rpttext

• Verify the newly created program appears on the page.

Now that we have the newly created program, we can now start generating reports if needed.