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. On this page, I'll show you how to extract SB-RIPA version data to DOJ XML files.

To export use RIPAExport:
RipaExport
  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:
RipaExport
RipaExport
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 will build it

Great software isn't cheap to make. I don't just develop software. I find solutions to your business needs.
AboutContact