BCS Dynamic Data Entry Forms

This application generates data entry forms when you supply the alias and table name for any MySQL database.

dgf01

Notice that the controls are populated in a scroll box so long forms are accommodated by this application.  The application is invoked by sending he alias and table name on the command line.  The application then generates the data entry form as pictured above.   Notice this is accomplished without a single line of code.

When you do not supply the alias and table name on the command line the following dialog appears.

dgf02

If you respond with the No option the following dialog is displayed.

dgf03

When you respond Yes to the Select Database Now? he following dialog appears.

dgf04

When you double click on the alias and table name of the desirable item you will be able to create, read,update and delete records in that table.  The alias and table name also appear in the caption of the data entry dialog.

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS WordPress Anchors

Sometime anchors are required to make longer pages readily accessible for end users.  This application builds and scripts on page anchors complete with associated links.  Those links are then pasted to the clipboard where they can subsequently be pasted into a WordPress or HTML document.

wpa01

When the user selects the Gen New Anchor option the following dialog appears.

wpa02

That dialog is followed by the dialog below when the user clicks on the OK control.

wpa03

The final output from this process is listed below.

<a href="#top">Top</a><br><br>
<h7 id="anc001">Enter New Editor Items</h7><br><br>
<a href="#anc001">Enter New Editor Items</a>

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Django Workbench

Top
Create New App
Start The Server
Launch Web Browser
Launch Django IDE

When you need to write applications using Django here is a workbench you may find to be helpful.  This full featured application performs all the necessary Django function without entering a single command on the command line.

When you create a new project the following dialog appears to collect a family name.

dwb02

If the family name already exists the following message appears and execution of the creation step ends.

dwb03

Top

Create New App

To create a new application select the Start App menu item and the following dialog will appear.

dwb08

When the user select a project by double clicking on the desired item the following dialog appears.

dwb09

Click the OK control to accept the application name.

If the application already exists the following dialog will appear.

dwb10

This application will not allow you to write over and existing project.  If the application does not exists then it is created and the user can proceed to utilize the newly generated code.

Top

Start The Server

To start the server for a particular Django project select the Start Server Menu Item.

dwb04

Select the desired sub folder to indicate the server to start by double clicking on the desirable item.

dwb05

The server is started and is available at port 8000 (by default).

Top

Launch Web Browser

By selecting the Launch Browser Option the web browser is launched to review the started application.

Top

Launch Django IDE

To invoke the Django IDE select the Launch Django IDE option and the following dialog will appear.

dwb06

The IDE is started with the file name selected appearing in the editor.

dwb07

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS List Delphi Projects

There are those time when you need to view a list of Delphi projects.  After traversing the projects a double click should invoke the Delphi IDE.  That is exactly what this application does.

ldp01

The default is to list all available Delphi projects.  You will be prompted to select main line projects.

ldp02

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Django Tutorial 01

Python version 3.5.x does not employ the normal MySQL databases.  Eclipse Neon 4.6 supports PyDev plugin for Python and Django.  I recommend using Eclipse for project creations.  When I authored this article initially Python 3.5.x and Eclipse Neon 4.6 were not available.  The screenshot below show the types of project supported by Eclipse.

dje01

To create a new project invoke the command prompt shell and key in the command as depicted below.

jt01

As you can see the jt01 sub directory has been created and contains the new Django project.

If your DBMS is not configured correctly you can use the following example to do so.

jt02

To configure MySQL for Django modify he “settings.py” of your project to reflect the following.

Near the top of the file place these two statements beneath the existing import statement.

import pymysql
pymysql.install_as_MySQLdb()

Move down to the the databases section and include the code below.

DATABASES = {
    'default': {
        'NAME': 'bcswebtools',
        'ENGINE': 'django.db.backends.mysql',
        'USER': 'user',
        'PASSWORD': 'password',
        'OPTIONS': {
          'autocommit': True,
        },
    }
}

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Executable Cross Reference

To access and document Delphi projects working in reverse order is sensible.  The applications allows you to select the executable modules of a specific sub directory.  From this application practically all required programmer activity is attainable for subsequent application development and documentation.

This view reveals many of the Primary Options available.

rex14

When the Load Executable option is selected the following dialog will appear.

rex15

Select the desired directory and click on the Select Folder option.

To gain complete access to this tool software produced by Brooks Computing Systems, LLC and other vendors must be installed and present within your configuration.  There is no charge for any of these tools.

rex02

Notice the selected sub directory is listed and centered at the top of the dialog.

The dialog below identifies the options available to the user after the executable has been selected by double clicking on any file specification in the list control.

rex01

The Execute option launches the executable as is.  This option allows the user to execute the program.  Notice the 32 and 64 bit executables are available for subsequent execution.

The Search option allow the user to specify a search string to detect in the list of files.

rex03

When the user selects the search string by clicking on the Ok control all file specification that contain that text are highlighted.

The Compile option dynamically creates the project path from the executable file specification and launches the Delphi IDE for subsequent application development.

The View option populates the Project File List tab with the file specifications for the project.

rex04

Notice the directory for the Delphi project appears centered at the top of the dialog.  When the user double clicks on any item in the list the following dialog will appear.

rex05

When you double click on the Execute option the associated file is launched immediately.  If the file you selected is a Delphi project file the Delphi IDE is launched.  If the file specification is an executable file the application begins its execution.

When you double click on the View option the file specification is available for viewing in the File Viewer Tab of the application.

