my timestamps are wrong when exporting waveform to excel

[alfie]

hi there,
I have the same problem,
After doing this , my waveform shows current time and date , but when i Export to excel , still 01/01/1904!!!

in another and simple VI, I connected the waveform with "build waveform" and connect t0 to "get time/date in seconds" and the problem solved, but at this project, I can't connect the waveform to "build waveform" !!!
I attached the VI , U can see what's going on!
I work with Labview 7.1 ( i'm new at LV)
thanks in advance,
/Alfie




Message Edited by alfie on 05-13-2008 06:32 AM

[alfie]

No one can help me??!!!

[MikeS81]

Hi alfie,

i can´t find a waveform in your vi. See the attached example picture.

Hope it helps.

Mike

Message Edited by MikeS81 on 05-14-2008 09:45 AM

[Norbert_B]

Alfie,

your vi contains a very nice "Goldberg". Your arrayhandling is not good, and, as far as i can see, not working like i asume you want it to. The reason: you always select the same channel and therefor save 16 times the same arrayindex.....
You should definetly rework the arrayhandling, add the code Mike suggested and perharps then the function is working as desired,......

hope this helps,
Norbert

[MikeS81]

Hi Alfie,

this part of code in your for loop should also work.

Try to remove your local variables, because everything you make there is also possible with wires.

Mike

Message Edited by MikeS81 on 05-14-2008 11:29 AM

[Norbert_B]

Mike,

there is still potential for improvement 🙂



Please note that the red marked code does not have any effect on the multiplication and therefor can be left out, too.....

Norbert

[Edit] Since Gain has a size of 8, the result of the multiplication has a size of 8, too. All other elements of a are ignored. Regarding the loop: Since it always write the same channel (index) in the output array (i doubt that anybody is fast enough to change the channel while the loop is running!), you have 16 times the same index, which is most propably not desired.... So loop is completly nonsense......
Changing Gain to Single will remove several coercions improving the code further.....


Message Edited by Norbert B on 05-14-2008 04:44 AM

[alfie]

Thank u Mike and Norbert 🙂
I've said that I'm new at labview 😞
It seems my problem with timestamp is solved,
but another question:  :">
how can I export different channel of my project to different excel files?? is there any way??
or in different sheet of one excel file?
I tried  to show per channel to seprate waveform and  export to seprate excel file, but after 4 waveforms importing, labview using more than 1GB of ram and hanging!!
what can I do know??
thanks in advance,
/Alfie

[MikeS81]

Hi Alfie,

to export your data to excel you need the ActiveX functions. Do you really need Excel? What about tdm(s)? tdms first is available in LV8.x i think.

Mike

Message Edited by MikeS81 on 05-14-2008 12:44 PM

[alfie]

Yes, I need it 😉
but Now,I'm working with "Export Waveforms To Spreadsheet File" and its ok with one channel, but what about with multi channel waveforms??
and what's the problem when I Use 4 or more waveforms in one project and labview use more than 1GB of RAM??
/Alfie

[MikeS81]

Hi Alfie,

i´m not sure how big your datas are, so i don´t know why you need 1 GB of RAM. if you have more than one channel you can create an array of your channels and write the array to the file.

Mike

Message Edited by MikeS81 on 05-14-2008 12:56 PM