Using BCM2010 Business Projects as SharePoint 2007 Data Source

Status
Not open for further replies.

paulbockmann

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
We have a SBS2008 network and it comes with SharePoint 2007 v3, which drives our internal Companyweb pages. I would like to link BCM2010's Business Projects to our Companyweb's Tasks page. I have found that via SP Designer 2007 I can create a Data Source from the BCM2010 data, but I can not seem to find where or how the Business Projects are stored in BCM.

Is there a particular table to attach to? Or do I need to attach to multiple tables?

Can someone tell me what I am missing?

Thanks

Paul
 

larry

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
I will preface this with "I have not looked at the BCM data files" so you know I'm just guessing here, but in my experience with other applications, they use multiple tables and you'll need a query.

The best way to find out is to open the BCM database in Sql Management console and look at the tables and the data in them to find the data you want to link. I don't know what you can see in Designer 2007 as I have not used it, but you might be able to see enough of the tables and field names in it to know which ones to use.
 

paulbockmann

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I will preface this with "I have not looked at the BCM data files" so you know I'm just guessing here, but in my experience with other applications, they use multiple tables and you'll need a query.

The best way to find out is to open the BCM database in Sql Management console and look at the tables and the data in them to find the data you want to link. I don't know what you can see in Designer 2007 as I have not used it, but you might be able to see enough of the tables and field names in it to know which ones to use.
Thanks Larry,

I am approaching it from that angle - I see I can use a SQL Select statement to get the records I am looking for. Now I have to figure out what the statement needs to be.
 

paulbockmann

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Does anyone have any sample SELECT statements that will get BCM2010 Business Project data that I can display and hopefully edit.

Thanks for any help.

Paul
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
A Going to folder using shortcuts Using Outlook 3
A Outlook replies not using "delivered to" address in From Using Outlook 1
Terry Sullivan E-Mails Sent Using a Group Box Result in 70 Kickbacks Using Outlook 5
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
K Using Outlook 2016 to draw Using Outlook 1
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
A Using or not using apostrophes in search terms has this changed? Using Outlook 0
O Office 365 using POP3 on both laptop and desktop Using Outlook 0
M Using field names to capture a data element Using Outlook 0
B Vba to monitor time to respond to emails using a shared mailbox Outlook VBA and Custom Forms 5
B Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA Outlook VBA and Custom Forms 4
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
O Using .OST and .PST mail thru different providers Using Outlook 5
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
E Using the Like operator properly Outlook VBA and Custom Forms 1
R Using "check for duplicates" for existing contacts Using Outlook 2
S Find a cell value in excel using outlook vba Using Outlook 1
N Using email notification to update calendar events? Outlook VBA and Custom Forms 4
S Macro using .SendUsingAccount only works the first time, after starting Outlook Outlook VBA and Custom Forms 4
C Sync Calendars using WiFI Using Outlook 3
A Capturing Send Variables without using Application_ItemSend in ThisOutlookSession Outlook VBA and Custom Forms 8
L Using alpha numeric in email address Using Outlook 5
Sabastian Samuel HOW DO I FORWARD AN EMAIL WITH MACRO using an email that in the body of another email Outlook VBA and Custom Forms 3
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
D Print Attachments only in selected emails using a macro Outlook VBA and Custom Forms 3
B query outlook using vba Outlook VBA and Custom Forms 13
M Using conditional formatting on a shared calendar with categories Using Outlook 6
e_a_g_l_e_p_i A question about installing office 2013 Pro and using my .pst from office 2010 Using Outlook 12
A Forward Outlook Email by Filtering using Macro Rule Outlook VBA and Custom Forms 44
O How to paste website content using a specific font and removing URLs Using Outlook 2
P Replying to calendar item using VBA Outlook VBA and Custom Forms 4
N Export details to a excel spreadsheet using macros Using Outlook 0
R Toggle the Reading Pane using Keyboard Shortcut Using Outlook 0
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
H Change Default Email Account Using VBA Outlook VBA and Custom Forms 5
S Outlook [Online - Office365] perfomance is getting affected when accessing the mails using Redemptio Using Outlook 1
M Using Outlook with Yahoo email Using Outlook 6
G Using Data From Combo Box in Appointment Body Outlook VBA and Custom Forms 6
U Using VBA to creat hyperlinks in an email Outlook VBA and Custom Forms 3
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
Diane Poremsky Set Another Data File as Default When Using an Exchange Account New Slipstick.com Articles 0
Similar threads


















































Top