Converting 5.1 code to 8.5

[Pellette]

Ok, that .txt file exists on the old computer. Can I open it using LabView 8.5 to retrieve the old logs, or does it also need to be converted?

[Matthew_Kelton]

It's just a text file.  You can open it in Notepad.

[Pellette]

Alright, everything seems to be in good working order now. Thank you for all your help.

[Pellette]

Hello again. I have a new problem.  I can now open the old data with the new computer using the Keithley_DataFile_migrated.vi, but I need to export the data to an excel spreadsheet.  In the attached .llb file there is a VI that is supposed to convert the data, but I'm not sure how it works.  I am having trouble retrieving the data in the DataLog_to_spreadsheet.vi.  Any insight you might have would be useful.  Thanks.

http://www.mediafire.com/?npxzw1nykij

[Dennis_Knutson]

Could you just attach the code to your message? The place where you are hosting the files is asking for a cookie to be downloaded and I'm not in the habit of accepting cookies from sites I'm not familiar with. Just use the Browse button below the message body.

Unless you have changed the VI from the one that you got translated, the VI in question is just using the Write to Spreadsheet File. All that this does is create a text file with columns separated with tabs. Excel is perfectly capable of importing this type of file. You can also just use Notepad to view. Explain exactly what you mean by 'having trouble retrieving the data'.

[Matthew_Kelton]

As Dennis stated, the VI in the library you posted creates a text file which can be imported into Excel.  It does not actually create an Excel spreadsheet (xls) file.  You can take the C:\My Documents\data\database.txt file and open it in Excel.

[Pellette]

The data I can open in the Keithley_DataFile.vi using the data log has information such as voltage, efficiency, etc. This is what I can see using the actual .vi front panel and the Retrieve Data Log option under the Operate menu.  I need to move this data into excel if possible. What happens when I try to open the data file directly in excel is that it appears to open as just a long list of code. If possible I would like excel to create a spreadsheet that has the output from each experimental run that was saved in the .vi datafile. Preferably this would include column headers including the caption for the output (e.g. "Voc", "efficiency").

Sorry about not using the attachment option, I didn't notice it before. I am on a different computer at the moment so I cannot attach the file right now.

[Dennis_Knutson]

When I run the VI once with some dummy data, I get a text file that Excel can open and each element is in a separate column. Run it again and a new row gets created. If you are not seeing that, then you are not specifying to Excel the correct way to open the file.

In order to add header information, you will have to modify one of your VIs to do that. It's just a Write to File that you perform once, before using the Write to Spreadsheet function.

[Pellette]

Hi Dennis. I have attached the Keithley_DataFile.llb file.  In it is the Keithley_DataFile_migrated.vi.  In this VI I changed the log file binding to use the Keithley_DataFile_data file which allows me to use the Data Logging "Retrieve" option to look at the old data. So I can now look at each of the 6,522 previous experimental runs individually in the Front Panel. I am not able, however, to convert this data into excel. I am not sure how you did it using the dummy data you entered. Could you please explain what steps you took?  Also, when I try to convert the Keithley_DataFile_data file to excel I get a long mess of seemingly meaningless output.

[Dennis_Knutson]

I just opened the VI and entered some some numbers into the controls. I changed the path and ran the VI. Changed the numbers and ran it again. Went to windows explorer and found the file. double clicked it and it opened in Notepad. Then I right clicked on it and selected 'Open With>Excel'. It opened just fine. Why don't you attach the file you created?