Letras y Números

Error:You must specify a value for this required field July 14, 2012

Error:You must specify a value for this required field

Este error se presenta cuando se intenta modificar una página de Wiki desde el explorador, el origen de este error es el master.page

Correcto

• <h2 style=”visibility:hidden;”>  
•  <div style=”visibility:hidden;display:inline”>  
•   <asp:ContentPlaceHolder id=”PlaceHolderPageTitleInTitleArea” runat=”server” Visible=”true”  />  
•  </div>
• </h2>
•  <div tabindex=”0″ >  
•   <div style=”visibility:hidden;display:inline”>  
•    <asp:ContentPlaceHolder id=”PlaceHolderPageDescription” runat=”server” Visible=”true” />  
•   </div>
• </div>

Incorrecto

• <h2>  <asp:ContentPlaceHolder id=”PlaceHolderPageTitleInTitleArea” runat=”server” Visible=”false”  /></h2>
• <div tabindex=”0″ >  
• <asp:ContentPlaceHolder id=”PlaceHolderPageDescription” runat=”server” Visible=”false” />
• </div>

Se debe evitar manipular la propiedad visible=”false” de todos los ContentPlaceHolder del master page

Other content placeholder’s in the v4.master MasterPage to be aware of:

Apoyado por: http://blogs.msdn.com/b/tmathis/archive/2010/03/18/you-must-specify-a-value-for-this-required-field-error-when-hidding-placeholderpagetitleintitlearea.aspx

SharePoint 2010 Foundation Vs Standard Vs Enterprise June 27, 2012

Esta es una información que esta disponible en Microsoft pero que yo por mi parte no quiero olvidar, así que aqui se las comparto Forever.

Esta información esta disponible en http://sharepoint.microsoft.com/en-us/buy/pages/editions-comparison.aspx

Script de apertura de puertos SQL SERVER 2008 June 27, 2012

Hola Amigos

Encontre este articulo super util y que nunca debemos olvidar de como programar adecuadamente los puertos de entrada salida, necesarios para instalar correctamente SQL SERVER 2008.

@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer" 
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection" 
@echo Enabling conventional SQL Server Service Broker port 4022  
netsh firewall set portopening TCP 4022 "SQL Service Broker" 
@echo Enabling Transact-SQL Debugger/RPC port 135 
netsh firewall set portopening TCP 135 "SQL Debugger/RPC" 
@echo =========  Analysis Services Ports  ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services" 
@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser" 
@echo =========  Misc Applications  ==============
@echo Enabling HTTP port 80 
netsh firewall set portopening TCP 80 "HTTP" 
@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL" 
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser" 
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

Es importante siempre configurar los puertos de acceso, y evitar abrir todos los puertos, o bajar el firewall,

http://support.microsoft.com/kb/968872

Comandos Power Shell Utiles May 27, 2012

• Consultar todas las templates instaladas
  • $web.webtemplate | format-list
  • to file
  •  $list.items | Out-File C:\filename.txt
• Reduce WSS_Logging
  • $defs = Get-SPUsageDefinition
    Foreach($def in $defs)
    {
    Set-SPUsageDefinition –Identity $def.Name –DaysRetained 1
    }
• Query with Row Line number
  • SELECT TOP 10 ROW_NUMBER() OVER (Order by [col1]) AS RowNumber,[col1]
    FROM [dbo].[Table]
• excel arrow moves sheet not cell
  • Windows
  • On-Screen Keyboard
  • When the on-screen keyboard appears, click the ScrLk or Slk button
• WSDL.exe
  • WSDL.exe /language:CS /namespace:FourCalc /out:c:\Captures\FourCalc.cs http:\\localhost/FourFunctionCalc/Service1.asmx?sdl
• psconfig -cmd upgrade -inplace b2b
• read PublicKeyToken> en power shell
  • ([system.reflection.assembly]::loadfile(“c:\MyVerificationDLL.dll”)).FullName
• PrerequisiteInstaller.exe /?
  • Muestra los prerequisitos de esa versión
• Broacast skype 365 URL
  • https://broadcast.skype.com/
• Borrar usuarios
  • Get-SPUser -web http://www.misite.com  -Limit ALL | Where-Object {$_.UserLogin -like “*fuckuser*”} | select UserLogin
  • $user = Get-SPUser -web http://www.misite.com  -identity “i:0#.f|sql_membership|fuckuser”
  • Remove-SPUser -identity $user.ID -web http://www.misite.com
• Connect SharePoint Online
  • Connect-SPOService -Url https://tenantname-admin.sharepoint.com -credential admin@contoso.com
•  Allow MimeType
  • $webApp  = Get-SPWebApplication http://sharepoint.contoso.co
  • # current allowed mimetypes
  • $webApp.AllowedInlineDownloadedMimeTypes
  • # add the text/html mime type
  • $webApp.AllowedInlineDownloadedMimeTypes.Add(‘text/html’)
  • $webApp.Update()
• Set Office 365 never expires
  •  Set-MsolUser -UserPrincipalName “userprincipalname” –PasswordNeverExpires $true
• MicrosoftEasyFix20150
  • fix sync issues with OneDrive for Business automatically
• Get all assembly
  • gacutil -l >yourassemblies.txt
• CamlQuery query = CamlQuery.CreateAllItemsQuery()
• CamlQuery query = CamlQuery.CreateAllItemsQuery(100)
• URL view all users
  • …/_layouts/15/people.aspx?MembershipGroupId=0
• Otorgar permisos a la base de datos de configuración
  • • Add-SPShellAdmin aaa\bbbb
• Manage property bags
  • $web = GEt-spweb “http://www.misite.com/subsite/&#8221;
  • $web.Properties[“prop1”] = “88888”
  • $web.Properties[“prop2”] = “0010”
  • $web.Properties.Update();
  • $web.Update();
• Shutdown . Apagar por comandos
  • shutdown /r /t 0
• Copy Paste error
  • rdpclip.exe
• Obtener el listado de listas de un sitio
  • $web = GET-SPWeb “http://site/subsite/subsite/
  • $web.lists | Format-Table title,id -AutoSize
• PowerShell
  • add-PSSnapIn “Microsoft.SharePoint.Powershell”
• Crear sitio de Educacion
  • New-SPEduClass –ClassId SPEU101 –ClassName “ElectronicaI” –site http://education.contoso.com
• Upgrade several sitecollections
  • get-spsite -limit all | Upgrade-SPSite -VersionUpgrade -Unthrott
• Computer Management
  • compmgmt.msc
• Sincronizar el reloj HORA
  • w32tm /resync
• Usage Logs
  • _layouts/usagedetails.aspx
• Activar Features en el web
  • Get-SPSite http://misitio/ | Get-SPWeb -Limit ALL |%{ Get-SPFeature -Web $_ } | Select DisplayName,ID -Unique
  • Enable-SPFeature -identity “9a447926-5937-44cb-857a-d3829301c73b” -URL http://misitio/
• Activar Features en el site
  • Get-SPFeature -Limit ALL | Where-Object {$_.Scope -eq “SITE”}
  • Enable-SPFeature -identity “9a447926-5937-44cb-857a-d3829301c73b” -URL http://misitio/
• Administrar Tipos de Contenido Huerfanos
  • SELECT [SiteId],[Class],[Scope],sys.fn_varbintohexstr([ContentTypeId]) as CT,[Version],[NextChildByte],[Size],[Definition],[ResourceDir],[IsFromFeature]FROM [dbo].[ContentTypes]where (sys.fn_varbintohexstr(ContentTypeId) LIKE ‘0x010010bd6c5%’)
  • Update [dbo].[ContentTypes]set [IsFromFeature] = 0where (sys.fn_varbintohexstr(ContentTypeId) LIKE ‘0x010010bd6c5%’)
  • delete [dbo].[ContentTypes]where (sys.fn_varbintohexstr(ContentTypeId) LIKE ‘0x010010bd6c5%’)
• Elevarse permisos en SQL SERVER
  • SQLCMD –E -S ‘Domain\Account’
  • exec sp_addsrvrolemember @loginame=’Domain\Account’,@rolename=’sysadmin’
  • Reiniciar servico SQL SERVER
• Comando para un copiar-pegar inteligente
  • xcopy “E:\Source\MyProject\styles\*.*” “E:\Destine\MyProject\styles\*.*” /EXCLUDE:C:\FileList.txt /d/e/y/i
• Obtener el listado de archivos de un folder con subfolders
  • dir /s /b>FileList.txt
• Borrar una lista corrupta
  • $web = get-spweb -Identity http://sp2010
  • $web.lists | select Title
  • $list = $web.lists[“corrupted list name”]
  • $list.AllowDeletion = $true
  • $list.Update()
  • $list.Delete()
• — reset the logging thresholds loggin SharePoint
  • stsadm -o setlogginglevel -category IRM -default
  • Get-SPLogLevel | Clear-SPLogLevel
• to windows config hour sinchronize whit DC
  • w32tm /query /status
  • w32tm /resync
  • w32tm /config /syncfromflags:manual /manualpeerlist: [lista]   , donde [lista] son los nombres DNS o IP de los servidores con los que se debe sincronizar, separados por comas
• Get AD usuarios con un dato especifico
  • Get-ADUser -filter {employeeID -like “*” }| Get-ADObject -properties employeeid | Format-List name,employeeid
• Actualizar un parametro con un CSV usuarios de AD
  • Import-CSV C:\test.csv | foreach { Set-ADUser $_.username -EmployeeID $_.id }
• SQL Commands
  • NOT LIKE ‘%[^0-9]%’ isnumeric dont work for e or d
  • http://www.sqlservercentral.com/articles/IsNumeric/71512/
• IIS Commands enable Rastreo de procesos del Pool
  • cd C:\Windows\System32\inetsrv
  • appcmd list wp
  • appcmd list wps /apppool.name:DefaultAppPool
  • IIS 7.0 -> Root -> Worker Process “Procesos de Trabajo” -> Select -> ver solicitudes actuales
  • IIS 6.0 cscript iisapp.vbs

New-SPConfigurationDatabase : Cannot bind parameter ‘FarmCredentials’. Cannot convert the “xxx” value of type “System.String” to type “System.Management.Automation.PSCredential”. May 8, 2012

Hola

Este sucede cuando se corre el comando

New-SPConfigurationDatabase -DatabaseName “SharePoint_Config” -DatabaseServer “.” -Passphrase  (ConvertTo-SecureString “MyPassword” -AsPlainText -force) -FarmCredentials “SHPJUANPABLOPC\shpservice”

Una forma de arreglarlo es correrlo sin el parametro de -FarmCredentials, al hacerlo se nos despliega una ventana solicitando las credenciales

New-SPConfigurationDatabase -DatabaseName “SharePoint_Config” -DatabaseServer “.” -Passphrase  (ConvertTo-SecureString “MyPassword” -AsPlainText -force)