CN102663614A - Configuration method and system for customer relation management to service provision - Google Patents

Abstract

The invention relates to a configuration method and a system for customer relation management to service provision. The configuration method of customer relation management to service provision comprises: reading the class of an excel and obtaining the configuration content relative to business in the excel; obtaining a connection string of a database by reading a configuration file; connecting the database for inquiring necessary data; assembling structured query language SQL statement; and sorting the output by a C++ container. The configuration method and the system for customer relation management to service provision of the invention reduce the workload of CRM to service provision in configuration, save configuration time, and raise configuration efficiency. The configuration method and system of customer relation management to service provision of the invention are beneficial to rapid opening without causing database conflicts.

Description

Customer relation management is to the collocation method and the system of service release

Technical field

The present invention relates to computer realm, relate in particular to collocation method and the system of a kind of customer relation management to service release.

Background technology

The interface of CRM (Customer Relationship Management, customer relation management) and service release belongs to the part of whole Complex interface, is the CRM service handling, arrives an intermediate link of service release after the business processing.Each functional module of CRM is responsible for generating business transaction change data, and interface needs to give the other side's platform data in synchronization according to the demand of service release end through configuration extraction from professional transaction data, and receives the return message of the other side's platform.

The data layout that the service release end requires is XML (Extensible Markup Language, an extend markup language) message, wherein comprises the order relevant information; Main body service and action and correlation parameter; Additional Services and action and correlation parameter.

At present, CRM carries out through manual to the configuration effort of service release, and this configuration mode workload is big, and the serious waste time, allocative efficiency is very low.

Summary of the invention

Technical matters to be solved by this invention provides collocation method and the system of a kind of customer relation management to service release, practices thrift setup time, improves allocative efficiency.

For solving the problems of the technologies described above, the present invention proposes the collocation method of a kind of customer relation management to service release, comprising:

Read the class of excel, obtain deploy content relevant among the excel with business;

Obtain database connection string through reading configuration file;

Connect database, the data of needs are inquired about;

Splicing structure query language SQL statement sorts to output through the C++ container.

Further, said method also can have following characteristics, also comprises:

Trigger the calling interface function according to order;

In the transmission service release process of form ordering system; The capable trigger table of order is monitored in scanning; Obtain the capable state of order for service order to be opened is capable, call service release transmission function and carry out the message assembly unit, and the message data that assembly unit is good is charged to service release interface table;

The Complex interface application integration platform obtains message data and sends to service release from said service release interface table;

Service release is handled message data and result is fed back to customer relation management CRM, and detached process scanning the other side interface table is given order relevant interface table with data transfer;

Form ordering system is handled the data of said order relevant interface table, continues the circulation order.

Further, said method also can have following characteristics, and said order relevant interface table comprises successfully feedback form and failure feedback form.

Further, said method also can have following characteristics, also comprises: the service action that the configure base allocation list is required, attribute and attribute value mode information are filled in the GetSql.xls file.

Further, said method also can have following characteristics, also comprises:

Form ordering system calls the external interface function of CRM to service release;

The interface table copy data of Complex interface from CRM to the service release given service release, and makes CRM go into history to the interface data of service release;

Service release data and CRM are to the common Property ID of data sharing of service release, and the professional Property ID of definition offers service release;

Service release is obtained the corresponding business property value according to said Property ID, and this service attribute value is passed to Complex interface.

For solving the problems of the technologies described above, the present invention proposes the configuration-system of a kind of customer relation management to service release, comprise the read module, acquisition module, enquiry module and the assembling module that link to each other successively, wherein:

Said read module is used to read the class of excel, obtains deploy content relevant with business among the excel;

Said acquisition module is used for obtaining database connection string through reading configuration file;

Said enquiry module is used to connect database, and the data of needs are inquired about;

Said assembling module is used for splicing structure query language SQL statement, through the C++ container output is sorted.

Further, said system also can have following characteristics, also comprises:

Calling module is used for triggering the calling interface function according to order;

Monitor module; Be used for the transmission service release process at form ordering system, the capable trigger table of order is monitored in scanning, and it is capable for service order to be opened to obtain the capable state of order; Call service release transmission function and carry out the message assembly unit, and the message data that assembly unit is good is charged to service release interface table;

The Complex interface application integration platform is used for obtaining message data and sending to service release from said service release interface table;

Service release is used to handle message data and result is fed back to customer relation management CRM, and detached process scanning the other side interface table is given order relevant interface table with data transfer;

Form ordering system is used to handle the data of said order relevant interface table, continues the circulation order.

