Search found 1460 matches

by PointsWell
Fri Mar 09, 2018 1:32 am
Forum: Tips and Tricks
Topic: Simple REST - Weather
Replies: 5
Views: 14888

Simple REST - Weather

This isn't a tip or a trick, it's just the first REST API call that I have made work. This is a very simple API to get the weather conditions from https://openweathermap.org To use it you will need to register and obtain a key. Store the Key in SystemsSettings.KeyWeather and store it as '&APPID xxxx...
by PointsWell
Thu Mar 08, 2018 9:33 am
Forum: General discussion and questions about Aware IM
Topic: [CLOSED] the OLD Official v8.1 REST thread - examples, ...]
Replies: 14
Views: 28637

Re: the Official v8.1 REST thread - examples, services, etc.

Yeah I have it going into some BOs now, but I am getting a random error that I don't understand So JSON goes into: Weather: Weather.coords Weather.main Weather.weather WeatherCoords: WeatherCoords.lat WeatherCoords.lon WeatherMain: WeatherMain.temp WeatherMain.temp_min WeatherMain.temp_max Etc etc B...
by PointsWell
Thu Mar 08, 2018 6:59 am
Forum: General discussion and questions about Aware IM
Topic: [CLOSED] the OLD Official v8.1 REST thread - examples, ...]
Replies: 14
Views: 28637

Re: the Official v8.1 REST thread - examples, services, etc.

The Singleton message is not an error it is a nota bene reminder that you can only have one instance of the BO when running. What I have done is prefaced the calling of the service with a process step IF NOT EXISTS THEN CREATE. Also I don't think your parameters don't need a ? in them, that is added...
by PointsWell
Sun Mar 04, 2018 3:49 am
Forum: General discussion and questions about Aware IM
Topic: Google Cloud Compute Setup (my Notes)
Replies: 11
Views: 26540

Re: Google Cloud Compute Setup (my Notes)

Hi Pointswell, We’re just reviewing our AWS hosting which is starting to cost a lot. Just wondering how you,ve found Google Cloud’s peformance and durability after 6 months of use. Thanks Hmm, I’m just using it for development at the moment, that said it has been rock solid though I am not at the s...
by PointsWell
Fri Mar 02, 2018 9:55 pm
Forum: General discussion and questions about Aware IM
Topic: Log Viewer
Replies: 5
Views: 8534

Re: Log Viewer

Sorry Bruce I assumed and made an ass outta all of us. From memory the file is Timestamp user something something then the bit you are interested in. It’s a bit of a pain but you can parse it in a spreadsheet. You could probably also use Jasper ETL if you were doing this repeatedly https://community...
by PointsWell
Fri Mar 02, 2018 2:37 am
Forum: General discussion and questions about Aware IM
Topic: Log Viewer
Replies: 5
Views: 8534

Re: Log Viewer

Screen Shot 2018-03-02 at 13.36.12.png
Screen Shot 2018-03-02 at 13.36.12.png (79.04 KiB) Viewed 8528 times
On Server Settings/Logging
File Radio
View hyperlink
by PointsWell
Thu Feb 22, 2018 12:20 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] - SOAP Troubleshoot
Replies: 8
Views: 15760

Re: SOAP Troubleshoot

BenHayat wrote:
PointsWell wrote:
BobK wrote: There is a reason I am not allowed scissors at my desk...
Then, how are you going to do "Cut" & Paste? :)
Generally I go and get a grown up to help with that. :oops:
by PointsWell
Wed Feb 21, 2018 11:48 pm
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] - SOAP Troubleshoot
Replies: 8
Views: 15760

Re: SOAP Troubleshoot

instead of playing post tag, here is my code: BobK - there is a reason why I shouldn't do things when I am tired... After going off and thinking that this has to be an issue with ports on my firewall a simple cut and paste from the Key attribute on my database shows that if your key is 35 character...
by PointsWell
Mon Feb 19, 2018 11:22 pm
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] - SOAP Troubleshoot
Replies: 8
Views: 15760

Re: SOAP Troubleshoot

Its Mondor FX service https://mondor.org and the WSDL is: http://mondor.org/ces/rates.svc?singleWsdl

You'll need a trial API Key from here to use it https://mondor.org/CurrencyExchangeServiceDemo.aspx
by PointsWell
Mon Feb 19, 2018 2:15 am
Forum: Tips and Tricks
Topic: Worked Example of Stored Proc
Replies: 7
Views: 27378

Worked Example of Stored Proc

Thanks to Bruce et al's posts on EXEC_SP I wasn't smart enough to fully understand how EXEC_SP worked initially so I had to go on my own personal development journey. I have a number of BO in my model: Contact Contact_Bank Contact_Bank_Statement Finance_Cashbook A Contact may have one or more Contac...
by PointsWell
Mon Feb 19, 2018 1:51 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] - Running Balances Across Time
Replies: 2
Views: 4388

Re: [SOLVED] - Running Balances Across Time

AIM 7 - Me 0 So AIM proves itself to be smarter than me (again). I had been working on the basis of my understanding of stored procedures in less smart environments requiring an output parameter in order to communicate their result set. After a lot of re-reading of Bruce's (and other's posts) I real...
by PointsWell
Sun Feb 18, 2018 4:50 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] - SOAP Troubleshoot
Replies: 8
Views: 15760

[SOLVED] - SOAP Troubleshoot

I have a Web Service that I am trying to use, but failing. Using http://wsdlbrowser.com I can confirm that the WSDL functions correctly and returns the expected values. When I run it in AIM I get a zero value back, which is the fallback for the service. The AIM Logger shows that AIM thinks it has fi...
by PointsWell
Fri Feb 16, 2018 12:25 am
Forum: Tips and Tricks
Topic: MySQL Service on Mac - Changing the Port
Replies: 0
Views: 5244

MySQL Service on Mac - Changing the Port

So I spent the better part of a day trying to change the default port on mySQL on my desktop. Why? I have a remote server that AIM runs off and I can connect to by an SQL proxy (thereby keeping my database without an external IP address). I also keep some 'useful' data locally but could not maintain...
by PointsWell
Wed Feb 14, 2018 8:04 am
Forum: General discussion and questions about Aware IM
Topic: Incorrect Charts
Replies: 3
Views: 4384

Re: Incorrect Charts

Did you specify Aggregation as SUM for the Y axis? Did you specify Base Unit for the X axis? Have a look how this is done in the Sales Portal app. If you are sure there is a bug please send the BSV and steps to reproduce the problem. The issue is the Aggregation - it now works. From a usability poi...
by PointsWell
Wed Feb 14, 2018 2:20 am
Forum: General discussion and questions about Aware IM
Topic: [SOLVED] - Running Balances Across Time
Replies: 2
Views: 4388

Re: Running Balances Across Time

OK so I can manage to get some decent output using a query on the following (simplified data model): Screen Shot 2018-02-14 at 13.02.59.png I can run the following query: SET @runtot:=0; SELECT `MonthTot`.`Acc` AS `Account`, `MonthTot`.`Curr` AS `Curr`, `MonthTot`.`TXNYEAR` AS `Year`, `MonthTot`.`TX...