Welcome to DSMtuners - The Talon, Laser, and Eclipse performance enthusiast resource
























Login


 Featured 
 Products 
 >>>>>> 
Go Back   DSMtuners > DSM Forums > General > Tech Article Archives > Articles: Tuning & ECU

Add to this Article  
 
LinkBack Thread Tools
Old 02-24-2005, 02:10 PM   #1 (permalink)
Proven Member
 
From: North Canton, Ohio
Registered: Feb 2004
Posts: 558
Classifieds Rating: (0)
Reputation: karbon is pretty helpful and trustworthy
How to post logs so that people can actually read them.

I've seen a lot of logs posted that wer unreadable because they were posted as plain text. Even if you try and "format" the log into columns using tabs or spaces, all but one space will be deleted. Only one whitespace character is allowed between two text items. You COULD use multiple "non-breaking space" items between HTML tags, but I have a better way:

You first start with a log. I'll be using this one as an example. Different loggers output their data in different formats, but the most common seems to be CSV (comma separated value) files, where each data column is separated by a comma, and data in the next row down is separated by a newline.
Note: DSMLink will output this file type by going to File > Export, then selecting is as either .txt or .csv from the drop-down box at the bottom of the dialog (both are CSV, the only difference is file extension). With other loggers I can only say go to their respective forum or FAQ sites and find out how to export the data to text or csv files.

If you post a log like this in the forums, it'll look exactly like it does in the link above (like crap). It needs some "meat" in between the values so that they'll be in their corresponding columns. There are a couple ways of doing this depending on the software installed on your machine. The best ways I can think of to do this are either either Excel or Dreamweaver. Most everyone has Excel, and the process is easy, but I prefer to have Dreamweaver to build the tables for me. I'll illustrate both.

For Excel:
First of all, if your data file is a .csv file, you can simply use Excel to open it up and it'll automatically fill in the columns for you. If you viewed your file in Notepad or Wordpad and know it's comma separated like the example above, you can rename the file extension to .csv and THEN open it in Excel. If you can't see the file extension, it's because you don't have it enabled. Here's how you show file extensions.
If your data is not seperated by commas, then don't fret. There is a way of getting Excel to recognize any data file with other delineators (such as spaces, dashes, semicolons, etc.) Go to the Data drop-down, select "Export External Data" and then click "Import Data". Find your log file and click Open. The first window that comes up shows you a few options. "Delimited should be selected, Start import at row: 1, File origin: 437 (these should all be defaults), then click Next. This window allows you to select what characters separate the fields. As soon as you input the correct one, it'll automatically build the tables in the preview below. Now just click Finish, and insert it into the current worksheet. Now it should show you all the data in nice neat columns. You may drag the column widths around until you're happy. When you're done, select the File menu and select "Save as Web Page, then save it. Now it's ready to be shipped to the forums. Skip to the section under "For Dreamweaver".

For Dreamweaver:
Open up a new, blank web page, and select the "Insert" menu, click on "Table Objects", and then click on "Import Tabular Data". Select the data file with the "Browse" button, then select the Delimiter. If it's comma separated, select comma, otherwise pick one of the others. If the delimiter the data file uses is not in the list, sorry because you're going to have to use Excel to import the file. Leave the Table width to "Fit to Data". Experiment with cell paddig and cell spacing to find out what you think looks best. I usually use a cell padding of 1 or 2. For "Format top Row", I like to make it bold. Border selects the border width. 1 is fine. Now you're ready to get the data into the forums.

So you've got your tables filled with data, what now? Well it's easy. If you're in Dreamweaver, go to the "View" menu and select "Code". Now you're looking at the code for the table. If you used Excel, go to the file you made as a web page, and right click on it. Go to "Open With >" and select notepad/wordpad. All you have to do is select everything from to
and copy it (CTRL+C). If it's a very large lof file, you may have to copy and paste in several chunks as it may cut off some of it if you try and paste the whole thing. Now on the window type [ C O D E ] (without the spaces), and paste the table, then type [ / C O D E ] (without the spaces) at the end. If you preview your post, you should see something like this:
Code:
Timestamp (us) RPM (rpm) AirFlow (gm/sec) FrontO2 (v) A/F Ratio (: 1) Knock (deg) Timing (deg)
0 3551 28.4 0.20 18.00 0.0 31.1
46780 3551 28.6 0.12 18.00 0.0 31.1
93860 3558 28.4 0.25 18.00 0.0 31.1
141324 3558 28.7 0.78 18.00 0.0 31.1
188744 3561 28.7 0.80 18.00 0.0 31.1
236212 3565 28.9 0.76 18.00 0.0 31.1
283596 3565 28.9 0.61 18.00 0.0 31.1
331080 3571 29.0 0.29 18.00 0.0 31.1
379112 3571 29.0 0.25 18.00 0.0 31.1
425876 3578 29.1 0.16 18.00 0.0 31.1
473296 3578 29.1 0.57 18.00 0.0 31.1
521688 3582 29.1 0.80 18.00 0.0 31.1
568148 3585 29.1 0.80 18.00 0.0 31.1
615568 3592 29.4 0.76 18.00 0.0 31.1
663824 3592 29.4 0.71 18.00 0.0 31.1
710432 3599 29.5 0.53 18.00 0.0 31.1
757856 3595 29.7 0.55 18.00 0.0 31.1
805580 3606 30.2 0.16 18.00 0.0 30.1
852704 3606 30.4 0.10 18.00 0.0 30.1
900132 3613 31.2 0.10 18.00 0.0 30.1
947552 3609 32.5 0.41 18.00 0.0 30.1
994988 3623 35.4 0.61 17.84 0.0 29.0
1042416 3641 39.7 0.20 17.59 0.0 26.2
1089828 3644 46.6 0.67 17.92 0.0 25.1
1137248 3641 50.7 0.84 14.60 0.0 23.0
1184680 3644 54.4 0.92 14.83 0.0 20.2
1232096 3662 57.7 0.94 14.49 0.0 19.1
1279532 3666 59.8 0.94 14.33 0.0 18.1
1326976 3659 62.0 0.96 18.00 0.0 18.1
1374576 3695 64.9 0.96 14.15 0.0 17.0
1421824 3669 67.2 0.96 14.15 0.0 16.0
1469252 3728 69.8 0.96 13.84 0.0 13.1
1516792 3713 71.3 0.96 13.77 0.0 14.2


____________________________
Nick
Offline  

[posts] [gallery] Reply With Quote
Related Auctions

Sponsored Links
Add to this Article






Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -7. The time now is 10:15 PM.

Page generated in 0.15357089 seconds (75.88% PHP - 24.12% MySQL) with 9 queries
DSM Forums | Pontiac Solstice/Saturn Sky Forums | Evolution Forums | WRX Forums

© 2001-2008 SPEEDtuners Network, LLC All Rights Reserved

LinkBacks Enabled by vBSEO 3.1.0