Dave Graybeal

tcplomp,

Thanks for the link to the KB on NI's Forums. It looked like it only applied to MS access however. In our case we can connect to MS access and write all the data types fine. It just appears to be an issue when we try to write to PostgreSQL with a Date Column. I'll put together a VI that demonstrates the code that works as well as the code that does not work. If anyone's successfully done this before any help / advice would be appreciated

Thanks,

Dave Graybeal

QUOTE

Are VIs saved in 8.2.1 fully openable and editable in the 8.2 development system? Thanks.

Yep, I tried it this morning actually to make sure. A VI that you save in 8.2.1 can be opened and edited in 8.2 just fine. Every file that you open in 8.2 though does think it needs to be resaved, so this could be an inconvience if loading lots of file.

Dave

Hey all,

Has anyone used a Parameterized Query to Insert data into a PostgreSQL date Field? I'm getting an error returned when it tries to execute the query. The same code works when I try to talk to an Access database.

Thanks,

Dave

I'm currently using LabVIEW Database Connectivity Toolset for LabVIEW 8.2.1, PGADO client and PostgreSQL 8.2.

QUOTE

I would suggest setting up a means for members to relieve their frustrations at HH-type questions -- perhaps with a button to click. Enough clicks by enough members could send the topic to a different section, as described above. Perhaps this can be done as a ratio:

"""After 12 viewings, 63% of the readers found this topic to be poorly formed. Please revise your question and resubmit."""

I think Doon might be onto something here. This would make it an anonymous vote sorta thing on every post that could likely be automated. This would eliminate the need for a large moderators group and still inform the poster that they need to do some more work before they resubmit the question.

Thanks,

Dave

I agree Crefl, this shouldn't fall solely on Mike. I would also be willing to help out as a Moderator if we would like for this purpose. I'm sure there are plenty of members willing to help with this issue. I know that my recomendation would take more work than just moving the forum, but I think in the end it would help fuel more constructive posts and act as more of an encouragment towards new members to get involved properly.

Dave

QUOTE

lock the topic so that neither the homework hustler nor the homework hustler hecklers have a chance to butt heads.

QUOTE

I'm not sure i think the topic should be locked. I would be more in favor of it being locked to people other than the creator and moderators. Locking the thread altogether would fail to allow the poster to rephrase the question.

Maybe a procedure should be more like this.

1) Unclear, Nondefinded posts get moved to another topic (maybe something other than HH to prevent new members from being offended.. maybe something like Rework Needed?)

2) A default post from the moderator that moved the thread to inform them that the post needs some work in order to be acceptable on LAVA.

3) Lock the thread from everyone but the original creator and mods

4) Send the creator a PM informing them of the move (maybe with a link to the new post)

4) Let the post sit for some period allowing the creator to fix the issues with the way they posted it.

5) After the creator has the post fixed they send a PM to the moderator(or whoever originally moved it) requesting it be moved back

Something like this might help promote the following of guidelines in a non-offensive way for someone that just didn't take the time to read the post guidelines before posting. Obviously after the same account makes numerous of these poor posts it could be set upon the moderators to take futher action.

Hope these ideas are useful.

Dave Graybeal

QUOTE

Nullllll: you're assigned to help Sally out for this problem - let's see what the two of you come up with...

I can't wait to see how this pans out. Should be Interesting lol.

Dave

Well, there are more than one way to put in a header. The first way that comes to my mind is just use a concatenate string. Since the data is arranged in a spreadsheet string its format is pretty much:

data1[tab]data2[tab]data3[cr]data4[tab] ... etc.

Tabs denote column changes and CR denotes a row change (Tab is actually a Tab and CR is a Character Return). So you can simple build your header as follows:

Send Value[tab]Received Value[cr]

then concatenate that on the front of the spreadsheet string before you write it to the file.

I hope this helps.

Dave

Suleyman,

