Hi,
Thanks for helping.I have an A2K Appl.Recently,o ne 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 ServiceApplicat ion ChronicInd IncludeReportIn d SuppressNotific ationInd ReportingRegion Id Address ResolveCountryI d ResolveDivision Id ResolveAreaId ManagerResponsi bleId ChangeInd ChangeSystemId ChangeRefId ProblemSystemId ProblemRefId CustomerImpact LongTermSolutio n RootCause DeletedInd DeleteReason SysDeleteTime SysDeletedBy ManagingDirecto r FinImpactId CustImpactBegin Time CustImpactEndTi me ChangeSystemCau seId AddDetailInfo CrisisMgmtEscal ationId 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,34 510 etc)
Any help?
Roy
1  2326 
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********@yah oo.comwrote in message
news:11******** *************@h 54g2000cwb.goog legroups.com...
Hi,
Thanks for helping.I have an A2K Appl.Recently,o ne 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 ServiceApplicat ion ChronicInd IncludeReportIn d
SuppressNotific ationInd ReportingRegion Id Address ResolveCountryI d
ResolveDivision Id ResolveAreaId ManagerResponsi bleId ChangeInd
ChangeSystemId ChangeRefId ProblemSystemId ProblemRefId CustomerImpact
LongTermSolutio n RootCause DeletedInd DeleteReason SysDeleteTime
SysDeletedBy ManagingDirecto r FinImpactId CustImpactBegin Time
CustImpactEndTi me ChangeSystemCau seId AddDetailInfo CrisisMgmtEscal ationId
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,34 510 etc)
Any help?
Roy
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Suresh Kumaran |
last post by:
Hi All,
Does anybody know the sytax in VB.NET to write the
contents of a multiline text box to a text file?
Appreciate help.
Suresh
|
by: fabrice |
last post by:
Hello,
I've got trouble reading a text file (event viewer dump) by using the
getline() function...
After 200 - 300 lines that are read correctly, it suddenly stops
reading the rest of the file...
Thank you to all of you who can help me with this one...
|
by: Lionel B |
last post by:
Greetings,
I need to read (unformatted text) from stdin up to EOF into a char
buffer; of course I cannot allocate my buffer until I know how much
text is available, and I do not know how much text is available until I
have read it... which seems to imply that multiple reads of the input
stream will be inevitable.
Now I can correctly find the number of characters available by:
|
|
by: Eric Lilja |
last post by:
Hello, I have a text file that contains a number of entries describing a
recipe. Each entry consists of a number of strings. Here's an example file
with only one entry (recipe):
Name=Maple Quill
Process=Interim
Level=10
Technique=Fletching
Knowledge=Woodworking
Device=Sawhorse
Primary components=Refined Maple
|
by: Magnus |
last post by:
allrite folks, got some questions here...
1) LAY-OUT OF REPORTS
How is it possible to fundamentaly change the lay-out/form of a report in
access? I dont really know it that "difficult", but listen up;
Reports, the way I look at them, all present data downwards, in this way;
TITLE
data
| | |
by: Michael Mair |
last post by:
Cheerio,
I would appreciate opinions on the following:
Given the task to read a _complete_ text file into a string:
What is the "best" way to do it?
Handling the buffer is not the problem -- the character
input is a different matter, at least if I want to remain within
the bounds of the standard library.
|
by: Sabin Finateanu |
last post by:
Hi I'm having problem reading a file from my program and I think it's from a
procedure I'm using but I don't see where I'm going wrong. Here is the code:
public bool AllowUsage()
{
OperatingSystem os = Environment.OSVersion;
AppDomain ad = Thread.GetDomain();
|
by: dale zhang |
last post by:
Hi,
I am trying to save and read an image from MS Access DB based on the
following article:
http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp
Right now, I saved images without any errors. After reading the ole object
from db, I saved it to C: as file1.bmp and displayed on the web. But it can
not be displayed. After I manually sent the file to wordpad, it shows
|
by: Amit Maheshwari |
last post by:
I need to read text file having data either comma seperated or tab seperated
or any custom seperator and convert into a DataSet in C# .
I tried Microsoft Text Driver and Microsoft.Jet.OLEDB.4.0 to read text file
but could not get the data in correct format.
All columns are not coming in dataset and rows are messing up.
Suggestions please ???
|
by: The Cool Giraffe |
last post by:
Regarding the following code i have a problem.
void read () {
fstream file;
ios::open_mode opMode = ios::in;
file.open ("some.txt", opMode);
char *ch = new char;
vector <charv;
while (!file.eof ()) {
do {
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
