Misc tips

From time to time I would write down a tip I thought worthwhile -- now - where did I put that piece of paper I wrote that on ...? TOO bad we don;t have a searchable data base for good idea's .... since I am an absolute FAN on WIKI's you know I have repeatedly asked the IT dept all the way to Joe Z for a WIKI on Exploris ...

anyways -- here are some tips I had written down over the years .... send a comment if you see something I have missed...

>VERIFY that End of Month ran well

We had an End of Month have a problem that we don't see until te next day. The resulting action of running the end of month during business hours SIGNIFICANTLY slowed down POS - to a point that many thought their terminal or printer was frozen - but it was just that CPU intensive

Do we want to start End Of Month early and see if it ran well?
-if so -- log in after an hour ( guess ) and look at 9-6 --- do for ALL stores separately ( if you are multi store ) ---if you get a status of 1 (one) it has yet to start that store --you want to see a status of 87 to know all is well ( do NOT change any status .... hint then you can check 8.3 and see if all are complete - this is the product and customer file rolls
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

> killterm kbxx to kill a frozen terminal
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
** Break points for movement codes
35 25 15 10 6 4 3 2 = 100 for all 8 codes
used in 3-13 mvt code build
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> force printing for more labels
8-15-2-9 option # 3 and make sure you go all the way thru to print

> clear Corupted Part Chain -- 8-15 3-2 ( this also removes duplicate parts - Re-Hash - run monthly ?? along with 3-14 re-sort -- needs to be run after hours but in a pinch on our fast system we can usually get it in live time

Note --we have a complete check list for end of month --send me an e-mail and I can forward copy in .xls or .pdf
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>To change the time in the J-Con simply:
Exit menu
TYPE - asktime
ENTER - correct time in military style( i.e. 4:30PM = 1630) no dots or spaces should be entered
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Stock Level move-ups
2.19 - see what levels are set at by sub-line
3.9 change any stock levels required
11.2 (or 8.15 3* 21 for right away ) for tomorrow add missing sku's
3.5 forcast
2.7 report of changes
3.7 set changes ( or 3.3 or 3.18 manual set changes by part )
2.13 manual return ( this is not automatic on end of day
7.1 do order ( or wait for end of day
NOTE -- Greg's way with Excel is SO MUCH easier ( drop e-mail for more info )
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>to check how full hard drive is
> sys/d
read the du0 line
>sys/d
Current disk status
Mount Dir Filesystem blocks used free %used
/ /dev/root 1000000 522848 477152 53%
/stand /dev/boot 40000 23068 16932 58%
/sds /dev/sds 1000000 108626 891374 11%
/du0 /dev/du0 32224684 5677832 26546852 18%
/cd0 /dev/cd0 322936 322936 0 100%
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

> how to FIX a broken connection to Warehouse

if bad router daemon ( shown at top of screen )
shell out ( exit J-Con )
> restart_comm (cr)
wait a minute for '>' to come back
type reg then (cr) - do 5 times ( to be sure - you are logging back in to aconnextx server )

Now you should be good to go and can order from the warehouse or superstore ... and your FAST-LINK customers can now order again
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

J-Con Tricks #2
> how to FORCE a update to warehouse

8-15 #10 - # 8 to send request file NOW
#4 for CCInet
submit a file for transfer ( 1st option )
poll a node
DSID # -- is TOR001 for our warehouse
Type: is POLL

hit F-10 to send file
hit F-9 to back out

Reprint more price labels in J-Con
say you want to re-do price labels for a line ...
8-15 menu
- 2 ( inventory)
- 9 price labels
- 3 label utilities for shelf labels (do not use 1,2 or 4)
- enter defaults ( enter = default ) until you get to the name of the line you want
- enter one or more lines
- enter = screen
then end when you are done
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
DISPLAY LOCATION
999 = price labels

100 = price sensitive items we need to review ( test 4-07 )
we set special items that are very price sensetive at 100 so we can sort in Excel and review
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Function keys - J-Con
got your won terminal emulator program you want to try ( good luck ) - here are the function key formulas
F1 esc OP
F2 esc OQ
F3 esc OR
F4 esc OS
F5 esc OT
F6 esc OU
F7 esc OV
F8 esc OW
F9 esc OX
F10 esc OY
F11 esc OZ
F12 [24~

getting it from J-Con to Excel

OK -- so you got Multi-View installed and working on a PC
-- and you have the red and black record buttons showing
-- and you have set the column width to 132 ... lets go get some data

Try an easy report to record ? Say a 2-19 or a 6-4 report? Anything as a test.

Save the report on your PC where you will remember to find it,

Open Excel -- hey -- you can't find it ... change excel setting to open ANY file type --and now you file shows up. See Image#1

Excel says --what do I do with this ?? You have two options -- open with some de-limiters ( can be a comma or a tab or ? ) or open as fixed width and you will cut into columns. One way we handle new reports is to open as delimited - using the default tab as delimiter ... and the J-Con will open as the report with no action ( as you have no embedded tabs in the report) See Image #2

How does your report look? Image #3 shows the report in a 'normal' font - like Arial -- but it looks sloppy - nothing lines up

Change your font to a 'non-proportional' font like COURIER and all of a sudden the report lines up. Image #4

Remember we didn't chop up the report when we first opened it -- now we can using "DATA" then "Text to columns" in Excel See Image #5

Now it is in Excel - next post will give us some more tips on what you can do

Version 65

A tidbit of info - most of us are on some version of v60. There is a v65 that has several nice features. There where also some big problems --although they are probably handled -as a couple of CARQUEST jobbers in Quebec are running v65.

I have some doc's on what v65 does -- will trade for beer