Read CSV And Save Values For Use?
Nov 17, 2009
I'm a "Moderate" skill programmer, and am upgrading some software I've written in VB.Net (VS2008, .Net 3.5), and need to be able to accomplish the following, which I'm not sure of the best way to go about doing: The software is an information reporting dashboard for a call centre. I have a csv file being created about every 10 seconds, extracted from the telephone software, the file consists of a list of "Skills" (basically telephone line types), the number of calls received on those lines, and the number of callers who hung up (and a few other bits of information I need, but once I figure the basics out, the rest should be easy), basically looking like the following:
[code]...
I need to be able to read this csv, store the data, filter out the "Skills" to be report on (i.e. 1,2, and 5 only), add up the "Offered" and "abandoned" data associated with them and then display this information as one number (i.e. "Skills 1,2,5 - Offered: 4925, Abandoned: 13") (and then the same for the other "Skills"). This data could grow as more phone lines are added or some are taken away.I've got the code to read the data into an array working, but I've got stuck with how to filter and add up the data. I'm not even sure if I can do this with an array.
View 10 Replies
ADVERTISEMENT
Sep 13, 2009
I need read csv file in this format each line (value1;value2;value3;value4) and save each value to separate variables.
View 2 Replies
Mar 23, 2009
I have a DEM file(Digital Elevattion Model File) and I am trying to open the file,where we have Latitude and Longitude values inside the DEM file.And, Now I have opened the file using Filestream and Read the file using BinaryReader.But, I am having a trobule in getting the values of Latitude and Longitude.I am getting Byte values randomly as 1,202,31,271 etc.But, we dont have latitude and longitude values more than 180,and also I am not getting 16 bit UInt values.For example, the values should be like Latitude 20.00416666666667 and Longitude 39.99583333333333.So,read the correct Byte values of the DEM file.The code I have used till now is:
Dim fs As FileStream = New FileStream("C:UsersadminDesktopHeader and DEM fileE020N40.DEM", FileMode.Open, FileAccess.Read)
Dim rd As New BinaryReader(fs)
Dim convertDB As UInt16
For i = 0 To rd.BaseStream.Length
[code]....
View 14 Replies
Jun 2, 2011
lets say I have a form (form1) with lables a-z which are all designed with default text "0". So they all show 0 on program startup. which is fine. I also have a dialog with 2 TextBoxes; I want my program to update the default text/value on (only)form1 labels x, y and z to whatever was put into the textboxes when i press the OK button on the Dialog, so these specified labels show the 'new' value on next startup. Is it even possible or should I save the values to a file which loads the values in the specified labels on startup?
View 5 Replies
Sep 21, 2011
I have a number of word documents I am converting. Everything is going great until I get a file that is read only. In this case I get a Save As prompt.
Is there any way to open the file in read/write format? I should have admin privileges so access isn't an issue.
I'm using VB.net to open the files. More specifically
doc = word.Documents.Open(path, Type.Missing, False, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing)
View 2 Replies
Nov 5, 2010
You need to read the values from an array. What Visual Basic flow construct would you need to use to perform that action? What are the important keywords to include in that construct?
View 6 Replies
Jul 22, 2011
Using VB.Net, I need to read the following XML from a string variable (not a file) and pull the AuthNo, Client ID, Client Name, Supplier ID, and Supplier Name for each Dispatch contained within the XML.
I have looked at tons of examples on the web using XMLReader but I can't figure out how to pull the separate ID's and match them up with their appropriate Names and also matched up with appropriate AuthNo.[code]...
View 7 Replies
Jun 10, 2011
I am working on a application where user enters his personal information (name, city...), so, should I, that is, should user save his data inside of the application, or should there be a data file where the information would be stored?
View 7 Replies
Jun 6, 2009
i have this code to save a rtf document as read only, but why is that when you re open it, it is not in the same format as when you saved it. like if the text was read and courier new p20, it comes out as the default font.
Private Sub readon_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles readon.Click
Dim sfd As New SaveFileDialog
[Code]....
View 8 Replies
Jan 27, 2011
I am working on a project that is essentially a task manager. It has some special features, but in essence, you put in tasks, and when you check them they move. I have got most of it done, but I need the ability to save separate lists.[code]...
View 2 Replies
Oct 7, 2011
I am using VS 2010 to make a web site and working on a page right now. After submitting my variables, I need to output the values as a pdf
View 1 Replies
Jul 19, 2010
I have some checkboxlist like this:
<asp:CheckBoxList ID="G1" runat="server">
<asp:ListItem Value="Comunicações Unificadas" Text="Comunicações Unificadas - UCoIP"></asp:ListItem>
[code].....
View 1 Replies
May 16, 2011
I have two radio buttons and several text boxes that need to be filled out.I need to be able to save the textbox values and the checked radio buttons when my Save All button is clicked. I also have to be able to open the saved file in the program and have all the saved values be displayed in the correct textboxes when I click the open button and search for the file. I am new to programming so I have no idea where to start this function...
View 6 Replies
Dec 16, 2009
Using VB.Net
Database Form
Server Name, Username, Password - textbox
SQL Authentication, windows Authentication - checkbox
I have Database Form, First Time i run my software, I have to give Server Name, Window or SQL Authentication mode, UserName and password. Next Time I run the software, given data's like Server name, username, password, window or sql authentication should appear in the form. Before I used VB6, I used the ini file for getting the username, password and servername.
vb6 code.
Dim File As String, OFLen As Double, str As String
File = App.Path & "SQLServer.ini"[code]....
There is any option is available in the vb.net for saving the data's or i have to use the same format(ini file) in vb.net
View 2 Replies
Apr 7, 2011
i have no time for design a database and all these things ,i have only one table and i have to fill the answers , i have to finish it within two days.the problem is I have more than 50 questions and i divided them into 3 groups , i putted each question group in User Control, and i am trying to save the values from each user control.
View 4 Replies
Jan 23, 2010
use values to output and save as pdf
View 4 Replies
Dec 17, 2010
I have an EXE that creates objects based on params passed to it.Say I have textboxes named 57 and 21.I want to read the values entered by the end user.
Var1=57.text
Var2=21.text
How do I pull this data from the boxes?
View 5 Replies
Mar 20, 2011
Within my service i have the following function in order to take some values from my registry[code]...
View 3 Replies
Mar 2, 2009
I'm new to VB.net and have only a few projects under my belt. This one has me stumped!! I need to open a file and search its contents hex byte by byte. (Similar to Hex editor). On finding a particular value I need to replace it with a set hex value then write and close the file. So far I have only managed to read / write the ascii equivilant.
View 4 Replies
Oct 12, 2010
On my form I have a textbox called TxtSelectedEvType. On the other hand, I have a listview called lvwBatchHist which has two columns, BatchID and EvType respectively.
Now, I want to read all the values in EvType column and compare with the value in TxtSelectedEvType.Text, if they are the same write a message EvType is the same else call a function...
i.e.,
if TxtSelectedEvType.Text = (comparing from the column 'EvType' in lvxBatchHist) Then
MsgBox ("EvType Same", MsgBoxStyle.Information, "Test")
[Code].....
View 18 Replies
Nov 24, 2010
What I want is to have the ability for the user once the values are entered into the Textboxes, the user has the ability to save the values for retrival a some later time. This is what I have so far
[Code]...
View 1 Replies
Apr 10, 2011
I am creating a windows service in .Net 4.0 and testing some functions of said service with a windows forms client by referencing the service project.The service project has an App.config file and that file looks like this: [code]a null reference error is thrown because my connection string is not loaded.The only connectionStrings that are loaded are from the machine.config file located in [code]If I create an application scope setting for the service, I can get that setting by using the My.Settings.setting so it's not like the App.config file is not being read.why are my connectionStrings not being loaded from the App.config file?When referencing a project(parent) from another project(child), the child's app.config is used even if the parent's classes are being used.Thus, I can get the connectionStrings to show up if I copy them over to the child's app.config. When trying to open it manually, my currentDirectory was of the child, not the parent (strange how it did not throw an exception - it wouldn't have been able to find the config file it just silently used the machine.config.
View 4 Replies
Apr 28, 2009
[code]i need to read data from specific cells and assign them to other cells.
View 4 Replies
Jun 10, 2011
I would like to read values set in a string that's retrieved from the Web, I've already got the string in a string called Webdata.The string is like so...
"Info" {
"Name" {
"Name1""Value1"
[code]....
I need to set Value1, Value2, Value3 as strings that I can use.
View 2 Replies
Oct 22, 2010
I am trying to read xml nodes values from lastfm web service that look like this:
<lfm status="ok">
<results for="stinkfist" xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/">
<opensearch:Query role="request" searchTerms="stinkfist" startPage="1" />
<opensearch:totalResults>188</opensearch:totalResults>
[Code]....
View 2 Replies
May 2, 2012
im having problems with reading these values from XML with XElement Im trying to get Each value between <month> and </month>
<Document>
<Element>
<status>1</status>
<data>
[code]....
View 2 Replies
Mar 16, 2010
I have a form to calculate some settings. It works just fine. I will input some decimal numbers to 8 deferent Textboxes. For example I input 40.0098 to textbox1. When I press a button my form will calculate these setting, and it will generate some new values. What I want to do is save the user inputs and the generated values to a text file each input or value has its own line it should by after the name of that input or value so the user could read the info contain in this text file, so per say line 1 of this text file will represent the input of textbox 1. it should save it as "parameter 1 = 40.0098" to line 1 of the text file I also want to be able to load this text file to my form (only specific lines) when I press another button I should get a dialog box to be able to select the text file, once I do that my form should read line one and only the input what after the "=" so textbox1 should now show 40.0098 only.
View 8 Replies
Apr 7, 2011
I've bound a lot of controls on a form to a Entity. Some of them update fine, the others are just jumping back to their original value as soon as it loses focus.The old data are loaded in all controls perfectly.
Dim Q = From e In EnData.Calls Where e.CallID = ID
TempRow = Q.FirstOrDefault()
ticTemp1.DataBindings.Add("Value", TempRow, "CallDate")
ticTemp2.DataBindings.Add("Value", TempRow, "CustomerID")
How can this be fixed?
View 1 Replies
Nov 20, 2009
I have a form with a couple of multi-line text boxes, a couple of radio buttons, and a couple of check boxes. When the form is closed I need to save the values of the textboxes, radiobuttons and checkboxes so their values will be retained next time the form is open. I've done this in VB6 on form open and form close, but I cannot get the same module to work in .NET
Here was what I used in 6.0 to save:
Sub SaveFormState(ByVal SourceForm As Form)
Dim A As Long ' general purpose
Dim B As Long
Dim C As Long
Dim FileName As String ' where to save to
[Code] .....
View 3 Replies
Aug 24, 2011
I have multiple controls on my form. Text boxes, radio buttons, check boxes, etc. Is there a way to move through every control on the form and save it's value, status ? Like whether the radio button is checked, or not. The value of the text box, and save them all to a text file. Then, reload the values saved in the text file in the same sequence. Without doing all this one line at a time.
View 2 Replies
