Aware IM User Forums

I have a BO called MyData with attributes for Easting and Northing. Imagine the data looking like ID Easting Northing 1 1,000 12,345 2 1,101 12,456 3 1,342 12,342 4 1,355 12,411 5 1,378 12,503 6 1,402 12,475 I have another temporary BO called Delta which has two attributes, Dx and Dy I need to loop ...

I have a BO that could have 1000's records. Users import data which gets added to this BO. I IMPORT and CREATE the new records, however, for each set of imported data I need a sequence number starting at 1 and with the last imported record being the total number of records imported during that impor...

Managed to get it to work with only one caveat. ENTER NEW FileUpload USING Main EXPORT DOCUMENT FileUpload.FileToUpload TO FILE 'mydata.csv' IMPORT HaulData FROM 'mydata.csv' FIND ALL HaulData ORDER BY HaulData.ID CREATE HaulProfiles FOR EACH HaulData WITH HaulProfiles.Analysis=Analyses,HaulProfiles...

Hi James. Yes that works. Thanx. One issue though.... I have two BOs. Analyses and HaulData HaulData is owned by Analyses My HaulData has the following attributes... SegmentCode text Easting number Northing number RL number Analysis Analyses I call the importation process from an Analyses and pass A...

Yes. I can do that and I can get it to import the file (.csv) into the document attribute. But, is it then possible to point to that attribute as an argument for the IMPORT FROM Normally IMPORT myBO FROM 'C:\mydocs\myfile.csv But now I import the file into fileBO IMPORT myBO FROM fileBO Unless I am ...

Oh really.

File select will work for my purpose.

How can that be accomplished.

I can see IMPORT myobject FROM 'C:/mydocuments/psa.csv'

So, if i can use that but have the user select the file to import rather than have is hard coded, that would be great.

Cheers,
Mark

I want each user to be able to set a default folder path.

Is there any funtionality in AwareIM that will pop up a folder selection dialog
and then allow me to take that selected folder path and save it to a BO attribute?

Cheers,
Mark

I have a Rule as Follows.... Condition 1 UserEntities.EntityUser.DefaultEntityCount=1 Condition 2 UserEntities.DefaultEntity='No' Action 1 READ PROTECT UserEntities.DefaultEntity FROM ALL This is intended to hide any of the DefaultEntity of any record where it = 'No' if any one of the records = 'Yes...

Ah.....

FIND Equipment WHERE MyDate>=Equipment.EffectiveDate ORDER BY Equipment.EffectiveDate DESC TAKE BEST 1

Solved.

Awesome.

I have a BO Equipment with attributes Effective Date Equipment So the data looks like 01/04/2010 Type A 18/09/2011 Type B 24/06/2012 Type C So I need to retrieve an item of Equipment for a particular Date. For example if my enquiry date is 14/10/2011 then I need to get Type B. And if my enquiry date...

Worked it out.

Hi, I have two BOs. One called Entities and one called Incidents. Each Entity can have many Incidents and the Incident Number must contiguous for each Entity. For example, each Entity must have an Incident number 1, 2 and 3 etc. My Entity BO has an EntityCode and a LastIncidentNumber attribute. My I...

Just wondering if anyone might be able to give me a tip on how to fix the
following error please?

Server encountered an exception Error altering reference tables 'DROP TABLE' cannot be performed on 'BASTESTDOMAINTESTSAFETYSYSTEM_ENTITIES_REF' because it does not exist.

Cheers,
Mark

Hey. thanx for the heads up fuseon.

I am not a front to back reading type so missed this in my eagness to get into it.

Cheers,
Mark

I have a query which displays a table of all records from a BO. I then have an Default Operation which calls another Query. This second Query gets called each time the user selects a row from the first table. Can anyone suggest a way to force the first displayed record to be Selected as soon as the ...