Build Installer Process - Revision history

Anw: Included InnoSetup link for downloading the latest version

2018-04-06T11:44:16Z

Included InnoSetup link for downloading the latest version

← Older revision		Revision as of 13:44, 6 April 2018
Line 4:		Line 4:
	Install from:		Install from:
	* P:\271321 - Vision\_Development\Development Tools\ispack-5.4.1-unicode.exe		* P:\271321 - Vision\_Development\Development Tools\ispack-5.4.1-unicode.exe
			or download the latest version from:
			* http://www.jrsoftware.org/isdl.php

Anw: Updated version of installer package

2018-04-06T11:38:46Z

Updated version of installer package

← Older revision		Revision as of 13:38, 6 April 2018
Line 1:		Line 1:
	== Requirements ==		== Requirements ==
	InnoSetup/InnoIDE installed on local PC. ~~Version used here~~: 1.0.0.~~0078~~		InnoSetup/InnoIDE installed on local PC.

			Install from:
			* P:\271321 - Vision\_Development\Development Tools\ispack-5.4.1-unicode.exe

Anw: Formatting

2018-04-06T11:29:34Z

Formatting

← Older revision		Revision as of 13:29, 6 April 2018
Line 91:		Line 91:
	--default-character-set=utf8 --comments <{SQL file}		--default-character-set=utf8 --comments <{SQL file}
	</pre>		</pre>


	== Edit Metadata ==		== Edit Metadata ==
Line 104:		Line 105:

	Copy all files to be distributed (including these files) and all subdirectories to a a clean Distribution folder, for building the installer. Typically this folder is C:\Inetpub\wwwroot\Vision, which should be different to your development directory. If using this folder, the standard Installer script need not be changed.		Copy all files to be distributed (including these files) and all subdirectories to a a clean Distribution folder, for building the installer. Typically this folder is C:\Inetpub\wwwroot\Vision, which should be different to your development directory. If using this folder, the standard Installer script need not be changed.


	== Build Installer ==		== Build Installer ==
Line 117:		Line 119:
	* Change ''AppCopyright'' to reflect the current year.		* Change ''AppCopyright'' to reflect the current year.
	* Change ''SetupIconFile'' to point to your Distribution folder if necessary.		* Change ''SetupIconFile'' to point to your Distribution folder if necessary.


	In the '''Files''' section:		In the '''Files''' section:
Line 128:		Line 129:

	If working on a local copy, copy the changes back to the projects drive, first replacing the distribution folder as before if not set to C:\Inetpub\wwwroot\Vision.		If working on a local copy, copy the changes back to the projects drive, first replacing the distribution folder as before if not set to C:\Inetpub\wwwroot\Vision.


	In the project folder P:\271321 - Vision\_Installers\Installer\Output, copy and zip the file ''setup.exe'' to the parent folder and rename to:		In the project folder P:\271321 - Vision\_Installers\Installer\Output, copy and zip the file ''setup.exe'' to the parent folder and rename to:

Anw: Updated with extended-insert note

2018-04-06T11:27:59Z

Updated with extended-insert note

← Older revision		Revision as of 13:27, 6 April 2018
Line 19:		Line 19:
	* Select ''Export to Self-Contained File''. Either accept the generated dump name and rename later or name it 'CreateDB-Struct.sql' now.		* Select ''Export to Self-Contained File''. Either accept the generated dump name and rename later or name it 'CreateDB-Struct.sql' now.
	* Check ''Include Create Schema''		* Check ''Include Create Schema''
	* Optional: Check or uncheck ''Create Dump in a single transaction...''.		* Optional: Check or uncheck ''Create Dump in a single transaction...'' - it is recommended that this is checked.
	* Click '''Start Export'''		* Click '''Start Export'''

