Run Mapper Import within Connector

This window is used to transmit standard formatted .csv files from the PC to the Preceda application.  

Prerequisites

  • Create the file to be uploaded on your PC based on the File Format Rules.
  • Ensure that Mapper is available and setup on your PC.
  • Ensure that Connector is available and setup on your PC.

Mapper Import Process Options

The Mapper Import process can be setup through Connector to perform one of the following:-

  1. Upload a selected Import File held in a flat file on your PC to update a Preceda Master or Reference via the IFS.
  2. Upload a Batch Time Card data flat file on your PC to update Preceda via the IFS, and will perform the following steps for the Batch Time Card to update:
    • Splits the downloaded data according to Payrun Environments if you have Payrun Environments in place.
    • Runs the Batch Time Card Edit process and produces a report for each Payrun Environment that has records in the downloaded field and is at a status to allow the merge.
    • Merges valid data into on line Time Card files.
    • Reports and discards Invalid data.

    Before running the Batch Time card data, the following must be setup:

    • Create the file to be uploaded on your PC. The file must be in the format of Preceda's PAY34T file.
    • There must be a Payrun Header record in the file for every Payrun environment which is included in the file.
    • The Payrun Environment must be at a status that allows the merging of Batch Time Card data online.

 

This refers to the name of the Activity ID that will be imported, e.g. Award Codes M000017.

This field is window al and free format, and can be used as a means to specifically identify one import from another through the console. This is helpful if there are many similar types of imports.

There are two modes to choose from: Interactive or Batch. For the uploading of the Batch Time Card PAY34T file, this must be run in Batch mode to ensure that reports are created.

  • Browse to locate the file on your PC that is to be uploaded.
  • Select the Run Process icon to submit the job.
  • Messages relating to the job are displayed in the message area of the window.
  • Double clicking on a message will display the message in a pop up window. This is handy if the message is very long.

The Job Log is cleared by selecting Tools | Clear Log from the toolbar at the top of the window.

This window will validate fields and produce a report on any exception without making any changes in Preceda.

This window will update the information in Preceda as well as producing an exception report.

When this upload process is run, the following is processed in Preceda:

  • The status of the payrun is changed to Time Card Merge in Progress.
  • The Edit is run and the Time Card Edit Report, PAY34, is produced and placed on the output queue attached to the scheduled job.
  • If no valid entries exist for the merge, the Payrun Environment status is restored and the merge is bypassed, allowing records to remain on the IFS.
  • The Merge of Batch Time Cards to Online is run and the files on the IFS are deleted.
  • The payrun status is set to Payrun Started.
  • If the PC file does not include data for some Payrun Environments, these environments are ignored by the Edit/Merge process.

If required, the Mapper Import job can be saved for later use by selecting the Save icon.

  • Select the location for the job and enter the required name.
  • The job will be saved with your entered file name and a suffix of .con.
  • When the job is selected, the Mapper Import window will be opened.