Communications :: Real Time Data Collection From Socket And Storing In Excel

Jan 5, 2012

I m into automation development of FMCG products using Micro-controllers. I get real time data Barcode 2D from TCP/IP connection. My task is to compare the result do some Computation with them and Store the incoming Barcode and results into a Excel sheet in a folder. I m successful with the basic working. Am currently working at slow speed of 1 barcode(22 char info) per second from the TCP/IP data (barcode scanner). Now, comes the real issue. I need to process atleast 5 barcodes per sec ( <200ms per process). I m partially successful with 3 Barcode per second(300 ms per process). so, thats like 300ms per processing. I need to achieve less than 200ms for entire processing. I have used threads and timers. but I m unable to achieve. Seems like storing in Excel takes more than 250ms. Since i come from micro controllers background 1msec is a lotta time to process for me. I m not sure how much time does it take and trust me i find it difficult to guage the time here.

View 1 Replies


ADVERTISEMENT

Excel Automation For Real-time Data

Jun 5, 2012

i have a program that function as a DAQ System.i have input channel to gather information from sensors. The reading of each sensor such as voltage, current and temperature are displayed in the textbook. As we all know, DAQ system is involve taking data real-time measurement.My problem is:

1. how to update each row automatically as time goes on. the value in the textbook is updated by each second.Below figure shows how the excel can be written automatically row by row, as time ticking for a sec. this update will stop as the timer stop.

View 12 Replies

Transfer Real Time Data From Vb 2005 To Excel?

Nov 24, 2009

I am working on a project that is able to display real time data from sensors from micro-controller. I am able to do so by sending the data through the serial port and then use vb 2005 to show the data. However, I want to save those data from vb 2005 to excel. How am I able to do it ? I am able to use vb to insert data to excel step by step, cell by cell using the following codes.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object

[code]....

Lets say TextBox1.Text and TextBox2.Text is my real time data. How do I save it to the excel sheet displaying the data in cell A2, A3, A4 when the time goes by. Eg. If I want to save TextBox1.Text to excel it would be, the data in the 1st seconds in cell A2, data in the 2nd seconds in A3, 3rd seconds A4, 4th seconds in A5, A6 and so on...

View 3 Replies

Office Automation :: Multi-threaded Real-time Data Handling In Excel With COM

Jun 22, 2010

I have an Excel based algo-trading app that needs to take in lots of real-time data, and make trading decisions based on the calculations driven by the data. It is not one of those "read-only" stock ticker kinda spreadsheets.I created a COM object with VB.NET that runs in its own thread space which collects data from a socket, and when the data is read it raises an Event with data attached. In Excel VBA, the event handler parses the data, puts them to the right places on the spreadsheet to feed calculations (so far it sounds like a stock ticker app), and then, based on the results of the various calculations it does something.The problem is that when the user starts to click around the spreadsheet while there is large amount of data coming, the event handler's cell updating breaks apart. If the app is left alone without user action, it stands well. My frustration comes from not understanding what happens to the main thread when a user clicks around. Either the event handler blocks the user action, or the user action blocks the event handler (under which case I will put in some queuing facility). But I just don't see how user action can break the code (like causing VBA to stop executing)

View 9 Replies

Communications :: Parsing Data From Binary Socket

Sep 7, 2008

I am using VB.NET and I am designing a generic network architecture in which data can be transmitted in various ways. I am wanting to strip down things as much as possible, and I do not want to transmit in plain text. My question today is regarding ideas and example code (if applicable) as far as parsing binary data that is sent over the wire in VB.NET.I want each packet to have a very generic architecture such as <packet type> <address> <payload> or whatnot. I understand that I can use certain bytes as delimiters for these packet fields. I don't necessarily want to serialize everything being that for security reasons, the same library has to be used to deserialize the data.

a) Put my protocol into binary data where each field is delimited using a certain byte

b) Parse that data from binary at the other end.

Once again, I don't want to use plaintext since this can cause a bunch of overhead in comparison.

View 4 Replies

Reading Data From A Socket (as Bytes) And Storing Data In A String?

Nov 29, 2009

