AppGini Community Forums

Hi, thanks for reporting. I do not remember ... but are there already some changed logged in the Audit? It could be, that I did the code in the way that only tables are shown in the dropdown where already some data exists in the AuditLog table. To make sure this is NOT the problem: If there are no e...

Hi, so what is the problem? When you remove (uncheck) the checkbox in the group 2 and group 3 setting, these groups should not appear. You could also use javascript to preselect group 1 while on the sign up page and at the same time make the dropdown hidden... But... it seems MUCH easier to me to si...

Hi, I am not sure, but isn't it possible to define for which groups a user can sign up? Yes, it is (just tested): Simply set in your group 1 (where all new users belong to) the corresponding checkbox. Disable this checkbox on all other groups!: ag_new_group_signup.png Then, once a new user want's to...

Hi, I am not sure what you want to accomplish. I do not understand your problem. Can you please rephrase it. You have 3 groups - ok. If it's allowed for new members to sign up, can't they choose the group? If you want all "new members" to have "Group A" after sign up ("forcibly inserted with group 1...

Hi pbötcher,

funny. Taking a look at the data he sent me, I came to the same assumption.
Let's what if he can confirm this.

Olaf

Hi,

I noticed problems with PHP 8.2, but not with PHP 8.1 anymore. Maybe you have some more details for us.
Also: Did you generate your app with the latest version of AppGini? This has some fixes for the warnings that resulted when using PHP 8.x

Olaf

Hi Ron,

so did you solve the problem (you wrote you "figured it out")?
If not, maybe you could send me the AG file (clipped to only that table) and the data once more. I would try to recreate the effect (but I can do this only until Friday, or after Oct. 16th)

OLaf

Hi, well, I do not understand the problem. Let's rephrase this. When you click "Show All" and the filter goes away, but the sorting stays, it's exactly doing this: You will see all data. If you have set a filter before, so be it. Again: You can click on the headline to "remove" filters and sorting w...

Hi,

I would think this is a bug. And you should post it in that subforum.
On the other hand, we can see, that it's a lookup and as this, the value shown could also be text. But: If you as the user decide to ask for the column sum, there shoule be one. As this: Bug?!

Olaf

Hi, interesting. When I clicked on a CSV export, even the ID (autonumber) is exported in double quotes. For saving from XLS, I want to recommend the free XLToolbox. This can (also) save CSV with options: https://www.xltoolbox.net Did you try to import on a new testserver? Maybe this turns out good a...

Hi,

did you try to input some records, export those as CSV and reimport them? Same problem?

Just a thought: Shouldn Woningtype_Id, Actie_ID and Soortaanvraag_Id not contain "real" values instead of references only? I thought AG is taking care of setting the correct references.

Olaf

Hi, I tried: 1 ok 2 ok 3 ok (I clicked "Show all"). Filter is gone, sorting stays. When I click on the "Filter" button, there is nothing left in the filter-criteria, only in the sort. So, everything seems fine to me. 4 well ... if you remove the filter (show all) then you remove the filter. I know t...

Hi Ron, a couple of questions first that might help to answer your question: 1. are you using the "new" or the "old" CVS Import wizard 2. are you using some weird enconding (UTF-8 should probably work best) 4. does your file use BOM (if utf8) or not? 5. what are your seperators? 6 are text fields en...

Hi,

sorry, no, I not not know this.

Olaf

Hi,

you want to filter first and then print without filter? This does not really make sense to me ... but that's my problem.
You can simply clear filter and sorting, by clicking on the table header. This will reload the page and to print it would take just two clicks.

Olaf

Hi, if you need average displayed, you will need to change the layout of the page. You can do this either by using Javascript (someone else on the forum can probably help) and inject "something" (see below) at the position or change the base layout file of the page in the /templates/tablename-dv or ...

Hi, just a quick shot, not tested... somehow pseudocode: In the hooks/tablename.php look for the function after_insert In the function, add the following code (before the return TRUE statement of course): $mi = getMemberInfo(); if($mi['username'] == 'guest'){ $result = sendmail($username, $email, $m...

Hi Michael,

glad to help, and thanks for reporting back.
Take care
Olaf

Hi, when posting code here, please use the [ code ] ... [ /code ] tags/tool from the editor. This will make code much easier to read. Looking at what you posted, it seems, that you have commented out all code .... did you do this on purpose? Try this in links-navmenu.php - what closely to what you p...

Hi pstump,

thanks for pointing this out. This is quite nice and would also be something to built on.

Olaf

Hi, please use the "code" tag to show code - make it easier to read. What do you need help with? Is this a MSSQL Server Statement (of MySQL)? What is your problem? What is your goal (what are you trying to accomplish)? Do you want to read some date? Your question is unclear (too unclear to me at lea...

Hi, I stumbled over Ragic (https://www.ragic.com/). They have a built in search feature which searches similar to AGs quick search - but obviously in all "tables". Thus: Why not have something like this as well? ragic.png I know, there are permissions (access to tables) to consider, but the idea see...

Hi Shay,

if you succeed, please let us know how you did it.
goog luck
Olaf

Hi,

aha, and what is your question, problem, desired result?
Maybe this helps: https://www.mysqltutorial.org/mysql-case-function/ and https://www.w3schools.com/SQL/func_mysql_case.asp

Olaf

Hi,

no.
I once asked if someone has used other than MySQL/Maria DB as DBs - but even there no real experience.
Probably you can set up an ODBC connection and you might need to code SQL yourself

Sorry that this probably was not what you expected / a helpful answer
Olaf