By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Reading from a Text file.

P: n/a
Roy
Hi,
Thanks for helping.I have an A2K Appl.Recently,one of the groups agreed
to provide data which I download into the access table.The problem is
this data which is sent in a text file.I am unable to import it because
of the delimiter tab.The tab is present in places where it is unable to
identify one problem ID from the second one.I need help.I am pasting a
sample taxt file here.

ProblemId Page SeverityId MaxSeverityId ReopenCount StatusId SysOpenedBy SysOpenTime SysUpdatedBy SysUpdateTime SysClosedBy SysCloseTime ContactName ContactPhone Summary Details StatusUpdate Resolution RootCauseCd TimeZoneCd StartTime EndTime SysResolveTime SysResolvedBy ResolveName ResolvePhone ServiceApplication ChronicInd IncludeReportInd SuppressNotificationInd ReportingRegionId Address ResolveCountryId ResolveDivisionId ResolveAreaId ManagerResponsibleId ChangeInd ChangeSystemId ChangeRefId ProblemSystemId ProblemRefId CustomerImpact LongTermSolution RootCause DeletedInd DeleteReason SysDeleteTime SysDeletedBy ManagingDirector FinImpactId CustImpactBeginTime CustImpactEndTime ChangeSystemCauseId AddDetailInfo CrisisMgmtEscalationId COBInvokedId SLABreachedId
34495 2 2 2 0 1 0000263999 2006-11-16 19:14:18.0 0000263999 2006-11-16
19:33:55.0 Mike Bradfield 817-317-8145 Solana ACD 800 number is
impaired The Solana ACD 800-235-7080 number is looping when selecting
option 2 for the command center. 11/16/2006 13:33:55 CST: Terry is
contacting Tampa to implement the fix. CST 2006-11-16
12:00:00.0 0 0 0 NAM Southwest Command
Center 1 50 0 6 7932537 No customer impact, however users have to
call directly into the command center to speak with operations.
817-317-8177. 0 0 2006-11-16 12:00:00.0 The Solana ACD
800-235-7080 number is looping when selecting option 2 for the command
center. Opened VT#7932537, contacted Terry Johnson who is
investigating. 0 0 0
34510 12 1 1 1 1 0000387571 2006-11-17 09:28:46.0 0000301555 2006-11-20
14:05:31.0 1000000798 2006-11-20 12:37:08.0 Ryad Bharucha 0207 508
6768 UK branch tellers are unable to access Teller Seven branches in
the UK are unable to access the Teller application to gain access to
EBS. Branch staff are unable to provide any services to
customers. 11/20/2006 14:05:31 GMT: Problem re-opened. The Sabre Teller
server was rebooted and all processes started successfully. All
branches confirmed access to Teller is now available GMT 2006-11-17
08:00:00.0 2006-11-17 10:20:00.0 2006-11-17 10:33:54.0 0000387571 Rafal
Kolodziejski 48-22-692-9931 0 1 0 EMEA 180 0 6 7938114 -What
timeframe did the issue span?
Problem was made known around 8am Nov 17 when branch tellers would
perform a Start of Day Process. Problem ceased around 10:30am. Problem
timespan was 2 hours 30 minutes.
-How were external customers impacted by this incident including outage
time experienced?
No transactions can be performed for the customers as Start of Day
cannot be initiated and tellers cannot work even in offline mode.
Branches have had to reject customer transactions because of this.
-How were internal customers impacted by this incident including outage
time experienced?
Tellers using the system cannot perform transactions and Citigroup
employees depending on the system to manage their day to day banking
needs in the branches could not be assisted during this timespan.
-Has there been any financial loss to Citigroup as a result of this
incident and if so what is the value of that loss?
Yes, but the value of that loss is unknown.
-Has there been any damage to Citigroup reputation as a result of the
incident?
Yes, since system runs in a client-facing environment.. Full services
were not started on the Sabre Teller after the normal nightly reboot.
Support continue to investigate the root cause 0 0 5 2006-11-17
09:00:00.0 2006-11-17 10:20:00.0 08:00 Branches unable to logon to
09:30 Manual reboot of Sabre Teller server.
09:52 Sabre teller server name LDNGCBSD018.
10:02 Processes now working
10:20 All branches have access to Teller.
0 0 0
34539 14 2 1 0 2 1000294222 2006-11-19 22:13:02.0 1000281139 2006-11-20
14:18:11.0 Watts Hudgens 469-220-9485 Multiple CBNA branches were
single-threaded. Many CBNA branches are single-threaded from a head-end
router in Weehawken. The GNCC is currently building a list of affected
sites. 11/20/2006 09:18:11 EST: Problem updated. Backout IOS changes
and services restored to all affected sites EST 2006-11-19
16:10:10.0 2006-11-19 19:50:00.0 2006-11-20
03:12:46.0 0000279882 Tyrone
Knight 469-220-9485 0 0 1 NAM 3 1 1 7773092 6 7954707 IOS
upgrade upgrade change affected the Crypto configuration and
connectivity. 0 0 6 1 Services restored at 19:50 0 0 0

As you can see,the first are the column headers.The problem Id's are
the 5 digit number(34495,34510 etc)

Any help?

Roy

Nov 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Its difficult to tell from the example as the posting of it has monkeyed
araound with the layout.

I wonder if your text file is missing a linefeed character, which happened
if its FTP'd using binary format (i think)
If you look at it in a HEX viewer, there should be a AO A1 pair (or the
orther way around..cant remember or is it AO OO) which is the Carriage
return Line feed pair.

