Computer program for storing electronic files and associated attachments in a single searchable database

• US 7,293,006 B2
• Filed: 04/07/2004
• Issued: 11/06/2007
• Est. Priority Date: 04/07/2004
• Status: Expired due to Fees

• Current Assignee: Integrated Project Solutions LLC
• Original Assignee: Integrated Project Solutions LLC
• Inventors: Beckius, Bruce E., Devito, Robert J.
• Primary Examiner(s): Alam; Hosain
• Assistant Examiner(s): LIN, SHEW FEN
• Application Number:
  US10/819,643
• Publication Number:
  US 20050234843A1
• Time in Patent Office: 1,308 Days
• Field of Search: 707 1- 10, 707100-102, 709/206
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/107 Computer-aided management of electronic mailing [e-mailing]
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A program of storing electronic files in a searchable database includes opening an electronic file having a body of text data. The file'"'"'s body is stored in a body text file in a memory of a computer system. An attachment associated with the electronic file is opened. Text data of the attachment is stored in an attachment text file of the computer system. The body text file is imported into a body text file field of a first database record of a searchable database. The attachment text file is imported into an attachment text file field of a second database record of the searchable database.

Claims

1. A computer program for storing e-mail files and associated attachments in a searchable database stored on a computer readable medium of a computer system having a memory for executing the program, the program comprising:

opening an e-mail file having metadata and a body of text data;

storing selected e-mail metadata in a memory of a computer system;

storing the e-mail'"'"'s body in a body text file in the memory of the computer system;

storing a body pathname indicative of the location of the body text file in the memory of the computer system;

opening at least one attachment associated with the e-mail;

storing the at least one attachment metadata in the memory of the computer system;

storing text data of the at least one attachment in an attachment text file in the memory of the computer system;

storing a pathname of the at least one attachment, said pathname being indicative of the location of the attachment text file in the memory of the computer system;

writing the selected e-mail metadata, and the body pathname to a predetermined set of fields of a first record of comma delimited file;

writing the at least one attachment metadata and the at least one attachment pathname to a predetermined set of fields of a second logically sequential record of the comma delimited file;

importing the e-mail metadata and body pathname from the comma delimited fields stored in the first record of the comma delimited file into a first record of a searchable database;

importing the at least one attachment metadata and attachment pathname from the comma delimited fields stored in the second record of the comma delimited file into a second logically sequential record of a searchable database;

reading the field in the first database record containing the body pathname as a source pointer to the location of the body text file in the memory of the computer system;

importing the body text file from the memory of the computer system into the first database record of the searchable database;

reading the field in the second database record containing the attachment pathname as a source pointer to the location of the attachment text file in the memory of the computer system;

importing the attachment text file from the memory of the computer system into the second database record of the searchable database;

storing in the searchable database a plurality of attachment text files representing a plurality of attachments associated with the e-mail, the attachment text files being stored in successive records which are in logical sequential order relative to the first record containing the body text file of the e-mail, the first record and the successive records comprising a document file with a plurality of pages of text data;

assigning a unique sequentially increasing alpha numeric value to each page of text data of the document file;

assigning each record of the document file a common BD value and ED value equal to the first and last alpha numeric values of the document file respectively; and

assigning each record of the document file a unique BR value and ER value equal to the first and last alpha numeric values of the first and last pages of each record respectively.

2. The program of claim 1 comprising:

creating a bit mapped image of the e-mail after the e-mail'"'"'s body has been stored in the body text file;

checking the body text file for errors after the creation of the bit mapped image of the e-mail;

deleting all data stored in the computer system associated with the e-mail, including the body text file and bit mapped image of the e-mail, if an error is detected.

3. The program of claim 2 comprising:

creating a bit mapped image of the at least one attachment after the attachment text data has been stored in the attachment text file

checking the attachment text file for errors after creation of the bit mapped image of the at least one attachment;

deleting all data stored in the computer system associated with the at least one attachment and the e-mail, including the attachment text file, the body text file and the bit mapped images of the at least one attachment and e-mail, if an error is detected.

