Sunday, December 30, 2007

Unistall Sharepoint 3.0 Database MSSQL$MICROSOFT##SSEE

MSSQL$MICROSOFT##SSEE Database can be tricky to unistall, this happen when you unistall sharepoint 3.0 simply farm, and when you try to install again will say to you that SQL server is already install, to unistall you will have to make the following steps:

click "Start-Run" -> Regedit
go to folder
find the ID of the MSSQL$MICROSOFT##SSEE
Copy content of "uninstallstring"

click "Start-Run" ex: C:\WINDOWS\system32\MsiExec.exe /I{90120000-1110-0000-0000-0000000FF1CE} CALLERID=OCSETUP.EXE
and the unistall window will show up
MsiExec.exe /X{CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe

Easy way to install Sharepoint 3.0 Server Templates

Hi again,

Do you still instaling Sharepoint 3.0 server Template one by one, dont do that. Use a litle script to save time, this manual will help you.

Download Sharepoint 3.0 Templates
Install then put Server Templates in folder "c:\templates\"
Create a file .bat Call "InstallTemplate.bat", then you add the following lines.

path c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin\
stsadm -o addsolution -filename c:\templates\ApplicationTemplateCore.wsp
stsadm -o deploysolution -name ApplicationTemplateCore.wsp -local -allowgacdeployment
stsadm -o copyappbincontent
stsadm -o addsolution -filename c:\templates\AbsenceVacationSchedule.wsp
stsadm -o deploysolution -name AbsenceVacationSchedule.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\BudgetingTrackingMultipleProjects.wsp
stsadm -o deploysolution -name BudgetingTrackingMultipleProjects.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\BugDatabase.wsp
stsadm -o deploysolution -name BugDatabase.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\CallCenter.wsp
stsadm -o deploysolution -name CallCenter.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\ChangeRequest.wsp
stsadm -o deploysolution -name ChangeRequest.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\ComplianceProcessSupport.wsp
stsadm -o deploysolution -name ComplianceProcessSupport.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\ContactsManagement.wsp
stsadm -o deploysolution -name ContactsManagement.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\DocumentLibraryReview.wsp
stsadm -o deploysolution -name DocumentLibraryReview.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\EventPlanning.wsp
stsadm -o deploysolution -name EventPlanning.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\ExpenseReimbursementApproval.wsp
stsadm -o deploysolution -name ExpenseReimbursementApproval.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\HelpDesk.wsp
stsadm -o deploysolution -name HelpDesk.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\InventoryTracking.wsp
stsadm -o deploysolution -name InventoryTracking.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\ITTeamWorkspace.wsp
stsadm -o deploysolution -name ITTeamWorkspace.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\JobRequisition.wsp
stsadm -o deploysolution -name JobRequisition.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\KnowledgeBase.wsp
stsadm -o deploysolution -name KnowledgeBase.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\PhysicalAssetTracking.wsp
stsadm -o deploysolution -name PhysicalAssetTracking.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\ProjectTrackingWorkspace.wsp
stsadm -o deploysolution -name ProjectTrackingWorkspace.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\RoomEquipmentReservations.wsp
stsadm -o deploysolution -name RoomEquipmentReservations.wsp -local -allowgacdeployment
stsadm -o addsolution -filename c:\templates\SalesLeadPipeline.wsp
stsadm -o deploysolution -name SalesLeadPipeline.wsp -local -allowgacdeployment

Run InstallTemplate.bat, everything will run right.

Saturday, December 29, 2007

Sharepoint - CRM Mobile Express

Allo again, Sharepoint and CRM can be best friends sometimes
I was looking in my quest of Mobile CRM and was to improve CRM Mobile Express, and stop in Joris Kalz Blog, excelents articles and saw, i think to my self, i am lazy and need a emulator, why not share in Sharepoint company.
One Day later Boom instant sucess, demostrations, implementations... etc etc.
Simple ideia, not? :)

to implement create a new Webpart Page and select full page, then add webpart that call url, and put the URL of the LazyEmulator of CRM, DONE.

Excelent manual to instal CRM Mobile Express with ISA

Administrative Mode

Sunday, December 23, 2007

Download Microsoft CRM 4.0

Microsoft have release the new Microsoft CRM 4.0, Already try, new Features.
Like Example, remember phone call not been sync with outlook, ok now is sync with tasks.

Microsoft Dynamics CRM 4.0

Microsoft Dynamics CRM 4.0 for released languages.

Microsoft Dynamics CRM 4.0 Data Migration Manager

Using the Microsoft Dynamics CRM 4.0 Data Migration Manager, you can convert and upload data from another CRM system to Microsoft Dynamics CRM 4.0.

Microsoft Dynamics CRM 4.0 Trial Versions

Microsoft Dynamics CRM 4.0 90-day trial versions for released languages.

