Combine proposed order and Scholaris data locations sheet

[pgwillia]

https://docs.google.com/spreadsheets/d/19cQH_uiuu7WJ4Jm5_mNcgqGQ9HJlblpR-k4jmYVwvHA/edit?gid=0#gid=0

https://docs.google.com/spreadsheets/d/1XcUSRl2dASREKQhhIan2GQsN375o7GsARh9_ATqzzd8/edit?gid=1646529984#gid=1646529984

[jefferya]

The following Google Sheets spreadsheet was created combing Collection SAF Packaging Order and Scholaris: UofA Collection mapping for importing into DSpace via the following process:

Combined doc: https://docs.google.com/spreadsheets/d/1BBn_r16O5j0t_Lwu67fRbezSrVG80PrA2mVluXDhLIA/edit?gid=0#gid=0

1. Copied a list of collection IDs into the "Combined" sheet
2. Created a second sheet using the contents of "Collection SAF Packaging Order" via =importrange("https://docs.google.com/spreadsheets/d/1XcUSRl2dASREKQhhIan2GQsN375o7GsARh9_ATqzzd8", "collection_criteria!$A:$N")
3. Created a third sheet using the contents of "Scholaris: UofA Collection mapping for importing into DSpace" via =importrange("https://docs.google.com/spreadsheets/d/19cQH_uiuu7WJ4Jm5_mNcgqGQ9HJlblpR-k4jmYVwvHA", "Sheet1!$A:$K")
4. Used a combination of INDEX & MATCH to link the two documents via a common ID and output the cells in each document into one row in a combined sheet =index('Import Range from Collection SAF Packaging Order'!B:B, MATCH($A2, 'Import Range from Collection SAF Packaging Order'!$C:$C, 0))

Note: the import range formula in step 2 & 3 could be combined with the step 4 formula to prevent the creation of the 2 extra sheet/tabs.

All columns are included though some can be excluded.

[pgwillia]

Those two other sheets were created using

https://gist.github.com/pgwillia/b713f4d9fb4ccc0e498603b73fc2ee22

https://gist.github.com/pgwillia/b379c68bc0ac5ed4ac1058f3ffc4ec78

Perhaps the XML file Omar is using in SAF package is a better data source?