I am reading data from a socket (as bytes) and storing this data in a string. Then later i need to access specific bytes within the string and do some math with them. However the bytes that I read back from the string are not what I am expecting.

[Code]...

View 2 Replies

Communications :: Socket Behaviour - Created A Client That Can Send And Receive Data Via TCP Sockets

Aug 26, 2010

I have created a Client that can send and receive data via TCP sockets. The objects stored on the serverside are the *exact* same object used for the client. They use the same send and receive protocols.

Now, when i send a string from the server to the client , it does precisely what it should do. However when I send a string to the server.... I do receive the string as an equal length of NULL characters. I run the server and client locally.

Basicly what can influence the behaviour between two completely identical objects performing the exact same task? I wonder if there is some socketflag issue if the TCPlistener.accept function returns a completely different setup then the one I R used to.

(if it is of any interest, the send protocol is asynchronious)

View 3 Replies

Tracing A Graph In Real Time From Excel

Jul 5, 2010

I have a project to make a GUI using VB.net and retreiving data from an excel spreadsheet every three minutes and draws a graph in real time. The excel file is filled every 3 minutes by a new value (level of water in a tank).As I made started making this interface and I have a problem with retrieving data from a cell of the excel spreadsheet and update this action automatically every three minutes.

View 3 Replies

VS 2008 Select From Excel Returning Null Data Instead Of Real Data?

Dec 22, 2010

I typed this question once already, hit preview, and somehow never got the preview and lost what I typed. It has been that kind of a day.So here is my quick overview then I am going shopping. I am using OLE DB to select from an excel spreadsheet. It has over 15000 rows and 33 columns. Sometimes even when a cell is not null, it is returning a null value. If I just do a "select * where [termination date] is not null", for example, it will return no rows even though I can see with my own eyes that sometimes termination date is not null.

View 9 Replies

How To Cache Real-time Data

Jan 14, 2009

I'm working on a windows forms application (.NET 4.0).My form contains a 'Fast Line' chart using the Microsoft chart control included in VS2010.The chart gets filled with about 20,000 datapoints.My application then starts receiving market data from a server via DDE (Dynamic Data Exchange) in real-time and adds it the chart.

View 5 Replies

How To Send Real-time Data Over UDP

Sep 19, 2010

I have to send a sequence of video frames over UDP as fast and real-time as possible and while I got the basics working, I am running into all sorts of difficulties. Some of my goals:Data will normally be sent over dial-up (hence UDP instead of TCP), but also needs to support fast Ethernet.It's OK to occasionally drop frames (hence UDP instead of TCP).Need low latency. The frame the remote receives should be one that was recently sent (no more than a few frames waiting in buffers).I need to be able to detect the effective bandwidth so that I can compress the frames more or less to keep frame rate up.I break up frame data into one or more datagrams of about 500 bytes and each has a sequence number and other info. The receiver reassembles the entire frame and detects if any datagrams are missing.If the receiver detects more than a certain percentage of dropped frames (e.g. 50% over the last 10 frames), I send a TCP message to the sender to slow down by 50%. Sender than slowly increases speed by 5% each subsequent frame.Using System.Net.Sockets.UdpClient to send and receive the data.I have a separate TCP channel used for control messages back to sender.My main difficulty right now is detecting the effective bandwidth and dealing with latency, especially over dial-up (max ~4,000 bytes/sec). For example, if I try to send 100,000 bytes/second using TcpClient.Send() they ALL seem to arrive (no dropped datagrams) but with large latency by the time last datagram arrives. I think the TcpClient.Send() function is blocking until the buffer is able to send which messes up my current algorithm.

Can anybody point me to any sources of information for how to:Detect actual bandwidth over UDP.A better algorithm for dynamically adjusting bandwidth to suit the available pipe.Send data smoothly at the desired bandwidth.A way to detect and keep latency down to a minimum.I have been spinning my wheels over the last week and every time I solve one problem it seems another rears up is head.

View 1 Replies

Real Time Data Display?

Jan 11, 2012

