RTF Document Parsing and conversion to TIFF

We are looking to have a standalone executable program written.

I believe we would prefer it to be written in C#

The purpose of the program is to parse a multi-page RTF document into several smaller documents, convert the individual documents to RTF, TIFF and

TXT formats and save them into specified folders.

It will also update a MySQL database with data related to the location of the documents.

The target computer is a Windows 7 Pro 64bit OS

This computer is running MySQL version 5.6.17

When executed, the software will do the following

- provide the user of the program with a list of documents to process

- provide the user with buttons for "Setup", "Process" and "Cancel"

- make several queries to MySQL to obtain various parameters

- if there are RTF documents in a specified folder, it will

>> parse them into individual documents by looking for a string that represents the start of a new section

>> convert the individual documents to TIFF format

>> convert the individual documents to TXT format

>> convert the individual documents to RTF format

>> save these documents in the specified folder

>> update an sql table related to the documents

>> display a process complete message to the user

The parameters for the program will be in an .ini file located in the same folder as the application

[database]

server = valleyoccmed

username = emruser

password = password

database = emr

[file path]

source = c:\Transcription Processor

[workstation]

site = 12

******************************************************

Parsing the RTF document and extracting necessary data

******************************************************

Each occurence of a line within the original document that contains "VISIT DATE:" and "CHART#:" will indicate the start of a new sub-document

"VISIT DATE:" may also be "Visit Date:"

"CHART#:" may also be "Chart#:"

Each sub-document is usually one page, but may be two or three

If more than one page, the TIF file created is to be a single multi-page TIF file

Additionally, within each sub-document there may or may not be a "Date of Injury:" or "D/A:"

These three values must be extracted from each document to insert into the database record later

ChartNumber is a six digit numeric string left padded with zeros (ex: 001234)

VisitDate will be a date string formatted YYYY-MM-DD (Ex: 2014-10-09)

DateofInjury will be a date string formatted YYYY-MM-DD (Ex: 2014-10-09)

*******************************

Obtaining the document filename

*******************************

The individual documents will be renamed using the following rules

LocationNumber

- SELECT Location from System -> LocationNumber

- this is a two character string left padded with zeros

- ex: for Location=1, LocationNumber="01"

NextDocumentNumber

- This is the create table for "NewDocument"

CREATE TABLE `newdocument` (`DocID` int(4) unsigned NOT NULL auto_increment, PRIMARY KEY (`DocID`)) ;

- To obtain the next document id

- INSERT INTO NewDocument SET docid=null

- the resulting docid is the basis for the next document number

- it will be an eight character numeric string left padded with zeros

- ex: for docid=767802, NextDocumentNumber="00767802"

FileName

- FileName=[login to view URL]

- ex: using LocationNumber and NextDocumentNumber above, FileName="0100767802"

****************************

Saving the Documents

****************************

The saved documents will be in 'chart folders'

All chart numbers are six digits long

Chart numbers relate to folder locations as follows

Given: chart number = 123456

The folder for saving the documents is <DataPath>\charts\12XXXX\1234XX\123456

NOTE: if the target folder does not exist, it is to be created

DataPath is obtained from SELECT DataPath FROM SiteData WHERE SiteID=site

NOTE: "site" is from the ini file

In this example DataPath="r:"

<see attached file for more info>

C# Programming MySQL Software Development

Project ID: #6572739

About the project