ygauthier

QUOTE (liuman @ Sep 19 2008, 11:25 AM)

Hi all,

I'm using labview 8.5 and using MAX in an attempt to communicate with a Hamilton MVP electronic valve through a serial/RS-232 port. I know my commands are correct because we have another program built in visual basic (that I didn't work on) and it controls the device fine. I'm just trying to integrate the control into Labview. The com1 port I've chosen is correct.

The commands are something like 1a<CR> or aLXR<CR> where the "a" is the address, and the "LXR" is the command. But even though the commands that I'm using in labview are identical to the ones used in the visual basic program, the device doesn't respond at all. When I read the buffer, the it just echoes what I sent back at me without any error codes or anything.

Anyone know if the viWrite function is able to write the commands that I need properly? Also, when I tick asynchronous write, it gives me an error, to the best of my knowledge shouldn't it be async?

Any help would be appreciated.

Hello there.

One way to be sure that you are sending the right information on serial port is to use a serial sniffer. You can easily find one by googling "Free serial sniffer". There are 2 reasons why your instrument is not responding to the commands you are sending:

1- You did not correctly set your serial settings (baud rate, data bits, parity, stop bit, termination character,...)

2- You are not sending a valid command.

Either points can be validated by using the VB software and a serial sniffer to see the correct command to send and the connection configuration parameters.

Hope this helps.

Yvan

QUOTE (Dan DeFriese @ Aug 22 2008, 12:29 PM)

Hello Todd,

I've never used this feature, but with LV 8.2 and greater you should be able to cache the device drivers and components you need the first time you create an install.

From LV 8.2 Help:

"... Caching installer components—If you build an installer more than once and the installer contains additional installers or components, caching eliminates the need to specify a location for the additional components each time you build the installer.

The first time you build the installer, the Locate Distribution dialog box prompts you to locate the distribution that contains the additional components. Place a checkmark in the Cache component from this distribution checkbox to copy files from the distribution into a permanent location on the local system. The next time you build an installer that includes these components, the Application Builder automatically copies the components from the local system instead of prompting you for a distribution CD. "

Hope this helps,

Dan DeFriese

This is a very useful feature indeed. Don't need those DVDs anymore because of this feature! Just a small disclaimer though. This feature will simply copy the DVD's installation files to your harddrive. Basically, building your exe will be easier but you will have to have enough disk space to store the driver installation files to your hard drive.

Yvan

QUOTE (iowa @ Aug 7 2008, 11:41 PM)

Test Stand 4.0 -- Better Reporting question

Have LabView & Test Stand sequenced project where I have to deal with 100K of tests results.

Native Test STand reporting is not really friendly or helpful in analyzing such huge volumes of tests results.

Question: Has anyone had any experience with Test Stand reporting -- what type of Test Stand reporting do you use? Any examples would be helpful.

Wonder if anyone has SQL DB Reporting repository with IIS WebPortal & Crystal Report Web AcrtiveX for letting anyone in intranet visit Webpages and query any flavor of the tests results reports. I am looking for examples or anything related to better Test Stand reporting.

Thank you,

Alex

http://energyray.com

Hi there alex. After working a full year on a pretty big TestStand project I can say that the HTML reports are very nice but are very hard to customize. To customize them you need some knowledge on web progromming such as xslt style sheets, xml, html, javascript,... The results can be realy impresive but you might need some help to get to what you need if you are not used to web programming. That said, this is only a static html reporting tool. If what you need is to be able to make different types of analysis on the data, you might want to think about a database solution. I never actualy tried it but I know that TestStand has drivers to communicate with databases. So you can basically add steps to save the data that you just acquired in the database.

There is one other option that I know of. It is not my intention to do product placement but I simply think that this might be useful to you. I work for a company called Averna. We make a software called Proligent which enhances TestStand web reporting capabilities. It actually does a lot more but just to keep this reply short, if you are interested, you can check out this website:

http://www.proligent.com/

Hope this helps,

Yvan

Hello everybody. I tried searching on the NI and lava sites and came up empty. I was simply wondering if anybody tested LabVIEW 8.5.1 on Windows XP Service Pack 3? And my question to those that have tried it... did everything go smoothly? I often use DAQmx, VISA, 488.2 (All latest versions) and also TestStand 4.0.1. So basically, I would like to read good and bad experiences that people have had with this service pack and NI software/hardware.

Thanks,

Yvan

I just upgrade our MySQL server from 4.0.13 to 5.0.18 and the bug has disapeared. This is the only problem I have seen with version 4. At least this problem forced me to upgrade faster and it didn't take nearly as much time as I thought it would. Thanks for the help guys.

Yvan

As I said, I am using MYSQL5.0 so this may have been fixed in MYSQL. I cannot reproduce this problem with any code I use. Can you attach a code sample? As you can see, I have defined a large field definition and I get back everything.

Here is the code sample:

Sorry for the quality of the picture but if you download it on your hard drive the quality seems to be better for some odd reason?

I'll try to install MySQL 5.0 on my local machine to see if it makes a difference.

Thanks again.

Whe I tried this from the database toolkit, it works fine for me. I used the SQL query:

SHOW columns FROM test_table

It returns all information. Here is the code I'm using:

Thanks for the response Michael. I actually used code very similar to the one you posted with the difference that I used the "Rec Fetch String Data ®.vi to get the response instead of the Fetch Recordset Data ®.vi. But even using the code you posted, I still get the bug. You can only see this bug if you have a data type definition that is more than 40 characters long. So for a data type such as int(11) there is no problem but for a datatype such as an enum with 4 elements for instance: enum('element1','element2','element3','element4')

then, the bug appears and only returns the following characters:

enum('element1','element2','element3','e\00\00\00\00\00\00\00\00\00

I saw on this forum that you are using a MySQL server. I would appreciate it if you could reproduce this bug. If you can't, that means that there's something wrong with my system. But I always love to blame my problems on somebody else!!!

This bug is probably a problem related to ADODB. Here is my problem. I