Good evening Julien and welcome back!
Thank you for reaching out to us.
We are sorry to hear about the struggles you have faced with the CSV import of venues.
I would love to help you with this topic.
I ran a quick test on my end with your file and there are a couple of tweaks I would like to suggest:
- Could you use a comma (,) a delimiter as opposed to a semi-colon (;) ?
- Some of your entries end up offsetting each other because the file is perceived as having 3 address fields (e.g.: Great Lakes Regional OTI Education Center – University of Cincinnati) you have to write the addresses in such a way that they are perceived as 2 address fields.
- For several reasons,I highly recommend that each venue gets a unique name. I suspect the system will not handle multiple venues with the exact same name properly (e.g.: Great Lakes Regional OTI Education Center – University of Cincinnati).
Or, at the very least, that they do not have the same address (e.g. University of Cincinnati).
Perhaps something like Great Lakes Regional OTI Education Center – Stetson Building and use University of Cincinnati in the address only ?
Let me know how that goes.
Best regards,
Geoff B.