Frequently Asked Questions


  1. I turned 'maintenance mode' on from the admin area then accidentally signed out as admin. Now I'm locked out and can't sign in.
  2. I added a new field to a table in my project and regenerated the application. Which files should I upload to my server?
  3. When trying to change the table icon in AppGini, I get an error message "ActiveX component can't create object", and I see blank boxes with no icons.
  4. In AppGini, some of the fields have a red color, some blue, and some with different icons in the left tree-view. What is the meaning of all the colors and icons?
  5. I have a time field in my application that stores the record modification time. It used to display the time correctly until I upgraded to AppGini 4.70. It's now 5 hours late.
  6. I could not upload a 20MB file even when setting up the field to allow so. Tried recreate the field but still failed.
  7. After generating the application, I wanted to change the data type of a field. So, I changed it in AppGini then regenerated the application later. But the actual field did not change.
  8. I forgot the admin password. How can I reset it?
  9. How can I install AppGini in linux/MacOS?
  10. Is it possible to import a CSV file into AppGini?
  11. If I use a third-party form (for example a contact form ... etc) to populate a table in my database, can my AppGini application see and work with the submitted data?
  12. I want to have a rich (HTML) area field, but I want to be able to edit its HTML source code as well. Is this possible?
  13. Can I build a site like amazon.com using AppGini?



Q. I turned 'maintenance mode' on from the admin area then accidentally signed out as admin. Now I'm locked out and can't sign in.

A. To disable maintenance mode manually if you're not signed in as admin, you need to delete the file "admin/.maintenance". You can do so via FTP or shell access to your web server.
Back to top


Q. I added a new field to a table in my project and regenerated the application. Which files should I upload to my server?

A. You can safely upload all the generated files. But if you want to upload only the changed files (due to bandwidth limitations or because you made modifications to the files on the server that you don't want to override .. etc), here is a list of all files that are affected when you modify a table in your project, assuming your table is named tablename:
  • tablename_dml.php
  • tablename_view.php
  • templates\children-tablename-printable.php
  • templates\children-tablename.php
  • templates\tablename_templateDV.html
  • templates\tablename_templateDVP.html
  • templates\tablename_templateTV.html
  • templates\tablename_templateTVS.html
  • incCommon.php
  • updateDB.php
  • admin\pageRebuildFields.php
So, instead of uploading all the generated files, you could upload the above ones. Again, please beware that the first 8 files above are table-specific and tablename should be replaced with the actual name of the modified table. The last 3 ones are common files with fixed file names.
Back to top


Q. When trying to change the table icon in AppGini, I get an error message "ActiveX component can't create object", and I see blank boxes with no icons.

A. This indicates a missing component in your Windows OS. To fix this, please download and unzip this file into your Windows/System32 folder, then run this command from a command prompt (Start menu > Run > type "cmd" without quotes and click Enter):
regsvr32 C:\Windows\System32\wiaaut.dll
This should resolve this error.
Back to top


Q. In AppGini, some of the fields have a red color, some blue, and some with different icons in the left tree-view. What is the meaning of all the colors and icons?

A. The red color means a required field (a field set to "Can't be empty"), the blue is a field containing a web or email link. Here is a legend of the different colors and icons for your reference.
A legend for icons and colors of fields in AppGini
Back to top


Q. I have a time field in my application that stores the record modification time. It used to display the time correctly until I upgraded to AppGini 4.70. It's now 5 hours late.

A. AppGini 4.70 introduced the option to specify the time zone for your application. And the default time zone is New York (EST). To change that, open your project in AppGini, and from the database properties page click on the button labeled "Change time zone", select your desired time zone, and regenerate your application.
Back to top


Q. I could not upload a 20MB file even when setting up the field to allow so. Tried recreate the field but still failed.

A. In addition to the upload size setting in AppGini, you should also check the variable "upload_max_filesize" in the "php.ini" config file. Make sure it's larger than the size of your file.
Back to top


Q. After generating the application, I wanted to change the data type of a field. So, I changed it in AppGini then regenerated the application later. But the actual field did not change.

A. AppGini supports applying field changes automatically to the database, but sometimes the changes won't apply correctly.

To force the data type change, please open your project in AppGini, select the concerned field, then open the "Tables" menu > Fields > Recreate this field, and click yes to confirm. Next, regenerate the application, making sure to overwrite the old files. Then upload the new files to your server. This should fix the field type.
Back to top


Q. I forgot the admin password. How can I reset it?

A. You can reset your password by opening the "config.php" file, find the line starting with:

'adminPassword' =>

And change it to:

'adminPassword' => '21232f297a57a5a743894a0e4a801fc3',

Next step, using phpMyAdmin or a similar MySQL admin tool, open your database and go to the “membership_users” table .. find the admin user and change the passMD5 field value to “21232f297a57a5a743894a0e4a801fc3” (without quotes).

Now, you can log into the admin area using the password 'admin'. You should then change the password from there.
Back to top


Q. How can I install AppGini in linux/MacOS?

A. Although we don't fully support installing AppGini on non-Windows platforms, you might be able to run AppGini under Linux using PlayOnLinux, and under Mac OSX using Wine. To install AppGini under Wine, you should follow these steps:
  1. Make sure you have Wine (preferably the latest version) installed and running correctly.
  2. Download Winetricks: you can download it using this command from a terminal window: wget http://kegel.com/wine/winetricks
  3. In the same terminal window, execute this command: sh winetricks vcrun6 wsh56
  4. Download AppGini and extract the setup.exe file from the downloaded zip file.
  5. You might need to grant execute permission to the exe file. Consult your OS documentation for how to do so.
  6. finally, execute the setup.exe file and follow the setup screens.
After following the above steps, you should now have AppGini installed and ready to run. An easier very low cost alternative is to install AppGini in a remotely-hosted Windows virtual machine ... This would save you a lot of setup time and effort.
Back to top


Q. Is it possible to import a CSV file into AppGini?

A. Yes, this can be done on 2 steps: importing the field names (if the table doesn't already exist), then importing the data.

To import the field names from your csv file into AppGini, open the file menu > Import > Table from CSV file. Then follow the instructions.

After generating the php application and uploading it to your server, you can import data from your csv file into the application. First, log into the admin area, then click the link labeled "Import CSV data", and follow the instructions.
Back to top


Q. If I use a third-party form (for example a contact form ... etc) to populate a table in my database, can my AppGini application see and work with the submitted data?

A. Yes. You can use any form to capture and store the data into the database. Any records added by this form will then be accessible to your AppGini application. However, only the users who have "view all" access to the table populated by your contact form will be able to view the records ... If you have configured your AppGini application (in the admin area) to have groups who can view group-only or owner-only records, they won't be able to see those new records.
Back to top


Q. I want to have a rich (HTML) area field, but I want to be able to edit its HTML source code as well. Is this possible?

A. The rich editor component that comes with AppGini doesn't support code editing ... So, you should use this NicEditor version instead (unzip and copy the 2 files to the folder where you generated your application, replacing the existing ones).

The next step is to open the generated "templates/tablename_templateDV.html" file in a text editor (where tablename is the name of the concerned table) and find this line:
new nicEditor().panelInstance('fieldname');
(where fieldname is the name of the concerned field) ... Change that to:
new nicEditor({ fullPanel : true }).panelInstance('fieldname');
Back to top


Q. Can I build a site like amazon.com using AppGini?

A. No! An advanced web application contains many specialized views, reports and workflows that AppGini can't help you with. However, AppGini can help you get a very quick working prototype of the data views of your application so you can easily identify the features you'd like to implement ... It can also help you build a simple responsive admin area where you can add, edit, sort, and search for data using your PC or any mobile device. Although this might not sound as much, it still can save you tens or even hundreds of development man-hours, and helps you easily communicate your application idea and details to your developers so they can get started building your next amazon.com :)
Back to top