It was nice to see a VI showing what you were trying to accomplish. Between that, the screenshot and the description you formed what I feel was a good question. You were on the right track to get the data sorted into columns and rows. Attached is a VI that I built off your example to give you a pretty good idea as to how to go about getting the data formatted properly. One difference in the way I handled it was that I get everything into a 2D array (virtual table) before I write data to a spreadsheet file. This allows me to get it to look how I need it without having to think.

I also notice that the way you have the VI set up it basically opens the file writes all the data and then closes the file each time you loop around. I'm not sure if this was intended, but I would recommend either doing all the writing outside of the loop at the end, or using the following procedure:

1) opening the file before going into the loop.

2) writing a single row of data to the file (for this you would use a tab delimiter for the array).

3) close the file after exiting the loop.

I hope that this information helps you along your way.

Dave Graybeal

My guess is that the Declining Interest in LabVIEW from Googles perspective is that after doing 1 search you find LAVA. After finding LAVA you realize that there isn't much need in going back to Google to try to find more relevent information about LabVIEW.

LAVA, Your 1 Stop Shop for LabVIEW!

or

LAVA... Once you Start, you Can't Stop!

Dave

I went to Edit the Link to the Support thread today for my recently approved code. It seems that every time I edit the description it lists another file in the download list. I think this may be confusing to people downloading the files because they might think that some changes were made when really there was no update. Is this something that I as a member can edit to remove duplicate files from the history?

Thanks,

Dave Graybeal

Well, I've been told that LabVIEW 8.2.1 has been officially released. At the same time though, it does not appear to be located anywhere on ni's website. Anyone on here have the patch floating around or know when ni plans to make it available thru their website?

Thanks,

Dave Graybeal

Sweet,

I'm glad it sounds like there might be a best of both worlds solution

Thanks,

Dave

Michael,

I hope you didn't think my post was meant to be rude or demeaning to the efforts you put forth towards these forums. I am extremely greatful for the work that you put into this meeting place. It was just something that I noticed recently and wasn't sure what drove the change. I certainly understand that the higher that number the more resources required to make them available. I also understand that if I were to be away for a period of a week that I should not expect the RSS feed to save me from having to travel to the site to catch up. I actually enjoy browsing the site as it was created because I think you did a great job in laying everything out. I'm curious, how many posts on average does LAVA see in a day? Maybe this is how 50 was determined to be used, I don't know. I would think that if I were to check for RSS feed updates once every morning as part of my daily routine, that I would be able to retrieve all the posts from the previous day(With the execption of some peek traffic on a random day).

Thanks,

Dave

Tomi,

I do infact understand what your saying. It is important to maintain your copyright information, and I think anyone viewing your blogs should be willing to view the advertisements to support the cost of hosting. Is there another option though? When I view the Lava RSS in my RSS Reader (Thunderbird) it appears just like the webpage that I would have clicked on. I would imagine that this would count as a hit on the website being viewed and that It would also show any advertisements that exist there. ThinkingInG is another Example of a blog that displays the actual page. I would think this would solve the issue of advertisements not being viewed. I'm not sure however if this solves the rehosting issue you mentioned. I do enjoy your blogs and don't mind going to the site, I was just wondering if there is a way to get the best of both worlds ( you get the credit for people viewing them and we get to view them in our environment of choice). I'm curious if what Michael Aivaliotis and Jim Kring are doing solves these issues.

Dave Graybeal

I'm a huge fan of all the work that everyone puts into their blogs. First I'd like to say thanks for that. There are a lot of great articles out there. My question is in reference to the way the RSS feeds for a lot of these blogs show up in my RSS Reader. For Example, If I look at the LAVA RSS Feed I see the actual website embeded into the RSS Reader for me to view. I've seen a few of the blogs lately that just post text summaries for the RSS (not as nice to look at as the original html page), and even others (Expressionflow) that only show 2 lines of text and then directs you to the webpage for more. Is this an option on the Blog creators side that they get to decide how their blog is viewed? Or is this an option thru my reader that is Blog Specific?

