Rapid Agile Development for Prototyping and Rapid Application Development

Navigation: <Root level>

File Manifests

 

 

 

 

Main Menu > Maintenance > File Manifests

 

File Manifests are used to group Files for Concatenation or SQL Script execution. File Manifests can cascade their concatenated output to other File Manifests, useful when creating and maintaining SQL Patch Scripts.

 

 

 

Cascading output from File Manifests.

 

End Result files can be built from the output of File Manifests. In the example below the inputs to File Manifest 4 are the output of File Manifests 1 & 2. The way File Manifests cascade their output is determined by the Output File Manifest selection and the File Manifest Build Order. Cascading File Manifests can be used to produce SQL Script Patches:

 

 

 

File Manifest Dialog

 

This is displayed when “New” or “Modify” are clicked.

File Manifests can either be SQL based (SQL Scripts), Code based (C# / VB.NET) or User Defined (Text / Batch Files).

 

 

 

Details Tab

 

 

Source Tab

 

 

Output Tab

 

 

File Manifest Fields

 

File Manifest Type

Determined by Project Type of the owning Project; select from: Code | SQL | User Defined

Filter

Determined by File Manifest Type; select from: *.bat | *.cs | *.sql | *.txt | *.vb | *.*

Name

Name of the File Manifest

Source Directory

Source Directory for files to be added to the File Manifest when Refresh is clicked

Output File

Name of the Concatenated Output File

Output File Manifest

Select another File Manifest to receive the output from the current File Manifest. This allows a Concatenation Hierarchy

Include File Header

Add File Header to the Concatenated Output File

Apply Placeholders on Concatenate

Apply Placeholder substitution to the Concatenated Output File

Apply Placeholders on Execute SQL

Apply Placeholder substitution when SQL Scripts are Executed

Build Order

<Read Only> Set in File Manifests dialog to determine the build order of the File Manifest

Maintain Header & Footer Files

Check to maintain the Header | Body | Footer file position markers for generated files

Load Files on Modify

If there are a large number of files in the File Manifest it can take some time to load. Check this field if the files should not be displayed on load. Files can be loaded manually by clicking Refresh in the lower section of the form. The default value for new File Manifests is True (checked)

Check File Exists

When checked the File Manifest will check that all its Files Exist.

 

Buttons

 

 

Browse Directory

Refresh Files

Concatenated Files

Placeholders

Open Concatenated Output File

Open Output File Location

Find and Replace in selected File(s) content

Version

Import from a previous Export

 

File Manifest Context Menu

 

 

 

Move selected File Index Up

Move selected File Index Down

Set selected file as File Manifest Header file

Set selected file as File Manifest Footer file

Compare 2 Files if Comparison Tool is set up in Options e.g. Beyond Compare

Inset a New File above current Index

Add a New File to the End of the File Manifest

Select / Deselect All Files

Modify selected File record

Edit physical File in File Editor as set in Options e.g. EditPadPro  (defaults to NotePad.exe)

Copy selected File's Name to Clipboard

Copy selected File’s Path to the Clipboard

Open selected File's directory

Execute selected SQL Script if connected to data source

Open selected File in SQL Tool! if connected to data source

Edit physical File in Code Editor as set in Options

Edit physical File in SQL Editor as set in Options

Export File Manifest Files to CSV

Open Exports Directory

Delete selected File record, not the physical file

 

 

Find and Replace in Files

Find & Replace text in selected files, in the current File Manifest:

 

 

 

Version

 

This is the Version Number of the File Manifest Concatenated Output. If Auto Increment Revision Number is checked the last digit will be incremented each time the File Manifest is concatenated.

 

 

 

Refresh

 

Refresh files from the Source Directory. Files will be removed from the File Manifest if ‘Yes’ is clicked. Click ‘Cancel’ to cancel the operation.

 


 

Right Click & Add File/ Insert File or Drag & Drop File

 

Files can be Added to the end of a File Manifest or Inserted into a required index position. Dragging & Dropping files onto either the Main File Listview or the File Manifest Listview will add the file(s) to the end of the selected File Manifest.

 

 

SQL Utilities

 

Path

Description

[InstallDir]\Templates\SQL\Utilities\1.KillConnections.sql

Kills connections to the database specified by Placeholder <#_TARGET_DATABASE_NAME_#>

[InstallDir]\Templates\SQL\Utilities\2.DropDatabase.sql

Drops the database specified by Placeholder <#_TARGET_DATABASE_NAME_#>

[InstallDir]\Templates\SQL\Utilities\3.CreateDatabase.sql

Creates a new database specified by Placeholders <#_DATABASE_PATH_#><#_TARGET_DATABASE_NAME_#>

[InstallDir]\Templates\SQL\Utilities\4.SetDatabaseOptions.sql

Sets database options to the database specified by Placeholder <#_TARGET_DATABASE_NAME_#>

 

 

 

 

 

www.rapidagiledevelopment.com by Cove Bay Software Limited Copyright © 2015