ITrack/Appraisal Extension - Revision history

Codeman: We've got internal pages to help you set up appraisals for customers

2017-06-01T21:24:32Z

We've got internal pages to help you set up appraisals for customers

← Older revision		Revision as of 16:24, 1 June 2017
Line 1:		Line 1:
	The Appraisal Extension is used to allow our products to give per-item appraisals by evaluating the item's performance to Berryhill Auctioneers' previous auctions.		The Appraisal Extension is used to allow our products to give per-item appraisals by evaluating the item's performance to Berryhill Auctioneers' previous auctions.

			== This page doesn't help you set up appraisals for a customer ==

			'''Before you dig too deeply into this page, this page lists technical specifications of the Appraisal Extension. If you are ISoft Tech Support looking to turn on (or fix) Appraisals for a customer, try these articles instead:'''

			*[[Internal:Turning_on_Auction_Appraisals]]
			*[[Internal:Fixing_Appraisals]]

	== General ==		== General ==

Dillon Sadofsky: /* Manually Retrieving Appraisals */

2017-03-23T18:37:52Z

Manually Retrieving Appraisals

← Older revision		Revision as of 13:37, 23 March 2017
Line 50:		Line 50:

	INSERT INTO `toappraise` (`company`, `session`, `timestamp`, `inventoryid`, `inventorytypeid`, `category`, `make`, `model`, `pmanufacturer`, `pmodel`, `year`) VALUES (@strProductCode, @strSession, NOW(), <inventoryid>, <inventorytypeid>, <category>, <make>, <model>, <manufacturer>, <partmodel>, <year>);		INSERT INTO `toappraise` (`company`, `session`, `timestamp`, `inventoryid`, `inventorytypeid`, `category`, `make`, `model`, `pmanufacturer`, `pmodel`, `year`) VALUES (@strProductCode, @strSession, NOW(), <inventoryid>, <inventorytypeid>, <category>, <make>, <model>, <manufacturer>, <partmodel>, <year>);

	CALL `p_appraise_session`(@strSession, @strOriginCode);		CALL `p_appraise_session`(@strSession, @strOriginCode);

Dillon Sadofsky: /* Methodology */

2015-12-07T18:05:11Z

Methodology

← Older revision		Revision as of 13:05, 7 December 2015
Line 42:		Line 42:
	In calling code, no exceptions should ever make it out of the Appraisal extension. There is logging functionality in Get/SetLastError(), as well as TriggerFailure(). Automatic failure display in general can be toggled on and off using Get/SetSuppressErrors(), and connection has had special boolean inputs to its related functions (mostly Connect()) to provide the same functionality in a limited setting.		In calling code, no exceptions should ever make it out of the Appraisal extension. There is logging functionality in Get/SetLastError(), as well as TriggerFailure(). Automatic failure display in general can be toggled on and off using Get/SetSuppressErrors(), and connection has had special boolean inputs to its related functions (mostly Connect()) to provide the same functionality in a limited setting.

			=== Manually Retrieving Appraisals ===
	Example queries for manual appraisal:		Example queries for manual appraisal:
	SET @strProductCode = <their_product_code>;		SET @strProductCode = <their_product_code>;

Dillon Sadofsky: /* Using Appraisal Data */

2015-12-07T18:04:20Z

Using Appraisal Data

← Older revision		Revision as of 13:04, 7 December 2015
Line 41:		Line 41:

	In calling code, no exceptions should ever make it out of the Appraisal extension. There is logging functionality in Get/SetLastError(), as well as TriggerFailure(). Automatic failure display in general can be toggled on and off using Get/SetSuppressErrors(), and connection has had special boolean inputs to its related functions (mostly Connect()) to provide the same functionality in a limited setting.		In calling code, no exceptions should ever make it out of the Appraisal extension. There is logging functionality in Get/SetLastError(), as well as TriggerFailure(). Automatic failure display in general can be toggled on and off using Get/SetSuppressErrors(), and connection has had special boolean inputs to its related functions (mostly Connect()) to provide the same functionality in a limited setting.

			Example queries for manual appraisal:
			SET @strProductCode = <their_product_code>;
			SET @strOriginCode = <desired_origin>; # good examples: ORIGIN_HTP_LIVE, ORIGIN_ALL_AUCTIONS, ORIGIN_LAST_YEAR

			SELECT f_open_session(@strProductCode) INTO @strSession;

			INSERT INTO `toappraise` (`company`, `session`, `timestamp`, `inventoryid`, `inventorytypeid`, `category`, `make`, `model`, `pmanufacturer`, `pmodel`, `year`) VALUES (@strProductCode, @strSession, NOW(), <inventoryid>, <inventorytypeid>, <category>, <make>, <model>, <manufacturer>, <partmodel>, <year>);
			CALL `p_appraise_session`(@strSession, @strOriginCode);

			SELECT `toappraise`.`appraisalid`, `toappraise`.`inventoryid`, `toappraise`.`itemsaffected`, `toappraise`.`value`, `toappraise`.`min`, `toappraise`.`max`, `toappraise`.`relevance`, `toappraise`.`deviance`, `metadata`.`metadataid`
			FROM `toappraise`
			LEFT JOIN `metadata` USING (`appraisalid`)
			WHERE `session` = @strSession
			GROUP BY `inventoryid`;

			SELECT f_close_session(@strSession);

	== Code ==		== Code ==

Codeman: /* General */

2014-08-08T16:09:02Z

General

← Older revision		Revision as of 11:09, 8 August 2014
Line 9:		Line 9:
	* Connection configuration data. This is usually located in the host.ini file provided with ITrack.		* Connection configuration data. This is usually located in the host.ini file provided with ITrack.
	* Company permission. This is controlled by ISoft, and those interested in being added should contact our Sales department.		* Company permission. This is controlled by ISoft, and those interested in being added should contact our Sales department.
			* The company also needs to have its product code set in the the database.

	All of these can be arranged by contacting ISoft at 1-800-929-1829.		All of these can be arranged by contacting ISoft at 1-800-929-1829.

Daytonlowell: /* General */

2011-09-29T19:39:03Z

General

← Older revision		Revision as of 14:39, 29 September 2011
Line 6:		Line 6:
	** OR any specially-build applications designed by ISoft.		** OR any specially-build applications designed by ISoft.
	* The AppraisalExtension.dll file.		* The AppraisalExtension.dll file.
			* In Pro, the user must have '''htmode''' set to '''true''' in the '''general''' section of their '''host.ini''' for the '''Appraise...''' button to appear
	* Connection configuration data. This is usually located in the host.ini file provided with ITrack.		* Connection configuration data. This is usually located in the host.ini file provided with ITrack.
	* Company permission. This is controlled by ISoft, and those interested in being added should contact our Sales department.		* Company permission. This is controlled by ISoft, and those interested in being added should contact our Sales department.

Jmckinstry: /* Permissions */

2011-01-05T00:49:31Z

Permissions

← Older revision		Revision as of 19:49, 4 January 2011
Line 131:		Line 131:
	*** toappraise		*** toappraise
	** Execute:		** Execute:
	*** f_appraise_session
	*** f_build_appraisal
	*** f_clean_old_entries		*** f_clean_old_entries
	*** f_close_session		*** f_close_session

Jmckinstry: /* Permissions */

2010-12-31T18:06:30Z

Permissions

← Older revision		Revision as of 13:06, 31 December 2010
Line 142:		Line 142:
	*** p_build_custom		*** p_build_custom
	*** p_generate_full_cache		*** p_generate_full_cache

			* `customerdb` OR `customer_stub`
			** CALL p_company_enable_appraisal(<companyID>, ('Full','HTP','Auction','None') to turn a company on or off

	=== Adding an Origin ===		=== Adding an Origin ===

Jmckinstry: /* General */

2010-12-29T20:14:35Z

General

← Older revision		Revision as of 15:14, 29 December 2010
Line 9:		Line 9:
	* Company permission. This is controlled by ISoft, and those interested in being added should contact our Sales department.		* Company permission. This is controlled by ISoft, and those interested in being added should contact our Sales department.

	All of these can be arranged by contacting ISoft.		All of these can be arranged by contacting ISoft at 1-800-929-1829.

	== Usage ==		== Usage ==

Jmckinstry: /* Database */

2010-12-24T00:26:11Z

Database

@@ Line 117: / Line 117: @@
 == Database ==
-The following are nifty rules for altering the way that appraisals are done.
+The following are nifty rules for altering the way that appraisals are done, or need to be done in order for things to work.
 === Adding an Origin ===