Welcome, Guest
If you're using San Diego RIPA (SD-RIPA) or San Bernardino RIPA (SB-RIPA) version the database doesn't store data as DOJ format. Data extraction or conversion to DOJ format required. SB-RIPA web app is based on SD-RIPA first released version with many features added, this version doesn't have DOJ submission tool with error correction capability. I created RIPAExport to export RIPA data to DOJ XML files. On this page, I'll show you how to extract SB-RIPA version data to DOJ XML files.

To export use RIPAExport: (not available to public, contact me)
  1. Edit the connection string that connects to RIPA web application.
  2. Modify the start date and end date
  3. Enter the ORI, for the test XML files I use test ORI (check with DOJ for test ORI). I only use real ORI when it comes to production.
  4. "Save to Path" is location where you want to store your XML files.
  5. Click "Export to XMLs" to save XML files.
Once exported, you will see something like this:
All the export files have a TX_Type = I, which stands for "Insert". This means these files will be added to the database as new record. If DOJ rejects your XML files, after you corrected the XML files, the status must be changed to "U" which stands for "Update" for correction.

You describe it, I build it

Great software is not cheap to make.
Quick Services
• Convert HTML to PDF