Line 49:		Line 49:
	* Select ''Export to Self-Contained File''. Either accept the generated dump name and rename later or name it 'CreateDB-Data.sql' now.		* Select ''Export to Self-Contained File''. Either accept the generated dump name and rename later or name it 'CreateDB-Data.sql' now.
	* Uncheck ''Include Create Schema''		* Uncheck ''Include Create Schema''
	* Optional: Check or uncheck ''Create Dump in a single transaction...''.		* Optional: Check or uncheck ''Create Dump in a single transaction...'' - it is recommended that this is checked.
			* Optional: Check or uncheck ''extended-insert'' in '''Advanced Options'''.
	* Click '''Start Export'''		* Click '''Start Export'''

Anw: Updated based on latest information

2018-04-06T11:17:44Z

Updated based on latest information

@@ Line 1: / Line 1: @@
 First, create the database structure and metadata SQL files.
 This can be done manually using MySQL Administrator or through the command line as follows:
 ''Dump all the metadata:''
 <pre>
@@ Line 40: / Line 91: @@
 </pre>
-Take these produced files along with all the latest screens and place then into a clean directory.
+== Edit Metadata ==
-Use the existing Inno Setup installer file to build the installer.
+The Data dump may contain data that is not required - edit the file.
 [[Category:Vision Overview]]
 [[Category:Vision Coding and Release Doc|040]]
 [[Category:Vision Coding and Release]]

Anw at 09:24, 27 June 2011

2011-06-27T09:24:02Z

← Older revision		Revision as of 11:24, 27 June 2011
Line 14:		Line 14:
	--result-file=CreateDB-Data.sql		--result-file=CreateDB-Data.sql
	"productivity1" "rules_category" "rules_master" "screens" "system_extract_points"		"productivity1" "rules_category" "rules_master" "screens" "system_extract_points"
	"system_extracts" "system styles"		"system_extracts" "system styles" "menu_groups" "menus" "menu_screens" "group_menus"
	</pre>		</pre>
	'''Note:''' To dump all the data from a remote server (perhaps for support), remove everything after "productivity1"		'''Note:''' To dump all the data from a remote server (perhaps for support), remove everything after "productivity1"
Line 22:		Line 22:
	>mysqldump.exe --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE		>mysqldump.exe --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE
	--no-data=TRUE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE		--no-data=TRUE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE
	--replace=FALSE ~~--host=localhost~~ --insert-ignore=FALSE --quote-names=TRUE		--replace=FALSE --insert-ignore=FALSE --quote-names=TRUE
	--hex-blob=FALSE --complete-insert=TRUE --add-locks=TRUE --disable-keys=TRUE		--hex-blob=FALSE --complete-insert=TRUE --add-locks=TRUE --disable-keys=TRUE
	--delayed-insert=FALSE --create-options=TRUE --skip-extended-insert=TRUE		--delayed-insert=FALSE --create-options=TRUE --skip-extended-insert=TRUE

Anw at 13:07, 9 May 2011

2011-05-09T13:07:55Z