Further, said system also can have following characteristics, and said order relevant interface table comprises successfully feedback form and failure feedback form.

Further, said system also can have following characteristics, also comprises: packing module is used for the service action that the configure base allocation list is required, attribute and attribute value mode information and is filled in the GetSql.xls file.

Further, said system also can have following characteristics, also comprises:

Said form ordering system also is used to call the external interface function of CRM to service release;

Complex interface, the interface table copy data that is used for from CRM to the service release is given service release, and makes CRM go into history to the interface data of service release;

Definition module, the data of said service release and CRM are to the common Property ID of data sharing of service release, and said definition module is used to define professional Property ID and offers service release;

Said service release also is used for obtaining the corresponding business property value according to said Property ID, and this service attribute value is passed to said Complex interface.

Customer relation management of the present invention is to the collocation method and the system of service release, reduced the workload of CRM in the configuration of service release, practiced thrift setup time, improved allocative efficiency.And customer relation management of the present invention is of value to quick opening to the collocation method and the system of service release, can not cause the conflict of database.

Description of drawings

Fig. 1 be in the embodiment of the invention customer relation management to the process flow diagram of the collocation method of service release;

Fig. 2 be in the embodiment of the invention customer relation management to the structural drawing of the configuration-system of service release.

Embodiment

Below in conjunction with accompanying drawing principle of the present invention and characteristic are described, institute gives an actual example and only is used to explain the present invention, is not to be used to limit scope of the present invention.

The present invention generates some fixing statements through the simplification of code realization configuration through program, uncertain part is passed through configuration excel and realized.

Fig. 1 be in the embodiment of the invention customer relation management to the process flow diagram of the collocation method of service release.As shown in Figure 1, in the present embodiment, customer relation management comprises the steps: to the flow process of the collocation method of service release

Step 101 reads the class of excel, obtains deploy content relevant with business among the excel;

Step 102 obtains database connection string through reading configuration file Config.cfg;

Step 103 connects database, and the data of needs are inquired about;

Step 104, assembly unit SQL (Structured Query Language, SQL) statement sorts to output through the C++ container.

In the embodiment of the invention, customer relation management can also comprise the steps: to trigger the calling interface function according to order to the collocation method of service release; In the transmission service release process of form ordering system; The capable trigger table of order is monitored in scanning; Obtain the capable state of order for service order to be opened is capable, call service release transmission function and carry out the message assembly unit, and the message data that assembly unit is good is charged to service release interface table; The Complex interface application integration platform obtains message data and sends to service release from said service release interface table; Service release is handled message data and result is fed back to customer relation management CRM, and detached process scanning the other side interface table is given order relevant interface table with data transfer; Form ordering system is handled the data of order relevant interface table, continues the circulation order.

Wherein, order relevant interface table can comprise successfully feedback form and failure feedback form.

In the embodiment of the invention, customer relation management can also comprise the steps: that to the collocation method of service release the service action that the configure base allocation list is required, attribute and attribute value mode information are filled in the GetSql.xls file.

Wherein, the configurations table comprises relation table or_groupprorel_dict, data source obtaining value method table or_DataSource_dict and the data source definitions table or_DataDef_dict of data source of relation table or_svcgrouprel_dict, set of properties, Property ID and the property value obtaining value method of service, action and set of properties.The corresponding relation of these four tables is following:

or_svcgrouprel_dict.group_id＝or_groupprorel_dict.group_id，

or_groupprorel_dict.property_new_value＝or_DataDef_dict.data_id，

or_groupprorel_dict.property_old_value＝or_DataDef_dict.data_id，

or_DataSource_dict.datasource.id＝or_DataDef_dict.data_id。

Wherein, the property_name (attribute-name) in field SVC_ID (service ID) among the table or_svcgrouprel_dict and ACTIOM_ID (action ID), the or_groupprorel_dict table, the data_exp (obtaining value method) in the or_DataDef_dict table can obtain.The value of property_new_value and property_old_value in most of the cases is the same, if the different table or_DataDef_dict that will define respectively twice.The configuration of configurations table will be explained in the content in the back.

In the embodiment of the invention, customer relation management can also comprise the steps: that to the collocation method of service release form ordering system calls the external interface function of CRM to service release; The interface table copy data of Complex interface from CRM to the service release given service release, and makes CRM go into history to the interface data of service release; Service release data and CRM are to the common Property ID of data sharing of service release, and the professional Property ID of definition offers service release; Service release is obtained the corresponding business property value according to said Property ID, and this service attribute value is passed to Complex interface.

