Skip navigation links

MySQL Forums :: Data Warehouse :: Importing data to MySQL database


Advanced Search

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 6466 velayudham jayakumar 01/04/2010 07:17AM
Re: Importing data to MySQL database 2689 Peter Brawley 01/04/2010 10:17PM
Re: Importing data to MySQL database 2641 velayudham jayakumar 01/04/2010 11:12PM
Re: Importing data to MySQL database 2470 velayudham jayakumar 01/19/2010 05:00AM
Re: Importing data to MySQL database 2656 velayudham jayakumar 02/06/2010 05:52AM


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.