Use the ESF Database Migration Toolkit
I use it all the time and it is brilliant.
https://www.dbsofts.com
Search found 2392 matches
- Fri May 26, 2023 8:03 am
- Forum: General discussion and questions about Aware IM
- Topic: Cloning an app to same server after migrating from MySQL to MariaDB
- Replies: 5
- Views: 3383
- Mon May 22, 2023 11:01 pm
- Forum: General discussion and questions about Aware IM
- Topic: Exporting Calendar PDF to server
- Replies: 2
- Views: 1236
Re: Exporting Calendar PDF to server
You can do this.... EXPORT DOCUMENT 'EXPENSE CLAIM' TO FOLDER 'C:\expense'+ExpenseClaim.ExpenseClaimNumber+'\' I use similar for Expense Claims. I export an Expense Claim and then all of the Receipts to a unique folder. Then I use PDF Combine Pro X to merge the Expense Claim PDF and all of the Recei...
- Tue May 09, 2023 1:39 am
- Forum: General discussion and questions about Aware IM
- Topic: AwareIM as a data migration tool
- Replies: 3
- Views: 2381
Re: AwareIM as a data migration tool
This is the best data migration tool I have ever found. It is just brilliant.
The ESF Data Migration Toolkit.
https://www.dbsofts.com/
The ESF Data Migration Toolkit.
https://www.dbsofts.com/
- Wed May 03, 2023 11:51 pm
- Forum: Problem reports
- Topic: The import of data in test works but it no longer works when we publish and the application becomes Current
- Replies: 5
- Views: 16669
Re: The import of data in test works but it no longer works when we publish and the application becomes Current
How do you Import?
Did you create an Import Template?
If so, did you Export your Import Template from your test machine and Import it onto your Server?
Did you create an Import Template?
If so, did you Export your Import Template from your test machine and Import it onto your Server?
- Tue May 02, 2023 8:01 am
- Forum: General discussion and questions about Aware IM
- Topic: Compare new record to existing record
- Replies: 3
- Views: 2780
Re: Compare new record to existing record
Have a look at the Customer BO in the CRM Sample App.... In the Business Object Rules you will see this.... If EXISTS SystemUser WHERE (SystemUser.LoginName=ThisCustomer.LoginName AND SystemUser.ID<>ThisCustomer.ID) Then REPORT ERROR 'User with this login name already exists. Please choose a differe...
- Sat Apr 29, 2023 1:11 am
- Forum: Problem reports
- Topic: Forgot password link not working
- Replies: 7
- Views: 15639
Re: Forgot password link not working
Well done Max. Glad you got it working.
- Mon Apr 24, 2023 11:13 pm
- Forum: General discussion and questions about Aware IM
- Topic: Import Document from URL
- Replies: 20
- Views: 23672
Re: Import Document from URL
I haven't tried this but, just wondering if could it be done in javascript? For example..... const downloadLink = document.createElement('a'); downloadLink.href = 'http://www.mydomain.com/samples/mypdf.pdf'; downloadLink.download = 'mypdf.pdf'; downloadLink.textContent = 'Download PDF'; document.bod...
- Sun Apr 23, 2023 11:51 pm
- Forum: General discussion and questions about Aware IM
- Topic: Exchange Rate API Return Data
- Replies: 4
- Views: 2591
Re: Exchange Rate API Return Data
I have used Mondor for years. Started right back in http SOAP days...
Thought it time to upgrade....
Currency API provides a Free plan for up to 300 calls per month. I have less than 10 Currencies can do a call every night
and still be under the Free threshold.
https://currencyapi.com/
Thought it time to upgrade....
Currency API provides a Free plan for up to 300 calls per month. I have less than 10 Currencies can do a call every night
and still be under the Free threshold.
https://currencyapi.com/
- Sun Apr 23, 2023 10:23 am
- Forum: General discussion and questions about Aware IM
- Topic: Exchange Rate API Return Data
- Replies: 4
- Views: 2591
Re: Exchange Rate API Return Data
Worked it out....
Currency.Value=PARSE_JSON(RESTCurrencyResponse.Reply,'$.data.' + Currency.Currency + '.value')
Where Currency.Currency is the Currency Code... ie USD
Currency.Value=PARSE_JSON(RESTCurrencyResponse.Reply,'$.data.' + Currency.Currency + '.value')
Where Currency.Currency is the Currency Code... ie USD
- Sun Apr 23, 2023 5:53 am
- Forum: General discussion and questions about Aware IM
- Topic: Exchange Rate API Return Data
- Replies: 4
- Views: 2591
Exchange Rate API Return Data
I am trying a new Exchange Rate API Service. It returns data in this format..... { "meta":{ "last_updated_at":"2023-04-22T23:59:59Z" }, "data":{ "AED":{ "code":"AED","value":4.075241 }, "CAD":{ "code":"CAD","value":1.517868}, "USD":{ "code":"USD","value":1.109754} } } I guess there are two ways to p...
- Fri Apr 21, 2023 1:08 am
- Forum: Problem reports
- Topic: Forgot password link not working
- Replies: 7
- Views: 15639
Re: Forgot password link not working
ForgottenPassword process - Handles Forgotten Password Checked. Rule 1: ENTER NEW ForgottenPassword (is a Non Persisted BO called ForgottenPassword with Attributes....LoginName (50) and NewPassword (20) ) The Form only shows the LoginName Rule 2: IF NOT(EXISTS SystemUser WHERE (SystemUser.LoginName=...
- Wed Apr 19, 2023 1:38 pm
- Forum: General discussion and questions about Aware IM
- Topic: Upcloud email problems?
- Replies: 3
- Views: 2056
Re: Upcloud email problems?
Drop me an email privately and will make a time to call to discuss
- Tue Apr 18, 2023 9:07 am
- Forum: Tips and Tricks
- Topic: Auto Create SystemSettings with DQ
- Replies: 2
- Views: 12477
Auto Create SystemSettings with DQ
On the odd occasion we need to automatically create the SystemSettings BO usually when building a new server. ALL of our Apps have a DQ Attribute that holds the " character. But has always been a PITA to create SystemSettings with it populated with this Attribute set because you cannot have a " in a...
- Tue Apr 18, 2023 8:56 am
- Forum: General discussion and questions about Aware IM
- Topic: System Lock Error
- Replies: 6
- Views: 2741
Re: System Lock Error
Certainly does not look like an Aware IM error. Never seen that before. Are you hosting internally or on a Cloud Server? On the very rarest of occasions one of our users cannot log in when windows is updating something in the background. So we put off all Windows updates to a time when the least amo...
- Mon Apr 17, 2023 11:58 pm
- Forum: General discussion and questions about Aware IM
- Topic: Other icons besides font awesome
- Replies: 2
- Views: 3355
Re: Other icons besides font awesome
Tried Font Awesome V6 and could not get it to work either.
Would be great to have a mechanism to plug and play and bit more with this stuff.
Would be great to have a mechanism to plug and play and bit more with this stuff.