First Shift
Notes on first shift within the IT department
-
Balancing the proc-sales with jrun->smantest / smantest3
These are instructions on what to do when the smantest / smantest3 does not balance and a value is presented after running the program. jrun fmsman, option I, then put in sales # and week 0. Once you're looking at the data in week 0 you have to hit N to get to the next section, from there you will use option C, then the sales # and the current week. There you'll be able to edit field 56 (for smantest) and field 40 (for smantest3). For smantest you take the value of CATG - WKLY and subtract it from field 56 and enter that value into field 56. So if the CATG - WKLY value is a negative number you add the absolute value
-
If a route is missing from Extendata, but has been approved in Unix
Sign into Unix cd over to /users/data/extendata/uploaded run the following command in that directory ls -l *routeNum* replace the route number with the actual numeric value FTP all displayed files to your local machine use an FTP client like filezilla to move all the files to your local machine These will include: AssignNHBrouteNum DetailNHBrouteNum LabelNHBrouteNum LoadNHBrouteNum TicketNHBrouteNum TripsheetNHBrouteNum They may potentially include also: HazmatNHBrouteNum The extra file / files may or may not exist, depending if the truck has that type of material. IE, if there is no hazardous material on this route You must rename each file so it is slightly different from the version that failed to upload You can do this by changing the last value in the file name (before the .csv) to be a 1, or if the value is already 1, change it to a 2 we have to do this because extendata prevents duplicate file names from being processed, so if you do not change the file name, this entire process will not work Using your FTP client, change your UNIX directory to: /users/data/extendata/staged Using a TinyTerm session, run the following commands: cd /users/data/extendata/staged - IF YOU DO NOT DO THIS, YOU WILL HAVE A VERY BAD DAY. DO NOT RUN THE NEXT COMMAND WITH KNOWING YOU ARE IN THE CORRECT DIRECTORY. chmod +rw * You're done! An automated script checks this directory every 10 seconds to see if there is a new file to upload to the server. Extendata then will take a minute or two to process the file, and you will be able to see this on the website.