<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://theoracle.magentaretail.com.au/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Bevan</id>
	<title>EnablerWiki - User contributions [en]</title>
	<link rel="self" type="application/atom+xml" href="https://theoracle.magentaretail.com.au/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Bevan"/>
	<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/Special:Contributions/Bevan"/>
	<updated>2026-10-22T01:10:21Z</updated>
	<subtitle>User contributions</subtitle>
	<generator>MediaWiki 1.46.2</generator>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=MediaWiki:Sidebar&amp;diff=1648</id>
		<title>MediaWiki:Sidebar</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=MediaWiki:Sidebar&amp;diff=1648"/>
		<updated>2026-10-21T08:11:20Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;* navigation&lt;br /&gt;
** mainpage|mainpage-description&lt;br /&gt;
** portal-url|portal&lt;br /&gt;
** currentevents-url|currentevents&lt;br /&gt;
** recentchanges-url|recentchanges&lt;br /&gt;
** randompage-url|randompage&lt;br /&gt;
** specialpages-url|specialpages&lt;br /&gt;
** helppage|help&lt;br /&gt;
* SEARCH&lt;br /&gt;
* TOOLBOX&lt;br /&gt;
* LANGUAGES&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=EEE_WebService&amp;diff=1619</id>
		<title>EEE WebService</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=EEE_WebService&amp;diff=1619"/>
		<updated>2021-04-07T04:21:42Z</updated>

		<summary type="html">&lt;p&gt;Bevan: /* EEE WebService */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 05 July 2012.  Last Reviewed: 24 January 2018&lt;br /&gt;
&lt;br /&gt;
===EEE WebService===&lt;br /&gt;
&lt;br /&gt;
EEE provides an interface to allow website developers to retrieve data from EEE for publishing on a website, and also allow changes recorded on a website to be updated back to EEE. This would allow actions such as a customer calling up their account on a website and updating their contact information. The changes made on the website would then flow back to EEE.&lt;br /&gt;
&lt;br /&gt;
Before this interface can be used, a licensed plugin is required from Magenta Retail. Further information on obtaining this license can be obtained by contacting our helpdesk on support@magentaretail.com.au&lt;br /&gt;
&lt;br /&gt;
Once you have obtained the license plugin, this license needs to be retrieved in EEE from Utilities-&amp;gt;Configuration-&amp;gt;Configuration Settings-&amp;gt;Licensed Plugins tab.&lt;br /&gt;
&lt;br /&gt;
Magenta Retail provide EEE Web Service documentation which can be viewed from here:&lt;br /&gt;
&lt;br /&gt;
[https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/EEEWebService.htm EEE Web Service Documentation]&lt;br /&gt;
&lt;br /&gt;
or downloaded as a PDF from here:-&lt;br /&gt;
&lt;br /&gt;
[https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/EEE_WebService.PDF EEE Web Service Documentation]&lt;br /&gt;
&lt;br /&gt;
Recommendations / Processes&lt;br /&gt;
&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/WebServiceIntegrationRecommendationDiagram.pdf Integration Recommendations]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/GiftCardsOrderFulfilledAtWebsiteScenarios.pdf Gift Cards Scenarios - Order Fulfilled at Website]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/GiftCardsOrderFulfilledInEEEScenarios.pdf EEE Gift Cards Scenarios - Order Fulfilled at EEE]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/GiftCardsSalesNotSentScenarios.pdf EEE Gift Cards Scenarios - Sales Not Sent to EEE]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/8/85/EEE_Customer_Communications_-_Email_Click_and_Open_link_tracking.pdf EEE Email Click and Open link tracking Recommendations]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/c/cf/EEE_Customer_Communications_-_Email_Verification_Process.pdf EEE Email Verification Process]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/b/b5/EEE_Customer_Communications.pdf EEE Customer Communications]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/E-Commerce_Integration_Scenarios.pdf E-Commerce Integration Scenarios]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Example XML and XSD files and PHP code can be downloaded using the links below&lt;br /&gt;
&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/Xsd.zip XSD files]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/XmlSample.zip XML Sample files]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/PhpSample.zip PHP sample code]&lt;br /&gt;
&lt;br /&gt;
== See Also: ==&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=EEE_WebService&amp;diff=1618</id>
		<title>EEE WebService</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=EEE_WebService&amp;diff=1618"/>
		<updated>2021-04-07T04:20:44Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 05 July 2012.  Last Reviewed: 24 January 2018&lt;br /&gt;
