I am currently re-writing an isp billing application which i originally did in a product called "layout" which is no longer available nor supported as well as being only 16bit.
basically i need to be able to import thousands of these records into a "temp.dbf";
example;
Sat Feb 26 20:44:07 2000
User-Name = "martin"
NAS-IP-Address = 203.37.71.131
NAS-Port = 7
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "311667999"
Acct-Authentic = RADIUS
Called-Station-Id = "62802900"
Framed-Protocol = PPP
Framed-IP-Address = 203.37.71.236
Timestamp = 951558247
Request-Authenticator = Unverified
Sat Feb 26 20:45:11 2000
User-Name = "oscarsmith"
NAS-IP-Address = 203.37.71.131
NAS-Port = 27
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "311667997"
Acct-Authentic = RADIUS
Acct-Session-Time = 1167
Acct-Input-Octets = 7217
Acct-Output-Octets = 6589
Called-Station-Id = "62802900"
Framed-Protocol = PPP
Framed-IP-Address = 203.37.71.234
Timestamp = 951558311
Request-Authenticator = Unverified
And I export this text file;
# Users file as of the ...............12-07-2001
# Created by ISP-Plus...........version 1.0a
# as @ 11:52:03
#
12313 Password = "testpassword"
Service-Type = Framed-User,
Framed-Protocol = PPP,
Framed-Routing = None,
Filter-Id = "std.ppp",
Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP
3242314 Password = "testpassword"
Service-Type = Framed-User,
Framed-Protocol = PPP,
Framed-Routing = None,
Filter-Id = "std.ppp",
Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP
aad Password = "testpassword"
Service-Type = Framed-User,
Framed-Protocol = PPP,
Framed-Routing = None,
Filter-Id = "std.ppp",
Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP
basically i need to be able to import thousands of these records into a "temp.dbf";
example;
Sat Feb 26 20:44:07 2000
User-Name = "martin"
NAS-IP-Address = 203.37.71.131
NAS-Port = 7
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "311667999"
Acct-Authentic = RADIUS
Called-Station-Id = "62802900"
Framed-Protocol = PPP
Framed-IP-Address = 203.37.71.236
Timestamp = 951558247
Request-Authenticator = Unverified
Sat Feb 26 20:45:11 2000
User-Name = "oscarsmith"
NAS-IP-Address = 203.37.71.131
NAS-Port = 27
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "311667997"
Acct-Authentic = RADIUS
Acct-Session-Time = 1167
Acct-Input-Octets = 7217
Acct-Output-Octets = 6589
Called-Station-Id = "62802900"
Framed-Protocol = PPP
Framed-IP-Address = 203.37.71.234
Timestamp = 951558311
Request-Authenticator = Unverified
And I export this text file;
# Users file as of the ...............12-07-2001
# Created by ISP-Plus...........version 1.0a
# as @ 11:52:03
#
12313 Password = "testpassword"
Service-Type = Framed-User,
Framed-Protocol = PPP,
Framed-Routing = None,
Filter-Id = "std.ppp",
Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP
3242314 Password = "testpassword"
Service-Type = Framed-User,
Framed-Protocol = PPP,
Framed-Routing = None,
Filter-Id = "std.ppp",
Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP
aad Password = "testpassword"
Service-Type = Framed-User,
Framed-Protocol = PPP,
Framed-Routing = None,
Filter-Id = "std.ppp",
Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP
Comment