CRM is exactly that service and attribute with needs adds in the message template that has had to the fundamental purpose of service release.Relation through table or_svcgrouprel_dict, or_groupprorel_dict, or_DataSource_dict, or_DataDef_dict finds corresponding obtaining value method, carries out value then and is filled in the template and gets final product.

Be the template blank before the configuration below:

Supposing to require now configuration service (svc_id) is S00001, and action (action_id) is open an account (1000), and attribute is KI (supposing to require the value of KI is 123), and so through configuration, program will obtain following template blank after carrying out:

Below, the configuration of configurations table is described one by one.

1, the configuration of table or_svcgrouprel_dict

Comprise field SVC_TYPE, SVC_ID, ACTION_ID, GROUP_ID, OP_TIME among the table or_svcgrouprel_dict.

Wherein, field SVC_TYPE marks COS, is divided into O (Additional Services) and M (main service), here can be through select*from pd_svc_dict where svc_id=' service ID ' go to inquire COS;

Wherein, field SVC_ID marks service ID, and this field obtains in parameterized template, such as the SVC_ID that will obtain returning short message now, can check that in parameterized template obtaining SVC_ID is BS1209;

Wherein, field ACTION_ID marks action, here if main service can inquire about through select*from pd_action_dict; If Additional Services can be inquired about through select*from or_subsvcact_dict, field sub_svc_id is 0,1 in the Query Result here; 2,3,4; 8, corresponding relation be 1 order, 0 quit the subscription of, 2 suspend, 3 suspend recover, 4 changes, 8 other, (have only two action_id in the Additional Services; Be respectively 99999 and 99998), remove the ACTION_ID in the corresponding look-up table according to the ACTION in the parameterized template then, such as the corresponding ACTION_ID that opens an account is 1000;

Wherein, Field GROUP_ID mark group is the set together of several attributes, needs oneself definition here, and its value can be arbitrarily; Unique requirement is not exist at table or_svcgrouprel_dict; At first can go inquiry through or_svcgrouprel_dict, look for then one not used, give GROUP_ID this value.

Wherein, field OP_TIME is a system time.

For example, suppose to want configuration service school letter logical, action is to open an account, and can obtain following INSERT statement through above explanation:

2, the configuration of table or_groupprorel_dict

Comprise field GROUP_ID, PROPERTY_ID, PROPERTY_NAME, PROPERTY_NEW_VALUE, PROPERTY_OLD_VALUE, SERIAL_NO, PROPERTY_NUM, OP_TIME among the table or_groupprorel_dict.

Wherein, field GROUP_ID marks service groups, and this field disposes in table or_svcgrouprel_dict;

Wherein, Field PROPERTY_ID marks Property ID, and this field needs configuration, will confirm at first which value shows or_groupprorel_dict has existed; The configuration this field value can not with already present value repetition; It is noted that in addition that if this attribute exists that just needs multiplexing original PROPERTY_ID.For example: through SQL:select*from or_groupprorel_dict where property_name=PHONE_NO ', can inquire this attribute of PHONE_NO and exist, be 8400517, so just can use original configuration; Equally,, can find out a Property ID, confirm through query statement whether this value exists then through inquiry if this attribute does not exist.For example: in table or_groupprorel_dict, confirm property_id=123, can whether use through the value of following statement select*from or_groupprorel_dict where property_id=123 property_id=123 then.

Wherein, field PROPERTY_NAME is used for marking attribute-name, and this is in the parameter configuration document and exists, and promptly is listed as the PHONE_NO in " INSTCON ", and BIZCODE is called attribute;

Wherein, field PROPERTY_NEW_VALUE, new, the old value of PROPERTY_OLD_VALUE attribute; Need definition here; Their value can be arbitrarily, and unique requirement is not exist at table or_groupprorel_dict, at first can go inquiry through or_groupprorel_dict; Look for respectively then one not used, compose this value respectively and to give PROPERTY_NEW_VALUE, PROPERTY_OLD_VALUE.

Wherein, field SERIAL_NO is used for marking attribute number, is exactly to number for the interior all attributes of group in order here;

Wherein, field PROPERTY_NUM mark attribute number, value is represented the number of all properties here;

Wherein, field OP_TIME is a system time.

Data_id in PROPERTY_NEW_VALUE among the table or_groupprorel_dict, the corresponding or_datadef_dict table of PROPERTY_OLD_VALUE.

For example, suppose to want configuration service school letter logical, can obtain following INSERT statement through above explanation:

