A Importing Merchant Category Codes

This appendix contains these topics:

• Appendix A, "Creating the Template for Merchant Category Codes,"

• Appendix A, "Updating the Merchant Category Codes Template (Spreadsheet),"

• Appendix A, "Importing the Merchant Category Codes."

You can use the interactive import process to upload merchant category codes directly into the Merchant Category Codes program (P01P21). To do this, you create a template (spreadsheet) that you save as a .csv or .xml file, update it with the MCCs that you want to import, and then use the interactive import process to upload the MCCs from the spreadsheet to the Merchant Category (Commodity) Codes file (F01P21).

Your bank should be able to provide you with the MCCs that they use, but you can also locate them, by credit card, on the Internet.

The interactive subfile programs can display a maximum of 9,999 records at one time. If your import generates more than 9,999 records, the program will import to the subfile limit and then pause. You can then process the records in the subfile and run the import again, until you process all records.

Prerequisites

To use the interactive import process, you must set up an Integrated File System (IFS) directory and map it to your PC. For information about setting up the system for import and export, see Work with Import/Export in the JD Edwards World Technical Tools Guide.

A.1 Creating the Template for Merchant Category Codes

You create a template that you save as an Excel spreadsheet as a the .csv or .xml file directly from the Merchant Category Codes program (P01P21).

1. From menu G01P41 (Purchase Card Set-Up), choose Merchant Category Codes (P01P21).

2. On Merchant Category Codes, enter F in the Action Code and press Enter to display the Interactive Import Parameters.

3. In the File Name field, enter the name that you want to assign to the template that the system creates followed by .csv or .xml.

4. If you want to create the spreadsheet as an .xml file, enter Y in the Excel XML Y/N field; otherwise, leave it blank to use create the spreadsheet as a .csv file.

5. Enter the IFS path in the corresponding field or press F4 (Search IFS Path) to select the IFS path from the list that appears.

6. Press Enter.

   Because you use this program to create the spreadsheet as well as to import the data from the spreadsheet, the system returns an error on the File Name field when you first create the template.

7. Press F9 to create the template.

8. Press F3 to exit the program from the menu.

   The system stores the template on your PC in the directory that is mapped to your IFS directory.

A.2 Updating the Merchant Category Codes Template (Spreadsheet)

The template that you save has a row with data item names that identify the columns. The order of columns on the spreadsheet is not important and you do not have to complete all of the columns; only those required for the process.

1. Open the template that you created from the IFS directory and complete the following columns. You might be able to cut/paste this information from a spreadsheet that you download from the Internet.

   • SFMCCC - Enter the merchant category code.

   • SFDL01 - Enter the description for the merchant category codes.

2. If you want to add mapping information to create a relationship among the merchant category codes, complete the SFMAP1, SFMAP2, and SFMAP3 fields.

3. After you update the spreadsheet, you must save it. When you click Save, the system displays this message:

   Figure A-1 Microsoft Excel Message on Save screen

   
   Description of "Figure A-1 Microsoft Excel Message on Save screen"
   
   

4. Click Yes.

5. When you exit the spreadsheet, you may receive the following message, depending on your Excel File settings:

   Figure A-2 Microsoft Excel Message on Exit screen

   
   Description of "Figure A-2 Microsoft Excel Message on Exit screen"
   
   

6. Click No.

   The CSV format does not retain cell formatting; therefore, if you choose Yes, the system prompts you to save the spreadsheet in an .xls or other format. If you choose to save it in an .xls or other format, you must save it in the CSV format before you import it.

A.3 Importing the Merchant Category Codes

When you have saved your spreadsheet as a .csv or .xml file, you can import it interactively to the Merchant Category Codes program (P01P21):

1. From menu G01P41 (Purchase Card Set-Up), choose Merchant Category Codes (P01P21).

2. On Merchant Category Codes, enter F in the Action Code and press Enter to display the Interactive Import Parameters.

3. Complete the following fields based on your spreadsheet:

   • File Name

   • Excel XML Y/N

   • IFS Path

     Alternatively, you can press F4 to browse the IFS folders and select a file and path.

   • Field ID Row Number

   • Start Data Row Number

   • End Data Row Number

4. Press Enter to save parameters and then press F6 (Continue).

   The system enters the data in the appropriate fields from the spreadsheet.

   Note:

   The import might not load all of the data from the spreadsheet. If the system detects a change in header information, it returns a message stating "Group of records imported (JDE0517)." Add the first group of records and then run the import again. The import begins from the point in the spreadsheet where the import ceased. A similar situation occurs if you try to import more than 9,998 records at one time.

5. Enter A in the Action Code and press Enter.

   The system validates and adds the import records.