def data = [
['id', 'Task', 'Name', 'Description'],
['1', 'Create', 'Jira', 'System Project'],
['2', 'Read', 'Confluence', 'Wiki'],
['3', 'Update', 'SharePoint', 'Portal']
]
def file = new File("C:/Temp/data.csv")
def stringBuilder = new StringBuilder()
data.each { row ->
stringBuilder.append(row.join(';')).append(System.lineSeparator())
}
file.text = stringBuilder.toString()
public static string GetEncodedCredentials(string UserName, string Password)
{
string mergedCredentials = String.Format("{0}:{1}", UserName, Password);
byte[] byteCredentials = Encoding.UTF8.GetBytes(mergedCredentials);
return Convert.ToBase64String(byteCredentials);
}
static void Main(string[] args)
{
string baseUrl = "http://jira.server.net:8080";
string UserName = "login";
string Password = "password";
try
{
string restUrl = String.Format("{0}/rest/api/2/project", baseUrl);
HttpWebResponse response = null;
HttpWebRequest request = WebRequest.Create(restUrl) as HttpWebRequest;
request.Method = "GET";
request.Accept = "application/json";
request.ContentType = "application/json";
request.Headers.Add("Authorization", "Basic " + GetEncodedCredentials(UserName, Password));
using (response = request.GetResponse() as HttpWebResponse)
{
StreamReader reader = new StreamReader(response.GetResponseStream());
string responseContent = reader.ReadToEnd();
dynamic data = JsonConvert.DeserializeObject(responseContent);
var array = data;
for (int i = 0; i < array.Count; i++)
{
var resp = array[i];
string name = resp.name;
Console.WriteLine(name);
}
}
}
catch (Exception ex)
{
throw ex;
}
Console.ReadLine();
}import groovy.json.JsonSlurper
def conn = "http://jira.server.net:8080/rest/api/2/project/".toURL().openConnection()
conn.setRequestProperty('Authorization', 'Basic ' + 'login:password'.bytes.encodeBase64().toString())
if(conn.responseCode == 200) {
def jsonSlurper = new JsonSlurper()
def result = jsonSlurper.parseText(conn.content.text)
println "json name:${result.name}"
} else {
println "Something bad happened."
println "${conn.responseCode}: ${conn.responseMessage}"
}$("textarea[title='Client']").prop('disabled', true);
$("textarea[title='Client']").prop('disabled', 'disabled');
$("textarea[title='Client']").attr("disabled", "disabled");
$("div[id^='Client']").attr("readonly","true");
$("input[title='Client']").attr("readonly","true").css('background-color','#F6F6F6');
$("div[id^='Client']").attr("contentEditable","false").css('background-color','#F6F6F6');
static void Main(string[] args)
{
ClientContext cxt = new ClientContext("http://sp-test/sites/test");
List list = cxt.Web.Lists.GetByTitle("Documents");
cxt.Load(list);
cxt.Load(list.RootFolder);
cxt.Load(list.RootFolder.Folders);
cxt.Load(list.RootFolder.Files);
cxt.ExecuteQuery();
FolderCollection folders = list.RootFolder.Folders;
foreach (Folder folder in folders)
{
if ((folder.Name != "Forms")&(folder.Name == "Special Documents"))
{
cxt.Load(folder.Files);
cxt.ExecuteQuery();
FileCollection fileCol = folder.Files;
foreach (Microsoft.SharePoint.Client.File file in fileCol)
{
string ServerRelativeUrl = file.ServerRelativeUrl;
DownloadFiles(ServerRelativeUrl);
}
}
}
}
public static void DownloadFiles(string ServerRelativeUrl)
{
ClientContext clientContext = new ClientContext("http://sp-test/sites/test");
Web web = clientContext.Web;
Microsoft.SharePoint.Client.File filetoDownload = web.GetFileByServerRelativeUrl(ServerRelativeUrl);
clientContext.Load(filetoDownload);
clientContext.ExecuteQuery();
var fileRef = filetoDownload.ServerRelativeUrl;
var fileInfo = Microsoft.SharePoint.Client.File.OpenBinaryDirect(clientContext, fileRef);
var fileName = Path.Combine(@"C:\Temp\Document", (string)filetoDownload.Name);
using (var fileStream = System.IO.File.Create(fileName))
{
fileInfo.Stream.CopyTo(fileStream);
}
}
if(!(Get-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction:SilentlyContinue))
{
Add-PsSnapin Microsoft.SharePoint.PowerShell
}
$webURL = "http://sp-test/sites/RU_test"
$docLibraryName = "Documents"
$User = 'i:0#.w|micro\administrator'
$web = Get-SPWeb $webURL
$docLibrary = $web.Lists[$docLibraryName]
$audit = $docLibrary.Audit
$auditEntries = $audit.GetEntries()
$targetUserId = $web.AllUsers | Where{$_.UserLogin -eq 'i:0#.w|micro\administrator'}
$Output = @()
foreach($entry in ($auditEntries | Select -unique))
{
$FileName = $entry.DocLocation
$userId = $entry.UserId
$userEntry = $web.AllUsers | Where{$_.ID -eq $userId}
$userName = $userEntry.UserLogin
$Output+=New-Object -TypeName PSObject -Property @{
FileName = $FileName
userName = $userName
Occurred = $entry.Occurred
Event = $entry.Event
} | Select-Object FileName,userName,Occurred,Event
}
$Output | Export-Csv -Path 'C:\Temp\audit.csv' -NoTypeInformation -Encoding unicode -Delimiter "`t"
if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
Write-Host "Connect Sharepoint cmd-Let"
Add-PSSnapin Microsoft.SharePoint.PowerShell
}
$SPweb = Get-SPWeb "http://sp-test/sites/RU_test"
$lst1 = $SPweb.Lists["List1"]
$lst2 = $SPweb.Lists["List2"]
$columns1 = ($lst1.Fields | where {$_.Title -like "column*"}).Title
$columns2 = ($lst2.Fields | where {$_.Title -like "column*"}).Title
$linesCount=$lst1.ItemCount
$colCount1 = $columns1.Count
$colCount2 = $columns2.Count
$result = @()
for ($line=0; $line -lt $linesCount; $line++)
{
$line1 = $lst1.Items[$line]
$line2 = $lst2.Items[$line]
$props = @{}
for ($col=0; $col -lt $colCount1; $col++)
{
$props+=@{$columns1[$col]=$line1[$columns1[$col]]}
}
for ($col=0; $col -lt $colCount2; $col++)
{
$props+=@{$columns2[$col]=$line2[$columns2[$col]]}
}
$result += New-Object PSObject -Property $props
}
$result | Export-Csv -Path 'C:\Temp\Export.csv' -NoTypeInformation -Encoding unicode -Delimiter "`t"
using System;
using System.IO;
using System.Text;
using Microsoft.SharePoint;
namespace EventRecieverTest.EventReceiverTestList
{
public class EventReceiverTestList : SPItemEventReceiver
{
public override void ItemAdded(SPItemEventProperties properties)
{
using (SPWeb web = properties.OpenWeb())
{
try
{
//getcurrentitem
SPListItem currentItem = properties.ListItem;
//create variable
string title = currentItem["Title"].ToString();
string server = currentItem["Server"].ToString();
DateTime Created = DateTime.Parse(currentItem["Created"].ToString());
//create text file
string path = @"C:\Temp\" + title + ".txt";
//add to Encoding
Encoding encoding = Encoding.GetEncoding("UTF-8");
if (!File.Exists(path))
{
using (FileStream fs = new FileStream(path, FileMode.CreateNew))
{
using (StreamWriter writer = new StreamWriter(fs, encoding))
{
writer.WriteLine("Наименование: " + title);
writer.WriteLine("Сервер: " + server);
writer.WriteLine("Дата создания: " + Created);
writer.Close();
}
}
//Add file to library
SPList lib_destination = (SPDocumentLibrary)web.Lists["Shared Documents"];
var targetFolder = lib_destination.RootFolder;
var fileContent = File.ReadAllBytes(path);
var fileUrl = Path.GetFileName(path);
targetFolder.Files.Add(fileUrl, fileContent);
//remove cash file
File.Delete(path);
}
}
catch (Exception ex)
{
File.WriteAllText(@"C:\Temp\error.txt", ex.ToString());
}
}
}
}
}
#Load System.Reflection.Assembly WSS or SharePoint server 2007 only
[System.Reflection.Assembly]::Load("Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
[System.Reflection.Assembly]::Load("Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
[System.Reflection.Assembly]::Load("Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
[System.Reflection.Assembly]::Load("System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")
#PSSnapin SharePoint server 2010, 2013, 2016, 2019
if(!(Get-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction:SilentlyContinue))
{
Add-PsSnapin Microsoft.SharePoint.PowerShell
}
#Enter your parametrs here site, listname, count elements
$siteUrl = "http://sharepoint/sites/Department"
$listName = "Main"
$batchSize = 1000
$site = new-object Microsoft.SharePoint.SPSite($siteUrl)
$web = $site.OpenWeb()
write-host "Web is: $($web.Title)"
$list = $web.Lists[$listName];
write-host "List is: $($list.Title)"
while ($list.ItemCount -gt 0)
{
write-host "Item count: $($list.ItemCount)"
$batch = "<?xml version=`"1.0`" encoding=`"UTF-8`"?><Batch>"
$i = 0
foreach ($item in $list.Items)
{
$i++
write-host "`rProcessing ID: $($item.ID) ($i of $batchSize)" -nonewline
$batch += "<Method><SetList Scope=`"Request`">$($list.ID)</SetList><SetVar Name=`"ID`">$($item.ID)</SetVar><SetVar Name=`"Cmd`">Delete</SetVar><SetVar Name=`"owsfileref`">$($item.File.ServerRelativeUrl)</SetVar></Method>"
if ($i -ge $batchSize) { break }
}
$batch += "</Batch>"
$result = $web.ProcessBatchData($batch)
write-host "Emptying Recycle Bin..."
$web.RecycleBin.DeleteAll()
write-host
$list.Update()
}
ClientContext context = new ClientContext("http://sp/sites/test");
Web web = context.Web;
List list = context.Web.Lists.GetByTitle("DataList");
context.Load(list);
context.ExecuteQuery();
CamlQuery query = new CamlQuery();
query.ViewXml = "";
ListItemCollection allitems = list.GetItems(query);
context.Load(allitems);
context.ExecuteQuery();
SqlConnection cn = new SqlConnection();
DataSet EmpDataSet = new DataSet();
SqlDataAdapter da;
cn.ConnectionString = @"Data Source=SQLServer;Initial Catalog=DataTable;Integrated Security=SSPI";
cn.Open();
da = new SqlDataAdapter("select * from [dbo].[Table_Data]", cn);
SqlCommandBuilder builder = new SqlCommandBuilder(da);
da.Fill(EmpDataSet, "Table_Data");
DataTable table = EmpDataSet.Tables[0];
foreach (ListItem listitem in allitems)
{
DataRow row = table.NewRow();
row["Date"] = System.TimeZone.CurrentTimeZone.ToLocalTime(Convert.ToDateTime(listitem["Created"].ToString()));
row["Column1"] = listitem["Title"].ToString();
row["Column2"] = listitem["Event1"].ToString();
row["Author"] = listitem["AuthorPosition"].ToString();
row["DateToday"] = System.TimeZone.CurrentTimeZone.ToLocalTime(Convert.ToDateTime(listitem["Today"].ToString()));
table.Rows.Add(row);
builder.GetInsertCommand();
}
da.Update(EmpDataSet, "Table_Data");<script type="text/javascript" src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
<script type="text/javascript">
function hdrDetails(i, elm, cl) {
cl = cl/1024; //divide content-length by 1024 (KB)
var sz = cl>1024?"MB":"KB"; //if cl is still big, set to MB
cl = cl>1024?cl/1024:cl; //if cl is still big, divide again
var len = $(elm).eq(i).text().length; //check the link's text length
if(len > 0) {
//add a file size
$(elm).eq(i).after(" (" + cl.toFixed(2) + " " + sz + ")");
}
}
$(function() {
var elm="a[href$='.pdf'],"+ //only the file types we want
"a[href$='.doc'],"+
"a[href$='.ppt'],"+
"a[href$='.xls'],"+
"a[href$='.docx'],"+
"a[href$='.pptx'],"+
"a[href$='.mht'],"+
"a[href$='.xlsx']";
$(elm).each(function(i, e) {
if (e.hostname && e.hostname == location.hostname) {
$.ajax({
type: "get",
url: $(this).attr("href"),
complete: function(xhr, textStatus) {
var cl=xhr.getResponseHeader("content-length");
hdrDetails(i, elm, cl); //call the calculation fn
}
});
}
});
});
</script>
using Microsoft.SharePoint;
using System;
namespace EventDeployTest2.EventReceiver2
{
public class EventReceiver2 : SPItemEventReceiver
{
public override void ItemUpdated(SPItemEventProperties properties)
{
using (SPSite oSPsite = new SPSite("http://sharepoint/sites/test"))
{
using (SPWeb oSPWeb = oSPsite.OpenWeb())
{
SPList list = oSPWeb.Lists["Test"];
string[] lines = System.IO.File.ReadAllLines(@"\\sharepoint\sites\test\SiteAssets\user.csv");
SPListItem itemToAdd = null;
foreach (string line in lines)
{
string[] arr = line.Split(';');
itemToAdd = list.Items.Add();
itemToAdd["Name"] = Convert.ToString(arr[0]);
itemToAdd["Surname"] = Convert.ToString(arr[1]);
itemToAdd["Department"] = Convert.ToString(arr[2]);
itemToAdd["Post"] = Convert.ToString(arr[3]);
itemToAdd["Position"] = Convert.ToString(arr[4]);
itemToAdd.Update();
}
}
}
}
}
}
window.onload= function(){
// getting the GUID of list.
var listGUID = _spPageContextInfo.pageListId;
// getting the item id
var itemId = '1';
// clearing the value inside the tdCheckInComment
$("#tdCheckInComment").html('');
// checking if list guid found or not.
if(listGUID)
{
//removing {} from the variable.
listGUID = listGUID.replace(/[{}]/g, "");
// checkin if item id is found or not.
if(itemId)
{
var comment = GetLastCheckInComment(listGUID,itemId);
if(comment)
{
$("#tdCheckInComment").html(comment);
}
}
}
}
function GetLastCheckInComment(listGUID,itemId) {
var returnValue;
try {
jQuery.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists(guid'" + listGUID + "')/items(" + itemId + ")/File/CheckInComment",
type: "GET",
async: false,
headers: { "Accept": "application/json;odata=verbose" },
success: function (data, textStatus, xhr) {
returnValue = data.d.CheckInComment;
},
error: function (data, textStatus, xhr) {
console.error('Error while getting the last check in comment.');
}
});
}
catch (ex) {
}
return returnValue;
}
<table>
<tr>
<th><label id="lblComment">Comment: </label></th>
<td id="tdCheckInComment"></td>
</tr>
</table>
[System.Reflection.Assembly]::LoadWithPartialName("System.Data")
$conn = New-Object "System.Data.SqlClient.SqlConnection" -ArgumentList "server=SQLSERVER-01; database=USERLOCAL; integrated security=SSPI"
$conn.Open()
$cmd = $conn.CreateCommand()
$cmd.CommandText = "UPDATE WSS_Content.dbo.AllListsAux set NextAvailableId=1 where ListID='D4D2CF11-1F16-4122-BA50-05A6A9CFD27E'"
$cmd.ExecuteNonQuery()UPDATE WSS_Content.dbo.AllListsAux set NextAvailableId=1 where ListID='D4D2CF11-1F16-4122-BA50-05A6A9CFD27E'