Ali Can's Sharepoint Tools

Steps Of SpFx with jQueryUI

2018-01-09T14:59:00.000+03:00

Steps Of SpFx with jQueryUI

1. Setup and configure spfx
https://docs.microsoft.com/en-us/sharepoint/dev/spfx/set-up-your-development-environment
Let’s Create a client-side webpart (Add jQueryUI Accordion to your SharePoint client-side web part)

2. Create Directory
>> md testWp

3. Enter Directory
>> cd testWp

Create a new web part by running the Yeoman SharePoint Generator
>> yo @microsoft/sharepoint

Accept the default jquery-webpart as your solution name and choose Enter.
Choose SharePoint Online only (latest), and press Enter.
Select Use the current folder for where to place the files.
Choose N to require the extension to be installed on each site explicitly when it's being used.
Choose WebPart as the client-side component type to be created.

The next set of prompts will ask for specific information about your web part:
Type jQuery for the web part name and choose Enter.
Enter jQuery Web Part as the description of the web part and choose Enter.
Accept the default No JavaScript framework option for the framework and choose Enter to continue.

4. Once the scaffolding completes, lock down the version of the project dependencies by running the following command:
>> npm shrinkwrap

Next, type the following to open the web part project in Visual Studio Code:
>> code .

5. In the console, type the following to install jQuery npm package:
>> npm install --save jquery@2
Now type the following to install jQueryUI npm package:
>> npm install --save jqueryui

6. Next we'll need to install the typings for our project. Starting from TypeScript 2.0, we can use npm to install needed typings.
>> npm install --save @types/jquery@2
>> npm install --save @types/jqueryui

7. Unbundle external dependencies from web part bundle
By default, any dependencies you add are bundled into the web part bundle. In some cases, this is not ideal. You can choose to unbundle these dependencies from the web part bundle.

In Visual Studio Code, open the file config\config.json.

This file contains information about your bundle(s) and any external dependencies.

The bundles region contains the default bundle information - in this case, the jQuery web part bundle. When you add more web parts to your solution, you will see one entry per web part