4. The program of claim 3 wherein the bit mapped images of the at least one attachment and e-mail are TIFF files.

5. The program of claim 1 comprising:

storing the at least one attachment in its original format in an original attachment folder in the memory of the computer system;

storing an original attachment pathname indicative of the location of the original attachment folder in the memory of the computer system;

writing the original attachment pathname to a field of the second logically sequential record of the comma delimited file;

importing the original attachment pathname from the comma delimited field stored in the second record of the comma delimited file into a field of the second logically sequential record of the searchable database; and

constructing a hyperlink from the database to the original attachment folder from the original attachment pathname stored in the database.

6. The program of claim 1 wherein the program includes a first program and a second program interfaced to enable the storage of the e-mail and associated attachments in the database.

7. A computer system comprising:

an executable memory; and

a computer program stored in the executable memory, the computer program for storing e-mail files and associated attachments in a searchable database, the program including;

opening an e-mail file having metadata and a body of text data;

storing selected e-mail metadata in a memory of a computer system;

storing the e-mail'"'"'s body in a body text file in the memory of the computer system;

storing a body pathname indicative of the location of the body text file in the memory of the computer system;

opening at least one attachment associated with the e-mail;

storing the at least one attachment metadata in the memory of the computer system;

storing text data of the at least one attachment in an attachment text file in the memory of the computer system;

storing a pathname of the at least one attachment, said pathname being indicative of the location of the attachment text file in the memory of the computer system;

writing the selected e-mail metadata, and the body pathname to a predetermined set of fields of a first record of a comma delimited file;

writing the at least one attachment metadata and the at least one attachment pathname to a predetermined set of fields of a second logically sequential record of the comma delimited file;

importing the e-mail metadata and body pathname from the comma delimited fields stored in the first record of the comma delimited file into a first record of a searchable database;

importing the at least one attachment metadata and attachment pathname from the comma delimited fields stored in the second record of the comma delimited file into a second logically sequential record of a searchable database;

reading the field in the first database record containing the body pathname as a source pointer to the location of the body text file in the memory of the computer system;

importing the body text file from the memory of the computer system into the first database record of the searchable database;

reading the field in the second database record containing the attachment pathname as a source pointer to the location of the attachment text file in the memory of the computer system;

importing the attachment text file from the memory of the computer system into the second database record of the searchable database;

storing in the searchable database a plurality of attachment text files representing a plurality of attachments associated with the e-mail, the attachment text files being stored in successive records which are in logical sequential order relative to the first record containing the body text file of the e-mail, the first record and the successive records comprising a document file with a plurality of pages of text data;

assigning a unique sequentially increasing alpha numeric value to each page of text data of the document file;

assigning each record of the document file a common BD value and ED value equal to the first and last alpha numeric values of the document file respectively; and

assigning each record of the document file a unique BR value and ER value equal to the first and last alpha numeric values of the first and last pages of each record respectively.

8. The computer system of claim 7 wherein the program further comprises:

creating a bit mapped image of the e-mail after the e-mail'"'"'s body has been stored in the body text file;

checking the body text file for errors after the creation of the bit mapped image of the e-mail;

deleting all data stored in the computer system associated with the e-mail, including the body text file and bit mapped image of the e-mail, if an error is detected.

9. The computer system of claim 8 wherein the program further comprises:

creating a bit mapped image of the at least one attachment after the attachment text data has been stored in the attachment text file

checking the attachment text file for errors after creation of the bit mapped image of the at least one attachment;

deleting all data stored in the computer system associated with the at least one attachment and the e-mail, including the attachment text file, the body text file and the bit mapped images of the at least one attachment and e-mail, if an error is detected.

10. The computer system of claim 9 wherein the bit mapped images of the at least one attachment and e-mail are TIFF files.

11. The computer system of claim 7 wherein the program includes a first program and a second program interfaced to enable the storage of the e-mail and associated attachments in the database.