Because this attribute of PHONE_NO exists, and through confirming that the obtaining value method that exists can be multiplexing, so to PROPERTY_NEW_VALUE, the assignment of PROPERTY_OLD_VALUE is with original the same.

3, the configuration of table or_DataDef_dict

Comprise field DATA_ID, DATA_NAME, DATASOURCE_ID, DATA_TYPE, DAFAULT_VALUE, DATA_LENGTH among the table or_svcgrouprel_dict.

Wherein, Field DATA_ID; Value if perperty_new_value is identical with perperty_old_value, only needs configuration once just can with perperty_new_value or perperty_old_value among the table OR_GROUPPROREL_DICT here here;

Wherein, field DATA_NAME, value is the perperty_name among the table OR_GROUPPROREL_DICT here;

Wherein, field DATASOURCE_ID, oneself definition here, require among the or_datasource_dict datasource_id not with redetermination repeat get final product, all be configured to the value of datasource_id identical generally speaking with DATA_ID;

Wherein, field DATA_TYPE comprises int, long, date, string, func, and the type that promptly marks the value of taking out in the OR_DATASOURCE_DICT table is identical;

Wherein, field DAFAULT_VALUE, these two fields of DATA_LENGTH are not temporarily used, and fill out NULL and get final product.

For example, suppose to want configuration service school letter logical, action is to open an account, and can obtain following INSERT statement through above explanation:

4, the configuration of table or_DataSource_dict

Comprise field DATASOURCE_ID, SRC_TYPE, DATA_EXP, RSLT_ID, RLST_TYPE, PARAM_ID, PARAM_TYPE among the table or_DataSource_dict.

Wherein, field DATASOURCE_ID, field is with the DATASOURCE_ID among the or_DataDef_dict here;

Wherein, field SRC_TYPE, value is 1-4 here, concrete implication is following:

1 expression is directly obtained from uType according to message;

2 expressions value of obtaining from the sql statement;

3 expressions are a kind of to be to obtain through pointer with * beginning, and a kind of is definite value, for example 03;

4 representative functions;

Wherein, field DATA_EXP, mostly definition value is sql and definite value here, concrete and top SRC_TYPE corresponding relation is following:

1 expression is directly obtained from uType according to message--want the field of value in the-corresponding message;

2 expressions value of obtaining----from the sql statement needs product that obtaining value method is provided here;

3 expressions are a kind of to be to obtain through pointer with * beginning, and a kind of is definite value, for example 03;

4 representative functions---respective function name;

Illustrate:

Example 1:datasource_id=' 100 ' data_exp=' ID_NO ' src_type=' 1 ' expression 100 is through the uType ID_NO value of obtaining

Example 2:datasource=' 112 ', the value of data_exp=' * $ (122) $ ' src_type=' 3 ' expression 112 through data source 122 obtain again that value tax gives 112

Example 3:

Through the expression formula value of obtaining, the change in the expression formula need be through this mode of $ () the $ value of obtaining.

Wherein, field DATA_TYPE comprises int, long, date, string, func;

Wherein, field DAFAULT_VALUE, these two fields of DATA_LENGTH are not temporarily used, and fill out NULL and get final product.

For example, suppose to want configuration service school letter logical, action is to open an account, and can obtain following INSERT statement (here defined attribute PHONE_NO, because its obtaining value method has existed and we confirm it is can be multiplexing) again through above explanation:

Through above configuration instruction, can obtain following SQL statement to four configurations tables:

In the process of service release data, often can only not dispose an action at actual disposition CRM, be to need a plurality of actions of configuration generally speaking, such as ordering, quit the subscription of, open an account, sell in advance, selling in advance and recover or the like.Collocation method is with top the same; But their obtaining value method is different when being a plurality of action, is different such as the obtaining value method of ordering with the attribute ENDTIME_TEST that pin is corresponding in advance, and difference is to order and quits the subscription of is to be deposited into history lists to value; If will get less than value with the same of order in the time of the obtaining value method of the definition attribute that pin is corresponding in advance; Get at main schedule because sell value in advance, just need write a corresponding relation again for these four configurations tables more according to top method for this situation; Two kinds of corresponding relations so just can be arranged; A kind ofly fetch data at history lists, a kind ofly in addition fetch data at main schedule, so no matter corresponding which kind of action can the value of getting.

