> Also, I was wondering, could I use a Telnet component in my Delphi App. to > directly access the 4001 port and pull the data directly into my database.
You can use ICS, Indy or Sinapse telnet component to do that. ICS also has a TTnScript component which is some kind of basic scripting which simplify tasks such as entering login/password automatically. You can download ICS full source code (freeware) from http://www.overbyte.be Contribute to the SSL Effort. Visit http://www.overbyte.be/eng/ssl.html -- [EMAIL PROTECTED] Author of ICS (Internet Component Suite, freeware) Author of MidWare (Multi-tier framework, freeware) http://www.overbyte.be ----- Original Message ----- From: "Jerry Mallett" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, July 30, 2006 5:54 PM Subject: Telnet, Indy9, text file conversion; > > > I have TELNETed into our phone server at work to port 4001 and it allows me > to output the call logs to a txt file in this format..... > > 27/07/2006 12:15,Catherine Bradley,Modules.CallServer 00 > -07-d9-00-1c-6b.PRI,Catherine > Bradley,2180,,,07813922167,63390,26830,,,1,,,Cathe > rine > Bradley,d40d0300-e4a6-c814-927e-0007d9001fc7,0,,10,30890,20970,27/07/2006 1 > 1:15:46.513,,1,Catherine Bradley,,,0, > 27/07/2006 12:16,Cheryl Rainey,Modules.CallServer > 00-07-d9-00-1c-6b.PRI,Cheryl R > ainey,2022,,,00353749156837,36620,14250,,,1,,,Cheryl > Rainey,d4200a00-4ca5-c814-b > 868-0007d90019a1,0,,10,20250,16170,27/07/2006 11:16:06.274,,1,Cheryl > Rainey,,,0, > 27/07/2006 12:16,McCambridge Duffy Customer Care one,,,07775911808,Theresa > Gilli > spie,McCambridge Duffy Customer Care > one,8001,115180,112730,,,1,Modules.CallServ > er 00-07-d9-00-1c-6b.PRI,2000,McCambridge Duffy Customer Care > one,47f50700-04a0- > c814-b011-0007d9001c6b,0,6c350d00-6aa1-c814-8770-0007d9001aa2,110,2340,2240, 27/0 > 7/2006 11:16:07.735,,1,McCambridge Duffy Customer Care one,,,0, > 27/07/2006 12:16,Theresa Gillispie,,Theresa Gillispie,2000,Danielle mc > conway,Da > nielle mc conway,2168,42580,24620,,,1,,2168,Theresa > Gillispie,6c350d00-6aa1-c814 > -8770-0007d9001aa2,1,47f50700-04a0-c814-b011-0007d9001c6b,0,3220,3190,27/0 7/2006 > 11:16:07.736,,1,Theresa Gillispie,,,0, > 27/07/2006 12:16,Racheal McCahon ,,Racheal McCahon > ,2119,,,,39380,0,,,0,,,Rachea > l McCahon ,b64e0900-c1a6-c814-8d22-0007d9001977,0,,0,0,0,27/07/2006 > 11:16:11.632 > ,,0,,,,0, > 27/07/2006 12:16,Leanne Parke,,Leanne Parke,2156,,,,3960,0,,,0,,,Leanne > Parke,45 > cc0500-4ca7-c814-927e-0007d9001fc7,0,,0,0,0,27/07/2006 11:16:31.227,,0,,,,0, > 27/07/2006 12:16,Lilian Robinson,Modules.CallServer > 00-07-d9-00-1c-6b.PRI,Lilian > Robinson,2054,,,07919157058,77220,40330,,,1,,,Lilian > Robinson,33050f00-519d-c81 > 4-a60e-0007d9001987,0,,10,24630,17110,27/07/2006 11:16:36.645,,1,Lilian > Robinson > ,,,0, > 27/07/2006 12:16,Andrew Brown,,Andrew Brown,2057,Marty Parke,Marty > Parke,2077,10 > 4440,99570,,,1,,2077,Andrew > Brown,89620500-419d-c814-a60e-0007d9001987,0,,10,334 > 0,3310,27/07/2006 11:16:47.246,,1,Andrew Brown,,,0, > 27/07/2006 12:16,Andrew Brown,,Andrew Brown,2057,,,,810,0,,,0,,,Andrew > Brown,2b4 > 80100-aa9d-c814-a60e-0007d9001987,0,,0,0,0,27/07/2006 11:16:48.331,,0,,,,0, > 27/07/2006 12:16,Ashleen Kelly,,Ashleen Kelly,2071,,,**,2140,0,,,0,,,Ashleen > Kel > ly,2b740a00-09a6-c814-bf9f-0007d9001996,0,,0,0,0,27/07/2006 > 11:16:52.316,,0,,,,0 > , > > > As you can see, maximum line length is 80 characters and each record ouput > starts with a date and time and not all records are the same length due to > some fields being ommitted depending on the type of call. i.e internal or > external from what I can gather. > > My problem(s) are this. > I need to read this file in, one record at a time, so that I can convert it > to a CSV file or better still, import it directly into my DBF file. > > What is the best way of reading in this file one record at a time.( Would > really like to know how to properly read in and manipulate text files) > > Also, I was wondering, could I use a Telnet component in my Delphi App. to > directly access the 4001 port and pull the data directly into my database. > > This option would be preferred. > > For the record, Using Delphi v5, Indy 9, and Topaz Database Components. > > > > Many thanks in advance.. > > > > Jerry > > > _______________________________________________ > Delphi mailing list -> [email protected] > http://www.elists.org/mailman/listinfo/delphi _______________________________________________ Delphi mailing list -> [email protected] http://www.elists.org/mailman/listinfo/delphi
