![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif){kind=logo}
FORMS II Lite Documents and Technical Information
FORMS II Lite Menu
- Documents and Technical Information
- Frequent Questions
- Software Download and Updates
- Training
You will need Adobe Reader to view some of the files on this page. See EPA's PDF page to learn more.
This page contains information about the Field Operations and Records Management System (FORMS) II Lite software.
Overview and General Use Documents
The following documents are available for those looking for general FORMS II Lite information, features, and usage guidance.
- FORMS II Lite 5.1 User Guide (PDF) (71pp, 4.3 MB)
- FORMS II Lite 5.1 Release Notes (PDF) (1p, 21K)
- FORMS II Lite 5.1 Feature Sheet (PDF) (1p, 18K)
Developer Reference Documents
DTDs for Laboratory and Regional Electronic Traffic Report/Chain-of-Custody (TR/COC) Form
There are separate DTDs for the Regional and laboratory XML exports. XML files reference DTDs that specify the expected data and format. The FORMS II Lite software DTDs referenced in the XML files are on the Internet and cannot be checked unless you are online. To work around this, open the XML file in Notepad and delete the first line of the XML file that starts with "DOCTYPE..."
Note that DTDs can either accompany an XML document or the XML can reference the location of the DTD on the Internet.
- F2Lab51 DTD (.dtd, 3KB)
- F2REG51 DTD (.dtd, 4KB)
Entity Relationship Diagram (ERD)
This ERD, generated by ERwin, represents the relationships between tables in the latest version of the FORMS II Lite software database.
Field Definitions
These definitions document the fields in the database.
- FORMS II Lite Field Values (PDF) (10 pp, 230KB)
XML Tools
There are many tools for manipulating and editing XML data. Two examples are provided below. EPA does not endorse any particular product or software.
XML Spy
There are two easy ways to retrieve the data from an XML file if you do not have the capability built into the database product you are using. One is to use XML Spy's Convert feature that translates the XML file into text files or into a MS Access table. The other is to use various parsing tools available on the Internet, such as Import Export Studio, which is listed below.
Etasoft Extreme Translator
This tool assists in importing or exporting data to and from databases. Business rules can be defined as maps and used to import data (e.g., XML, EDI, etc.), read data from a file, parse it and insert into database or export data, read data from SQL queries, and create an output file. This is one tool that can help you to take the FORMS II Lite software XML file, map it to your database, and then import the FORMS II Lite data.