Love the forum, database, and content – the spreadsheet load option is great but to make this really work it needs to have reference information to make sure it complies with your naming convention
Its a relatively easy task to create a list of acceptable values for the distillery and Bottlers into the spreadsheet so that adding your collection you can pick from acceptable values
Not sure how important the other fields are but the same would be true for any of the other fields if their values are important for matching
Can you make available ad download of these values so I can incorporate into my spreadsheet that I want to create to import all my bottles
I’d be happy to reciprocate with an updated template others could use once I have created it
you are totally right, restricting the distillery and bottler fields in the import Excel would have been an obvious thing to do.
Find below all the bottlers and distilleries we currently track on Whiskystats. Also note that we are currently in the progress of setting up a new database, but all of the collections you create now will be automatically translated to the new database once it is finished.