---
title: "Customer Order Imports"
canonical: "https://kb.myframeworks.com.au/space/CO/30515102/Customer%20Order%20Imports"
format: markdown
---
Overview To be able to import a customer order you will require: The customer order as a  .CSV  or  XML  file to import (csv file recommended). The customer order as a  PDF  with the same name as the import file Importing Customer Orders To Import Customer Orders, perform the following: Prepare a  .CSV  or  XML  file import as per the below format. More information about the .CSV Import format For CSV, there should be 33 entries/columns per line as per following: PDF Filename ABN Company Zone  Company Name  Account Number   Section  Order Number  Order Date    Job Number    Delivery Date Street No Street Name Suburb State Map Ref       Map Xref      Contact Name Contact Number Transaction Description Delivery Comment 1 Delivery Comment 2 Delivery Comment 3 Agreed-value/total_ex_prce Product Code Product Description Item Comments Tallies Qty UOM Unit Price    Line Price    Source Type(New Field) Email Address(New Field) Add/Save the  .CSV  or  XML  file AND the  PDF , of the same name, to the  Import File Path  as defined in the next step. An example file path may be:  /prostix/dmp/centralorder/import. Run the  Central Order Import scheduled task  in ProStix via System Services - Tasks to import the .csv/.xml file. How to set up Scheduled Task The scheduled task can be setup and/or modified via ProStix menu option  System Administration - Utilities - Run a Program,  enter  ordbctrlscd.p  and press < Enter > or  <F1>  to run The following Scheduled Central Order Import Settings box will be displayed. Enter the below data similar to the below: Field Description Import File Path Enter the filepath location of where the import files are to be imported to Frameworks (Need a PDF of the same name in the location) Archive File Path Enter the filepath location to move the imported files to Log File path Enter the filepath where the log files are to be generated Notify on Failure An email will be sent with attachments of both the error file and the csv import file to the email address entered File type Enter the file type format : . csv , . xml ,  Both  (to import both .csv and .xml files at the same time) Press  <F1>  to save. Once the scheduled task has been run go to the Frameworks menu and open the Customer Orders Dashboard via  Sales > Transaction Processing  >  Customer Orders Search for the newly imported order - you can use the Imported Date column to filter the results Any orders imported with product lines missing tally details or with a negative value will be highlighted in the COP Order Maintenance screen for review and rectification after import. Any orders imported with missing customer product or qty values will be imported but highlighted in the COP Order review screen for rectification.  Proceed to maintain/process the Order as per  Maintaining a Customer Order Additional Information Next:  Maintain/process the Order as per  Maintaining a Customer Order . For XML, each field has tag names and not all fields are imported or used. These are the fields that are imported and saved in ProStix: