AppGini Community Forums

I have a simple database web application that I am wondering if AppGini will allow me to easily create. I have a public database that contains 2 files. Basically a master file with customer numbers and names and a detail file with billing records. I need to create a simple web app that show a custom filter screen asking for customer number or last name search and then allow them to pick a customer from the master database and show the detail billing info from the detail billing file. I have 2 questions:

1. Since this is a public information database do I have to have all users sign in or register or can I just go directly to the search page from a link on the main website and assume they are connecting as an anonymous user.

2. Is there a way to simply automate replacing the complete database with a new one Daily since the detail database changes daily with an updated version via CSV file that would be created nightly.

I have looked and used other tools to do this AppGini looks so much easier to use from what I have seen so far. Just don't know how much I can do with the program .vs. custom changes required by me.

I appreciate any response.

Thanks for your interest in AppGini.

1. You can enable anonymous access to your tables from the admin area .. this way users won't have to register or sign in. Here is how: https://bigprof.com/appgini/screencasts ... mous-users

2. Hmm .. you could configure a cron job on your server to run a script that uses the 'Load data infile' query to import your CSV file to the database. Please refer to this page for details: https://dev.mysql.com/doc/refman/5.7/en/load-data.html