anyway, it looks like each record ends in 0 0 0 which, if all else fails,
you might be able to strip it at that set of 0 0 0.

If you post with an attechment of the text file( or section of) this would
maintain the formatting which is lost in the post.
"Roy" <pr********@yahoo.comwrote in message
news:11*********************@h54g2000cwb.googlegro ups.com...
Hi,
Thanks for helping.I have an A2K Appl.Recently,one of the groups agreed
to provide data which I download into the access table.The problem is
this data which is sent in a text file.I am unable to import it because
of the delimiter tab.The tab is present in places where it is unable to
identify one problem ID from the second one.I need help.I am pasting a
sample taxt file here.

ProblemId Page SeverityId MaxSeverityId ReopenCount StatusId SysOpenedBy
SysOpenTime SysUpdatedBy SysUpdateTime SysClosedBy SysCloseTime
ContactName ContactPhone Summary Details StatusUpdate Resolution
RootCauseCd TimeZoneCd StartTime EndTime SysResolveTime SysResolvedBy
ResolveName ResolvePhone ServiceApplication ChronicInd IncludeReportInd
SuppressNotificationInd ReportingRegionId Address ResolveCountryId
ResolveDivisionId ResolveAreaId ManagerResponsibleId ChangeInd
ChangeSystemId ChangeRefId ProblemSystemId ProblemRefId CustomerImpact
LongTermSolution RootCause DeletedInd DeleteReason SysDeleteTime
SysDeletedBy ManagingDirector FinImpactId CustImpactBeginTime
CustImpactEndTime ChangeSystemCauseId AddDetailInfo CrisisMgmtEscalationId
COBInvokedId SLABreachedId
34495 2 2 2 0 1 0000263999 2006-11-16 19:14:18.0 0000263999 2006-11-16
19:33:55.0 Mike Bradfield 817-317-8145 Solana ACD 800 number is
impaired The Solana ACD 800-235-7080 number is looping when selecting
option 2 for the command center. 11/16/2006 13:33:55 CST: Terry is
contacting Tampa to implement the fix. CST 2006-11-16
12:00:00.0 0 0 0 NAM Southwest Command
Center 1 50 0 6 7932537 No customer impact, however users have to
call directly into the command center to speak with operations.
817-317-8177. 0 0 2006-11-16 12:00:00.0 The Solana ACD
800-235-7080 number is looping when selecting option 2 for the command
center. Opened VT#7932537, contacted Terry Johnson who is
investigating. 0 0 0
34510 12 1 1 1 1 0000387571 2006-11-17 09:28:46.0 0000301555 2006-11-20
14:05:31.0 1000000798 2006-11-20 12:37:08.0 Ryad Bharucha 0207 508
6768 UK branch tellers are unable to access Teller Seven branches in
the UK are unable to access the Teller application to gain access to
EBS. Branch staff are unable to provide any services to
customers. 11/20/2006 14:05:31 GMT: Problem re-opened. The Sabre Teller
server was rebooted and all processes started successfully. All
branches confirmed access to Teller is now available GMT 2006-11-17
08:00:00.0 2006-11-17 10:20:00.0 2006-11-17 10:33:54.0 0000387571 Rafal
Kolodziejski 48-22-692-9931 0 1 0 EMEA 180 0 6 7938114 -What
timeframe did the issue span?
Problem was made known around 8am Nov 17 when branch tellers would
perform a Start of Day Process. Problem ceased around 10:30am. Problem
timespan was 2 hours 30 minutes.
-How were external customers impacted by this incident including outage
time experienced?
No transactions can be performed for the customers as Start of Day
cannot be initiated and tellers cannot work even in offline mode.
Branches have had to reject customer transactions because of this.
-How were internal customers impacted by this incident including outage
time experienced?
Tellers using the system cannot perform transactions and Citigroup
employees depending on the system to manage their day to day banking
needs in the branches could not be assisted during this timespan.
-Has there been any financial loss to Citigroup as a result of this
incident and if so what is the value of that loss?
Yes, but the value of that loss is unknown.
-Has there been any damage to Citigroup reputation as a result of the
incident?
Yes, since system runs in a client-facing environment.. Full services
were not started on the Sabre Teller after the normal nightly reboot.
Support continue to investigate the root cause 0 0 5 2006-11-17
09:00:00.0 2006-11-17 10:20:00.0 08:00 Branches unable to logon to
09:30 Manual reboot of Sabre Teller server.
09:52 Sabre teller server name LDNGCBSD018.
10:02 Processes now working
10:20 All branches have access to Teller.
0 0 0
34539 14 2 1 0 2 1000294222 2006-11-19 22:13:02.0 1000281139 2006-11-20
14:18:11.0 Watts Hudgens 469-220-9485 Multiple CBNA branches were
single-threaded. Many CBNA branches are single-threaded from a head-end
router in Weehawken. The GNCC is currently building a list of affected
sites. 11/20/2006 09:18:11 EST: Problem updated. Backout IOS changes
and services restored to all affected sites EST 2006-11-19
16:10:10.0 2006-11-19 19:50:00.0 2006-11-20
03:12:46.0 0000279882 Tyrone
Knight 469-220-9485 0 0 1 NAM 3 1 1 7773092 6 7954707 IOS
upgrade upgrade change affected the Crypto configuration and
connectivity. 0 0 6 1 Services restored at 19:50 0 0 0

As you can see,the first are the column headers.The problem Id's are
the 5 digit number(34495,34510 etc)

Any help?

Roy

Dec 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.