Aware IM User Forums

It appears I was doing my FIND statement backwards. I had
FIND OrderHeader WHERE... =Customer...
it should be
FIND Customer WHERE Customer.customer_id=OrderHeader.customer_id
OrderHeader.customer=customer ( that worked)

Hello, The image attached has 6 columns. Column 3 and 6 are not spacing correctly. They are to far the the right. Nothing I do changes the display. If I view the elements in the browser I can see that columns 3 & 4 are 155 px wide I can change them to be 81 px wide in the browser and then it display...

passing in AIM_Customer,AIM_OrderHdr & AIM_OrderLine, not sure if they are all needed? The rule to create the order header is on the order line BO. Rule On AIM_OrderlIne BO is: IF AIM_OrderLine IS NEW THEN RelatesOrderLineWithOrderHdrs Relate Order lines With Order Hdrs Process Rule#1 FIND AIM_Order...

Hello, Working with External SQL DB and we are having to refresh some AwareIM tables with data from the external DB I have a process that will go find all the orders for a part#. All this is working good. But then I need to get the relationship between the Order Header and the Customer. I have the r...

So you are using a process to CREATE or Update the data in your AIM BO rather than an Import from a csv or some other format is that correct?
Do you find this method easier and faster when updating data?

Yes, but after reading it again it make a little more sense now! Also the video on import & Export templates helped. Having to go through all these step to get data into AwareIM is tedious, its to bad AIM can't use the relationships when access external DB's. Its seems like you have to create a AIM ...

Changing the '=No' to a ='Yes' resolved the issue and the import process worked.

Hello, I have a question about importing data from a csv file. Looking at the sample apps I noticed that some of the csv files used already have shortcuts in them. If you are receiving data from a 3rd party system via csv file how are the shortcuts suppose to get in there? Does the 3rd Party need to...

Can't seem to figure out why the rules and Import process is failing when doing an import process. StartDate in MRP BO is not being set to start date set in MRPImport BO See log record below. This is the Rule I have on the BO HamiltonMRP IF HamiltonMRP IS NEW THEN HamiltonMRP.ob_MRPImport=MRPImports...

Hello, I have external tables from a MS-SQL DB. I have pulled them into AIM. What is the best method to get the data exported and imported in to the AIM version of all the BO's with AIM relationships established? For example I exported the Supplier table and imported it in to the AIM Supplier BO. Th...

I tried searching for previous posts on that. Do you have any suggestions in what keywords to search for?

Also when reading large amounts of records like this what is the best number to use for the "IN BATCHES OF" number, 100, 1000, 10,000?

probably a littler over 30-40 minutes.

Hello,
Trying to create records for native PO_Line BO from MS-SQL External PO_Line Table. SQL table has 98,471 records. AwareIM is timing out after 26,000 have been created. Not sure why?
Any idea's on what to look at?

Roger

I think I figured it out. I Was passing the customer BO as input once I removed that it ran and created all the records in the new BO.