Steps | Screen shots | Description |
1 | Path: Pivotal Toolkit -> Tables -> QuickFind Create Find Now to open current design of table ![-00 - 0 > 一 d
一 q21 •.pu!-JV!nO
V'lHOßWAld](https://lh4.googleusercontent.com/Z4d80sjiBNKBuaQafwM8XVdIlCf9rZyNx6fyukCzw5xS_doToGICP0INmffLk-zqpgq3SVAiQb0VnWRSiVa19T5I_Rht4DOsZ3GBOHxw2g1knyn-dayWK4VGskGl3XHwupgLnCSSb4E8xy13aO08ve2__95aRupY8u35_KjRbqx7uKn0FRZgy7oJI0Ze7KMbSs2C2g)
| Following the path to open table design |
2 | ![Table -
Type T,ble
LO string
P ads link to t*le
I Lists I I Display I
15
120
60](https://lh5.googleusercontent.com/xwLeQrVw7lVQDJCgsO54rsbo_mtDzn32dRmh8RbWcqP7jrYYs6DHlCwD-1hhHwZpJl9mUuy2LNsuWB41gYLHS-mJ-1-oyJGgENvjBKSKDYy7IEroTw08mRwcEhuqN7_covmok-pdRVbkZWylEgnrKx3qTxoJfRbDCZpeCJjN8_U594wTLvvt_xScP1oRiHGjW597tw)
| Click new field and add new fields into table |
3 | ![ON¯OWJapy¯7B•Pl-•ysmqeL
! ; 101](https://lh3.googleusercontent.com/O9jSuvWZvrla299VwTDrtkEjv91gmpR_QVXyF5ENyyDtnVf5fMD1xJGQBfRlUPctsCzg012T7fZHrJBG0vE1lrZyawsDU2ELI1VjDCn7ZqHRNAqUwCgiWYLQVSeQ24Atj36G9gUu7Sd1DgiDx4HTo5FKiGvq_XxDJEeu5iSep87EsDHAGyWlGWqrxdxsRTwu3sDtMg)
![Eiéds Lats I I Display I I
d Birth
code](https://lh5.googleusercontent.com/-QIbWclm2wQ4g9i6jropu2kbSbB6JuxmeCo95zc9_fAnwRG_CJMyK8cOWVIj1JpVfoMJIlNEPjml609NZhB2y0ree3EYs-L4lbJEwf49Lju17YvPmjyH4IvN7NU_ZjKSuvIl5lG0g6G5hROFtHEzIejZBFJ6Y7aLCVxiGd6Y7XvaCNXr5S3ibx9A-ModfAG-gt9_qg)
| Create new custom field. For this example, we will create a field with the type Text 50: Rc_Reference_No. And the comments is: "This field will reocrd the Work Ready Compliance Reference Number" |
4 | ![](https://lh3.googleusercontent.com/q9_pe63rqUEqPUkVYLfmR526sBejcIAJjCOpoeGIJIPTWnsMuELlIuCT_A2goLizn5pc-EeRYu3sPDWeQcIoHOf7ZOVYmrMH79NGHEj9tn9aLKpbaxk3kvBUxNLv862lho5z3sbnXtMjJWaA-ceZm9eHqQ1QV-lLCEnq9ZdLpUlv9aqzuK6N9FpH82H46Q60ZGjtRA)
| Open Pivotal Administration Console |
5 | ![:JOAW5-
MAVISJL](https://lh5.googleusercontent.com/9iRNERW-d4_I7EWKFItGu2BeZyHK-LCs6H7X7GgN2W_qf_N6FAnORW_wmUt7xMdDc9B4O8FklSPWUjm_KuSu7DNMFzjAuUwyPyv1F48KtYSkoG_AAPbkfuj8_rbBhgtnGfeCeCtg4nQn4GVgtCXcEv6hLQicqnaDnNErDKtrYTgyKKq0Ce2AAwh6X-e7jF89l4izKw)
| Select Data Synchronization and select environment then right click and select Audit Synchronization |
6 | ![](https://lh6.googleusercontent.com/BPnp6xFo-4ghL5mkj-Tn4N2MAd-o1QOfMb2HlrnWWABrZ6oyglfdmIno-u7BZZHmNU1tfvyDpNn88cR5ZtlOOo9XGyvWz4noPnGVnqtongdIp1HWGAzAiTkXBhNLjz3r5XZa1najFYQ4l2yBjncIlPCnpT1KP9ie6ljbW1RCR6iLrpE1rhr55JV1X1s71y6mfZBXpA)
Noted: You can see some modifier from another member of the team, should contact them to make sure all change is okay.
| Click Ok to applied change and process it. |
7 | ![](https://lh5.googleusercontent.com/YQMJb1UGwRQR0wpu6GPijLR8p_Fz71NH7dC9ySU7jqlb0i1xWG1P6Be4uRQqVi9G9MtlQ-MYcaANLKS3b7SeAYICQtV_piQOQAdbStbzW25Y17bpFqMKrmRWDS_Y4Lk2oittAnI3_Fx8PHdyktWXSltFM_Vcwi0OyomIwqk_4lJY71aRLJNounAK2EA0Tpjz7Uoa4w)
| Sync completed |
8 | ![SQL Server](https://lh6.googleusercontent.com/B3jQDr6cH-n0AC_Ci3ZarJo_UB9zUppqurs1etpk3RpITORU1-JQKLopozgyZgS2CerhXtNlSvzm3DgoysMZOOzp33r4Sieu8j4lyceedN9sRqPg76T_BqG3xrUEs18luUZ-uQBRMmSgM7EOtiNP4ssFjE6gLLkB-nv74xUAT2-K8zaYBYLCUax1YR1IxEyQ_pkPjg)
| Open Microsoft SQL Management Studio. Connect to your database AU_DEV_ED |
9 | ![..v_EO
tep
r:.ate
_LIRC_
12'2020
1 1 '2020
2,202C
9,.u-27/11 '2020
11,2020
1234567
250* 1 78
reJLL](https://lh5.googleusercontent.com/QLjKtjleyqXCLB4E65008_tAzG5cb_Q0QC76qNt_1KI_cmeVSjsuFHikaOQ24I_1qdK3dEYus6XkMHqbNYlg_BBuaAYWnEZqnv9_nNA3Lybf15e5Q-sb6W8WA5bLPVF2YxG9_ZsCq-lSOx_gX-xA7j1RRg2FWB9uqOExxLQNmE2Zsy9GDmws4eW_28hApDS7gGrnew)
| Create new query and select table: Rc_Volunteer_Staging to see the fields created after synchronize database |
10 | Path: C:\Constants\GenerateConstants.exe ![Thispc
2402.12022 7:55
ce•W2022 1:35
2402/2022
COWC File
TXT File](https://lh4.googleusercontent.com/qH9Oe16Ive13AUNrYlutvXuAHBGUKkidub3V5AFP4lnD1XQwxPX9FnTroQDyJQj4nXJYUA7A8PYLRgLCnS1feg__ptkM7ONSe3yr18HoE3sl1xSO3uyInFAteQJPIpZdmdUjsBwIFndB6Z16Vcrx7GWjAMVHAxJgr8PimHIdiizm_GFhf2aw0p76BT-r9jAJNUdssA)
| Follow the path, and open Generate Constants by admin. We need to generate a constants table to use it for Pivotal 6.X and public new fields to API |
11 | ![〔 | · 01 囗
1 囗](https://lh4.googleusercontent.com/iWbNT1jfb3FZhdo3jLbvy1aEql-42snhzgRQNVk2Dx1HOlCOxh9uVR5TRab_s2yWfuXioY1AOzu136szCy3aO3cwE6nyXzN1dAAaCeQ02lD3gYjKlRodIxcWDZCOKsVEC3HrtMqTjl_ZTZ7ZDWQS7MfZdqBwD6nePnmZ2UVPNJ8aWsvyy_BuimzPKpin15yiO0PRfw)
![tbÜ_L*](https://lh6.googleusercontent.com/tSnZ8FCLkdpn5Gw23pRYiY--DblKdMiYVgfLBiWYe9RYTZrvEMXTl8uvRpTOMwHaqysuKXW1tYWejDWCFaj5BTNDybF2N4b816Jxx-n7nDfRb9v9THBGjIlcXn0roWNbsRL7v4cGeh1sW6lY4_goBz8jT3fkibumEJLHUBWzjZzvY78czWw8sO4Cu-utpMTgl_1HXw)
| In Generate Constants Form, in the tables, click select to open the Tables Form. Select the table name you want to generate constant. |
12 | ![冖 一 , 囗 冖 一 , 。 一 囗](https://lh5.googleusercontent.com/b5OcMjomJNOnabdrSSAtiSZZiC9Ml3CIuLcPfBGYTbjhvh-14Vl8LBynO_XbKKD82Oz5f9pmEeC4OUPl7oH6lev93nXkP5Wi3nwlJ-0Vqe6R_i-Pcv92qIwY2HTDXKkRWnw_ViGhglmBkLllpVx5iJlZd1Yax_u9N69oberNiIG7T-5pGqHL8E1WwuSNje8698yNjA)
File have been generated
![1 、 p ー
暑 = 。 、 3 一 Lids
コ 盟 - 第 h 一 物 -
十 0 こ - コ 、 -
要 当 お
冐 物 2 コ を 象
ロ 日 一 3 を 当 ロ ー " 一 3 亠 」
- 挙 第 ロ
~ ← 乙 心 紀 2 55 い 豪 - 画 コ
Ge え & CO ま を 1](https://lh6.googleusercontent.com/BeDbkr-LUy1LhDc0wCSmwYuWVcR_MDylkIn_cEId3ZOfp8tzZH6ea4oTQRMBnmwVbJL7Xa3Lex4ICDumXZKggwUyjHLlXW7JLgUwjxsih8-8HPsgqTh48Vx96aLYCjRTJC-PTkAlPugY1uriJYRbctnPboehbByr3DGwx3wiviYIlojOniawvp4IvHvmEgCEGEOFbQ)
| Select tables, and click Generate File |
13 | Path: C\Constants\Tables\Tables ![](https://lh5.googleusercontent.com/_7I2I6GOYtj_ki2-fuAjnMHpHlgO6l8OMnfGYt1SPgZZbxCYzhJ7znWFLf3TZkd36CvlEbIwIjeY9IdJd8JdGcZmCs17few31XkKrG_iB8K7npmOsZgTN4hMXJuI7tN1AkD0y1BUY-mYzYYcaV3qOcWWDkB-G48zyL6zaE_rsomVFOzg74hO8OPs_FzanRIrs3H6Sw)
| Follow this path, we can see a file generate: RcVolunteerStagingTable.cs
This file will include all fields in the table |
14 | ![](https://lh6.googleusercontent.com/ztU15nWReHeMu8de_X_nki8P7wy-Z-u-mu9KFrg1dwDYd2GU-5hobX-yZxXDi97JGR74fgygMFkU32Vd_R02RvsHxGOq-B2fneu6nruUVO26beiS-Ze8Qxl6aKzU3968fTnhLBXJU4VQ0B3VbKrYQAIL1kpPlzGN6QcxAuBy1uY_C6ZXsQ37NL1o3RhH7PdBkvFYaA)
| Open solution PivotalCRM, and open RedCross.Data Project |
15 | ![가 ddy¯
! .물u;콤•국S-
1N0
기1되凸
• 이훤•그!rd쏴꺼 믈바」
다가
0Ⅰfi] n!Ⅵ105
|1뙈• 세회리V.개 !
-회•1리• pd|계*회•罌개
” I ”p그까V.개 •1 !
~Ⅰ墮15 u며” •1 !
″리墮11″ I 매개 •1 !
″리墮1些 I 매개 •1 !
”회墮1~* I 매개 •1 ,
” I 매개 •1 !
u이|거뙤
그」
1″) 기tq蘭
. - 毳&』14 14″ 」&1력nd
• *」V 국 ″, 그!1되馝
十국출회 1” “15 ,1
기』믽! 」&1회馝
리삐우이그야*l!•.](https://lh5.googleusercontent.com/6fX1wqtqaxmr2iGDMSjcfP4zhegLrpDDFlrjojhEXwBsrnTortCurqwL0fklIbd_UvJ2UqEQPjLn6PhEpN78BvFQaZvB5ScWqRUKMLY3DvDdgedgcZd58v9qu47GLLJa0qUA86OpXfPwcZhpYW6jWqMETs6UlJ1NZlEDqRcRSq8NRbs5zgvY1Rw04pGaJRfC_6s1vA)
| Select the cs file with the file name same with your table name, Then insert new fields from the file generate by constant tool. |
16 | ![04 ~ 夃 0
山 30 〕](https://lh5.googleusercontent.com/7iHY9UG0M58T8FzuSKGJBqvOgHdC3r1AVrG-b_S_N-MTW-0EfXtudbx2Jbr0uMsie7GiAXEP3rSXHKp-o7S2jCaDlNND6Kca93LqGGsTA3--duBng9R1YxVr5nN1B_sn7gVxPCodzVOTXNAtALtgqyYhvWdir6WNJ6PPukVTEE0JeUNgjQITdcIYb5j0usULTrs6Hw)
| Build RedCross.Data project and check new version of RedCross.Data.DLL and RedCross.Data.pdb |
17 | ![Quickm
D00 , n , ,
lPic
Go 0
00 ! r 丨 m 卜 A p
【 ! r 丨 m M ! mb 'db
Thedestination has ~ ” 小 same names
Replacethe ” in the d n ,
Skipthese files
丨 L n ci for , hfi
19 AM
23 0 & AM
23 0 & AM
23 0 & AM
23 0 & AM
u ud p 勫 …
u ud p 勫 …](https://lh3.googleusercontent.com/lXyJBNRk4YglBMTRlQQ9aUWXgGxiMBaGehpv4O7jtQma10S9of55CG7R1HQUvX36fMYJtwNW-CLlqK9ww86TKV7q3Kev6GcFM66JlxMz9aF2YOKMchV2KnmmGeWgFgF-x169A1g1iv9XDS0327HwoRukBEYFZIfWv0ugL1_C1Xca8CAZZtN2gev5I-h-ApeIOEbvXw)
| Open Component Services and open Base Application Partition and right click to shut down Pivotal Business Server |
18 |
![2
My
v COM-
C Leg. ey
Shutdown pas
before replace DLL
COM.
COM-
, y coM-
MAVIS.c•Evuump
Z:' COW.
COM-](https://lh6.googleusercontent.com/1B9x1IYpf6s0XPX-aWPE4KcYXdl--CHhrn3KDttzL8QBgaOx0nr63dPtCpjAnkTUUVbTxIOx9-FQbV4qYL9nOBRBg6fYbgZoyDScgz4PHeQbEpS5oTrDGcL8ehJ-Uy6kkKkDYO3Aw-AvytS1Zc9ZI7RH6-iwNMtQnOBLwolc0IbNRAnQW1ZkgUF7UQrBNCZHoeVbJg)
| Copy RedCross.Data.DLL and RedCross.Data.pdb to Service Tasks to apply new fields |
19 | ![, MAVIS_DEV_N&
v'MAVIS_OEV_hmp
) 'MAVIS_OEV 」
Start PBS](https://lh3.googleusercontent.com/k_GX49fBh-suOpXVVWMfab5UGVxokMkFXc1QSTYcXW5AUcwoKoD8rxVtfNkK7IxvCKPVe099mHlAa_6xzZ5NoUiUlIoH0iQ4gmYyKjprwXYfOcobz-7L2AR0SyX9p2-IfhZNrSWrgsEBq4dAQV8jSb78oeh3Ij_ESdcbjtTWeFjWIFx_pUUQbZ1Qll3aYZoh1v0Maw)
| Open Component Services and open Base Application Partition and right click to start Pivotal Business Server |
20 | ![(c) 2e18
Internet
services
ttempting start..
le,e.17763.a9281
All rights
s topped](https://lh4.googleusercontent.com/I0A8zYBcT_ARP_ZCttuYmxtBNsI3rWAyNEGb9_5yg46iC7jiFUhQiSslRrE2Jnps7WtCa1CuL54EP8ULz3Bbp0R-y7vRAm6rJ5k9Kobo0vrcXQniFDdeoVR1-nLomcDVWPjOscazpieCdC9wetAppg9UNNyttUV_5unHK7yj6Kb6YHr0vDLTWuDtAqHHeD6WnfwuPw)
| Open CMD and run: IISRESET to restart Application Pool |
21 | ![Oublie 0 ! 015 t •i 0](https://lh6.googleusercontent.com/qawVQUKik7zOUDWDszjNMrWIM6nLIycaIHOtocD-cURjTYg03leClquNFU2lm-eD0TlRsqSk8RJLi8rxRcgqBkToin8YjzsuVLR_5UygPXVlRAIxzN2pR92pmkY1rt5vXypY1geESXLysrJ1OlnCyrE2h3BQCnMnkIMBqsq641pxfZE_dlqVhK-7Csr2I_Ho4LqJOQ)
| We can debug Service Task to check the data in new fields |
No comments:
Post a Comment