search

omar733 / company-time-sheet

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

TIME SHEET MIGRATION SCDB TO SQL - SPLITED TABLE #75

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
1.Migrate all time sheet records SCDB to SQL table.
2.Create audit history table and insert all migration details (table   
name,key,exec time,users tamp,time stamp,etc).
3.Create view and show all time sheet migration details.
4.Need to split time sheet scdb into two tables 
  1.Roles(USERRIGHTS_SCDB_FORMAT)
  2.Reports(REPORTS_SCDB_FORMAT).
5.Time stamp need to show 24Hrs format.

Original issue reported on code.google.com by KUMA...@ssomens.com on 1 Aug 2014 at 9:36

GoogleCodeExporter commented 9 years ago 
Completed script for migrating all scdb time sheet records inserted into SQL 
table.
created audit history and view.

SCRIPT LINK:
https://script.google.com/a/macros/ssomens.com/d/1vnqvVKk02ol5vY3ub_FN8VBhwSzq5m
0NG36wbetyljSxSVrFzUm7W-B1/edit?mid=ACjPJvGX7l2dWrq01satMTLSl4t_Oq-wQWdTwzAjUbqz
ymC1_XmbKaVO3XVcqZeHI7_KrC5o7o-MeBpy9Wb0DrH5cyXqoGvWc3c21pJsvcqz6tBJRjG-_Y4Pj9U

SP'S drive link:
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B1AhtyM5U79zaXdmR3Z6b3dE
N28

Original comment by KUMA...@ssomens.com on 1 Aug 2014 at 9:45

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 6 Aug 2014 at 11:15

GoogleCodeExporter commented 9 years ago 
Below defect found,

1.2000 records i loaded, but FROM showing 1000
and LAST SQL TS RPT ID SHOWING 999,

2.RUN btn NOT DISABLE AFTER MAX SCDB RECORD COUNT.

https://docs.google.com/a/ssomens.com/file/d/0B_f0d7mdbV_UcGdxZnNCMEtPN2M/edit

Original comment by DHANDAPA...@ssomens.com on 6 Aug 2014 at 11:20

GoogleCodeExporter commented 9 years ago 
@SN 
u opened issue k i ll accept
but i asked all data's need to test but u don't give any source.
u gave only ss records and i'm loaded in scdb but its showing max exec time 
error so i loaded 500 records and tested 
in this 500 records i'm not got any issue 
if i need to clear this issue means i need to full db records...
what u tel?

Original comment by KUMA...@ssomens.com on 6 Aug 2014 at 11:34

GoogleCodeExporter commented 9 years ago 
@SN sir,

Reply ?

Original comment by KUMA...@ssomens.com on 7 Aug 2014 at 7:06

GoogleCodeExporter commented 9 years ago 
IN REPORT TABLE CREATION SP BEFORE I GAVE UID COLUMN AS VAR CHAR BECAUSE UID 
COLUMN HAVE NULL VALUES ALSO THAT'S Y I GAVE VAR CHAR NOW CHANGED VAR CHAR TO 
INT DATA TYPE.
TEST AND TEL IN LOCAL
Because i try to load TS records SS to SCDB but SS also not open loading 
loading...

https://script.google.com/a/macros/ssomens.com/d/1zsvhSincFX_eU10uVmamce3or8dbD2
WgFN-QXei5D7k3h7ASxLX8A1OZ/edit?mid=ACjPJvEuTag2WbvlN-mzfmaaagRRoxcMZBwe0K4-PKZ2
fNKY6DzJQfODyVDSw9Yo4SFXjE5UUYN9jCJB5PHGz50IypOMnR43m2fo2TV1T50gn4sr057_mqIoWEA

SCRIPT LINK:
https://script.google.com/a/macros/ssomens.com/d/1zsvhSincFX_eU10uVmamce3or8dbD2
WgFN-QXei5D7k3h7ASxLX8A1OZ/edit?mid=ACjPJvEuTag2WbvlN-mzfmaaagRRoxcMZBwe0K4-PKZ2
fNKY6DzJQfODyVDSw9Yo4SFXjE5UUYN9jCJB5PHGz50IypOMnR43m2fo2TV1T50gn4sr057_mqIoWEA

Original comment by KUMA...@ssomens.com on 7 Aug 2014 at 8:30

GoogleCodeExporter commented 9 years ago 
sry in comment #6 i updated two links both are same link oly
take anyone link

Original comment by KUMA...@ssomens.com on 7 Aug 2014 at 8:32

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 7 Aug 2014 at 10:37

GoogleCodeExporter commented 9 years ago 
SCDB TO SQL SUCCESSFULLY MIGRATED

Original comment by DHANDAPA...@ssomens.com on 7 Aug 2014 at 10:38

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 7 Aug 2014 at 10:39

GoogleCodeExporter commented 9 years ago 
DIV,

Load this in local mysql , use this do the post migration of TS V2

TS SCDB TO SQL MIGRATION , SINGLE SQL FILE IN BELOW LINK

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

Original comment by DHANDAPA...@ssomens.com on 7 Aug 2014 at 10:42

GoogleCodeExporter commented 9 years ago 
need cloud schema to check form in cloud.need to check how to connection 
working and forms are working r not.

Original comment by SAFIYULL...@ssomens.com on 25 Aug 2014 at 6:22

GoogleCodeExporter commented 9 years ago 
Safi,

Update the Migration  status? Raja and BH doing 1000 days. if u sleeping they 
wont finish. first show 4 forms with migration in local. and then try clsql.

I know migration  not complete.Did u asked sql team reg this.I need ur forms 
with migration data. not empty db.

Test first TS v2 with migrated records.then only u ll clear 1000 defects

Original comment by DHANDAPA...@ssomens.com on 25 Aug 2014 at 6:54

GoogleCodeExporter commented 9 years ago 
MIGRATE CONFIG,USER_RIGHTS SQL FORMAT FROM SS TO SQL TABLE

CONFIG_SQL_FORMAT SS 
LINK:https://docs.google.com/a/ssomens.com/spreadsheets/d/1W_N9xD5E5ZEIt1Ab7A1V_
saXrLAzKVxkVMH2VKfjElM/edit#gid=2044240017

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

Original comment by dhivya.a...@ssomens.com on 9 Oct 2014 at 4:03

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 9 Oct 2014 at 4:29

GoogleCodeExporter commented 9 years ago 
i need latest version of ts premigration script

Original comment by RAJALAKS...@ssomens.com on 9 Oct 2014 at 4:56

GoogleCodeExporter commented 9 years ago 
PREMIGRATION SCRIPT LINK

https://script.google.com/a/ssomens.com/d/1B_riuA5u5waye25R82nUTMx6bZep__WMpnRfU
JhgeZF4KXgLFdO4sMrZ/edit?folder=0B_f0d7mdbV_Ud0RKSGpJZ0V3enM&usp=drive_web&splas
h=yes

Original comment by DHANDAPA...@ssomens.com on 9 Oct 2014 at 5:14

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#14 

ADDED SCRIPT FOR MIGRATING CONFIG,USER_RIGHTS SQL FORMAT FROM SS TO SQL TABLE 
inserted into SQL table.

SCRIPT LINK : 
https://script.google.com/a/macros/ssomens.com/d/M30HLVORiTacO9W4rQU747-IXVT1Y8c
_e/edit?mid=ACjPJvGWkLDdPp-6sdnCvKGoyow_3EJoX-N5ToidPfRgJ_ci_a6qUwz1eKUoLQXoM1lT
19aeER0qjA3PUFhZ2msqfaAG9-RXuWB4KN7mjVLBwjWydxq6pz57EcgY

SITE LINK : https://sites.google.com/a/ssomens.com/rl-scripts/

Original comment by RAJALAKS...@ssomens.com on 9 Oct 2014 at 9:58

GoogleCodeExporter commented 9 years ago 
migrate all month bandwidth ss to sql table

ss link: 
https://docs.google.com/a/ssomens.com/spreadsheet/ccc?key=0Ar0UK3Ne43XpdGtyeklDa
UNpRXJlUDVhQmg1T2pDbmc&usp=sharing_eil#gid=10

Original comment by dhivya.a...@ssomens.com on 9 Oct 2014 at 10:08

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

Original comment by RAJALAKS...@ssomens.com on 9 Oct 2014 at 10:22

GoogleCodeExporter commented 9 years ago 
2013 BW SS

https://docs.google.com/a/ssomens.com/spreadsheet/ccc?key=0Avf0d7mdbV_UdHRCMzhqa
mlPWlM1NjY2V0NXdEk3aFE&usp=sharing_eil#gid=0

Original comment by dhivya.a...@ssomens.com on 9 Oct 2014 at 10:29

GoogleCodeExporter commented 9 years ago 
MIGRATE TEMPORARY LOGIN SS TO SQL TABLE

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

Original comment by dhivya.a...@ssomens.com on 11 Oct 2014 at 3:56

GoogleCodeExporter commented 9 years ago 
AS PER CMT 22 

REFER SS 
LINK:https://docs.google.com/a/ssomens.com/spreadsheets/d/1GD7w3Cyx8RbIoVe1jnBJX
2__0W7D_iE03J16X5R72fE/edit#gid=0

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

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#19,#22

migrateD all month bandwidth ss to sql table, MIGRATE TEMPORARY LOGIN SS TO SQL 
TABLE

COMPLETED FINAL MIGRATION FORM

SCRIPT LINK : 
https://script.google.com/a/macros/ssomens.com/d/1DWTavC-QvFxnXW9DAg16NTmWByoaaN
KciZwvuQfFlStOh_ZULzj0InTY/edit?mid=ACjPJvGvl50U0JMuMa9ju-Y2HjwGDXc2nA6Yko1msvkc
eRb4REAZ0AEUIPb9Gcek11mQIhr2B-J7VDWweoN_ts6GBw9xWDrPFHf3GNmedw-iGseVHOmj2K4BS9LR

ALL BANDWIDTH, CONFIG_SQL_FORMAT, USER_RIGHTS_SQL_FORMAT, TEMP LOGIN DTLS SS 
LINK 

https://docs.google.com/a/ssomens.com/spreadsheets/d/1aNWp6FbMR9VONeV2fogt7vxDnx
Wj5TYVGUT_fytoYK0/edit#gid=2137337257

@TS TEAM, @SQLTEAM
HERE AFTER ALL CONFIG, USERRIGHTS, BANDWIDTH DATA'S NEED TO UPDATE IN THE ABOVE 
SHEET

Original comment by RAJALAKS...@ssomens.com on 11 Oct 2014 at 12:23

GoogleCodeExporter commented 9 years ago 
as per commentno#24 

site link : https://sites.google.com/a/ssomens.com/rl-scripts/final

Original comment by RAJALAKS...@ssomens.com on 13 Oct 2014 at 4:25

GoogleCodeExporter commented 9 years ago 
SIR

IN REPORT SCDB SOME RECORDS HAVING REPORT DATE AS 01/01/1970 

REFER 
SS:https://docs.google.com/a/ssomens.com/spreadsheets/d/1-iMaAl89HmVHO0ZqdQoPENG
PyKyL7pH_RYdVsWCkMIs/edit#gid=382780345

SIR U NEED TO UPDATE THESE RECORDS DATE AS TIMESTAMP DATE IN THE SCDB ITSELF

Original comment by dhivya.a...@ssomens.com on 13 Oct 2014 at 6:08

GoogleCodeExporter commented 9 years ago 
SIR 

UPDATE TERMINATED REASON FOR THE TEMPORARY LOGIN

REFER 
SS:https://docs.google.com/a/ssomens.com/spreadsheets/d/1aNWp6FbMR9VONeV2fogt7vx
DnxWj5TYVGUT_fytoYK0/edit#gid=662211119

Original comment by dhivya.a...@ssomens.com on 13 Oct 2014 at 7:22

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #27 SN SIR ASK TO UPDATE THE REASON AS 'TERMINATED' FOR 
TEMPORARY TERMINATED LOGINID

Original comment by dhivya.a...@ssomens.com on 14 Oct 2014 at 9:37

GoogleCodeExporter commented 9 years ago 
update the user rights view dynamically and and include view module in post 
migration module table.

Original comment by SAFIYULL...@ssomens.com on 14 Oct 2014 at 9:39

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 14 Oct 2014 at 9:46

GoogleCodeExporter commented 9 years ago 
as per comment #29 changed user_rights view dynamically added view domain in 
post_migration_module table

user rights view
drive 
link:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UYzN3Z2c
tYlRkR2M

file 
name:SP_TS_VW_ACCESS_RIGHTS_TERMINATE_REJOIN_LOGINID_VER_0.3_75_29_14102014.SQL

post_migration_module table

drive 
link:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPUFZvYkJ
VQVJiN2s

file name:SP_TS_POST_MIGRATION_INITIAL_TABLE_VER_0.2_14102014.SQL

Original comment by dhivya.a...@ssomens.com on 14 Oct 2014 at 10:36

GoogleCodeExporter commented 9 years ago 
CHANGE POST AUDIT VIEW 

ADD TEMPORARY LOGINS ALSO IN USER_LOGIN_DETAILS & USER_ACCESS TABLE

Original comment by dhivya.a...@ssomens.com on 15 Oct 2014 at 6:20

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 32 ADDED TEMP EMPLOYEE SCDB RECORDS WITH USER LOGIN 
DETAILS,USER_ACCESS AND REPORTS FOR THE VIEW IN POST AUDIT SP

FILE NAME:
SP_TS_POST_AUDIT_VER_0.2_75_32_15102014

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

Original comment by raja.gun...@ssomens.com on 15 Oct 2014 at 7:58

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 15 Oct 2014 at 8:35

GoogleCodeExporter commented 9 years ago 
tested delivery in the comment #22 post audit view working fine...

Original comment by dhivya.a...@ssomens.com on 15 Oct 2014 at 10:59

GoogleCodeExporter commented 9 years ago 
COMMENT # 24 , REJECTED. BCZ THER IS NO VER COMMENTS DETAILS.

DIV,

CHECK ALL THESE AND THE DELIVER TO ME.

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

GoogleCodeExporter commented 9 years ago 
AS PER CMT #24 DELIVERY ADDED VERSION & COMMENTS IN FINAL MIGRATION SCRIPT

SCRIPT 
LINK:https://script.google.com/a/macros/ssomens.com/d/1DWTavC-QvFxnXW9DAg16NTmWB
yoaaNKciZwvuQfFlStOh_ZULzj0InTY/edit?mid=ACjPJvGvl50U0JMuMa9ju-Y2HjwGDXc2nA6Yko1
msvkceRb4REAZ0AEUIPb9Gcek11mQIhr2B-J7VDWweoN_ts6GBw9xWDrPFHf3GNmedw-iGseVHOmj2K4
BS9LR

Original comment by dhivya.a...@ssomens.com on 15 Oct 2014 at 1:30

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 17 Oct 2014 at 8:26

GoogleCodeExporter commented 9 years ago 
DEFECT OWNER:RL 
PARTIAL DEFECT OWNER:SAFI,DIV

TASK OWNER: DIV

pre audit history not insert. reason: pre audit sp didnt write dynamically.

Original comment by DHANDAPA...@ssomens.com on 17 Oct 2014 at 8:29

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 17 Oct 2014 at 8:58

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #39 PRE_AUDIT_HISTORY SP CHANGED DYNAMICALLY

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

FILE NAME:03-SP_PRE_AUDIT_HISTORY_VER_0.2_75_39_17102014.SQL

Original comment by dhivya.a...@ssomens.com on 17 Oct 2014 at 9:10

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 17 Oct 2014 at 12:27

