HomeTutorialsHandheld SolutionModifying Handheld Queries
 

Modifying Handheld Queries


Overview

The query screens in the handheld solution are processed by taking the XML produced by the SYSPRO query business objects and passing it through an XSL translation file to form HTML.  The HTML is then paired with a CSS file to add the desired formatting and colors.  See the overview below followed by the detailed steps to accomplish Handheld solution query modifications.

 Handheld modify queries overview


Locating the query XSL file

XSL stands for EXtensible Stylesheet Language.  XSL "template" files are style sheets for XML in a similar way as CSS files are style sheets for HTML.  To understand more about XSL, see the many tutorials found on the Internet, such as at W3Schools.

The XSL and CSS files are used to format and populate the Handheld solution query screens.  The associated XSL and CSS files are stored in the Queries folder under the default handheld folder on the server.  To find the default handheld folder, run the Shipping/Handheld system setup or select Run a program (Ctrl+R), type-in and run EDISHP, then find the path under the Import/Export tab as shown below:

   

In the above example, the path to the XSL and CSS files for Handheld queries would be located in the C:\SYSPRO7\Handhelds\Query folder.  In this folder, each XSL file used for formatting a Handheld query has file name whose purpose should be apparent from the file name, such as, InvQuery.xsl for the inventory query, BinQuery.xsl for the bin query, and so on.  Query.css is the main CSS file where, as seen below, CSS is used to style the colors and borders of the Handheld query screens.

Handheld query files path exampleHandheld query CSS main file

Note:  for the purposes of query modifications, disregard the XSL 6-character files names found in this Query folder, such as IMPTMB.XSL, as these XSL files are used internally and are associated with the "Last" button display on the Handheld direct modules, such as "Direct Stock Take" or "Direct Receiving".

Copy the query XSL file to the Query\Local folder

In the following example, the goal is to add the Stocking Unit of Measure (UOM) to the Stock Code query screen.

To modify a query, first copy the default version from the Query folder to the Query\Local folder. No changes should be made in the default Query folder as these will get overwritten by future updates.

Locate the query business object XML output

SYSPRO business objects are used to interface with SYSPRO.  Business objects consume text in the form of XML and return text in the form of XML.  The Handheld solution sends XML to business objects to query desired information and receives the data (in XML form) back from the business object.  Any information available in the query business object can be presented on the Handheld screen.  Understanding business objects and the XML produced from them is key to modifying XSL file for query modifications.  For more details about business objects, see the SYSPRO documentation or contact the SYSPRO dealer.  

Query modification example

Then modify the XSL file as desired to add, remove, reformat fields, changing wording, and so on.


 

Why CADACUS SOLUTIONS FOR SYSPRO?

Since 1991, as developer of the standard EDI, Shipping, and Freight Calculator Solutions for SYSPRO, our products are fully integrated with SYSPRO and drive efficiencies for hundreds of users worldwide.

Why SYSPRO?

For 35 years, SYSPRO has had a single product focus resulting in an award-winning ERP system with a track record of success for over 14,000 customers worldwide.