Create SQL Database based off text documents in a folder

Closed - This job posting has been filled.

Job Description

I have a folder with many text documents.I need a way to automatically import these into a SQL database schema. The schema will need to be created off the following sample Data. (This is ONE text document in the folder) There will be more text documents and updated text documents each day. The data needs to automatically refresh. The next part of the job will be creating a visual representation of the data as part of a visual desktop or web application with the primary filter as the player name. For instance where it says "Seat 1:Tavelik (8.50)" This means the player name is Tavelik and he has 8.5 chips. I then need to track every action each player makes and record this in different tables of the database.

Sample data is:

Text Doc. Name: Table1

Hand #8635462-329 - 2013-09-08 20:05:17
Game: NL Hold'em (10 - 50) - Blinds 0.25/0.50
Site: Seals With Clubs
Table: NLHE 9max .25/.5 #3
Seat 1: Tavelik (8.50)
Seat 2: shuckyduckyq (48.16)
Seat 4: dragomiloff (42.71)
Seat 5: UncleGravy (87.76)
Seat 6: CiscoMonte (48) - sitting out
Seat 7: jonincgi (8.97)
Seat 8: ka11ink (54.30)
Seat 9: mshyamalan (16.27)
UncleGravy has the dealer button
jonincgi posts small blind 0.25
ka11ink posts big blind 0.50
** Hole Cards **
mshyamalan folds
Tavelik calls 0.50
shuckyduckyq folds
dragomiloff folds
UncleGravy folds
jonincgi calls 0.25
ka11ink checks
** Flop ** [4c 9s 5d]
jonincgi checks
ka11ink bets 2
Tavelik folds
jonincgi folds
ka11ink refunded 2
ka11ink wins Pot (1.47)
Rake (0.03)



Hand #8635505-330 - 2013-09-08 20:06:26
Game: NL Hold'em (10 - 50) - Blinds 0.25/0.50
Site: Seals With Clubs
Table: NLHE 9max .25/.5 #3
Seat 1: Tavelik (8)
Seat 2: shuckyduckyq (48.16)
Seat 3: EarlyCuyler (72.04) - waiting for big blind
Seat 4: dragomiloff (42.71)
Seat 5: UncleGravy (87.76)
Seat 6: CiscoMonte (48) - sitting out
Seat 7: jonincgi (8.47)
Seat 8: ka11ink (55.27)
Seat 9: mshyamalan (16.27)
jonincgi has the dealer button
ka11ink posts small blind 0.25
mshyamalan posts big blind 0.50
** Hole Cards **
Tavelik calls 0.50
shuckyduckyq folds
dragomiloff calls 0.50
UncleGravy folds
jonincgi folds
ka11ink calls 0.25
mshyamalan checks
** Flop ** [Ts 4s Js]
ka11ink checks
mshyamalan checks
Tavelik bets 7.50 (All-in)
dragomiloff folds
ka11ink folds
mshyamalan folds
Tavelik refunded 7.50
Tavelik wins Pot (1.95)
Rake (0.05)

Text Doc: Table 2

Hand #8635790-213 - 2013-09-08 20:12:43
Game: NL Hold'em (200 - 1000) - Blinds 5/10
Site: Seals With Clubs
Table: NLHE 9max 5/10 #1
Seat 1: phoen1x (4384.67)
Seat 5: Sharktarded (2119.13)
Seat 8: GUILTY (1000)
Seat 9: chronicdog (1524.63)
chronicdog has the dealer button
phoen1x posts small blind 5
Sharktarded posts big blind 10
** Hole Cards **
GUILTY folds
chronicdog raises to 25
phoen1x folds
Sharktarded folds
chronicdog refunded 15
chronicdog wins Pot (25)
Rake (0)



Hand #8635817-214 - 2013-09-08 20:13:21
Game: NL Hold'em (200 - 1000) - Blinds 5/10
Site: Seals With Clubs
Table: NLHE 9max 5/10 #1
Seat 1: phoen1x (4379.67)
Seat 5: Sharktarded (2109.13)
Seat 7: umm_call (1000) - waiting for big blind
Seat 8: GUILTY (1000)
Seat 9: chronicdog (1539.63)
phoen1x has the dealer button
Sharktarded posts small blind 5
umm_call posts big blind 10
** Hole Cards **
GUILTY raises to 30
chronicdog folds
phoen1x calls 30
Sharktarded folds
umm_call folds
umm_call adds 10 chips
** Flop ** [9s 6s Ks]
GUILTY checks
phoen1x bets 45
GUILTY calls 45
** Turn ** [9h]
GUILTY checks
phoen1x bets 100
GUILTY calls 100
** River ** [Jh]
GUILTY checks
phoen1x bets 275
GUILTY folds
phoen1x refunded 275
GUILTY adds 175 chips
phoen1x wins Pot (355.88)
Rake (9.12)