Search found 19 matches

by sacgtdev
2021-06-14 00:59
Forum: Feature Suggestions
Topic: Import CSV data only for specific table
Replies: 0
Views: 45

Import CSV data only for specific table

How to grant csv import only for certain tables only? Is there any workaround to edit the code manually?
by sacgtdev
2021-06-14 00:50
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85565

Re: Audit Log

Any updates on Audit log in the near future which compatible to the most recent Appgini release 5.96 or 5.97 ?
by sacgtdev
2021-04-29 07:28
Forum: Advanced Customizations > Others
Topic: ruview chart.php (modification for month and year view)
Replies: 1
Views: 1284

ruview chart.php (modification for month and year view)

Try to modify the custom page so that it can be view by selecting both month and year options. The chart can be either viewed at specific month or throughout the year if the year/month was selected or year selected only. Puzzling.. :?: . Any idea? <?php // config $chart = array( 'dayWidth' => 3, 're...
by sacgtdev
2021-04-18 03:52
Forum: Advanced Customizations > Others
Topic: Multiline text in table cell (custom page)
Replies: 5
Views: 559

Re: Multiline text in table cell (custom page)

Dear Olaf,

That will work only when the text have \n to indicate where to break the line.
However, the existing text do not have \n.

I wonder how the original table cell could show the representation of text with line-break.
by sacgtdev
2021-04-17 06:21
Forum: Advanced Customizations > Others
Topic: Multiline text in table cell (custom page)
Replies: 5
Views: 559

Re: Multiline text in table cell (custom page)

The representation of the content in table cell: 1) text-area line 1 line 2 line 3 line 4 2) DB line 1 line 2 line 3 line 4 3) Save CSV line 1 line 2 line 3 line 4 4) In custom page line 1 line 2 line 3 line 4 How to make the representation of text in multiline format as shown in (1) and (2) for (3)...
by sacgtdev
2021-04-17 02:48
Forum: Bugs/annoyances
Topic: Filter doesn't give expected records
Replies: 3
Views: 509

Re: Filter doesn't give expected records

I also want to know the workarounds to show NULL records when the filter was applied.
by sacgtdev
2021-04-16 06:33
Forum: Advanced Customizations > Others
Topic: Multiline text in table cell (custom page)
Replies: 5
Views: 559

Multiline text in table cell (custom page)

I have one question on the multiline display: The paragraph inserted into the text area showed quite well in the table cell in multiline format. However, in the DB, it is actually preserved in string without line. How to display it in multiline form in the custom page? I have been trying to add css ...
by sacgtdev
2020-12-28 15:21
Forum: Getting Started
Topic: Issue with the database backup on the new version
Replies: 28
Views: 11081

Re: Issue with the database backup on the new version

I have added the C:/inetpub/wwwroot/admin/backups in environmental variable path. But, still can't generate backup. Why? (mysqldump --no-tablespaces -u"root" -p**** -h"localhost" "opdb" -r "C:/inetpub/wwwroot/admin"/backups/feff28c7b0dac26754eff9cca0a5c895.sql) 2>&1 'mysqldump' is not recognized as ...
by sacgtdev
2020-12-28 13:04
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85565

Re: Audit Log

Thanks.
by sacgtdev
2020-12-28 12:59
Forum: AppGini Plugins
Topic: Edit mass update php file to change record ownership. How
Replies: 1
Views: 409

Re: Edit mass update php file to change record ownership. How

I have solved the problem. However, I still not able to understand the purpose of following code. It seems like the query will never be run as the if condition will be surely always return false. The $new_value will never be the 'MASS_UPDATE_TOGGLE_CHECKBOX' /* Can you explain the if statement for t...
by sacgtdev
2020-12-28 12:52
Forum: AppGini Plugins
Topic: in mass update, how to update the project file
Replies: 4
Views: 3882

Re: in mass update, how to update the project file

My workaround is download the axp from the previously uploaded axp (for plugins) to continue modify/improve/make amendments for the project. After done, re-run the project which it will then overwrite the files in the root folder except the hooks. After done, re-upload the latest modified axp into t...
by sacgtdev
2020-12-27 07:08
Forum: AppGini Plugins
Topic: in mass update, how to update the project file
Replies: 4
Views: 3882

Re: in mass update, how to update the project file

Dear Ahmad, Can you make some example? I don't understand the workflow that you have describe, my understanding is in blue text: 1. Upload your AXP project file to the plugin you're using and make the desired changes. Assuming there is old axp already uploaded before. I re-upload the new axp and it ...
by sacgtdev
2020-12-23 14:14
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: How to redirect to a specific page/url after login
Replies: 10
Views: 4800

Re: How to redirect to a specific page/url after login

Weird url after trying to log in. Log in fail because the 'triple slash' in the redirect url. Not encounter this in apache web server (XAMPP) before. First time experience this in IIS web server. Any solution for this? Login url: http://localhost/index.php?signIn=1 Redirect url: http://localhost///i...
by sacgtdev
2020-12-18 03:12
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85565

Re: Audit Log

Hi Olaf, Your idea is good. It means that I just need to do additional step after csv import to loop the newly inserted records and update it into the audit log. A quick way to loop the inserted records is using the mass update plugin. There are some code which I not able to apprehend (if statement ...
by sacgtdev
2020-12-14 09:21
Forum: AppGini Plugins
Topic: Edit mass update php file to change record ownership. How
Replies: 1
Views: 409

Edit mass update php file to change record ownership. How

I'm a newbie to php code. Should I insert the code in the mass update generated php code? Following is the snippet of code I extract from the generated php code, anyone able to explain on the bold code and comment the newly inserted code (in blue). I do not fully understand the php code and have di...
by sacgtdev
2020-12-04 08:43
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85565

Re: Audit Log

Does anyone have any idea on audit log approach to address crud action for both form editing action and csv import?

Regards,
Stephen
by sacgtdev
2020-11-16 03:04
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85565

Re: Audit Log

SkayyHH wrote:
2020-11-15 20:48
I think if I create an audit table in appgini the auditLog.php is not needed, right?
I think you do not need it as user with permission can access to the audit table already.
by sacgtdev
2020-11-16 03:03
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85565

Re: Audit Log

Hi, I have updated an app created with AG and the audit log v1.6 - it works without any problems for me. You may post what your problem seems to be. The way you are asking for, if you simply want to copy the current record to another table use the hook after_update: a) search in your "log" table fo...
by sacgtdev
2020-11-08 12:16
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85565

Re: Audit Log

I have tried the audit log v 1.6 with the latest appgini release 5.91. It doesn't seem to work. Any simple way if I just want to log each entry of record in another table that is exactly have the same fieldnames and additional one field for indicating '0' for old record and '1' for new record that r...