Search found 139 matches
- 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 -...
- 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.
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.
- 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...
- 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?
- 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.
- Fri Feb 22, 2019 1:19 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
Jaymer - you sir are a genius.
OtherBO
OtherBO
- 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.
- 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...
- 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...
- 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.
- 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.
ThisProperty.CreateDate IS UNDEFINED
And works perfectly.
- 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...
- 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...
- 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.
- 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.
Onto That one now.