Search found 139 matches

by KnightWare
Fri Apr 19, 2019 6:32 pm
Forum: General discussion and questions about Aware IM
Topic: Export with template
Replies: 0
Views: 3687

Export with template

If I setup an Export template and name the columns (below) I expected the export to put the Column Names in as header row followed by data. However nothing exports. Empty. If I change back to Column Names A,B,C,D ect. Then export, no header row. What did I miss? Attribute or Expression maps Column -...
by KnightWare
Thu Apr 18, 2019 7:02 pm
Forum: General discussion and questions about Aware IM
Topic: Export and Import
Replies: 5
Views: 8033

Re: Export and Import

Each Parent has Multiple Children. Each child has Multiple children.
Parent = Property.
Child = Suite(s).
Grandchild = Tenant.

I want to setup Import templates to do the work. But having trouble understanding the references and how I should do so.
by KnightWare
Thu Feb 28, 2019 3:25 pm
Forum: General discussion and questions about Aware IM
Topic: Export and Import
Replies: 5
Views: 8033

Re: Export and Import

Let me ask this another way. How do you Export from a Parent / Child / Grandchild relationship ( From your TEST project) to populate (Import) into your Production? I can't figure out how to import using the ID's from TEST records, Imports create their own ID's. I exported my Parent from test and imp...
by KnightWare
Wed Feb 27, 2019 1:27 pm
Forum: General discussion and questions about Aware IM
Topic: Export locks screen
Replies: 0
Views: 3179

Export locks screen

I've been working with Import/Export to figure out how to do relational data. I've noticed every time I run the Export process, the file writes, but the screen is locked. No interaction. I have to quit the session and restart. This is happening under test. Am I missing something?
by KnightWare
Tue Feb 26, 2019 7:00 pm
Forum: General discussion and questions about Aware IM
Topic: Export and Import
Replies: 5
Views: 8033

Export and Import

Trying to Import BO's from Parent down thru Child/Grandchild relations from out TEST system to Seed the Production system (Initial Data). I've Exported the three tables with ID's & Relationships. Can't seem to get a handle on how to import with the ID's so that New ID's are NOT generated.
by KnightWare
Thu Feb 21, 2019 9:22 pm
Forum: General discussion and questions about Aware IM
Topic: Syntax for updating all other child records except current.
Replies: 4
Views: 6076

Re: Syntax for updating all other child records except curre

I'll add, that according to the Rules Log, the Find is finding the other child records. It find s a count of child records -1.
by KnightWare
Thu Feb 21, 2019 7:34 pm
Forum: General discussion and questions about Aware IM
Topic: Syntax for updating all other child records except current.
Replies: 4
Views: 6076

Syntax for updating all other child records except current.

Parent (SUITES) / child (TENANT). SUITES owns TENANT. Suites.Tenant = relationship of all Tenants owned by Suites. Teant.Suite = relationship from Tenant back to Suite. During an Create/EDIT of the child (TENANT) , if I turn on a value, on save I want all other children of this parent value turned o...
by KnightWare
Mon Feb 04, 2019 4:44 pm
Forum: General discussion and questions about Aware IM
Topic: Excel like form
Replies: 2
Views: 3387

Excel like form

Is it possible to have an Entry form that is row based, aka Excel? The fields would be text or list boxes. Similar to a query, but you can copy a row (fields) as a new row and change data, or add blank row filling in contents? Copy/Save/Delete buttons would be on each row. I thought I was this somew...
by KnightWare
Fri Jan 18, 2019 8:39 pm
Forum: General discussion and questions about Aware IM
Topic: Not present when
Replies: 7
Views: 8093

Re: Not present when

You are correct. Lot's of left-overs from trial and error development.
by KnightWare
Fri Jan 18, 2019 6:06 pm
Forum: General discussion and questions about Aware IM
Topic: Not present when
Replies: 7
Views: 8093

Re: Not present when

Yes - Works both ways. Changed to
ThisProperty.CreateDate IS UNDEFINED

And works perfectly.
by KnightWare
Thu Jan 17, 2019 9:59 pm
Forum: General discussion and questions about Aware IM
Topic: Not present when
Replies: 7
Views: 8093

Re: Not present when

Figured it out - my crazy way. On the Parent, named PROPERTY, BO I added a new attribute "CreateDate". I added a business rule to the create/modified rules of the form to populate with CURRENT_DATE when the condition IS NEW. I set the form Initialization property of the rule to "FALSE" so it populat...
by KnightWare
Thu Jan 17, 2019 7:24 pm
Forum: General discussion and questions about Aware IM
Topic: Not present when
Replies: 7
Views: 8093

Not present when

Having trouble with condition rule for the Not Present When property of a separator section on a form. The form is parent/child. On a new parent I want the child section within the separator to be "not Present". When the user saves the form (Creates the new parent), then the section should appear to...
by KnightWare
Mon Nov 12, 2018 2:06 pm
Forum: General discussion and questions about Aware IM
Topic: Initialize Form Data
Replies: 6
Views: 8746

Re: Initialize Form Data

I did toy with this, as first. However, while the VendorLog application is a AwareIM Data Aware , the Vendor Master lives in an External MS SQL server DB, 13000+ entries. I've had trouble setting up this type relationship. Could be me.
by KnightWare
Fri Nov 09, 2018 4:12 pm
Forum: General discussion and questions about Aware IM
Topic: Initialize Form Data
Replies: 6
Views: 8746

Re: Initialize Form Data

Think I got this. I set the BO Update Rules from 'Automatic' to 'Yes' so they are forced to run on intialization. I've also setup a secondary form with the Tab order starting on the first field away from all those populating. Doesn't seem to be taking the focus.

Onto That one now.