are there any ways that i can extract my data from database and display it into my listbox in real-time? which means that whatever is updated in my database must immediately be inserted into the listbox without the need of refreshing or pressing any buttons. Immediate display.

View 3 Replies

Real Time Data From App To Web Server?

Jun 24, 2012

methods/procedures for sending real time data from a VB.net app to a web server (asp.net) for real time display. My question relates to the best method to send the data from the desktop app and the best way to receive and handle the data on the server. I'm not asking for sample code, just some idea of what methods to research. I am currently using a text file upload method but I'm sure there is a more efficient way of achieving this.

View 2 Replies

Real Time Data Tables/Data Grids?

May 25, 2012

I have been trying to find and/or think up a way for data to automatically update a data table.I have a log that shows all the customers that came in today with various information. There could be twenty or thirty employees adding to this log or updating or doing things with that customer. This information is in a Data Table on a ASPX page in Visual Studio 2010 that the code is binded in the aspx.vb page that is calling a page in my APP_CODE database file that calls a query in my Database to get the information.My question is could someones actions on a different computer make my computer refresh or to re-bind that data.I have thought of some kind of timer/counter maybe that looks to see if the count of the log is different.

View 2 Replies

Entity Framework 4.1 Data Real Time

Mar 9, 2012

I'm using EF version 4.1, and would like to have the data from the database in realtime, i.e. if you open the application it detects if there is new data in the database, and update the above it! is It possible to do this? I am using EF 4.1 code first time

View 1 Replies

Reading Data From USB Port In Real Time?

Sep 29, 2011

I have a driver for the device and I already have it integrated into an application.

It is a Human Input Device with buttons.

Controlling the device is not the issue nor is receiving button presses.

I want to retrieve the actual data that is being sent from the device to the computer and from the computer to the device.

I have seen a lot of hardware approaches but not any software approaches(that work right).

View 3 Replies

Sending Real Time Data To A Table

May 25, 2010

Basically I have a program that receives real time data from microcontroller and displays it in a text box. What I would now like to do is to store the values received into a table that can be viewed when the receive program finishes. However I still want the values displayed as they are received in addition to being stored in a table of some sort.

View 3 Replies

.net - Storing Subcollections (filtered Versions Of The Main Collection) Inside The Collection As Cache?

Jan 15, 2010

Is it good practice to store sub-collections of item X inside a parent collection of item X for caching 'filter-queries' which are performed on the parent collection? (They won't be used together (as in color AND type).) Or is it also ok to just Loop over the collection and return the correct entities in a temporary collection?

[Code]...

View 1 Replies

.NET And Displaying Real-time Received Serial Data On GUI?

May 24, 2010

I'm having a bit of an issue receiving a stream of serial data and displaying the data real-time in my GUI. I am fairly new to VB.Here's what I'm trying to achieve: I have an I2C device (bank of LED's) connected to my Arduino. Using the VB.NET (2010) GUI I request which LED I want on (via buttons) and the I2C device then sends a reply confirming which LED actually turned on (basic feedback). Ok, sounds great right? Here's where I get issues. Well when I try to read the serial data sent to VB and display the real-time stream on the GUI, a) I get a bit of a mess as an output (values are ok, just spewn across GUI) and b) when I select a new LED to turn on, the GUI data does not refresh to this change. The stream being sent from the Arduino is ok, I looked at the data in a serial monitor.

[Code]...

View 2 Replies

Create Application That Can Download The Real-time Data?

Jun 15, 2011

I've use VB net to create a application that can download the real-time data from a device for every second. Now I want to upload the data to a website in real time. (So some who is far away, can also check the data through the website)

View 3 Replies

Pass Data Bewteen Forms In Real Time?

Jan 30, 2009

HBasically I will have two forms. Form1 will control form2 which is the media display. Form2 will give back the media status and info back to form1 in someway. I was thinking of creating properties in form2 and having form1 polling these values to display the elapse run time etc... ideally i wish to have form2 somehow send events back with data when it values gets updated.

View 1 Replies

VS 2010 : View Array Data Real Time?

Feb 13, 2012

