cynthia
Opening csv files automatically with excel can corrupt the downloaded csv files and cause data to be shifted into the wrong columns. Depending on your browser and operating system, there are many different ways to prevent these files being opened automatically in Excel.
Opening csv files automatically with excel can corrupt the downloaded csv files and cause data to be shifted into the wrong columns. Depending on your browser and operating system, there are many different ways to prevent these files being opened automatically in Excel.
Opening csv files automatically with excel can corrupt the downloaded csv files and cause data to be shifted into the wrong columns. Depending on your browser and operating system, there are many different ways to prevent these files being opened automatically in Excel.
Opening csv files automatically with excel can corrupt the downloaded csv files and cause data to be
From the choices in the “File origin” drop-down menu (1) select **65001: Unicode (UTF-8)**. From the choices in the “Delimiter” drop-down menu (2) select **Comma** :numref:`select_Excel_window2`
From the choices in the “File origin” drop-down menu (1) select **65001: Unicode (UTF-8)**. From the choices in the “Delimiter” drop-down menu (2) select **Comma** :numref:`select_Excel_window2`
Applying zoning means that destinations can be linked automatically by zone, but the route is not optimized. You can reorder your routes manually (see `Ordonnancement manuel_`) or optimize them automatically (see `Optimisation automatique_`).
From the choices in the “File origin” drop-down menu (1) select **65001: Unicode (UTF-8)**. From the choices in the “Delimiter” drop-down menu (2) select **Comma** :numref:`select_Excel_window2`
Applying zoning means that destinations can be linked automatically by zone, but the route is not op
“Extra stops” can be unplanned destinations, departure and arrival stores, rest breaks and unchecked stops. “Columns” are the information contained in the routes. If information is not needed in the export, you can drag-and-drop it in the “Skip” box. If you click and hold on the information then slide it across to the gray “Skip” area, that column is removed from the export. See the explanatory video. The spreadsheet format is CSV (Comma Separated Value) format for a standard or Excel spreadsheet program.
“Extra stops” can be unplanned destinations, departure and arrival stores, rest breaks and unchecked stops. “Columns” are the information contained in the routes. If information is not needed in the export, you can drag-and-drop it in the “Skip” box. If you click and hold on the information then slide it across to the gray “Skip” area, that column is removed from the export. See the explanatory video. The spreadsheet format is CSV (Comma Separated Value) format for a standard or Excel spreadsheet program.
None
AA. (as per example) date all positions: Shows the dates of each status shown for a mission. AB. (as per example) comment found: Shows the comment written during the mission. AC. (as per example) lat found: Shows the latitude of the point identified on the map during the mission. AD. (as per example) lng found: Shows the longitude of the point identified on the map during the mission. AE. (as per example) road found: Shows the detail or the new road identified during the mission. AF. (as per example) addition found: Shows additional address information identified during the mission. AG. (as per example) postal code found: Shows the postal code identified during the mission. AH. (as per example) city found: Shows the city identified during the mission. AI. (as per example) state found: Shows the state identified during the mission. AJ. (as per example) country found: Shows the country identified during the mission. AK. (as per example) photos found: Shows the URL (web address) where to find the photos taken during the mission. AL. (as per example) signature found: Shows the URL (web address) for the image of the signature captured during the mission. AM. (as per example) signature name found: Indicates the name of the person who signed. AN. (as per example) tag IDs all temperatures: Shows the ID for the temperatures taken during the mission. AO. (as per example) latest values all temperatures: Shows the last temperature taken at the end of the mission. AP. (as per example) date all temperatures: Shows the date of each temperature reading. AQ. (as per example) units all temperatures: Shows the unit in which the temperature was taken. AR. (as per example) violations all temperatures: Indicates the number of times the temperature overshot. AS. (as per example) link to details all temperatures: Shows the URL for the page containing the temperature readings. AT. (as per example and following) quantity[nameUnitDeliverable]: Shows the quantity of the unit to deliver and, in square brackets, the name of that deliverable unit. AU. (as per example and following) quantity found[nameUnitDeliverable]: Shows the quantity of the unit delivered or collected and, in square brackets, the name of that deliverable unit.
AA. (as per example) date all positions: Shows the dates of each status shown for a mission. AB. (as per example) comment found: Shows the comment written during the mission. AC. (as per example) lat found: Shows the latitude of the point identified on the map during the mission. AD. (as per example) lng found: Shows the longitude of the point identified on the map during the mission. AE. (as per example) road found: Shows the detail or the new road identified during the mission. AF. (as per example) addition found: Shows additional address information identified during the mission. AG. (as per example) postal code found: Shows the postal code identified during the mission. AH. (as per example) city found: Shows the city identified during the mission. AI. (as per example) state found: Shows the state identified during the mission. AJ. (as per example) country found: Shows the country identified during the mission. AK. (as per example) photos found: Shows the URL (web address) where to find the photos taken during the mission. AL. (as per example) signature found: Shows the URL (web address) for the image of the signature captured during the mission. AM. (as per example) signature name found: Indicates the name of the person who signed. AN. (as per example) tag IDs all temperatures: Shows the ID for the temperatures taken during the mission. AO. (as per example) latest values all temperatures: Shows the last temperature taken at the end of the mission. AP. (as per example) date all temperatures: Shows the date of each temperature reading. AQ. (as per example) units all temperatures: Shows the unit in which the temperature was taken. AR. (as per example) violations all temperatures: Indicates the number of times the temperature overshot. AS. (as per example) link to details all temperatures: Shows the URL for the page containing the temperature readings. AT. (as per example and following) quantity[nameUnitDeliverable]: Shows the quantity of the unit to deliver and, in square brackets, the name of that deliverable unit. AU. (as per example and following) quantity found[nameUnitDeliverable]: Shows the quantity of the unit delivered or collected and, in square brackets, the name of that deliverable unit.
AA. (as per example) date all positions: Shows the dates of each status shown for a mission. AB. (as per example) comment found: Shows the comment written during the mission. AC. (as per example) lat found: Shows the latitude of the point identified on the map during the mission. AD. (as per example) lng found: Shows the longitude of the point identified on the map during the mission. AE. (as per example) road found: Shows the detail or the new road identified during the mission. AF. (as per example) addition found: Shows additional address information identified during the mission. AG. (as per example) postal code found: Shows the postal code identified during the mission. AH. (as per example) city found: Shows the city identified during the mission. AI. (as per example) state found: Shows the state identified during the mission. AJ. (as per example) country found: Shows the country identified during the mission. AK. (as per example) photos found: Shows the URL (web address) where to find the photos taken during the mission. AL. (as per example) signature found: Shows the URL (web address) for the image of the signature captured during the mission. AM. (as per example) signature name found: Indicates the name of the person who signed. AN. (as per example) tag IDs all temperatures: Shows the ID for the temperatures taken during the mission. AO. (as per example) latest values all temperatures: Shows the last temperature taken at the end of the mission. AP. (as per example) date all temperatures: Shows the date of each temperature reading. AQ. (as per example) units all temperatures: Shows the unit in which the temperature was taken. AR. (as per example) violations all temperatures: Indicates the number of times the temperature overshot. AS. (as per example) link to details all temperatures: Shows the URL for the page containing the temperature readings. AT. (as per example and following) quantity[nameUnitDeliverable]: Shows the quantity of the unit to deliver and, in square brackets, the name of that deliverable unit. AU. (as per example and following) quantity found[nameUnitDeliverable]: Shows the quantity of the unit delivered or collected and, in square brackets, the name of that deliverable unit.
AA. (as per example) date all positions: Shows the dates of each status shown for a mission. AB. (as per example) comment found: Shows the comment written during the mission. AC. (as per example) lat found: Shows the latitude of the point identified on the map during the mission. AD. (as per example) lng found: Shows the longitude of the point identified on the map during the mission. AE. (as per example) road found: Shows the detail or the new road identified during the mission. AF. (as per example) addition found: Shows additional address information identified during the mission. AG. (as per example) postal code found: Shows the postal code identified during the mission. AH. (as per example) city found: Shows the city identified during the mission. AI. (as per example) state found: Shows the state identified during the mission. AJ. (as per example) country found: Shows the country identified during the mission. AK. (as per example) photos found: Shows the URL (web address) where to
AA. (as per example) date all positions: Shows the dates of each status shown for a mission. AB. (as per example) comment found: Shows the comment written during the mission. AC. (as per example) lat found: Shows the latitude of the point identified on the map during the mission. AD. (as per example) lng found: Shows the longitude of the point identified on the map during the mission. AE. (as per example) road found: Shows the detail or the new road identified during the mission. AF. (as per example) addition found: Shows additional address information identified during the mission. AG. (as per example) postal code found: Shows the postal code identified during the mission. AH. (as per example) city found: Shows the city identified during the mission. AI. (as per example) state found: Shows the state identified during the mission. AJ. (as per example) country found: Shows the country identified during the mission. AK. (as per example) photos found: Shows the URL (web address) where to find the photos taken during the mission. AL. (as per example) signature found: Shows the URL (web address) for the image of the signature captured during the mission. AM. (as per example) signature name found: Indicates the name of the person who signed. AN. (as per example) tag IDs all temperatures: Shows the ID for the temperatures taken during the mission. AO. (as per example) latest values all temperatures: Shows the last temperature taken at the end of the mission. AP. (as per example) date all temperatures: Shows the date of each temperature reading. AQ. (as per example) units all temperatures: Shows the unit in which the temperature was taken. AR. (as per example) violations all temperatures: Indicates the number of times the temperature overshot. AS. (as per example) link to details all temperatures: Shows the URL for the page containing the temperature readings. AT. (as per example and following) quantity[nameUnitDeliverable]: Shows the quantity of the unit to deliver and, in square brackets, the name of that deliverable unit. AU. (as per example and following) quantity found[nameUnitDeliverable]: Shows the quantity of the unit delivered or collected and, in square brackets, the name of that deliverable unit.
AA. (as per example) date all positions: Shows the dates of each status shown for a mission. AB. (as