Centric CRM Sample Data Install

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
 
第1行: 第1行:
 
[allen@centos Centric_CRM_Sample_Data_41]$ ./demoDataInstaller.bsh postgresql centric_crm postgres postgres
 
[allen@centos Centric_CRM_Sample_Data_41]$ ./demoDataInstaller.bsh postgresql centric_crm postgres postgres
Getting a database connection...
+
Getting a database connection...
Inserting sample CRM data...
+
Inserting sample CRM data...
DemoData-> Installing data
+
DemoData-> Installing data
Contact-> ContactID: 2
+
Contact-> ContactID: 2
User-> Beginning insert
+
User-> Beginning insert
User-> Getting interval value
+
User-> Getting interval value
User-> Updating contact
+
User-> Updating contact
User-> User inserted & contact record updated
+
User-> User inserted & contact record updated
Contact-> ContactID: 3
+
Contact-> ContactID: 3
User-> Beginning insert
+
User-> Beginning insert
User-> Getting interval value
+
User-> Getting interval value
User-> Updating contact
+
User-> Updating contact
User-> User inserted & contact record updated
+
User-> User inserted & contact record updated
Contact-> ContactID: 4
+
Contact-> ContactID: 4
User-> Beginning insert
+
User-> Beginning insert
User-> Getting interval value
+
User-> Getting interval value
User-> Updating contact
+
User-> Updating contact
User-> User inserted & contact record updated
+
User-> User inserted & contact record updated
Contact-> ContactID: 5
+
Contact-> ContactID: 5
User-> Beginning insert
+
User-> Beginning insert
User-> Getting interval value
+
User-> Getting interval value
User-> Updating contact
+
User-> Updating contact
User-> User inserted & contact record updated
+
User-> User inserted & contact record updated
Contact-> ContactID: 6
+
Contact-> ContactID: 6
Contact-> Built contact type: contact/6 type/13 Executive
+
Contact-> Built contact type: contact/6 type/13 Executive
Opportunity-> Close prob: 33
+
Opportunity-> Close prob: 33
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.33
+
Opportunity-> Close Prob: 0.33
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.33
+
Opportunity-> Close Prob: 0.33
Opportunity-> Close prob: 50
+
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Contact-> Built contact type: contact/6 type/13 Executive
+
Contact-> Built contact type: contact/6 type/13 Executive
Contact-> Built contact type: contact/6 type/13 Executive
+
Contact-> Built contact type: contact/6 type/13 Executive
Contact-> ContactID: 7
+
Contact-> ContactID: 7
Contact-> ContactID: 8
+
Contact-> ContactID: 8
Contact-> ContactID: 9
+
Contact-> ContactID: 9
Contact-> ContactID: 10
+
Contact-> ContactID: 10
Contact-> ContactID: 11
+
Contact-> ContactID: 11
Contact-> Built contact type: contact/11 type/13 Executive
+
Contact-> Built contact type: contact/11 type/13 Executive
Opportunity-> Close prob: 80
+
Opportunity-> Close prob: 80
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.8
+
Opportunity-> Close Prob: 0.8
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.8
+
Opportunity-> Close Prob: 0.8
Contact-> ContactID: 12
+
Contact-> ContactID: 12
Contact-> ContactID: 13
+
Contact-> ContactID: 13
Opportunity-> Close prob: 85
+
Opportunity-> Close prob: 85
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.85
+
Opportunity-> Close Prob: 0.85
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.85
+
Opportunity-> Close Prob: 0.85
Opportunity-> Close prob: 40
+
Opportunity-> Close prob: 40
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.4
+
Opportunity-> Close Prob: 0.4
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.4
+
Opportunity-> Close Prob: 0.4
Contact-> ContactID: 14
+
Contact-> ContactID: 14
Opportunity-> Close prob: 33
+
Opportunity-> Close prob: 33
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.33
+
Opportunity-> Close Prob: 0.33
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.33
+
Opportunity-> Close Prob: 0.33
Opportunity-> Close prob: 25
+
Opportunity-> Close prob: 25
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.25
+
Opportunity-> Close Prob: 0.25
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.25
+
Opportunity-> Close Prob: 0.25
Contact-> ContactID: 15
+
Contact-> ContactID: 15
Contact-> ContactID: 16
+
Contact-> ContactID: 16
Opportunity-> Close prob: 50
+
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity-> Close prob: 50
+
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity-> Close prob: 50
+
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity-> Close prob: 95
+
Opportunity-> Close prob: 95
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.95
+
Opportunity-> Close Prob: 0.95
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.95
+
Opportunity-> Close Prob: 0.95
Contact-> ContactID: 17
+
Contact-> ContactID: 17
Contact-> Built contact type: contact/17 type/1 Acquaintance
+
Contact-> Built contact type: contact/17 type/1 Acquaintance
Contact-> Built contact type: contact/17 type/1 Acquaintance
+
Contact-> Built contact type: contact/17 type/1 Acquaintance
Contact-> Built contact type: contact/17 type/1 Acquaintance
+
Contact-> Built contact type: contact/17 type/1 Acquaintance
Contact-> Built contact type: contact/17 type/1 Acquaintance
+
Contact-> Built contact type: contact/17 type/1 Acquaintance
Opportunity-> Close prob: 50
+
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity-> Close prob: 50
+
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
+
Opportunity-> Close Prob: 0.5
Contact-> ContactID: 18
+
Contact-> ContactID: 18
Contact-> ContactID: 19
+
Contact-> ContactID: 19
Contact-> ContactID: 20
+
Contact-> ContactID: 20
Contact-> ContactID: 21
+
Contact-> ContactID: 21
Contact-> ContactID: 22
+
Contact-> ContactID: 22
Opportunity-> Close prob: 80
+
Opportunity-> Close prob: 80
Opportunity Component-> Updating the opportunity component
+
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.8
+
Opportunity-> Close Prob: 0.8
Opportunity Component-> ResultCount: 1
+
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
+
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.8
+
Opportunity-> Close Prob: 0.8
Contact-> ContactID: 23
+
Contact-> ContactID: 23
Contact-> ContactID: 24
+
Contact-> ContactID: 24
Contact-> ContactID: 25
+
Contact-> ContactID: 25
*************************************************************
+
*************************************************************
+
  Username: [email protected]
