Automate Creation of BO

leopdurr

Does any know of a way to automate the creation of some Business Object and the attributes in bulk? I tried using the "Add from JSON Schema" but cannot seems to find any documentation on how the structure of the Schema should be or an example.
I also tried doing this using SQL but the Attributes does not appear in AwareIM, It is possible that I did it incorrect or not even supported.

Help Anyone.

nhofkes

It depends a little bit what the source is for your bulk process.
Have you looked at the various CREATE id() FOR EACH options? (https://www.awareim.com/dokuwiki/a_f/a/create)
For example:

CREATE BO FOR EACH NUMBER BETWEEN 1 AND 100
CREATE Attachment FOR EACH FILE IN 'c:/mydirectory'
CREATE Transaction FOR EACH DATE IN SomeObject.SelectedDates WITH Transaction.AppliedDate=LOOP_ITERATION

Or, if the source are some other existing objects, you could do something like:

FIND SourceBO WHERE (Condition)
Subprocess_Create_Related_BO Using SourceBO

The Subprocess must have the SourceBO as input, and can then CREATE a new BO that is based on the SourceBO.

With some creativity, there is a lot more possible than you might think using standard AwareIM actions.

If the BOs are based on external data, look at the import functionality (https://www.awareim.com/dokuwiki/docs/2000_concepts/0900_prod_feats/0600_export_import)

You should not use SQL for this purpose, as there is a big risk that the tables will not be in the correct format for AwareIM. And there should be no need to do so.

BLOMASKY

Let me politely offer a different opinion. If you are comfortable with SQL selects and insert statements, there can be substantial performance enhancements. There are really on 2 areas you have to understand to not screw up SQL inserts. 1st, is that every AwareBO has an ID, BASVERSION and BASTIMESTAMP field. Creating the ID is easy assuming you use the SEQUENCE that Aware uses to generate unique IDs. The BASVERSION can always be 1 and the BASTIMESTAMP gets the result of getdate().
The 2nd is the way Aware generates foreign keys. There are 3 fields in the "child" table. FKName_REN, FKName_RID and FKName_REF. The 1st, (REN) is the name of the parent BO. Then RID is the ID of the parent BO and the REF is optional, depending on if you created a matching reference in the parent table. If so, it gets that name.
There are so many places where I need SQL to create a complex result BO for the user to view that would be either impossible or very very slow to do in Aware. I write Stored procedures like this often:

INSERT INTO [dbo].[DesignSummary]([ID], [BASVERSION], [BASTIMESTAMP],
[ps_OrderLine_REN], [ps_OrderLine_RID],
[ps_Customer_REN], [ps_Customer_RID],
[ps_TargetUnit_REN], [ps_TargetUnit_RID],
[ps_Item_REN], [ps_Item_RID],
[wholeUnitOrder],[noWU], [noSources], EWX, [takeUM], [tookUM],
[sourceUnitDug], [handleStatus], orderLineForDisplay, priorityDesign, designDate)

select next value for mySEQ, 1, getdate(),
'OrderLines', L.ID as ps_OrderLine_RID,
'Customers', C.ID as ps_Customer_RID,
'Units', DSM.targetUnitID as ps_TargetUnit_RID,
'Items', I.ID as ps_Item_RID,
L.wholeUnits as wholeUnitOrder,
OU.noWU - 1 as noWU, DSM.noSources, DSM.EWX, takeUM, tookUM,
sourceUnitDug, case when handleIsComplete = 1 then 'Complete'
when handleIsActive = 1 then 'Active'
when handleIsServed = 1 then 'Served'
else '' end as handleStatus, L.orderLineForDisplay, isnull(L.priorityDesign,0), DSM.designDate
from OrderLines L inner join Orders O on L.ob_Orders_RID = O.ID
inner join Customers C on O.ob_Customers_RID = C.ID
inner join Items I on L.ob_Items_RID = I.ID
left outer join DesignSummaryForMobile DSM on L.ID = DSM.orderLineID
left outer join (select ps_OrderLines_RID, count(*) as noWU from Units
group by ps_OrderLines_RID) as OU
on OU.ps_OrderLines_RID = L.ID
where L.dateShipped is null and L.designStatus <> ''

Jaymer

I SHOULD HAVE SAID THIS after Neils comment... I dont think that what OP is saying.
I read it as:

How can I create a Business Object and the fields in my app 'automatically' without using the config tool.

He's not talking about data base table rows/tuples.
He wants to create a new BO based on dynamic data coming from who knows where - he didn't say.
He 'tried using SQL" - sure, he created the table with fields, but the fields "does not appear in" the config tool.

leopdurr

Thank everyone for your reply.

I can use SQL to populate the data without issue which I have been doing. But I needed to create an Audit workflow in my Application that require about 7 BO. I wanted to know if there is an better way to do this without create them separately. I tried using SQL but the BO does not show up in AwareIM even after restarting the application.
I tried using the JSON method, because there are not documentation on the format of “Add from JSON Schema” it does not work, all sort of BO get created including the name of some of the attribute get created as BO (Rubbish).

I was able to create them manually and using SQL to populate all the BO with the data that I needed.

Thanks

Jaymer

lol. I still don’t understand.

nhofkes

I would think that if you are using 7 different BOs just for an audit workflow, the design may be suboptimal. Having so many different types of BO will make your application hard to maintain - also taking into account that there are some unexpected gotchas if you try to handle them through a BO group. In my view, it would be better to create one BO for the audit workflow and reflect the 7 variations/types/classification in some attributes of that BO.