customizing bcm for Brazil... issues

Not open for further replies.


Outlook version
Email Account
I'm from the US and starting a company in Brazil, and want to use BCM 2007 integrated with Office Accounting 2009 since it covers all my CRM and accounting needs at least for now. I need to customize it, however, to adapt to some of the quirks down here. My two issues are the following, and I've been trying to resolve them for 2 days now and can't find the info I'm looking for, or I'm not looking in the right place.

Issue 1:

When I import data from a csv file, I lose any special characters. Specifically, the tax ID numbers down here are in the following format:

06.267.641/0001-93 and also 77.726.225

<col width="346"><tbody>


I've created the custom fields as data type "text" and enter the data ok. I can also export the data ok to another csv file. It's only when I import that I get a bad result. The data type options when creating a custom field doesn't give an option for "general" format so that I can import the data as alphanumeric with symbols. Just for kicks I imported this data into a standard address field and it show up fine! I've tried all available data format types but nothing works. Is there a workaround for this?

Issue 2:

All addresses in Brazil have an extra line for "bairro" or "neighborhood". I can create it ok in the account form, but when I export it merges all the data into one line, so that when I reimport the data it shows up on one line as well. How can I manipulate the data within excel, then reimport it so that the address shows up like it's supposed to? I've tried to find an option for "address line 1" and "address line 2", but no luck. I'd like to keep the "bairro" data in it's own field so that I can access customers in the database based on the "bairro field"

I would think that these issues should be easy to resolve, but I'm pretty new to BCM and driving myself crazy trying to make it do what I want it to do! Any help is greatly appreciated.

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Not sure this will work for #1 - but in excel you can force general format by adding a leading ' (apostrophe). Otherwise, enter them in number only format and create a custom format for the field. (Haven't tried this in BCM so it might not work - it works with sql though, so its possible.)

How are you entering the line break for the address?
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
N Starting out with BCM - Customizing contact records BCM (Business Contact Manager) 1
X BCM: Customizing Marketing Forms BCM (Business Contact Manager) 2
P Customizing Business Cards in BCM BCM (Business Contact Manager) 0
D Customizing BCM BCM (Business Contact Manager) 2
J Customizing Outlook 2010 with Email Address Using Outlook 2
H Customizing "Send to" Attachment Script Outlook VBA and Custom Forms 5
S Customizing Connected Services in Office 2013 Pro Plus (O365) Using Outlook 1
J Customizing PST error message in Outlook Using Outlook 8
S Customizing an Outlook 2010 Email Form Exchange Server Administration 1
D Customizing Tasks form in Outlook 2007 Using Outlook 4
J Customizing Contact Form Using Outlook 6
J Customizing fields in Outlook forms Outlook VBA and Custom Forms 1
R Real Estate Customizing BCM (Business Contact Manager) 2
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
R Follow up button doesn't working neither the reminders in BCM BCM (Business Contact Manager) 0
P BCM conditional formatting BCM (Business Contact Manager) 5
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
D BCM 2013 not functioning as BCM 2010 Example no drop down for communications history Using Outlook 0
J No access to a Database BCM BCM (Business Contact Manager) 3
J Marketing task MS BCM BCM (Business Contact Manager) 10
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
A BCM does not work anymore! BCM (Business Contact Manager) 1
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
A BCM does not work with Windows 10 1703 any more BCM (Business Contact Manager) 3
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
S BCM Project Task Order BCM (Business Contact Manager) 1
T Lost access to remote BCM database BCM (Business Contact Manager) 4
crazyboy Problems connecting to BCM on Server Using Outlook 2
J Problems connecting to BCM BCM (Business Contact Manager) 16
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
M At last a BCM alternative... Outlook Customer Mngr 365! BCM (Business Contact Manager) 0
S BCM view customization BCM (Business Contact Manager) 1
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
K BCM Reports: Timeout Expired BCM (Business Contact Manager) 0
K BCM hide subfolders BCM (Business Contact Manager) 1
Diane Poremsky Restoring BCM Database After Upgrading Windows Using Outlook 0
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Diane Poremsky Trial/Beta program for BCM replacement BCM (Business Contact Manager) 8
A BCM crashes immediately after start BCM (Business Contact Manager) 2
A Two Problems with BCM BCM (Business Contact Manager) 0
J BCM 2013 displays wrong form for account and business contact BCM (Business Contact Manager) 1
A Latest updates kill BCM 2013 BCM (Business Contact Manager) 0
C Where are BCM User Customizations located? BCM (Business Contact Manager) 9
Diane Poremsky Outlook 2016: No BCM Using Outlook 0
Diane Poremsky Outlook 2016: No BCM BCM (Business Contact Manager) 17
wallisellener BCM and MSSQL2012 BCM (Business Contact Manager) 2
M Can I use BCM projects for this BCM (Business Contact Manager) 1
R BCM Reporting of repeat calendar entries BCM (Business Contact Manager) 0
Eduardo Macias BCM 2013 with SQL Express 2014 BCM (Business Contact Manager) 5

Similar threads