← Older revision		Revision as of 15:07, 9 May 2011
Line 3:		Line 3:

	''Dump all the metadata:''		''Dump all the metadata:''
	>mysqldump.exe --no-create-info=TRUE --order-by-primary=FALSE --force=FALSE --no-data=FALSE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE --replace=FALSE --insert-ignore=FALSE --extended-insert=FALSE --quote-names=TRUE --hex-blob=FALSE --complete-insert=TRUE --add-locks=TRUE --disable-keys=TRUE --delayed-insert=FALSE --create-options=TRUE --delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE --allow-keywords=FALSE --events=FALSE --host={host} --port=5306 --user=root --password={pwd} --result-file=CreateDB-Data.sql "productivity1" "rules_category" "rules_master" "screens" "system_extract_points" "system_extracts" "system styles"		<pre>
			>mysqldump.exe --no-create-info=TRUE --order-by-primary=FALSE --force=FALSE
			--no-data=FALSE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE
			--replace=FALSE --insert-ignore=FALSE --extended-insert=FALSE --quote-names=TRUE
			--hex-blob=FALSE --complete-insert=TRUE --add-locks=TRUE --disable-keys=TRUE
			--delayed-insert=FALSE --create-options=TRUE --delete-master-logs=FALSE --comments=TRUE
			--default-character-set=utf8 --max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE
			--lock-tables=TRUE --allow-keywords=FALSE --events=FALSE --host={host} --port=5306
			--user=root --password={pwd}
			--result-file=CreateDB-Data.sql
			"productivity1" "rules_category" "rules_master" "screens" "system_extract_points"
			"system_extracts" "system styles"
			</pre>
	'''Note:''' To dump all the data from a remote server (perhaps for support), remove everything after "productivity1"		'''Note:''' To dump all the data from a remote server (perhaps for support), remove everything after "productivity1"

	''Dump the structure:''		''Dump the structure:''
	>mysqldump.exe --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE --no-data=TRUE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE --replace=FALSE --host=localhost --insert-ignore=FALSE --quote-names=TRUE --hex-blob=FALSE --complete-insert=TRUE --add-locks=TRUE --disable-keys=TRUE --delayed-insert=FALSE --create-options=TRUE --skip-extended-insert=TRUE --delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8 --max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE --allow-keywords=FALSE --events=FALSE --routines --result-file=CreateDB-Struct.sql --host={host} --port=5306 --user=root --password={pwd} "productivity1"		<pre>
			>mysqldump.exe --no-create-info=FALSE --order-by-primary=FALSE --force=FALSE
			--no-data=TRUE --tz-utc=TRUE --flush-privileges=FALSE --compress=FALSE
			--replace=FALSE --host=localhost --insert-ignore=FALSE --quote-names=TRUE
			--hex-blob=FALSE --complete-insert=TRUE --add-locks=TRUE --disable-keys=TRUE
			--delayed-insert=FALSE --create-options=TRUE --skip-extended-insert=TRUE
			--delete-master-logs=FALSE --comments=TRUE --default-character-set=utf8
			--max_allowed_packet=1G --flush-logs=FALSE --dump-date=TRUE --lock-tables=TRUE
			--allow-keywords=FALSE --events=FALSE --routines
			--result-file=CreateDB-Struct.sql
			--host={host} --port=5306 --user=root --password={pwd}
			"productivity1"
			</pre>
	In these commands, replace '''{host}''' and '''{pwd}''' with your Vision Host IP address and root password.		In these commands, replace '''{host}''' and '''{pwd}''' with your Vision Host IP address and root password.

	'''Note:''' To load either file, you can use the following:		'''Note:''' To load either file, you can use the following:
	>mysql.exe --host={host} --port=5306 --user=root --password={pwd} --default-character-set=utf8 --comments <{SQL file}		<pre>
			>mysql.exe --host={host} --port=5306 --user=root --password={pwd}
			--default-character-set=utf8 --comments <{SQL file}
			</pre>

	Take these produced files along with all the latest screens and place then into a clean directory.		Take these produced files along with all the latest screens and place then into a clean directory.

Anw at 07:22, 9 May 2011

2011-05-09T07:22:49Z

← Older revision		Revision as of 09:22, 9 May 2011
Line 18:		Line 18:

	[[Category:Vision Overview]]		[[Category:Vision Overview]]
	[[Category:Vision Coding and Release\|040]]		[[Category:Vision Coding and Release Doc\|040]]
			[[Category:Vision Coding and Release]]

Anw at 14:07, 6 May 2011

2011-05-06T14:07:00Z

← Older revision		Revision as of 16:07, 6 May 2011
Line 18:		Line 18:

	[[Category:Vision Overview]]		[[Category:Vision Overview]]
	[[Category:Vision Coding and Release]]		[[Category:Vision Coding and Release\|040]]

Anw at 12:26, 26 January 2011

2011-01-26T12:26:24Z

← Older revision		Revision as of 14:26, 26 January 2011
Line 16:		Line 16:
	Take these produced files along with all the latest screens and place then into a clean directory.		Take these produced files along with all the latest screens and place then into a clean directory.
	Use the existing Inno Setup installer file to build the installer.		Use the existing Inno Setup installer file to build the installer.

			[[Category:Vision Overview]]
			[[Category:Vision Coding and Release]]