Case data worksheet
This Excel sheet serves as a data input tool for eProsecutor Online, designed to streamline the process of converting data into a structured format compatible with the Self Service Data Conversion. The sheet includes macros to automate the addition of headers and columns, ensuring data consistency and ease of integration with eProsecutor Online.
All fields denoted with an asterisk (*) at the end of the field are required to be uploaded for an item or case to be uploaded to eProsecutor Online.
|
The case data worksheet comes ready with a Case header and all the fields required to build a case with nothing else on it. For an explanation of the fields see Case Data Fields.
Other items may be placed on a case using macros or buttons inside the Excel sheet.
Click the buttons to append whatever is needed, or navigate to the Automate tab at the top of the Excel ribbon and select individual macros inside the scripts tab.
The following scripts allow you to add all the following:
| As mentioned on the Self service data conversion landing page some entities are required to be added before others. Example: A charge is associated with the party that is directly left of it, and a charge enhancement is associated with the charge that is left of it. If charges are out of order, it may be uploaded incorrectly to the eProsecutor Online instance. |