Viewing Exception File with Header Line

Viewing Exception File with Header Line

When viewing flat file order import files or managing exception files, it is usually helpful to view the fields in excel with the field headers.

Accompanying our spec for the OLX Order Import V4 is a header file in Excel. When this is opened in the Microsoft Excel program, the steps to follow will allow you to add the data from a .txt or .csv file into the spreadsheet in the correct format for review and import, if needed. 

1) In Excel, paste the contents of the .txt. .csv file into the first column of the Excel sheet below the header line.

2) Select the first column and in the Data menu of Excel, choose Text to Columns.

3) Select Deiminated and click Next.

4) Choose Comma from the list of delimitators and click Next.

5) Select all of the columns (scroll all the way to the right and Shift + Click on the final column), and choose the data format Text. Then click Finish.

    • Related Articles

    • OrderLogix Order Import V4 (Flat File and API) Exception List

      Module: Order Import V4 Topic: Exception List Version(s): Version 5.0 and up Editions: Standard, Commerce, Call Center OrderLogix Real-Time Order Submission API OrderLogix Order Import V4 (Flat File and API) Exception List The Import Process will ...
    • Import file with mutliple orders appears as only one order on the imports preview page

      You may find instances where you receive an import file that has mutliple line items but when you preview the import it appears that there is only one order.  There are a few things that can cause this. The first is that there's no CRLF at the end of ...
    • WARNING: Duplicate order found in the import file. Order was not imported.

      Message: WARNING: Duplicate order found in the import file. Order was not imported.  Explanation: The order number that you have provided matches a web order number that is already in use. This logic prevents duplicate orders from being imported to ...
    • Download Tax Rate File

      Module: Tax Accounts Topic: Download Tax Rate File Version(s): 5.1 & up Editions: All Download Tax Rate File Due to our provider's contract, we are unable to provide a file of tax rates to you. There are many reports available via Reports > Sales ...
    • Credit Card BIN File Script Rule

      Module: Global Script Rules and Maintain Scripts Path: Company Data > Advertising > Global Script Rules Company Data > Advertising > Maintain Scripts > Edit Script > Rules tab Topic: Script Rule for Credit Card BIN File Version(s):  5.1 & up ...