AMPLE Scaffolder Version 2.1.3 Released

UPDATE: The software package formerly known as MBG Scaffolder has now been officially renamed to “AMPLE Scaffolder”.

It’s been a few months since the last release of AMPLE Scaffolder as I’ve had other ongoing projects and distractions. There have been several more updates behind the scenes in this latest release to include a few bug fixes as well. One of the biggest additions to the 2.1.3 release is that internal linking between tables is now supported. This means that a record id that references a value from a separate look-up table will now show up as a link if auto-joining is enabled. This allows you to easily jump into a reference record to make changes if required. The addition of this feature caused a temporary sorting bug that has also now been fixed in this version. As usual, you can download the latest release using the link below.

Download the latest release here!

AMPLE Scaffolder 2.1.0 Now Available

UPDATE: The software package formerly known as MBG Scaffolder has now been officially renamed to “AMPLE Scaffolder”.

Even though the last release was less than a week ago, I’ve been using AMPLE Scaffolder recently on another project and I discovered a few things that were lacking. The Insert Plus feature allows users to duplicate data from a record insertion and use that data to repopulate a new set of form fields. This is a very handy feature if you want to insert multiple records where the majority of the fields have the same value. But I recently found that this wasn’t enough.

My current project had me wanting the option to duplicate data for an existing record (vs. a new record). So the 2.1.0 release now includes a Record Duplication feature that makes this possible. Just click the pencil icon to modify the record you wish to duplicate and click the “copy” button at the bottom of the form. This will automatically generate a new record creation form with all the fields pre-populated with the previous record’s data.

There were also a few minor bugs that I discovered from several releases ago that have now been fixed in this latest release.

  • Fixed a bug where users were returned to page one of the results, regardless of where the original record was listed (page two or higher)
  • Fixed a bug that wouldn’t allow users to deselect all options under Advanced > SQL Field Select in order to show all fields again
  • Fixed a bug where multi-select form fields were not pre-populated after an Insert Plus or a Record Copy

Also, SQL queries are no longer displayed by default. I found this to be a bit annoying when using the utility for longer sessions since some of the queries were long and I was forced to scroll down after after update. So I set this option to disabled by default so it doesn’t display after a session reset. It can easily be re-enabled under the Options tab though if you prefer.

Download the latest release here!

AMPLE Scaffolder 2.0.9 Released

UPDATE: The software package formerly known as MBG Scaffolder has now been officially renamed to “AMPLE Scaffolder”.

This is just a quick update to let everyone know that a new version of AMPLE Scaffolder is available for download. There are no major feature updates in this release, but there were a few languishing bugs that I felt the need to address. Some of the changes included:

End Users:

  • Datetime fields no longer auto-populate with today’s date if set to allow nulls in the database
  • Datetime fields that do not allow nulls will still auto-populate with existing data or today’s date
  • Datetime fields that do not allow nulls will require a valid date prior to form submission
  • Calendar pop-up for datetime fields now has a “clear” button so that existing dates can be removed from a field
  • Empty datetime fields that allow nulls will automatically insert a null in that field when the form is submitted
  • Read-only table parameter is now set to blank in downloadable version.
  • Prior versions contained multiple table names that may have resulted in access denied errors if local table names were the same.

Developers Only:

  • Updated build file to include help documentation and procedural guidance.
  • Updated call status file so end users will be properly notified when a new release is available.
  • Moved the features list, blocked files list and general help docs from flat files into database for speedier retrieval during builds.
  • Compiled multiple classes into a single bundled class file to help reduce file count and locate individual classes more quickly.
  • Began work on minimized code base for release that just contains just the bare essential PHP classes with no HTML added.
  • Added a function to maxify existing minified releases if end users need to make changes (not yet released).

Well that’s about it for now. Check out the latest version here. As always, please let me know if you notice any new bugs or problems with the code.

Happy CRUDding!

AMPLE Scaffolder: Now Offering Thumbnail Generation On-The-Fly

UPDATE: The software package formerly known as MBG Scaffolder has now been officially renamed to “AMPLE Scaffolder”.

This is just a quick note for all the AMPLE Scaffolder users.  Version 2.0.6 has just been released with a variety of bug fixes and updates.  But the most prominent feature now available is the option of generating image thumbnails during file uploads.  I had planned to add this option in at some distant point in the future.  But the upgrade happened sooner than later because I required this feature for another project I’m working on at the moment.  So as users, you can just sit back and reap the rewards!

