Built-in SMDR no end of line feed. 1

[chipig]

I have a IPS 2000.I'm using port 0 connected to a PC for SMDR. Unfortunately Built-in SMDR has no end of line feed.
I can capture the data but all the calls appear on the same line. Is there any way of capturing the data and have each call on its line in a .txt file.I have tried many freeware that can capture the data but none have the option of starting a new line when ETX is received.

Data look like this:

<STX>0!KA0141590014223 10230713481023071907 001000014014144186605931 0000 08080 <ETX>

Has anyone sucessfully accomplished that?

 

[gmannatl]

The format is of a fixed length. So, I don't know what program you are using to capture the serial data, but if it can be set to start a new line after a set number of characters you are good to go.

 

[chipig]

Well that seem to be the problem, I cannot find a software that can do that.

I've tried:Realterm (very good by the way)
Hyperterminal
RS-232 Datalogger
Teraterm
And more..

None can start a new line in the saved file when a set of characters is received.I guess VB is my last option.

 

[OzzieGeorge]

As you want this in Excel, why not use VBA to pull it straight into Excel (read your post elsewhere)?

 

[chipig]

VBA could do but other people might access the excel file, so I'd rather have a raw text file and use the import external data in excel.I will look into VB to create a .txt file and sync on the ETX to start a new line.

Yes I have posted on other forums to see if someone did this but so far, no luck.

Thank you all for your help, and if someone knows a software that can log serial data and can sync on STX ETX protocol, let me know.

 

[wilc]

I use Teraterm Pro, set the terminal to 130x24 and log the session. (The SMDR record is 130 characters. 24 lines just happens to be convenient.) I then import the session log to excel and/or Access to manipulate and create reports.

Hope that helps.

 

[chipig]

I just tried it and it does display correctly in the terminal window but it does not display it the same way in the log file.It would be great if the log file would be exactly as the terminal window.It looks like I'm missing something.

I have Teraterm 4.60.

 

[wilc]

Interesting. What are you using to view the log file?

 

[chipig]

notepad or pspad

 

[wilc]

Do you have word wrap turned on when you view the log?

I wonder if you try to import the file to excel if the <CR> is not where it should be. Might be worth a try just for giggles.

The following is my teraterm.ini contents. That may help.

--begin teraterm.ini contents--
[Tera Term]
Version=2.3
Language=English
Port=serial
VTPos=119,306
TEKPos=-2147483648,-2147483648
TerminalSize=130,24
TermIsWin=off
AutoWinResize=off
CRReceive=CR
CRSend=CR
LocalEcho=off
Answerback=
KanjiReceive=SJIS
KatakanaReceive=8
KanjiSend=SJIS
KatakanaSend=8
KanjiIn=B
KanjiOut=J
AutoWinSwitch=off
TerminalID=VT100
RussHost=Windows
RussClient=Windows
Title=Tera Term
CursorShape=block
HideTitle=off
PopupMenu=off
FullColor=off
EnableScrollBuff=on
ScrollBuffSize=100
VTColor=0,0,0,255,255,255
VTBoldColor=0,0,255,255,255,255
VTBlinkColor=255,0,0,255,255,255
TEKColor=0,0,0,255,255,255
TEKColorEmulation=off
VTFont=Terminal,0,13,1
EnableBold=off
RussFont=Windows
TEKFont=Terminal,0,8,1
BSKey=BS
DeleteKey=off
MetaKey=off
RussKeyb=Windows
ComPort=1
BaudRate=9600
Parity=none
DataBit=8
StopBit=1
FlowCtrl=none
DelayPerChar=0
DelayPerLine=0
Telnet=on
TermType=vt100
TCPPort=23
AutoWinClose=on
Historylist=off
TransBin=off
LogAppend=on
XmodemOpt=checksum
XmodemBin=on
FileDir=C:\Documents and Settings\USER\My Documents
Accept8bitCtrl=on
AllowWrongSequence=off
AutoFileRename=on
AutoTextCopy=on
BackWrap=off
Beep=on
BeepOnConnect=off
BPAuto=off
BPEscCtl=off
BPLog=off
ConfirmDisconnect=on
CtrlInKanji=on
Debug=off
DelimList=$20!"#$24%&'()*+,-./:;<=>?@[\]^`{|}~
DelimDBCS=on
EnablePopupMenu=on
EnableShowMenu=on
EnableStatusLine=on
IME=on
IMEInline=on
KmtLog=off
LanguageSelection=on
MaxBuffSize=10000
MaxComPort=4
NonblinkingCursor=off
PassThruDelay=3
PassThruPort=
PrnFont=
PrnMargin=50,50,50,50
QVLog=off
QVWinSize=8
RussPrint=Windows
ScrollThreshold=12
SelectOnActivate=on
StartupMacro=
TEKGINMouseCode=32
TelBin=off
TelEcho=off
TelLog=off
TelPort=23
TCPLocalEcho=off
TCPCRSend=
UseTextColor=off
TitleFormat=5
VTFontSpace=0,0,0,0
VTPPI=0,0
TEKPPI=0,0
WindowMenu=on
XmodemLog=off
ZmodemAuto=off
ZmodemDataLen=1024
ZmodemWinSize=32767
ZmodemEscCtl=off
ZmodemLog=off
[Hosts]
Host1=myhost.mydomain
Host2=111.11.1.1
Host3=myhost.mydomain /F=myhost.ini
Host4=/C=1 ;serial port
Host5=/R=readme.txt ;replay a file
--End teraterm.ini contents--

 

[chipig]

Thank you very much. That log saved me a lot of time.
I have modified your log with my port settings and it worked.The problem was this line in my log:

EnableContinuedLineCopy=on

This setting must be off!

Thanx a lot!