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
1. ls -l *routeNum*
2. replace the route number with the actual numeric value
FTP all displayed files to your local machine
1. use an FTP client like filezilla to move all the files to your local machine
2. These will include:
  1. AssignNHBrouteNum
  2. DetailNHBrouteNum
  3. LabelNHBrouteNum
  4. LoadNHBrouteNum
  5. TicketNHBrouteNum
  6. TripsheetNHBrouteNum
3. They may potentially include also:
  1. HazmatNHBrouteNum
4. 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
1. 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
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:
1. 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.
2. chmod +rw *
You're done!
1. 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.