Password: password
+
  Password: password
*************************************************************
+
*************************************************************
Data inserted.
+
Data inserted.
[1]+  Done                    gedit demoDataInstaller.bsh
+

2007年9月1日 (六) 00:35的版本

[allen@centos Centric_CRM_Sample_Data_41]$ ./demoDataInstaller.bsh postgresql centric_crm postgres postgres

Getting a database connection...
Inserting sample CRM data...
DemoData-> Installing data
Contact-> ContactID: 2
User-> Beginning insert
User-> Getting interval value
User-> Updating contact
User-> User inserted & contact record updated
Contact-> ContactID: 3
User-> Beginning insert
User-> Getting interval value
User-> Updating contact
User-> User inserted & contact record updated
Contact-> ContactID: 4
User-> Beginning insert
User-> Getting interval value
User-> Updating contact
User-> User inserted & contact record updated
Contact-> ContactID: 5
User-> Beginning insert
User-> Getting interval value
User-> Updating contact
User-> User inserted & contact record updated
Contact-> ContactID: 6
Contact-> Built contact type: contact/6 type/13 Executive
Opportunity-> Close prob: 33
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.33
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.33
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
Contact-> Built contact type: contact/6 type/13 Executive
Contact-> Built contact type: contact/6 type/13 Executive
Contact-> ContactID: 7
Contact-> ContactID: 8
Contact-> ContactID: 9
Contact-> ContactID: 10
Contact-> ContactID: 11
Contact-> Built contact type: contact/11 type/13 Executive
Opportunity-> Close prob: 80
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.8
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.8
Contact-> ContactID: 12
Contact-> ContactID: 13
Opportunity-> Close prob: 85
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.85
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.85
Opportunity-> Close prob: 40
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.4
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.4
Contact-> ContactID: 14
Opportunity-> Close prob: 33
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.33
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.33
Opportunity-> Close prob: 25
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.25
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.25
Contact-> ContactID: 15
Contact-> ContactID: 16
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
Opportunity-> Close prob: 95
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.95
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.95
Contact-> ContactID: 17
Contact-> Built contact type: contact/17 type/1 Acquaintance
Contact-> Built contact type: contact/17 type/1 Acquaintance
Contact-> Built contact type: contact/17 type/1 Acquaintance
Contact-> Built contact type: contact/17 type/1 Acquaintance
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
Opportunity-> Close prob: 50
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.5
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.5
Contact-> ContactID: 18
Contact-> ContactID: 19
Contact-> ContactID: 20
Contact-> ContactID: 21
Contact-> ContactID: 22
Opportunity-> Close prob: 80
Opportunity Component-> Updating the opportunity component
Opportunity-> Close Prob: 0.8
Opportunity Component-> ResultCount: 1
OpportunityComponent-> Adding Component Log Entry
Opportunity-> Close Prob: 0.8
Contact-> ContactID: 23
Contact-> ContactID: 24
Contact-> ContactID: 25
*************************************************************
 Username: [email protected]
 Password: password
*************************************************************
Data inserted.
分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