GoogleCodeExporter commented 9 years ago 
DEFECT OWNER: RL

TASK OWNER: DIV

GIVE CORRECT SCHEMA IN THE CALL QUERY, THEN ONLY AUDIT LL WORK.

Original comment by DHANDAPA...@ssomens.com on 17 Oct 2014 at 12:28

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #43

changed destination schema input in pre_audit_history sp call query 

SCRIPT 
LINK:https://script.google.com/a/macros/ssomens.com/d/1DWTavC-QvFxnXW9DAg16NTmWB
yoaaNKciZwvuQfFlStOh_ZULzj0InTY/edit?mid=ACjPJvGvl50U0JMuMa9ju-Y2HjwGDXc2nA6Yko1
msvkceRb4REAZ0AEUIPb9Gcek11mQIhr2B-J7VDWweoN_ts6GBw9xWDrPFHf3GNmedw-iGseVHOmj2K4
BS9LR

SCRIPT NAME:TS FINAL MIGRATION_VER_0.04

Original comment by dhivya.a...@ssomens.com on 18 Oct 2014 at 9:58

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 20 Oct 2014 at 2:37

GoogleCodeExporter commented 9 years ago 

1. WHILE RUNING REPORTPART3 POST MIGRAITON
ScriptError: Table 'TS_PHP.TEMP_USER_ADMIN_REPORT_DETAILS' doesn't exist
https://docs.google.com/a/ssomens.com/file/d/0B_f0d7mdbV_UajJEdk5yLXBZMkU/edit

LOG DETAILS:

https://docs.google.com/a/ssomens.com/spreadsheets/d/1px2xj9wcxrAXiQdWM_JU9Atedk
WTs8BgA0FHEOqTMKU/edit#gid=0

2.MIGRATION FORM: RADIO BUTTON VALIDATION SHLD DO FOR CLICKING POST MIGARION 
AND PRE MIGRAITON AND POST MIGRATION FORM OBJ.
ELEMENTS SOME TIME NOT DISAPPERS

Original comment by DHANDAPA...@ssomens.com on 20 Oct 2014 at 2:42

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 21 Oct 2014 at 4:15

GoogleCodeExporter commented 9 years ago 
THE CONFIGURATION PROFILE DATA REPORT CHANGED AS REPORTS IN MIG SP'S

FILE NAME:
01-SP_TS_MIG_REPORT_DETAILS_ABSENT_INSERT_VER_0.7_75_47_21102014
02-SP_TS_MIG_REPORT_DETAILS_ONDUTY_INSERT_VER_0.9_75_47_21102014
06-SP_TS_MIG_REPORT_DETAILS_REPORT_INSERT_VER_0.5_75_47_21102014

DRIVE LINK:
https://drive.google.com/drive/#folders/0B_f0d7mdbV_Ud0RKSGpJZ0V3enM/0B_f0d7mdbV
_UbjFlb1dheFctdmM/0B_f0d7mdbV_UVkRHajRJbVJCbE0/0B_f0d7mdbV_USndFM2hCZlVHR3c

Original comment by raja.gun...@ssomens.com on 21 Oct 2014 at 6:21

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#46 ALL ISSUES FIXED IN MIGRATION

SCRIPT LINK : 
https://script.google.com/a/macros/ssomens.com/d/15j9Bu0Sd_PShwcvdAPUrNNHtcUbpeJ
DwetupFbQPfudv6hMtQBQLSs5Y/edit?mid=ACjPJvGKodvv1m8d4AiM6vDeaBIZ3PCbTZkVllyl0Wgq
wabjq8CfdToQT6KTWRO6jvrCPtG0Ycao7KFo235r5uHlJR9knF17FLFMDFTn2-j55JAzfiwL1RFmInTK

SITE LINK : https://sites.google.com/a/ssomens.com/rl-scripts/final

Original comment by RAJALAKS...@ssomens.com on 21 Oct 2014 at 7:52

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 23 Oct 2014 at 11:29