Thanks
Search found 545 matches
- Mon Jan 30, 2023 1:33 pm
- Forum: General discussion and questions about Aware IM
- Topic: Time Math -- Easy in SQL what about in Aware?
- Replies: 5
- Views: 3716
- Fri Jan 27, 2023 8:16 pm
- Forum: General discussion and questions about Aware IM
- Topic: Time Math -- Easy in SQL what about in Aware?
- Replies: 5
- Views: 3716
Re: Time Math -- Easy in SQL what about in Aware?
Out of curiosity, how would you do that in SQL?
- Mon Jan 23, 2023 5:39 pm
- Forum: General discussion and questions about Aware IM
- Topic: How to store images returned by REST service
- Replies: 14
- Views: 31276
Re: How to store images returned by REST service
karelh, I am not sure this is possible with AwareIM out of the box. I expose a web service that allows users to send us a picture, and the data for that picture needs to be in a certain format. See forum post: https://www.awareim.com/forum/viewtopic.php?f=1&t=11766 I am exposing a web service and yo...
- Fri Nov 04, 2022 12:56 pm
- Forum: General discussion and questions about Aware IM
- Topic: Parent Child functionality
- Replies: 3
- Views: 1387
Re: Parent Child functionality
Also, this is my first entry in this forum. If there is a better place to ask questions such as this, please let me know. This is the place and welcome. ...does the process of importing child records automatically create the requisite parent record? No. I am not sure this will work but you might tr...
- Fri Nov 04, 2022 12:47 pm
- Forum: General discussion and questions about Aware IM
- Topic: Updating calculation after Importing records
- Replies: 4
- Views: 1711
Re: Updating calculation after Importing records
You can use Validation on the import. This will cause the BO rules to execute.
If you are using the IMPORT action in a rule, add
WITH VALIDATION
to your rule.
if you are using the Import menu option, select the Validate option.
See the User Guide for more details
If you are using the IMPORT action in a rule, add
WITH VALIDATION
to your rule.
if you are using the Import menu option, select the Validate option.
See the User Guide for more details
- Fri Oct 14, 2022 4:37 pm
- Forum: Problem reports
- Topic: Import Data Using A Java Plugin Issue
- Replies: 1
- Views: 12124
Re: Import Data Using A Java Plugin Issue
obt123, Are you still looking for an answer to this? Whether you are or not, here is my answer. I think the error you are getting C:\\Users\\Administrator\\Downloads\\Imports\\Contact.csv was not found is coming from your s4 parameter. Try putting null in that parameter. For you s2 parameter, you sh...
- Tue Aug 23, 2022 12:19 pm
- Forum: General discussion and questions about Aware IM
- Topic: Pasting from MS Word to Text Area causes error
- Replies: 8
- Views: 2951
Re: Pasting from MS Word to Text Area causes error
if you decide to remove those characters, the following will do it: ExecutiveSummary.Narrative=REPLACE_PATTERN(REPLACE_PATTERN(ExecutiveSummary.Narrative, '[\x00-\x1F]', ''), '[\x7F-\xFF]', '') That will remove the 'xF0\x9F\x87\xBa\xF0\x9F' that were in you gif plus any other formatting or control c...
- Thu Jun 23, 2022 12:39 pm
- Forum: General discussion and questions about Aware IM
- Topic: Can I add Minutes to TimeStamp?
- Replies: 12
- Views: 10982
Re: Can I add Minutes to TimeStamp?
There has been a few times I wish there was a START_OF_DAY (similar to START_OF_WEEK) that returned a timestamp with HOURS, MINUTES and SECONDS all set to 00PointsWell wrote: ↑Thu Jun 23, 2022 6:03 am The whole area of Time is inconsistently managed.
There's no WEEK_ADD or YEAR_ADD either.
- Thu Jun 23, 2022 12:36 pm
- Forum: General discussion and questions about Aware IM
- Topic: Can I add Minutes to TimeStamp?
- Replies: 12
- Views: 10982
Re: Can I add Minutes to TimeStamp?
I would convert minutes to hours. I don't think the minutes function exists. To convert minutes to hours use fractions. example: TIME_ADD('2022-06-23 08:30:00', 0.50) returns '2022-06-23 09:00:00' Note: I think it was fixed several builds back, but there was a time when subtracting fractions (-0.50...
- Thu Jun 16, 2022 3:38 pm
- Forum: Problem reports
- Topic: Retrieve a list of payments via REST-API (SOLVED)
- Replies: 4
- Views: 7288
Re: Retrieve a list of payments via REST-API
Having multiple levels should not be an issue.
Can you post the details of your set up.
Can you post the details of your set up.
- Thu May 26, 2022 10:05 pm
- Forum: General discussion and questions about Aware IM
- Topic: How to default a value in a query
- Replies: 5
- Views: 2918
Re: How to default a value in a query
Thanks Jaymer, I will take a look at the new-ish fields and options you mentioned.
- Thu May 26, 2022 11:51 am
- Forum: General discussion and questions about Aware IM
- Topic: How to default a value in a query
- Replies: 5
- Views: 2918
Re: How to default a value in a query
No. There are multiple fields prompting for a value but not all of them require a default value.
I just choose the date field as an example and because for dates, the default will change daily.
I just choose the date field as an example and because for dates, the default will change daily.
- Wed May 25, 2022 6:46 pm
- Forum: General discussion and questions about Aware IM
- Topic: How to default a value in a query
- Replies: 5
- Views: 2918
How to default a value in a query
When executing a query that uses (Ask at run-time) is it possible to default the value so that the user does not need to enter it? Specifically, if the query is searching a data field and the majority of the time the date being searched for is the current date, I would like the date field on the que...
- Sun Apr 10, 2022 8:58 pm
- Forum: General discussion and questions about Aware IM
- Topic: Substracting 3 time attributes
- Replies: 2
- Views: 1784
Re: Substracting 3 time attributes
I am just guessing, but here is what I think is causing your error. Subtracting a TimeStamp from a TimeStamp (Work.EndTime - Work.Starttime) gives you a Duration. Subtracting your third TimeStamp (Work.PauzeTime) from the Duration gives you your error. What does PauzeTime represent? A point in time ...
- Wed Apr 06, 2022 12:29 pm
- Forum: General discussion and questions about Aware IM
- Topic: This issue still exists after 14 years
- Replies: 7
- Views: 2949
Re: This issue still exists after 14 years
I occasionally have this issue too. Aware thinks processes are running which prevents BSV from being published. The processes in question are not running and I have not been able to determine why Aware thinks they are still running. In my case, I just reset Aware and publish the BSV. Any users activ...