BCS Delphi XE8 Exp Imp MySql Databases

There are those times when you will need to backup and restore your MySQL databases.  This utility creates two batch files to accomplish that assigned task.
msd1

The user must let the application know where the mysqldump.exe program resides at their installation.  Afterwards a destination location for the output is selected.
msd2

Those two batch files are dynamically created considering every database currently active on localhost or the designated MySQL server.

The  default of this utility is to dump the structure and the data.  If you double click on the table in the list only the structure is copied as backup.

Once the batch files are invoked the exported database will appear in the designated directory.

The 32 bit executable can be downloaded by clicking here.
The 64 bit executable can be downloaded by clicking here.
The component documentation can be viewed by clicking here.
The source code for the application can be downloaded by clicking here.

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

BCS Stackoverflow Code Formatter

To insert a block of code in Stackoveflow every line in the block must contain four spaces.  This utility will take an isolated block and insert four spaces at the beginning of each line the allow you to save the newly modified code and a separate file.

sofu

  • Create a new text file.
  • Copy and paste the code you would like to post on Stackoverflow.
  • Save the text file.
  • Invoke this utility.
  • Open the newly created text file b clicking on the Prepare Stackoverflow Text menu item.
    otf
  • Save the updated output to the text file of your liking.
    stf

The 32 bit application can be downloaded by clicking here.
The 64 bit application can be downloaded by clicking here.
The component documentation can be viewed by clicking here.
The source code can be accessed by clicking here.

Now open the newly formatted file select all and past into your Stackoverflow article. This is a fairly painless way to prepare a block of code for insertion into Stackoverflow.

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

BCS Delphi XE8 Get Date And Time


There are those time when you will need to establish a date and time.  This utility will allow the end user the capability to do that.

gdnt

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 Delphi XE8 Invoice Generator


There are those times when the programmer need to submit an invoice so they can be paid for services rendered. invgen
The first task would be to create a MySQL database named “bcsi” (minus quotes). The BCS Select Date And Time Component is required for this software.  Review the specification by clicking here.

There are four primary tables that comprise the database used for the BCS Invoice Generator. The customers table is listed below.

-- phpMyAdmin SQL Dump
-- version 4.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 16, 2015 at 02:29 PM
-- 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 utf8 */;
 
--
-- Database: `bcsi`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `cust`
--
 
CREATE TABLE IF NOT EXISTS `cust` (
  `id` int(11) NOT NULL,
  `cust` varchar(125) NOT NULL,
  `cinfo` mediumtext NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `cust`
--
ALTER TABLE `cust`
  ADD PRIMARY KEY (`id`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `cust`
--
ALTER TABLE `cust`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
/*!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 */;
The services or inventory master table is listed below.
-- phpMyAdmin SQL Dump
-- version 4.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 16, 2015 at 02:32 PM
-- 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 utf8 */;
 
--
-- Database: `bcsi`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `invm`
--
 
CREATE TABLE IF NOT EXISTS `invm` (
  `id` int(11) NOT NULL,
  `rdate` datetime NOT NULL,
  `cust` varchar(125) NOT NULL,
  `cinfo` mediumtext NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `invm`
--
ALTER TABLE `invm`
  ADD PRIMARY KEY (`id`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `invm`
--
ALTER TABLE `invm`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
/*!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 */;
The inventory or services items table is listed below.
-- phpMyAdmin SQL Dump
-- version 4.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 16, 2015 at 02:35 PM
-- 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 utf8 */;
 
--
-- Database: `bcsi`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `inv`
--
 
CREATE TABLE IF NOT EXISTS `inv` (
  `id` int(11) NOT NULL,
  `inv` varchar(125) NOT NULL,
  `cost` double NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `inv`
--
ALTER TABLE `inv`
  ADD PRIMARY KEY (`id`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `inv`
--
ALTER TABLE `inv`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
/*!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 */;
The invoice details table description is listed below.
-- phpMyAdmin SQL Dump
-- version 4.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 16, 2015 at 02:37 PM
-- 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 utf8 */;
 
--
-- Database: `bcsi`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `est`
--
 
CREATE TABLE IF NOT EXISTS `est` (
  `id` int(11) NOT NULL,
  `invno` int(11) NOT NULL,
  `cnt` double NOT NULL,
  `task` varchar(125) NOT NULL,
  `cost` double NOT NULL,
  `stot` double NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `est`
--
ALTER TABLE `est`
  ADD PRIMARY KEY (`id`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `est`
--
ALTER TABLE `est`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
/*!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 */;
The 32 bit executable program may be downloaded here. The 64 bit executable program may be downloaded here. The component documentation can be viewed by clicking here. The source code for this application can be downloaded by clicking here. Once the database is created and the tables are imported simply download either the 32 or 64 bit executable and you should be in operation. invgen When the application comes active I recommend entering the information for one customer and one or more service items. To add a new customer click on the Customers menu item and fill in the required information on the form. To add a new service click on the Services Offered menu item and fill in the rewired information on the form. Each time you create a new invoice (clicking the + (plus button) on the database navigator) you are prompted to select the customer by the appearance of the Customer dialog.  Simply double click on the item in the database grid to select the associated item. When you would like to add a new service provided to the invoice (clicking the + (plus button) on the database navigator) you are prompted to select the service from the available services by double clicking on the desired service to be added. In either scenario the user can perform CRUD operations via the database grid until the desired results are entered into the database.  Then simply double click on the desired item to utilize it in this application. To invoke the reports click on the Reports menu item and a drop down will appear.  Then simply click on the desired menu item to generate the associated report. There are three reports with this application.  The first report is the Invoice Report and is depicted below. invr01 Another report is the Customers Report and it is depicted below. invr02 The final report is for the individual services offered and is depicted below. invr03 This application generates invoices for services rendered and should be of service to the programmers for years into the future. Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

BCS Orpheus File Manager


An additional file manager is now available.
ofm

The report view component give a robust view of the hard disk contents.

The TurboPower Orpheus package must be installed in Delphi XE8.

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

Modifications
————–     ————————————–
2015-07-04  –  Activated Double Click to Launch Application
2015-07-04  –  Added Up One button to facilitate sub directory navigation
2015-08-20  –  Added Delphi Styles

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