CN1567829A - General purpose data file conversion method - Google Patents
General purpose data file conversion method Download PDFInfo
- Publication number
- CN1567829A CN1567829A CN 03132012 CN03132012A CN1567829A CN 1567829 A CN1567829 A CN 1567829A CN 03132012 CN03132012 CN 03132012 CN 03132012 A CN03132012 A CN 03132012A CN 1567829 A CN1567829 A CN 1567829A
- Authority
- CN
- China
- Prior art keywords
- file
- data
- output
- input
- format
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
Abstract
The invention discloses a method of converting universal data files, for providing a method of converting various forms of call ticket files generated by exchange to arbitrary forms. Universal data file describing unit describes the data file to be converted by using data input-form file and stores data file describing information in the database; universal data file converting unit analyzes the description of the data input-form file and interprets the input file data into medium state, and then according to output file description, converts the medium-state data to output-form data and writes in the output file, thus completing conversion from input file to output file. After this, the universal data-detecting unit splits the converted file according to the output form described in the universal data-describing unit and converts to ASSII code to display in columns.
Description
Technical field
The present invention relates to the conversion method of general data file in a kind of field of telecommunications.
Background technology
Because China region is wide, each regional development differs, and being distributed in each regional switch type has the hundreds of kind, as S1240, EWSD, Ericsson, HJD04, ZXT10, C﹠amp; C08 or the like.Wherein the version of same kind switch is uneven, the CDR file form that different editions generated of every type of switch also has nothing in common with each other, discern the format of billing file of different-format, early stage charging acquisition system need be done a cover capture program to various dissimilar switches, with different programs the different-format CDR file is handled, cause charging acquisition system program huge, not easy care, upgrading difficulty or the like problem.The diversity of CDR file form is puzzlement telecom operators one big problems always.
The diversity of Original CDR form is the ubiquitous problem of present telecommunication system, wants thoroughly to deal with problems from the switch end, wishes that switch producer provides ticket according to unified reference format, almost is impossible at present, and reason is as follows:
● there is not unified format of billing standard in the switch industry at first at present.Each switch manufacturer all follows the standard that oneself is approved.
● to unify upgrade cost too high for switch in addition.The format of billing change, corresponding switch program will be changed, and certainly will will collect expensive upgrade cost.More extreme is some small switch, and manufacturer has not existed, and upgrading is not known where to begin especially.Therefore unified upgrading almost is impossible.
Summary of the invention
The present invention is in order to overcome weak point of the prior art, to provide a kind of and will exchange the system and method that the various form CDR files that produce completely convert arbitrary format to.
The present invention is achieved through the following technical solutions:
A kind of general data file conversion method comprises the steps:
(1) the general data file description unit comes out describable conversion data file with the data entry format file description, and data file descriptor data are saved in database; Described data entry format file description is wished the output file form that converts to, and wishes the distributing information the input and output file simply distributed before and after the conversion;
(2) the general data file converting unit is resolved the description of data entry format file, the data entry format file data is translated into intermediateness, describe according to output file again, the intermediateness data transaction is become the output format data, write output file, generate the data output format file and promptly finished from being input to the conversion of output file.
Described general data file converting unit is finished the conversion from the data entry format file to the output format file, comprises the steps:
(1) input traffic that meets distribution conditions in the data flow with the data entry format file outputs in the distributing data stream, writes in the distributing data file;
(2) data flow that does not meet distribution conditions is judged whether to need computing in the output configuration; Computing if desired, then domain output carries out computing, afterwards execution in step (3); If do not need computing, execution in step (3) then
(3) output content is converted to intermediate character string state;
(4) judge whether output content meets distribution conditions;
(5) if meet distribution conditions, the output stream that then meets distribution conditions outputs in the distributing data stream, writes in the distributing data file; If do not meet distribution conditions then write in the output format data flow, finally write in the output data file.
Finish after the conversion that is input to output file, the file after the conventional data detecting unit will be changed splits according to the output format of describing in the conventional data description unit, and converts ASCII character to, and apportion shows.
Described database has control of authority.
The present invention has following beneficial effect:
(1) safe and reliable.The invention provides strict control of authority, effectively avoided irrelevant personnel's misoperation and the configuration information that causes such as loses, changes by mistake at problem.
(2) be easy to learn and use.Friendly man-machine interface is provided, only needs simple training can learn to use.
(3) with low cost.Because document format data is describable among the present invention, newly-increased arbitrarily type or change Configuration Type change configuration are described and are got final product, and need not upgrade version.Only need one-time investment, for economizing the no small expense of next record in the annual huge maintenance cost of telecom operation enterprise.
(4) easy to maintenance.All data processing are all by same resume module, same traffic handing capacity code maintenance amount minimum.
Description of drawings
Fig. 1 is the schematic diagram of general data file conversion method;
Fig. 2 is a general data file converting system workflow diagram;
Fig. 3 is a conventional data convert file cell operation flow chart.
Embodiment
The invention will be further described below in conjunction with the drawings and specific embodiments.
Conventional data conversion method schematic diagram needs the file of conversion to convert the final apperance that needs convert file to through this general data file conversion method as shown in Figure 1.
Conventional data converting system workflow diagram as shown in Figure 2, the conventional data description unit will need the data converted file to be described, generate the data entry format file, the data entry format file converts the data output format file to through the conventional data converting unit.In order to check the accuracy of conversion, the output format file after the conversion need be through the detection of conventional data detecting unit.
● the general data file description unit will need the data converted file to be described, and generate the data entry format file:
The general data file description unit provides perfect, friendly man-machine interface, according to the information that the interface provides data file is described out.The conventional data conversion relies on input fully, the output file format description realizes, so description file format information is quite important, and any irrational change all can have influence on the correctness of data transaction.For guaranteeing the file description information reliability, this programme data file descriptor data all are saved in database.Database has strict control of authority, and the fail safe of data file descriptor is guaranteed.Here the type of database of using can be oracle, informix, sybase, access or the like, and is unrestricted.Be that this programme provides database middleware.The user needn't comprehend type of database.
All need the file of general data file conversion method conversion, must describe through the general data file description unit.The so-called description mainly is divided into:
1. file Global Information, required item.File type, file header, tail information, block message, file information such as fill character.
2. file source information, required item.Be exactly above-mentioned input data.Data type, the data format of input data, the information such as length of cutting apart field are come out according to the interface prompt information description.
3. file purpose information, required item.Be exactly above-mentioned dateout, with the data type of dateout, data format, field length, dateout source, the detailed descriptions of information such as (certain section input data, a few segment data simply add, add, multiplication and division computing gained, fixed value) is come out.
4. file distributing information is option.As distribution conditions content relatively, manner of comparison comprises more whole relatively content, rating unit relatively content, comparison content-length etc. according to above-described input, output item, comparison algorithm comprise equal, be not equal to, greater than, less than etc.According to the relatively various combinations of content, manner of comparison, comparison algorithm, the description document distributing information, be transformed at last in the file that needs and go, the data that do not meet the file distributing condition are write the dateout form that configuration describes and are write in the output file, promptly in the purpose file.
The general data file description unit is described out with various types of fileinfos, is the basis of follow-up conversion module, has only the information of description accurate, detailed, and the data file that converting unit is changed out is just accurate, errorless.
● the general data file converting unit becomes the data output format file with the data entry format file conversion:
The conventional data converting unit is core of the present invention.The general data file converting unit is resolved the description of pattern of the input file, and the pattern of the input file data is translated into intermediateness, again according to the output format file description, the intermediateness data transaction is become the output format data, writes the output format file.Any that need particularly point out, because the specificity of field of telecommunications switch ticket, a lot of output informations, can not have input item one by one correspondence obtain, but obtain dateout according to some algorithm combination, the conventional data converting unit of this case can realize importing between data and input data, import the simple computation between data and fixed value, thereby obtains dateout, has finally finished from being input to the conversion of output file.
The workflow of general data file converting unit as shown in Figure 3, the input traffic that meets distribution conditions in the data flow with the data entry format file outputs in the distributing data stream, writes in the distributing data file; The data flow that does not meet distribution conditions is judged whether to need computing in the output configuration; Computing if desired, then domain output carries out computing, afterwards output content is converted to intermediate character string state; If do not need computing, then directly output content is converted to intermediate character string state; Judge whether output content meets distribution conditions; If meet distribution conditions, the output stream that then meets distribution conditions outputs in the distributing data stream, writes in the distributing data file; If do not meet distribution conditions then write in the output format data flow, finally write in the output data file.
All input files all are the same for the general data file converting unit, and different is the configuration difference of different files.Configuration is divided into four parts, introduces four parts in conjunction with switch generation ticket and describes function.
1. file Global Information.According to the file Global Information input file is divided into data flow (or being called the input record), gives an example,, the switch CDR file is divided into a ticket according to configuration information as the switch CDR file.
2. source file information.Input traffic can be divided into littler territory again according to the source file input data description again, as comprising territories such as calling and called in ticket of switch, the information description of calling and called number is come out, and comprising:
● data type
● data type is described
● skew
● length
The information that disposes in the source file information can be fully according to the information in the source file, the territory is described and is listed one by one, also can omit certain territory wherein, how to accept or reject is according to selecting the file type in article one file Global Information to decide, the file that territory skew, length of field are arranged, can select input domain to describe, only list useful territory.Accepting or rejecting principle in a word is that final output will be according to the value of the information acquisition input domain of configuration in the input.
3. purpose fileinfo.Output file is finally also cut apart by domain output difference one by one, and the source of domain output has a lot:
● can derive from the input data source, as the calling number source and the calling number of importing in the ticket in the output ticket.
● can derive from several territories of input, obtain output by several territories simple computation of importing.As the conversation time started and the duration of call that the end of conversation time in the ticket of exporting derives from the input ticket are calculated gained.
● can derive from fixed value information, domain output is not bound the direct simple operation gained according to some constant or constant of input.
Source difference according to dateout, this unit converts the dateout source to intermediateness character string format, the data type of the domain output that description is described according to output file, type specification, skew, length convert intermediateness character string to the information of output configuration again, be written in the output stream, finally write in the output data file.
As the master in record in the switch ticket, taught number, skew, length according to them are taken out the calling and called number, again according to the data type of calling and called number, data type is described the calling and called number translated is become intermediate character string state, describe according to output configuration type, data type, skew, length that the calling and called number is described according to output write in the input ticket again.
4. distributing information.File distributing information can be selected to be provided with according to the demand difference of conversion, if wish in the transfer process according to some condition file to be shunted, or the data that need not use need not change or the like, and single data transaction can not be finished the demand.Charge system as field of telecommunications, hope will not be that the ticket of this area completely picks by native system and method, do not do to charge and handle, just can handle by the file distributing information description, this unit carried out the detection of file distributing condition in the input data before the dateout conversion, the file that satisfies condition writes in the distribution of document, the file that need distribute does not write in the final configuration file, if disposed file distributing information, the final file that generates is except the output format configuration file, N the file that distribution also will be arranged, the form of distribution of document can be the output format file, also can be input configuration format file, the also configuration description in file distributing information of which kind of file format.
As certain CDR file, comprise two types of tickets in the fileinfo, wish that wherein one type of ticket is distributed to another file different and configuration output, the condition of distribution is exactly the ticket type identification, just can in distribution conditions, describe, the ticket writing that satisfies this condition all is distributed in the file of specified file suffix, and the ticket that does not meet the type sign writes in the standard CDR file.
● the general data file detecting unit detects the accuracy of the file after the conversion:
The file of all conventional data converting unit conversions all can detect by this unit, and so-called detection is that the file after the conversion is generated text intuitively temporarily, and whether the result who examines conversion for the user is correct.The file conversion of various forms is become text, its principle is described the output description of file with above-mentioned converting unit as the input of this unit, output is described and is defaulted as the ASCII character string format, according to the domain output cutting file of describing in the conventional data description unit, apportion shows.
The description of summary the present invention three unit as can be seen, the general data file conversion method has realized that file is input to any conversion of output, the foundation of conversion is the description of general data file, according to the information of describing data file is changed.Except necessary description, converting unit were provided, the authentication unit that the present invention also provides was by general data file detecting unit detection validation transformation result.
Claims (4)
1. a general data file conversion method is characterized in that, comprises the steps:
(1) the general data file description unit comes out describable conversion data file with the data entry format file description, described data entry format file description is wished the output file form that converts to, and wish the distributing information that simply distribute the input and output file conversion front and back, and data file descriptor data are saved in database;
(2) the general data file converting unit is resolved the description of data entry format file, the data entry format file data is translated into intermediateness, describe according to output file again, the intermediateness data transaction is become the output format data, write output file, generate the data output format file and promptly finished from being input to the conversion of output file.
2. general data file conversion method according to claim 1 is characterized in that, described general data file converting unit is finished the conversion from the data entry format file to the output format file, comprises the steps:
(1) input traffic that meets distribution conditions in the data flow with the data entry format file outputs in the distributing data stream, writes in the distributing data file;
(2) data flow that does not meet distribution conditions is judged whether to need computing in the output configuration; Computing if desired, then domain output carries out computing, afterwards execution in step (3); If do not need computing, execution in step (3) then
(3) output content is converted to intermediate character string state;
(4) judge whether output content meets distribution conditions;
(5) if meet distribution conditions, the output stream that then meets distribution conditions outputs in the distributing data stream, writes in the distributing data file; If do not meet distribution conditions then write in the output format data flow, finally write in the output data file.
3. general data file conversion method according to claim 1 and 2, it is characterized in that, finish after the conversion that is input to output file, file after the conventional data detecting unit will be changed splits according to the output format of describing in the conventional data description unit, and converting ASCII character to, apportion shows.
4. general data file conversion method according to claim 3 is characterized in that described database has control of authority.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 03132012 CN1567829A (en) | 2003-07-07 | 2003-07-07 | General purpose data file conversion method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 03132012 CN1567829A (en) | 2003-07-07 | 2003-07-07 | General purpose data file conversion method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1567829A true CN1567829A (en) | 2005-01-19 |
Family
ID=34469846
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 03132012 Pending CN1567829A (en) | 2003-07-07 | 2003-07-07 | General purpose data file conversion method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1567829A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100426306C (en) * | 2005-11-09 | 2008-10-15 | 鸿富锦精密工业（深圳）有限公司 | System and method for switching format of file |
| CN1859505B (en) * | 2006-03-10 | 2010-08-25 | 华为技术有限公司 | Bill checking system and method |
| WO2010124495A1 (en) * | 2009-04-29 | 2010-11-04 | 中兴通讯股份有限公司 | System and method for multi-service format file processing |
| CN101930582A (en) * | 2010-08-06 | 2010-12-29 | 中国工商银行股份有限公司 | Multilanguage-supporting data conversion equipment and bank transaction system |
| CN101047902B (en) * | 2007-04-30 | 2011-08-24 | 华为技术有限公司 | Service process method, device of charging system and charging system |
| CN101610277B (en) * | 2008-06-18 | 2012-07-04 | 中兴通讯股份有限公司 | Method for processing information transmission |
| CN101262356B (en) * | 2007-03-07 | 2012-07-11 | 中兴通讯股份有限公司 | A CDR processing system for communication system |
| CN106778317A (en) * | 2015-11-20 | 2017-05-31 | 第美卡科技（苏州）有限公司 | The data information generation method of telecommunications card |
| CN106897259A (en) * | 2017-02-28 | 2017-06-27 | 郑州云海信息技术有限公司 | A kind of conversion method of ASCII character and character string based on WINDOWS platform |
| CN110471659A (en) * | 2019-08-16 | 2019-11-19 | 珠海格力电器股份有限公司 | Multilingual method and system, human-machine interface configuration software end and equipment end |
| CN111061481A (en) * | 2019-12-17 | 2020-04-24 | 神州数码融信软件有限公司 | Data format conversion method and device |
-
2003
- 2003-07-07 CN CN 03132012 patent/CN1567829A/en active Pending
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100426306C (en) * | 2005-11-09 | 2008-10-15 | 鸿富锦精密工业（深圳）有限公司 | System and method for switching format of file |
| CN1859505B (en) * | 2006-03-10 | 2010-08-25 | 华为技术有限公司 | Bill checking system and method |
| CN101262356B (en) * | 2007-03-07 | 2012-07-11 | 中兴通讯股份有限公司 | A CDR processing system for communication system |
| CN101047902B (en) * | 2007-04-30 | 2011-08-24 | 华为技术有限公司 | Service process method, device of charging system and charging system |
| CN101610277B (en) * | 2008-06-18 | 2012-07-04 | 中兴通讯股份有限公司 | Method for processing information transmission |
| WO2010124495A1 (en) * | 2009-04-29 | 2010-11-04 | 中兴通讯股份有限公司 | System and method for multi-service format file processing |
| CN101552976B (en) * | 2009-04-29 | 2012-06-06 | 中兴通讯股份有限公司 | Multi-service form file processing system and method |
| CN101930582A (en) * | 2010-08-06 | 2010-12-29 | 中国工商银行股份有限公司 | Multilanguage-supporting data conversion equipment and bank transaction system |
| CN101930582B (en) * | 2010-08-06 | 2013-04-10 | 中国工商银行股份有限公司 | Multilanguage-supporting data conversion equipment and bank transaction system |
| CN106778317A (en) * | 2015-11-20 | 2017-05-31 | 第美卡科技（苏州）有限公司 | The data information generation method of telecommunications card |
| CN106897259A (en) * | 2017-02-28 | 2017-06-27 | 郑州云海信息技术有限公司 | A kind of conversion method of ASCII character and character string based on WINDOWS platform |
| CN110471659A (en) * | 2019-08-16 | 2019-11-19 | 珠海格力电器股份有限公司 | Multilingual method and system, human-machine interface configuration software end and equipment end |
| CN111061481A (en) * | 2019-12-17 | 2020-04-24 | 神州数码融信软件有限公司 | Data format conversion method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111400387B (en) | Conversion method and device for import and export data, terminal equipment and storage medium | |
| CN111324610A (en) | Data synchronization method and device | |
| CN108682421B (en) | Voice recognition method, terminal equipment and computer readable storage medium | |
| CN1567829A (en) | General purpose data file conversion method | |
| EP3444725A1 (en) | Man-machine interaction method and device therefor | |
| CN103473234A (en) | Method, device and system for deriving report forms from web inquiring system | |
| CN104461531A (en) | Implementing method for self-defined functions of reporting system | |
| CN113177090A (en) | Data processing method and device | |
| CN110413672B (en) | Automatic data importing method and device and computer readable storage medium | |
| CN114500676B (en) | Information interaction method and device between industrial Internet devices and storage medium | |
| CN113741864B (en) | Automatic semantic service interface design method and system based on natural language processing | |
| CN111143450B (en) | Method and device for importing data | |
| CN113923268A (en) | Analysis method, equipment and storage medium for multi-version communication protocol | |
| CN102486731B (en) | Strengthen the visualization method of the call stack of software of software, equipment and system | |
| CN111324645B (en) | Block chain data processing method and device | |
| CN107315805A (en) | A kind of license e-file sharing method and system | |
| CN1851724A (en) | Business data operation coutrol method and business system | |
| CN112162951A (en) | Information retrieval method, server and storage medium | |
| CN110502478A (en) | Data interactive method and system between a kind of off-line system | |
| CN101866334A (en) | Method and system for generating CA (Certificate Authority) information message in QFII (Qualified Foreign Institutional Investor) services | |
| CN106339454A (en) | Inquiry-command conversion method and device | |
| CN107092607A (en) | A kind of bill storage method and device | |
| CN111324614A (en) | Table configuration method and device, terminal equipment and storage medium | |
| CN111241191A (en) | Database synchronization method and device | |
| CN113033832B (en) | Method and device for inputting automobile repair data, terminal equipment and readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |