BO Data Copy

ghilton

Hello

I have a BO called AssignmentSheet to which I have 11k records that I would like to move to another BO called Archive AssignmentSheet

How can I do this?

Thanks

tford

Graham,

Not sure why this was in the "problem report" forum??

You will need to create two processes:

Process1
1- FIND ALL AssignmentSheet
2- Process2 (this rule will call Process2)

Process2 (This will have AssignmentSheet as a Process Input)
1- CREATE ArchiveAssignmentSheet WITH ArchiveAssignmentSheet.Attribute1=AssignmentSheet.Attribute1,ArchiveAssignmentSheet.Attribute2=AssignmentSheet.Attribute2

Tom

ghilton

Hi Tom

Sorry I guess it was on the spur of the moment as this is an issue to me :?

I have made a copy of the BO through the config tool, what I need to do is 2 things -

I have a new attribute called TaxYear in BO AssignmentSheet which is blank at present for old records I need to find a way of saying if attribute TaxWeek is between 6 and 52 then TaxYear will = 2007
Once 1 is completed I then need to say if TaxYear=2007 then move records to ArchiveAssignmentsheet BO

I cannot copy the data, the data has to be moved as the coding of the application looks up the current week when the client is copying the previous weeks assignmentsheet to this week! If the current_week already exists they cannot copy the sheet over a major issue to us!

Longer term I have to figure out a way of archiving (moving) records that are older than 2 weeks than the current_week to the archiveAssignmentSheet BO

Hope this makes sense? Still getting to know AwareIM but cannot find references to this in the manuals so I am struggling abit 🙁

Thanks

tford

Graham,

1a- put a rule on AssignmentSheet:
If AssignmentSheet.TaxWeek>=6 AND AssignmentSheet.TaxWeek<=52 Then
AssignmentSheet.TaxYear=2007

1b- run a process with following steps:

FIND ALL AssignmentSheet
UPDATE AssignmentSheet

This process will fire the new rule for all instances of AssignmentSheet

2- To move the data: First run the 2 step process from the earlier post. I would add an attribute to AssignmentSheet that flags when an instance has been archived. A second process could then go through AssignmentSheet and delete all instances with the archive flag turned on.

Re: Longer term. It would be very easy to add conditions to the archiving process I've described. You could also use AwareIM Scheduling features to automatically run this process periodically.

Tom

ghilton

Thanks Tom this is a great help! I am a bit baffled about process 2 though as in my small mind this at the moment does not make sense

"Process2 (This will have AssignmentSheet as a Process Input)
1- CREATE ArchiveAssignmentSheet WITH ArchiveAssignmentSheet.Attribute1=AssignmentSheet.Attribute1,ArchiveAssignmentSheet.Attribute2=AssignmentSheet.Attribute2 "

So this process would do........? Are the Attributes mapped to the exsisting attribute? ie Attribute1 would be sat TaxYear?
I am sure the penny will drop shortly on this

As all ways thanks for the help being a novice is not easy 🙂

tford

Graham,

I just used Attibute1 and Attibute2 as 2 sample attribute names. If you have 25 attributes in AssignmentSheet, then your CREATE... rule will have 25 pairs using the format ArchiveAssignmentSheet.Attribute1=AssignmentSheet.Attribute1 with each seperated by commas.

Tom

ghilton

Hi Tom

Thanks is seems easy when it is broken down so I think I get it! I just need to see this working so I will write the processes and test.

I also have a question on Exporting BO's and data if you don't mind? I will post this one under general🙂

I will let you know

Thanks again

tford

Below is Graham's PM question. My answer follows in next post:

Hi Tom

Not sure What I am doing wrong here as this is not working at all

Created 2 Processess -

ITProcess1
'For this Process' I have selected 'AssignmentSheet'
2 Rules

Find AssignmentSheet WHERE AssignmentSheet.Taxweek=1
ITProcess02

ITProcess02
'For this Process' I have selected 'AssignmentSheet'
1 Rule
CREATE ArchiveAssignmentSheet WITH
ArchiveAssignmentSheet.AGENCYCODE=AssignmentSheet.AGENCYCODE,
ArchiveAssignmentSheet.CHARGE=AssignmentSheet.CHARGE,
ArchiveAssignmentSheet.Checked=AssignmentSheet.Checked,
ArchiveAssignmentSheet.ClientCode=AssignmentSheet.ClientCode,
ArchiveAssignmentSheet.ClientCodeTEXT=AssignmentSheet.ClientCodeTEXT,
ArchiveAssignmentSheet.ClientName=AssignmentSheet.ClientName,
ArchiveAssignmentSheet.HOURS=AssignmentSheet.HOURS,
ArchiveAssignmentSheet.Imported=AssignmentSheet.Imported,
ArchiveAssignmentSheet.NOTES=AssignmentSheet.NOTES,
ArchiveAssignmentSheet.PAY=AssignmentSheet.PAY,
ArchiveAssignmentSheet.PONumber=AssignmentSheet.PONumber,
ArchiveAssignmentSheet.PROTECTION=AssignmentSheet.PROTECTION,
ArchiveAssignmentSheet.TaxWeek=AssignmentSheet.TaxWeek,
ArchiveAssignmentSheet.TaxYear=AssignmentSheet.TaxYear,
ArchiveAssignmentSheet.TempID=AssignmentSheet.TempID,
ArchiveAssignmentSheet.TempIDTEXT=AssignmentSheet.TempIDTEXT,
ArchiveAssignmentSheet.TempName=AssignmentSheet.TempName,
ArchiveAssignmentSheet.Type=AssignmentSheet.Type,
ArchiveAssignmentSheet.WageType=AssignmentSheet.WageType,
ArchiveAssignmentSheet.WeekSubmitted=AssignmentSheet.WeekSubmitted,
ArchiveAssignmentSheet.protectFIELD=AssignmentSheet.protectFIELD

When I run Process01 the 'FIND' brings up everything not just taxweek 1?
Then I have a list of assignmentsheets and it says select one, I do this and click on ok
'Operationn Error Value of TempID Must be provided'

I now have 2 issues -

Issue 1 - ON this test system when I import data the relationships are not coming across hence the above error. How can I copy all the data with the relationships?

Issue2 - If this process runs on the live system (Not that I will ever test this on the live server) when Process01 Runs and the FIND list appears do I have to select each one indivdually to move to the archive BO I was kind of hoping this would be automatic due to the large numbers of records?

Sorry Tom I seem to be asking a lot of questions here. This App I did not write and we are having major issues.

It is frustrating that I cannot copy this data into a test system and see these processes working. I do appricate the help as I have no where else to go on this!

Cheers

tford

Grahsm,

When I run Process01 the 'FIND' brings up everything not just taxweek 1?

1- Is you taxweek attribute defined as NUMBER or PLAIN TEXT? I'm guessing it's PLAIN TEXT. If so, make it '1'.

Then I have a list of assignmentsheets and it says select one, I do this and click on ok

2- Please refer to my original post. You should not have to select AssignmentSheet if you specified AssignmentSheet as a Process Input for Process2.

Tom

ghilton

Hi Tom

TaxWeek Attribute is a 'Number'
Both ITProcess01 & ITProcess02 'Process Input' and 'For this Process' where set to AssignmentSheet, I have removed this for ITProcess01

Graham

tford

Graham,

What what the result after making that change?

Tom

ghilton

Tom

It is hard to tell at the moment as the test system is having these import issues. Just in the middle of reconfiguring the test system as we speak all though the relationships will still be missing!
As soon as I have retested I will let you know

Cheers

ghilton

Hi Tom

Right I have tested the 2 processors and it is still not working. I do not a list of any kind but I see the Operation Error message as the TempID cannot be found. I am assuming this is tied in now with the export and import issue 🙁

Can I recap, when these processes work, what will happen? Does the data copy across to the ArchiveAssignmentSheet BO or is the data moved?
If it is just copied I still then have to remove this from the AssignmentSheet BO! I take it this would be easy to do

Delete AssignmentSheet WHERE AssignmentSheet.TaxWeek=1

Thanks

Graham

tford

Graham,

There is no WHERE is not part of the DELETE syntax. AwareIM will delete the instances that are in context when you use the DELETE action. You will probably want to use FIND.....WHERE & then use DELETE action.

Tom

ghilton

Hi Tom

I figured out the deleting and tested this so I am OK with this. Just need to test these other processes on moving the data!
Any luck on the exporting issue I have now ran out of ideas!

Thanks
Graham