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



Monday, November 26, 2007

Report "Quick campaign" Microsoft Crm 3.0

One thing hard to get is "Quick campaign" report in Microsoft CRM 3.0, and after this litle example, you can work out and try to make a report like Campaign.

select fbo.subject, fap.activitytypecodename, *
from [companyname]_MSCRM.dbo.filteredbulkoperation fbo,
[companyname]_MSCRM.dbo.filteredactivitypointer fap
where fbo.operationtypecodename='Quick Campaign'
and fbo.activityid=fap.regardingobjectid

Wednesday, November 14, 2007

Microsoft CRM in full screen mode

A easy way to look you crm web page like a real aplication, you will like

1º create a shortcut and put the line

"C:\Program Files\Internet Explorer\iexplore.exe" -K http://[server]:5555/loader.aspx

Puf will show a full page.

Saturday, November 10, 2007

Mobile Phone Sharepoint 3.0

To access in sharepoint 3.0 in a mobile phone you need in the url page add "/M" -> for Mobile Phone, example:
"http://[sharepoint site]/M"

This will send you to a ligth access to sharepoint list, the list views can be only acces if you give mobile phone access to views, will not apear by default, on views properties you need to give access.
After this you can have access in mobile phone.

Create Network Folder ms-dos command prompt in active directory

When you have a server and you want use active directory do give some rules and shared permission to some folder, in that rules you can create network folder on you windows explorer to easy acces to folder, here a litle example:

net use drivepath: \\FolderPath\Folder

net use z: \\\Documents

create a map.bat or other file
1. AD in the Organizational Unit of the group you wish to add an unmap folder
2. edit gPolicy then put it in the
3. User COnfiguration
- Windows Setting
- Scripts
-add the Map.bat
4. log off login the user to test it or you can use this lines
net use \\[server name ex: server.companyname.local]\ipc$ /user:[Username] [Password]
to connect

Wednesday, November 07, 2007

Close Selected Letters Microsoft CRM 3.0

one thing that ask me when i was develomp in CRM is close the selected letters i selected in grid, to do this you have to add in isv.config.xml file and add this line

<entity name="activitypointer">
<button title="Close Letter" javascript="doIsvAction('crmGrid', 'closeLetter.htm', 0, '');" winmode="1" winparams="" passparams="1" icon="/_imgs/ico/16_L_remove.gif" tooltip="Close Selected Letters">

After this you can create a html page that call the following javascript and will close the select letters you select in the grid.

var selected = true;
var unselected = true;
function ShowGuids()
if(confirm('Deseja apagar a(s) Carta(s) selecionada(s)?')== true)
if(window.opener == null)

var content = "<table>";
var allRows = window.opener.document.getElementsByTagName("tr");

for(i=0; i<allRows.length; i++)

if (allRows[i].otype=="4207" && allRows[i].className == "gridSelectOn")

var activityid = allRows[i].oid;

var serverUrl = "/mscrmservices/2006";

var xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");

//alert(serverUrl+ "/crmservice.asmx");"POST", serverUrl + "/crmservice.asmx", false);

xmlhttp.setRequestHeader("Content-Type", "text/xml; charset=utf-8")

xmlhttp.setRequestHeader("SOAPAction", "")

xmlhttp.send("<?xml version='1.0' encoding='utf-8'?>"+"\n\n"+"<soap:Envelope"+

' xmlns:soap=""'+

' xmlns:xsi=""'+

' xmlns:xsd="">'+

' <soap:Body>' +

' <Request xsi:type="SetStateLetterRequest"'+

' xmlns=""> '+

' <EntityId>' + activityid + '</EntityId>'+

' <LetterState>Completed</LetterState>'+

' <LetterStatus>4</LetterStatus>'+

' </Request>'+

' </soap:Body>'+

' </soap:Envelope>')

