Search found 907 matches

by RocketRod
Thu Nov 26, 2015 4:25 am
Forum: General discussion and questions about Aware IM
Topic: Error while updating external MS_SQL DB
Replies: 28
Views: 20028

Re: Error while updating external MS_SQL DB

Are you trying to put a null then into one of your number attributes instead of zero?

Cheers Rod
by RocketRod
Thu Nov 26, 2015 4:08 am
Forum: General discussion and questions about Aware IM
Topic: Error while updating external MS_SQL DB
Replies: 28
Views: 20028

Re: Error while updating external MS_SQL DB

Then as Tom suggested check all your rules on both the line item and header tables as the header will be most likely updated as well. Also check initial attribute values in case one of them is incorrect. Somewhere you must be trying to change a text value into a number attribute. Also if you turn on...
by RocketRod
Thu Nov 26, 2015 3:44 am
Forum: General discussion and questions about Aware IM
Topic: Error while updating external MS_SQL DB
Replies: 28
Views: 20028

Re: Error while updating external MS_SQL DB

Are you sure your completed attribute on the line is defined as Plain Text and not Number?

Cheers Rod
by RocketRod
Thu Nov 26, 2015 3:37 am
Forum: General discussion and questions about Aware IM
Topic: ►Your Feeback Please!◄ Scheduled processes
Replies: 8
Views: 6477

Re: ►Your Feeback Please!◄ Scheduled processes

Yes that's the idea. Not sure how long your processes take to execute for you would need to add another check if they take less than a minute. Otherwise they will execute more than once a day.

CHeers Rod
by RocketRod
Tue Nov 24, 2015 9:02 pm
Forum: General discussion and questions about Aware IM
Topic: ►Your Feeback Please!◄ Scheduled processes
Replies: 8
Views: 6477

Re: ►Your Feeback Please!◄ Scheduled processes

Be careful setting execution time to a specific value as I have had issues in the past of non execution due to time not matching (seconds value I guess). I have therefore had to do some workarounds.

Cheers Rod
by RocketRod
Wed Oct 14, 2015 1:05 am
Forum: General discussion and questions about Aware IM
Topic: Wish List New version builds
Replies: 2
Views: 2339

Re: Wish List New version builds

Thanks Mark. I do something similar but a little more mechanical. Just think that AwareIM could with minimal fuss put these things in which would be of benefit to all especially those that have little IT knowledge.

Cheers Rod
by RocketRod
Tue Oct 13, 2015 8:56 pm
Forum: General discussion and questions about Aware IM
Topic: Wish List New version builds
Replies: 2
Views: 2339

Wish List New version builds

I would like when upgrading versions of AwareIM to: 1. Have ALL memory settings retained. 2. Have it prompt for web folder name and update the appropriate files accordingly. 3. Leave undeleted all files and folders within the AwareIM folder structure that start with a predetermined character naming ...
by RocketRod
Tue Oct 13, 2015 8:49 pm
Forum: General discussion and questions about Aware IM
Topic: Thought - AwareIM Lite
Replies: 6
Views: 5150

Thought - AwareIM Lite

In order to spread the availability and awareness of AwareIM and allow it for personal use, would you consider introducing a lite version. This could be done simply by limiting the number of BSVs, BOs, queries and processes that can be built within the Config tool. You could also limit extras such a...
by RocketRod
Wed Sep 23, 2015 9:21 pm
Forum: General discussion and questions about Aware IM
Topic: Custom sql query without stores procedure
Replies: 4
Views: 4171

Re: Custom sql query without stores procedure

Can you give a little more detail. You can connect to a SQL view using external BO and you can write quite complex SQL code within a query itself.

Cheers Rod
by RocketRod
Tue Sep 22, 2015 9:41 pm
Forum: General discussion and questions about Aware IM
Topic: reuse a query
Replies: 6
Views: 4886

Re: reuse a query

One way to do it is to modify the SQL statement using the SQL form tab of the query. By modifying SQL statements you can make your queries very powerful and flexible. In this instance I assume you have an attribute to designate a manager. So you could use something like: FIND Personnel where (Logged...
by RocketRod
Fri Sep 11, 2015 1:10 am
Forum: General discussion and questions about Aware IM
Topic: Mobile features of version 7.0
Replies: 54
Views: 46567

Re: Mobile features of version 7.0

"To be able to display search attributes on a query display rather than have to display a search form then the query results and use filters to get where you want to." The issue for me here is the delay in displaying information on a mobile when the query results are large. So I'd like a search butt...
by RocketRod
Tue Sep 08, 2015 10:48 pm
Forum: General discussion and questions about Aware IM
Topic: Mobile features of version 7.0
Replies: 54
Views: 46567

Re: Mobile features of version 7.0

Thanks Support. I'll put my list in general/AwareIM terms. Basically I would like the mobile version of AwareIM to look and operate as a true mobile application. This will hopefully be achieved by moving to the new toolset. I would like the following: Good looking themes. Place a menu that fills the...
by RocketRod
Tue Aug 25, 2015 6:23 am
Forum: General discussion and questions about Aware IM
Topic: Average of Two different records
Replies: 4
Views: 3845

Re: Average of Two different records

I thought about summing both 6 months totals and then dividing by 12 for manually doing the average, but it actually may not be a full 12 months. What do you mean it may not be a full 12 months? A month of zero value should be included in the average so why would you not divide by 12? Or are you sa...
by RocketRod
Thu Aug 20, 2015 6:28 am
Forum: General discussion and questions about Aware IM
Topic: Next big release - ext js6?
Replies: 71
Views: 52018

Re: Next big release - ext js6?

Support can you tell us yet if such things as mobile functionality and Gnatt charts will be separate licence add ons or with the change to the new product will everything be under the one licence?

Cheers Rod
by RocketRod
Sun Aug 16, 2015 10:04 pm
Forum: General discussion and questions about Aware IM
Topic: Aware's Reporting - Jasper Reports upgrade for next release?
Replies: 37
Views: 43573

Re: Aware's Reporting - Jasper Reports upgrade for next rele

Yuri that's similar to what I do currently with Microsoft reporting services. Ben yes the SQL statement is the hardest issue for some. In the statement you have to join the tables knowing how AwareIm works with its rel tables etc. In other words build the joins manually. It's quite easy for those wh...