Hi All,
Well I've gone ahead and designed my new database to replace my old 'purchased' one (which had limited functionality).
The database is in MySQl with the front end in PHP.
I can read reports and data from my database HOWEVER,
I have not yet designed the system of inputting the data.
I have not done this before so need some help
The DATA comes from 4 laboratory machines. All with different interfaces. All connected to its own PC.
1: (LNF)
Exports to text file. Either :
ICAS (14 MED files, handshaking) OR
TEXT (1 comma deliminated file, data appended) -> Currently used by old system.
Once the sample has been completed the Lab equipment software automatically sends the data to the export.txt file. It then clears this file. Example below.
<code>
Unknown,Unknown,Unknown,09/11/2003,5,163,09/11/2003,15:41,3.89,0.00,00068,OILSTAR,,,43009060.00,3386551.75,197061.75,66698.56,36937.04,2232.41,78.33,125.22,5.44,1.67,>28,24,>28,>28,24,12,6,-,36147028.00,10280917.00,25888.06,23127020.00,276034.84,72690.22,21736.57,12846.12,548.31,0.00,54.02,7079.20,1637.37,0.00,0.00,41.26,23.60,3.74,7368.15,1878.15,195.82,0.00,68.98,24.74,8.18,14832.61,14062.08,1292.44,78.33,125.22,29.14,11.66,37514.93,19118.65,587.47,0.00,95.66,25.34,6.47
</code>
FTIR
Exports to a text file, however in this case, as each sample is generated, a new text file is generated and named after the sample number. eg. 101.txt, 102.txt etc.
Spectroil M, and 4. Viscometer.
These programs communicate with their PC's via their com ports (9 pin). In the
current system, there is a listener on the PC that listens to the com ports, once the sample is complete and the data sent from the machine, the listener
automatically sticks it into the Database.
So please point me in the right direction.
How to get data from text files and com ports to insert into my database.
I know - Visual Basic, PHP, HTML, Javascript.
regards
Andrew
