search

omar733 / company-time-sheet

Automatically exported from code.google.com/p/company-time-sheet
0 stars 0 forks source link

TIMESHEET-SQL PATCHES #90

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 

write patch and update the below 

1.marimuthu.r@ssomens.com-15.06.2012

15/06/2012  "1.Working in version2 in User interace Classes to get the input 
date vales in Panel and i did the script  (refer codingprog file).
2.Followed the instruction in configuration setting.
 "

2.boopathy.v@ssomens.com-2012-07-06

patch to update ABSENT

3.kumar.r@ssomens.com-HAVING 2 REPORT FOR THE DATE 04-09-2012

Delete one duplicate

Original issue reported on code.google.com by dhivya.a...@ssomens.com on 26 Sep 2014 at 9:06

GoogleCodeExporter commented 9 years ago 
@RL

WRITE SCDB PATCH TO UPDATE THE ABOVE RECORDS

Original comment by dhivya.a...@ssomens.com on 14 Oct 2014 at 6:35

GoogleCodeExporter commented 9 years ago 
DIV,

CHANGE THIS TASK TO SOMEONE

Original comment by DHANDAPA...@ssomens.com on 14 Oct 2014 at 6:51

GoogleCodeExporter commented 9 years ago 
WRITE PATCH TO DELETE THE BELOW RECORDS

https://docs.google.com/a/ssomens.com/spreadsheets/d/1-iMaAl89HmVHO0ZqdQoPENGPyK
yL7pH_RYdVsWCkMIs/edit#gid=382780345

Original comment by dhivya.a...@ssomens.com on 14 Oct 2014 at 7:21

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #1 & #3

PATCH FOR THE DUPLICATE RECORD

SCRIPT 
LINK:https://script.google.com/a/macros/ssomens.com/d/19_3wgCPyH8QjAG1FJgn4QwXh-
ZpGmgcUTyGffP6kW9Mjr94Mw6uDE0Gv/edit?mid=ACjPJvF_fdI0PxRMqj7oaVfrxlY7c5SQRkqXqMp
9JEhEtVWsPMh9YFQoth2DtZXESQVoCa1pYsviRHg_SDMuvS9go3J3kKGCEDpuGcOhy-VtGn99sFW5-pR
O71RifPj_BA&splash=yes

SCRIPT NAME:TS_PATCH_14102014

Original comment by dhivya.a...@ssomens.com on 14 Oct 2014 at 8:53

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 15 Oct 2014 at 1:02

GoogleCodeExporter commented 9 years ago 
TESTED PATCH VERIFIED

Original comment by DHANDAPA...@ssomens.com on 15 Oct 2014 at 1:02

GoogleCodeExporter commented 9 years ago 
INT IN PROD TS

Original comment by DHANDAPA...@ssomens.com on 15 Oct 2014 at 1:03

GoogleCodeExporter commented 9 years ago 
AFTER PATCH IN TS RECORDS

https://docs.google.com/a/ssomens.com/spreadsheets/d/1_FtSd8l3gAduGmJYzPoR2RVVqc
NYI8tfyqaT-aQEN4s/edit#gid=1624410005

Original comment by DHANDAPA...@ssomens.com on 15 Oct 2014 at 1:10

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 15 Oct 2014 at 1:11

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 15 Oct 2014 at 1:11

GoogleCodeExporter commented 9 years ago 
WRITE PATCH:

1.FOR ALL PAST RECORDS.PREPARE A SS , NEED TO FILE EXACT PROJECT NAME.
2.FOR EMPLOYEE DETAILS, PATCH TO UPDATE DETAILS, GIVE DETAILS TO SUBASH HE LL 
PREPARE AND GIVE TO U

Original comment by DHANDAPA...@ssomens.com on 31 Oct 2014 at 5:59

GoogleCodeExporter commented 9 years ago 
@subash

fill employee details which s given in this ss

https://docs.google.com/a/ssomens.com/spreadsheets/d/1S6bfTSOuVFUOHXAgHatNoQC-Xq
iHBTaP5-cq3GoqbyY/edit#gid=0

Original comment by dhivya.a...@ssomens.com on 31 Oct 2014 at 7:03

GoogleCodeExporter commented 9 years ago 
@subash

