The present template comes from the perspective of starting with the OCDS schema, and identifying, for each of its fields, which source system field populates it.
We want to additionally support the perspective of starting with a source system, and identifying, for each of its fields, which OCDS field it populates.
We can do this by adding a new sheet, or by adding extra columns to the Source Fields sheet, for the source-to-OCDS mapping.
Ideally, if you enter a mapping in one sheet, it will appear on the other sheet in a new column for the effective mapping. (If a mapping is entered on both sheets and the mapping conflicts, then that new column can say as much.)
Based on discussion in CRM-5938 opened by @duncandewhurst.
The present template comes from the perspective of starting with the OCDS schema, and identifying, for each of its fields, which source system field populates it.
We want to additionally support the perspective of starting with a source system, and identifying, for each of its fields, which OCDS field it populates.
We can do this by adding a new sheet, or by adding extra columns to the Source Fields sheet, for the source-to-OCDS mapping.
Ideally, if you enter a mapping in one sheet, it will appear on the other sheet in a new column for the effective mapping. (If a mapping is entered on both sheets and the mapping conflicts, then that new column can say as much.)
Based on discussion in CRM-5938 opened by @duncandewhurst.