The Position By Path option lists a unique paths for the subject directory.  The dialog appears below.

rex06

When the user double clicks on the list control the user is automatically positioned in the Executable Programs Workbench tab.  This feature is most useful with there are many sub folders because it allows rapid traversal of the list and double clicking selects the desired object.

When the Document This One option is selected the user is positioned to the Documentation Center tab of the application.  This location is listed in the dialog below.

rex07

Initially the file specification is populated for you and you simply add a descriptive title and the associated narrative in the Basic Information tab.  Click on the Maintenance Log to gain access to the maintenance details.

rex08

Invoke the popup menu for the Maintenance Log tab and the options appear.  If you click on the Copy Mod Log To Clipboard the Maintenance log in its entirety is copied to the clipboard for subsequent pasting (into Code Centeral or other locations) that can accommodate plain old text (pot).

When the user selects the Add New Line menu item the user is prompted for the new entry description.  The application supplies the time stamp and formatting.

rex09

When the user clicks the Ok control the new maintenance line is inserted.

There is a Future Maintenance tab is where we can make entries for future modifications for each application.

rex16

The Add Future Item menu item will invoke a dialog to identify the future actions.

rex17

Tap the OK button to insert the designated description into the Future Maintenance items area.

To move a Future Maintenance Item over the to Maintenance Log highlight a single item then invoke the popup menu and select the Add To Maintenance option.  The highlighted item is remove from the Future Maintenance tab and added to the Maintenance Log.

rex18

The Sort Descending Sequence reversed the order of the items in the list so the last item becomes the first item.

There is a report available for the Maintenance Log which is depicted below.

rex13

When the user selects the Zip This Directory option the user is prompted to authorize the creation of the zip file.

rex10

When the user selects the Add To Executable Base this executable is added to the list of executables used by the programmer’s workbench.  This feature provides a simple mechanism to invoke the executable by using its record number for its selection.

rex11

If the item selected is already in the database the above dialog appears and the process continues as you would normally expect.

If the item is not already in the database the following dialog appears prompting the user for the program description.

rex12

Subsequently the appropriate record is inserted into the database and is available for immediate use.

Below is the database schema used for this application.

-- phpMyAdmin SQL Dump
-- version 4.6.0
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 22, 2016 at 04:29 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12
 
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
 
--
-- Database: `bcsra`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `ext`
--
 
CREATE TABLE `ext` (
  `id` int(11) NOT NULL,
  `ext` varchar(75) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `lud`
--
 
CREATE TABLE `lud` (
  `id` int(11) NOT NULL,
  `rdate` datetime NOT NULL,
  `sdes` varchar(125) NOT NULL,
  `sdir` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `sdoc`
--
 
CREATE TABLE `sdoc` (
  `id` int(11) NOT NULL,
  `sdes` varchar(125) NOT NULL,
  `sdir` varchar(255) NOT NULL,
  `doc` mediumtext NOT NULL,
  `maint` mediumtext NOT NULL,
  `fut` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `ext`
--
ALTER TABLE `ext`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ext` (`ext`);
 
--
-- Indexes for table `lud`
--
ALTER TABLE `lud`
  ADD PRIMARY KEY (`id`);
 
--
-- Indexes for table `sdoc`
--
ALTER TABLE `sdoc`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sdir` (`sdir`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `ext`
--
ALTER TABLE `ext`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lud`
--
ALTER TABLE `lud`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=243;
--
-- AUTO_INCREMENT for table `sdoc`
--
ALTER TABLE `sdoc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

 

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Select File Or Directory

There are those occasions when a file or directory needs to be selected.  This utility handles all the idiosyncrasies of selecting a directory or a file.  A single dialog fulfills all requirements by allowing a Title for the dialog but the file selection dialog allows the user to specify file types to open.  If no file types are specified the default All Files | *.* file type is selected by default.

sdf01

The dialog to select a directory is shown below.

sdf02

The dialog to select a file is listed below.

sdf03png

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Unique Extensions

There are those times when we need to know which extensions of a particular sub directory are unique.  This application allows the end user to select a sub directory then identifies the unique extensions for that sub directory.

uni01

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Zip Delphi Source Code

There are those time when the project is completed and a zip file of the source code needs to be produced.  This utility will create the appropriate zip file that will only contain the source code of the project.

zs01

This application has been modified to detect parameters passed to it on the command line.  If the parameter is a valid directory the application continues in silent mode and the property is established based on the passed parameter value.

If the value passed is not a valid directory the following dialog is displayed and execution is terminated.

z12

When the parameter specifies a correct directory the processing continues by displaying the following dialog.

z13

If you select the No option the following dialog appears.

z14

To preserve the existing file the ability to rename the existing zip is available.  When the user click the Yes option the following dialog appears.

z15

When using the graphical user interface (GUI) of this application by clicking on the Zip Source the folowing dialog appears.

z16

As soon as the user completes selecting the desired directory processing resumes.  After the new zip file is created the following 7 Zip GUI appears.

z17

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Video Viewer

There are those times when a Quick and dirty video viewer application comes in handy.

vv01

This application is designed to view videos. The user selects the subject directory and the application provides the user with a list of directories and a list of files.

When you double click on the directories control a drill down is performed and the list of files associated with that directory appears in a separate dialog.

When you double click on a files control the items selected will execute.

Invoke the pop up menu on either list to reveal the capability to perform a delete function. A delete capability is available for directories and files. The user is prompted before completing all delete functions.

 

A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.