NOW OUR TS REPORT TABLE HAVING DEFAULT PROJECT AS EI FOR ALL.EACH DAY ALL 
WORKED IN DIFF PROJECTS. ASK ALL TO UPDATE PROJECT_ID FOR THEIR REPORTS UPTO 
29/10/2014.

ss 
link:https://docs.google.com/a/ssomens.com/spreadsheets/d/1S6bfTSOuVFUOHXAgHatNo
QC-XqiHBTaP5-cq3GoqbyY/edit#gid=2078037953

Original comment by dhivya.a...@ssomens.com on 3 Nov 2014 at 4:40

GoogleCodeExporter commented 9 years ago 
1) CREATE PATCH DOMAIN TABLES

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=1253344448

2) WRITE PATCH TO INSERT VALUES IN ERROR_MSG_CONFIG TABLE HIGHLIGHTED IN YELLOW 
COLOR

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=1446845105

Original comment by RAJALAKS...@ssomens.com on 3 Nov 2014 at 7:27

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#14

Original comment by RAJALAKS...@ssomens.com on 3 Nov 2014 at 7:28

GoogleCodeExporter commented 9 years ago 
as per comment no#14 patch completed

1) PATCH DOMAIN

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPN0xsNkhmdE9x
eHM

FILE NAME : SP_TS_CREATE_PATCH_TABLES_VER_0.1_90_14_03112014.SQL

2) CONFIG ERROR MSG

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPZ2NZNzI1dFk1
VHc

FILE NAME : SP_ERROR_MSG_CONFIGURATION_INSERT_VER_0.1_90_14_03112014.SQL

Original comment by RAJALAKS...@ssomens.com on 3 Nov 2014 at 8:01

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#16

Original comment by RAJALAKS...@ssomens.com on 3 Nov 2014 at 8:02

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #11 TASK TRANSFER TO RL

REFER THIS SS TO WRITE PATCH

https://docs.google.com/a/ssomens.com/spreadsheets/d/1S6bfTSOuVFUOHXAgHatNoQC-Xq
iHBTaP5-cq3GoqbyY/edit#gid=2078037953

Original comment by dhivya.a...@ssomens.com on 4 Nov 2014 at 4:46

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#18

Original comment by RAJALAKS...@ssomens.com on 4 Nov 2014 at 4:47

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#18 USER_ADMIN_REPORT_DTLS PATCH 

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1S6bfTSOuVFUOHXAgHatNoQC-Xq
iHBTaP5-cq3GoqbyY/edit#gid=80701832

WHICH R HIGHLIGHTED IN GREEN COLOR I DIDN'T WROTE PATCH. FOR THAT WT TO DO? 
SHALL I DELIVER ALL OTHER PATCH.

Original comment by RAJALAKS...@ssomens.com on 5 Nov 2014 at 9:03

GoogleCodeExporter commented 9 years ago 
@SN SIR

AS PER UR INSTRUCTION TERMINATED TEMPORARY LOGIN PROJECTID UPDATED AS TRAINING.

I UPDATED PROJECTID OF THE TERMINATED LOGIN WHICH I KNOW.
STILL SOME OF THE TERMINATED LOGIN WHO WORKED IN DIFFERENT PROJECT S NOT 
UPDATED.
SO PLS UPDATE IN THIS BELOW SS WHICH S HIGHLIGHTED IN GREEN COLOR

https://docs.google.com/a/ssomens.com/spreadsheets/d/1S6bfTSOuVFUOHXAgHatNoQC-Xq
iHBTaP5-cq3GoqbyY/edit#gid=80701832

Original comment by dhivya.a...@ssomens.com on 5 Nov 2014 at 9:12

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#18 EMPLOYEE_DETAILS INSERT PATCH

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1S6bfTSOuVFUOHXAgHatNoQC-Xq
iHBTaP5-cq3GoqbyY/edit#gid=0

WHICH R HIGHLIGHTED IN BLUE COLOR I DIDN'T WROTE PATCH. FOR THAT WT TO DO? 
SHALL I DELIVER ALL OTHER PATCH.

Original comment by RAJALAKS...@ssomens.com on 5 Nov 2014 at 11:29

GoogleCodeExporter commented 9 years ago 
FINISH ALL PATCH & THEN DELIVER. DON'T DELIVER INCOMPLETE. ASK SUBASH TO FILL 
ALL EMPLOYEE DETAILS

