Component database - Revision history

Markus Friedrich: /* Where is the component data base located on my computer? */

2021-07-26T09:17:21Z

Where is the component data base located on my computer?

← Older revision		Revision as of 11:17, 26 July 2021
Line 27:		Line 27:
	If some folders in your Windows explorer are hidden, please set your Windows the way that you can <span class="plainlinks">[http://www.google.de/#q=hidden+folders see all folders and all file extensions]</span>. You can place the component data base file to any folder you like, you only need to point TARGET there. Please see TARGET menu "Settings/Settings(INI file)". Also network drives with UNC names can be created, e.g. '''\\server\target3001\database'''. If several users want to use the data base simultaneously it is recommended to use a [[MySQL]]-Server .<br><br>		If some folders in your Windows explorer are hidden, please set your Windows the way that you can <span class="plainlinks">[http://www.google.de/#q=hidden+folders see all folders and all file extensions]</span>. You can place the component data base file to any folder you like, you only need to point TARGET there. Please see TARGET menu "Settings/Settings(INI file)". Also network drives with UNC names can be created, e.g. '''\\server\target3001\database'''. If several users want to use the data base simultaneously it is recommended to use a [[MySQL]]-Server .<br><br>

	"In my version V30 the data base path points to V19!" No problem at all. Do a free data base update to get all current parts. ~~All~~ USER parts remain untouched.		"In my version V30 the data base path points to V19!"
			No problem at all. Do a free data base update to get all current parts. So you are up to date while all USER parts remain untouched.
	<br>		<br>

Markus Friedrich: /* Where is the component data base located on my computer? */

2021-07-26T09:15:49Z

Where is the component data base located on my computer?

← Older revision		Revision as of 11:15, 26 July 2021
Line 17:		Line 17:
	After you have installed TARGET 3001! please have a look here to find it:		After you have installed TARGET 3001! please have a look here to find it:
	<br><br>[[Image: databasepath_e.jpg\|750px]]<br>Image: How to find the location of your component data base. "Markus" that is me as a user. Your ''user'' sure will be different.<br><br>		<br><br>[[Image: databasepath_e.jpg\|750px]]<br>Image: How to find the location of your component data base. "Markus" that is me as a user. Your ''user'' sure will be different.<br><br>
	Using Windows Vista und Windows 7 / 8 you will find it here:<br>		Using Windows Vista und Windows 7/8/10 you will find it here:<br>
	'''C:\Users\[username]\AppData\Roaming\ibf\TarVn\[edition]\Database'''<br><br>		'''C:\Users\[username]\AppData\Roaming\ibf\TarVn\[edition]\Database'''<br><br>

Line 23:		Line 23:
	'''C:\Documents and Settings\[username]\Application data\ibf\TarVn\[edition]\Database'''<br><br>		'''C:\Documents and Settings\[username]\Application data\ibf\TarVn\[edition]\Database'''<br><br>

	Exchange [username] by your individual user name or by '''All Users''' (using WinXP) or '''Public'''. Exchange [edition] by the name of your edition, e.g.. professional or discover. The n in TarVn means ~~Your~~ current main version number, e.g. ''18''<br>		Exchange [username] by your individual user name or by '''All Users''' (using WinXP) or '''Public'''. Exchange [edition] by the name of your edition, e.g.. professional or discover. The n in TarVn means your current main version number, e.g. ''30''<br>

	If some folders in your Windows explorer are hidden, please set your Windows the way that you can <span class="plainlinks">[http://www.google.de/#q=hidden+folders see all folders and all file extensions]</span>. You can place the component data base file to any folder you like, you only need to point TARGET there. Please see TARGET menu "Settings/Settings(INI file)". Also network drives with UNC names can be created, e.g. '''\\server\target3001\database'''. If several users want to use the data base simultaneously it is recommended to use a [[MySQL]]-Server .<br><br>		If some folders in your Windows explorer are hidden, please set your Windows the way that you can <span class="plainlinks">[http://www.google.de/#q=hidden+folders see all folders and all file extensions]</span>. You can place the component data base file to any folder you like, you only need to point TARGET there. Please see TARGET menu "Settings/Settings(INI file)". Also network drives with UNC names can be created, e.g. '''\\server\target3001\database'''. If several users want to use the data base simultaneously it is recommended to use a [[MySQL]]-Server .<br><br>

			"In my version V30 the data base path points to V19!" No problem at all. Do a free data base update to get all current parts. All USER parts remain untouched.
			<br>

	You can also use a directory in [https://en.wikipedia.org/wiki/Dropbox_(service) DropBox], [https://en.wikipedia.org/wiki/Microsoft_OneDrive OneDrive] or [https://en.wikipedia.org/wiki/Google_Drive Google Drive] to keep the SQLite database synchronised everywhere.<br><br>		You can also use a directory in [https://en.wikipedia.org/wiki/Dropbox_(service) DropBox], [https://en.wikipedia.org/wiki/Microsoft_OneDrive OneDrive] or [https://en.wikipedia.org/wiki/Google_Drive Google Drive] to keep the SQLite database synchronised everywhere.<br><br>

Markus Friedrich: /* Two-user situation with two local SQLite component databases */

2020-10-29T08:27:32Z

Two-user situation with two local SQLite component databases

← Older revision		Revision as of 10:27, 29 October 2020
Line 193:		Line 193:
	[[Image: cronjob.jpg]]<br>'''Image 2:''' Two-user situation with local SQLite component databases<br><br>		[[Image: cronjob.jpg]]<br>'''Image 2:''' Two-user situation with local SQLite component databases<br><br>

	If only Chris creates components working with a SQLite setup can continue. A ~~Cron job~~ could copy the data base file from Chris to Robin after each change. Then no MySQL server would be necessary.		If only Chris creates components working with a SQLite setup can continue. A CRON-Job could copy the data base file from Chris to Robin after each change. Then no MySQL server would be necessary.

	<br><br>		<br><br>

Markus Friedrich at 08:08, 29 October 2020

2020-10-29T08:08:09Z

← Older revision		Revision as of 10:08, 29 October 2020
Line 191:		Line 191:
	== Two-user situation with two local SQLite component databases ==		== Two-user situation with two local SQLite component databases ==

	[[Image: cronjob.jpg~~\|none~~]]'''Image 2''': Two-user situation with local SQLite component databases<br><br>		[[Image: cronjob.jpg]]<br>'''Image 2:''' Two-user situation with local SQLite component databases<br><br>

	If only Chris creates components working with a SQLite setup can continue. A Cron job could copy the data base file from Chris to Robin after each change. Then no MySQL server would be necessary.		If only Chris creates components working with a SQLite setup can continue. A Cron job could copy the data base file from Chris to Robin after each change. Then no MySQL server would be necessary.

Markus Friedrich: /* Two-user situation with two local SQLite component databases */

2020-10-29T08:05:35Z

Two-user situation with two local SQLite component databases

← Older revision		Revision as of 10:05, 29 October 2020
Line 191:		Line 191:
	== Two-user situation with two local SQLite component databases ==		== Two-user situation with two local SQLite component databases ==

	[[Image: cronjob.jpg]]~~<br>~~ Image 2: Two-user situation with local SQLite component databases<br><br>		[[Image: cronjob.jpg\|none]]'''Image 2''': Two-user situation with local SQLite component databases<br><br>
	If only Chris creates components working with a SQLite setup can continue. A Cron job could copy the data base file from Chris to Robin after each change. Then no MySQL server would be necessary.		If only Chris creates components working with a SQLite setup can continue. A Cron job could copy the data base file from Chris to Robin after each change. Then no MySQL server would be necessary.

Markus Friedrich: /* Two-user situation with two local SQLite component databases */

2020-10-29T08:04:12Z

Two-user situation with two local SQLite component databases

← Older revision		Revision as of 10:04, 29 October 2020
Line 191:		Line 191:
	== Two-user situation with two local SQLite component databases ==		== Two-user situation with two local SQLite component databases ==

	[[Image: cronjob.jpg]]<br> Image 2: Two-user situation with local SQLite component databases		[[Image: cronjob.jpg]]<br> Image 2: Two-user situation with local SQLite component databases<br><br>
	If only ~~one of the two employees~~ creates components~~, for example Chris,~~ working with a SQLite setup can continue . ~~To do this, a~~ Cron job could copy the file from ~~one colleague~~ to ~~the other~~ after each change. Then no MySQL server would be necessary.		If only Chris creates components working with a SQLite setup can continue. A Cron job could copy the data base file from Chris to Robin after each change. Then no MySQL server would be necessary.

	<br><br>		<br><br>


	== Network with access to one central [[MySQL]] client-server data base ==		== Network with access to one central [[MySQL]] client-server data base ==

Markus Friedrich: /* Network situations with the TARGET 3001! database */

2020-10-29T07:59:42Z

Network situations with the TARGET 3001! database

← Older revision		Revision as of 09:59, 29 October 2020
Line 171:		Line 171:
	[[The structure of the TARGET 3001! database\|The structure of the TARGET 3001! database]]<br><br>		[[The structure of the TARGET 3001! database\|The structure of the TARGET 3001! database]]<br><br>


			== Single user situation with local SQLite component data base ==

	[[Image: Server1_e.png]]<br>'''Image 1:''' Single user situation with local SQLite component data base<br>		[[Image: Server1_e.png]]<br>'''Image 1:''' Single user situation with local SQLite component data base<br>
Line 187:		Line 189:


	[[Image: Server2_e.png]]<br>'''Image 2:''' Network with access to one central [[MySQL]] client-server data base<br>		== Two-user situation with two local SQLite component databases ==

			[[Image: cronjob.jpg]]<br> Image 2: Two-user situation with local SQLite component databases
			If only one of the two employees creates components, for example Chris, working with a SQLite setup can continue . To do this, a Cron job could copy the file from one colleague to the other after each change. Then no MySQL server would be necessary.

			<br><br>


			== Network with access to one central [[MySQL]] client-server data base ==

			[[Image: Server2_e.png]]<br>'''Image 3:''' Network with access to one central [[MySQL]] client-server data base<br>
	<br>		<br>
	* the expert solution for the administration of huge amounts of data		* the expert solution for the administration of huge amounts of data
Line 194:		Line 206:
	* open and well proven data base technology		* open and well proven data base technology



			== Client-Server-Network giving access to one central data base ==

	[[Image: Server3.png\|750px\|TARGET 3001! on a server]]<br>'''Image 3:''' Client-Server-Network giving access to one central data base. There is oportunity to install a mirror of the [[MySQL]] database on an external computer (Michael) to run it SQLite and bring it back.<br>		[[Image: Server3.png\|750px\|TARGET 3001! on a server]]<br>'''Image 4:''' Client-Server-Network giving access to one central data base. There is oportunity to install a mirror of the [[MySQL]] database on an external computer (Michael) to run it SQLite and bring it back.<br>
	<br>		<br>

Markus Friedrich: /* Where is the component data base located on my computer? */

2020-09-08T08:17:11Z

Where is the component data base located on my computer?

← Older revision		Revision as of 10:17, 8 September 2020
Line 28:		Line 28:

	You can also use a directory in [https://en.wikipedia.org/wiki/Dropbox_(service) DropBox], [https://en.wikipedia.org/wiki/Microsoft_OneDrive OneDrive] or [https://en.wikipedia.org/wiki/Google_Drive Google Drive] to keep the SQLite database synchronised everywhere.<br><br>		You can also use a directory in [https://en.wikipedia.org/wiki/Dropbox_(service) DropBox], [https://en.wikipedia.org/wiki/Microsoft_OneDrive OneDrive] or [https://en.wikipedia.org/wiki/Google_Drive Google Drive] to keep the SQLite database synchronised everywhere.<br><br>



	<small>Alias: where is the data base? Directory of the data base folder of the data base data base folder path to the data base</small><br><br>		<small>Alias: where is the data base? Directory of the data base folder of the data base data base folder path to the data base</small><br><br>

Markus Friedrich: /* Where is the component data base located on my computer? */

2020-09-08T08:16:20Z

Where is the component data base located on my computer?

← Older revision		Revision as of 10:16, 8 September 2020
Line 27:		Line 27:
	If some folders in your Windows explorer are hidden, please set your Windows the way that you can <span class="plainlinks">[http://www.google.de/#q=hidden+folders see all folders and all file extensions]</span>. You can place the component data base file to any folder you like, you only need to point TARGET there. Please see TARGET menu "Settings/Settings(INI file)". Also network drives with UNC names can be created, e.g. '''\\server\target3001\database'''. If several users want to use the data base simultaneously it is recommended to use a [[MySQL]]-Server .<br><br>		If some folders in your Windows explorer are hidden, please set your Windows the way that you can <span class="plainlinks">[http://www.google.de/#q=hidden+folders see all folders and all file extensions]</span>. You can place the component data base file to any folder you like, you only need to point TARGET there. Please see TARGET menu "Settings/Settings(INI file)". Also network drives with UNC names can be created, e.g. '''\\server\target3001\database'''. If several users want to use the data base simultaneously it is recommended to use a [[MySQL]]-Server .<br><br>

	You can also use a directory in [https://en.wikipedia.org/wiki/~~Dropbox~~ DropBox], [https://en.wikipedia.org/wiki/Microsoft_OneDrive OneDrive] or [https://en.wikipedia.org/wiki/Google_Drive Google Drive] to keep the SQLite database synchronised everywhere.<br><br>		You can also use a directory in [https://en.wikipedia.org/wiki/Dropbox_(service) DropBox], [https://en.wikipedia.org/wiki/Microsoft_OneDrive OneDrive] or [https://en.wikipedia.org/wiki/Google_Drive Google Drive] to keep the SQLite database synchronised everywhere.<br><br>

Markus Friedrich: /* Where is the component data base located on my computer? */

2020-09-08T08:15:16Z

Where is the component data base located on my computer?

← Older revision		Revision as of 10:15, 8 September 2020
Line 26:		Line 26:

	If some folders in your Windows explorer are hidden, please set your Windows the way that you can <span class="plainlinks">[http://www.google.de/#q=hidden+folders see all folders and all file extensions]</span>. You can place the component data base file to any folder you like, you only need to point TARGET there. Please see TARGET menu "Settings/Settings(INI file)". Also network drives with UNC names can be created, e.g. '''\\server\target3001\database'''. If several users want to use the data base simultaneously it is recommended to use a [[MySQL]]-Server .<br><br>		If some folders in your Windows explorer are hidden, please set your Windows the way that you can <span class="plainlinks">[http://www.google.de/#q=hidden+folders see all folders and all file extensions]</span>. You can place the component data base file to any folder you like, you only need to point TARGET there. Please see TARGET menu "Settings/Settings(INI file)". Also network drives with UNC names can be created, e.g. '''\\server\target3001\database'''. If several users want to use the data base simultaneously it is recommended to use a [[MySQL]]-Server .<br><br>

			You can also use a directory in [https://en.wikipedia.org/wiki/Dropbox DropBox], [https://en.wikipedia.org/wiki/Microsoft_OneDrive OneDrive] or [https://en.wikipedia.org/wiki/Google_Drive Google Drive] to keep the SQLite database synchronised everywhere.<br><br>



	<small>Alias: where is the data base? Directory of the data base folder of the data base data base folder path to the data base</small><br><br>		<small>Alias: where is the data base? Directory of the data base folder of the data base data base folder path to the data base</small><br><br>