Scribd Logo
Upload

Welcome to Scribd!

  • 167 views

    CIM Data Load2

    Uploaded by

    Arif Subagyo
    This document provides instructions for creating a CIM input file to load item master data into an ERP system. It describes determining which fields are required and validated, creating a template for the input file format, editing an input file, loading the file, processing the loaded data, and verifying the records were added correctly.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    CIM Data Load2

    Uploaded by

    Arif Subagyo
    167 views3 pages
    This document provides instructions for creating a CIM input file to load item master data into an ERP system. It describes determining which fields are required and validated, creating a template for the input file format, editing an input file, loading the file, processing the loaded data, and verifying the records were added correctly.

    Original Title

    CIM_Data_Load2

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for creating a CIM input file to load item master data into an ERP system. It describes determining which fields are required and validated, creating a template for the input file format, editing an input file, loading the file, processing the loaded data, and verifying the records were added correctly.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    167 views3 pages

    CIM Data Load2

    Uploaded by

    Arif Subagyo
    This document provides instructions for creating a CIM input file to load item master data into an ERP system. It describes determining which fields are required and validated, creating a template for the input file format, editing an input file, loading the file, processing the loaded data, and verifying the records were added correctly.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3
    At a glance
    Powered by AI
    The document discusses creating and using CIM input files to load data into QAD Enterprise Applications.

    The document states that at minimum the CIM input file must contain the required fields to create a valid record according to the program being used, in this case ppptmt04.p. Required fields and any fields that need a 'Go' are determined by testing record creation.

    The document states that to load a CIM input file you use the CIM Data Load program and specify the input file name. The number of loaded records/groups will be displayed.

    Using The CIM Data Load

    Creating CIM Input File Template


    Overview: In this activity, you will select a program and determine which fields you want to use as
    input data for a CIM input file.
    1. Select Item Master Maintenance (1.4.1).
    2. Determine the following:
    • Which fields are required. You must include at least the required fields in your input file
    to create a valid record according to the ppptmt04.p program. Of course, you can update
    other fields.
    • Which fields must be followed by Go.
    • Which field(s) are validated against generalized codes. If they are, what is a valid value?
    For example, in the second window, press Go before you enter any data. The system
    displays:
    ERROR: PRODUCT LINE MUST EXIST IN pl_mstr. Please re-enter.
    This error message tells you the Product Line field is required. Your CIM input file must
    contain a value for this field. (You can use a look-up browse to see a list of values.)
    3. Continue creating the test record using this process, recording your findings, and creating a
    template of how the actual CIM file will be structured. For example, you may determine the
    CIM file will look like:
    @@batchload ppptmt04.p
    “999”
    “EA” “CIM Test Item”
    “1000” “01/01/99” - “process”
    @@End
    This file is one record, in one group. The following file contains two records, in one group:
    @@batchload ppptmt04.p
    “999”
    “EA” “CIM Test Item”
    “1000” “01/01/99” - “process”
    “333”
    “EA” “CIM Test Item”
    “1000” “01/01/99” - “process”
    @@End
    This last file creates three records, using two groups:
    @@batchload ppptmt04.p
    “999”
    “EA” “CIM Test Item”
    “1000” “01/01/99” - “process”
    “333”
    “EA” “CIM Test Item”

    Using The CIM Data Load 1


    ID: 9072-QAD2 | Version: 6 | Date: 2/29/08 3:15:09 PM
    “1000” “01/01/99” - “process”
    @@End
    @@batchload ppptmt04.p
    “555”
    “EA” “CIM Test Item”
    “1000” “01/01/99” - “process”
    @@End
    Once your template is complete, you can create the CIM input file, and load and/or process the
    records.
    Creating a CIM Input File
    Overview: In this activity, you will create a CIM input file.
    1. Select Exit to the Operating System (36.19.1/36.24.1), and press Go.
    2. Edit a new file named cim.dat in your working directory.
    3. Create a CIM input file containing the following criteria
    Criteria
    One Group
    One Record
    Populate All Mandatory Fields
    Populate First Description Line
    Populate Status
    Populate Drawing
    Populate Revision

    4. Save the file, and return to QAD Enterprise Applications by typing: exit
    Loading the CIM Input File
    Overview: In this activity, will load the CIM input file you just created.
    1. Select CIM Data Load (36.17.1/36.15.1), and enter the following:
    Field Enter
    Input from File or Continuous Process File
    (F/C):
    Input File/Continuous Process Name: cim.dat

    2. Press Go.
    The system loads the input file. The number of records/groups appears in the Batch Data Load
    Groups Entered field. A system-assigned group ID appears in the Group ID field. (A group is
    defined by a set of @@batchload and @@endin the input file.)
    Note the group ID(s). ________________________________________

    Using The CIM Data Load 2


    ID: 9072-QAD2 | Version: 6 | Date: 2/29/08 3:15:09 PM
    NOTE

    Note In post-Version 8.5 systems, loading can be accomplished using CIM Load Processor
    (36.17.2/36.15.2). There is an option that processes directly from the file, skipping the need
    to load the file separately.

    Processing the Input Data


    Overview: In this activity you will process the input data you just loaded.
    1. Select CIM Data Load Processor (36.17.2/36.15.2).
    2. Specify the group ID number in the Group Id and To fields. (If you loaded a CIM file with
    multiple groups, specify a range.) Skip the remaining fields. In the Output field, specify a file
    name (for example, cimout). The system appends a .prn extension and displays the warning:
    The output device is not a defined printer.
    3. Press Go, and review the CIM data load report output file (cimout.prn).
    4. Open Item Master Maintenance (1.4.1), and find the item number(s) you loaded. Verify that
    the data appears in the correct fields, as specified in the same CIM input file.

    Using The CIM Data Load 3


    ID: 9072-QAD2 | Version: 6 | Date: 2/29/08 3:15:09 PM

    You might also like