Original comment by dhivya.a...@ssomens.com on 5 Nov 2014 at 11:33

GoogleCodeExporter commented 9 years ago 
as per comment no#18

EMPLOYEE_DETAILS INSERT PATCH & UPDATE EXACT PROJECT_ID FOR ALL EMPLOYEE ONHOLD 
BECAUSE SOME OF THE DETAILS IN COMPLETE. SO WORKING ON ISSUE 75 COMMENT NO#94

Original comment by RAJALAKS...@ssomens.com on 5 Nov 2014 at 11:44

GoogleCodeExporter commented 9 years ago 
WRITE PATCH TO UPDATE EMAIL TEMPLATE AND EMAIL TEMPLATE DETAILS AS PER SS BELOW

https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=239979624

Original comment by SAFIYULL...@ssomens.com on 6 Nov 2014 at 7:25

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#25

Original comment by RAJALAKS...@ssomens.com on 6 Nov 2014 at 7:25

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#25 COMPLETED PATCH TO INSERT EMAIL TEMPLATE DETAILS

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPZkdiMFJUamcy
TWc

FILE NAME : SP_TS_EMAIL_TEMPLATE_INSERT_VER_0.1_90_25_06112014.SQL

Original comment by RAJALAKS...@ssomens.com on 6 Nov 2014 at 10:06

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#27

Original comment by RAJALAKS...@ssomens.com on 6 Nov 2014 at 10:06

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#18

FOR EMPLOYEE_DETAILS I DISCUSS WITH SN SIR HE TOLD TO PUT DUMMY VALUES FOR 
TERMINATED EMPLOYEE. BECAUSE THAT EMPLOYEE DTLS WE DIDN'T HAVE.

STARTED WORKING ON EMPLOYEE_INSERT PATCH

Original comment by RAJALAKS...@ssomens.com on 6 Nov 2014 at 10:54

GoogleCodeExporter commented 9 years ago 
i need project_dtls insert query from prod

Original comment by RAJALAKS...@ssomens.com on 6 Nov 2014 at 12:03

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 6 Nov 2014 at 12:08

GoogleCodeExporter commented 9 years ago 
below link have the project details and th records from prod ts

https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPWmxEZk9oa2FX
WU0

Original comment by DHANDAPA...@ssomens.com on 6 Nov 2014 at 12:11

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#18 EMPLOYEE_DTLS INSERT PATCH COMPLETED

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1S6bfTSOuVFUOHXAgHatNoQC-Xq
iHBTaP5-cq3GoqbyY/edit#gid=0

SHEET NAME : EMPLOYEE_DETAILS (AS PER SN SIR INSTRUCTION DUMMY VALUES INSERTED 
WHICH R HIGHLIGHTED IN BLUE COLOR)

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPVHFIcmpIekMt
OUk

FILE NAME : 
SP_TS_EMPLOYEE_DETAILS_INSERT_ULD_ID_1_TO_15_VER_0.1_90_18_05112014.SQL
FILE NAME : 
SP_TS_EMPLOYEE_DETAILS_INSERT_ULD_ID_16_TO_30_VER_0.1_90_18_07112014.SQL
FILE NAME : 
SP_TS_EMPLOYEE_DETAILS_INSERT_ULD_ID_31_TO_45_VER_0.1_90_18_07112014.SQL
FILE NAME : 
SP_TS_EMPLOYEE_DETAILS_INSERT_ULD_ID_46_TO_60_VER_0.1_90_18_07112014.SQL
FILE NAME : 
SP_TS_EMPLOYEE_DETAILS_INSERT_ULD_ID_61_TO_69_VER_0.1_90_18_07112014.SQL

Original comment by RAJALAKS...@ssomens.com on 7 Nov 2014 at 11:43

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#33

Original comment by RAJALAKS...@ssomens.com on 7 Nov 2014 at 11:44

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#18 UPDATED EXACT PROJECT_ID FOR ALL EMPLOYEE

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/189aMZYOVVBPmnZS6zL4GIyd2Qf
m4U-z7luMFgSni3ro/edit#gid=143349274

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPVHFIcmpIekMt
OUk

FILE NAME : SP_TS_UPDATE_PROJECT_ID_ULD_ID_1_TO_15_VER_0.1_90_18_08112014.SQL
FILE NAME : SP_TS_UPDATE_PROJECT_ID_ULD_ID_16_TO_30_VER_0.1_90_18_08112014.SQL
FILE NAME : SP_TS_UPDATE_PROJECT_ID_ULD_ID_31_TO_45_VER_0.1_90_18_08112014.SQL
FILE NAME : SP_TS_UPDATE_PROJECT_ID_ULD_ID_46_TO_69_VER_0.1_90_18_08112014.SQL

Original comment by RAJALAKS...@ssomens.com on 8 Nov 2014 at 10:55

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#35

Original comment by RAJALAKS...@ssomens.com on 8 Nov 2014 at 10:56

GoogleCodeExporter commented 9 years ago 
WRITE PATCH TO INCLUDE MENU'S FOR TS LINK BELOW

DRIVE 
LINK:https://docs.google.com/a/ssomens.com/spreadsheets/d/1O-omI1do-t6Hn8M7E3_fS
MuMBedWE7xHLrfvLezktcg/edit#gid=488990207

Original comment by SAFIYULL...@ssomens.com on 8 Nov 2014 at 12:09

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 10 Nov 2014 at 4:24

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#37 COMPLETED PATCH TO INSERT MENU'S

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPSVQ2elNGUmU1
V3M

FILE NAME : SP_TS_USER_RIGHTS_INSERT_VER_0.1_90_37_10112014.SQL

Original comment by RAJALAKS...@ssomens.com on 10 Nov 2014 at 6:36

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#39

Original comment by RAJALAKS...@ssomens.com on 10 Nov 2014 at 6:36

GoogleCodeExporter commented 9 years ago 
WRITE PATCH TO ADD EMAIL_TEMPLATE WHICH S HIGHLIGHTED IN GREEN 
COLORhttps://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_
saXrLAzKVxkVMH2VKfjElM/edit#gid=1511841712

REFER 
SS:https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_sa
XrLAzKVxkVMH2VKfjElM/edit#gid=1511841712

Original comment by dhivya.a...@ssomens.com on 12 Nov 2014 at 6:21

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 13 Nov 2014 at 7:04

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#41

Original comment by RAJALAKS...@ssomens.com on 13 Nov 2014 at 7:13

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#41 COMPLETED PATCH TO INSERT VALUES IN EMAIL_TEMPLATE_DETAILS

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPZkdiMFJUamcy
TWc

FILE NAME : SP_TS_EMAILTEMPLATE_INSERT_VER_0.1_90_41_13112014.SQL

Original comment by RAJALAKS...@ssomens.com on 13 Nov 2014 at 7:34

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#44

Original comment by RAJALAKS...@ssomens.com on 13 Nov 2014 at 7:34

GoogleCodeExporter commented 9 years ago 
WRITE PATCH TO INSERT VALUES IN COMPANY_PROPERTIES_DETAILS

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_saXrL
AzKVxkVMH2VKfjElM/edit#gid=1571590187

Original comment by RAJALAKS...@ssomens.com on 14 Nov 2014 at 4:24

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#46

Original comment by RAJALAKS...@ssomens.com on 14 Nov 2014 at 4:25

GoogleCodeExporter commented 9 years ago 
tested delivery in the comment 16,33,35

patch for create patch tables,employee_details insertion,project id updation 
working fine..

Original comment by dhivya.a...@ssomens.com on 14 Nov 2014 at 4:54

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#46 COMPLETED PATCH TO INSERT VALUES IN 
COMPANY_PROPERTIES_DETAILS TABLE 

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPVHFIcmpIekMt
OUk

FILE NAME : SP_TS_COMPANY_PROPERTIES_DETAILS_INSERT_VER_0.1_90_46_14112014.SQL

REFER SS : 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1S6bfTSOuVFUOHXAgHatNoQC-Xq
iHBTaP5-cq3GoqbyY/edit#gid=0

WHICH R HIGHLIGHTED IN PINK COLOR

Original comment by RAJALAKS...@ssomens.com on 14 Nov 2014 at 6:46

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#49

Original comment by RAJALAKS...@ssomens.com on 14 Nov 2014 at 6:47