Who's Online Now
0 registered members (), 4 guests, and 15 spiders.
Key: Admin, Global Mod, Mod
Newest Members
AKR, Barry_Test_User, KVS, Andrew, wilts
1284 Registered Users
Recent Posts
Fixed Term/Contract Employees
by JGrewal01. 16/04/19 07:54 PM
Top Posters(30 Days)
delboy 3
CT 2
Popular Topics(Views)
478,001 PAYE RTI
56,990 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#259 - 14/03/05 03:52 PM CT's Handy Hints for Migrating Balances  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
The information previously contained herein has now been consigned to a downloadable file: balance_migration.txt

Herein re-attached!

Attached Files
balance_migration-v3.txt (266 downloads)
Last edited by CT; 15/11/15 08:46 PM. Reason: V3 - minor updates

CT
#5582 - 06/07/10 10:07 AM Re: CT's Handy Hints for Migrating Balances [Re: CT]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
Bumped to publicise the updated version of the document - arising from some discussions with other forum members this morning! You know who you are....


CT
#5619 - 20/07/10 03:57 AM Re: CT's Handy Hints for Migrating Balances [Re: CT]  
Joined: Mar 2005
Posts: 252
Gus Offline
claiming squatters rights
Gus  Offline
claiming squatters rights

Joined: Mar 2005
Posts: 252
Lapenne
From memory another foible is that the you have your pay_balance_batch_lines rows all waiting with a status of 'U' the first thing the Balance Upload process does is set them all to 'V' so you cannot monitor how things are going...it then unsets the 'V' to 'E' as it finds Errors.

So you have no idea how things are progressing at least within that table

#5620 - 20/07/10 09:34 AM Re: CT's Handy Hints for Migrating Balances [Re: Gus]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
Fair point - all the more reason to keep the batch sizes small, i.e. balances for one assignment only. Monitoring throughput rates then becomes more feasible.


CT
#11078 - 26/09/15 03:52 PM Re: CT's Handy Hints for Migrating Balances [Re: CT]  
Joined: Jan 2013
Posts: 17
Sandy Offline
warming-up
Sandy  Offline
warming-up

Joined: Jan 2013
Posts: 17
Hi CT,
I'm not able to donwload the attachment. It says "You do not have access to download this attachment."

Thanks !!
Sandy

#11079 - 27/09/15 07:29 PM Re: CT's Handy Hints for Migrating Balances [Re: CT]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
I think it's one of the restrictions on new forum members - you have to make (and have approved) a certain number of posts before these restrictions are lifted - sorry. Once you're past that threshold, you should be ok.


CT
#11204 - 15/11/15 08:52 PM Re: CT's Handy Hints for Migrating Balances [Re: CT]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
Bump - publicising v3 smile


CT
#12198 - 05/02/19 10:24 AM Re: CT's Handy Hints for Migrating Balances [Re: CT]  
Joined: Oct 2015
Posts: 3
Neo Offline
stranger
Neo  Offline
stranger

Joined: Oct 2015
Posts: 3
United Kingdom
So can we download the balance_migration-v3 document elsewhere? Can it be sent to me?

#12199 - 05/02/19 07:41 PM Re: CT's Handy Hints for Migrating Balances [Re: Neo]  
Joined: Mar 2005
Posts: 2,103
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,103
You have mail, sir smile


CT

Moderated by  Administrator, bcooper, CT 

Forum Statistics
Forums60
Topics2,220
Posts11,996
Members1,284
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,103
delboy 1,297
bcooper 1,291
paulgos 436
SBi 426
pat 254
Gus 252
vkumar 223
April
S M T W T F S
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.032s Queries: 16 (0.005s) Memory: 2.7967 MB (Peak: 2.9895 MB) Zlib disabled. Server Time: 2019-04-21 02:22:42 UTC