Microsoft Dynamics CRM for Outlook (For On-Premise and Hosted Editions)

Install Microsoft Dynamics CRM 4.0 for Outlook and Microsoft Dynamics CRM 4.0 for Outlook with Offline Access. For on-premise and hosted editions of Microsoft Dynamics CRM 4.0 only.

Microsoft Dynamics CRM 4.0 E-mail Router (On-Premise and Hosted Editions)

The E-mail Router is an interface between the Microsoft Dynamics CRM system and an e-mail system.

Download details: Microsoft Dynamics CRM 4.0 SDK

This package contains the complete software development kit for Microsoft Dynamics CRM 4.0.

Microsoft Dynamics CRM 4.0 Language Pack

Microsoft Dynamics CRM 4.0 Language Packs contain translated text, such as labels, error messages, and Help

URL Links, Datagrid List, Microsoft CRM 3.0 View

This is a compliation of filters and views that will help you working with CRM and create personal views.

One good example is using this url in sharepoint sites and call when you need.

CRM Calendar
just need to add "http://[server]:Port/workplace/home_calendar.aspx" in the url and will show you just the calendar this links are very usefull if you want to integrate your pages with microsoft CRM.

DataGrid Lists
Accounts - http://[server]:Port/_root/homepage.aspx?etc=1
Contacts - http://[server]:Port/_root/homepage.aspx?etc=2
Opportunities - http://[server]:Port/_root/homepage.aspx?etc=3
Leads - http://[server]:Port/_root/homepage.aspx?etc=4
Marketing List - http://[server]:Port/_root/homepage.aspx?etc=4300
Reports - http://[server]:Port/CRMReports/home_reports.aspx
Activities - http://[server]:Port/workplace/home_activities.aspx
Calendar - http://[server]:Port/workplace/home_calendar.aspx
Articles - http://[server]:Port/workplace/home_answers.aspx
Queues - http://[server]:Port/workplace/home_workplace.aspx
Competitors - http://crm:5555/_root/homepage.aspx?etc=123
Products - http://[server]:Port/_root/homepage.aspx?etc=1024
Sales Literature - http://[server]:Port/_root/homepage.aspx?etc=1038
Quotes - http://[server]:Port/_root/homepage.aspx?etc=1084
Orders - http://[server]:Port/_root/homepage.aspx?etc=1088
Invoices - http://[server]:Port/_root/homepage.aspx?etc=1090
Quick Campaigns - http://[server]:Port/MA/home_minicamps.aspx
Campaigns - http://[server]:Port/MA/home_camps.aspx
Cases - http://[server]:Port/CS/home_cases.aspx
Contracts - http://[server]:Port/_root/homepage.aspx?etc=1010
Services - http://[server]:Port/_root/homepage.aspx?etc=4001

Custom Entities:
Custom: http:///userdefined/edit.aspx

Advanced Find - http://[server]:Port/AdvancedFind/AdvFind.aspx
CRM Help - http://[server]:Port/help/default.aspx

Settings Pages
Settings - http://[server]:Port/tools/home_tools.aspx?pid=0
Customisation Menu - http://[server]:Port/tools/systemcustomization/systemcustomization.aspx
Entity Customisation DataGrid - http://[server]:Port/tools/systemcustomization/systemcustomization.aspx?PID=01
Import Customisations - http://[server]:Port/tools/systemcustomization/systemcustomization.aspx?PID=03
Export Customisations - http://[server]:Port/tools/systemcustomization/systemcustomization.aspx?PID=03
Subjects (Taxomony for Knowledge Base) - http://c[server]:Port/tools/home_tools.aspx?pid=08
Advanced View of Settings - http://[server]:Port/tools/home_tools.aspx?vid=1

lookup, to create filterviews associated to a entity, 1- account, 2- Contact, 4 - Lead..........
Lookup - http://[server]:Port/_controls/lookup/lookupsingle.aspx?class=ParentLookup&objecttypes=1,2&browse=0&DefaultType=0

http://[server]:Port/_forms/readonly/readonly.aspx?objTypeCode="+ lookupItem[0].type +"&id="+lookupItem[0].id;

Read = 1
Write = 2
Append = 4
AppendTo = 16
Create = 16
Delete = 65536
Share = 262144
Assign = 524288

document.all.IFRAME_Historico_Lead.src="/sfa/leads/areas.aspx?oid="+lookupItem[0].id+ "&oType=112&security=852023&tabSet=areaActivityHistory";

Sunday, December 16, 2007

How-to Pass Parameter to Report Viewer

One of the most asked question is "How-to Pass Parameter to Report Viewer", here i find a video that can help you very easy.

Thursday, December 13, 2007

Google Analytics, just fantastic

Never think reports can be done so easy, can see where viewers are from, just amazing exploring and filtering in Google analytics can be a powerfull tool to your sites and creater markets, see what people want to see.

Google Analytics, A tool to stay in touch

Wednesday, December 12, 2007

Sharepoint Services 3.0 Service Pack 1

This lasts days microsoft have finish his Service pack 1 to Sharepoint Services 3.0.

Here is the link

Windows SharePoint Services 3.0 with Service Pack 1

To update your wss3.0 go to site:

Windows SharePoint Services 3.0 Service Pack 1 (SP1)

Show Shared Exchange Calendar CRM Microsoft - Part II

Like i show you in other post, share outlook calendar can be simple, dont try code over code over code, try simple, you dont lose your head and clients will like.
Like this litle example:

Ok first step is go to isv.config.xml and add:

<Entity name="appointment">
<ToolBar >
<Button Title="Shared Calendar" ToolTip="Shared Calendar" Icon="/_imgs/ico_16_4003.gif" JavaScript="'http://crm:5555/custom/outlook.htm','Shared Calendar','width=550,height=540,top=150,left=150,toolbar=0,location=0,status=0,menubar=0,scrollbars=1,resizable=0');" />

after add this lines create a html, "Outlook.html" page that will suport you outlook views

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">


<style type="text/css">
body { font-size:11px; font-family:"Tahoma,Verdana"; margin:0px; border:0px; background-
color:#eef0f6; cursor:default; }
td { font-size:11px; font-family:"Tahoma,Verdana"; }
td.sec { width:100%; color:#000000; font-weight:bold; padding-left:0px; padding-
bottom:2px; text-overflow:ellipsis; overflow:hidden; } { border-bottom:1px solid #000000; }
td.req { font-weight:bold; color:#9f2409; overflow:hidden; text-overflow:ellipsis;
padding-top:5px; }
td.rec { font-weight:bold; color:#466094; overflow:hidden; text-overflow:ellipsis;
padding-top:5px; }
table.layout { table-layout:fixed; width:100%; }
input { font-size:8pt; width:10%; height:19px; border:1px solid #7b9ebd; }
button { filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr=
#ffffff, EndColorStr=#cecfde); cursor:hand; font-size:11px; padding-left:5px; padding-right:
5px; border:1px solid #7b9ebd; }
<body style="background-color: #EEF0F6;">


<select id="Agendas1" name="btnShowCal1" style="font-family: tahoma,Arial;font-size: 11px;">
<option value ="Calendar">Calendar</option>
<option value ="\\Public Folder\Every Public Folder\Marketing Departmant">Marketing Departmant</option>
<option value ="\\Public Folder\Every Public Folder\Conference Room" selected>Conference Room</option>


<select id="Agendas2" name="btnShowCal2" style="font-family: tahoma,Arial;font-size: 11px;">
<option value ="Calendar">Calendar</option>
<option value ="\\Public Folder\Every Public Folder\Marketing Departmant">Marketing Departmant</option>
<option value ="\\Public Folder\Every Public Folder\Conference Room" selected>Conference Room</option>
<BUTTON id="cmdButton" onclick="ViewResource();">Calendário 1</BUTTON>

<BUTTON id="cmdButton1" onclick="ViewResource1();">Calendário 2</BUTTON><BR>

<object classid="clsid:0006F063-0000-0000-C000-000000000046" id="OVCWPQ1" width="1" height="1">
<p id="parah"></p>
<param name="Folder" value="\\Public Folder\Every Public Folder\Conference Room"/>
<param name="Namespace" value="MAPI"/>

<object classid="clsid:0006F063-0000-0000-C000-000000000046" id="OVCWPQ2" width="1" height="1">
<p id="parah"></p>
<param name="Folder" value="\\Public Folder\Every Public Folder\Conference Room"/>
<param name="Namespace" value="MAPI"/>

<script language=VBScript>
Sub btnShowCal1_onchange
OVCWPQ1.Folder = btnShowCal1.value

End Sub
Sub btnShowCal2_onchange
OVCWPQ2.Folder = btnShowCal2.value

End Sub
Sub ViewResource()
If cmdButton.Value = "Calendário 1" Then
cmdButton.Value = "Esconde Calendário 1"
OVCWPQ1.Width = "100%"
OVCWPQ1.Height = "300px"
OVCWPQ1.Width = "1"
OVCWPQ1.Height = "1"
cmdButton.Value = "Calendário 1"
end if
end sub
Sub ViewResource1()
If cmdButton1.Value = "Calendário 2" Then
cmdButton1.Value = "Esconde Calendário 2"
OVCWPQ2.Width = "100%"
OVCWPQ2.Height = "300px"
OVCWPQ2.Width = "1"
OVCWPQ2.Height = "1"
cmdButton1.Value = "Calendário 2"
end if
end sub