I still have to update the help documentation and the feature list but using the thumbnail generator is pretty simple.  There’s a new option available under the Files tab now with a list of image sizes from which to select.  Currently, you can choose up to 12 different options ranging from 75×75 pixels to 1600×1200 pixels.  I guess the larger images are technically not thumbnails but you get the idea.  If nothing is selected from this list, no thumbnails are created.  Removing an uploaded file from an existing record will automatically remove any related thumbnails too, making it super simple to use this feature.

If you still don’t know what AMPLE Scaffolder is all about, check out the introductory post for all the details.  If you just want the latest version available, you can download it here.  Again thanks for testing and all the constructive feedback.  Every bit helps me to improve the end product.


AMPLE Scaffolder: Open Source Now Available For Download

UPDATE: The software package formerly known as MBG Scaffolder has now been officially renamed to “AMPLE Scaffolder”.

If you haven’t already heard, I finally got around to tweaking the AMPLE Scaffolder code enough that I felt it was ready for beta release.  The AMPLE Scaffolder package has now been officially released under GNU’s general public license.  For those unfamiliar with the AMPLE Scaffolder project, please check out my previous post for download and demo links, as well as a complete list of features available.

For this particular project, I opted to make the code available under open source licenses because I’m a big believer in open source software and I really feel this project has something to offer.  Hopefully the latter becomes reality and someone else can finally benefit from my efforts, like I have from others all these years.  With the exception of Password Meter, the AMPLE Scaffolder package is the first major piece of code I’ve released under the GPL.  But I certainly don’t plan for it to be the last.  I have several other PHP classes, as well as a Javascript or two that I hope to make available under GPL as well.

In my opinion, open source projects are a huge benefit to developers because they get the code out there for others to use and review.  This process lends itself quite nicely to project expansion through other developers and community feedback.  Typically, the more popular a project is, the better the code and feature-set because there’s a genuine interest in maintaining and maturing the final product.  I realize that most people these days are looking to make money whenever possible, but I honestly wish more companies would look into releasing their code under OS licensing.  To me, it seems like a win-win situation.

To answer a lingering question, some of you may be wondering why I’ve built yet another MySQL PHP scaffolding tool.  I found a few other scaffolding utilities out there that did some of what I needed, but most of these other apps weren’t very intuitive and required a lot of modifications to the back-end database to make them work correctly.  AMPLE Scaffolder was designed with minimal requirements in mind. Putting aside some of the more advanced features, the AMPLE Scaffolder utility is fully configured and ready to go.  Drop it in a web-accessible directory and using the proper credentials, you can easily access any MySQL database server using a fully qualified domain name.  It’s just that easy.  The only real requirements come in the form of PHP and MySQL version support and some minor table comments to support advanced joining options.  The following is a rough gist of AMPLE Scaffolder’s abilities:

“AMPLE Scaffolder is a robust and intuitive PHP-MySQL database scaffolding utility with virtually zero database requirements. It offers auto-joining for referential look-up tables as well as enum, set, and boolean field types, and even supports referential look-ups on fields that contain comma-separated values. This package features insert plus one for similar records, bulk record inserts up to 10,000 records at a time as well as a built-in query-based data exporting utility, server- and client-side validation, error and warning reports, and unlimited file uploads. Building queries is a snap thanks to a custom query generator with individual field selection and unlimited where clauses, as well as SQL syntax highlighting, data-type matching, paging, sorting and much, much more.”

It’s pretty easy to talk up my own product though, so I’m looking for testers and feedback to make the AMPLE Scaffolder even better.  My testing has been pretty limited so far so I’m looking for more worldly feedback based on database parameters outside of my own controlled environment.  Quite a few updates were included in the last push so there’s still a possibility of some bugs.  But I did my best to eliminate any issues I came across.

Please feel free download the package and give it a try and let me know what you think.  If you don’t have access to a PHP-enabled web server, check out the demo site to get a feel for AMPLE Scaffolder’s abilities.  The only feature that’s missing on the demo is the file uploading.  I’ve blocked this for security reasons.  But file uploads are fully enabled in the download-able release.  Don’t forget to pass this on to anyone you know that may have need for a PHP-MySQL scaffolding utility.

Thanks in advance and have fun!