On VB.NET 2005 and 2008, if you were debugging you could roll over the variable you set as an array and a little "+" would pop up next to the array variable and you could click it and see all of the data loaded into the array.

View 3 Replies

VS 2010 Displaying Real-time Serial Data In GUI?

May 24, 2010

connected to my Arduino. Using the VB.NET (2010) GUI I request which LED I want on (via buttons) and the I2C device then sends a reply confirming which LED actually turned on (basic feedback). Ok, sounds great right? Here's where I get issues. Well when I try to read the serial data sent to VB and display the real-time stream on the GUI, a) I get a bit of a mess as an output (values are ok, just spewn across GUI) and b) when I select a new LED to turn on, the GUI data does not refresh to this change. The stream being sent from the Arduino is ok, I looked at the data in a serial monitor.

Public Class Form1
Dim ticktock As Integer
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles

[code].....

View 4 Replies

VS 2008 Displaying Data On More Than One Network Computer In Real Time?

May 2, 2009

I am busy with a VB2008 EXPRESS program that reads is data via a network cable. Saving the data on the same computer as my program is not a problem, but I must also make this data available to other users in the network and update their screens in real time. In other words I need a COPY of my running program on each networked computer when requested by the user in the network. I have looked at SQL, XML pages and inheritance. But I am confused, what is the best way???

View 13 Replies

VS 2010 Caching Real-time Data To Avoid Crashing Chart?

May 10, 2011

- I'm working on a windows forms application (.NET 4.0). - My form contains a 'Fast Line' chart using the Microsoft chart control included in VS2010. - The chart gets filled with about 20,000 datapoints. - My application then starts receiving market data from a server via DDE (Dynamic Data Exchange) in real-time and adds it the chart.

Note: I have no control over the server and so I have to deal with DDE only even though it's an outdated technology. VS doesn't support DDE anymore and so I use the Ndde library which works like a charm.

Private Sub StartDDE()
'first we connect to the DDE server:
Dim client As DdeClient = New DdeClient("ServerApplication", "Bid")

[Code].....

View 1 Replies

Communications :: Socket Raw And Vista II ?

Aug 7, 2009

Using the Socket raw, with XP I can read without problems both the incoming packets and the outgoing packets. With Vista (I have tried also others Sniffers) is impossible to see the outgoing packets...WHY? what I have to do to see alse the outgoing packets? In reality I have not to read packet data or packet lenght... I need only to count the number of incoming packets and outgoing packets... but with Vista this job seems impossible... or not?

View 1 Replies

Communications :: Socket Connection Error

Aug 1, 2008

I'm working on an application that communicates to torque controllers on the factor floor. The user inputs an IP address and a port and clicks the btnConnect button to make the initial connection. Once that completes a KeepAlive message must be sent periodically to maintain communication with the torque controller. The initial connection works very well but a socket error (see below) grinds everything to a halt when the KeepAlive message is sent. I would appreiciate any ideas the readers may have on the root cause. I'm quite confused because basically the same code is use for both the initial connection and then the KeepAlive messages. I have pasted some of the code as well below.

[code]...

View 1 Replies

Communications :: Socket - Connecting To Port 80 Of Server

Apr 21, 2008

I am new to socket communication. I found a few samples on the web and I managed to make my own host-client communication but i wanted to go a bit further and connect to port 80 of a server and it was just a disaster! First of all I know I can just use the functions that vb has itself but I want to make my own connections ... I have got some reasons I need this one! Do I really have to make them "connect" or just somehow without connecting I get the data? So I'm stack at the point that the connection is made ... it refuses to connect.

View 7 Replies

Communications :: Use A Socket Connection On Vb To Communicate With PC Without Using GSM Modem And SIM Card?

Apr 1, 2009

I would like to know can we use a socket connection on vb to communicate with PC without using GSM modem and SIM card.for example, like sendin a simple text msg to the PC and it will reply back the result back to me the result.

View 1 Replies

Communications :: [2008] Socket Programming - Receive / Send?

Mar 6, 2009

I realize this is a broad question, but how do I recieve / send packets. I know what packets I need to send and what Im going to recieve, but I dont know how to send / recieve them.

View 8 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved