Updating Portfolios

You can update multiple portfolios for the same target service and the same object is possible via DataLoader, for both KBART and TXT format. To do this, select the Update Portfolios load type. The Activate/Deactivate multiple portfolios for the same target and the same object option appears:

activate_deactivate_multiple_portfolios.png

Update Portfolios
To identify the correct portfolio to update, SFX uses two methods: via the parse_param field and via the threshold field.

Selecting this option affects all portfolios in the load file, if multiple object portfolios for the same target and the same object exist.

If this option is selected and dataloader finds that there are multiple object portfolios for the same target and the same object, when activating/deactivating the portfolios, the PARSE_PARAM field is checked to determine which object portfolios should be updated, activated, or deactivated.

  • If a match is found in the PARSE_PARAM information in load file versus portfolio field, the portfolio identified is activated/deactivated.
    • For the parse_param field comparison, first the entire parse_param is compared. If no match is found, only the jkey’s or the bkeys are matched if they exist in the parse_param.
    • Blank parse_params are compared like a string (two blank parse_params are matched).
  • If no match is found in the PARSE_PARAM information (either because there is no PARSE_PARAM in the file or it does not match), thresholds are checked.
The threshold matching works only for activation/deactivation (change of AVAILABILITY_STATUS from ACTIVE to INACTIVE or vice versa) – not for other types of updates.
  • The active threshold in the portfolio is checked against the load file threshold. If the thresholds are identical, this is considered a match and the portfolio is updated.
  • If no match is found, the portfolio is not updated.
For the KBART input format, the comparison between portfolio and the load file is done after the date/volume/issue from KBART file is converted into an SFX threshold statement.