For example, suppose to want configuration service school letter logical, action is to open an account, sell in advance, sell in advance and recover; Can confirm that according to aforesaid collocation method the corresponding ACTION_ID of these actions is 99999 and 99998; Said above because these actions will be in history lists and main schedule value, therefore to define two kinds of obtaining value methods; In order to define two kinds of different obtaining value methods; And these two kinds of obtaining value methods are same services, thus corresponding two kinds of action definitions two groups, the insert statement that inserts table OR_SVCGROUPREL_DICT is following:

Disposed two groups above, can be corresponding to these two groups respectively according to aforesaid method allocation list or_groupprorel_dict, or_DataDef_dict is following:

------21067 groups

-----21068 groups

------21067 groups

-----21068 groups

Dispose obtaining value method below, through confirming that as product to obtain the expression formula of getting main schedule of data_exp following:

=" U ", for example the history lists of top table pd_userprc_info_$ (100 ,-1,2) $ is pd_userprc_info_his_$ (100 ,-1,2) $, so it is following to obtain expression formula:

Because ordering respective action is 99999, and the corresponding group of this action is 21067, can obtain datasource_id by that analogy and be 3521 fetch data at history lists, so it is following to insert the predicative sentence:

To the configuration of above-mentioned four configurations tables, should be noted that following some:

1, general configuration is picked up from the source, at first allocation list or_svcgrouprel_dict;

2, service release message parameter acquiring, the most basic inlet is: service (svc_id)+action (action_id);

3, svc_id+action_id → group_id (table or_svcgrouprel_dict realizes this configuration, service+action here can corresponding a plurality of parameter group);

4, (table or_groupprorel_dict realizes this configuration to group_id → property_id+property_old_value+property_new_value; Group can a corresponding N attribute here; In conjunction with top table, each service+action can be confirmed N the parameter that service release is required);

5, property_new_value/property_old_value=or_datadef_dict.da ta_id (table or_datadef_dict has disposed property_old_value and property_new_value value in the top table);

6, data_id → datasource_id (or_datadef_dict has disposed the corresponding data source id:datasource_id of data_id);

7, datasource_id → data value (or_datasource_dict has disposed the obtaining value method of data source);

8, to above-mentioned 4 configurations tables, can establish an excel form earlier, after desired data collection arrangement is finished, produce the sql script according to the excel form.

Under normal conditions, data_exp is the sql statement in the or_datasource_dict table, will introduce through the group value below by way of example, get the collocation method of definite value.

For example, dispose main service enterprise all-purpose card, SVC_ID=' BSJ111 ' can order, quits the subscription of, sell in advance, and attribute has SERVICELEVELID, EFFTTIME, ENDTIME, EXT_YKTKQ_ADMINPHONE.EFFTTIME, ENDTIME can use original, and SERVICELEVELID gets definite value 0.

At first can to inquire corresponding action ID be 1000,1052 to select*from pd_action_dict, 1055; Finding two not used GROUP_ID through inquiry is 20123 and 20124; Introduced aforementioned, and ordered and quit the subscription of and in history lists, to fetch data, so action 1000 and 1055 corresponding groups; Sell corresponding another one group in advance, so can dispose as follows:

Insert?into?OR_SVCGROUPREL_DICT(SVC_TYPE，SVC_ID，ACTION_ID，GROUP_ID，OP_TIME，OP_NOTE)Values(′M′，′BSJ111′，1000，20109，sysdate，NULL)；

Insert?into?OR_SVCGROUPREL_DICT(SVC_TYPE，SVC_ID，ACTION_ID，GROUP_ID，OP_TIME，OP_NOTE)Values(′M′，′BSJ111′，1055，20109，sysdate，NULL)；

Insert?into?OR_SVCGROUPREL_DICT(SVC_TYPE，SVC_ID，ACTION_ID，GROUP_ID，OP_TIME，OP_NOTE)Values(′M′，′BSJ111′，1052，20110，sysdate，NULL)；

Need to prove that general configuration custom all is that the odd number correspondence is in the history lists value.

Following allocation list OR_GROUPPROREL_DICT at first confirms attribute EFFTTIME, ENDTIME through inquiry OR_GROUPPROREL_DICT table with to the people of product; Can use original the definition; So can confirm that the property_new_value of EFFTTIME, ENDTIME is identical with property_old_value and be respectively 249 and 251, there is 249 and 251 definition in question blank or_datadef_dict in the confirmation form then; But in table or_datasource_dict, but there is not 251 obtaining value method; Here just caused the notion of group, when working as identical can once taking-up of obtaining value method of two attributes in other words, just can be defined in one in an obtaining value method through the group value; Inquire about through his-and-hers watches select*from or_DataGroup_rel; Obtaining the corresponding relation that 249-251 exists group, is 249 and 251 so can confirm their new and old value, and configuration is as follows:

-----20109 groups

-----20110 groups

To above-mentioned statement, need to prove that the obtaining value method of group is not in daily use; But arouse attention; And if only occur 251 and do not occur 249, and so just can not use the method for group value, can only give 251 to define an obtaining value method again or come value with other implementation method; In 20110 groups; PROPERTY_NEW_VALUE and PROPERTY_OLD_VALUE that attribute ' SERVICELEVELID ' is corresponding are 2559; With 20109 groups in ' the new and old value of SERVICELEVELID ' attribute is identical; This is because what know that attribute ' SERVICELEVELID ' gets is definite value, so just need not distinguish in history lists value and main schedule value, and their obtaining value method and datadef show can be identical.

Come allocation list or_datadef_dict below and since attribute EFFTTIME, ENDTIME_TEST multiplexing definition originally, so here just needn't define they two, dispose as follows:

-----20109 groups

-----20110 groups

Come allocation list or_datasource_dict below, what should be noted that here that attribute ' SERVICELEVELID ' gets is definite value, configuration as follows:

----20109 groups fetched data from the dataSource table

----20110 groups fetched data from the dataSource table

Annotate: obtaining value method:

In the above-mentioned statement, condition id_no=" $ (100) $ " and svc_id=" $ (109) $ ", $ (100) $ just is equivalent to the obtaining value method that calls datasource_id=100 in fact here, and $ (109) $ is equivalent to the obtaining value method that calls datasource_id=109.

Should be noted that following some:

1, the data source value of some variablees commonly used is following:

User id_no obtains with $ (100) $,

Operation flowing water update_accept obtains with (103),

Main body service MAIN_SVC_ID obtains with $ (109) $,

Additional Services ID obtains with $ (114) $,

Customer ID cust_id obtains with $ (115) $,

Service area REGION_ID obtains with $ (104) $,

Operator's job number LOGIN_NO obtains with (126),

Service number SERVICE_NO obtains with $ (125) $,

2, variable replacement symbol () can be according to variable-value intercepting character string as a result, and method of application: (len), usage is with the substr method of oracle for data, loc.For example (100 ,-1,2) expression since 100 these data source values as a result 2 .100 data sources of last 1 intercepting left value character string of character string be user's id_no, promptly be last two of intercepting id_no here;

3, skilful use UE row pattern is write SQL configuration statement in batches;

When 4, using the result set pattern to obtain the data source value, i.e. or_datasource_dict.rslt_type=2, for example 249 and 251 two data sources get access to through the data_exp of 249 1 data sources.Then this moment, 251 value just depended on 249, if 249 these data sources do not use in service configuration, and so 251 can the value of getting yet.Because data source does not have value inlet, says with these data not inside the metadata cache;

When 5, using the result set pattern to obtain the data source value, when being empty, can exert an influence to whole data set result as if a certain train value that takes out.The method of eliminating the effects of the act: can add nvl (column_x, chr (0)) by empty row.Source_id=3990 for example:

6, because the data source value is used cache way, so if if the data_exp in the or_datasource_dict table has renewal, need flush buffers, method is to upgrade the or_templet_dict.valid row.Whether program can compare the valid value when getting into has renewal, if having, then can get the or_datasource_dict table again and put into chained list.

Upgrade statement:

UPDATE?or_templet_dict

SET?valid＝TO_CHAR(MOD(TO_NUMBER(valid)+1，10))

7, in general, a service can configuration two be overlapped group_id, and corresponding attribute business datum value is respectively from history lists value and master meter value; Parameter I MSI value such as main service S00001; Change of product 1104 values, from user's master meter ur_usersim_info value, cancellation then need be gone user's history lists ur_usersim_info_his value of reaching; Because after the cancellation, user's business datum all can change history lists over to.For example, for two kinds of obtaining value methods of IMSI, define two set of properties to it: 20014 and 20013.

8, in or_svcgrouprel_dict table about the action_id of Additional Services. In this table the inside; The value that the action_id of Additional Services does not use input parameter to transmit; But have two 99999/99998, and in or_svcgrouprel_dict the set of properties of 99999 configurations from the history lists value, be the set of properties of 99998 configurations from the master meter value.For example: select*from or_svcgrouprel_dict where svc_id=' BS1002 '.

The verification of data can be adopted following steps:

1, whether have unusual according to following statement verification:

2, the first step: verify the OL_STATUS field according to order number or capable number inquiry of order sequence information:

Select*from?or_orderline_info?WHERE?order_line_id＝′L1210012600000014′；

Master meter does not have record, and the expression order has been brought to completion into history

Select*from?or_ordline_info_201001?WHERE?order_line_id＝′L2210012700000028′；

＜13 do not go to service release as yet, and request helps order group related personnel problem identificatioin place

=13 services are treated open-minded, and the reason majority that runs into this situation at present is order to occur to wait for, i.e. this order front still untreated order of existence or existence is unusual, please carry out for second step

In=14 service releases

＞14 service releases finish, and please directly carry out for the 3rd step

3, second step:, please check whether the order of wait or unusual is arranged if order status is 13:

Wait for order:

Unusual order:

SELECT*

FROM?or_ordlineexcp_info

WHERE?order_line_id＝′L2210041500000021′

Check excp_reason and the error message of err_msg field description, according to miscue information inspection allocation list data, orientation problem reason.

Common abnormal has:

Call the failure of service release function:

The service that [if_Exception|30000|30000|fillUtype.

returns-1 unusually]----this mistake normally need not sent service release does not have configuration to cause; Can be according to the service ID of order; To table 1or_ordlinedisprelse_dict (whether control sends service release), whether the affirmation business needs to send.

The statement mistake of data source.

4, the 3rd step: check whether message data is correct

select*from?spmswOrderTaskLog0004where?crm_order_id＝′L2210012700000028′

--current table, this shows last position is last position of id_no.

select*from?SPMSWORDERTASKLOGHIS201004?where?crm_order_id＝′L2210012700000028′

--history lists.By carrying out submeter days

If data are gone into history and fields configured all in message, please the contact service personnel of opening check whether success, if some field forwarded for the 4th step to not in message,, current table data please not get in touch Complex interface if going into history.

5, the 4th step: check whether obtaining value method can the value of getting

Compare according to message and the attribute that oneself disposes; If lack certain attribute, that just goes or_grouprel_dict to go to search the new and old value of this attribute, and then removes to inquire about obtaining value method; See that can obtaining value method the value of getting, if the value of not getting is not confirmed with regard to the people who gets in touch product.

Customer relation management of the present invention is to the collocation method of service release, reduced the workload of CRM in the configuration of service release, practiced thrift setup time, improved allocative efficiency.And customer relation management of the present invention is of value to quick opening to the collocation method of service release, and can not cause the conflict of database.

The invention allows for the configuration-system of a kind of customer relation management, in order to implement the collocation method of above-mentioned customer relation management to service release to service release.

Fig. 2 be in the embodiment of the invention customer relation management to the structural drawing of the configuration-system of service release.As shown in Figure 2, in the present embodiment, customer relation management can comprise read module 210, acquisition module 220, enquiry module 230 and assembling module 240 to the inking device 200 of service release.Read module 210 is used to read the class of excel, obtains deploy content relevant with business among the excel.Acquisition module 220 is used for obtaining database connection string through reading configuration file.Enquiry module 230 is used to connect database, and the data of needs are inquired about.Assembling module 240 is used for splicing structure query language SQL statement, through the C++ container output is sorted.

In the embodiment of the invention, customer relation management can also comprise calling module, monitor module, Complex interface application integration platform, service release and form ordering system to the configuration-system of service release.Wherein, calling module is used for triggering the calling interface function according to order.Monitor module and be used for transmission service release process at form ordering system; The capable trigger table of order is monitored in scanning; Obtain the capable state of order for service order to be opened is capable, call service release transmission function and carry out the message assembly unit, and the message data that assembly unit is good is charged to service release interface table.The Complex interface application integration platform is used for obtaining message data and sending to service release from service release interface table.Service release is used to handle message data and result is fed back to customer relation management CRM, and detached process scanning the other side interface table is given order relevant interface table with data transfer; Form ordering system is used to handle the data of order relevant interface table, continues the circulation order.

In the embodiment of the invention, customer relation management can also comprise packing module to the configuration-system of service release.Packing module is used for the service action that the configure base allocation list is required, attribute and attribute value mode information and is filled in the GetSql.xls file.

In the embodiment of the invention, customer relation management can also comprise Complex interface and definition module to the configuration-system of service release.Form ordering system also is used to call the external interface function of CRM to service release.The interface table copy data that Complex interface is used for from CRM to the service release is given service release, and makes CRM go into history to the interface data of service release.The data of service release and CRM are to the common Property ID of data sharing of service release, and definition module is used to define professional Property ID and offers service release.Service release also is used for obtaining the corresponding business property value according to Property ID, and this service attribute value is passed to Complex interface.

