Haltech Forum Area is for discussing Haltechs

Haltech Solution: Importing E6K Datalogs into Excel (separate columns)

Thread Tools
 
Search this Thread
 
Old Dec 22, 2005 | 11:19 PM
  #1  
pistonsuk's Avatar
Thread Starter
Senior Member
Tenured Member 15 Years
 
Joined: Oct 2002
Posts: 685
Likes: 1
From: Portland, OR
Solution: Importing E6K Datalogs into Excel (separate columns)

These are the exact steps used to insert a datalog from my old crusty Compaq laptop into an Excel spreadsheet on my home PC. You might find your application varies some.

Some of my first attempts only yielded the column headings once imported. After using the different software this problem went away.

I used this version of software found at: http://www.hitman.hm/e6k634u.zip

Once I fixed this the data was all in one column. The follow shows how to avoid this.

1) Load datalog file
2) Hit “P” for Print
3) Hit “F” for File
4) Key in any file name i.e. “Test”
5) Enter First Page Number i.e. “1”
6) Enter Second Page Number i.e. “4”
7) Hit any key besides “Esc” and “R”
8) Hit “Enter” to return to datalog screen
9) Under the File Menu Exit the Haltech Program
10) Insert a floppy. Find “test.txt” file. Mine was in c:\. Under the file directory (c:\) type “copy test.txt a:” and press “Enter” to copy to the floppy drive.
11) Remove floppy and put in PC that has Excel.
12) Make a copy of “test.txt” and rename is “test.xls”. Say “OK” to the warning about making the file unusable.
13) Open Excel. Under File select “Open” and select “test.xls” from the floppy drive. It should prompt you with a screen, click the “Delimited” radio button, and then “Next”.
14) On the next screen select the “Space” button and hit “Next” and then “Finish”.
15) The data should all be in separate columns. I don’t know how to make the asterisk appear next to the vacuum values. It also might be wise to delete the page number rows.

hope this helps,
Justin
Reply
Old Dec 23, 2005 | 03:16 AM
  #2  
Project84's Avatar
Open up! Search Warrant!
Tenured Member 05 Years
 
Joined: May 2002
Posts: 3,838
Likes: 3
From: Kicking down doors in a neighborhood near you
Good post!
Reply
Old Dec 23, 2005 | 04:35 PM
  #3  
pistonsuk's Avatar
Thread Starter
Senior Member
Tenured Member 15 Years
 
Joined: Oct 2002
Posts: 685
Likes: 1
From: Portland, OR
Skip Step #12

I found that is not necessay to do step #12. Excel will still give that same prompts with the file saved as a text file.

Justin
Reply
Old Dec 23, 2005 | 06:08 PM
  #4  
purple82's Avatar
Absolute Power is Awesome
Tenured Member: 20 Years
 
Joined: Mar 2001
Posts: 1,973
Likes: 5
From: Issaquah, WA
If only the Haltech didn't puke if you print any pages higher than 10.
Reply
Old Dec 23, 2005 | 09:02 PM
  #5  
Wankel7's Avatar
Haven't we ALL heard this
Tenured Member 20 Years
 
Joined: Mar 2001
Posts: 3,948
Likes: 1
From: Indiana
I think the U version is the only version of the software that will actually print to file.

Good write up!

James
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
SakeBomb Garage
Vendor Classifieds
5
Aug 9, 2018 05:54 PM
$lacker
3rd Generation Specific (1993-2002)
8
Feb 13, 2016 05:26 PM




All times are GMT -5. The time now is 03:11 AM.