To make sure that the data you import is as correct as possible, we have a sample file feature that we highly recommend you download to work on every time you want to import a newly certified establishment to the BeCause database.
Why?
Simply because we have already matched the columns in the sample file to match the columns that are required for a successful data import to the database. In that way, you do not need to match the columns when you are ready to import your file.
Can I work on my own file?
You can work in your own prepared file, as long as you match the columns in your own file to the columns we have in our database. Otherwise, your data will end up being mixed.
To help you prepare your data as smoothly as possible, we have a step-by-step guide that will take you through how to download a sample file to work in.
Step-by-step guide on how to download a sample file
Go to Import and click on Import Establishment Data.
2. Select the certification that you are importing data on, then select the group that you will be uploading the certification to. You will then be able to download a sample file 📁
You may use your own Excel or CSV file in the import, but we recommend that you download the sample file and use it as the foundation of your file.
The sample file contains all relevant columns and the header names already match what the import tool expects 💡.
Your file may contain one or more rows depending on the fields required for your import.
3. This is an example of your SAMPLE FILE:
Please make sure to fill out all fields required
If you are importing a NEW establishment, please remember to remove BeCause Profile ID, as this will be created automatically when you import your new. establishment.
4. Please go to the next GUIDE ⬅️ to see how to fill out the fields in your SAMPLE FILE with the correct data points.
If you are unsure about how to do the import, please contact support via the chat in the right-hand corner 🤝. We are here to help 💜.