Details

The main menu of SignGen provides you access to the five main functions of the program.

Certificate – Allows users to create a unique Certificate key for placement on any document that they have created

Search – Allows the user to search SignGen by Certificate number or Originator Name for information on Certificates that have been issued.

Administer – The administration centre for the creation and maintenance of the users on the system. (This area can be secured or rely on integrity) Secured version of SignGen is available on request.

Reports – Presents a menu that contains basic reports – this area will dynamically change and create several Upgrade releases as users requirements are expanded.

Administration

The Administration System allows the Administrator the capabilities to add Clients/Users to the main database. Facilities are provided to maintain clients.

If required this form can be set to only be available to authorised administrators.

From this area the Administrator sets up the User Machine with their particulars and can assists them in creating their unique private key.

Add New Client

The function of adding a client requires the following items:

Key One (Public) – the unique key that identifies the user. This key can contain any numeric or character based symbols of not more than 50 characters. Recommended minimum of 8 characters – symbols and punctuation should not be used.

Key Two (Private) – the unique key that is managed by the USER and allows them the privacy and security of having a key that is exclusive to them. This key can contain any numeric or character based symbols of not more than 50 characters. Recommended minimum of 8 characters – symbols and punctuation should not be used.

This key is created and controlled by the User. The Administrator has administrative access and edit rights.

Certificate Point – This is defaulted to “Registry” at the moment but facilities within SignGen are designed to allow the program to reach out to external Certifying Authorities if that is required.

Client Position – The position that the client/user holds in the organisation.

Generated Key – this key is automatically generated by the system to create the unique identifier for the client/user. It is a concatenation of both Key One and Key Two – this is the key that is used to identify all transaction processed by the client/user.

Set Signature Block – Opens a form and allows the administrator to choose which of the 9 lines of the Certified Signature Block will be created for each Certification. The Transaction number is a obligatory requirement and can not be turned off.

This form allows the administrator to find and edit details on any clients within the database. Navigation buttons, Find button and the ability to sort or filter on any field is available on this form.

To Find a client – Left click on any field then click on the binoculars and you can search the database on items for that field.

It is essential that each user is set up on their Personal computer to enable that particulars are stored on their machine for retrieval and then comparison against the main transaction issuing database. This data is stored on the users Personal computer within a separate database – Client Details (table me-data) in the SignGen Personal Details directory.

Using this form at the users Personal computer will allow the user to input their Private key and regenerate the Generated key which offers privacy and a layer of Personal security to the User certification.

If the user has already been created by the Add Client function (main data base) then you can select the details from a list by clicking on the Select From List button.

When completed setting up the details and Keys can be sent to the master database by clicking on the Update Client Master button.

This area allows the allocation of unique Certificate (Transaction) number that can be used to authenticate or validate the originator of the document. There are three steps to the Certification.

3. (if validated) then issue a unique transaction number and signature block for use with the required document.

On clicking Certificate this form is presented to the user. The details shown are from the information stored on their machine (drawn from the data created in the User Set-up Process)

The user should review the form and check that the request that is about to be made is on their behalf.

If the user is satisfied with the details then they can click on the “TICK” button and the system will move on to the next validation phase “Get New Number”

After clicking on the “TICK” on the previous screen the program examines the SignGen Client database and validates the details submitted by the user against the master records.

If the details on the Check Client form are not validated then the system will advise the user and cease the request process.

If the details or the Check Client form are valid then the Get New Number form will appear and allow the client to proceed to the next phase of being allocated a unique transaction number for their document.

The Lines for Block represent which of the 9 Certificate block lines will be created for the Certificate. (selected in the Client Area).

To proceed to the transaction number allocation form please click on the Pencil Button.

This is the heart of the transaction registration process – the form returns to the client the following information:

Description of fields:

Transaction Number – this number is the numerically incremented next available number within the SignGen database.

Transaction Date – the date of the registration of this transaction

Transaction Time – the time including hours, minutes, seconds of the transaction

Transaction Certificate – this is the unique SignGen key that is to be used for validation of documents – this contains a combination of the Transaction Number and the date of the transaction – the first six digits of the Transaction number are replaced with the six digit date values.

Add Document Details – clicking on this button will allow you to add details to the system in relation to the document that the transaction number is required for. (See details further down in this document)

Signature Block – this is the electronic signature stamp that has been created for this transaction. You can cut and past this to any document you choose. However, for your convenience SignGen writes several background files for use in your Microsoft environment.

sign.txt is written to the My Documents directory on the user machine and can be inserted into any document by using the macro provided below.

Macro for MS Word. This may require technical assistance to be inserted in your Word Program.

Sub Load_Signature_Block()
'
' Load_Signature_Block Macro |
' Macro created 7/09/01 by Garry J. Smith
'
    Documents.Open FileName:="sign.txt", ConfirmConversions:=False, ReadOnly:= _
        False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:= _
        "", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="", _
        Format:=wdOpenFormatAuto
    Selection.MoveDown Unit:=wdLine, Count:=8, Extend:=wdExtend
    Selection.Copy
    ActiveDocument.Close
    Selection.Paste
