RTF Document Parsing and conversion to TIFF
$250-750 USD
Paid on delivery
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>
Project ID: #6572739
About the project
8 freelancers are bidding on average $640 for this job
I am an expert in willing to discuss further about the project details and deliver the same to your needs
Hi, I am expert in processing text based files. You project requirement is very much descriptive, so I dont have any question. I will be looking forward to hearing from you. Thanks
Hi, I am interested to work with this requirement. I will delivery an exe using c# and .net. please consider my bid and let me start with the job.300
Hello, Hello I am C# expert and interested in this project. If needed I can do it in Java, you will be able to use it later on mac/linux if needed. I have reviewed your requirements for Splitting and Convertin More
Hi, I have 8+ years of experience to work with most reputed MNC IT Company. My jobs includes analysis, design, develop, implementation and enhanced customized application modify existing applications to meet user ch More