Associating Breeze IDs
One of the challenges faced when importing anything other than people is getting the correct Breeze ID into the import file. Typically users will have a file with dozens or hundreds of names and, after pasting the data into the import template, the only column that still needs to be filled in is the Breeze ID.
Depending on the number of rows in the import file, adding the Breeze ID by hand can feel anywhere from monotonous to exceedingly overwhelming. Fortunately, with a little Excel wizardry, you're able to generate a formula to do this automatically for you by cross-referencing the person's name, making a task that could take hours only take a few minutes.
The formula looks like this:
|Range of cell references including at least 2 columns||Sheet2.$A$2:$B$24
|Number (column number to return)||2
Sometimes seeing a function in action is easier than in the abstract. If it's helpful, you can download an example here:
Some characters don't format correctly when exported/imported as CSV files. Typically these are characters outside the English language such as á, é, í, ó, ú, ü, ñ, ¿, ¡, อักษรไทย, 汉字, and more. Excel doesn't do a great job opening CSV files with these characters due to how Excel treats encoding. As a result, we recommend using Open Office (https://www.openoffice.org), a free program similar to Microsoft Office.
When opening CSV files with Open Office, you'll have the chance to select the "Character set." Setting this to "Unicode (UTF-8)" should allow the special characters to be read properly.