UC

Secure Messaging Systems

This department works with a lot of other agencies and organizations. Sensitive information is often sent to and received from them. In order to avoid any phishing emails, we have documented a list of messaging systems we are familiar with and have used in the past. You can review the systems on the dedicated page on Secure Messaging Systems.

Update member data in Access

Currently the UC Access (ucnew.accdb) program generates reports using member data pulled from iMIS. Prior to 2017, it was pulled in via Excel spreadsheets. Later on we were able to connect directly to the SQL server and pull the data in real-time. But in 2023 with the move to iMIS EMS, we no longer have direct access to the SQL server any more and need to revert back to importing the data manually. There are two main steps involved: one is to export the data from iMIS and the other is to import it into Access.

Export the member data

1. Log into iMIS https://myaccount.boroughs.org/staff
2. Go to PSAB → Custom IQA → UC
3. Open the IQA named PSAB Name Address Export
4. Export the results as a CSV, this option is located in the Export drop-down in the upper right
   
5. Save the exported CSV as O:\uc\dbo_Name_Address_Export.csv

Note: Steps 5, 8, and 11 assume your browser is asking you where to save the exported file to. If your browser does NOT ask you, then just click on the folder icon from the download drop-down to open directly to where the file was saved.

Then manually rename the file and move it to the O:\uc folder accordingly. You will need to overwrite the existing files that may already be there.

6. Next open the IQA named PSAB Name Export
7. Export the results as a CSV
8. Save the exported CSV as O:\uc\dbo_Name_Export.csv
9. Next open the IQA named PSAB Programs Export
10. Export the results as a CSV
11. Save the exported CSV as O:\uc\dbo_PSAB_Programs_Export.csv

Import the member data

Once the CSVs have been re-exported/updated we can import them into the UC Access program.

1. Open O:\uc\ucnew.accdb
2. Login with your user as usual
3. Click on the Update Client Info button, this will run a script to pull in the data from the CSVs

Update UC rates in iMIS

While the UC rates are accessible and editable in iMIS, there is no simple way to edit them in bulk using the interface. So what this process does is export the data as a CSV. Allow you to edit in bulk, then re-import that data back into iMIS.

Export member rates data

1. Log into iMIS https://myaccount.boroughs.org/staff
2. Go to PSAB → Custom IQA → UC → UC Rates Export
3. Export the results as a CSV, this option is located in the Export drop-down in the upper right
   Note: We use CSV as iMIS exports XLSX kinda funny, but either should work.
4. Make your bulk edits to the document

Import member rates data

This part should be handled by IT but documenting the process here none-the-less.

1. Re-save the now edited CSV as an XLSX (if not already an XLSX)
2. Log into iDIMS https://us.cloud.csiinc.com/
3. Go to iImport
4. Upload the XLSX file, make sure the Spreadsheet is selecting the correct worksheet. It should show 6 columns available.
5. Click on Update in the Select an Action area.
6. On the Select Mappings screen, click on Load mappings, then select UCRateImport and click the Select button.
7. Click on Submit in the Submit Task area to run the task.

Troubleshooting Access

Hide confirmation notices on each step of the scripts

Remove Security Risk warning

Mount/Unmount Encrypted Drives

The UC uses encrypted drives located on the shared NAS (Network Attached Storage). Since they are encrypted, they must be manually unlocked before they can be accessed. This is separate from having the NAS turned on. Once unlocked, you will be able to access the data, and when done (as necessary) you can lock them again.

1. Log into the UC NAS at https://192.168.1.225 using your *_admin credentials which should be in your Passwords.xlsx.
2. Navigate to Control Panel -> Shared Folder

3. Select the Share you would like to mount, and under the Encryption drop-down, select Mount
4. It will ask for the encryption key for that share, enter it here and click OK

5. Once mounted, you will now be able to access the corresponding drive on your computer. For example, if you unlocked “KDrive”, you will now be able to access the K: drive on your computer.
6. To unmount/lock the drive, just return to the Shared Folder screen. Then select the drive you want to lock, and under the Encryption drop-down, select Unmount. It will ask if you are sure, click on Yes