-
Posts
4,850 -
Joined
-
Days Won
292
Content Type
Profiles
Forums
Downloads
Gallery
Posts posted by ShaunR
-
-
Indeed. But for an introduction to DBs and SQL it will be perfectly adequate and acheive what is required. You gotta open the door before running through it
-
Thank you to both.
My question with SQL, is how did you push all your data to the database, ie in my case 60 data points on each test. From my reading, that is not a way to easily send an array of data to the database.
My basic data that I am putting in the database for each UUT is: Fixture #, Employee #, Result, Serial # (future addon, but planning for it), and the data (min of 56 points).
I do like the webpage idea, but I would have to get IT involved in that, I am a HTML idiot.
Thanks guys.
SQL is all string manipulation
e.g
INSERT INTO TestDB (Fixture, Employee, Serial) VALUES ('No1', 'Brown','12345').
Will insert a new entry and populate the "fields" Fixture, Employee and Serial number with the values No1, Brown and 12345. (See its not that hard )
For the data, I would use a TEXT field (65,536 chars max should be plenty for most apps) and format my array to colon delimited floating point values. This makes it much easier to get back out and much, much easier to debug.
e.g
INSERT INTO TestDB (RawData) VALUES ('10.123456,3.1212134,12.11223344')
If any calculations are to be made on the data (eg mean values, standard deviation, noise, max-min etc) you can iether post process it in the report query (harder) or save it to the DB as a separate field (easy).
-
Another little snippet that you may find useful.
-
I had to make this dicision a while ago...and never looked back.
I set up my own "Test" network which I got IT to link to so that anyone with a browser and login on thier network could view test results and other test information. This is still in use and is incredibaly scaleable.
I set up an old PC with a webserver using Xampp. Its a fully functioning webserver including Apache, PHP, CGI, SQL,mail SSL and well, everything. But more importantly it is really easy to install and FREE. About 10 minutes and your up and running.
Part of the Xampp installation is an SQL server. I set up a set of "Test" databases (we had 3 product lines at the time so I decided to have a different one for each...personal choice to partition the data better. You could have one or you could have one for each station..its up to you how you set it up). The test stations (18 of them, 6 per line) all pushed thier test data into the various databases using the Labview SQL toolkit. I just made a drop in module for the existing test stations so that instead of writing the results to a file, they wrote it to the database.
I then wrote a few webpages (started as two, is now about 80 and quite sophisticated with graphs, process capabilities, searchable queries etc) that queried the databases so that any user could view the results in a web browser.
The thing about this setup was that it operated perfectly fine on its own as a standalone system, but once it was up and running, IT really took an interest (especially after the big guns wanted to see the pretty graphs on their laptops in the office ) and they have now taken the responsibility of managing and updating the webserver. From my point of view (and ITs) it creates a defineable partition between the test network and thiers and it is a technology they understand. The big guns loved it because there was no captital cost (well, apart from the SQL) although I did persuade them that they should make a donation.
- 1
-
Considering the 4 copies in memory that might happen, I'd be lucky to get that 200MB...
Still reeling from that one eh?
-
Hi all,
I have a .txt file which includes several lines, and I want to delete certain line(e.g. line 5) in the file, I found Labview have no function for this, so I would like to operate like following steps:
1. open file in read/write mode;
2. read all lines to a array;
3. delete the line in the array;
4.write updated array to the file(replace all the old contents)
do you have any other way to operate this easier?
1. Read from spreadsheet file.
2. Delete array element.
3. Write To Spreadsheet file.
Either way its only a 30 second vi. How easy do you want it?
-
Even Excel cannot save its own page breaks to a text file.
-
Are there any other BD constants in Labview that have to be initialized at run time before you can use them? (Honest question... I can't think of any off the top of my head.)
Ummm. VI, TCPIP, UDP. IMAQ, Bluetooth, IRDA?
-
Yes..like that . How did you get the time stamps on the grid lines???
I want to make sure each gets a time stamp
thanks
J
As Asbo said. You have to select a scale that shows the minor markers.
-
I think I see.
Like this?
-
I am using LV 8.5.1, so I cant open this VI.
Hopefully in your solution, there is a running time stamp for each major grid line....grid lines will move from right to left
Can you post a picture, since I cant open your VI
J
Sorry.
Here it is in a version you can open.
-
Hello
I am using a Waveform Chart and I would like to display the running time stamp on each major grid line. (LV 8.5.1)
Anyone know how to do this? A picture or a small vi would be quite helpful
thanks!!!
J
Here you go
-
Isn't that what you'd expect?
Its what I expect since I think of refs similarly to pointers. An unitialised pointer is a "null" pointer (no memory allocated). But I think Daklu thinks of them as references to objects and that by placing it on the diagram the "pointer" is allocated. So I got the impression (rightly or wrongly) that he expects a reference to an uninitialised ref to be the same as an initialised one since it is the same object. In that respect. Daklus last image seems prefectly normal to me, however it is an "unexpected" result.
-
In other words, the equals prim is smart. It "knows" to compare values of by-val objects and to compare references of by-ref objects.
...eh, I thought it was a neat side effect.
I'm not sure its is that smart. It basically just typecasts the ref to a U32 (or maybe an I32) and compares the values. It does the same for VISA and IMAQ sessions. If you think about your uninitilaised references, the value when typecast is 0 which is not equal to its value if its initilaised.
-
The cFP-1808 module backplane controller has a small hole labeled "RESET" that just begs for a straightened paper clip to be inserted.
The question is: (a) What is it that is RESET? (b) To what state is it RESET? and © Now that it is RESET, how do I put the reset values into some state of my choosing?
Its more of a reboot than a reset. The state depends on what you have set the power-up states to be from MAX and the position of the DIP switches (refer to the manual)
-
Thanks. I suspect it should work. In my case it got up to ~350 VIs before Labview sputtered and died.
Told you I get confused as to which propery nodes need closing of the refs
-
In a quick test just now in 8.6, it does in fact reload from disk VIs it does not consider to be changed.
Sweet
-
You can't help but laugh AT them in this
-
When working on a project sometimes another developer will check in code and I'll want to get the latest updates. Or I might be futzing around with previous versions of certain VIs. Usually LV will catch it and tell me the VI on disk has changed and offer to load the disk version. Sometimes it doesn't and continues to show the copy in memory rather than the version on disk. When that happens (or if another devoper has updated the project file) I end up having to close and reopen the project, which takes ~8-10 minutes.
I'd like to have some tool that forces LV to reload the project file and any VIs, controls, libraries, etc. that are in memory from disk. The Revert method combined with getting a list of all loaded VIs might work. Rereading the project file might be tougher.
Try this
Although I don't know whenter it will reload the vis if the vis in memory aren't modified. LV might ignore it if it doesn't think anything has changed.
But you should really be checking in/out and merging since its really a source control issue.
-
Is there a way to force Labview to reload a project file and/or project VIs from disk? I scanned through property and invoke nodes but didn't see anything promising.
Not quite sure what your getting at here since the project is just an organiser. You can set a directory to autopopulate which will cause it to react when changes to the organisation take place.
Individual vis can be reloaded by selecting "revert" which forces a reload from disk if the vi has changed (you can use an invoke node for this).
-
-
That's right - your submission has to be reviewed and approved by a "LAVA Certified" team member. It's one of the strengths of the LAVAcr over other forum reposotories - we only let code in that meets the LAVAcr standards.
And these " LAVAcr standards" are documented where?
-
Link is borken.
I think it needs to be approved or something. It doesn't appear in my file list but I can see it in the repository and edit/download etc (and its a different colour to the others). If I click on the link its there, so must be just the uploader until its approved.
-
Hi,
Can Anyone Know about how to program Analog Devices BF561 Ez-LITE Board board with Labview, means How to start programming using that board using labview
You'll probably need the "Embedded Module For Blackfin"
Fonts not displayed properly for EXE builds
in Application Builder, Installers and code distribution
Posted
Try adding the following to your executables "ini" file
appFont="Arial" 12
systemFont="Arial" 12