Lunch & Learn

1. Lunch & Learn WELCOME! Don VonderBurg Laura Schultz

2. Outline • JEN – New features Laura • Becoming a JXI Expert Don • Corp Business Plan – Don & Laura • Online Catalog Sneak Preview!

3. Topics • Features and Benefits of JXI • Old data vs. newer Cleaned up JXI • U?ing w=ld cards to your %dvantage • Understanding the numbers game and reverse searching • How to efficiently copy information from JXI to other applications • What does the future hold for JXI • XML, Pricing, Vendor Information, etc.

4. Features and Benefits of JXI • One box searches models and parts • Pricing on many of the non-stock items • Wildcard and advance searches • Copy features • No need to wait for CD or download updates • Tell-Corp messages • Reverse searches • Links to on-line catalog pages • C99 and Manufacturer ordering information • Not dependant on system or external programming for features • Cleaner database and more reliable.

5. The cleanup • Many of the items in the old database that crossed to Johnstone were wrong • These crosses could not be confirmed quickly • Restructured cross to Johnstone items by manufacturer numbers only • Slowly by help of Stores information is getting cleaner

6. Old search for EM328

7. Cleaned up search or EM328

8. Tips on Searching • Search – Select – Results • Everything is a begin with search • Wildcard searches ?,=,% • Narrow search • Dash and Zero’s.

9. Wildcard Searching The Default search method is a “begin with” search. For example to find “9540N115” use “9540”. This will also find “95405” and “9540A27”

10. Wildcard Searching All numbers can be searched with or without the Dashes. Searching the number "9540"will return "95405"as well as "954-036"and "954-028"

11. Wildcard Searching All numbers can be searched by using the letter O or the number 0. Searching the number "OCB1036" can also be found by typing in (zero) "0CB1O36"

12. Wildcard Searching The % is used as the replacement of many characters. To find the number "AB9540N115" use "%9540"

13. Wildcard Searching The ? is used as a single character replacement. If you have an item that the 5th character is difficult to read, you can replace that character with the "?". For example "9540?115" will return "9540N115" and "9540A115".

14. Wildcard Searching You can use more than one ? to find an item. For example "95???115" will return "9540N115"  "9540A115" but not "9540N115A".

15. Wildcard Searching You can use the ? and the % in combination. Searching "954??11%" will return "9540N115" and "9540A115" and "9540N115A"

16. Wildcard Searching The = is used to find an exact match. For example, searching "A100" finds all items that begin with "A100", i.e "A1003","A100Z", etc. Using "=A100" will only find all numbers that are "A100".

17. Reverse Search made Simple

18. Reverse Search made Simple • If A = B • And B = C • Then C = A • So A, B and C are the same?

19. Reverse Search made Simple • B can replace A • C can replace B or A • A cannot replace C or B • Unless C or B was using only one side of the sequence • So A, B, and C are not always the same! • Reverse search shows the A to C or B relations.

20. Copy to Clipboard

21. The Future of JXI • Store pricing matrix • XML calls to vendors • Drop-down features NEW TO .NET 2.0! • Other types of Cross Information Tools • Motor Source • Compressor resource

22. Questions?

23. Online Catalog • Current Corp website is old, unstable • Feb 2006, Board approval to revamp Corp Website / Online Catalog • Board decision RE: Online Ordering funding will occur on June 2006 • What does this mean to you….?

24. Sneak Preview • www.projectcentralteam.com/johnstone/alpha

25. Corp Website / Online Catalog - RECAP • Board Decision in June 2006 RE: Online Ordering • Summer 2006 “new” Corp Website available • Based on what we know now - Fall 2006, if ordering approved