&lt;br /&gt;
===EEE WebService===&lt;br /&gt;
&lt;br /&gt;
EEE provides an interface to allow website developers to retrieve data from EEE for publishing on a website, and also allow changes recorded on a website to be updated back to EEE. This would allow actions such as a customer calling up their account on a website and updating their contact information. The changes made on the website would then flow back to EEE.&lt;br /&gt;
&lt;br /&gt;
Before this interface can be used, a licensed plugin is required from Magenta Retail. Further information on obtaining this license can be obtained by contacting our helpdesk on support@magentaretail.com.au&lt;br /&gt;
&lt;br /&gt;
Once you have obtained the license plugin, this license needs to be retrieved in EEE from Utilities-&amp;gt;Configuration-&amp;gt;Configuration Settings-&amp;gt;Licensed Plugins tab.&lt;br /&gt;
&lt;br /&gt;
Magenta Retail provide EEE Web Service documentation which can be viewed from here:&lt;br /&gt;
&lt;br /&gt;
[http://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/EEEWebService.htm EEE Web Service Documentation]&lt;br /&gt;
&lt;br /&gt;
or downloaded as a PDF from here:-&lt;br /&gt;
&lt;br /&gt;
[http://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/EEE_WebService.PDF EEE Web Service Documentation]&lt;br /&gt;
&lt;br /&gt;
Recommendations / Processes&lt;br /&gt;
&lt;br /&gt;
* [http://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/WebServiceIntegrationRecommendationDiagram.pdf Integration Recommendations]&lt;br /&gt;
* [http://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/GiftCardsOrderFulfilledAtWebsiteScenarios.pdf Gift Cards Scenarios - Order Fulfilled at Website]&lt;br /&gt;
* [http://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/GiftCardsOrderFulfilledInEEEScenarios.pdf EEE Gift Cards Scenarios - Order Fulfilled at EEE]&lt;br /&gt;
* [http://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/GiftCardsSalesNotSentScenarios.pdf EEE Gift Cards Scenarios - Sales Not Sent to EEE]&lt;br /&gt;
* [http://theoracle.magentaretail.com.au/images/8/85/EEE_Customer_Communications_-_Email_Click_and_Open_link_tracking.pdf EEE Email Click and Open link tracking Recommendations]&lt;br /&gt;
* [http://theoracle.magentaretail.com.au/images/c/cf/EEE_Customer_Communications_-_Email_Verification_Process.pdf EEE Email Verification Process]&lt;br /&gt;
* [http://theoracle.magentaretail.com.au/images/b/b5/EEE_Customer_Communications.pdf EEE Customer Communications]&lt;br /&gt;
* [http://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/E-Commerce_Integration_Scenarios.pdf E-Commerce Integration Scenarios]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Example XML and XSD files and PHP code can be downloaded using the links below&lt;br /&gt;
&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/Xsd.zip XSD files]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/XmlSample.zip XML Sample files]&lt;br /&gt;
* [https://theoracle.magentaretail.com.au/images/EEEWebServiceDocumentation/PhpSample.zip PHP sample code]&lt;br /&gt;
&lt;br /&gt;
== See Also: ==&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Recover_HostLog_TranIDs&amp;diff=1395</id>
		<title>Recover HostLog TranIDs</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Recover_HostLog_TranIDs&amp;diff=1395"/>
		<updated>2015-09-09T05:40:29Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 30 October 2013.  Last Reviewed:  09 September 2015.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Under some circumstances, it might become necessary to recover POS HostLog data processed via the EEE HostLogExportStaging tables if the original data was missing TranIDs.  This could arise if a store server was mis-configured to not generate TranIds for a period of time and the ERP receiving data from HostLogExportStaging is dependent upon TranIds (this includes EEE .HOS file exporter if configured to use TranID validation).&lt;br /&gt;
&lt;br /&gt;
Should the need arise to recover POS HostLog data processed via the EEE HostLogExportStaging tables a stored procedure exists in EEE to assist. &lt;br /&gt;
&lt;br /&gt;
The parameters are as follows:&lt;br /&gt;
&lt;br /&gt;
 @branch TBranchCode&lt;br /&gt;
 @datefrom datetime&lt;br /&gt;
 @dateto datetime&lt;br /&gt;
 @bRegenTranIdsOnly bit&lt;br /&gt;
 @CopyBackToHostLogExportStaging bit&lt;br /&gt;
&lt;br /&gt;
You can execute the following to preview changes:&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 0&lt;br /&gt;
&lt;br /&gt;
and to actually recover the data:&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 1&lt;br /&gt;
&lt;br /&gt;
or better:&lt;br /&gt;
 select * from HostLogExportStaging&lt;br /&gt;
 begin tran&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 1&lt;br /&gt;
 select * from HostLogExportStaging&lt;br /&gt;
 rollback OR commit as appropriate&lt;br /&gt;
&lt;br /&gt;
This proc should take care of recovering TranIds for SH and related records only - as well as miscellaneous / stand alone record types TS, VR, DS, BS, TV.  It deliberately excludes EV, VI, HB as no likely ERP interface implementation would require these record types.  There are other unhandled, miscellaneous record types - hence the preview mode which will reveal if there are other records with unrecovered TranIDs - case by case assessment would be necessary to determine if further steps are required to recover extra record types not handled by this procedure.&lt;br /&gt;
&lt;br /&gt;
Multi-row transactions such as goods receipts and transfers are unhandled - the TranIDs for these are created by EEE not POS so should not need recovery in the same way.  However should the need arise, Magenta could extend this procedure to handle these using the same concepts as SH sale transactions.&lt;br /&gt;
&lt;br /&gt;
UPDATE:  As of EEE version 1.76 SR-9 support for GH, XH, TH records and their children has been added.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Main_Page&amp;diff=1391</id>
		<title>Main Page</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Main_Page&amp;diff=1391"/>
		<updated>2015-06-02T04:18:58Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[File:Magenta_Retail_Logo_White.png]]&lt;br /&gt;
&lt;br /&gt;
===Welcome to Magenta Retail&#039;s EEE and Enabler Wiki===&lt;br /&gt;
&lt;br /&gt;
Enter the topic you would like to search for in the seach box to the left and please enjoy our Wiki!&lt;br /&gt;
&lt;br /&gt;
* To see all articles on our WIKI [[Special:AllPages|please click here]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Manuals and Technical documentation for both Enabler and EEE are available on our website. &lt;br /&gt;
&lt;br /&gt;
As the website links to our FTP site, you must be a client of Magenta Retail with an FTP usercode and password &lt;br /&gt;
to be able to access this documentation.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
* Magenta Technical Documentation [http://www.magentaretail.com.au/documents.php Please click here]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
If you would like to submit a suggestion for an article to be added to the WIKI, please use this email link [mailto:support@magentaretail.com.au?Subject=WIKI%20Suggestion Suggestion:]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===[http://www.magentaretail.com.au/CloseEnablerHelp.html Close Enabler Help]===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Other Links ==&lt;br /&gt;
&lt;br /&gt;
* Magenta&#039;s Web site [http://www.magentaretail.com.au www.magentaretail.com.au]&lt;br /&gt;
* Magenta&#039;s FTP site [ftp://ftp.magentaretail.com.au Please click here]&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Main_Page&amp;diff=1389</id>
		<title>Main Page</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Main_Page&amp;diff=1389"/>
		<updated>2015-06-02T03:56:03Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[File:Magenta_Retail_Logo_White.png]]&lt;br /&gt;
&lt;br /&gt;
===Welcome to Magenta Retail&#039;s EEE and Enabler Wiki===&lt;br /&gt;
&lt;br /&gt;
Enter the topic you would like to search for in the seach box to the left and please enjoy our Wiki!&lt;br /&gt;
&lt;br /&gt;
* To see all articles on our WIKI [[Special:AllPages|please click here]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Manuals and Technical documentation for both Enabler and EEE are available on our website. &lt;br /&gt;
&lt;br /&gt;
As the website links to our FTP site, you must be a client of Magenta Retail with an FTP usercode and password &lt;br /&gt;
to be able to access this documentation.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
* Magenta Technical Documentation [http://www.magentaretail.com.au/documents.php Please click here]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
If you would like to submit a suggestion for an article to be added to the WIKI, please use this email link [mailto:support@magentaretail.com.au?Subject=WIKI%20Suggestion Suggestion:]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Other Links ==&lt;br /&gt;
&lt;br /&gt;
* Magenta&#039;s Web site [http://www.magentaretail.com.au www.magentaretail.com.au]&lt;br /&gt;
* Magenta&#039;s FTP site [ftp://ftp.magentaretail.com.au Please click here]&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Main_Page&amp;diff=1388</id>
		<title>Main Page</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Main_Page&amp;diff=1388"/>
		<updated>2015-06-02T03:55:20Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[File:Magenta_Retail_Logo_White.png]]&lt;br /&gt;
&lt;br /&gt;
===Welcome to Magenta Retail&#039;s EEE and Enabler Wiki===&lt;br /&gt;
&lt;br /&gt;
Enter the topic you would like to search for in the seach box to the left and please enjoy our Wiki!&lt;br /&gt;
&lt;br /&gt;
* To see all articles on our WIKI [[Special:AllPages|please click here]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Manuals and Technical documentation for both Enabler and EEE are available on our website. &lt;br /&gt;
&lt;br /&gt;
As the website links to our FTP site, you must be a client of Magenta Retail with an FTP usercode and password &lt;br /&gt;
to be able to access this documentation.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
* Magenta Technical Documentation [http://www.magentaretail.com.au/documents.php Please click here]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
If you would like to submit a suggestion for an article to be added to the WIKI, please use this email link [mailto:support@magentaretail.com.au?Subject=WIKI%20Suggestion Suggestion:]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
[http://www.magentaretail.com.au/CloseEnablerHelp.html Close From Enabler Help]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Other Links ==&lt;br /&gt;
&lt;br /&gt;
* Magenta&#039;s Web site [http://www.magentaretail.com.au www.magentaretail.com.au]&lt;br /&gt;
* Magenta&#039;s FTP site [ftp://ftp.magentaretail.com.au Please click here]&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Enabler_EEE_Docket_Printing&amp;diff=1385</id>
		<title>Enabler EEE Docket Printing</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Enabler_EEE_Docket_Printing&amp;diff=1385"/>
		<updated>2015-04-20T03:19:56Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 20 April 2015. Last Reviewed: 20 April 2015&lt;br /&gt;
&lt;br /&gt;
EEE can print transactions dockets such as inter-store transfer slips, goods receipts etc to Enabler POS receipt printers so long as the POS receipt printer uses a Windows print queue (not OPOS).  The Windows print queue must be shared on the POS till and EEE must have access to print to that shared print queue.  In practice this means the EEE services service account must have access to the print queue.  This can be achieved on a domain, or by creating a local Windows account with the same credentials as the EEE services account.  It may also be possible by using the Windows credential cache on the EEE server or granting guest or everyone access to the print queue.  The most appropriate means of granting access will depend upon a number of factors including the Domain/Workgroup environment, Windows versions and individual preferences re security levels of print queues.&lt;br /&gt;
&lt;br /&gt;
== Integrated Logins ==&lt;br /&gt;
&lt;br /&gt;
When Enabler creates an integrated login to EEE to perform an inventory transaction such as inter-store transfers, Enabler passes in the &#039;&#039;share name&#039;&#039; of its receipt printer (Enabler uses the Windows print queue configuration to retrieve the share name and passes this to EEE).  Enabler also passes to EEE command strings for enlarged print, receipt cut and so forth.  EEE then simply writes its receipt text including formatting strings to the print queue share name passed in by Enabler.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Non-Integrated Logins ==&lt;br /&gt;
&lt;br /&gt;
For non-integrated logins it is more complicated.  If at head office, EEE will send its output to the receipt printer configured for the till code specified for head office printing in the general tab of configuration settings.  The Enabler configuration setting for the print queue will need to be specified in \\computer\print-share-name format.&lt;br /&gt;
&lt;br /&gt;
For all other branches, if EEE can find a single till that has a receipt printer with the print queue configured in \\computer\print-share-name format it will send the print job to that queue.  Otherwise EEE will display a popup prompt to the user to select a printer - the popup will list all &#039;&#039;receipt&#039;&#039; printers from the branch printer queue table as well as all tills found with an enabled receipt printer where the receipt printer queue name is specified in \\computer\print-share-name format.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Enabler_EEE_Docket_Printing&amp;diff=1384</id>
		<title>Enabler EEE Docket Printing</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Enabler_EEE_Docket_Printing&amp;diff=1384"/>
		<updated>2015-04-20T03:18:59Z</updated>

		<summary type="html">&lt;p&gt;Bevan: Summary of how EEE prints IBT and other dockets to Enabler receipt printers.&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 20 April 2015. Last Reviewed: 20 April 2015&lt;br /&gt;
&lt;br /&gt;
EEE can print transactions dockets such as inter-store transfer slips, goods receipts etc to Enabler POS receipt printers so long as the POS receipt printer uses a Windows print queue (not OPOS).  The Windows print queue must be shared on the POS till and EEE must have access to print to that shared print queue.  In practice this means the EEE services service account must have access to the print queue.  This can be achieved on a domain, or by creating a local Windows account with the same credentials as the EEE services account.  It may also be possible by using the Windows credential cache on the EEE server or granting guest or everyone access to the print queue.  The most appropriate means of granting access will depend upon a number of factors including the Domain/Workgroup environment, Windows versions and individual preferences re security levels of print queues.&lt;br /&gt;
&lt;br /&gt;
When Enabler creates an integrated login to EEE to perform an inventory transaction such as inter-store transfers, Enabler passes in the &#039;&#039;share name&#039;&#039; of its receipt printer (Enabler uses the Windows print queue configuration to retrieve the share name and passes this to EEE).  Enabler also passes to EEE command strings for enlarged print, receipt cut and so forth.  EEE then simply writes its receipt text including formatting strings to the print queue share name passed in by Enabler.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Non-Integrated Logins ==&lt;br /&gt;
&lt;br /&gt;
For non-integrated logins it is more complicated.  If at head office, EEE will send its output to the receipt printer configured for the till code specified for head office printing in the general tab of configuration settings.  The Enabler configuration setting for the print queue will need to be specified in \\computer\print-share-name format.&lt;br /&gt;
&lt;br /&gt;
For all other branches, if EEE can find a single till that has a receipt printer with the print queue configured in \\computer\print-share-name format it will send the print job to that queue.  Otherwise EEE will display a popup prompt to the user to select a printer - the popup will list all &#039;&#039;receipt&#039;&#039; printers from the branch printer queue table as well as all tills found with an enabled receipt printer where the receipt printer queue name is specified in \\computer\print-share-name format.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Recover_HostLog_TranIDs&amp;diff=1344</id>
		<title>Recover HostLog TranIDs</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Recover_HostLog_TranIDs&amp;diff=1344"/>
		<updated>2013-10-29T23:18:45Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 30 October 2013.  Last Reviewed:  30 October 2013.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Under some circumstances, it might become necessary to recover POS HostLog data processed via the EEE HostLogExportStaging tables if the original data was missing TranIDs.  This could arise if a store server was mis-configured to not generate TranIds for a period of time and the ERP receiving data from HostLogExportStaging is dependent upon TranIds (this includes EEE .HOS file exporter if configured to use TranID validation).&lt;br /&gt;
&lt;br /&gt;
Should the need arise to recover POS HostLog data processed via the EEE HostLogExportStaging tables a stored procedure exists in EEE to assist.&lt;br /&gt;
&lt;br /&gt;
 create procedure usp_RecoverHostLog @branch TBranchCode, @datefrom datetime, @dateto datetime, @bRegenTranIdsOnly bit, @CopyBackToHostLogExportStaging bit as&lt;br /&gt;
&lt;br /&gt;
You can execute thus to preview:&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 0&lt;br /&gt;
&lt;br /&gt;
and thus to actually recover the data:&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 1&lt;br /&gt;
&lt;br /&gt;
or better:&lt;br /&gt;
 select * from HostLogExportStaging&lt;br /&gt;
 begin tran&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 1&lt;br /&gt;
 select * from HostLogExportStaging&lt;br /&gt;
 rollback OR commit as appropriate&lt;br /&gt;
&lt;br /&gt;
This proc should take care of recovering TranIds for SH and related records only - as well as miscellaneous / stand alone record types TS, VR, DS, BS, TV.  It deliberately excludes EV, VI, HB as no likely ERP interface implementation would require these record types.  There are other unhandled, miscellaneous record types - hence the preview mode which will reveal if there are other records with unrecovered TranIDs - case by case assessment would be necessary to determine if further steps are required to recover extra record types not handled by this procedure.&lt;br /&gt;
&lt;br /&gt;
Multi-row transactions such as goods receipts and transfers are unhandled - the TranIDs for these are created by EEE not POS so should not need recovery in the same way.  However should the need arise, Magenta could extend this procedure to handle these using the same concepts as SH sale transactions.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Recover_HostLog_TranIDs&amp;diff=1343</id>
		<title>Recover HostLog TranIDs</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Recover_HostLog_TranIDs&amp;diff=1343"/>
		<updated>2013-10-29T23:16:59Z</updated>

		<summary type="html">&lt;p&gt;Bevan: Created page with &amp;quot;Created: 30 October 2013.  Last Reviewed:  30 October 2013.   Under some circumstances, it might become necessary to recover POS HostLog data processed via the EEE HostLogExportS...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 30 October 2013.  Last Reviewed:  30 October 2013.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Under some circumstances, it might become necessary to recover POS HostLog data processed via the EEE HostLogExportStaging tables if the original data was missing TranIDs.  This could arise if a store server was mis-configured to not generate TranIds for a period of time and the ERP receiving data from HostLogExportStaging is dependent upon TranIds (this includes EEE .HOS file exporter if configured to use TranID validation).&lt;br /&gt;
&lt;br /&gt;
Should the need arise to recover POS HostLog data processed via the EEE HostLogExportStaging tables a stored procedure exists in EEE to assist.&lt;br /&gt;
&lt;br /&gt;
 create procedure usp_RecoverHostLog @branch TBranchCode, @datefrom datetime, @dateto datetime, @bRegenTranIdsOnly bit, @CopyBackToHostLogExportStaging bit as&lt;br /&gt;
&lt;br /&gt;
You can execute thus to preview:&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 0&lt;br /&gt;
&lt;br /&gt;
and thus to actually recover the data:&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 1&lt;br /&gt;
&lt;br /&gt;
or better:&lt;br /&gt;
 select * from HostLogExportStaging&lt;br /&gt;
 begin tran&lt;br /&gt;
 exec usp_RecoverHostLog &#039;723&#039;, &#039;20131024&#039;, &#039;20131024&#039;, 1, 1&lt;br /&gt;
 select * from HostLogExportStaging&lt;br /&gt;
 rollback OR commit as appropriate&lt;br /&gt;
&lt;br /&gt;
This proc should take care of recovering TranIds for SH and related records only - as well as miscellaneous / stand alone record types TS, VR, DS, BS, TV.  It deliberately excludes EV, VI, HB as no likely ERP interface implementation would require these record types.  There are other unhandled, miscellaneous record types - hence the preview mode which will reveal if records with unrecovered TranIDs - case by case assessment would be necessary to determine if further steps are required to recovery extra record types not handled by this procedure.&lt;br /&gt;
&lt;br /&gt;
Multi-row transactions such as goods receipts and transfers are unhandled - the TranIDs for these are created by EEE not POS so should not need recovery in the same way.  However should the need arise, Magenta could extend this procedure to handle these using the same concepts as SH sale transactions.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1271</id>
		<title>POS Auto Relicense</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1271"/>
		<updated>2012-06-17T23:54:26Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 18 June 2012. Last Reviewed: 18 June 2012&lt;br /&gt;
&lt;br /&gt;
Enabler and EEPOS require a licence key to operate.  Licence keys expire from time to time, usually after 12 months.  When POS detects that it is within one month of its licence expiration date, POS can automatically relicense itself via the Magenta licensing server.  &lt;br /&gt;
&lt;br /&gt;
== Configuration ==&lt;br /&gt;
Some simple configuration is required.  You must enter:&lt;br /&gt;
# Magenta&#039;s relicensing server address:  &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;&lt;br /&gt;
# Your user code issued by Magenta&lt;br /&gt;
# Your licensing password issued by Magenta&lt;br /&gt;
# Text that will display to your store operators should auto-relicensing be unsuccessful&lt;br /&gt;
&lt;br /&gt;
[[Image:Auto_Relicense_Figure_1.jpg]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Network Requirements ==&lt;br /&gt;
Relicensing requires that each POS terminal has port 80 access to the Magenta licensing server.  To check if your POS machines have appropriate network access, open a browser on the POS machine and try to navigate to &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;.  If this succeeds then the basic network requirements are met.  If this fails the cause of the failure will need to be identified and resolved before POS will be able to automatically renew its licence.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Other Requirements ==&lt;br /&gt;
In order for Enabler to invoke the licensing web service, the POS machine must have the Microsoft .NET framework 3.5 installed.  Older versions of Enabler POS may fail silently if this requirement is not met, later versions will log this in the Enabler event log.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Trouble Shooting ==&lt;br /&gt;
If POS is failing to renew its licence and the network test above is successful, check the POS event log at the time the POS relicensing message was displayed for a record indicating the reason for the relicensing failure.&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;Key Words: licence license relicense autolicence autorelicense unlicensed&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1270</id>
		<title>POS Auto Relicense</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1270"/>
		<updated>2012-06-17T23:19:10Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 18 June 2012. Last Reviewed: 18 June 2012&lt;br /&gt;
&lt;br /&gt;
Enabler and EEPOS require a licence key to operate.  Licence keys expire from time to time, usually after 12 months.  When POS detects that it is within one month of its licence expiration date, POS can automatically relicense itself via the Magenta licensing server.  &lt;br /&gt;
&lt;br /&gt;
== Configuration ==&lt;br /&gt;
Some simple configuration is required.  You must enter:&lt;br /&gt;
# Magenta&#039;s relicensing server address:  &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;&lt;br /&gt;
# Your user code issued by Magenta&lt;br /&gt;
# Your licensing password issued by Magenta&lt;br /&gt;
# Text that will display to your store operators should auto-relicensing be unsuccessful&lt;br /&gt;
&lt;br /&gt;
[[Image:Auto_Relicense_Figure_1.jpg]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Network Requirements ==&lt;br /&gt;
Relicensing requires that each POS terminal has port 80 access to the Magenta licensing server.  To check if your POS machines have appropriate network access, open a browser on the POS machine and try to navigate to &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;.  If this succeeds then the basic network requirements are met.  If this fails the cause of the failure will need to be identified and resolved before POS will be able to automatically renew its licence.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Trouble Shooting ==&lt;br /&gt;
If POS is failing to renew its licence and the network test above is successful, check the POS event log at the time the POS relicensing message was displayed for a record indicating the reason for the relicensing failure.&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;Key Words: licence license relicense autolicence autorelicense unlicensed&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1269</id>
		<title>POS Auto Relicense</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1269"/>
		<updated>2012-06-17T23:18:47Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 18 June 2012. Last Reviewed: 18 June 2012&lt;br /&gt;
&lt;br /&gt;
Enabler and EEPOS require a licence key to operate.  Licence keys expire from time to time, usually after 12 months.  When POS detects that it is within one month of its licence expiration date, POS can automatically relicense itself via the Magenta licensing server.  &lt;br /&gt;
&lt;br /&gt;
== Configuration ==&lt;br /&gt;
Some simple configuration is required.  You must enter:&lt;br /&gt;
# Magenta&#039;s relicensing server address:  &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;&lt;br /&gt;
# Your user code issued by Magenta&lt;br /&gt;
# Your licensing password issued by Magenta&lt;br /&gt;
# Text that will display to your store operators should auto-relicensing be unsuccessful&lt;br /&gt;
&lt;br /&gt;
[[Image:Auto_Relicense_Figure_1.jpg]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Network Requirements ==&lt;br /&gt;
Relicensing requires that each POS terminal has port 80 access to the Magenta licensing server.  To check if your POS machines have appropriate network access, open a browser on the POS machine and try to navigate to &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;.  If this succeeds then the basic network requirements are met.  If this fails the cause of the failure will need to be identified and resolved before POS will be able to automatically renew its licence.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Trouble Shooting ==&lt;br /&gt;
If POS is failing to renew its licence and the network test above is successful, check the POS event log at the time the POS relicensing message was displayed for a record indicating the reason for the relicensing failure.&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;Key Words:&lt;br /&gt;
licence license relicense autolicence autorelicense unlicensed&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1268</id>
		<title>POS Auto Relicense</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1268"/>
		<updated>2012-06-17T23:16:09Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 18 June 2012. Last Reviewed: 18 June 2012&lt;br /&gt;
&lt;br /&gt;
Enabler and EEPOS require a licence key to operate.  Licence keys expire from time to time, usually after 12 months.  When POS detects that it is within one month of its licence expiration date, POS can automatically relicense itself via the Magenta licensing server.  &lt;br /&gt;
&lt;br /&gt;
== Configuration ==&lt;br /&gt;
Some simple configuration is required.  You must enter:&lt;br /&gt;
# Magenta&#039;s relicensing server address:  &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;&lt;br /&gt;
# Your user code issued by Magenta&lt;br /&gt;
# Your licensing password issued by Magenta&lt;br /&gt;
# Text that will display to your store operators should auto-relicensing be unsuccessful&lt;br /&gt;
&lt;br /&gt;
[[Image:Auto_Relicense_Figure_1.jpg]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Network Requirements ==&lt;br /&gt;
Relicensing requires that each POS terminal has port 80 access to the Magenta licensing server.  To check if your POS machines have appropriate network access, open a browser on the POS machine and try to navigate to &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;.  If this succeeds then the basic network requirements are met.  If this fails the cause of the failure will need to be identified and resolved before POS will be able to automatically renew its licence.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Trouble Shooting ==&lt;br /&gt;
If POS is failing to renew its licence and the network test above is successful, check the POS event log at the time the POS relicensing message was displayed for a record indicating the reason for the relicensing failure.&lt;br /&gt;
&lt;br /&gt;
Key Words:&lt;br /&gt;
licence license relicense autolicence autorelicense unlicensed&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1267</id>
		<title>POS Auto Relicense</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1267"/>
		<updated>2012-06-17T23:10:25Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 18 June 2012. Last Reviewed: 18 June 2012&lt;br /&gt;
&lt;br /&gt;
Enabler and EEPOS require a licence key to operate.  Licence keys expire from time to time, usually after 12 months.  When POS detects that it is within one month of its licence expiration date, POS can automatically relicense itself via the Magenta licensing server.  &lt;br /&gt;
&lt;br /&gt;
Some simple configuration is required.  You must enter:&lt;br /&gt;
# Magenta&#039;s relicensing server address:  &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;&lt;br /&gt;
# Your user code issued by Magenta&lt;br /&gt;
# Your licensing password issued by Magenta&lt;br /&gt;
# Text that will display to your store operators should auto-relicensing be unsuccessful&lt;br /&gt;
&lt;br /&gt;
[[Image:Auto_Relicense_Figure_1.jpg]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Key Words:&lt;br /&gt;
licence license relicense autolicence autorelicense unlicensed&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=File:Auto_Relicense_Figure_1.jpg&amp;diff=1266</id>
		<title>File:Auto Relicense Figure 1.jpg</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=File:Auto_Relicense_Figure_1.jpg&amp;diff=1266"/>
		<updated>2012-06-17T23:09:06Z</updated>

		<summary type="html">&lt;p&gt;Bevan: uploaded a new version of &amp;amp;quot;File:Auto Relicense Figure 1.jpg&amp;amp;quot;: Smaller&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Auto relicensing Enabler setup screen shot&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=File:Auto_Relicense_Figure_1.jpg&amp;diff=1265</id>
		<title>File:Auto Relicense Figure 1.jpg</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=File:Auto_Relicense_Figure_1.jpg&amp;diff=1265"/>
		<updated>2012-06-17T23:08:11Z</updated>

		<summary type="html">&lt;p&gt;Bevan: Auto relicensing Enabler setup screen shot&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Auto relicensing Enabler setup screen shot&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1264</id>
		<title>POS Auto Relicense</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1264"/>
		<updated>2012-06-17T23:06:20Z</updated>

		<summary type="html">&lt;p&gt;Bevan: How to set up and test automatic relicensing of Enabler POS&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 18 June 2012. Last Reviewed: 18 June 2012&lt;br /&gt;
&lt;br /&gt;
Enabler and EEPOS require a licence key to operate.  Licence keys expire from time to time, usually after 12 months.  When POS detects that it is within one month of its licence expiration date, POS can automatically relicense itself via the Magenta licensing server.  &lt;br /&gt;
&lt;br /&gt;
Some simple configuration is required.  You must enter:&lt;br /&gt;
# Magenta&#039;s relicensing server address:  &#039;&#039;&#039;http://licensing.magentaretail.com.au/magentawebservice/magentawebservice.asmx&#039;&#039;&#039;&lt;br /&gt;
# Your user code issued by Magenta&lt;br /&gt;
# Your licensing password issued by Magenta&lt;br /&gt;
# Text that will display to your store operators should auto-relicensing be unsuccessful&lt;br /&gt;
&lt;br /&gt;
[[Image:Auto_Relicensing_Figure_1.jpg]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Key Words:&lt;br /&gt;
licence license relicense autolicence autorelicense unlicensed&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1263</id>
		<title>POS Auto Relicense</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=POS_Auto_Relicense&amp;diff=1263"/>
		<updated>2012-06-17T22:59:39Z</updated>

		<summary type="html">&lt;p&gt;Bevan: Created page with &amp;quot;fghfdgh&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;fghfdgh&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Firewall_Exceptions&amp;diff=1078</id>
		<title>Firewall Exceptions</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Firewall_Exceptions&amp;diff=1078"/>
		<updated>2012-02-02T03:51:55Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created 18 June 2010 Last Reviewed 2 February 2012&lt;br /&gt;
==Overview &amp;lt;br /&amp;gt;==&lt;br /&gt;
Various Firewall ports are required to be opened for full Enabler and EEE functionality to work correctly.  These are outlined below. &amp;lt;br /&amp;gt;&lt;br /&gt;
Note that various ports relating to EEE can be customised, so ensure the correct port number is taken into consideration when opening/closing firewall ports.  This includes but is not limited to Query Server, EEE Web Management Interface, SQL Server and others.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Enabler &amp;lt;br /&amp;gt;== &lt;br /&gt;
=====Enabler Head Office Server &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from local Head Office Nodes if any exist) &amp;lt;br /&amp;gt;&lt;br /&gt;
======Optional: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from all stores) if using Enabler Internal Comms to transfer Nibbler Messages &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port 445 (Outbound to Host Server) if using Enabler Internal Comms to transfer exported .hos files or import ISL-FILE.dat files from EEE or another 3rd party Host system. &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for Query Server (Outbound to EEE Query Server) if EEE is in use.  See [[#Query Server]] later on this page for further details.  &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for EEE Web Management Interface (Outbound to EEE Web Server) if EEE is in use &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Enabler Store Server &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from local tills within same store) &amp;lt;br /&amp;gt;&lt;br /&gt;
======Optional: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Outbound to Head Office Server) if using Enabler Internal Comms to transfer Nibbler Messages &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port 445 (Outbound to Host Server) if using Enabler Internal Comms to transfer exported .hos files or import ISL-FILE.dat files from EEE or another 3rd party Host system. &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for Query Server (Outbound to EEE Query Server) if EEE is in use.  See [[#Query Server]] later on this page for further details.  &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for EEE Web Management Interface (Outbound to EEE Web Server) if EEE is in use &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Enabler Tills and Head Office Nodes &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Outbound to local server) &amp;lt;br /&amp;gt;&lt;br /&gt;
======Optional: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from EEE Server) if EEE Online Inventory is in use &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for Query Server (Outbound to EEE Query Server) if EEE is in use.  See [[#Query Server]] later on this page for further details.  &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for EEE Web Management Interface (Outbound to EEE Web Server) if EEE is in use &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Further Details: &amp;lt;br /&amp;gt;=====&lt;br /&gt;
Enabler requires the standard Windows File and Printer Sharing ports open.  These allow tills to communicate with the store server. &amp;lt;br /&amp;gt;&lt;br /&gt;
As is often recommended, TCP port 445 should be the only port opened.  Other ports such as TCP/UDP 135-139 have been known to be exploited by Malware in the past, so should remain blocked where possible. &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
If EEE Online Inventory is in use, specifically Online Transfers, port 445 is used to print Transfer Dockets &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
If EEE Query Server is in use, the TCP port number can be customised.  This must be taken into consideration when opening the required ports. &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
If EEE is in use, the website port can be customised.  This must be taken into consideration when opening the required ports.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==EEE &amp;lt;br /&amp;gt;==&lt;br /&gt;
=====Query Server &amp;lt;br /&amp;gt;===== &lt;br /&gt;
Used to provide answers to data queries made by stores &amp;lt;br /&amp;gt;&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port for Query Server  (Inbound from all tills/store servers).  The first EEE company usually uses port 9000, and subsequent companies use 9001, 9002, etc.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====EEE Web Pages &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port for EEE Web Management Interface (Inbound from all tills/store servers and any other devices that require access to the EEE Management Interface).  This is usually HTTP/Port 80.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
======Optional: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port for Secure EEE Web Management Interface  (Inbound as above) if a SSL Certificate for secure https web communications is installed and configured on the Web Server.  This is usually HTTPS/Port 443.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====EEE Import/Export directories &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from all Store Servers) if Enabler Internal Comms is used to transfer Import/Export data to and from a store server.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Enabler Enterprise POS &amp;lt;br /&amp;gt;==&lt;br /&gt;
=====MSDTC &amp;lt;br /&amp;gt;===== &lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TPC Port 135 and UDP Port 137.  This is necessary to allow replication to function. &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====SQL Server &amp;lt;br /&amp;gt;===== &lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TPC Port 1433 and UDP Port 1434.&amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Dot Net Remoting &amp;lt;br /&amp;gt;===== &lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TPC Port 8080 (or other port as configured).&amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==See Also:==&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Firewall_Exceptions&amp;diff=1077</id>
		<title>Firewall Exceptions</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Firewall_Exceptions&amp;diff=1077"/>
		<updated>2012-02-02T03:51:39Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created 18 June 2010 Last Reviewed 15 February 2011&lt;br /&gt;
==Overview &amp;lt;br /&amp;gt;==&lt;br /&gt;
Various Firewall ports are required to be opened for full Enabler and EEE functionality to work correctly.  These are outlined below. &amp;lt;br /&amp;gt;&lt;br /&gt;
Note that various ports relating to EEE can be customised, so ensure the correct port number is taken into consideration when opening/closing firewall ports.  This includes but is not limited to Query Server, EEE Web Management Interface, SQL Server and others.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Enabler &amp;lt;br /&amp;gt;== &lt;br /&gt;
=====Enabler Head Office Server &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from local Head Office Nodes if any exist) &amp;lt;br /&amp;gt;&lt;br /&gt;
======Optional: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from all stores) if using Enabler Internal Comms to transfer Nibbler Messages &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port 445 (Outbound to Host Server) if using Enabler Internal Comms to transfer exported .hos files or import ISL-FILE.dat files from EEE or another 3rd party Host system. &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for Query Server (Outbound to EEE Query Server) if EEE is in use.  See [[#Query Server]] later on this page for further details.  &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for EEE Web Management Interface (Outbound to EEE Web Server) if EEE is in use &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Enabler Store Server &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from local tills within same store) &amp;lt;br /&amp;gt;&lt;br /&gt;
======Optional: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Outbound to Head Office Server) if using Enabler Internal Comms to transfer Nibbler Messages &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port 445 (Outbound to Host Server) if using Enabler Internal Comms to transfer exported .hos files or import ISL-FILE.dat files from EEE or another 3rd party Host system. &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for Query Server (Outbound to EEE Query Server) if EEE is in use.  See [[#Query Server]] later on this page for further details.  &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for EEE Web Management Interface (Outbound to EEE Web Server) if EEE is in use &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Enabler Tills and Head Office Nodes &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Outbound to local server) &amp;lt;br /&amp;gt;&lt;br /&gt;
======Optional: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from EEE Server) if EEE Online Inventory is in use &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for Query Server (Outbound to EEE Query Server) if EEE is in use.  See [[#Query Server]] later on this page for further details.  &amp;lt;br /&amp;gt;&lt;br /&gt;
TCP Port for EEE Web Management Interface (Outbound to EEE Web Server) if EEE is in use &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Further Details: &amp;lt;br /&amp;gt;=====&lt;br /&gt;
Enabler requires the standard Windows File and Printer Sharing ports open.  These allow tills to communicate with the store server. &amp;lt;br /&amp;gt;&lt;br /&gt;
As is often recommended, TCP port 445 should be the only port opened.  Other ports such as TCP/UDP 135-139 have been known to be exploited by Malware in the past, so should remain blocked where possible. &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
If EEE Online Inventory is in use, specifically Online Transfers, port 445 is used to print Transfer Dockets &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
If EEE Query Server is in use, the TCP port number can be customised.  This must be taken into consideration when opening the required ports. &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
If EEE is in use, the website port can be customised.  This must be taken into consideration when opening the required ports.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==EEE &amp;lt;br /&amp;gt;==&lt;br /&gt;
=====Query Server &amp;lt;br /&amp;gt;===== &lt;br /&gt;
Used to provide answers to data queries made by stores &amp;lt;br /&amp;gt;&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port for Query Server  (Inbound from all tills/store servers).  The first EEE company usually uses port 9000, and subsequent companies use 9001, 9002, etc.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====EEE Web Pages &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port for EEE Web Management Interface (Inbound from all tills/store servers and any other devices that require access to the EEE Management Interface).  This is usually HTTP/Port 80.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
======Optional: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port for Secure EEE Web Management Interface  (Inbound as above) if a SSL Certificate for secure https web communications is installed and configured on the Web Server.  This is usually HTTPS/Port 443.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====EEE Import/Export directories &amp;lt;br /&amp;gt;=====&lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TCP Port 445 (Inbound from all Store Servers) if Enabler Internal Comms is used to transfer Import/Export data to and from a store server.  &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Enabler Enterprise POS &amp;lt;br /&amp;gt;==&lt;br /&gt;
=====MSDTC &amp;lt;br /&amp;gt;===== &lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TPC Port 135 and UDP Port 137.  This is necessary to allow replication to function. &amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====SQL Server &amp;lt;br /&amp;gt;===== &lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TPC Port 1433 and UDP Port 1434.&amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Dot Net Remoting &amp;lt;br /&amp;gt;===== &lt;br /&gt;
======Required: &amp;lt;br /&amp;gt;======&lt;br /&gt;
TPC Port 8080 (or other port as configured).&amp;lt;br /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==See Also:==&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=HOS_File_Pass-Through_to_ERP&amp;diff=1003</id>
		<title>HOS File Pass-Through to ERP</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=HOS_File_Pass-Through_to_ERP&amp;diff=1003"/>
		<updated>2011-09-21T02:24:44Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 21 September 2011. Last Reviewed: 21 September 2011&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
To support legacy ERP implementations that already process Enabler HOS data from a file system directory structure, typically without extended HOS record headers as produced by Enabler when integrated with EEE, a modification has been implemented in Data Loader to support passing the raw HOS files through to a separate file system location for consumption by such ERP.&lt;br /&gt;
As a rarely used feature, configuration must be performed directly in the registry in:&lt;br /&gt;
 HKEY_LOCAL_MACHINE\SOFTWARE\ISL Australia Pty Ltd\Data Loader\Settingsn&lt;br /&gt;
Or, for x64 systems in:&lt;br /&gt;
 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ISL Australia Pty Ltd\Data Loader\Settingsn&lt;br /&gt;
&lt;br /&gt;
The following string values should be created:&lt;br /&gt;
&lt;br /&gt;
 &#039;&#039;&#039;ErpCopyToErp&#039;&#039;&#039;			Set to 1 to enable pass-through, else set to 0&lt;br /&gt;
 &#039;&#039;&#039;ErpFlatDirectoryStructure&#039;&#039;&#039;	Set to 1 to use the flattened directory structure described below.&lt;br /&gt;
 &#039;&#039;&#039;ErpIncludeResendFiles&#039;&#039;&#039;		Set to 1 to enabler pass-through of resend files, else set to 0.  Typically this would be 0.&lt;br /&gt;
 &#039;&#039;&#039;ErpStripExtendedHeaders&#039;&#039;&#039;		Set to 1 to strip extended headers (and replace with standard headers).&lt;br /&gt;
 &#039;&#039;&#039;ErpRootPath&#039;&#039;&#039;			Set to the root path to write files for ERP.  UNC path name is supported.&lt;br /&gt;
&lt;br /&gt;
Note that after editing Data Loader settings in the registry, the Data Loader service must be restarted to apply the changes.&lt;br /&gt;
If the ErpFlatDirectoryStrucuture option is off (0) files will be written in a subdirectory for each branch (and till if individual tills created HOS files) beneath the ErpRootPath.  Subdirectory names will be the lowest-level directory name from the original .IMP file location – typically this is the store’s four digit logical address.  If tills are generating the HOS files then the two lowest-level directory names are used.  So the ERP directory structure would become:&lt;br /&gt;
&lt;br /&gt;
 \\ERP-Server\Import-Folder\0201\&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202\&lt;br /&gt;
 \\ERP-Server\Import-Folder\0203\&lt;br /&gt;
… and so on…&lt;br /&gt;
or&lt;br /&gt;
 \\ERP-Server\Import-Folder\0201\01&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202\01&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202\02&lt;br /&gt;
 \\ERP-Server\Import-Folder\0203\&lt;br /&gt;
&lt;br /&gt;
etc if tills are creating the HOS files.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
If ErpFlatDirectoryStrucuture option is on (1) files will all be written in the ErpRootPath folder.  Each file name will be prefixed with the store’s four digit logical address from the lowest-level directory name or, if HOS files are generated by tills, the filename is prefixed with the branch code and till number from the lower two directories.  So the file structure would become:&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_09211300.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_09211305.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_09211310.hos&lt;br /&gt;
… and so on…&lt;br /&gt;
or&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_01_09211300.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_01_09211305.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_01_09211310.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_02_09211300.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_02_09211305.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_02_09211310.hos&lt;br /&gt;
etc if tills are creating the HOS files.&lt;br /&gt;
&lt;br /&gt;
Data Loader will create the ERP root folder if possible and the store (and till) sub-folders if necessary.  The Data Loader service account, commonly “EEEServices”, will need read/write/delete (or “full control”) permissions on the folder/directory targeted by the ErpRootPath setting.  If this is a network path then the network share will also need to permit read/write by the Data Loader service account.&lt;br /&gt;
Only uncompressed files will be copied to the ERP path – Data Loader will decompress ZIP files and copy the uncompressed contents to the ERP.  Files copied to the ERP will retain their original file names from inside the ZIP archive (usually Month-Day-Hour-Minute [mmddhhnn]) with a .HOS extension.&lt;br /&gt;
&lt;br /&gt;
If Data Loader is unable to copy a file to the ERP path (e.g. if the ErpRootPath share is temporarily unavailable) EEE will store files for the ERP in the EEE &amp;lt;import&amp;gt; path (original location of the HOS/ZIP files processed by Data Loader).  Such files with have a .ToERP_Ready file extension.  When Data Loader next processes a file from the same store, any accumulated .ToERP_Ready files will be copied to the ErpRootPath if it is writable.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=HOS_File_Pass-Through_to_ERP&amp;diff=1002</id>
		<title>HOS File Pass-Through to ERP</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=HOS_File_Pass-Through_to_ERP&amp;diff=1002"/>
		<updated>2011-09-21T02:23:05Z</updated>

		<summary type="html">&lt;p&gt;Bevan: Created page with &amp;quot;To support legacy ERP implementations that already process Enabler HOS data from a file system directory structure, typically without extended HOS record headers as produced by E...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To support legacy ERP implementations that already process Enabler HOS data from a file system directory structure, typically without extended HOS record headers as produced by Enabler when integrated with EEE, a modification has been implemented in Data Loader to support passing the raw HOS files through to a separate file system location for consumption by such ERP.&lt;br /&gt;
As a rarely used feature, configuration must be performed directly in the registry in:&lt;br /&gt;
 HKEY_LOCAL_MACHINE\SOFTWARE\ISL Australia Pty Ltd\Data Loader\Settingsn&lt;br /&gt;
Or, for x64 systems in:&lt;br /&gt;
 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ISL Australia Pty Ltd\Data Loader\Settingsn&lt;br /&gt;
&lt;br /&gt;
The following string values should be created:&lt;br /&gt;
&lt;br /&gt;
 &#039;&#039;&#039;ErpCopyToErp&#039;&#039;&#039;			Set to 1 to enable pass-through, else set to 0&lt;br /&gt;
 &#039;&#039;&#039;ErpFlatDirectoryStructure&#039;&#039;&#039;	Set to 1 to use the flattened directory structure described below.&lt;br /&gt;
 &#039;&#039;&#039;ErpIncludeResendFiles&#039;&#039;&#039;		Set to 1 to enabler pass-through of resend files, else set to 0.  Typically this would be 0.&lt;br /&gt;
 &#039;&#039;&#039;ErpStripExtendedHeaders&#039;&#039;&#039;		Set to 1 to strip extended headers (and replace with standard headers).&lt;br /&gt;
 &#039;&#039;&#039;ErpRootPath&#039;&#039;&#039;			Set to the root path to write files for ERP.  UNC path name is supported.&lt;br /&gt;
&lt;br /&gt;
Note that after editing Data Loader settings in the registry, the Data Loader service must be restarted to apply the changes.&lt;br /&gt;
If the ErpFlatDirectoryStrucuture option is off (0) files will be written in a subdirectory for each branch (and till if individual tills created HOS files) beneath the ErpRootPath.  Subdirectory names will be the lowest-level directory name from the original .IMP file location – typically this is the store’s four digit logical address.  If tills are generating the HOS files then the two lowest-level directory names are used.  So the ERP directory structure would become:&lt;br /&gt;
&lt;br /&gt;
 \\ERP-Server\Import-Folder\0201\&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202\&lt;br /&gt;
 \\ERP-Server\Import-Folder\0203\&lt;br /&gt;
… and so on…&lt;br /&gt;
or&lt;br /&gt;
 \\ERP-Server\Import-Folder\0201\01&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202\01&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202\02&lt;br /&gt;
 \\ERP-Server\Import-Folder\0203\&lt;br /&gt;
&lt;br /&gt;
etc if tills are creating the HOS files.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
If ErpFlatDirectoryStrucuture option is on (1) files will all be written in the ErpRootPath folder.  Each file name will be prefixed with the store’s four digit logical address from the lowest-level directory name or, if HOS files are generated by tills, the filename is prefixed with the branch code and till number from the lower two directories.  So the file structure would become:&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_09211300.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_09211305.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_09211310.hos&lt;br /&gt;
… and so on…&lt;br /&gt;
or&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_01_09211300.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_01_09211305.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_01_09211310.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_02_09211300.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_02_09211305.hos&lt;br /&gt;
 \\ERP-Server\Import-Folder\0202_02_09211310.hos&lt;br /&gt;
etc if tills are creating the HOS files.&lt;br /&gt;
&lt;br /&gt;
Data Loader will create the ERP root folder if possible and the store (and till) sub-folders if necessary.  The Data Loader service account, commonly “EEEServices”, will need read/write/delete (or “full control”) permissions on the folder/directory targeted by the ErpRootPath setting.  If this is a network path then the network share will also need to permit read/write by the Data Loader service account.&lt;br /&gt;
Only uncompressed files will be copied to the ERP path – Data Loader will decompress ZIP files and copy the uncompressed contents to the ERP.  Files copied to the ERP will retain their original file names from inside the ZIP archive (usually Month-Day-Hour-Minute [mmddhhnn]) with a .HOS extension.&lt;br /&gt;
&lt;br /&gt;
If Data Loader is unable to copy a file to the ERP path (e.g. if the ErpRootPath share is temporarily unavailable) EEE will store files for the ERP in the EEE &amp;lt;import&amp;gt; path (original location of the HOS/ZIP files processed by Data Loader).  Such files with have a .ToERP_Ready file extension.  When Data Loader next processes a file from the same store, any accumulated .ToERP_Ready files will be copied to the ErpRootPath if it is writable.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=BDE_Advanced_Settings&amp;diff=403</id>
		<title>BDE Advanced Settings</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=BDE_Advanced_Settings&amp;diff=403"/>
		<updated>2009-10-26T05:17:15Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 26 October 2009. Last Reviewed: 26 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. Enabler allows certain parameters that control the operation of the BDE to be configured. These settings are written by Enabler to the Registry, where the BDE looks for its configuration.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
These settings in Enabler are found in Configuration / Database Setup on the tab titled “BDE Settings”:&lt;br /&gt;
&lt;br /&gt;
[[Image:BDE_Advanced_Settings_Figure1.jpg]]&lt;br /&gt;
&lt;br /&gt;
Enabling the use of advanced settings and using the Recommned Settings (click Recommended Settings) can yield quite substantial performance improvements compared with the BDE default settings that would otherwise be used. The settings specified in this screen take affect only when:&lt;br /&gt;
&lt;br /&gt;
# The new settings have been successfully written to the Registry&lt;br /&gt;
# All BDE client applications (including Enabler POS, Back Office and Nibbler) have been closed and restarted. Sometimes it is easier to restart the machine to be sure.&lt;br /&gt;
&lt;br /&gt;
=== Writing Settings to the Registry ===&lt;br /&gt;
The Registry key &#039;&#039;&#039;HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine\Settings\SYSTEM\INIT&#039;&#039;&#039; might be secured such that POS logins cannot write to it. This can be determined by clicking the Test Registry Access button from the BDE settings screen on each terminal. Remember, however, that although you might have Registry Access when configuring these settings on your Enabler head office server, store machines might &#039;&#039;not&#039;&#039; have appropriate registry access. In order to allow the settings to be written to the Registry, you might have to log in as an administrator account &#039;&#039;one time only&#039;&#039; and load Enabler. Enabler would update the registry as it loads, and because the Registry data is in HKLM, not HKCU, this setting will continue to apply once you resume your normal Windows login.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Testing Impact of These Settings ===&lt;br /&gt;
As these settings change the memory footprint of the BDE, you might have to experiment with alternative BDE shared memory address settings. Once these changes have been made, verify that Enabler still runs without displaying error messages relating to BDE memory. It is important to verify that POS and Nibbler can both run, no matter which order they are loaded (POS first vs Nibbler first). For servers, try loading Back Office as well.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that if you have multiple machine types, configurations or Windows versions, you should test and verify these new settings on each platform.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=File:BDE_Advanced_Settings_Figure1.jpg&amp;diff=402</id>
		<title>File:BDE Advanced Settings Figure1.jpg</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=File:BDE_Advanced_Settings_Figure1.jpg&amp;diff=402"/>
		<updated>2009-10-26T05:17:02Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=BDE_Advanced_Settings&amp;diff=401</id>
		<title>BDE Advanced Settings</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=BDE_Advanced_Settings&amp;diff=401"/>
		<updated>2009-10-26T05:16:28Z</updated>

		<summary type="html">&lt;p&gt;Bevan: New page: Created: 26 October 2009. Last Reviewed: 26 October 2009   Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. Enabler allows...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 26 October 2009. Last Reviewed: 26 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. Enabler allows certain parameters that control the operation of the BDE to be configured. These settings are written by Enabler to the Registry, where the BDE looks for its configuration.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
These settings in Enabler are found in Configuration / Database Setup on the tab titled “BDE Settings”:&lt;br /&gt;
&lt;br /&gt;
[[Image:]]&lt;br /&gt;
&lt;br /&gt;
Enabling the use of advanced settings and using the Recommned Settings (click Recommended Settings) can yield quite substantial performance improvements compared with the BDE default settings that would otherwise be used. The settings specified in this screen take affect only when:&lt;br /&gt;
&lt;br /&gt;
# The new settings have been successfully written to the Registry&lt;br /&gt;
# All BDE client applications (including Enabler POS, Back Office and Nibbler) have been closed and restarted. Sometimes it is easier to restart the machine to be sure.&lt;br /&gt;
&lt;br /&gt;
=== Writing Settings to the Registry ===&lt;br /&gt;
The Registry key &#039;&#039;&#039;HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine\Settings\SYSTEM\INIT&#039;&#039;&#039; might be secured such that POS logins cannot write to it. This can be determined by clicking the Test Registry Access button from the BDE settings screen on each terminal. Remember, however, that although you might have Registry Access when configuring these settings on your Enabler head office server, store machines might &#039;&#039;not&#039;&#039; have appropriate registry access. In order to allow the settings to be written to the Registry, you might have to log in as an administrator account &#039;&#039;one time only&#039;&#039; and load Enabler. Enabler would update the registry as it loads, and because the Registry data is in HKLM, not HKCU, this setting will continue to apply once you resume your normal Windows login.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Testing Impact of These Settings ===&lt;br /&gt;
As these settings change the memory footprint of the BDE, you might have to experiment with alternative BDE shared memory address settings. Once these changes have been made, verify that Enabler still runs without displaying error messages relating to BDE memory. It is important to verify that POS and Nibbler can both run, no matter which order they are loaded (POS first vs Nibbler first). For servers, try loading Back Office as well.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that if you have multiple machine types, configurations or Windows versions, you should test and verify these new settings on each platform.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Product_Indexes&amp;diff=400</id>
		<title>Product Indexes</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Product_Indexes&amp;diff=400"/>
		<updated>2009-10-26T04:59:27Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 26 October 2009. Last Reviewed: 26 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses indexes to assist in rapidly retrieving data from the database. These indexes work just like an index in a book – the search value is located in the index, and the index tells Enabler where in the database to look for the full data record. Indexes are essential to allow data to be retrieved rapidly, however they require work to maintain. Every time new information is added to the database, the index must be updated to tell Enabler how to retrieve that data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Tables in Enabler may be indexed on many different fields or combinations of fields. For example, the product table is indexed by product code, barcode, description, supplier product code and many more fields. Thus for each product that is added to Enabler, all these indices must also be maintained.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The product table is perhaps the most important table in Enabler, in so far as products are central to most POS operations. As a result, the product table, and to a degree the style table, tend to have a large number of indexes. It is also common, for the product table in particular, to have quite a large number of rows in these tables – product tables with &amp;gt; 600,000 rows are not uncommon. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Because of the large number of rows and the large number of indexes, it follows that if some of these indexes can be disabled, substantial performance gains can be enjoyed when importing new/additional products into the Enabler product database.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
A tab exists in the Product Database Options called “Index Options”.&lt;br /&gt;
&lt;br /&gt;
[[Image:Product_Indexes_Figure1.jpg]]&lt;br /&gt;
&lt;br /&gt;
On this tab, you can turn off various indexes on the posprod &amp;amp; posstyle tables. The more products you have, the slower it becomes due to the number of indexes that need to be updated, even if you are not using a lot of them. Turning off indexes that you do not use will have a significant impact on the time taken importing new products.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The functional impact of turning off the indexes differs depending on the index in question. A summary is below. Note that in all cases where it says cannot search from PLU prompt, this also applies to other areas of Enabler as well where we search for a PLU, not just the sales screen (i.e product field on stock adjustments or product labels screens). This is because the underlying product lookup logic has been changed to ignore those indexes that have been turned off.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Product Table (local\posprod.dbf): ===&lt;br /&gt;
Turn off supplier stock code 1 index&lt;br /&gt;
&lt;br /&gt;
-When supplier product code 1 is added as a custom field to the product browse, you will no longer be able to sort the browse results via supplier product code 1.&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 2 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 3 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via supplier code 1 only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off division index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via division code only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off class index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via class code only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off barcode index &#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using the product barcode contained in the product table. Searching via barcodes contained in local\posbarc is still supported. Note: When using barcodes sent form EEE, they are stored in the local\posbarc table, not the local\posprod.pd_barc field.&lt;br /&gt;
&lt;br /&gt;
-When importing SOH (SC records, ISL-INV.DAT), cannot search for product via posprod.pd_barc when barcode included but no PLU included in the import record. The number of attempts that were skipped is logged to the event log, i.e “Product Quantities (no PD_BARC index) = 113”.&lt;br /&gt;
&lt;br /&gt;
-When generating new products from the style maintenance, and the option to generate a barcode is turned on, we do not generate a new barcode &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Style table (local\posstyle.dbf): ===&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
-No longer an index that can be selected on the style browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 2 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 3 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off barcode index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using the style barcode contained in the style table.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
For example, when “division” index is turned off in the example above, performing an advanced search will not allow you to search on division without entering a class, supplier or department to narrow down the search via index first:&lt;br /&gt;
&lt;br /&gt;
[[Image:Product_Indexes_Figure2.jpg]]&lt;br /&gt;
&lt;br /&gt;
The local\posprod.dbf and local\posstyle.dbf files are always conditionally reindexed during the data purge as part of the end of day. This will force indexes turned on/off to be regenerated/removed. You can off course reindex the files manually, do a conditionalindexall or a migrate to update the indexes to what you have selected.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Product_Indexes&amp;diff=399</id>
		<title>Product Indexes</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Product_Indexes&amp;diff=399"/>
		<updated>2009-10-26T04:59:00Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 26 October 2009. Last Reviewed: 26 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses indexes to assist in rapidly retrieving data from the database. These indexes work just like an index in a book – the search value is located in the index, and the index tells Enabler where in the database to look for the full data record. Indexes are essential to allow data to be retrieved rapidly, however they require work to maintain. Every time new information is added to the database, the index must be updated to tell Enabler how to retrieve that data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Tables in Enabler may be indexed on many different fields or combinations of fields. For example, the product table is indexed by product code, barcode, description, supplier product code and many more fields. Thus for each product that is added to Enabler, all these indices must also be maintained.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The product table is perhaps the most important table in Enabler, in so far as products are central to most POS operations. As a result, the product table, and to a degree the style table, tend to have a large number of indexes. It is also common, for the product table in particular, to have quite a large number of rows in these tables – product tables with &amp;gt; 600,000 rows are not uncommon. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Because of the large number of rows and the large number of indexes, it follows that if some of these indexes can be disabled, substantial performance gains can be enjoyed when importing new/additional products into the Enabler product database.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
A tab exists in the Product Database Options called “Index Options”.&lt;br /&gt;
&lt;br /&gt;
[[Image:]]&lt;br /&gt;
&lt;br /&gt;
On this tab, you can turn off various indexes on the posprod &amp;amp; posstyle tables. The more products you have, the slower it becomes due to the number of indexes that need to be updated, even if you are not using a lot of them. Turning off indexes that you do not use will have a significant impact on the time taken importing new products.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The functional impact of turning off the indexes differs depending on the index in question. A summary is below. Note that in all cases where it says cannot search from PLU prompt, this also applies to other areas of Enabler as well where we search for a PLU, not just the sales screen (i.e product field on stock adjustments or product labels screens). This is because the underlying product lookup logic has been changed to ignore those indexes that have been turned off.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Product Table (local\posprod.dbf): ===&lt;br /&gt;
Turn off supplier stock code 1 index&lt;br /&gt;
&lt;br /&gt;
-When supplier product code 1 is added as a custom field to the product browse, you will no longer be able to sort the browse results via supplier product code 1.&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 2 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 3 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via supplier code 1 only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off division index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via division code only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off class index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via class code only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off barcode index &#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using the product barcode contained in the product table. Searching via barcodes contained in local\posbarc is still supported. Note: When using barcodes sent form EEE, they are stored in the local\posbarc table, not the local\posprod.pd_barc field.&lt;br /&gt;
&lt;br /&gt;
-When importing SOH (SC records, ISL-INV.DAT), cannot search for product via posprod.pd_barc when barcode included but no PLU included in the import record. The number of attempts that were skipped is logged to the event log, i.e “Product Quantities (no PD_BARC index) = 113”.&lt;br /&gt;
&lt;br /&gt;
-When generating new products from the style maintenance, and the option to generate a barcode is turned on, we do not generate a new barcode &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Style table (local\posstyle.dbf): ===&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
-No longer an index that can be selected on the style browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 2 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 3 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off barcode index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using the style barcode contained in the style table.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
For example, when “division” index is turned off in the example above, performing an advanced search will not allow you to search on division without entering a class, supplier or department to narrow down the search via index first:&lt;br /&gt;
&lt;br /&gt;
[[Image:]]&lt;br /&gt;
&lt;br /&gt;
The local\posprod.dbf and local\posstyle.dbf files are always conditionally reindexed during the data purge as part of the end of day. This will force indexes turned on/off to be regenerated/removed. You can off course reindex the files manually, do a conditionalindexall or a migrate to update the indexes to what you have selected.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Product_Indexes&amp;diff=398</id>
		<title>Product Indexes</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Product_Indexes&amp;diff=398"/>
		<updated>2009-10-26T04:50:34Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 26 October 2009. Last Reviewed: 26 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses indexes to assist in rapidly retrieving data from the database. These indexes work just like an index in a book – the search value is located in the index, and the index tells Enabler where in the database to look for the full data record. Indexes are essential to allow data to be retrieved rapidly, however they require work to maintain. Every time new information is added to the database, the index must be updated to tell Enabler how to retrieve that data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Tables in Enabler may be indexed on many different fields or combinations of fields. For example, the product table is indexed by product code, barcode, description, supplier product code and many more fields. Thus for each product that is added to Enabler, all these indices must also be maintained.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The product table is perhaps the most important table in Enabler, in so far as products are central to most POS operations. As a result, the product table, and to a degree the style table, tend to have a large number of indexes. It is also common, for the product table in particular, to have quite a large number of rows in these tables – product tables with &amp;gt; 600,000 rows are not uncommon. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Because of the large number of rows and the large number of indexes, it follows that if some of these indexes can be disabled, substantial performance gains can be enjoyed when importing new/additional products into the Enabler product database.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
A tab exists in the Product Database Options called “Index Options”.&lt;br /&gt;
&lt;br /&gt;
[[Image:Product_Indexes_Figure1.jpg]]&lt;br /&gt;
&lt;br /&gt;
On this tab, you can turn off various indexes on the posprod &amp;amp; posstyle tables. The more products you have, the slower it becomes due to the number of indexes that need to be updated, even if you are not using a lot of them. Turning off indexes that you do not use will have a significant impact on the time taken importing new products.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The functional impact of turning off the indexes differs depending on the index in question. A summary is below. Note that in all cases where it says cannot search from PLU prompt, this also applies to other areas of Enabler as well where we search for a PLU, not just the sales screen (i.e product field on stock adjustments or product labels screens). This is because the underlying product lookup logic has been changed to ignore those indexes that have been turned off.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Product Table (local\posprod.dbf):&#039;&#039;&#039;Turn off supplier stock code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-When supplier product code 1 is added as a custom field to the product browse, you will no longer be able to sort the browse results via supplier product code 1.&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 2 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 3 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via supplier code 1 only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off division index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via division code only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off class index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via class code only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off barcode index &#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using the product barcode contained in the product table. Searching via barcodes contained in local\posbarc is still supported. Note: When using barcodes sent form EEE, they are stored in the local\posbarc table, not the local\posprod.pd_barc field.&lt;br /&gt;
&lt;br /&gt;
-When importing SOH (SC records, ISL-INV.DAT), cannot search for product via posprod.pd_barc when barcode included but no PLU included in the import record. The number of attempts that were skipped is logged to the event log, i.e “Product Quantities (no PD_BARC index) = 113”.&lt;br /&gt;
&lt;br /&gt;
-When generating new products from the style maintenance, and the option to generate a barcode is turned on, we do not generate a new barcode &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Style table (local\posstyle.dbf):&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
-No longer an index that can be selected on the style browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 2 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 3 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off barcode index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using the style barcode contained in the style table.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
For example, when “division” index is turned off in the example above, performing an advanced search will not allow you to search on division without entering a class, supplier or department to narrow down the search via index first:&lt;br /&gt;
&lt;br /&gt;
[[Image:Product_Indexes_Figure2.jpg]]&lt;br /&gt;
&lt;br /&gt;
The local\posprod.dbf and local\posstyle.dbf files are always conditionally reindexed during the data purge as part of the end of day. This will force indexes turned on/off to be regenerated/removed. You can off course reindex the files manually, do a conditionalindexall or a migrate to update the indexes to what you have selected.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=File:Product_Indexes_Figure2.jpg&amp;diff=397</id>
		<title>File:Product Indexes Figure2.jpg</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=File:Product_Indexes_Figure2.jpg&amp;diff=397"/>
		<updated>2009-10-26T04:49:07Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=File:Product_Indexes_Figure1.jpg&amp;diff=396</id>
		<title>File:Product Indexes Figure1.jpg</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=File:Product_Indexes_Figure1.jpg&amp;diff=396"/>
		<updated>2009-10-26T04:48:48Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Product_Indexes&amp;diff=395</id>
		<title>Product Indexes</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Product_Indexes&amp;diff=395"/>
		<updated>2009-10-26T04:47:39Z</updated>

		<summary type="html">&lt;p&gt;Bevan: New page: Created: 26 October 2009. Last Reviewed: 26 October 2009   Enabler uses indexes to assist in rapidly retrieving data from the database. These indexes work just like an index in a book – ...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 26 October 2009. Last Reviewed: 26 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses indexes to assist in rapidly retrieving data from the database. These indexes work just like an index in a book – the search value is located in the index, and the index tells Enabler where in the database to look for the full data record. Indexes are essential to allow data to be retrieved rapidly, however they require work to maintain. Every time new information is added to the database, the index must be updated to tell Enabler how to retrieve that data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Tables in Enabler may be indexed on many different fields or combinations of fields. For example, the product table is indexed by product code, barcode, description, supplier product code and many more fields. Thus for each product that is added to Enabler, all these indices must also be maintained.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The product table is perhaps the most important table in Enabler, in so far as products are central to most POS operations. As a result, the product table, and to a degree the style table, tend to have a large number of indexes. It is also common, for the product table in particular, to have quite a large number of rows in these tables – product tables with &amp;gt; 600,000 rows are not uncommon. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Because of the large number of rows and the large number of indexes, it follows that if some of these indexes can be disabled, substantial performance gains can be enjoyed when importing new/additional products into the Enabler product database.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
A tab exists in the Product Database Options called “Index Options”.&lt;br /&gt;
&lt;br /&gt;
[[Image:]]&lt;br /&gt;
&lt;br /&gt;
On this tab, you can turn off various indexes on the posprod &amp;amp; posstyle tables. The more products you have, the slower it becomes due to the number of indexes that need to be updated, even if you are not using a lot of them. Turning off indexes that you do not use will have a significant impact on the time taken importing new products.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The functional impact of turning off the indexes differs depending on the index in question. A summary is below. Note that in all cases where it says cannot search from PLU prompt, this also applies to other areas of Enabler as well where we search for a PLU, not just the sales screen (i.e product field on stock adjustments or product labels screens). This is because the underlying product lookup logic has been changed to ignore those indexes that have been turned off.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Product Table (local\posprod.dbf):&#039;&#039;&#039;Turn off supplier stock code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-When supplier product code 1 is added as a custom field to the product browse, you will no longer be able to sort the browse results via supplier product code 1.&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 2 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 3 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
-Centralised Purchase Orders. Cannot validate/resolve a PLU entered using “.” Notation to search for a supplier stock code.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via supplier code 1 only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off division index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via division code only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off class index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search via class code only in the advanced search screen on the product browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off barcode index &#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using the product barcode contained in the product table. Searching via barcodes contained in local\posbarc is still supported. Note: When using barcodes sent form EEE, they are stored in the local\posbarc table, not the local\posprod.pd_barc field.&lt;br /&gt;
&lt;br /&gt;
-When importing SOH (SC records, ISL-INV.DAT), cannot search for product via posprod.pd_barc when barcode included but no PLU included in the import record. The number of attempts that were skipped is logged to the event log, i.e “Product Quantities (no PD_BARC index) = 113”.&lt;br /&gt;
&lt;br /&gt;
-When generating new products from the style maintenance, and the option to generate a barcode is turned on, we do not generate a new barcode &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Style table (local\posstyle.dbf):&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 1 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
-No longer an index that can be selected on the style browse.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 2 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off supplier stock code 3 index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using “.” notation to search for a supplier stock code of the style.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Turn off barcode index&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
-Cannot search from the PLU prompt in the sales screen using the style barcode contained in the style table.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
For example, when “division” index is turned off in the example above, performing an advanced search will not allow you to search on division without entering a class, supplier or department to narrow down the search via index first:&lt;br /&gt;
&lt;br /&gt;
[[Image:]]&lt;br /&gt;
&lt;br /&gt;
The local\posprod.dbf and local\posstyle.dbf files are always conditionally reindexed during the data purge as part of the end of day. This will force indexes turned on/off to be regenerated/removed. You can off course reindex the files manually, do a conditionalindexall or a migrate to update the indexes to what you have selected.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=QUOTED_IDENTIFIER_Errors_in_EEE&amp;diff=394</id>
		<title>QUOTED IDENTIFIER Errors in EEE</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=QUOTED_IDENTIFIER_Errors_in_EEE&amp;diff=394"/>
		<updated>2009-10-19T03:10:08Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 16 October 2009. Last Reviewed: 16 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Microsoft SQL Server has a number of settings that can impact on the operation of some types of queries. One of these is the setting of QUOTED_IDENTIFIER (on/off). SQL Server &#039;&#039;requires &#039;&#039;that QUOTED_IDENTIFIER be ON in certain circumstances. One circumstance which can affect EEE is when inserting or updating rows in a table that has an index on a computed column. TenderDetail is such a table in EEE. Further, if a stored procedure inserts or updates such rows then QUOTED_IDENTIFIER must be on &#039;&#039;when the stored procedure is compiled!. &#039;&#039;&lt;br /&gt;
&lt;br /&gt;
= Symtoms: =&lt;br /&gt;
If this requirement is not met, SQL Server may return an error message such as “READTEXT failed because the following SET options have incorrect settings: &#039;QUOTED_IDENTIFIER&#039;. Veryify the SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type mthods.”&lt;br /&gt;
&lt;br /&gt;
= Cause: =&lt;br /&gt;
In EEE this can occur if EEE stored procedures are recompiled while QUOTED_IDENTIFIER is off. Depending on how stored procedures are compiled, QUOTED_IDENTIFIER may be on or off. Stored Procedures installed using Magenta&#039;s standard EEE tools should be properly compiled. If stored procedures are applied manually, they may have been compiled with incorrect settings. There are various possible reasons:&lt;br /&gt;
&lt;br /&gt;
* SQLCMD, by default, has QUOTED_IDENTIFIER set to OFF&lt;br /&gt;
* SQL Server Management Studio usually defaults QUOTED_IDENTIFER on, but this can be overridden in SSMS options&lt;br /&gt;
* OLEDB connections normally default QUOTED_IDENTIFIER to ON&lt;br /&gt;
&lt;br /&gt;
As SQLCMD is used by the EEE installers, upgrade tool and service release tool, any special (non-standard) scripts that fail to include SET QUOTED_IDENTIER ON at the start could also lead to this problem.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;To Check Connection Settings for any Current Connection:&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
The following TSQL may be executed on any connection to display the current values for a variety of SET options.&lt;br /&gt;
&lt;br /&gt;
IF 1 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 1PRINT &#039;DISABLE_DEF_CNST_CHK&#039;IF 2 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 2PRINT &#039;IMPLICIT_TRANSACTIONS&#039;&lt;br /&gt;
&lt;br /&gt;
IF 4 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 4PRINT &#039;CURSOR_CLOSE_ON_COMMIT&#039;&lt;br /&gt;
&lt;br /&gt;
IF 8 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 8PRINT &#039;ANSI_WARNINGS&#039;&lt;br /&gt;
&lt;br /&gt;
IF 16 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 16PRINT &#039;ANSI_PADDING&#039;&lt;br /&gt;
&lt;br /&gt;
IF 32 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 32PRINT &#039;ANSI_NULLS&#039;&lt;br /&gt;
&lt;br /&gt;
IF 64 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 64PRINT &#039;ARITHABORT&#039;&lt;br /&gt;
&lt;br /&gt;
IF 128 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 128PRINT &#039;ARITHIGNORE&#039;&lt;br /&gt;
&lt;br /&gt;
IF 256 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 256PRINT &#039;QUOTED_IDENTIFIER&#039;&lt;br /&gt;
&lt;br /&gt;
IF 512 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 512PRINT &#039;NOCOUNT&#039;&lt;br /&gt;
&lt;br /&gt;
IF 1024 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 1024PRINT &#039;ANSI_NULL_DFLT_ON&#039;&lt;br /&gt;
&lt;br /&gt;
IF 2048 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 2048PRINT &#039;ANSI_NULL_DFLT_OFF&#039;&lt;br /&gt;
&lt;br /&gt;
IF 4096 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 4096PRINT &#039;CONCAT_NULL_YIELDS_NULL&#039;&lt;br /&gt;
&lt;br /&gt;
IF 8192 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 8192PRINT &#039;NUMERIC_ROUNDABORT&#039;&lt;br /&gt;
&lt;br /&gt;
IF 16384 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 16384PRINT &#039;XACT_ABORT&#039; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
= Resolution: =&lt;br /&gt;
These problems in EEE can be resolved by determining the problem stored procedure(s) and recompiling them with the appropriate SET QUOTED_IDENTIFIER ON.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
For example if usp_SampleProc is the problem:&lt;br /&gt;
&lt;br /&gt;
* sp_helptext usp_SampleProc&lt;br /&gt;
* Paste the stored procedure text into a query window&lt;br /&gt;
* Delete the text up to, and including CREATE PROCEDURE and replace with ALTER PROCEDURE&lt;br /&gt;
* Prior to ALTER PROCEDURE, insert:&lt;br /&gt;
&lt;br /&gt;
SET QUOTED_IDENTIFIER ON&lt;br /&gt;
&lt;br /&gt;
GO&lt;br /&gt;
&lt;br /&gt;
Run the query.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=QUOTED_IDENTIFIER_Errors_in_EEE&amp;diff=393</id>
		<title>QUOTED IDENTIFIER Errors in EEE</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=QUOTED_IDENTIFIER_Errors_in_EEE&amp;diff=393"/>
		<updated>2009-10-19T03:09:00Z</updated>

		<summary type="html">&lt;p&gt;Bevan: New page: Created: 16 October 2009. Last Reviewed: 16 October 2009   Microsoft SQL Server has a number of settings that can impact on the operation of some types of queries. One of these is the sett...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 16 October 2009. Last Reviewed: 16 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Microsoft SQL Server has a number of settings that can impact on the operation of some types of queries. One of these is the setting of QUOTED_IDENTIFIER (on/off). SQL Server &#039;&#039;requires &#039;&#039;that QUOTED_IDENTIFIER be ON in certain circumstances. One circumstance which can affect EEE is when inserting or updating rows in a table that has an index on a computed column. TenderDetail is such a table in EEE. Further, if a stored procedure inserts or updates such rows then QUOTED_IDENTIFIER must be on &#039;&#039;when the stored procedure is compiled!. &#039;&#039;&lt;br /&gt;
&lt;br /&gt;
===== Symtoms: =====&lt;br /&gt;
If this requirement is not met, SQL Server may return an error message such as “READTEXT failed because the following SET options have incorrect settings: &#039;QUOTED_IDENTIFIER&#039;. Veryify the SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type mthods.”&lt;br /&gt;
&lt;br /&gt;
===== Cause: =====&lt;br /&gt;
In EEE this can occur if EEE stored procedures are recompiled while QUOTED_IDENTIFIER is off. Depending on how stored procedures are compiled, QUOTED_IDENTIFIER may be on or off. Stored Procedures installed using Magenta&#039;s standard EEE tools should be properly compiled. If stored procedures are applied manually, they may have been compiled with incorrect settings. There are various possible reasons:&lt;br /&gt;
&lt;br /&gt;
* SQLCMD, by default, has QUOTED_IDENTIFIER set to OFF&lt;br /&gt;
* SQL Server Management Studio usually defaults QUOTED_IDENTIFER on, but this can be overridden in SSMS options&lt;br /&gt;
* OLEDB connections normally default QUOTED_IDENTIFIER to ON&lt;br /&gt;
&lt;br /&gt;
As SQLCMD is used by the EEE installers, upgrade tool and service release tool, any special (non-standard) scripts that fail to include SET QUOTED_IDENTIER ON at the start could also lead to this problem.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;To Check Connection Settings for any Current Connection:&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
The following TSQL may be executed on any connection to display the current values for a variety of SET options.&lt;br /&gt;
&lt;br /&gt;
IF 1 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 1PRINT &#039;DISABLE_DEF_CNST_CHK&#039;IF 2 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 2PRINT &#039;IMPLICIT_TRANSACTIONS&#039;&lt;br /&gt;
&lt;br /&gt;
IF 4 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 4PRINT &#039;CURSOR_CLOSE_ON_COMMIT&#039;&lt;br /&gt;
&lt;br /&gt;
IF 8 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 8PRINT &#039;ANSI_WARNINGS&#039;&lt;br /&gt;
&lt;br /&gt;
IF 16 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 16PRINT &#039;ANSI_PADDING&#039;&lt;br /&gt;
&lt;br /&gt;
IF 32 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 32PRINT &#039;ANSI_NULLS&#039;&lt;br /&gt;
&lt;br /&gt;
IF 64 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 64PRINT &#039;ARITHABORT&#039;&lt;br /&gt;
&lt;br /&gt;
IF 128 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 128PRINT &#039;ARITHIGNORE&#039;&lt;br /&gt;
&lt;br /&gt;
IF 256 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 256PRINT &#039;QUOTED_IDENTIFIER&#039;&lt;br /&gt;
&lt;br /&gt;
IF 512 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 512PRINT &#039;NOCOUNT&#039;&lt;br /&gt;
&lt;br /&gt;
IF 1024 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 1024PRINT &#039;ANSI_NULL_DFLT_ON&#039;&lt;br /&gt;
&lt;br /&gt;
IF 2048 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 2048PRINT &#039;ANSI_NULL_DFLT_OFF&#039;&lt;br /&gt;
&lt;br /&gt;
IF 4096 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 4096PRINT &#039;CONCAT_NULL_YIELDS_NULL&#039;&lt;br /&gt;
&lt;br /&gt;
IF 8192 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 8192PRINT &#039;NUMERIC_ROUNDABORT&#039;&lt;br /&gt;
&lt;br /&gt;
IF 16384 &amp;amp; @@options &amp;lt;nowiki&amp;gt;=&amp;lt;/nowiki&amp;gt; 16384PRINT &#039;XACT_ABORT&#039; &lt;br /&gt;
&lt;br /&gt;
# &lt;br /&gt;
&lt;br /&gt;
= Resolution: =&lt;br /&gt;
These problems in EEE can be resolved by determining the problem stored procedure(s) and recompiling them with the appropriate SET QUOTED_IDENTIFIER ON.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
For example if usp_SampleProc is the problem:&lt;br /&gt;
&lt;br /&gt;
* sp_helptext usp_SampleProc&lt;br /&gt;
* Paste the stored procedure text into a query window&lt;br /&gt;
* Delete the text up to, and including CREATE PROCEDURE and replace with ALTER PROCEDURE&lt;br /&gt;
* Prior to ALTER PROCEDURE, insert:&lt;br /&gt;
&lt;br /&gt;
SET QUOTED_IDENTIFIER ON&lt;br /&gt;
&lt;br /&gt;
GO&lt;br /&gt;
&lt;br /&gt;
Run the query.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Main_Page&amp;diff=355</id>
		<title>Main Page</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Main_Page&amp;diff=355"/>
		<updated>2009-10-14T04:17:26Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&amp;lt;big&amp;gt;&#039;&#039;&#039;Welcome to Magenta Retail&#039;s EEE and Enabler Wiki.&#039;&#039;&#039;&amp;lt;/big&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Enter the topic you would like to search for in the seach box to the left and please enjoy our Wiki!&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Other Links ==&lt;br /&gt;
&lt;br /&gt;
* Magenta&#039;s Web site [http://www.magentaretail.com.au www.magentaretail.com.au]&lt;br /&gt;
* Magenta&#039;s FTP site [ftp://ftp3.magentaretail.com.au Please click here]&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=354</id>
		<title>Installing the Reporting Services Client Print ActiveX Control</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=354"/>
		<updated>2009-10-14T04:16:59Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 14 October 2009. Last Reviewed: 14 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Reports are delivered using Microsoft SQL Server Reporting Services, a component of SQL Server 2005 and SQL Server 2008. Reporting Services displays reports to users in a web browser. In order to print reporting services reports to a client-connected printer, Reporting Services uses a small ActiveX component known as RSClientPrint. Upon first attempt to use the client print function (or first attempt after installing a Reporting Services update such as an SQL Server service pack), IE will prompt the user to download and install the ActiveX control.&lt;br /&gt;
&lt;br /&gt;
The ActiveX control may be manually pre-deployed to client machines. This is desirable:&lt;br /&gt;
&lt;br /&gt;
# To save users having to accept the ActiveX installation prompts; or&lt;br /&gt;
# If Internet Explorer security settings are such that the installation of the ActiveX control would not be permitted.&lt;br /&gt;
&lt;br /&gt;
===== To Manually Install the ActiveX Control: =====&lt;br /&gt;
The ActiveX control files are in RSClientPrint.cab on the SQL Server in the Reporting Services bin directory. This is typically located in &#039;&#039;&#039;c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin&#039;&#039;&#039;. Note that the MSSQL.4 directory is variable depending what SQL Server components are installed – Reporting Services may be in MSSQL.2 or MSSQL.3 etc.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The cab file contains the following which should be installed in c:\windows\Downloaded Program Files:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
* gdiplus.dll&lt;br /&gt;
* rsclientprint.dll&lt;br /&gt;
* RSClientPrint_1028.rll&lt;br /&gt;
* RSClientPrint_1031.rll&lt;br /&gt;
* RSClientPrint_1033.rll&lt;br /&gt;
* RSClientPrint_1036.rll&lt;br /&gt;
* RSClientPrint_1040.rll&lt;br /&gt;
* RSClientPrint_1041.rll&lt;br /&gt;
* RSClientPrint_1042.rll&lt;br /&gt;
* RSClientPrint_1043.rll&lt;br /&gt;
* RSClientPrint_1046.rll&lt;br /&gt;
* RSClientPrint_1049.rll&lt;br /&gt;
* RSClientPrint_1053.rll&lt;br /&gt;
* RSClientPrint_2052.rll&lt;br /&gt;
* RSClientPrint_3082.rll&amp;lt;br/&amp;gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Once thse files have been installed, RSClientPrint.dll needs to be registered:&#039;&#039;&#039;regsvr32.exe RFClientPrint.dll.&#039;&#039;&#039;If writing a batch file to automate this process it may be necessary to force the installation and registration of files above to run under a separate account with administrative privileges. The following batch file may be used as a guide:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@echo off&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Skip if already installed (might not work if attempting to upgrade an older version!)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if exist &amp;quot;c:\Windows\Downloaded Program Files\gdiplus.dll&amp;quot; goto endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Specify source directory (copy of files from cab file)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;set srcpath=\\eee-server\files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Install Files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe /accepteula -u administrator -p my-password cmd.exe /c xcopy %srcpath%\rsclient\* &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; /y&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Register DLL&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe -u administrator -p my-password regsvr32 &amp;quot;c:\Windows\Downloaded Program Files\RSClientPrint.dll&amp;quot; /s&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;:endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note: This batch file uses psexec.exe from Sys Internals ([http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx][http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx)/ )] to invoke commands (cmd.exe and regsvr32.exe) under a different (administrator) account. The Windows internal runas command cannot be used because runas does not accept passwords from the command line.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that upon first execution of psexec.exe a EULA may be displayed to the user in a modal dialog box. To prevent this (which would stop a batch file from running in unattended mode), the command line switch /accepteula is used in the first call to psexec.exe.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=353</id>
		<title>Installing the Reporting Services Client Print ActiveX Control</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=353"/>
		<updated>2009-10-14T04:16:26Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 14 October 2009. Last Reviewed: 14 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Reports are delivered using Microsoft SQL Server Reporting Services, a component of SQL Server 2005 and SQL Server 2008. Reporting Services displays reports to users in a web browser. In order to print reporting services reports to a client-connected printer, Reporting Services uses a small ActiveX component known as RSClientPrint. Upon first attempt to use the client print function (or first attempt after installing a Reporting Services update such as an SQL Server service pack), IE will prompt the user to download and install the ActiveX control.&lt;br /&gt;
&lt;br /&gt;
The ActiveX control may be manually pre-deployed to client machines. This is desirable:&lt;br /&gt;
&lt;br /&gt;
# To save users having to accept the ActiveX installation prompts; or&lt;br /&gt;
# If Internet Explorer security settings are such that the installation of the ActiveX control would not be permitted.&lt;br /&gt;
&lt;br /&gt;
===== To Manually Install the ActiveX Control: =====&lt;br /&gt;
The ActiveX control files are in RSClientPrint.cab on the SQL Server in the Reporting Services bin directory. This is typically located in &#039;&#039;&#039;c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin&#039;&#039;&#039;. Note that the MSSQL.4 directory is variable depending what SQL Server components are installed – Reporting Services may be in MSSQL.2 or MSSQL.3 etc.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The cab file contains the following which should be installed in c:\windows\Downloaded Program Files:* gdiplus.dll&lt;br /&gt;
* rsclientprint.dll&lt;br /&gt;
* RSClientPrint_1028.rll&lt;br /&gt;
* RSClientPrint_1031.rll&lt;br /&gt;
* RSClientPrint_1033.rll&lt;br /&gt;
* RSClientPrint_1036.rll&lt;br /&gt;
* RSClientPrint_1040.rll&lt;br /&gt;
* RSClientPrint_1041.rll&lt;br /&gt;
* RSClientPrint_1042.rll&lt;br /&gt;
* RSClientPrint_1043.rll&lt;br /&gt;
* RSClientPrint_1046.rll&lt;br /&gt;
* RSClientPrint_1049.rll&lt;br /&gt;
* RSClientPrint_1053.rll&lt;br /&gt;
* RSClientPrint_2052.rll&lt;br /&gt;
* RSClientPrint_3082.rll&amp;lt;br/&amp;gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Once thse files have been installed, RSClientPrint.dll needs to be registered:&#039;&#039;&#039;regsvr32.exe RFClientPrint.dll.&#039;&#039;&#039;If writing a batch file to automate this process it may be necessary to force the installation and registration of files above to run under a separate account with administrative privileges. The following batch file may be used as a guide:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@echo off&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Skip if already installed (might not work if attempting to upgrade an older version!)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if exist &amp;quot;c:\Windows\Downloaded Program Files\gdiplus.dll&amp;quot; goto endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Specify source directory (copy of files from cab file)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;set srcpath=\\eee-server\files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Install Files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe /accepteula -u administrator -p my-password cmd.exe /c xcopy %srcpath%\rsclient\* &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; /y&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Register DLL&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe -u administrator -p my-password regsvr32 &amp;quot;c:\Windows\Downloaded Program Files\RSClientPrint.dll&amp;quot; /s&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;:endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note: This batch file uses psexec.exe from Sys Internals ([http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx][http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx)/ )] to invoke commands (cmd.exe and regsvr32.exe) under a different (administrator) account. The Windows internal runas command cannot be used because runas does not accept passwords from the command line.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that upon first execution of psexec.exe a EULA may be displayed to the user in a modal dialog box. To prevent this (which would stop a batch file from running in unattended mode), the command line switch /accepteula is used in the first call to psexec.exe.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=352</id>
		<title>Installing the Reporting Services Client Print ActiveX Control</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=352"/>
		<updated>2009-10-14T04:12:42Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 14 October 2009. Last Reviewed: 14 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Reports are delivered using Microsoft SQL Server Reporting Services, a component of SQL Server 2005 and SQL Server 2008. Reporting Services displays reports to users in a web browser. In order to print reporting services reports to a client-connected printer, Reporting Services uses a small ActiveX component known as RSClientPrint. Upon first attempt to use the client print function (or first attempt after installing a Reporting Services update such as an SQL Server service pack), IE will prompt the user to download and install the ActiveX control.&lt;br /&gt;
&lt;br /&gt;
The ActiveX control may be manually pre-deployed to client machines. This is desirable:&lt;br /&gt;
&lt;br /&gt;
# To save users having to accept the ActiveX installation prompts; or&lt;br /&gt;
# If Internet Explorer security settings are such that the installation of the ActiveX control would not be permitted.&lt;br /&gt;
&lt;br /&gt;
===== To Manually Install the ActiveX Control: =====&lt;br /&gt;
The ActiveX control files are in RSClientPrint.cab on the SQL Server in the Reporting Services bin directory. This is typically located in &#039;&#039;&#039;c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin&#039;&#039;&#039;. Note, that the MSSQL.4 directory is variable depending what SQL Server components are installed – Reporting Services may be in MSSQL.2 or MSSQL.3 etc.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The cab file contains the following which should be installed in c:\windows\Downloaded Program Files:* gdiplus.dll&lt;br /&gt;
* rsclientprint.dll&lt;br /&gt;
* RSClientPrint_1028.rll&lt;br /&gt;
* RSClientPrint_1031.rll&lt;br /&gt;
* RSClientPrint_1033.rll&lt;br /&gt;
* RSClientPrint_1036.rll&lt;br /&gt;
* RSClientPrint_1040.rll&lt;br /&gt;
* RSClientPrint_1041.rll&lt;br /&gt;
* RSClientPrint_1042.rll&lt;br /&gt;
* RSClientPrint_1043.rll&lt;br /&gt;
* RSClientPrint_1046.rll&lt;br /&gt;
* RSClientPrint_1049.rll&lt;br /&gt;
* RSClientPrint_1053.rll&lt;br /&gt;
* RSClientPrint_2052.rll&lt;br /&gt;
* RSClientPrint_3082.rll&amp;lt;br/&amp;gt; &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Once thse files have been installed, RSClientPrint.dll needs to be registered:&#039;&#039;&#039;regsvr32.exe RFClientPrint.dll&#039;&#039;&#039;If writing a batch file to automate this process it may be necessary for force steps 2 and 3 above to run under a separate account with administrative privileges. The following batch file may be used as a guide:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@echo off&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Skip if already installed (might not work if attempting to upgrade an older version!)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if exist &amp;quot;c:\Windows\Downloaded Program Files\gdiplus.dll&amp;quot; goto endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Create directory if necessary&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if not exist &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; mkdir &amp;quot;c:\Windows\Downloaded Program Files&amp;quot;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Specify source directory (copy of files from cab file)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;set srcpath=\\eee-server\files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Install Files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe /accepteula -u administrator -p my-password cmd.exe /c xcopy %srcpath%\rsclient\* &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; /y&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Register DLL&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe -u administrator -p my-password regsvr32 &amp;quot;c:\Windows\Downloaded Program Files\RSClientPrint.dll&amp;quot; /s&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;:endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note: This batch file uses psexec.exe from Sys Internals ([http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx][http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx)/ )] to invoke commands (cmd.exe and regsvr32.exe) under a different (administrator) account. The Windows internal runas command cannot be used because you cannot pass the password on the command line to runas. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that upon first execution of psexec.exe a EULA may be displayed to the user in a modal dialog box. To prevent this (which would stop a batch file from running in unattended mode), the command line switch /accepteula is used in the first call to psexec.exe.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=351</id>
		<title>Installing the Reporting Services Client Print ActiveX Control</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=351"/>
		<updated>2009-10-14T04:07:58Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 14 October 2009. Last Reviewed: 14 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Reports are delivered using Microsoft SQL Server Reporting Services, a component of SQL Server 2005 and SQL Server 2008. Reporting Services displays reports to users in a web browser. In order to print reporting services reports to a client-connected printer, Reporting Services uses a small ActiveX component known as RSClientPrint. Upon first attempt to use the client print function (or first attempt after installing a Reporting Services update such as an SQL Server service pack), IE will prompt the user to download and install the ActiveX control.&lt;br /&gt;
&lt;br /&gt;
The ActiveX control may be manually pre-deployed to client machines. This is desirable:&lt;br /&gt;
&lt;br /&gt;
# To save users having to accept the ActiveX installation prompts; or&lt;br /&gt;
# If Internet Explorer security settings are such that the installation of the ActiveX control would not be permitted.&lt;br /&gt;
&lt;br /&gt;
===== To Manually Install the ActiveX Control: =====&lt;br /&gt;
# The ActiveX control files are in RSClientPrint.cab on the SQL Server in the Reporting Services bin directory. This is typically located in &#039;&#039;&#039;c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin&#039;&#039;&#039;. Note, that the MSSQL.4 directory is variable depending what SQL Server components are installed – Reporting Services may be in MSSQL.2 or MSSQL.3 etc.&lt;br /&gt;
# The cab file contains the following which should be installed in c:\windows\Downloaded Program Files:&lt;br /&gt;
&lt;br /&gt;
* gdiplus.dll&lt;br /&gt;
* rsclientprint.dll&lt;br /&gt;
* RSClientPrint_1028.rll&lt;br /&gt;
* RSClientPrint_1031.rll&lt;br /&gt;
* RSClientPrint_1033.rll&lt;br /&gt;
* RSClientPrint_1036.rll&lt;br /&gt;
* RSClientPrint_1040.rll&lt;br /&gt;
* RSClientPrint_1041.rll&lt;br /&gt;
* RSClientPrint_1042.rll&lt;br /&gt;
* RSClientPrint_1043.rll&lt;br /&gt;
* RSClientPrint_1046.rll&lt;br /&gt;
* RSClientPrint_1049.rll&lt;br /&gt;
* RSClientPrint_1053.rll&lt;br /&gt;
* RSClientPrint_2052.rll&lt;br /&gt;
* RSClientPrint_3082.rll&lt;br /&gt;
&lt;br /&gt;
# Once thse files have been isntalled, RSClientPrint.dll needs to be registered:&#039;&#039;&#039;regsvr32.exe RFClientPrint.dll&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If writing a batch file to automate this process it may be necessary for force steps 2 and 3 above to run under a separate account with administrative privileges. The following batch file may be used as a guide:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@echo off&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Skip if already installed (might not work if attempting to upgrade an older version!)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if exist &amp;quot;c:\Windows\Downloaded Program Files\gdiplus.dll&amp;quot; goto endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Create directory if necessary&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if not exist &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; mkdir &amp;quot;c:\Windows\Downloaded Program Files&amp;quot;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Specify source directory (copy of files from cab file)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;set srcpath=\\eee-server\files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Install Files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe /accepteula -u administrator -p my-password cmd.exe /c xcopy %srcpath%\rsclient\* &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; /y&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Register DLL&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe -u administrator -p my-password regsvr32 &amp;quot;c:\Windows\Downloaded Program Files\RSClientPrint.dll&amp;quot; /s&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;:endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note: This batch file uses psexec.exe from Sys Internals ([http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx][http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx)/ )] to invoke commands (cmd.exe and regsvr32.exe) under a different (administrator) account. The Windows internal runas command cannot be used because you cannot pass the password on the command line to runas. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that upon first execution of psexec.exe a EULA may be displayed to the user in a modal dialog box. To prevent this (which would stop a batch file from running in unattended mode), the command line switch /accepteula is used in the first call to psexec.exe.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=350</id>
		<title>Installing the Reporting Services Client Print ActiveX Control</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=350"/>
		<updated>2009-10-14T04:06:42Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 14 October 2009. Last Reviewed: 14 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Reports are delivered using Microsoft SQL Server Reporting Services, a component of SQL Server 2005 and SQL Server 2008. Reporting Services displays reports to users in a web browser. In order to print reporting services reports to a client-connected printer, Reporting Services uses a small ActiveX component known as RSClientPrint. Upon first attempt to use the client print function (or first attempt after installing a Reporting Services update such as an SQL Server service pack), IE will prompt the user to download and install the ActiveX control.&lt;br /&gt;
&lt;br /&gt;
The ActiveX control may be manually pre-deployed to client machines. This is desirable:&lt;br /&gt;
&lt;br /&gt;
# To save users having to accept the ActiveX installation prompts; or&lt;br /&gt;
# If Internet Explorer security settings are such that the installation of the ActiveX control would not be permitted.&lt;br /&gt;
&lt;br /&gt;
===== To Manually Install the ActiveX Control: =====&lt;br /&gt;
# The ActiveX control files are in RSClientPrint.cab on the SQL Server in the Reporting Services bin directory. This is typically located in &#039;&#039;&#039;c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin&#039;&#039;&#039;. Note, that the MSSQL.4 directory is variable depending what SQL Server components are installed – Reporting Services may be in MSSQL.2 or MSSQL.3 etc.&lt;br /&gt;
# The cab file contains the following which should be installed in c:\windows\Downloaded Program Files:&lt;br /&gt;
# Once thse files have been isntalled, RSClientPrint.dll needs to be registered:&#039;&#039;&#039;regsvr32.exe RFClientPrint.dll&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If writing a batch file to automate this process it may be necessary for force steps 2 and 3 above to run under a separate account with administrative privileges. The following batch file may be used as a guide:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@echo off&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Skip if already installed (might not work if attempting to upgrade an older version!)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if exist &amp;quot;c:\Windows\Downloaded Program Files\gdiplus.dll&amp;quot; goto endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Create directory if necessary&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if not exist &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; mkdir &amp;quot;c:\Windows\Downloaded Program Files&amp;quot;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Specify source directory (copy of files from cab file)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;set srcpath=\\eee-server\files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Install Files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe /accepteula -u administrator -p my-password cmd.exe /c xcopy %srcpath%\rsclient\* &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; /y&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Register DLL&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe -u administrator -p my-password regsvr32 &amp;quot;c:\Windows\Downloaded Program Files\RSClientPrint.dll&amp;quot; /s&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;:endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note: This batch file uses psexec.exe from Sys Internals ([http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx][http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx)/ )] to invoke commands (cmd.exe and regsvr32.exe) under a different (administrator) account. The Windows internal runas command cannot be used because you cannot pass the password on the command line to runas. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that upon first execution of psexec.exe a EULA may be displayed to the user in a modal dialog box. To prevent this (which would stop a batch file from running in unattended mode), the command line switch /accepteula is used in the first call to psexec.exe.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=349</id>
		<title>Installing the Reporting Services Client Print ActiveX Control</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Installing_the_Reporting_Services_Client_Print_ActiveX_Control&amp;diff=349"/>
		<updated>2009-10-14T04:05:13Z</updated>

		<summary type="html">&lt;p&gt;Bevan: New page: Created: 14 October 2009. Last Reviewed: 14 October 2009   EEE Reports are delivered using Microsoft SQL Server Reporting Services, a component of SQL Server 2005 and SQL Server 2008. Repo...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 14 October 2009. Last Reviewed: 14 October 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
EEE Reports are delivered using Microsoft SQL Server Reporting Services, a component of SQL Server 2005 and SQL Server 2008. Reporting Services displays reports to users in a web browser. In order to print reporting services reports to a client-connected printer, Reporting Services uses a small ActiveX component known as RSClientPrint. Upon first attempt to use the client print function (or first attempt after installing a Reporting Services update such as an SQL Server service pack), IE will prompt the user to download and install the ActiveX control.&lt;br /&gt;
&lt;br /&gt;
The ActiveX control may be manually pre-deployed to client machines. This is desirable:&lt;br /&gt;
&lt;br /&gt;
# To save users having to accept the ActiveX installation prompts; or&lt;br /&gt;
# If Internet Explorer security settings are such that the installation of the ActiveX control would not be permitted.&lt;br /&gt;
&lt;br /&gt;
===== To Manually Install the ActiveX Control: =====&lt;br /&gt;
# The ActiveX control files are in RSClientPrint.cab on the SQL Server in the Reporting Services bin directory. This is typically located in &#039;&#039;&#039;c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin&#039;&#039;&#039;. Note, that the MSSQL.4 directory is variable depending what SQL Server components are installed – Reporting Services may be in MSSQL.2 or MSSQL.3 etc.&lt;br /&gt;
# The cab file contains the following which should be installed in c:\windows\Downloaded Program Files:gdiplus.dll&lt;br /&gt;
&lt;br /&gt;
rsclientprint.dll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1028.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1031.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1033.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1036.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1040.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1041.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1042.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1043.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1046.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1049.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_1053.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_2052.rll&lt;br /&gt;
&lt;br /&gt;
RSClientPrint_3082.rll&lt;br /&gt;
&lt;br /&gt;
# Once thse files have been isntalled, RSClientPrint.dll needs to be registered:&#039;&#039;&#039;regsvr32.exe RFClientPrint.dll&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If writing a batch file to automate this process it may be necessary for force steps 2 and 3 above to run under a separate account with administrative privileges. The following batch file may be used as a guide:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@echo off&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Skip if already installed (might not work if attempting to upgrade an older version!)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if exist &amp;quot;c:\Windows\Downloaded Program Files\gdiplus.dll&amp;quot; goto endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Create directory if necessary&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;if not exist &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; mkdir &amp;quot;c:\Windows\Downloaded Program Files&amp;quot;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Specify source directory (copy of files from cab file)&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;set srcpath=\\eee-server\files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Install Files&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe /accepteula -u administrator -p my-password cmd.exe /c xcopy %srcpath%\rsclient\* &amp;quot;c:\Windows\Downloaded Program Files&amp;quot; /y&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;@Rem Register DLL&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;%srcpath%\psexec.exe -u administrator -p my-password regsvr32 &amp;quot;c:\Windows\Downloaded Program Files\RSClientPrint.dll&amp;quot; /s&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;:endd&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note: This batch file uses psexec.exe from Sys Internals ([http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx][http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx)/ )] to invoke commands (cmd.exe and regsvr32.exe) under a different (administrator) account. The Windows internal runas command cannot be used because you cannot pass the password on the command line to runas. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that upon first execution of psexec.exe a EULA may be displayed to the user in a modal dialog box. To prevent this (which would stop a batch file from running in unattended mode), the command line switch /accepteula is used in the first call to psexec.exe.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Stock_Movement_Types_in_EEE&amp;diff=307</id>
		<title>Stock Movement Types in EEE</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Stock_Movement_Types_in_EEE&amp;diff=307"/>
		<updated>2009-07-11T05:59:07Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 17 November 2008. Last Reviewed: 13 July 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Stock Movement Types in EEE ==&lt;br /&gt;
The EEE table (view) StockMovementTbl (StockMovement) holds line item detail records for all stock movements. StockMovementTbl.Type is an integer column which identifies the type of each transaction.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;prettytable&amp;quot;&lt;br /&gt;
| &#039;&#039;&#039;Type&#039;&#039;&#039;&lt;br /&gt;
| &#039;&#039;&#039;Description&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 0&lt;br /&gt;
| Sale or Return (Use the sign of the quantity to determine)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 1&lt;br /&gt;
| Alternative Sale or Return (Use the sign of the quantity to determine)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 2&lt;br /&gt;
| Goods Receipt&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 3&lt;br /&gt;
| Return to Supplier&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 4&lt;br /&gt;
| Stock Transfer In/Out (Use the sign of the quantity to determine)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 5&lt;br /&gt;
| Stock Adjustment&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 6&lt;br /&gt;
| Stock take*&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 7&lt;br /&gt;
| Internal Bin Trnsfer&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 8&lt;br /&gt;
| Concept Sports Head Office Inter-store Transfer (Reserved)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 9&lt;br /&gt;
| Stock quantity adjustment (via SC record import)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
| 10&lt;br /&gt;
| Staff Uniform Sale&lt;br /&gt;
&lt;br /&gt;
|}&lt;br /&gt;
&amp;lt;nowiki&amp;gt;* Note: &amp;lt;/nowiki&amp;gt;Enabler stock takes posted to EEE by means of incremental adjustments will appear in the the StockMovementTbl table as type 5 with a StockAdjustmentReasonCode of &#039;STAKE&#039;.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note that a positive quantity in StockMovementTbl represents an inwards movement / increase of stock on hand. A negative movement represents an outward movement or decrease of stock on hand. Thus a sale, for example, will have a negative quantity in StockMovement.Quantity as it is an outward movement of stock.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Gross_Profit_and_Cost_Column_Definitions&amp;diff=215</id>
		<title>Gross Profit and Cost Column Definitions</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Gross_Profit_and_Cost_Column_Definitions&amp;diff=215"/>
		<updated>2009-04-14T00:49:49Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 14 April 2009. Last Reviewed: 14 April 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Table StockMovementTbl Cost and Gross Profit Columns ===&lt;br /&gt;
The stock movement table contains a row for every movement of stock, including a row assocaited with every sale or return line item. Except in complex cases such as multi-packs and kits, there is a 1 : 1 relationship between rows in SaleLine and StockMoveTbl. However, not all stock movement rows have associated SaleLine rows – consider stock receipts, transfers etc. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note columns prefixed with FC are in the currency local to the branch (for EEE instances supporting branches in different countries). The Non-FC version of the column has the amount in the local currency of EEE as converted using user-defined exchange rates.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The population of cost and gross profit columns in table StockMovementTbl for stock movements associated with sales is:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Cost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
FCCost * ExchangeRate&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;TotalCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This is an SQL Server computed column: isnull (ActualTotalCost, Cost*Quantity)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
SQL Server stored procedure UpdateStock looks up the configuration for the branch to determine that branch&#039;s stock valuation configuration option – i.e. WAC or list cost. Based on this configuration, the current cost for the Branch/SKU is retrieved. If this is null of $0.00, uses BuyPrice1 for the branch/SKU. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Finally, any oncost amount passed back from POS is added to this cost, however for sales POS will always return oncost of $0.00.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCTotalCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This is an SQL Server computed column: isnull (FCActualTotalCost, FCCost*Quantity)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;OnCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This is populated with the unit on-cost amount passed back from POS, always $0.00 for sales.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;ActualTotalCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
FCActualTotalCost * ExchangeRate&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCActualTotalCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
FCCost * Qty.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;AlternateGPCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Cost.AlternateGPCost except client code 22 which uses BuyPrice1 for warehouse branch &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== View vwSaleLine_GP Cost and Gross Profit Columns ===&lt;br /&gt;
This view combines sales data from table SaleLine with stock cost data from table StockMovement to provide the most accurate possible GP reporting. In the column descriptions below, “if available” means if a matching stock movement row is found for the SaleLine. In some cases the StockMovement row might be missing, for example in the minimallyt supported scenario where sales are recognised upon creation of a customer order or layby, but stock is not decremented until the order or layby is completed. In such case there is no StockMovement row to match the Sale, therefore no strictly accurate cost or GP is available.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;ExtendedCostAmount&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If available, StockMovementTbl.TotalCost else SaleLine.ExtendedCostAmount.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;GrossProfit&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If available, SaleLine.ExtendedNetAmount – SaleLine.ExtendedTaxAmount – StockMovementTbl.TotalCost else SaleLine.GrossProfit.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCExtendedCostAmount&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If available, StockMovementTbl.FCTotalCost else SaleLine.FCExtendedCostAmount&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCGrossProfit&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If available, SaleLine.FCExtendedNetAmount – SaleLine.FCExtendedTaxAmount – StockMovementTbl.FCTotalCost else SaleLine.FCGrossProfit.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;ExtendedAlternateGPCostAmount&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
StockMovementTbl.AlternateGPCost * SaleLine.Quantity. However if this is NULL, as will be the case when Cost.AlternateGPCost is null, then SaleLine.ExtendedCostAmount except for client code 22 which uses Cost.BuyPrice1 for branch 99 * SaleLine.Quantity.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;GrossProfitAlternateGP &#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
SaleLine.FCExtendedNetAmount – SaleLine.FCExtendedTaxAmount – ExtendedAlternateGPCost.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;br /&gt;
[http://theoracle.magentaretail.com.au/wiki/index.php/BDE_Versions ]&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=Gross_Profit_and_Cost_Column_Definitions&amp;diff=214</id>
		<title>Gross Profit and Cost Column Definitions</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=Gross_Profit_and_Cost_Column_Definitions&amp;diff=214"/>
		<updated>2009-04-14T00:49:11Z</updated>

		<summary type="html">&lt;p&gt;Bevan: New page: Created: 14 April 2009. Last Reviewed: 14 April 2009   === Table StockMovementTbl Cost and Gross Profit Columns === The stock movement table contains a row for every movement of stock, inc...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 14 April 2009. Last Reviewed: 14 April 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Table StockMovementTbl Cost and Gross Profit Columns ===&lt;br /&gt;
The stock movement table contains a row for every movement of stock, including a row assocaited with every sale or return line item. Except in complex cases such as multi-packs and kits, there is a 1 : 1 relationship between rows in SaleLine and StockMoveTbl. However, not all stock movement rows have associated SaleLine rows – consider stock receipts, transfers etc. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Note columns prefixed with FC are in the currency local to the branch (for EEE instances supporting branches in different countries). The Non-FC version of the column has the amount in the local currency of EEE as converted using user-defined exchange rates.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The population of cost and gross profit columns in table StockMovementTbl for stock movements associated with sales is:&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;Cost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
FCCost * ExchangeRate&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;TotalCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This is an SQL Server computed column: isnull (ActualTotalCost, Cost*Quantity)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
SQL Server stored procedure UpdateStock looks up the configuration for the branch to determine that branch&#039;s stock valuation configuration option – i.e. WAC or list cost. Based on this configuration, the current cost for the Branch/SKU is retrieved. If this is null of $0.00, uses BuyPrice1 for the branch/SKU. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Finally, any oncost amount passed back from POS is added to this cost, however for sales POS will always return oncost of $0.00.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCTotalCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This is an SQL Server computed column: isnull (FCActualTotalCost, FCCost*Quantity)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;OnCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This is populated with the unit on-cost amount passed back from POS, always $0.00 for sales.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;ActualTotalCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
FCActualTotalCost * ExchangeRate&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCActualTotalCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
FCCost * Qty.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;AlternateGPCost&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Cost.AlternateGPCost except client code 22 which uses BuyPrice1 for warehouse branch &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== View vwSaleLine_GP Cost and Gross Profit Columns ===&lt;br /&gt;
This view combines sales data from table SaleLine with stock cost data from table StockMovement to provide the most accurate possible GP reporting. In the column descriptions below, “if available” means if a matching stock movement row is found for the SaleLine. In some cases the StockMovement row might be missing, for example in the minimallyt supported scenario where sales are recognised upon creation of a customer order or layby, but stock is not decremented until the order or layby is completed. In such case there is no StockMovement row to match the Sale, therefore no strictly accurate cost or GP is available.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;ExtendedCostAmount&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If available, StockMovementTbl.TotalCost else SaleLine.ExtendedCostAmount.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;GrossProfit&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If available, SaleLine.ExtendedNetAmount – SaleLine.ExtendedTaxAmount – StockMovementTbl.TotalCost else SaleLine.GrossProfit.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCExtendedCostAmount&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If available, StockMovementTbl.FCTotalCost else SaleLine.FCExtendedCostAmount&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;FCGrossProfit&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
If available, SaleLine.FCExtendedNetAmount – SaleLine.FCExtendedTaxAmount – StockMovementTbl.FCTotalCost else SaleLine.FCGrossProfit.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;ExtendedAlternateGPCostAmount&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
StockMovementTbl.AlternateGPCost * SaleLine.Quantity. However if this is NULL, as will be the case when Cost.AlternateGPCost is null, then SaleLine.ExtendedCostAmount except for client code 22 which uses Cost.BuyPrice1 for branch 99 * SaleLine.Quantity.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&#039;&#039;&#039;GrossProfitAlternateGP &#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
SaleLine.FCExtendedNetAmount – SaleLine.FCExtendedTaxAmount – ExtendedAlternateGPCost.&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=BDE_Versions&amp;diff=206</id>
		<title>BDE Versions</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=BDE_Versions&amp;diff=206"/>
		<updated>2009-03-16T05:20:24Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 16 March 2009. Last Reviewed: 16 March 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. The BDE is a common, shared program component which may be utilitised by other applications.&lt;br /&gt;
&lt;br /&gt;
There are many versions of the BDE. Depending on when your Enabler was originally installed, your BDE version should be either 5.01, 5.11 or 5.2.&lt;br /&gt;
&lt;br /&gt;
It is possible for a third party application installed on the same computer to install a different version of the BDE. To determine your current BDE version:&lt;br /&gt;
&lt;br /&gt;
# Determine where the BDE program files are installed:&lt;br /&gt;
## The BDE is commonly installed in &amp;lt;tt&amp;gt;C:\Program Files\Common Files\Borland Shared\bde&amp;lt;/tt&amp;gt;&lt;br /&gt;
## To be sure, load the Registry Editor regedit.exe.&lt;br /&gt;
## Navigate to the key HKEY_LOCAL_MACHINE\Software\Borland\Database Engine&lt;br /&gt;
## The value of DLLPath is the directory where the BDE is installed.&lt;br /&gt;
# In Windows Explorer, navigate to this directory and locate the file IDAPI32.DLL.&lt;br /&gt;
# Right-click this file and choose Properties.&lt;br /&gt;
# Switch to the tab that displays file version information. Depending on your version of Windows this might be called Details or Version Info or similar.&lt;br /&gt;
# The first 3 parts of the 4-part version number show the BDE version. E.g. 5.0.1.x or 5.1.1.x or 5.2.0.x.&lt;br /&gt;
&lt;br /&gt;
If your BDE version is different from the above, please contact Magenta Support to discuss your options.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;br /&gt;
[http://theoracle.magentaretail.com.au/wiki/index.php/BDE_Conflicts BDE Conflicts].&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=BDE_Conflicts&amp;diff=205</id>
		<title>BDE Conflicts</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=BDE_Conflicts&amp;diff=205"/>
		<updated>2009-03-16T05:19:25Z</updated>

		<summary type="html">&lt;p&gt;Bevan: New page: Created: 16 March 2009. Last Reviewed: 16 March 2009   Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. The BDE is a commo...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 16 March 2009. Last Reviewed: 16 March 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. The BDE is a common, shared program component which may be utilitised by other applications.&lt;br /&gt;
&lt;br /&gt;
It is possible for the BDE to enter a temporary, unstable state. This may occur if one Enabler application terminates (or is terminated) abnormally, preventing it from properly disconnecting from the BDE. We have also observed upon rare occasions that third party applications that use the BDE may prevent Enabler from accessing the BDE. This has been observed in relation to a service known as “Insight Manager” which is part of a server monitoring toolset from HP.&lt;br /&gt;
&lt;br /&gt;
=== Symptoms: ===&lt;br /&gt;
# Enabler applications already running may freeze and become totally unresponsive. Typically the application is consuming no CPU resource when viewed in Task Manager.&lt;br /&gt;
# Enabler applications may fail to load. Upon attempting to start an Enabler application, nothing appears to happen. In Task Manager the EXE can be seen in the process list. The application user interface is never displayed.&lt;br /&gt;
# In these cases, the BDE Administration Utility (BDEADMIN.EXE) is generally also unable to be loaded.&lt;br /&gt;
&lt;br /&gt;
=== To Resolve This Issue: ===&lt;br /&gt;
# Forcibly close any Enabler applications from Task Manager process list:&lt;br /&gt;
## Press Shift+Ctrl+ESC to invoke Task Manager, or use Ctrl+ALT+DELETE and choose Start Task Manager.&lt;br /&gt;
## Locate NIBBLE.EXE, WINPOS.EXE and INFOCTRL.EXE. &#039;&#039;Hint: Click image name at the top of the list to sort alphabetically. &#039;&#039;&lt;br /&gt;
## For each the above processes found, click the image name in the process list then click End Process (and confirm when prompted).&lt;br /&gt;
## Double-check to ensure all the above processes have been removed from the process list.&lt;br /&gt;
## If any other processes are known to use the BDE, close those programs or forcibly terminate through Task Manager (forcibly terminate third party applications at your own risk!).&lt;br /&gt;
## Try starting Enabler applications as normal.&lt;br /&gt;
# If the problem is not resolved or if you have reason to suspect that some other application may be using the BDE:&lt;br /&gt;
## Obtain Process Explorer (PROCEXP.EXE) from Sys Internals ([http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx][http://technet.microsoft.com/en-us/sysinternals/bb545027.aspx)/ )]. &lt;br /&gt;
## Run procexp.exe&lt;br /&gt;
## From the Find menu, choose “Find File Handle or DLL”&lt;br /&gt;
## At the “Handle or dll substring” prompt enter IDAPI32.DLL and click Search.&lt;br /&gt;
## If any process is using the BDE, it will be listed in the search results. The search may take a minute or two to complete.&lt;br /&gt;
## If any processes are shown, identify the application that owns the process and try to stop the application. Note – the BDE can also be used by Windows services. Note – the process that directly accesses the BDE might be a child process of the offending application. Check if the listed process(es) has a parent process.&lt;br /&gt;
## If necessary, you might have to forcibly terminate such processes. Do this at your own risk!&lt;br /&gt;
## Retry the Enabler applications.&lt;br /&gt;
## When third party applications are found to conflict with Enabler, you may need to contact Magenta to discuss your options.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;br /&gt;
[http://theoracle.magentaretail.com.au/wiki/index.php/BDE_Versions BDE Versions].&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=BDE_Versions&amp;diff=204</id>
		<title>BDE Versions</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=BDE_Versions&amp;diff=204"/>
		<updated>2009-03-16T05:18:42Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 16 March 2009. Last Reviewed: 16 March 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. The BDE is a common, shared program component which may be utilitised by other applications.&lt;br /&gt;
&lt;br /&gt;
There are many versions of the BDE. Depending on when your Enabler was originally installed, your BDE version should be either 5.01, 5.11 or 5.2.&lt;br /&gt;
&lt;br /&gt;
It is possible for a third party application installed on the same computer to install a different version of the BDE. To determine your current BDE version:&lt;br /&gt;
&lt;br /&gt;
# Determine where the BDE program files are installed:&lt;br /&gt;
## The BDE is commonly installed in &amp;lt;tt&amp;gt;C:\Program Files\Common Files\Borland Shared\bde&amp;lt;/tt&amp;gt;&lt;br /&gt;
## To be sure, load the Registry Editor regedit.exe.&lt;br /&gt;
## Navigate to the key HKEY_LOCAL_MACHINE\Software\Borland\Database Engine&lt;br /&gt;
## The value of DLLPath is the directory where the BDE is installed.&lt;br /&gt;
# In Windows Explorer, navigate to this directory and locate the file IDAPI32.DLL.&lt;br /&gt;
# Right-click this file and choose Properties.&lt;br /&gt;
# Switch to the tab that displays file version information. Depending on your version of Windows this might be called Details or Version Info or similar.&lt;br /&gt;
# The first 3 parts of the 4-part version number show the BDE version. E.g. 5.0.1.x or 5.1.1.x or 5.2.0.x.&lt;br /&gt;
&lt;br /&gt;
If your BDE version is different from the above, please contact Magenta Support to discuss your options.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;br /&gt;
[http://theoracle.magentaretail.com.au/wiki/index.php/BDE_Conficts BDE Conflicts].&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=BDE_Versions&amp;diff=203</id>
		<title>BDE Versions</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=BDE_Versions&amp;diff=203"/>
		<updated>2009-03-16T05:12:30Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 16 March 2009. Last Reviewed: 16 March 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. The BDE is a common, shared program component which may be utilitised by other applications.&lt;br /&gt;
&lt;br /&gt;
There are many versions of the BDE. Depending on when your Enabler was originally installed, your BDE version should be either 5.01, 5.11 or 5.2.&lt;br /&gt;
&lt;br /&gt;
It is possible for a third party application installed on the same computer to install a different version of the BDE. To determine your current BDE version:&lt;br /&gt;
&lt;br /&gt;
# Determine where the BDE program files are installed:&lt;br /&gt;
## The BDE is commonly installed in &amp;lt;tt&amp;gt;C:\Program Files\Common Files\Borland Shared\bde&amp;lt;/tt&amp;gt;&lt;br /&gt;
## To be sure, load the Registry Editor regedit.exe.&lt;br /&gt;
## Navigate to the key HKEY_LOCAL_MACHINE\Software\Borland\Database Engine&lt;br /&gt;
## The value of DLLPath is the directory where the BDE is installed.&lt;br /&gt;
# In Windows Explorer, navigate to this directory and locate the file IDAPI32.DLL.&lt;br /&gt;
# Right-click this file and choose Properties.&lt;br /&gt;
# Switch to the tab that displays file version information. Depending on your version of Windows this might be called Details or Version Info or similar.&lt;br /&gt;
# The first 3 parts of the 4-part version number show the BDE version. E.g. 5.0.1.x or 5.1.1.x or 5.2.0.x.&lt;br /&gt;
&lt;br /&gt;
If your BDE version is different from the above, please contact Magenta Support to discuss your options.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;br /&gt;
[//bubba/CorporateShare/Company%20Documentation/Documentation/Wiki%20Master%20Docs/BDE%20Errors%20and%20Conflicts.odt BDE Conflicts].&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
	<entry>
		<id>https://theoracle.magentaretail.com.au/index.php?title=BDE_Versions&amp;diff=202</id>
		<title>BDE Versions</title>
		<link rel="alternate" type="text/html" href="https://theoracle.magentaretail.com.au/index.php?title=BDE_Versions&amp;diff=202"/>
		<updated>2009-03-16T05:02:52Z</updated>

		<summary type="html">&lt;p&gt;Bevan: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Created: 16 March 2009. Last Reviewed: 16 March 2009&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Enabler uses a technology from Borland known as the Borland Database Engine, or BDE, to access its database files. The BDE is a common, shared program component which may be utilitised by other applications.&lt;br /&gt;
&lt;br /&gt;
There are many versions of the BDE. Depending on when your Enabler was originally installed, your BDE version should be either 5.01, 5.11 or 5.2.&lt;br /&gt;
&lt;br /&gt;
It is possible for a third party application installed on the same computer to install a different version of the BDE. To determine your current BDE version:&lt;br /&gt;
&lt;br /&gt;
# Determine where the BDE program files are installed:&lt;br /&gt;
## The BDE is commonly installed in &amp;lt;tt&amp;gt;C:\Program Files\Common Files\Borland Shared\bde&amp;lt;/tt&amp;gt;&lt;br /&gt;
## To be sure, load the Registry Editor regedit.exe.&lt;br /&gt;
## Navigate to the key HKEY_LOCAL_MACHINE\Software\Borland\Database Engine&lt;br /&gt;
## The value of DLLPath is the directory where the BDE is installed.&lt;br /&gt;
# In Windows Explorer, navigate to this directory and locate the file IDAPI32.DLL.&lt;br /&gt;
# Right-click this file and choose Properties.&lt;br /&gt;
# Switch to the tab that displays file version information. Depending on your version of Windows this might be called Details or Version Info or similar.&lt;br /&gt;
# The first 3 parts of the 4-part version number show the BDE version. E.g. 5.0.1.x or 5.1.1.x or 5.2.0.x.&lt;br /&gt;
&lt;br /&gt;
If your BDE version is different from the above, please contact Magenta Support to discuss your options.&lt;br /&gt;
&lt;br /&gt;
= See Also: =&lt;br /&gt;
[#BDE Conflicts BDE Conflicts].&lt;/div&gt;</summary>
		<author><name>Bevan</name></author>
	</entry>
</feed>