| | |
Need Help Creating Program which reads text files
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Jun 2009
Posts: 1
Reputation:
Solved Threads: 0
Hi guys,
I'm a complete newbie here and to VB.net in general. My friend for his company has written a program to tell if machines within his workplace are actually doing anything. The results from this are then shown in a text file, which I will show a small part of now:
Server to Check : AC01VS007c
Date Stamp : 26/06/2009
Time Stamp : 08:15
SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql
--------------------------------------------------------------------------------------------------------
Name
------------------------------
CES Manager 3.08.012
Name
------------------------------
SIS Translator 20.2.1
Name
------------------------------
Name
------------------------------
Name
------------------------------
CDS 22.1 WHO TR3
TODAYS DECLARATIONS
Number of Meetings
------------------
19
Number of BTG_OPTYS
-------------------
199
ODEC MESSAGES RECEIVED
Meetings
-----------
19
Events
-----------
195
--------------------------------------------------------------------------------------------------------
Server to Check : AC01VS014a
Date Stamp : 26/06/2009
Time Stamp : 08:15
SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql
--------------------------------------------------------------------------------------------------------
Name
------------------------------
CES Manager 3.11.006
Central System 20.0.3.0
Name
------------------------------
SIS Translator 20.2.1.2
Name
------------------------------
PA Translator 22.0.5.0
Warning: Null value is eliminated by an aggregate or other SET operation.
Name
------------------------------
Name
------------------------------
CDS 22.1 WHO TR3
TODAYS DECLARATIONS
Number of Meetings
------------------
0
Number of BTG_OPTYS
-------------------
0
ODEC MESSAGES RECEIVED
Meetings
-----------
0
Events
-----------
0
--------------------------------------------------------------------------------------------------------
Server to Check : AS02VS035S
Date Stamp : 26/06/2009
Time Stamp : 08:15
SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql
--------------------------------------------------------------------------------------------------------
Name
------------------------------
The problem with this is that it is very hard to read and takes unecessary time scrolling through to find whether it is working or not. If the meetings and events add up to 0 then obviously the machine isn't working.
What he has assigned me to do is put this information into a form which is simple and easy to read. I have successfully created a DataGridView which shows the Name of Machine, Status, Date Stamp and Time Stamp. However, this is only reproduced by entering the data manually into the source code eg.
[DataGridView1.Rows.Item(n).Cells(4).Value = "26/6/2009"
DataGridView1.Rows.Item(n).Cells(5).Value = "08:15"]
for Date and Time Stamps.
So what I'm trying to do is be able to change the program so it can search the text file for the machine name, add up all of the events and meetings for that machine and store it as an integer which can be updated straight to the DataGridView, and do the same for the Date Stamp and time Stamp. I hope all of this makes sense and I would really appreciate your help because I don't have a clue of where to start.
I'm a complete newbie here and to VB.net in general. My friend for his company has written a program to tell if machines within his workplace are actually doing anything. The results from this are then shown in a text file, which I will show a small part of now:
Server to Check : AC01VS007c
Date Stamp : 26/06/2009
Time Stamp : 08:15
SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql
--------------------------------------------------------------------------------------------------------
Name
------------------------------
CES Manager 3.08.012
Name
------------------------------
SIS Translator 20.2.1
Name
------------------------------
Name
------------------------------
Name
------------------------------
CDS 22.1 WHO TR3
TODAYS DECLARATIONS
Number of Meetings
------------------
19
Number of BTG_OPTYS
-------------------
199
ODEC MESSAGES RECEIVED
Meetings
-----------
19
Events
-----------
195
--------------------------------------------------------------------------------------------------------
Server to Check : AC01VS014a
Date Stamp : 26/06/2009
Time Stamp : 08:15
SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql
--------------------------------------------------------------------------------------------------------
Name
------------------------------
CES Manager 3.11.006
Central System 20.0.3.0
Name
------------------------------
SIS Translator 20.2.1.2
Name
------------------------------
PA Translator 22.0.5.0
Warning: Null value is eliminated by an aggregate or other SET operation.
Name
------------------------------
Name
------------------------------
CDS 22.1 WHO TR3
TODAYS DECLARATIONS
Number of Meetings
------------------
0
Number of BTG_OPTYS
-------------------
0
ODEC MESSAGES RECEIVED
Meetings
-----------
0
Events
-----------
0
--------------------------------------------------------------------------------------------------------
Server to Check : AS02VS035S
Date Stamp : 26/06/2009
Time Stamp : 08:15
SQL Script Used : C:\Support\ServerChecks\Opp_SQL_Script.sql
--------------------------------------------------------------------------------------------------------
Name
------------------------------
The problem with this is that it is very hard to read and takes unecessary time scrolling through to find whether it is working or not. If the meetings and events add up to 0 then obviously the machine isn't working.
What he has assigned me to do is put this information into a form which is simple and easy to read. I have successfully created a DataGridView which shows the Name of Machine, Status, Date Stamp and Time Stamp. However, this is only reproduced by entering the data manually into the source code eg.
[DataGridView1.Rows.Item(n).Cells(4).Value = "26/6/2009"
DataGridView1.Rows.Item(n).Cells(5).Value = "08:15"]
for Date and Time Stamps.
So what I'm trying to do is be able to change the program so it can search the text file for the machine name, add up all of the events and meetings for that machine and store it as an integer which can be updated straight to the DataGridView, and do the same for the Date Stamp and time Stamp. I hope all of this makes sense and I would really appreciate your help because I don't have a clue of where to start.
![]() |
Similar Threads
- Analysing text files to obtain statistics on their content Using Perl (Perl)
- Program to search text files in a folder (Java)
- binary search tree question (Java)
- reading and writing java text files (Java)
- Analysing text files to obtain statistics on their content (Perl)
- Help! Concatenating Text Files (C++)
- Making arrays from text files (VB.NET)
- Need help Writing a code which reads text files. (C++)
Other Threads in the VB.NET Forum
- Previous Thread: ocr sdk
- Next Thread: inheritance in vb
| Thread Tools | Search this Thread |
Tag cloud for VB.NET
"crystal .net .net2005 30minutes 2005 2008 access application arithmetic array basic binary bing button buttons c# center check code combobox component connectionstring convert crystalreport data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dll dosconsolevb.net dropdownlist error excel file-dialog firewall folder ftp google hardcopy image images inline listview login math mobile ms navigate net networking opacity output peertopeervideostreaming picturebox picturebox1 plugin port print printing problem problemwithinstallation project reports" save savedialog searchbox serial server soap sorting sql string tcp text textbox timer toolbox trim updown upload usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web wpf






