omar733 / company-time-sheet

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

Updation in Backup time sheet #11

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
@kumar 
1.try to freeze the 1 st row in the SS n highlight the color with blue BG n 
white text color
2. TS in the SS is nt showing AM/PM.

Original issue reported on code.google.com by DHANDAPA...@ssomens.com on 3 Jan 2013 at 5:24

GoogleCodeExporter commented 9 years ago
completed 1st row Frozen and set background color in 1st row.
project name:TIME SHEET TRIGGER_DUMP VER2.1
1.input month backup : time sheet manual backup for particular month.
2.currnet month backup : time sheet backup daily.

Original comment by KUMA...@ssomens.com on 3 Jan 2013 at 11:46

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 3 Jan 2013 at 1:12

GoogleCodeExporter commented 9 years ago
1. update the 2012 bkp file with correct Timestamp with 24 HR FORMAT!
2. SS has been updated before 1AM fr 3/1/2013, redump it, trigger shd run oly 
between 1AM-2AM daily!

Original comment by sarathba...@ssomens.com on 3 Jan 2013 at 3:47

GoogleCodeExporter commented 9 years ago

Original comment by sarathba...@ssomens.com on 4 Jan 2013 at 4:01

GoogleCodeExporter commented 9 years ago
If the TS backup is taken on a current day -1, if there was an update on 
yesterday report, then tht updated report is nt included in the backup , which 
we have wrongly designed to go for taking the backup of just ONE Day's records 
instead of the whole DB or atleast the whole current MONTH's records everyday.

By doing this, we have a backup of the whole month even though the n-5 days 
reports are updated.

Bt the best soln. is to take backup of the whole DB everyday or every month!

So, fix it acc.!

Original comment by sarathba...@ssomens.com on 8 Jan 2013 at 3:29

GoogleCodeExporter commented 9 years ago
@KUMAR,

TS backup : Every day the script ll take whole db backup.
Change ur script.

Original comment by DHANDAPA...@ssomens.com on 8 Jan 2013 at 4:46

GoogleCodeExporter commented 9 years ago
BABOU,
Now our backup script took current month daily.
So i think no need of whole db backup.
DO U WANT WHOLE DB EVERY DAY?

Original comment by DHANDAPA...@ssomens.com on 8 Jan 2013 at 4:51

GoogleCodeExporter commented 9 years ago
TS ll take daily backup for current month

Original comment by DHANDAPA...@ssomens.com on 4 Feb 2013 at 1:08

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 4 Feb 2013 at 1:08

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 4 Feb 2013 at 1:08

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 4 Feb 2013 at 1:08

GoogleCodeExporter commented 9 years ago

Original comment by DHANDAPA...@ssomens.com on 4 Feb 2013 at 1:09