End Sub

Clicking on the menu item “Tools”, select “Macro” and then “Load_Signature_Block” will insert the following into your document at the cursor point:

This is an electronically validated unique Certificate
® 0709-01111-1111-1247
® Released by : Garry J. Smith
® Position : Manager
® Organisation: Consultant
® Certified by: Registry
® Date issued : 7/09/01 9:34:57 PM
Correspondence with this Certificate can be classed as Authenticated

Certified.txt, Certified.rtf and Certified.htm files are all written to your c:\WINDOWS\Application Data\Microsoft\Signatures directory.

These files are used by Microsoft's Outlook e-mail program as a signature block.

Clicking on the menu item “Insert”, select “Signature” and then “Certified” will insert the following into your -email at the cursor point:

This is an electronically validated unique Certificate: ® 0709-01111-1111-1249 ® Released by: Garry J. Smith ® Position: Director ® Organisation: GJSmith.com ® Certified by: Registry ® issued by SignGen ® Date issued: 7/09/01 10:21:08 PM Correspondence with this Certificate can be classed as Authenticated

This is an electronically validated unique Certificate:
® 0709-01111-1111-1249
® Released by : Garry J. Smith
® Position : Director
® Organisation: GJSmith.com
® Certified by: Registry ® issued by SignGen
® Date issued : 7/09/01 10:21:08 PM
Correspondence with this Certificate can be classed as Authenticated

All of the created files will be dynamically updated (replaced) with each new number issued so stamping of documents should happen immediately after the issue of the transaction number.

For convenience an e-mail address such as SignGen@yourcompany.com could be set up and recipients could be invited to seek confirmation of the transaction details by sending mail to that address. The administration of the SignGen mail could be assigned to any person within your organisation and they could search and validate any inquiry by using the Search function within the SignGen application.

As an example the following is used at GJSmith.com by using the 9^th line to the output files. This can be organised on request only – SignGen@gjsmith.com

This is an electronically validated unique Certificate:
® 0809-01111-1111-1252
® Released by : Garry J. Smith
® Position : Director
® Organisation: GJSmith.com
® Certified by: Registry ® issued by SignGen©
® Date issued : 8/09/01 12:42:09 PM
Correspondence with this Certificate can be classed as Authenticated
To confirm please e-mail SignGen@gjsmith.com with a copy of this block

Add Document Details

You can choose to add the following details to the transaction. It is advisable to complete this additional information as it will provide a more meaningful history for the transaction registration and will also assist in the management of corporate file content.

The files reference facility will allow the selection of a file number from known corporate files.

Search

SignGen provides two methods of search which allow the retrieval of information on any transactions certificates that have been issued.

You can select the transaction number from a list of all transaction numbers or you can input the transaction number manually.

This form shows a brief description of the details available for the transaction. If further information is available on the transaction then the radio button on the right will be occupied and the user can click on the “View” button to see this additional information.

Search on Client Name – show all transaction issued on behalf of an individual.

You can select the Client Name from a list of all Clients or you can input the Client Name manually.

Clicking on “Search” will list all transaction issued on behalf of that client.

SignGen provides a simply file management system to enable the allocation of file numbers to documents and transactions. This file management system can also be utilised as a basic file management system for Registry staff thereby providing access to all corporate file numbers and titles.

File Management

This form allows access to all existing file details on the system.

This form allows the user to find and edit details on any file within the database using

Navigation buttons or the Find button and the ability to sort or filter on any field is also available on this form.

To Find a file – Left click on any field then click on the binoculars and you can search the database on items for that field.

From this form you can view all existing transaction that are associated to this file thereby providing a record of physical document created by users that should be retained on the physical file.

Additionally it is possible to view all transaction records and allocate file numbers to transaction that do not have them or alter the file numbers if the user has inadvertently chosen the wrong file for a particular document.

Add File Number – to existing record

Facilities exist to enable the browsing of all transaction that are recorded and that file numbers can be allocated to transaction that may have been overlooked. Additionally it is possible to reassign a file number to one that my have been inadvertently selected.

This form allows the user to find and edit file allocated details on any transaction within the database using the Navigation buttons or the Find button and the ability to sort or filter on any field is also available on this form.

To Find a file – Left click on any field then click on the binoculars and you can search the database on items for that field.

Facilities also exist to show all records associated to this file number by clicking on the View Associated Records button.

If you require further information on the transaction then click on the View Full Details button.

This is an electronically validated unique Certificate
® 0809-01111-1111-1251
® Released by: Garry J. Smith
® Position: Director
® Organisation: GJSmith.com
® Certified by: Registry ® issued by SignGen
® Date issued: 8/09/01 11:12:28 AM
Correspondence with this Certificate can be classed as Authenticated
To confirm please e-mail SignGen@gjsmith.com with a copy of this block

Declaration

SignGen is a Microsoft Access 2000 solution fully developed by Garry J. Smith. Innovations, design and development within this application are all the Intellectual Property of Garry J. Smith of GJSmith.com from the date of publication of SignGen

