Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
FWECM RHEAD
FWECM RHEAD
nopaneltrue

Article Index

Table of Contents


Bulk job import is used to import jobs from custom Microsoft Excel spreadsheets to into the Framework ECM database.

Step 1 - Configure the field mapping

Configure the field mapping from the source data spreadsheet to the Framework ECM database fields.
(Proceed to Step 2 if the field mapping is already configured).

In Framework ECM

  1. Click File and select Bulk Job Import

...

  1. Follow the Bulk Job Import Wizard instructions:

...

  1. Select the Mapping Set and click on New Item

  2. Add the Name

  3. Add the Column Letter (from the spreadsheet)

  4. Select the Destination Field and choose the correct database field

  5. Update Mandatory? as required

  6. Click OK

Image Added

Step 2 - Updating the Bulk Job Import Spreadsheet

  1. Using the Insula provided Bulk Job Import Spreadsheet in Microsoft Excel,

...

  1. add new Jobs (rows) and update all relevant columns that need to be imported into Framework ECM.
    Note: Ensure all mandatory fields are

...

  1. correct.

  2. Save file as xls and close.

...

Tip

Adding additional field columns allows for greater data import, refer to the Framework Job Import Wizard to review the additional importable field options available.

...

Step 2

Refer to Step 1 for instructions on how to add new items.

Step 3 - How to perform a Bulk Job Import


In Framework ECM

  1. Click File and select Bulk Job Import

...


      2. Follow the Bulk Job Import Wizard instructions:

...

  1. Validate the data

...

  1. in order to commence the import

...

Confirm source data configuration by selecting the Microsoft Excel spreadsheet and template (being the worksheet name).

...

    1. Select the Bulk Job Import Excel spreadsheet (File)

    2. Select the worksheet name from the drop down

    3. Update the Start Row (with the number of the first row to be imported)

    4. Update the End Row (with the number of the last row to be imported)

    5. Click Validate

    6. Click Next

      The results must display Passed in order to click Next.

      Image Added


  1. Start the import

    Image Added

  2. Review the results of the import

...

Contact Us

...

  1. to ensure all rows were successfully created as a Job. Click Finish.

    Image Added