What are the formats of the fields?

None of the fields will accept either a comma or an & within the CSV file. The expected formats for each of the fields are detailed below;

JOBS

  • Job Number - This must be a unique job identifier and therefore can not exist within the system prior to upload. The field will accept a maximum of 45 and minimum of 1 alphanumeric characters.
  • Address 1 - The minimum number of characters for this field is 1 and a maximum of 45 alphanumeric characters.
  • Address 2 - There is no minimum number of characters for this field but there is a maximum of 45 alphanumeric characters.
  • Address 3 - There is no minimum number of characters for this field but there is a maximum of 45 alphanumeric characters.
  • Address 4 - There is no minimum number of characters for this field but there is a maximum of 45 alphanumeric characters.
  • Post Code - The minimum number of characters for this field is 1 and a maximum of 45 alphanumeric characters.
  • Timeslot - This should match a format of "DD/MM/YYY HH:MM:SS" and must be within the future.
  • Contact Name - The minimum number of characters for this field is 1 and a maximum of 45 alphanumeric characters.
  • Contact Number 1 - The contact number must be a valid phone number.
  • Contact Number 2 - The contact number must be a valid phone number.
  • Special Instructions - There is no minimum number of characters for this field but there is a maximum of 255 alphanumeric characters.
  • Fault - There is no minimum number of characters for this field but there is a maximum of 255 alphanumeric characters.
  • Products - There is no minimum number of characters for this field but there is a maximum of 255 alphanumeric characters.
  • Username - This must be the username of a mobile user that already exists within the system as it is defined within the system.

CUSTOMERS

  • Customer Name - This must be the name of the customer. The field will accept a maximum of 255 characters.
  • Contact Name - This is the name of the main contact for the customer. The field will accept a maximum of 45 characters.
  • Address 1 - The minimum number of characters for this field is 1 and a maximum of 45 alphanumeric characters.
  • Address 2 - There is no minimum number of characters for this field but there is a maximum of 45 alphanumeric characters.
  • Address 3 - There is no minimum number of characters for this field but there is a maximum of 45 alphanumeric characters.
  • Address 4 - There is no minimum number of characters for this field but there is a maximum of 45 alphanumeric characters.
  • Post Code - The minimum number of characters for this field is 1 and a maximum of 45 alphanumeric characters
  • Contact Number - This is the contact number of the customer and has a maximum of 45 characters and no minimum.

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.