Search found 1628 matches

by kklosson
Fri Sep 29, 2023 10:27 pm
Forum: General discussion and questions about Aware IM
Topic: wkhtml alternative
Replies: 6
Views: 42652

Re: wkhtml alternative

It certainly depends on what you need to do but I use PDFTK (https://www.pdflabs.com/) to combine PDF files via CLI on the back end. It's free.
by kklosson
Fri Sep 29, 2023 10:23 pm
Forum: General discussion and questions about Aware IM
Topic: How to Format Column Totals in Grid
Replies: 6
Views: 33202

Re: How to Format Column Totals in Grid

I suspect either this item is not fully built out or there are limitations.
by kklosson
Fri Sep 29, 2023 7:55 pm
Forum: General discussion and questions about Aware IM
Topic: How to Format Column Totals in Grid
Replies: 6
Views: 33202

Re: How to Format Column Totals in Grid

I'm afraid neither of the above is working.
by kklosson
Thu Sep 28, 2023 1:44 pm
Forum: General discussion and questions about Aware IM
Topic: How to Format Column Totals in Grid
Replies: 6
Views: 33202

How to Format Column Totals in Grid

How do I format a column total as currency?
Here's what does not work.
Screenshot_10.png
Screenshot_10.png (37.82 KiB) Viewed 33202 times
by kklosson
Mon Sep 11, 2023 12:27 pm
Forum: General discussion and questions about Aware IM
Topic: I Think I Must Be Going Crazy :-|
Replies: 5
Views: 22802

Re: I Think I Must Be Going Crazy :-|

Have you reviewed the logs?
by kklosson
Wed Sep 06, 2023 7:59 pm
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 126650

Re: [UPDATE] Database latency - all suggestions appreciated

For those following this saga, I replicated the AWS database server to a new EC2 instance and installed a spare AIM license on it, running it locally (localhost). To my surprise, the latency was simply not there. All of the latent queries were normal. For example, a query that is now taking 33 secon...
by kklosson
Wed Sep 06, 2023 5:30 pm
Forum: General discussion and questions about Aware IM
Topic: Trouble Editing Toolbar on Forms/Queries
Replies: 1
Views: 9851

Trouble Editing Toolbar on Forms/Queries

When editing Panel Operations on a query, I can move items up or down but cannot see the context of the full menu. When I Edit the Toolbar, there are no features to position items within the toolbar. Am I missing something?
by kklosson
Wed Sep 06, 2023 12:44 am
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 126650

Re: Database latency - all suggestions appreciated, will compensate

I've spun up a replica db server with AIM installed so I can start going in that direction with some tests.
Thanks
by kklosson
Sun Sep 03, 2023 11:08 pm
Forum: Problem reports
Topic: Import Action not working
Replies: 4
Views: 20356

Re: Import Action not working

This file is from a customer who got it from some other unknown source. I'm just happy to close the case with a lesson learned.
by kklosson
Sun Sep 03, 2023 4:25 pm
Forum: Problem reports
Topic: Import Action not working
Replies: 4
Views: 20356

Re: Import Action not working (RESOLVED]

Good on you!
You got me thinking. The doc looked fine in a text editor. However, I saved it as TXT using ANSI (usually cleans our the boogers). renamed it to .csv. Then it worked.

Good job and many thanks!
by kklosson
Sat Sep 02, 2023 2:36 pm
Forum: Problem reports
Topic: Import Action not working
Replies: 4
Views: 20356

Import Action not working

I have an import function for end users that employs the IMPORT action: IMPORT [object] FROM [file] WITH VALIDATION This has worked fine for years and I have not altered anything since instituting it. It gets used but I am unsure how often but I recently got a report that it was claiming the header ...
by kklosson
Fri Sep 01, 2023 2:59 pm
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 126650

Re: Database latency - all suggestions appreciated, will compensate

Sadly, nothing offered yet has helped. It really behaves as though an index is shot somewhere but I have carefully reviewed the server log for everything it does for this query and have examined all relevant tables and run a number of test queries mimicking those in this query process. They all run ...
by kklosson
Fri Sep 01, 2023 2:50 pm
Forum: Problem reports
Topic: BASServer.Props SessionTimeout value is overwritten
Replies: 0
Views: 60752

BASServer.Props SessionTimeout value is overwritten

When editing the General items from the Control Panel, any setting changes (including no changes to the Timeout setting) overwrites the SessionTimeout value in BASServer.Props usually with a long negative value. Interestingly, this only occurs on my production server (running Professional) but does ...
by kklosson
Sun Aug 27, 2023 3:54 pm
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 126650

Re: Database latency - all suggestions appreciated, will compensate

Here is my question to ChatGPT: "On MySQL database, if I remove the primary key, save the change, and then set it back, does it regenerate the index?" Answer: If you remove the primary key from a MySQL database table, the index is also removed ¹. If you then set the primary key back, it will regener...