MySQL Forums
Forum List  »  Data Warehouse

Importing data to MySQL database
Posted by: velayudham jayakumar
Date: January 04, 2010 07:17AM

Hello,

I am working on MySQL database. My requirement is to import data from the following format to MySQL database. The data format is
"----[/DHS3dyn/account/TAXAYQEK.DAT : Ticket number 8/8/100]---------------------

00) TicketVersion = ED5.1 (01) CalledNumber = 00138313407

(02) ChargedNumber = 32370 (03) ChargedUserName = TEST PERF 202

(04) ChargedCostCenter = C42 (05) ChargedCompany =

(06) ChargedPartyNode = 202 (07) Subaddress =

(08) CallingNumber =

(09) CallType = PrivateNetworkOutgoingCallToPublicNetwork

(10) CostType = ISDNCircuitSwitchedCall (11) EndDateTime = 20090908 10:06:52

(12) ChargeUnits = 1 (13) CostInfo = 100

(14) Duration = 519 (15) trunkIdentity = 29

(16) TrunkGroupIdentity = 2 (17) TrunkNode = 202

(18) PersonalOrBusiness = Normal (19) AccessCode =

(20) SpecificChargeInfo = (21) BearerCapability = 3Audio

(22) HighLevelComp = Unspecified (23) DataVolume = 0

(24) UserToUserVolume = 0 (25) ExternFacilities =

(26) InternFacilities = BasicCall ARSService

(27) CallReference = 0 (28) SegmentsRate1 = 0

(29) SegmentsRate2 = 0 (30) SegmentsRate3 = 0

(31) ComType = Data (32) X25IncomingFlowRate = Unspecified

(33) X25OutgoingFlowRate = Unspecified (34) Carrier = 1

(35) InitialDialledNumber = 014001893 (36) WaitingDuration = 2

(37) EffectiveCallDuration = 7 (38) RedirectedCallIndicator = 1

(39) StartDateTime = 20090908 09:58:13 (40) ActingExtensionNumber = 65579

(41) CalledNumberNode = 9999 (42) CallingNumberNode = 9999

(43) InitialDialledNumberNode = 9999 (44) ActingExtensionNumberNode = 501

(45) TransitTrunkGroupIdentity = 43696 (46) NodeTimeOffset = 0"

Can you please suggest some methodology to import this kind of data.

Options: ReplyQuote


Subject
Views
Written By
Posted
Importing data to MySQL database
7996
January 04, 2010 07:17AM
3511
January 04, 2010 10:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.