Who's Online Now
0 registered members (), 6 guests, and 1 spider.
Key: Admin, Global Mod, Mod
Newest Members
clickavi, wilts, Renuka, KavyaMurthy, Del
1280 Registered Users
Recent Posts
Update employee spinal point via API
by Andrew. 19/02/19 05:13 PM
CT's Handy Hints for Migrating Balances
by CT. 05/02/19 07:41 PM
Run Results from a UDF in a Fast Formula
by paulgos. 21/01/19 01:44 PM
Top Posters(30 Days)
Andrew 6
CT 5
delboy 1
Neo 1
Popular Topics(Views)
475,436 PAYE RTI
56,256 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,097
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,097
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 (247 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,097
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,097
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,097
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,097
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,097
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,097
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,097
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,097
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,097
CT Offline
CT  Offline

****

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


CT

Moderated by  bcooper, CT 

Forum Statistics
Forums60
Topics2,217
Posts11,977
Members1,281
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,097
delboy 1,291
bcooper 1,291
paulgos 436
SBi 426
pat 254
Gus 252
vkumar 223
February
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
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.034s Queries: 16 (0.016s) Memory: 2.7945 MB (Peak: 2.9863 MB) Zlib disabled. Server Time: 2019-02-20 17:23:06 UTC