var result = xmlhttp.responseXML.xml;
if (result.indexOf('faultcode') < 0) {'/CRMReports/viewer/drillopen.aspx?ID=' + activityid + '&OTC=4201');

} else {



content += "<tr>";
content += "<td>" + allRows[i].oid + "</td>";
content += "<td>" + allRows[i].otype + "</td>";
content += allRows[i].innerHTML;
content += "</tr>";

content += "</table>";

document.getElementById("area").innerHTML = content;

function ShowSelected()
selected = !selected;

function ShowUnselected()
unselected = !unselected;


How to send SMTP email using Telnet

This is an old method of sending email using Telnet. I've posted it here mostly for a remider to me on exactly how to do this, but thought I would share it with others who may not know of this. This can be useful when testing if a server can successfully send email. For example, I use this to confirm if a SharePoint server can successfully send emails for alerts and notifications.

The items in bold are what you should type.

Start a Telnet session from a command line by entering:
Telnet 25

220 Microsoft ESMTP MAIL Service, Version: 6.0.3790.2499 ready at Thu, 29 Jun 2006 15:59:02 -0600

250 Hello []
mail from:

250 2.1.0 OK
rcpt to:

250 2.1.5

354 Start mail input; end with .
This is a test.
. (enter a dot/period to end the data)

250 2.6.0 Queued mail for delivery

Connection to host lost.


Sunday, October 28, 2007

Connect Network using command in a VPN

If you connect to a diferent network using a VPN, you want to make the shortcuts on you explorer and authenticate user in Active Directory, to access that you have to write this lines on you command prompt:

net use \\[server name ex: server.companyname.local]\ipc$ /user:[Username] [Password]

This line will authenticate you on the network you connect in the VPN....

Add Google's AdSense to a SharePoint (WSS 3.0) Site

How to: Enable incoming/outgoing email for SharePoint 2007

Add Google Analytics Code to SharePoint Blog subpage or post

Installing Sharepoint Version 3.0 on SBS 2003

SharePoint 3.0/2007 Install - An Overview of Setup

SharePoint 2007 -- Custom List Forms

Enabling Anonymous Access in a SharePoint Site

InfoPath and MOSS workflow demo

E-mail enable a SharePoint List

Videos of Sharepoint 3.0

Monday, October 22, 2007

Create CRM Microsoft Callout in Visual Studio 2005

Normaly when you read forums and the SDK book to create callout they recomend Visual studio 2003, why? Very simple, because they need framework 1.1, but Arash Ghanaie-Sichanie create a template in visual studio that you can create your callout in visual studio 2005
you have to download framework 1.1 from that you cannot scape, this template is very very useful, because dont need to install 2 visual studios....

Saturday, October 20, 2007

Project Gant List in Sharepoint services wss 3.0

Hello Again, with introdution about almost a year i have being exploring, i see a lot of diference with wss 2.0 on that realy like because we can use to show customers and internal project is the "project list library", if administration want to control how is the develomp of product in real time, can use this web part library and create alert when some project have finish.

This control is very good but have a lots of limitations if you normaly work with office project, but is a good way to start and if you are a litle company, you can use the imagination to do a lot of things, and dont need to buy office microsoft project or microsoft project server... :P

Friday, October 19, 2007

Parameter reporting services 2005 URL and export PDF

Acessing reports services 2005 using url with parameters can be tricky sometimes because we have to construct the URL to the page with the parameters we want, my advice is to make step by step,


Ok what i did here
i call the reports and use some parameter to make the filter with the name:

this fields will be defined in the report by @ "where [field]=@id and [field]=@type and [field]=@typename

and if you want to export directly to a PDF file you will need to add the tag in the url

Ok is done easy and fast way to export reports to pdf, and you dont need to preeview report...

Tuesday, October 16, 2007

Create Task Scheduler Backup sharepoint Wss 3.0

One way to create a Task Scheduler on sharepoint Wss 3.0 is create a bat file and use the "Microsoft Scheduled Tasks" there you select the bat file and select the days or days that the service run, easy and fast...

"start"->"control Panel"->"Scheduled Tasks"->add task

create .bat file and associate the time
path C:\Program Files\common files\Microsoft shared\web server extensions\12\bin\
Stsadm.exe" -o backup -directory \\server\share -backupmethod full -overwrite

Microsoft have create a diferent scrip that delete older files a litle more complex but can be the way you want

How to automate the deletion of backups in SharePoint Server 2007 and in Windows SharePoint Services 3.0 by using a Visual Basic script

You can also manually delete backups. However, manually deleting backups does not clean the manifest file (Spbrtoc.xml) correctly.

the page i was base on

Clean up backup files (Windows SharePoint Services 3.0)

Wednesday, October 10, 2007

Show Shared Exchange Calendar CRM Microsoft

One time a college ask me if he can see calendars of his boss and colleges in APR, i say yes of course, go in the outlook, then folder of exchange and then find the shared calendar, ok after almost 2 minutes she found the calendar and ask me, "what i do when i am in the phone..." well i understand his problem then in the phone call i create a popup page in html that make outlook view in html page, sow i did this in the html page:

<--object classid="clsid:0006F063-0000-0000-C000-000000000046" id="OVCWPQ1" width="100%" height="485px" param name="Folder" value=[Folder to shared calendar in exchange] /-->
< param name="Namespace" value="MAPI" />

Of course this is a litle example, i create litle more complex with 2 calendars and a lists of shared calendar paths that change with vbscript.

here my original post:

Create Callout CRM 3.0 fast refresh

You can use Visual Studio 2005 to create callout, but you will need to have installed the framework 1.1, here a site where explains.


Now in then Prebuild and Postbuild og the project you can put this lines, this line will only refesh the IIS faster, and you dont have to stop services and restart, fast and easy....


cscript C:\Inetpub\AdminScripts\adsutil.vbs stop_server W3svc/AppPools/CRMAppPool

cscript C:\Inetpub\AdminScripts\adsutil.vbs start_server W3svc/AppPools/CRMAppPool


xcopy "$(TargetPath)" "C:\Program Files\Microsoft CRM\Server\bin\assembly" /y

Sunday, July 15, 2007

Enviar parameters por command prompt

Ola mais uma vez, estava eu no trabalho ate que um colega meu me pergunta.
"Como fazo para enviar parametros para uma aplicação pelo command prompt?"
Bem tenho que admitir que nao sabia, entao como o google esta aqui para ajudar, entao fiz uma pequena pesquisa e aqui vai....

1º Correr o "cmd" command prompt

2º Criar um novo programa onde o sera criado o executavel para ex: "c:\teste.exe"

3º É necessário importar a DLL Microsoft.VisualBasic

4º chamar o seguinte comando
private void Form1_Load(object sender, EventArgs e)
string teste=Microsoft.VisualBasic.Interaction.Command();

5º Compilar Programa

6º pelo command prompt executar a simples linha "c:\teste.exe -d -a -teste"

O que ira acontecer e que ira aparecer uma messagebox com o seguinte texto "-d -a -teste".

Ok está feito.... simples.

Saturday, June 30, 2007


Estava a ler algum conteudo sobre ferramentas windows e encontrei este conjunto de comando que considerei engraçado.

1. Create any new Folder.

2. Right click and go to Rename, remove the content, press “Alt” and type “0160″. The Folder name would become NIL. inv_fol1

3. Now go on to the properties of the folder and click “Customize”, and click “Change Icon”.

4. Here you will find some icons without any kind of images.

5. Select any of these images and click “OK”. You will now see that your folder is now invisible.

Sunday, June 24, 2007

Isnumeric em Oracle

Ola, depois de passar o São joão, aqui volto para dar mais uma pequena ajuda, desta vez é para validar num PL-SQL apenas valores numericos, para isso quando estiverem a realizar o select apenas fazam isto,

LENGTH(TRIM(TRANSLATE(string1, ' +-.0123456789', ' ')))

Isto ira validar se tem algum valor que nao seja numerico retornando o valor do texto, se nao tiver nenhum numeric ira retornar NULL, como indica o exemplo:

LENGTH(TRIM(TRANSLATE('123b', ' +-.0123456789',' ')));
retorna 1

LENGTH(TRIM(TRANSLATE('a123b', ' +-.0123456789',' ')));
retorna 2

LENGTH(TRIM(TRANSLATE('1256.54', ' +-.0123456789',' ')));
retorna null

LENGTH(TRIM(TRANSLATE ('-56', ' +-.0123456789',' ')));
retorna null

Thursday, June 14, 2007

Programa para Listagem da Active directory

Eu ja realizei algums programas para visualizar e controlar a Active directory em, mas quem é tecnico de informatica e trabalha com servidores e pequenas empresa este pequeno programa podera ajudar a visualizar o que existe dentro da empresa e como esta organizado os computadores e utilizadores e a interligaçoes que este possa ter com exchange, sql server, S.O. etc etc

Excelente site onde se ajudar no desenvolvimento de ferramentas .Net

Tuesday, March 20, 2007

Comandos do Windows

já alguma vez precisaram de saber qual era os comando para correr certas aplicações como o notepad ou o explorer, com este conjunto de comando podem criar ficheiros .bat para rapidas ligações ou outro tipo de ideias que podem ter.

Espero que ajude.....

Run Commands:
compmgmt.msc - Computer management
devmgmt.msc - Device manager
diskmgmt.msc - Disk management
dfrg.msc - Disk defrag
eventvwr.msc - Event viewer
fsmgmt.msc - Shared folders
gpedit.msc - Group policies
lusrmgr.msc - Local users and groups
perfmon.msc - Performance monitor
rsop.msc - Resultant set of policies
secpol.msc - Local security settings
services.msc - Various Services
msconfig - System Configuration Utility
regedit - Registry Editor
msinfo32 _ System Information
sysedit _ System Edit
win.ini _ windows loading information(also system.ini)
winver _ Shows current version of windows
mailto: _ Opens default email client
command _ Opens command prompt

Run Commands to access the control panel:
Add/Remove Programs control appwiz.cpl
Date/Time Properties control timedate.cpl
Display Properties control desk.cpl
FindFast control findfast.cpl
Fonts Folder control fonts
Internet Properties control inetcpl.cpl
Keyboard Properties control main.cpl keyboard
Mouse Properties control main.cpl
Multimedia Properties control mmsys.cpl
Network Properties control netcpl.cpl
Password Properties control password.cpl
Printers Folder control printers
Sound Properties control mmsys.cpl sounds
System Properties control sysdm.cpl

Command Prompt:
ANSI.SYS Defines functions that change display graphics, control cursor movement, and reassign keys.
APPEND Causes MS-DOS to look in other directories when editing a file or running a command.
ARP Displays, adds, and removes arp information from network devices.
ASSIGN Assign a drive letter to an alternate letter.
ASSOC View the file associations.
AT Schedule a time to execute commands or programs.
ATMADM Lists connections and addresses seen by Windows ATM call manager.
ATTRIB Display and change file attributes.
BATCH Recovery console command that executes a series of commands in a file.
BOOTCFG Recovery console command that allows a user to view, modify, and rebuild the boot.ini
BREAK Enable / disable CTRL + C feature.
CACLS View and modify file ACL's.
CALL Calls a batch file from another batch file.
CD Changes directories.
CHCP Supplement the International keyboard and character set information.
CHDIR Changes directories.
CHKDSK Check the hard disk drive running FAT for errors.
CHKNTFS Check the hard disk drive running NTFS for errors.
CHOICE Specify a listing of multiple options within a batch file.
CLS Clears the screen.
CMD Opens the command interpreter.
COLOR Easily change the foreground and background color of the MS-DOS window.
COMP Compares files.
COMPACT Compresses and uncompress files.
CONTROL Open control panel icons from the MS-DOS prompt.
COPY Copy one or more files to an alternate location.
CTTY Change the computers input/output devices.
DATE View or change the systems date.
DEBUG Debug utility to create assembly programs to modify hardware settings.
DEFRAG Re-arrange the hard disk drive to help with loading programs.
DEL Deletes one or more files.
DELETE Recovery console command that deletes a file.
DELTREE Deletes one or more files and/or directories.
DIR List the contents of one or more directory.
DISABLE Recovery console command that disables Windows system services or drivers.
DISKCOMP Compare a disk with another disk.
DISKCOPY Copy the contents of one disk and place them on another disk.
DOSKEY Command to view and execute commands that have been run in the past.
DOSSHELL A GUI to help with early MS-DOS users.
DRIVPARM Enables overwrite of original device drivers.
ECHO Displays messages and enables and disables echo.
EDIT View and edit files.
EDLIN View and edit files.
EMM386 Load extended Memory Manager.
ENABLE Recovery console command to enable a disable service or driver.
ENDLOCAL Stops the localization of the environment changes enabled by the setlocal command.
ERASE Erase files from computer.
EXIT Exit from the command interpreter.
EXPAND Expand a M*cros*ft Windows file back to it's original format.
EXTRACT Extract files from the M*cros*ft Windows cabinets.
FASTHELP Displays a listing of MS-DOS commands and information about them.
FC Compare files.
FDISK Utility used to create partitions on the hard disk drive.
FIND Search for text within a file.
FINDSTR Searches for a string of text within a file.
FIXBOOT Writes a new boot sector.
FIXMBR Writes a new boot record to a disk drive.
FOR Boolean used in batch files.
FORMAT Command to erase and prepare a disk drive.
FTP Command to connect and operate on a FTP server.
FTYPE Displays or modifies file types used in file extension associations.
GOTO Moves a batch file to a specific label or location.
GRAFTABL Show extended characters in graphics mode.
HELP Display a listing of commands and brief explanation.
IF Allows for batch files to perform conditional processing.
IFSHLP.SYS 32-bit file manager.
IPCONFIG Network command to view network adapter settings and assigned values.
KEYB Change layout of keyboard.
LABEL Change the label of a disk drive.
LH Load a device driver in to high memory.
LISTSVC Recovery console command that displays the services and drivers.
LOADFIX Load a program above the first 64k.
LOADHIGH Load a device driver in to high memory.
LOCK Lock the hard disk drive.
LOGON Recovery console command to list installations and enable administrator login.
MAP Displays the device name of a drive.
MD Command to create a new directory.
MEM Display memory on system.
MKDIR Command to create a new directory.
MODE Modify the port or display settings.
MORE Display one page at a time.
MOVE Move one or more files from one directory to another directory.
MSAV Early M*cros*ft Virus scanner.
MSD Diagnostics utility.
MSCDEX Utility used to load and provide access to the CD-ROM.
NBTSTAT Displays protocol statistics and current TCP/IP connections using NBT
NET Update, fix, or view the network or network settings
NETSH Configure dynamic and static network information from MS-DOS.
NETSTAT Display the TCP/IP network protocol statistics and information.
NLSFUNC Load country specific information.
NSLOOKUP Look up an IP address of a domain or host on a network.
PATH View and modify the computers path location.
PATHPING View and locate locations of network latency.
PAUSE Command used in batch files to stop the processing of a command.
PING Test / send information to another network computer or network device.
POPD Changes to the directory or network path stored by the pushd command.
POWER Conserve power with computer portables.
PRINT Prints data to a printer port.
PROMPT View and change the MS-DOS prompt.
PUSHD Stores a directory or network path in memory so it can be returned to at any time.
QBASIC Open the QBasic.
RD Removes an empty directory.
REN Renames a file or directory.
RENAME Renames a file or directory.
RMDIR Removes an empty directory.
ROUTE View and configure windows network route tables.
RUNAS Enables a user to execute a program on another computer.
SCANDISK Run the scandisk utility.
SCANREG Scan registry and recover registry from errors.
SET Change one variable or string to another.
SETLOCAL Enables local environments to be changed without affecting anything else.
SETVER Change MS-DOS version to trick older MS-DOS programs.
SHARE Installs support for file sharing and locking capabilities.
SHIFT Changes the position of replaceable parameters in a batch program.
SHUTDOWN Shutdown the computer from the MS-DOS prompt.
SMARTDRV Create a disk cache in conventional memory or extended memory.
SORT Sorts the input and displays the output to the screen.
START Start a separate window in Windows from the MS-DOS prompt.
SUBST Substitute a folder on your computer for another drive letter.
SWITCHES Remove add functions from MS-DOS.
SYS Transfer system files to disk drive.
TELNET Telnet to another computer / device from the prompt.
TIME View or modify the system time.
TITLE Change the title of their MS-DOS window.
TRACERT Visually view a network packets route across a network.
TREE View a visual tree of the hard disk drive.
TYPE Display the contents of a file.
UNDELETE Undelete a file that has been deleted.
UNFORMAT Unformat a hard disk drive.
UNLOCK Unlock a disk drive.
VER Display the version information.
VERIFY Enables or disables the feature to determine if files have been written properly.
VOL Displays the volume information about the designated drive.
XCOPY Copy multiple files, directories, and/or drives from one location to another.
TRUENAME When placed before a file, will display the whole directory in which it exists
TASKKILL It allows you to kill those unneeded or locked up applications

Windows XP Shortcuts:
ALT+- (ALT+hyphen) Displays the Multiple Document Interface (MDI) child window's System menu
ALT+ENTER View properties for the selected item
ALT+ESC Cycle through items in the order they were opened
ALT+F4 Close the active item, or quit the active program
ALT+SPACEBAR Display the System menu for the active window
ALT+TAB Switch between open items
ALT+Underlined letter Display the corresponding menu
BACKSPACE View the folder one level up in My Computer or Windows Explorer
CTRL+A Select all
CTRL+I Italics
CTRL+O Open an item
CTRL+U Underline
CTRL+V Paste
CTRL+F4 Close the active document
CTRL while dragging Copy selected item
CTRL+SHIFT while dragging Create shortcut to selected iteM
CTRL+RIGHT ARROW Move the insertion point to the beginning of the next word
CTRL+LEFT ARROW Move the insertion point to the beginning of the previous word
CTRL+DOWN ARROW Move the insertion point to the beginning of the next paragraph
CTRL+UP ARROW Move the insertion point to the beginning of the previous paragraph
SHIFT+DELETE Delete selected item permanently without placing the item in the Recycle Bin
ESC Cancel the current task
F1 Displays Help
F2 Rename selected item
F3 Search for a file or folder
F4 Display the Address bar list in My Computer or Windows Explorer
F5 Refresh the active window
F6 Cycle through screen elements in a window or on the desktop
F10 Activate the menu bar in the active program
SHIFT+F10 Display the shortcut menu for the selected item
CTRL+ESC Display the Start menu
SHIFT+CTRL+ESC Launches Task Manager
SHIFT when you insert a CD Prevent the CD from automatically playing
WIN Display or hide the Start menu
WIN+BREAK Display the System Properties dialog box
WIN+D Minimizes all Windows and shows the Desktop
WIN+E Open Windows Explorer
WIN+F Search for a file or folder
WIN+F+CTRL Search for computers
WIN+L Locks the desktop
WIN+M Minimize or restore all windows
WIN+R Open the Run dialog box
WIN+TAB Switch between open items

Windows Explorer Shortcuts:
ALT+SPACEBAR - Display the current window’s system menu
SHIFT+F10 - Display the item's context menu
CTRL+ESC - Display the Start menu
ALT+TAB - Switch to the window you last used
ALT+F4 - Close the current window or quit
CTRL+A - Select all items
CTRL+X - Cut selected item(s)
CTRL+C - Copy selected item(s)
CTRL+V - Paste item(s)
CTRL+Z - Undo last action
CTRL+(+) - Automatically resize the columns in the right hand pane
TAB - Move forward through options
ALT+RIGHT ARROW - Move forward to a previous view
ALT+LEFT ARROW - Move backward to a previous view
SHIFT+DELETE - Delete an item immediately
BACKSPACE - View the folder one level up
ALT+ENTER - View an item’s properties
F10 - Activate the menu bar in programs
F6 - Switch between left and right panes
F5 - Refresh window contents
F3 - Display Find application
F2 - Rename selected item

Internet Explorer Shortcuts:
CTRL+A - Select all items on the current page
CTRL+D - Add the current page to your Favorites
CTRL+E - Open the Search bar
CTRL+F - Find on this page
CTRL+H - Open the History bar
CTRL+I - Open the Favorites bar
CTRL+N - Open a new window
CTRL+O - Go to a new location
CTRL+P - Print the current page or active frame
CTRL+S - Save the current page
CTRL+W - Close current browser window
CTRL+ENTER - Adds the http://www. (url) .com
SHIFT+CLICK - Open link in new window
BACKSPACE - Go to the previous page
ALT+HOME - Go to your Home page
HOME - Move to the beginning of a document
TAB - Move forward through items on a page
END - Move to the end of a document
ESC - Stop downloading a page
F11 - Toggle full-screen view
F5 - Refresh the current page
F4 - Display list of typed addresses
F6 - Change Address bar and page focus
ALT+RIGHT ARROW - Go to the next page
SHIFT+CTRL+TAB - Move back between frames
SHIFT+F10 - Display a shortcut menu for a link
SHIFT+TAB - Move back through the items on a page
CTRL+TAB - Move forward between frames
CTRL+C - Copy selected items to the clipboard
CTRL+V - Insert contents of the clipboard
ENTER - Activate a selected link
HOME - Move to the beginning of a document
END - Move to the end of a document
F1 - Display Internet Explorer Help

Friday, March 16, 2007

Techdays 2007

Ja devem saber mas Dia 20 a dia 22 de Março, vai haver evento techdays 2007 sobre as novas ferramentas da microsoft versao 2007, muitos devem estar a pensar, melhoraram visual e tal....., pois é, mas tambem melhoraram performance maior integraçao entre sistemas entre muita mais coisa, bem eu vou estar lá, eu neste momento estou mais dentro dos sistemas de sharepoint v3.0 como ja devem ter reparado no meus ultimos post.
Este foi umas das minhas razoes para nao ter metido mais posts, explorei ate ao tutano as potencialidades e mesmo assim considero pouco porque as empresas nao sei porque gostam de inventar, mas o principal objectivo, "regras de negocio" estao la, mas como lhe costumo chamar, as mariquices, as vezes sao o ponto mais importante do mundo para as empresas, lol :).

Estive tambem a explorar e integrar um sistemas que ja venho a explorar desde fevereiro de 2006 que é o CRM 3.0, mas pelos visto ja vai sair uma versao mais recente "Titan" agora a microsoft deu para este tipo de nomes pró-grego.

Mas como o principal centro de negocio onde estou envolvido é trabalhar com Oracle, sim uma pessoa e um polvo e a informatica tambem, e preciso integrar todas as ferramente de um lado e do outro, que e exactamente procuro neste techdays e nao tanto para saber novidades, espero que seja produtivo.

Se me quiserem procurar apenas tem que me procurar e perguntar por André Lage do porto, partilhar conhecimento e experiencia sao sempre bem vindas.

Espero que se divirtam, eu vou de certeza.... ;)

Saturday, February 24, 2007

Configurar ajax no Sharepoint services 3.0 wss3.0

Pois é, estamos a ver sempre coisas novas com o sharepoint services 3.0 entre elas, a super nova..... a utilização de ajax nesta plataforma.

este conjunto de sites ira dar um dislumbre que como configurar a plataforma para utilização de ajax:
Ajax wss3.0

E como utilizar a ferramenta smarpart no desenvolvimento das webparts bastante util.

este video mostra como se utiliza o smartpart com wss3.0

É possivel fazer o download da ferramente pelo site:

