When you import Species data from a spreadsheet into GoldSim, GoldSim must decide what to do with existing Species data that may exist in the GoldSim model.
Hence, when GoldSim reads the spreadsheet, it first compares the species list currently in GoldSim to the species list being imported. It then reports how many of the species to be imported from the spreadsheet already exist in the GoldSim model and how many are new (i.e., they don't currently exist in the GoldSim model). Based on what it finds, GoldSim offers you several choices for how you want to treat the new data:
Note that depending on the data being imported and the species already in the model, not all of these options will be applicable. If they are not applicable, they will be grayed out. There are four possible combinations that can occur:
•The number and IDs of existing species exactly matches the number and IDs of species in the spreadsheet file. In this case, Update Only is the only available option. When you press OK, the new properties for the species in the spreadsheet will overwrite the existing properties. In this case, the order of the species in the spreadsheet is not important and the order of species in GoldSim remains unchanged.
•None of the existing species are present in the spreadsheet file. In this case, two options are presented: Add Only and Replace All. If you select Add Only, the new species will be added to the end of the species list (and existing species will be unchanged). If you select Replace All, all of the existing species will be deleted and replaced by the new species (in the order they exist in the spreadsheet file).
•Some of the existing species are present in the spreadsheet file, but there are no new IDs in the spreadsheet file that do not already exist in the existing species list. In this case, two options are presented: Update Only and Replace All. If you select Update Only, the new properties for the species present in the spreadsheet will overwrite the existing properties. Species not in the spreadsheet are unaffected. If you select Replace All, all species that are not in the spreadsheet will be removed from GoldSim, and the remaining species will be updated with new data from the spreadsheet. During the update, the order of species in the GoldSim model (that are being updated by the spreadsheet) will not change.
•Some of the existing species are present in the spreadsheet file, but there are also species in the spreadsheet file that do not already exist in GoldSim. In this case, all four options are available. If you select Update Only, for species present in both the spreadsheet and the existing list, the new properties for the species present in the spreadsheet will overwrite the existing properties. Species not in the spreadsheet are unaffected. If you select Add Only, new species in the spreadsheet that are not already in the GoldSim file will be added to the end of the species list. All other existing species will be unchanged. If you select Add & Update, for species present in both the spreadsheet and the existing list, the new properties for the species present in the spreadsheet will overwrite the existing properties. In addition, new species in the spreadsheet that are not already in the GoldSim file will be added to the end of the species list. If you select Replace All, all species that are not in the spreadsheet will be removed from GoldSim, and the remaining species will be updated with new data from the spreadsheet. During the update, the order of species in the GoldSim model that are also present in the spreadsheet will not change.
Warning: It is important to
keep in mind that when you import new species, you are also modifying the Species
array label set and the Elements array label
set. As such, any arrays that you have created that use these sets will be
impacted. For example, if you add new species, new rows would be added to
a vector based on the Species array label set, and the values would default to
zero (or false, if a condition).
Learn more about: