Search found 1142 matches

by ACDC
Fri Jul 28, 2023 10:28 pm
Forum: General discussion and questions about Aware IM
Topic: Several business spaces with a single database
Replies: 17
Views: 39139

Re: Several business spaces with a single database

Off topic Mark, did you manually create all the foreign key relationships to your DB? Or do you have some magic way to create those to then map your ERD? Having foreign keys embedded in the DB makes it more compatible to external BI tools and reporting apps. Would this not be a great feature to hav...
by ACDC
Tue Jul 25, 2023 9:35 pm
Forum: General discussion and questions about Aware IM
Topic: Config Tool Windows aren't sized correctly
Replies: 7
Views: 9143

Re: Config Tool Windows aren't sized correctly

I am sure a way around this problem is to simply increase the default size of the pop-up forms in the Configurator. Why are the pop-up forms that small anyway. We can at least double the size of the width, also some on the height. I find myself always having to stretch the form to see rule details. ...
by ACDC
Mon Jul 24, 2023 5:53 pm
Forum: General discussion and questions about Aware IM
Topic: Config Tool Windows aren't sized correctly
Replies: 7
Views: 9143

Re: Config Tool Windows aren't sized correctly

Lots of places for a new user to totally get hung up and frustrated. Totally agree, new users move on There are numerous places where this occurs, the only way sometimes is to change screen res to access the settings. Adjusting the form size ignores the area in the form that needs adjusting. All th...
by ACDC
Thu Jul 13, 2023 8:49 pm
Forum: Wish List
Topic: Rest - Sort Order
Replies: 0
Views: 54641

Rest - Sort Order

The Rest service in the service setup lacks a logical sort order, which can be quite frustrating when dealing with multiple services. It becomes difficult to sift through the list without any specific order. It would be greatly appreciated if the list could be sorted alphabetically based on the serv...
by ACDC
Wed Jul 05, 2023 7:12 pm
Forum: General discussion and questions about Aware IM
Topic: REST configuration- Boolean being sent as text in a POST
Replies: 5
Views: 5225

Re: REST configuration- Boolean being sent as text in a POST

but I create a JSON_String field/object in the User Table or the new NP in-memory table... building a string to match the endpoint requirements and then I use "Take from context" specifying that table and field that has the JSON. So you are building the json string manually ? If there was a functio...
by ACDC
Tue Jul 04, 2023 1:55 am
Forum: General discussion and questions about Aware IM
Topic: REST configuration- Boolean being sent as text in a POST
Replies: 5
Views: 5225

Re: REST configuration- Boolean being sent as text in a POST

I also think I'd never use "Take from context" using the "None" attribute (as you must be doing) because then all fields from that table would be sent to that API and what about extra fields you don't want to send them? Yes, you can exclude some fields in the service, but that might be a huge list ...
by ACDC
Tue Jul 04, 2023 1:41 am
Forum: General discussion and questions about Aware IM
Topic: REST configuration- Boolean being sent as text in a POST
Replies: 5
Views: 5225

Re: REST configuration- Boolean being sent as text in a POST

I'm not sure why you say "Take from context" is so powerful. I've used this a lot - but I create a JSON_String field/object in the User Table or the new NP in-memory table... building a string to match the endpoint requirements and then I use "Take from context" specifying that table and field that...
by ACDC
Mon Jul 03, 2023 8:26 pm
Forum: Problem reports
Topic: Configurator - memory leaks,
Replies: 14
Views: 72444

Re: Configurator - memory leaks,

aware_support wrote: Mon Mar 15, 2021 2:49 am Thanks, this is not a memory leak - just a regular bug
This problem still persists
by ACDC
Mon Jul 03, 2023 6:36 pm
Forum: Problem reports
Topic: REST- handling Boolean - Yes/No, 2 issues
Replies: 1
Views: 11559

REST- handling Boolean - Yes/No, 2 issues

I am re-listing this post to the problem area,hopefully it will get traction. Summary:(two separate problems) 1. The boolean (YesNo) is being sent as though it were text and resulting in a failed POST attempt. 2. Also the boolean is being sent as a "yes" or "no" , when it should be sent as "true" or...
by ACDC
Wed Jun 21, 2023 6:19 pm
Forum: General discussion and questions about Aware IM
Topic: Import csv works but same with xls/xlsx gives parser error
Replies: 3
Views: 10110

Re: Import csv works but same with xls/xlsx gives parser error

An alternative approach to address this issue involves converting the file into a MySql table and utilizing the external database table. This approach enables the importation of intricate Excel files, including multiple sheets. I personally rely on this method for all my data import tasks. Additiona...
by ACDC
Thu Jun 08, 2023 11:36 pm
Forum: General discussion and questions about Aware IM
Topic: Several business spaces with a single database
Replies: 17
Views: 39139

Re: Several business spaces with a single database

I suppose the obvious approach is to build one bsv covering all users and functions, I would agree, going separate databases could become a nightmare to manage, especially if you have to share data between the applications. Why would you want to do this other than ease of update, a single DB would ...
by ACDC
Fri May 26, 2023 11:22 pm
Forum: General discussion and questions about Aware IM
Topic: Cloning an app to same server after migrating from MySQL to MariaDB
Replies: 5
Views: 3767

Re: Cloning an app to same server after migrating from MySQL to MariaDB

or just ask ChatGPT :D The error message you received indicates that the row size in your database table is too large. In MySQL, the maximum row size is 65,535 bytes. The specific error message you provided suggests that the row size exceeds this limit (8126 bytes). To resolve this issue, you can co...
by ACDC
Wed May 24, 2023 6:13 pm
Forum: Wish List
Topic: GUID Function needed for REST POST endpoints
Replies: 5
Views: 23435

Re: GUID Function needed for REST POST endpoints

In my case, I want to include the Object.ID as part of the remote GUID, so at any time I can backtrack where the transaction came from.
both seem to be good options, Thanks again
by ACDC
Tue May 23, 2023 5:12 pm
Forum: Wish List
Topic: GUID Function needed for REST POST endpoints
Replies: 5
Views: 23435

Re: GUID Function needed for REST POST endpoints

Thank you, this will work for me .

What are your thoughts about inserting a timestamp in the formula ?
by ACDC
Fri May 12, 2023 5:23 am
Forum: Wish List
Topic: GUID Function needed for REST POST endpoints
Replies: 5
Views: 23435

GUID Function needed for REST POST endpoints

When configuring a REST setup and utilizing the POST method to create a new entry, it's often necessary to provide a unique identifier in the target application. It would be highly beneficial to have a function that can generate a GUID specifically for this purpose. The AwareIM ID attribute may not ...