{

"$schema": "https://dev.office.com/json-schemas/spfx-build/config.2.0.schema.json",

"version": "2.0",

"bundles": {

"j-query-web-part": {

"components": [

{

"entrypoint": "./lib/webparts/jQuery/JQueryWebPart.js",

"manifest": "./src/webparts/jQuery/JQueryWebPart.manifest.json"

}

]

}

"externals": {

"jquery":"node_modules/jquery/dist/jquery.min.js",

"jqueryui":"node_modules/jqueryui/jquery-ui.min.js"

"localizedResources": {

"JQueryWebPartStrings": "lib/webparts/jQuery/loc/{locale}.js"

}

8. Build the Accordion
Open the project folder jquery-webpart in Visual Studio Code. Your project should have the jQuery web part that you added earlier under the /src/webparts/jQuery folder.

Add Accordion HTML
Add a new file in the src/webparts/jQuery folder called MyAccordionTemplate.ts.
Create and export (as a module) a class MyAccordionTemplate that holds the HTML code for the accordion.

  export default class MyAccordionTemplate {
    public static templateHtml: string =  ‘
      

Section 1

Mauris mauris ante, blandit et, ultrices a, suscipit eget, quam. Integer ut neque. Vivamus nisi metus, molestie vel, gravida in, condimentum sit  amet, nunc. Nam a nibh. Donec suscipit eros. Nam mi. Proin viverra leo ut odio. Curabitur malesuada. Vestibulum a velit eu ante scelerisque vulputate.
            

Section 2

Sed non urna. Donec et ante. Phasellus eu ligula. Vestibulum sit amet purus. Vivamus hendrerit, dolor at aliquet laoreet, mauris turpis porttitor            velit, faucibus interdum tellus libero ac justo. Vivamus non quam. In suscipit faucibus urna.
            

Section 3

Nam enim risus, molestie et, porta ac, aliquam ac, risus. Quisque lobortis. Phasellus pellentesque purus in massa. Aenean in pede. Phasellus ac libero ac tellus pellentesque semper. Sed ac felis. Sed commodo, magna quis lacinia ornare, quam ante aliquam nisi, eu iaculis leo purus venenatis dui.
            


List item one
List item two
List item three



Section 4

Cras dictum. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum ante ipsum primis in            faucibus orci luctus et ultrices posuere cubilia Curae; Aenean lacinia mauris vel est.
            

Suspendisse eu nisl. Nullam ut libero. Integer dignissim consequat lectus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per            inceptos himenaeos.
            

’;
}

9. Import Accordion HTML
In Visual Studio Code, open src\webparts\jQuery\JQueryWebPart.ts.
At the top of the file, where you can find other imports, add the following import:
import MyAccordionTemplate from './MyAccordionTemplate';

10. Import jQuery and jQueryUI
You can import jQuery your web part in the same way that you imported MyAccordionTemplate.
At the top of the file, where you can find other imports, add the following imports:
import * as jQuery from 'jquery';
import 'jqueryui';
Next, you'll load some external css files. To do that, use the module loader. Add the following import:
import { SPComponentLoader } from '@microsoft/sp-loader';

11.      To load the jQueryUI styles, in the JQueryWebPart web part class, you'll need to add a constructor and use the newly imported SPComponentLoader. Add following constructor to your web part.
public constructor() {
    super();
    SPComponentLoader.loadCss('//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css');
}
This code does the following:
Calls the parent constructor with the context to initialize the web part.
Loads the accordion styles from a CDN asynchronously.

Render Accordion

In the jQueryWebPart.ts, go to the render method.
Set the web part's inner HTML to render the accordion HTML:

public render(): void {
  this.domElement.innerHTML = MyAccordionTemplate.templateHtml;
  const accordionOptions: JQueryUI.AccordionOptions = {
    animate: true,
    collapsible: false,
    icons: {
      header: 'ui-icon-circle-arrow-e',
      activeHeader: 'ui-icon-circle-arrow-s'
    }
  };
  jQuery('.accordion', this.domElement).accordion(accordionOptions);
}

>> gulp serve

https://docs.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/get-started/add-jqueryui-accordion-to-web-part

Sharepoint PowerShell Count List Items By Moderation Status

2018-01-09T11:47:00.002+03:00

Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue
$site = Get-SPSite("http://testurl")
$OutArray = @()
foreach($web in $site.AllWebs)
{

$list = $web.Lists.TryGetList("Sayfalar")
$listitems = $list.Items | where {$_['_ModerationStatus'] -eq 0}
$Count = $listitems.Count
Write-Host $web.Url ">>" $Count

}

List All Content Types & Get List Of Items (documents/pages) used by Content types (PowerShell)

2016-12-21T17:32:00.000+03:00

List All Content Types

$site = Get-SPSite  http://testsiteur

$web = $site.RootWeb

foreach ($ctype in $web.ContentTypes) {$ctype.Name+" :"+ $ctype.ID}

Get List Of Items (documents/pages) used by Content types

$webs = get-spsite http://testsiteurl | get-spweb

foreach ($web in $webs)
{
foreach ($lst in $web.lists)
{
foreach ($item in $lst.Items)
{
if ($item.ContentType.Name -eq "Telefon")
{ $item.ContentType.Name +"-"+ $item.Url}
}
}
$web.Dispose()
}

Get All Content Databases from SQL by PowerShell

2016-12-21T17:21:00.000+03:00

[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
$sqlServer = new-object ("Microsoft.SqlServer.Management.Smo.Server") "test\testsqlserver"
foreach($sqlDatabase in $sqlServer.databases) {$sqlDatabase.name}

Sharepoint Get All Features by PowerShell

2016-12-19T17:58:00.002+03:00

Get-SPFeature | Sort @{Expression={$_.GetTitle(1033)}} -Descending:$false |
ft @{Label='ID';Width=40;Expression={$_.Id}}, @{Label='Title';Width=250;Expression={$_.GetTitle(1033)}} |
Out-File -Width 350 "c:\TEMP\features.txt"

Get SharePoint Content Database Sizes by PowerShell

2016-12-19T17:55:00.002+03:00

$date = Get-Date -Format "dd-MM-yyyy"
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
$TXTFile = "c:ReportsSPContentDatabase_$date.txt"
$webapps = Get-SPWebApplication
foreach($webapp in $webapps)
{
$ContentDatabases = $webapp.ContentDatabases
Add-Content -Path $TXTFile -Value "Content databases for $($webapp.url)"
foreach($ContentDatabase in $ContentDatabases)
{
$ContentDatabaseSize = [Math]::Round(($ContentDatabase.disksizerequired/1GB),2)
Add-Content -Path $TXTFile -Value "- $($ContentDatabase.Name): $($ContentDatabaseSize)GB"
}
}
------------------------------------------------------------------------------------------

-Send Results By Email-

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
$date = Get-Date -Format "dd-MM-yyyy"
$TXTFile = "c:ReportsSPContentDatabase_$date.txt"
$SMTPServer = "relay.com"
$emailFrom = "test@test.com"
$emailTo = "testto@test.com"
$subject = "Content Database size reports"
$emailBody = "Daily/Weekly/Monthly report on Content databases"

$webapps = Get-SPWebApplication
foreach($webapp in $webapps)
{
$ContentDatabases = $webapp.ContentDatabases
Add-Content -Path $TXTFile -Value "Content databases for $($webapp.url)"
foreach($ContentDatabase in $ContentDatabases)
{
$ContentDatabaseSize = [Math]::Round(($ContentDatabase.disksizerequired/1GB),2)
Add-Content -Path $TXTFile -Value "- $($ContentDatabase.Name): $($ContentDatabaseSize)GB"
}
}
if(!($SMTPServer) -OR !($emailFrom) -OR !($emailTo))
{
Write-Host "No e-mail being sent, if you do want to send an e-mail, please enter the values for the following variables: $SMTPServer, $emailFrom and $emailTo."
}
else
{
Send-MailMessage -SmtpServer $SMTPServer -From $emailFrom -To $emailTo -Subject $subject -Body $emailBody -Attachment $TXTFile
}

Internal Value for Approval Status

2016-11-14T16:45:00.002+03:00

This post is mainly for my own reference purpose. The internal field name for approval status of a list/library item is _ModerationStatus, which has corresponding values and it is type of ModStat:

Status	Internal Value
Approved	0
Rejected	1
Pending	2
Draft	3

Sample usage for these values in CAML query : Retrieve all Approved documents from a particular document library

CAML query would look something like below:

Referance:

http://sharepointwriting.blogspot.com.tr/2011/10/internal-value-for-approval-status.html

Create Site Columns & Site Content Types by PowerShell

2016-10-07T13:46:00.000+03:00

Take care all columns Web id & Lookup Filed List id
If you have Lookup field first create list and get id

-Create Site Columns-

$destWeb = Get-SPWeb http://yoursite.import.com
$installPath = "c:\Backup"
$fieldsXML = [xml](Get-Content($installPath + "\Script-SiteColumns.xml"))

$fieldsXML.Fields.Field | ForEach-Object {

#Configure core properties belonging to all column types
$fieldXML = '
Name="' + $_.Name + '"
ID="' + $_.ID + '"
Description="' + $_.Description + '"
DisplayName="' + $_.DisplayName + '"
StaticName="' + $_.StaticName + '"
Group="' + $_.Group + '"
Hidden="' + $_.Hidden + '"
Required="' + $_.Required + '"
Sealed="' + $_.Sealed + '"'

#Configure optional properties belonging to specific column types – you may need to add some extra properties here if present in your XML file
if ($_.ShowInDisplayForm) { $fieldXML = $fieldXML + "`n" + 'ShowInDisplayForm="' + $_.ShowInDisplayForm + '"'}
if ($_.ShowInEditForm) { $fieldXML = $fieldXML + "`n" + 'ShowInEditForm="' + $_.ShowInEditForm + '"'}
if ($_.ShowInListSettings) { $fieldXML = $fieldXML + "`n" + 'ShowInListSettings="' + $_.ShowInListSettings + '"'}
if ($_.ShowInNewForm) { $fieldXML = $fieldXML + "`n" + 'ShowInNewForm="' + $_.ShowInNewForm + '"'}

if ($_.EnforceUniqueValues) { $fieldXML = $fieldXML + "`n" + 'EnforceUniqueValues="' + $_.EnforceUniqueValues + '"'}
if ($_.Indexed) { $fieldXML = $fieldXML + "`n" + 'Indexed="' + $_.Indexed + '"'}
if ($_.Format) { $fieldXML = $fieldXML + "`n" + 'Format="' + $_.Format + '"'}
if ($_.MaxLength) { $fieldXML = $fieldXML + "`n" + 'MaxLength="' + $_.MaxLength + '"' }
if ($_.FillInChoice) { $fieldXML = $fieldXML + "`n" + 'FillInChoice="' + $_.FillInChoice + '"' }
if ($_.NumLines) { $fieldXML = $fieldXML + "`n" + 'NumLines="' + $_.NumLines + '"' }
if ($_.RichText) { $fieldXML = $fieldXML + "`n" + 'RichText="' + $_.RichText + '"' }
if ($_.RichTextMode) { $fieldXML = $fieldXML + "`n" + 'RichTextMode="' + $_.RichTextMode + '"' }
if ($_.IsolateStyles) { $fieldXML = $fieldXML + "`n" + 'IsolateStyles="' + $_.IsolateStyles + '"' }
if ($_.AppendOnly) { $fieldXML = $fieldXML + "`n" + 'AppendOnly="' + $_.AppendOnly + '"' }
if ($_.Sortable) { $fieldXML = $fieldXML + "`n" + 'Sortable="' + $_.Sortable + '"' }
if ($_.RestrictedMode) { $fieldXML = $fieldXML + "`n" + 'RestrictedMode="' + $_.RestrictedMode + '"' }
if ($_.UnlimitedLengthInDocumentLibrary) { $fieldXML = $fieldXML + "`n" + 'UnlimitedLengthInDocumentLibrary="' + $_.UnlimitedLengthInDocumentLibrary + '"' }
if ($_.CanToggleHidden) { $fieldXML = $fieldXML + "`n" + 'CanToggleHidden="' + $_.CanToggleHidden + '"' }
if ($_.List) { $fieldXML = $fieldXML + "`n" + 'List="' + $_.List + '"' }
if ($_.ShowField) { $fieldXML = $fieldXML + "`n" + 'ShowField="' + $_.ShowField + '"' }
if ($_.UserSelectionMode) { $fieldXML = $fieldXML + "`n" + 'UserSelectionMode="' + $_.UserSelectionMode + '"' }
if ($_.UserSelectionScope) { $fieldXML = $fieldXML + "`n" + 'UserSelectionScope="' + $_.UserSelectionScope + '"' }
if ($_.BaseType) { $fieldXML = $fieldXML + "`n" + 'BaseType="' + $_.BaseType + '"' }
if ($_.Mult) { $fieldXML = $fieldXML + "`n" + 'Mult="' + $_.Mult + '"' }
if ($_.ReadOnly) { $fieldXML = $fieldXML + "`n" + 'ReadOnly="' + $_.ReadOnly + '"' }
if ($_.FieldRef) { $fieldXML = $fieldXML + "`n" + 'FieldRef="' + $_.FieldRef + '"' }

$fieldXML = $fieldXML + ">"

#Create choices if choice column
if ($_.Type -eq "Choice") {
$fieldXML = $fieldXML + "`n"
$_.Choices.Choice | ForEach-Object {
$fieldXML = $fieldXML + "`n" + $_ + ""
}
$fieldXML = $fieldXML + "`n
" }

#Set Default value, if specified
if ($_.Default) { $fieldXML = $fieldXML + "`n" + $_.Default + "" }

#End XML tag specified for this field
$fieldXML = $fieldXML + "
"
#Create column on the site
$destWeb.Fields.AddFieldAsXml($fieldXML.Replace("&","&"))
write-host "Created site column" $_.DisplayName "on" $destWeb.Url

$destWeb.Dispose()
}

-Get Site Column & Content TYPES-

$sourceWeb = Get-SPWeb http://yoursite.export.com
$xmlFilePath = "C:\Backup\Script-SiteContentTypes.xml"

#Create Export File
New-Item $xmlFilePath -type file -force

#Export Content Types to XML file
Add-Content $xmlFilePath ""
Add-Content $xmlFilePath "`n"
$sourceWeb.ContentTypes | ForEach-Object {
if ($_.Group -eq "your Export Content Type") {
Add-Content $xmlFilePath $_.SchemaXml
}
}
Add-Content $xmlFilePath "
"
$sourceWeb.Dispose()

-Create Site Columns And Content Types-

$destWeb = Get-SPWeb http://yoursite.import.com
$xmlFilePath = "C:\Backup\Script-SiteContentTypes.xml"
#Create Site Content Types
$ctsXML = [xml](Get-Content($xmlFilePath))
$ctsXML.ContentTypes.ContentType | ForEach-Object {

#Create Content Type object inheriting from parent
$spContentType = New-Object Microsoft.SharePoint.SPContentType ($_.ID,$destWeb.ContentTypes,$_.Name)

#Set Content Type description and group
$spContentType.Description = $_.Description
$spContentType.Group = $_.Group

$_.Fields.Field | ForEach-Object {
if(!$spContentType.FieldLinks[$_.DisplayName])
{
#Create a field link for the Content Type by getting an existing column
$spFieldLink = New-Object Microsoft.SharePoint.SPFieldLink ($destWeb.Fields[$_.DisplayName])

#Check to see if column should be Optional, Required or Hidden
if ($_.Required -eq "TRUE") {$spFieldLink.Required = $true}
if ($_.Hidden -eq "TRUE") {$spFieldLink.Hidden = $true}

#Add column to Content Type
$spContentType.FieldLinks.Add($spFieldLink)
}
}

#Create Content Type on the site and update Content Type object
$ct = $destWeb.ContentTypes.Add($spContentType)
$spContentType.Update()
write-host "Content type" $ct.Name "has been created"
}

$destWeb.Dispose()

--------------------------------------------------------------------------------------------------
Referenced : http://get-spscripts.com/2011/02/export-and-importcreate-site-content.html

Thanks man :)

Sharepoint Online Redirect(Sandbox solution)

2016-01-26T16:29:00.000+02:00

Sharepoint Field get ıtem Append Changes to Existing Text

2015-12-18T13:29:00.004+02:00

public static string GetVersionedMultiLineTextAsPlainText(SPListItem item, string key)
{

StringBuilder sb = new StringBuilder();

foreach (SPListItemVersion version in item.Web.Lists[item.ParentList.ID].Items[item.UniqueId].Versions)
{

SPFieldMultiLineText field = version.Fields[key] as SPFieldMultiLineText;

if (field != null)
{

string comment = field.GetFieldValueAsText(version[key]);

if (comment != null && comment.Trim() != string.Empty)
{

sb.Append("");

sb.Append(version.CreatedBy.User.Name).Append(" (");

sb.Append(version.Created.ToString("MM/dd/yyyy hh:mm tt"));

sb.Append(")

");
sb.Append("-" + comment);
sb.Append("
");
}

}

}

return sb.ToString();

}

Button Click => FileUplaod

2015-12-07T09:59:00.004+02:00

lnkbtnAddPhoto.Attributes.Add("onclick", "document.getElementById('" + FileUpload1.ClientID + "').click()");

Sharepoint infopath submit form by date/user/item id

2015-11-24T10:48:00.000+02:00

Submit formula:

concat(substring-before(now(); "T"); "-"; substring-after(userName(); "domain");"-";"formID=", max(ID) + 1 )

Referans:
http://www.spointblog.com/Pages/Post.aspx?ItemID=26

Sharepoint login as different user

2015-11-17T16:47:00.001+02:00

Text="<%$Resources:wss,personalactions_loginasdifferentuser%>"
Description="<%$Resources:wss,personalactions_loginasdifferentuserdescription%>"
MenuGroupId="100"
Sequence="100"
UseShortId="true" />

C:\Program Files\Common Files\Microsoft shared\Web ServerExtensions\15\TEMPLATE\CONTROLTEMPLATES Gidip:

Welcome.ascx user kontrolünün NOTEPAD'le açıp içine yukarıda yazdığım kontrolü yapıştırıp kaydedin.

SpList Status Indicator

2015-11-17T10:35:00.003+02:00

Referenced: http://officepowerups.com/2013/06/11/display-icons-in-sharepoint-list/

Event Receiver Properties

2015-11-12T11:56:00.002+02:00

Library         BeforeProperties    AfterProperties    properties.ListItem
ItemAdding      No value            No value           Null
ItemAdded       No value            No value           New value
ItemUpdating    Original value      Changed value      Original value
ItemUpdated     Original value      Changed value      Changed value
ItemDeleting    No value            No value           Original value
ItemDeleted     No value            No value           Null

Dursun bi şurda :D

infopath -This session has exceeded the amount of allowable resources(Bu oturum izin verilen kaynak miktarını aştı)

2015-09-11T11:23:00.003+03:00

Sharepoint InfoPath Forms Servisleri ile ilgili bir problem.

Formun içinde repeating table kullandığınızda her bir eklediğiniz değer postback sayısını ve session'ın büyüklüğünü arttırdığından dolayı karşılaşıcağınız bir problemdir.

Çözümü:

1.adım:

SharePoint 2013 Central Administration açın
General Application Setting => Configure InfoPath Forms Services'e gidip

2.adım:

Değerlerini değiştirdiğinizde problem çözülmüş olacak.

Office 365 - Sharepoint Online App Development Tools

2015-09-03T10:42:00.000+03:00

Sharepoint online'da geliştirme yapılırken gerekli toolların Nuget Console kullanarak otomatik olarak indirilmesi işimizi kolaylaştırmakta. :)

Farm uygulamaları için olan Sharepoint Manager'ın yerini burada Sharepoint Client Browser'a bırakmış bulunuyoruz.

Nuget & Tools

SharePoint Online CSOM NuGet

Office 365 Patterns and Practices NuGet

SharePoint Client Browser

SharePoint 2013 – DateControl “Access Denied” (error in '/' application. runtime error)

2015-09-02T17:42:00.006+03:00

Sharepoint DateTimeControl açilirken "/_layouts/15/iframe.aspx" frame Url ini kullanmanktadir.
Kesin karşılacaginiz bir problem.

Çözüm:

-On Page load
DateTimeControl dtPicker.DatePickerFrameUrl =ResolveUrl(SPContext.Current.Site.Url + “/_layouts/15/iframe.aspx”);

Veya

dtTarih1.DatePickerFrameUrl =ResolveUrl(SPContext.Current.Site.Url + “/_layouts/15/iframe.aspx”);

Sharepoint Read From Csv File to fill SP List By using Site Language (Event Receiver)

2015-08-24T10:06:00.003+03:00

Merhaba,
Event Receiver kullanarak Csv file'den okunan verilerin sharepoint listesine eklenmesi için yaptığım basit çalışmayı paylaşmak istedim.

----------------------------------------------------------------------------------------

public override void FeatureActivated(SPFeatureReceiverProperties properties)
{
using (SPWeb spWeb = (properties.Feature.Parent as SPWeb))

{
uint languageid = (uint)spWeb.Language;
string filePath;
if (languageid == 1055) //Turkish or not
{
filePath = SPUtility.GetVersionedGenericSetupPath(@"TEMPLATE\LAYOUTS\iso27001\TestTr.csv", 15);
}
else
{
filePath = SPUtility.GetVersionedGenericSetupPath(@"TEMPLATE\LAYOUTS\iso27001\TestEng.csv", 15);
}

SPList myList = spWeb.Lists["listname"];
while ((line = file.ReadLine()) != null)
{

String[] Array = line.ToString().Split('\t');

StreamReader file;

file = new StreamReader(filePath);

SPListItem newEntry = myList.Items.Add();

newEntry["Title"] = Array[0];
newEntry["Test1"] = Array[1];
newEntry["Test2"] = Array[2];

newEntry["Test3"] = Array[3];
newEntry.Update();
myList.Update();
}

file.Close();

file.Dispose();
}

}

Sharepoint Logout Url

2015-02-19T01:31:00.000+02:00

Write after site

/_layouts/closeConnection.aspx?loginasanotheruser=true

Google Api OpenWeatherMap 7 Days Weather Condition Asp.net

2015-02-09T02:01:00.003+02:00

Weather Conditıon Read From OpenWeatherMap XML.

private void getWeather()
{
XmlDocument doc1 = new XmlDocument();
doc1.Load("http://api.openweathermap.org/data/2.5/forecast/daily?q=izmir&mode=xml&units=metric&cnt=7");
XmlElement root = doc1.DocumentElement;
XmlNodeList timenodes = root.SelectNodes("/weatherdata");
XmlNodeList nodes = root.SelectNodes("/weatherdata/forecast/time");

foreach (XmlNode node in nodes)
{
string time = node.Attributes["day"].InnerText;
string condition = node.SelectSingleNode("symbol").Attributes["name"].InnerText;

string precipitation = node.SelectSingleNode("precipitation").Attributes["type"].InnerText;

string windDeg = node.SelectSingleNode("windDirection").Attributes["deg"].InnerText;
string windDirection = node.SelectSingleNode("windDirection").Attributes["name"].InnerText;

string windSpeed = node.SelectSingleNode("windSpeed").Attributes["mps"].InnerText;
string windCondition = node.SelectSingleNode("windSpeed").Attributes["name"].InnerText;

string tempday = node.SelectSingleNode("temperature").Attributes["day"].InnerText;
string tempmin = node.SelectSingleNode("temperature").Attributes["min"].InnerText;
string tempmax = node.SelectSingleNode("temperature").Attributes["max"].InnerText;
string tempnight = node.SelectSingleNode("temperature").Attributes["night"].InnerText;
string tempeve = node.SelectSingleNode("temperature").Attributes["eve"].InnerText;
string tempmorn = node.SelectSingleNode("temperature").Attributes["morn"].InnerText;

string humidityVal = node.SelectSingleNode("humidity").Attributes["value"].InnerText + node.SelectSingleNode("humidity").Attributes["unit"].InnerText;

string cloudval = node.SelectSingleNode("clouds").Attributes["value"].InnerText;
string cloudPercent = node.SelectSingleNode("clouds").Attributes["all"].InnerText + node.SelectSingleNode("clouds").Attributes["unit"].InnerText;

}

}

Sharepoint Column E-mail Validation Formula

2014-12-22T13:30:00.000+02:00

Sharepoint List Column E-Mail Validation Fromula 

=AND(    ISERROR(FIND(" ", [Email],1)), 

IF(ISERROR(FIND("@", [Email],2)), 

FALSE, AND(ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),

IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),FALSE,FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])))))

Reference

http://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/

Recycle IIS application pool”: The local sharepoint server is not available "

2014-11-28T18:28:00.001+02:00

The local Sharepoint server is not available

Çözümü: Sql Database'inde bulunan sharepoint_config ve sharepoint_admin database'lerine db_owner rolü verin. Sorunu çözmüş oluruz.

SharePoint Designer : Unexpected Error on server associating the workflow

2014-11-26T10:41:00.002+02:00

Sharepoint Designer'da genelde Workflow Publish Activating işleminde karşılaşılan bir durum.Bazı kaynaklarda IISReset işlemi ile çözülebileceğini açıklamışlar.

Sharepoint Designer'ın Cache sorunlarından biridir.

Benim kendi çözümüm server'ı RESTART etmek ama aşağıdaki linklerden de çözüme ulaşabileceğinizi düşünüyorum.

Çözüm 1 (Solution 1)

Çözüm 2 (Solution 2) :IISRESET

Çözüm 3 (Solution 3)

Çözüm 4 (Solution 4): Restart The Server

Sharepoint Farm Domain User Olmadan Oluşturulması

2014-11-01T23:43:00.002+02:00

Herkes Domain Kullanıcısına sahip olmayabilir.Sql Server'da Windows kullanıcısı kullanmak istiyorsunuzdur.Sharepoint Farmını Windows Kullanıcısıyla nasıl oluşturulacağını aşağıda belirttiğim sırayla yapabilirsiniz.

Sharepoint Configuration Wizard'ta aldığımız hata üsteki gibi olmalı.
SharePoint Management Shell'i admin olarak açıyoruz.
Shell'e New-SPConfigurationDatabase yazıp ENTER'lıyoruz.
Oluşturacağınız Sp Database ismini ve Sql Serverınızın ismini veriyoruz.
Sizden Local Kullanıcınızı isteyecektir.
Passphrase'de hatırlayacağınız bir şifre verein.Bu işlem 2-3 dakika sürebilir.
C:\Users a düşmeden kapatmayın.

Passphrase'de hatırlayacağınız bir şifre verein.

SpConfiguration Wizard'ı yeniden açın ve aşağıdaki gibi işleme devam edin.

Next & Finish.

Referans: Tıkla

Ali Can's Sharepoint Tools

Steps Of SpFx with jQueryUI

Section 1

Section 2

Section 3

Section 4

Sharepoint PowerShell Count List Items By Moderation Status

List All Content Types & Get List Of Items (documents/pages) used by Content types (PowerShell)

List All Content Types

Get List Of Items (documents/pages) used by Content types

Get All Content Databases from SQL by PowerShell

Sharepoint Get All Features by PowerShell

Get SharePoint Content Database Sizes by PowerShell

Internal Value for Approval Status

Create Site Columns & Site Content Types by PowerShell

-Get Site Columns-

-Create Site Columns-

-Get Site Column & Content TYPES-

-Create Site Columns And Content Types-

Sharepoint Online Redirect(Sandbox solution)

Sharepoint Field get ıtem Append Changes to Existing Text

Button Click => FileUplaod

Sharepoint infopath submit form by date/user/item id

Sharepoint login as different user

SpList Status Indicator

Event Receiver Properties

infopath -This session has exceeded the amount of allowable resources(Bu oturum izin verilen kaynak miktarını aştı)

Office 365 - Sharepoint Online App Development Tools

SharePoint 2013 – DateControl “Access Denied” (error in '/' application. runtime error)

Sharepoint Read From Csv File to fill SP List By using Site Language (Event Receiver)

Sharepoint Logout Url

Google Api OpenWeatherMap 7 Days Weather Condition Asp.net

Sharepoint Column E-mail Validation Formula

Recycle IIS application pool”: The local sharepoint server is not available "

SharePoint Designer : Unexpected Error on server associating the workflow

Sharepoint Farm Domain User Olmadan Oluşturulması