Falta apenar dar o link do mentor desta ferramenta
Jan Tielens

Referente ao meu proximo post nao sei se devo explicar a exportaçao de wss2.0 para 3.0.... vai variar do meu humor :P, nao sei, se pedirem mesmo mesmo mesmo muito eu la ponho o manual de exportação que tanto trabalho que meu a fazer porque as coisas nao correm bem a primeira, mesmo as ferramentas de exportação, hihi quem sabe, sabe do que falo entende.....

Ferramentas para windows sharepoint services Wss 3.0

Vou dar um conjunto de sites que serao bastante uteis quando se estiver a desenvolver no Wss3.0, bom proveito.... :)

download do sharepoint wss3.0

Windows SharePoint Services 3.0 Language Pack

Windows SharePoint Services 3.0 Application Templates: todos templates

(Para utilizar reporting services no sharepoint)
SQL Server Reporting Services Add-in for SharePoint Technologies
Sera necessario instalar o SQL 2005 service pack 2
SQL Server 2005 Service Pack 2

Para quem quiser desenvolver em visual studio existe um add in em Windows SharePoint Services 3.0 Tools: Visual Studio 2005 Extensions for Windows SharePoint Services 3.0

Para isso ira precisar de apoio documental que é fornecedio neste link Windows SharePoint Services 3.0: SDK (RTM version)

Correr uma aplicação directamente em codigo

Pois é correr uma aplicação em codigo e bastante simples, para isso apenas é preciso correr o seguinte codigo em c#.
Primeiro importa-se a class

Imports System
Imports System.Diagnostics
Imports System.ComponentModel
Process proc = new Process();
proc.StartInfo.FileName = "" + _DataRow["Path"]; //Caminho da Base de dados ou outro sitio qualquer desde que seja um caminho valido.

Tuesday, January 16, 2007


Pois é há tantas novidades que nem sei por onde começar.
Talvez por um VOLTEI :), pois é tanto tempo sem dar sinal de vida, posso dizer que aqui estou de volta, como nao queria deixar esta treta, vamos ver se consigo dizer tudo o que tenho para dizer, sharepoint V3.0, Reportviewer,, etc etc etc tanta coisa....

Curiosos entao esperem pelos proximos artigo ;) espero nao desiludir....