→ Bulk Import/Export User Guide
Contents
1. Field Description Size Required Comments 28 Package Contains 20 Yes Description will appear on the label 29 Invoice Number 255 No Will appear on the label 30 Transit Warranty 1 No Y Yes N or Blank No 31 Declared Value 4 No Mandatory if Transit Warranty Y 32 Number of Articles 2 Yes Within the Consignment 33 Total Weight 4 Yes Measured in KG s 34 Width 4 No Measured in CM s 34 Length 4 No Measured in CM s 35 Height 4 No Measured in CM s 1 None 2 UN3090 Lithium Metal Batteries 3 UN3091 Lithium Metal Batteries contained in equipment 4 UN3091 Lithium Metal Batteries packed with equipment 36 Dangerous Goods Type 1 Ne 5 UN3480 Lithium lon Batteries 6 UN3481 Lithium lon Batteries contained in equipment 7 UN3481 Lithium lon Batteries packed with equipment If field is left blank it will default to None Page 7 of 18 1 3 Bookings FREIGHT MAST3R The following table defines the format and field definitions of the FreightMaster Booking Import file Each booking record is to be on a separate line Field Description Size Required Comments 1 Booking Type 11 Yes SENDER RECEIVER THIRD_PARTY 2 Account 7 Yes If Prepaid Consignment is not populated 3 Prepaid Consignment 8 Yes ete enter the prepaid 4 No of Articles 2 Yes To be collected 5 Total Weight 2 Yes Measured in KG s 62. Prepaid E Express Saver 17 Product 1 Yes Z Airport to Airport Livestock M Newspapers R Perishable C Same Day Consolidator D Middle of the Day 18 Package Contains 20 Yes Description will appear on the label 19 Invoice Number 255 No Will appear on the label 20 Transit Warranty 1 No Y Yes N or Blank No 21 Declared Value 4 No Mandatory if Transit Warranty Y 22 Number of Articles 2 Yes Within the Consignment 23 Total Weight 4 Yes Measured in KG s 24 Width 4 No Measured in CM s Page 4 of 18 FREIGHT MAST3R Field Description Size Required Comments 25 Length 4 No Measured in CM s 26 Height 4 No Measured in CM s 1 None 2 UN3090 Lithium Metal Batteries 3 UN3091 Lithium Metal Batteries contained in equipment 27 Dangerous Goods Type 4 No 4 UN3091 Lithium Metal Batteries packed with equipment 5 UN3480 Lithium lon Batteries 6 UN3481 Lithium lon Batteries contained in equipment 7 UN3481 Lithium lon Batteries packed with equipment If field is left blank it will default to None Page 5 of 18 1 2 E Connote FREIGHT MAST3R The following table defines the format and field definitions of the FreightMaster E Connote Import file Each consignment record is to be on a separate line Field Description Size Required Comments 1 Account Number 8 Yes
3. and search for the relevant records You can then choose to bulk print standard consignments or bulk e mail e connotes Home Consignment Manifest Bookings Tools Manifest status 1 Consignment is yet to be manifested Consignment Type v Account Number v Products EXPRESS PREMIUM v Consignment Note No Article No Suburb Shipment Date From 18 06 2010 Es Shipment Date To 1806 2010 Es Status All Drafted Printed Reprinted Emailed Resent Manifested Cancelled searen prices Standard PRINTED ee S 18 06 2010 18 06 2010 EXPRESS PF 2154875 PQ250001 1 Article Found SelectAll Bulk Delete P Bulk Print Bulk E Connote You can select individual consignments to print or use the Select All button which will select all available consignments and the click on Bulk Print or Bulk E Connote To complete the process required for pick up produce a Manifest of all consignments to Page 16 of 18 FREIGHT MAST3R be collected by the AaE Retail driver for that day NB E Comnotes will automatically produce a manifest Note 500 is the maximum number of records that can be imported at a time 4 How to Export Files Click on Bulk Export from the Tools menu Select a Record Type to Export from the list Home Company Data Consignment Manifest Bookings Tools Manifest status There are no Consignments to be manifested Bulk Export Download Templates Select record type to export Select exist
4. UN3091 Lithium Metal Batteries packed with equipment 5 UN3480 Lithium lon Batteries 6 UN3481 Lithium lon Batteries contained in equipment 7 UN3481 Lithium lon Batteries packed with equipment 42 Created By 30 Username e mail address Page 12 of 18 2 2 Bookings FREIGHT MAST gt 3R The following table defines the format of the FreightMaster Bookings Export fields Field Description Size Comments 1 Pick up Date 10 DD MM YYYY 2 Booking Reference 10 3 Booking Type 11 SENDER RECEIVER THIRD_PARTY 4 On Account 7 5 Prepaid Consignment 8 6 No of Articles 2 7 Total Weight 2 8 Width 4 9 Height 4 10 Length 4 11 Pick up Time 5 HH MM 24 hour time 12 Close of Business Time 5 HH MM 24 hour time 13 Pick up Company Name 30 14 Pick up Street Address 1 30 15 Pick up Street Address 2 30 16 Pick up Street Address 3 30 17 Pick up Suburb 30 18 Pick up State 3 19 Pick up Postcode 4 20 Pick up Contact Name 30 21 Pick up Contact Number 10 22 Pick up Contact Area 30 23 Pick up E mail Address 255 24 Cost Centre 20 25 Connote Required 1 1 True 2 False 26 Receiver Company Name 30 27 Receiver Address 1 30 28 Receiver Address 2 30 29 Receiver Address 3 30 30 Receiver Suburb 30 31 Receiver State 3 32 Receiver Postcode 4 33 Receiver Contact Name 30 34 Receiver Contact Number 10 35 Receiver Contact Area 30 3
5. AaE Retail account number 2 Shipment Date 10 Yes DD MM YYYY 3 Reference 30 No Mandatory if set up at an account level 4 Delivery Instructions 255 No Will appear on the label 5 Authority to Leave 1 No Y Yes N or Blank No 6 Sender Company Name 30 Yes 7 Sender Address Line 1 30 Yes 8 Sender Address Line 2 30 No 9 Sender Address Line 3 30 No 10 Sender Suburb 30 Yes 11 Sender State 3 Yes 12 Sender Post Code 4 Yes This will be verified against AaE Retail s postcode database 13 Sender Contact Name 30 Yes 14 Sender Contact Number 10 Yes 15 Sender E mail Address 255 Yes E comnote label and manifest will be sent to this address 16 Receiver Company Name 30 Yes 17 Receiver Address Line 1 30 Yes 18 Receiver Address Line 2 30 No 19 Receiver Address Line 3 30 No 20 Receiver Suburb 30 Yes 21 Receiver State 3 Yes 22 Receiver Post Code 4 Yes This will be verified against AaE Retail s postcode database 23 Receiver Contact Name 30 Yes 24 Receiver Contact Number 10 Yes 25 Receiver E mail Address 255 Ves lied specifying the consignment details for Q Express Premium 26 Service Level 1 Yes E Express Saver Z Airport to Airport Q Express Premium S Deliver to Person K Deliver to Person Prepaid A Prepaid E Express Saver 27 Product 1 Yes Z Airport to Airport Livestock M Newspapers R Perishable C Same Day Consolidator D Middle of the Day Page 6 of 18 FREIGHT MAST gt 3R
6. Width 4 Yes If Total Weight gt 20kg 7 Height 4 Yes If Total Weight gt 20kg 8 Length 4 Yes If Total Weight gt 20kg 9 Pick up Date 10 Yes DD MM YYYY 10 Pick up Ready Time 5 Yes HH MM 24 hour time Yes HH MM 24 hour time 11 Close of Business Time 5 There must be at least one hour difference between the ready time and close of business time 12 Pick Up Company Name 30 Yes 13 Pick Up Street Address Line 1 30 Yes 14 Pick Up Street Address Line 2 30 No 15 Pick Up Street Address Line 3 30 No 16 Pick Up Suburb 30 Yes 17 Pick Up State 3 Yes 18 Pick Up Postcode 4 Yes a hier verified against AaE Retail s postcode 19 Pick Up Contact Name 30 Yes 20 Pick Up Contact Number 10 Yes 21 Pick Up Contact Area 30 Yes 22 Pick Up E mail Address 255 No praia an e mail will be sent specifying the booking 23 Cost Centre 20 No Mandatory if set up at an account level 24 Connote Required 1 No Y Yes N or Blank No 25 Receiver Company Name 30 No 26 Receiver Street Address Line 1 30 No Mandatory if Type is Receiver or Third Party 27 Receiver Street Address Line 2 30 No 28 Receiver Street Address Line 3 30 No 29 Receiver Suburb 30 No Mandatory if Type is Receiver or Third Party 30 Receiver State 3 No Mandatory if Type is Receiver or Third Party 31 Receiver Postcode 4 No Mandatory if Type is Receiver or Third Party 32 Receiver Contact Name 30 No Mandatory if Type is Receiver or Third Party Page 8 of 18 FREIGHT MAST gt R Fiel
7. 6 Receiver E mail Address 255 37 3 Party Contact Number 10 38 Creator Name 40 Username e mail address Page 13 of 18 FREIGHT MAST gt R 2 3 Address Book The following table defines the format of the FreightMaster Address Book Export fields Field Description Size Comments 1 Company Name 30 2 Location Name 30 Unique Reference 3 Address Line 1 30 4 Address Line 2 30 5 Address Line 3 30 6 Suburb 30 7 State 3 8 Postcode 4 Page 14 of 18 3 How to Import Files FREIGHT MAST gt R Click on Bulk Import from the link on the FreightMaster Home Page or from the Tools menu Select an Import Type from the drop down list i e Standard Consignment E Connote Bookings or Addresses Select a File to Import from your system folders by using the Browse button Home Company Data Consignment Manifest Bookings Tools Bulk Import Bulk Import eto the Bulk Im during tk next to important fi ter If you h cility within Freight u can use the c Import Type Select record File To Import Import Type t O The type of content that you are importing through the Bulk Import system Depending on your role certain types may not appear File The item Master To c navigate to the can import in bulk are limited by your u vithin Freight an import a maximum of 500 E Download Templates Cli
8. Consignment Number 8 4 Article Number 8 5 Consignment Status 10 OR REPRINTED RESENT or MANIFESTED 6 Consignment Type 30 STANDARD or E CONNOTE T Account Number 8 8 Reference 30 9 Delivery Instructions 255 10 Authority to Leave 1 1 True 2 False 11 Sender Location Name 30 12 Sender Address 1 30 13 Sender Address 2 30 14 Sender Address 3 30 15 Sender Suburb 30 16 Sender State 3 17 Sender Post Code 4 18 Sender Contact Name 30 19 Sender Contact Number 10 20 Sender E mail Address 255 21 Receiver Company Name 30 22 Receiver Address 1 30 23 Receiver Address 2 30 24 Receiver Address 3 30 25 Receiver Suburb 30 26 Receiver State 3 27 Receiver Post Code 4 28 Receiver Contact Name 30 29 Receiver Contact Number 10 Page 11 of 18 FREIGHT MAST gt 3R Field Description Size Comments 30 Receiver E mail Address 255 Q Express Premium S Deliver to Person K Deliver to Person Prepaid A Prepaid E Express Saver 31 Service Level 1 Z Airport to Airport Livestock M Newspapers R Perishable C Same Day Consolidator D Middle of the Day 32 Package Contains 20 33 Invoice Number 255 34 Transit Warranty 1 1 True 2 False 35 Declared Value 4 36 Number of Articles 2 37 Total Weight 4 38 Width 4 39 Length 4 40 Height 4 1 None 2 UN3090 Lithium Metal Batteries 3 UN3091 Lithium Metal Batteries contained in equipment 41 Dangerous Goods Type 1 4
9. FREIGHT MAST gt 3R STARTRACK FREIGHT MAST gt 3R Bulk Import Export User Guide 2014 Table of Contents FREIGHT MAST gt 3R Getting Started circos Aa 3 1 Import File Specifications 0c cece cece eee eens 4 1i Standard CONSIGA MENE civic o ors dene a 4 12 E CONNOCE iii in a cn 6 1 3 BOOKINGS iii a A A a 8 1 4 Address BOOK aci A ia 10 2 Export File SpecificationS o ooocococococcccccnconnnncncnnnncnnnnnrnrnnnncnrnrnrnranrrrnrnrnrnrrnannns 11 2 1 Standard CONSIGA MENE csi a te E a CEEE A ENEE 11 2 2 BOOKINGS siii de A dedi efer hentia EE as 13 2 3 Addr ss BOOK ii A ei cede 14 3 How to Import Files iii rea 15 4 How to Export Files coi ri A A 17 For further Information or Assistance please contact the FreightMaster Helpdesk Call 1800 153 000 option 1 E mail fm_helpdesk startrack com au Page 2 of 18 FREIGHT MAST gt R Getting Started For Bulk Import you need to create records according to a pre determined CSV Comma Separate Value file format which can be opened and edited within Microsoft Excel or any other spreadsheet software Templates can be downloaded from the Bulk Import screen or using the Tools menu gt Download Templates Home Company Data Consignment Manifest Bookings Tools Manifest status There are no Consignments to be manifested Download Template ithin the Bulk ened and E Account Company E User Profile Consignment Standard E C
10. ck on Next to import your file Manifest status There are no Consignments to be manifested spe to import E consignment Standard Y You will see a Confirm Your Import screen showing how many records were successfully imported and detailed reasons for any unsuccessful records i e incorrect postcode or suburb etc You will need to modify any unsuccessful records and re import them Home Company Data Consignment Manifest Bookings Tools Bulk Import Confirm Your Import Manifest status There are no Consignments to be manifested CSV File Validation Total records processed 8 8 Q0 2 ill be imported into Freight Master If you wish to make changes to this C w reflects what you would like to import pleas 8 records computer and then reimport If the list belov Data To Be Imported al l l l O 2 119935 4 11 2009 1234 Leave at Receptior Y O 3 119935 4 11 2009 1223 Deliver to Warehou O 119935 4 11 2009 1546 Y Os 119935 4111 2009 4856 Os 119935 4 11 2009 123 E ll Standard Consignment Template SAMPLE csv please click Back modify the file on your click Next Postcodes and other data will be checked on import SAMPLE COMPAN 111 SAMPLE STRE SAMPLE CO AN 112 SAMPLE STRE SAMPLE COMPAN 13 LE STRE SAMPLE COMPAN 114 SAMPLE STRE SAMPLE COMPAN 5 SAMPLE STRE v gt ae a If you wish to change any records at
11. d Home Company Data Consignment Manifest Bookings Tools Manifest status There are no Consignments to be manifested Bulk Export Data to be exported 5075012 CANCELLED Standard 119935 08 08 2008 uso75011 CANCELLED Standard 119935 08 08 2008 Nat Dugandzic USN75325 MANIFESTED Standard 119931 0710 2008 LE uso75013 CANCELLED Standard 119935 08 08 2008 1234567 Del 15075013 CANCELLED Standard 119935 08 08 2008 1234567 Del USN75327 MANIFESTED Standard 419931 0710 2008 LE USN75001 MANIFESTED Standard 419931 11 08 2008 U5N75002 MANIFESTED Standard 119931 11 08 2008 LE USN7S003 MANIFESTED Standard 119931 11 08 2008 SUE RYAN LE IPTEN A A aa E anna sane ine 2d lt 1 gt Total Results 500 Export as filename CSV BH 23 10 2009 consignment export Select the location you wish to export the file using the Browse button and Save Note 500 is the maximum number of records that can be exported at a time Page 18 of 18
12. d Description Size Required Comments 33 Receiver Contact Number 10 No Mandatory if Type is Receiver or Third Party 34 Receiver Contact Area 30 No 35 Receiver E mail Ad ress 255 No If specified an e mail will be sent specifying the booking details 36 3 Party Contact Number 10 No Mandatory if Type is Third Party Page 9 of 18 1 4 Address Book FREIGHT MAST gt 3R The following table defines the format and field definitions of the FreightMaster Address Book Import file Each Address Book record is to be on a separate line Field Description Size Required Comments 1 Company Name 30 Yes 2 Location Name 30 Yes Unique Reference 3 Address Line 1 30 Yes 4 Address Line 2 30 No 5 Address Line 3 30 No 6 Suburb 30 Yes 7 State 3 Yes 8 Postcode 4 ves Jes Aes verified against AaE Retail s postcode Page 10 of 18 FREIGHT MAST gt R 2 Export File Specifications All Exports can be modified you have the option of selecting all fields to export or only those required You can also enter relevant details to export the information with certain criteria e g within a date range etc 2 1 Standard Consignment The following table defines the format of the FreightMaster Consignment Export fields Field Description Size Comments 1 Shipment Date 10 DD MM YYYY 2 Created Date 10 DD MM YYYY 3
13. ing criteria Consignment v v To change any of the information within a row except for the field name simply click on the row and then the relevant column within that row Select Data to Export by ticking the fields that you require Enter the Display Order that you wish individual fields to exported Where applicable select the Criteria for a field or fields Criteria Description None Does not apply any criteria values against the selected field Equal Applies Criteria 1 against the selected field The data in the selected field must equal the data entered in Criteria 1 Greater Than Applies Criteria 1 against the selected field The data in the selected field must be greater than the data entered in Criteria 1 Only useful for fields that are numeric or date fields Less Than Applies Criteria 1 against the selected field The data in the selected field must be less than the data entered in Criteria 1 Only useful for fields that are numeric or date fields Between Applies both Criteria 1 and Criteria 2 against the selected field The data in the selected field must fall between the data entered in Criteria 1 and Criteria 2 Only useful for fields that are numeric or date fields Page 17 of 18 FREIGHT MAST gt R Enter the first value Criteria 1 Optional Enter the second value Criteria 2 You will see an Export Display screen showing the records to be exporte
14. onsignment E Connote amp Booking Company Address Book E Personal Address Book Manuals and Guides The relevant file formats and field definitions for both import and export files are following Page 3 of 18 1 Import File Specifications 1 1 Standard Consignment FREIGHT MAST3R The following table defines the format and field definitions of the FreightMaster Standard Consignment Import file Each consignment record is to be on a separate line Field Description Size Required Comments 1 Account Number 8 Yes AaE Retail account number 2 Shipment Date 10 Yes DD MM YYYY 3 Reference 30 No Mandatory if set up at an account level 4 Delivery Instructions 255 No Will appear on the label 5 Authority to Leave 1 No Y Yes N or Blank No 6 Receiver Company Name 30 Yes 7 Receiver Address Line 1 30 Yes 8 Receiver Address Line 2 30 No 9 Receiver Address Line 3 30 No 10 Receiver Suburb 30 Yes 11 Receiver State 3 Yes 12 Receiver PostCode 4 Yes This will be verified against AaE Retail s postcode database 13 Receiver Contact Name 30 No 14 Receiver Contact Number 10 No 45 Rec iver Email Address 255 Nio If specified an e mail will be sent specifying the consignment details for tracking purposes Q Express Premium 16 Service Level 1 Yes E Express Saver Z Airport to Airport Q Express Premium S Deliver to Person K Deliver to Person Prepaid A
15. this point select back make the changes to the file and begin the import process again If the records are correct and you wish to continue click on Next and then click on Yes to complete the import Page 15 of 18 FREIGHT MAST gt R You are about to import 8 records into Freight Master This process may take some time please be patient You will be presented with an overview of the results and a draft consignment number when importing both standard consignments and e connotes or a confirmed booking reference number for bookings imports These can be exported in a CSV file by clicking on the Export the Import Results Log at the bottom left of the page Home Company Data Consignment Manifest Bookings Tools Manifest status There are no Consignments to be manifested Bulk Import Import Results Overview Total records processed 8 Os o 00 8 records have been successfully imported into Freight Master Import Results O 2 Consignment Number Created 157094 ad O 3 Consignment Number Created 157095 O Consignment Number Crested 157096 Os Consignment Number Created 157097 6 Consignment Number Created 157098 O 7 Consignment Number Created 157099 4 Export the Import Results Log Back po text New Import Upon importing consignments standard or e connote these will automatically be saved as drafts to finalise these and either print or e mail you will need to go into View Consignments
Download Pdf Manuals
Related Search