All due care and effort has been expended to ensure that this application is compliant to all standards required for Microsoft Access 2000 Development. However, the developer accepts no responsibility for corruption, loss of data or application failures that may occur on systems.

The copyright for all material provided in this application is held by Garry J. Smith of GJSmith.com as the original creator of the material. Except as stated herein, none of the material may be copied, reproduced, distributed, republished, downloaded, displayed, posted or transmitted in any form or by any means, including, but not limited to, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of GJSmith.com or the copyright owner. Permission is granted to display, copy, distribute and download the materials within this application for Personal, non-commercial use only provided you do not modify the materials and that you retain all copyright and other proprietary notices contained in the materials. You also may not, without GJSmith.com owner's permission, "mirror" any material contained on this Site on any other server. This permission terminates automatically if you breach any of these terms or conditions. Upon termination, you will immediately destroy any downloaded and printed materials. Any unauthorised use of any material contained on this Site may violate copyright laws, trademark laws, the laws of privacy and publicity, and communications regulations and statutes.

Important that the application and supporting files be installed into the C:\SignGen Directory – several sub directories that contain the data and relevant graphics are created and populated by the installation program.

The automatic installation program will create this directory and install the software and support files in the appropriate locations.

If you wish to install the Demonstration on the D Drive please contact
SignGen-D@gjsmith.com and I will provide a version that will support that drive.

SignGen can be installed in various formats and the databases can be distributed throughout a networked environment. Some limited Microsoft Access 2000 skills will be required to achieve this successfully.

SignGen application must be stored on the Client’s Personal Computer. This is required to enable the client to maintain a unique Client Details table (me-Data) for use within the network.

Client Details – stored in the Client Details Directory – can be positioned anywhere on a network.

Document Details – stored in the Document Details Directory – can be positioned anywhere on a network.

Transaction Details - stored in the Transaction Records directory– can be positioned anywhere on a network.

FileRegister - stored in the FileRegister directory – can be positioned anywhere on a network.

Client Details - stored in the Personal Directory – must be stored in a location of your choice on the Client’s Personal Computer.

On completion of the distribution of the databases the SignGen application on each client’s machine will have to have the data linked to the SignGen application. This is achieved by opening the application in “Edit” mode (hold down a shift key while opening the application).

Then do the following steps:

Maximise the form in the bottom left of the screen. Click on the tables tab. Delete all tables currently displayed.

Then click on file, external data, Link and navigate to each of the databases – select the table within each database. This must be done for each of the tables required:

Network directory - Client Details – table: Client Details

Network directory – Document Details – table: Document Details

Network directory -Transaction Details – table: Transactions

Minimise the form on the screen – clicking on minus sign, this is required for aesthetic value only to hide in the background the structure of the data engine and make the application screens less cluttered.

If support is required to assist in the network installation please contact
SignGen-Support@gjsmith.com

Purchase details

SignGen is a shareware product – with an expiry date limitation for those that do not purchase – no destruction of data occurs on expiration of the program only access to the application is restricted.

SignGen purchase expectations are based on the honour and integrity of users who obtain benefits from this program.

Less than 5 Users US$49.95
Greater than 5 Users US$9.95 per User up to 50 users
Greater than 50 Users US$500.00

With purchase – all updates and upgrade will be e-mailed to the purchase point.

E-mail Support is free up to a reasonable level (defined by Supporting officer) – support beyond that will cost US$35.00 per hour or part there of.

	click here to download my Word 2000 resume in a ZIP file (164k) Compressed with WinZip
	Click here to request a Word 2000 version to be e-mailed to you
	Click Here to download my resume in Word 2000 format. (316k) if a password is requested then please click on OK and it will load into MSWord

The copyright in all material provided on this site ("Site") is held by GJSmith.com or by the original creator of the material. Except as stated herein, none of the material may be copied, reproduced, distributed, republished, downloaded, displayed, posted or transmitted in any form or by any means, including, but not limited to, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of GJSmith.com or the copyright owner. Permission is granted to display, copy, distribute and download the materials on this Site for Personal, non-commercial use only provided you do not modify the materials and that you retain all copyright and other proprietary notices contained in the materials. You also may not, without GJSmith.com owner's permission, "mirror" any material contained on this Site on any other server. This permission terminates automatically if you breach any of these terms or conditions. Upon termination, you will immediately destroy any downloaded and printed materials. Any unauthorised use of any material contained on this Site may violate copyright laws, trademark laws, the laws of privacy and publicity, and communications regulations and statutes.

	Demonstration Software Self installing executable 2.49mb Download a fully functioning Demonstration version of SignGen for testing and evaluation Click on the image to the left to download
	SignGen Documentation (Demo) Word Document in Winzip format 1.38mb Download Documentation on SignGen which will explain in detail the functionality and use of the program. Click on the image to the left to download
	*To order SignGen* Click on the image to the left to order Please remember to e-mail me after order for the latest version, tips and upgrades. SignGen-order@gjsmith.com
	SignGen Documentation (Full) Word Document in Winzip format 2.7mb Download Documentation on SignGen which will explain in detail the functionality and use of the program. Click on the image to the left to download