Customer relation management of the present invention can carry out the collocation method of aforesaid customer relation management to service release to the configuration-system of service release, reduced the workload of CRM in the configuration of service release, practiced thrift setup time, improved allocative efficiency.And the collocation method of customer relation management of the present invention to the performed customer relation management of the configuration-system of service release to service release is of value to quick opening, and can not causes the conflict of database.

The above is merely preferred embodiment of the present invention, and is in order to restriction the present invention, not all within spirit of the present invention and principle, any modification of being done, is equal to replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (10)

1. a customer relation management is characterized in that to the collocation method of service release, comprising:

Read the class of excel, obtain deploy content relevant among the excel with business;

Obtain database connection string through reading configuration file;

Connect database, the data of needs are inquired about;

Splicing structure query language SQL statement sorts to output through the C++ container.

2. customer relation management according to claim 1 is characterized in that to the collocation method of service release, also comprises:

Trigger the calling interface function according to order;

In the transmission service release process of form ordering system; The capable trigger table of order is monitored in scanning; Obtain the capable state of order for service order to be opened is capable, call service release transmission function and carry out the message assembly unit, and the message data that assembly unit is good is charged to service release interface table;

The Complex interface application integration platform obtains message data and sends to service release from said service release interface table;

Service release is handled message data and result is fed back to customer relation management CRM, and detached process scanning the other side interface table is given order relevant interface table with data transfer;

Form ordering system is handled the data of said order relevant interface table, continues the circulation order.

3. customer relation management according to claim 2 is characterized in that to the collocation method of service release said order relevant interface table comprises successfully feedback form and failure feedback form.

4. customer relation management according to claim 1 is characterized in that to the collocation method of service release, also comprises:

The service action that the configure base allocation list is required, attribute and attribute value mode information are filled in the GetSql.xls file.

5. customer relation management according to claim 2 is characterized in that to the collocation method of service release, also comprises:

Form ordering system calls the external interface function of CRM to service release;

The interface table copy data of Complex interface from CRM to the service release given service release, and makes CRM go into history to the interface data of service release;

Service release data and CRM are to the common Property ID of data sharing of service release, and the professional Property ID of definition offers service release;

Service release is obtained the corresponding business property value according to said Property ID, and this service attribute value is passed to Complex interface.

6. a customer relation management is characterized in that to the configuration-system of service release, comprises the read module, acquisition module, enquiry module and the assembling module that link to each other successively, wherein:

Said read module is used to read the class of excel, obtains deploy content relevant with business among the excel;

Said acquisition module is used for obtaining database connection string through reading configuration file;

Said enquiry module is used to connect database, and the data of needs are inquired about;

Said assembling module is used for splicing structure query language SQL statement, through the C++ container output is sorted.

7. customer relation management according to claim 1 is characterized in that to the configuration-system of service release, also comprises:

Calling module is used for triggering the calling interface function according to order;

Monitor module; Be used for the transmission service release process at form ordering system, the capable trigger table of order is monitored in scanning, and it is capable for service order to be opened to obtain the capable state of order; Call service release transmission function and carry out the message assembly unit, and the message data that assembly unit is good is charged to service release interface table;

The Complex interface application integration platform is used for obtaining message data and sending to service release from said service release interface table;

Service release is used to handle message data and result is fed back to customer relation management CRM, and detached process scanning the other side interface table is given order relevant interface table with data transfer;

Form ordering system is used to handle the data of said order relevant interface table, continues the circulation order.

8. customer relation management according to claim 7 is characterized in that to the configuration-system of service release said order relevant interface table comprises successfully feedback form and failure feedback form.

9. customer relation management according to claim 7 is characterized in that to the configuration-system of service release, also comprises:

Packing module is used for the service action that the configure base allocation list is required, attribute and attribute value mode information and is filled in the GetSql.xls file.

10. customer relation management according to claim 7 is characterized in that to the configuration-system of service release, also comprises:

Said form ordering system also is used to call the external interface function of CRM to service release;

Complex interface, the interface table copy data that is used for from CRM to the service release is given service release, and makes CRM go into history to the interface data of service release;

Definition module, the data of said service release and CRM are to the common Property ID of data sharing of service release, and said definition module is used to define professional Property ID and offers service release;

Said service release also is used for obtaining the corresponding business property value according to said Property ID, and this service attribute value is passed to said Complex interface.

Images