Thanks,

Dave Graybeal

I'm curious, did the number of LAVA threads available via the RSS change recently? Previously I was receiving the last 100 posts from the RSS feed. The last 2 days though I've received exactly 50 multiple times. It could just be coincidence that there were only 50 new posts to be aquired, but it led me to wonder. I like having the max posts at 100 because on any given day there could be 30 - 60 posts. Having 100 posts means If I miss a day I don't always have to worry about having missed some threads/posts. As of recently when I saw 100 new posts when I did a retrieve I would go to the website and browse them thru that interface (instead of my rss reader) to make sure I wasn't missing something. If the new limit is 50 posts, I will likely be forced to use the RSS reader less to prevent missing posts.

Thanks,

Dave Graybeal

P.S. I do enjoy browsing thru the Website directly, but there is a certain convienence to using the RSS Readers that I enjoy.

I submitted a few VI's to the CR that I use to Get a Reference to all My Controls and a vi that allows me to search thru them to obtain the reference that I want. Hopefully they will be made available soon once I get them approved. I hope that you will all find those vi's useful when dealing with control references. Basically what I use the vi's for are to obtain all the references on a calling vi, I then pass them in a shift register in my application, and finally use another vi to obtain the reference I want by name.

If you get a chance to stop by and check the CR and take a look (after they are approved of course) I would appreciate any feedback and recomendations to improve on them.

Dave Graybeal

QUOTE

p.s. Your question didn't deserve this good an answer. I was pollite. Please be pollite to our community and behave according to the recommendations I suggested.

Not only do I agree with this, but I was surprised to see a post with anything more than HH for the text.

lol, Whatever kind of coffee your drinking you better start sharing with the rest of us.

Dave

It sounds like he might just be trying to use a numeric control with the increment and decrement. Each click of the Increment(or Decrement) will trigger an event value change. So if your numeric Control is set to 1 and you want to get to 4 you click the increment button 3 times. This will trigger 3 value change events for the control. Although I believe I see what he's trying to do, I'm not sure I have a good answer to solve this problem. Maybe someone else will have a recomendation for this scenario.

Dave Graybeal

[Napolean Dynamite Voice] LabVIEW 8.20 is like the best version ever! [/Napolean Dynamite Voice]

But really, 8.20 is a ton of fun to work with and really stable compared to 8.0. The startup time alone will save you days in your first month of use.

Dave Graybeal

-Proud 8.20 User-

From what I remember, I believe that legally you can install a single labview liscense on up to 3 machines. I believe these 3 machines are intended to be development machine, laptop and a computer at home. I also believe that the intended function of them is that they are used exclusively of each other. Now that being said, I doubt any sales rep is going to mind anything relatively close as long as its not being used to allow other developers in your business to develop from a single liscense.

Just my 2 cents, but if it's going to be installed on a home pc to increase your labview coding skills then I don't think anyone's gonna be filing a lawsuit against ya

Dave

After a bit more research it appears to be caused by a Daqmx Device Constant. I'm not sure where this Daqmx Device Constant Came from, but it is the reason we are seeing this. Attached is a vi that shows the constant, as well as a picture.

Anyone know where this constant came from?

Dave Graybeal

After a bit of investigation ( and a ton of disconnecting type defs ).... it would appear that the gray cluster probe is caused by the probing of the daq cluster within the cluster. Attached is an even smaller vi that shows where the gray probe is comming from. I'm not sure what it is yet, but I figured that I'd post this breakdown in case someone else might be more familiar with this issue. Also attached is a picture that shows it.

I hope this helps get this figured out.

Dave Graybeal

Not to spin too far off from this topic, but has anyone else that uses thunderbird and mozilla had trouble keeping your id in thunderbird? It seems like once a week or more I move my cookies.txt file from mozilla (which has always kept me logged in) to thunderbird. I seem to have to keep doing this because somehow thunderbird will quit remembering who i am. Anyone else see this?

Dave