Blog

Basic Operation’s That SharePointer Needs For SharePointing By Using CSOM – Part 4

SharePoint user tasks

You can use the SharePoint .NET Framework CSOM to manage SharePoint users, groups, and user security.

Add a user to a SharePoint group

This example adds a user and some user information to a SharePoint group named Members.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://SiteUrl"); 

GroupCollection siteGroups = context.Web.SiteGroups; 

// Assume that there is a "Members" group, and the ID=5. 
Group membersGroup = siteGroups.GetById(5); 

// Let's set up the new user info. 
UserCreationInformation userCreationInfo = new UserCreationInformation(); 
userCreationInfo.Email = "user@domain.com"; 
userCreationInfo.LoginName = "domain\\user"; 
userCreationInfo.Title = "Mr User"; 

// Let's add the user to the group. 
User newUser = membersGroup.Users.Add(userCreationInfo); 

context.ExecuteQuery();  

Retrieve all users in a SharePoint group

This example retrieves information about all users from a SharePoint group named Members.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://SiteUrl"); 

GroupCollection siteGroups = context.Web.SiteGroups; 

// Assume that there is a "Members" group, and the ID=5. 
Group membersGroup = siteGroups.GetById(5); 
context.Load(membersGroup.Users); 
context.ExecuteQuery(); 

foreach (User member in membersGroup.Users) 
{ 
    // We have all the user info. For example, Title. 
    label1.Text = label1.Text + ", " + member.Title; 
}  

Create a role

This example creates a role that has create and manage alerts permissions.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://SiteUrl"); 

BasePermissions perm = new BasePermissions(); 
perm.Set(PermissionKind.CreateAlerts); 
perm.Set(PermissionKind.ManageAlerts); 

RoleDefinitionCreationInformation creationInfo = new RoleDefinitionCreationInformation(); 
creationInfo.BasePermissions = perm; 
creationInfo.Description = "A role with create and manage alerts permission"; 
creationInfo.Name = "Alert Manager Role"; 
creationInfo.Order = 0; 
RoleDefinition rd = context.Web.RoleDefinitions.Add(creationInfo); 

context.ExecuteQuery();  

Add a user to a role

This example adds a user to a role.

C#

// Starting with ClientContext, the constructor requires a URL to the

// server running SharePoint.

ClientContext context = new ClientContext("http://SiteUrl");

// Assume that we have a SiteUser with Login user.

Principal user = context.Web.SiteUsers.GetByLoginName(@"domain\user");

// Assume that we have a RoleDefinition named "Read".

RoleDefinition readDef = context.Web.RoleDefinitions.GetByName("Read"); RoleDefinitionBindingCollection roleDefCollection = new RoleDefinitionBindingCollection(context);

roleDefCollection.Add(readDef);

RoleAssignment newRoleAssignment = context.Web.RoleAssignments.Add(user, roleDefCollection); context.ExecuteQuery();


Part 1
Part 2
Part 3

What is Photography ??

We Hear the term Photography almost everyday, but have we ever think what it really means, and from where did this term came ??

Photography is a term combined from two sections:

1- Photo: which is mean Light.

2- graphy: which is mean Drawing

so Photography mainly means drawing with light.

Now lets get deeper in the meaning of photography and where did it came from.

Continue reading “What is Photography ??”

Terms That you may not know what it refers to !

We Use a lot of terms daily in our life, but have we ever noticed that a lot of these terms we don’t know what it really means or what does it refer to ??

 

URL: refers to “Uniform Resource Locator“, it is a reference to a web resource that specifies its location on a computer network and a mechanism for retrieving it. URLs occur most commonly to reference web pages (http), but are also used for file transfer (ftp), email (mailto), database access (JDBC), and many other applications.

 

 


 

IP: refers to “Internet Protocol“, and it is a numerical label assigned to each device connected to a computer network that uses the Internet Protocol for communication, An IP address serves two principal functions: host or network interface identification and location addressing.

Continue reading “Terms That you may not know what it refers to !”

The Top 3 Software’s … What’s The Difference ??

In the last Article we did Talk about video editing and it’s Top 3 software’s,  Today we will make a small comparison for these three software’s and there Uses in Hollywood.

1. Avid Media Composer

A large part of understanding one’s popularity is to examine WHY it’s popular. And that requires sharing the most brief of history lessons.

OK, do you remember a time before Internet connected cell phones? Now, try and remember how our daily lives changed when most everyone had one of these devices.

It was a definite shift in how we consumed media. Now, imagine that, only with the CREATION side of media. This was Hollywood in the early 90’s. Digital video cameras were still very new, and limited to standard definition. There were many companies toying with building digital editing software, but none really took hold. That is, until Avid Media Composer came along in the early 90’s.

By building a digital editing platform, based on the terminology and methodology the experienced film editors knew, Avid was able to make the industry adoption of their technology much easier. Thus, we already have 2 reasons Media Composer was popular: it appealed to the sensibilities of the user base, and it was one of the few solutions out there.

Avid also built around their ecosystem, including not only their own shared storage, but having the top audio editing system in the industry; Pro Tools, by then Digidesign, giving users a complete solution tech partner to work with. We call this the “one throat to choke” paradigm.

Many facilities already invested in a complete end-to-end Avid infrastructure.

By the time other NLE’s were in a useable state for film and TV projects, Avid had a massive head start. This meant a decent sized user base in the Hollywood market, facility infrastructures (and thus lots of money already invested in hardware and software) that were built around Media Composer, in addition to workflows that incorporated both legacy film based material, tape acquisition, and newer digital formats. Avid also had project sharing by the early 00’s, something that only recently are other NLE’s getting right. For all of these reasons, Avid had the Hollywood market cornered. And all of this played in to one of the greatest untold truths about Hollywood technology.

If something worked last season, why change it for this season? Changing it messes with budgets and timelines and generally upsets the natives.

And that’s why today, Avid is still used on a vast majority of all feature films and broadcast television in Hollywood.  Existing customer investment in infrastructure, experienced talent pool – both available and already on staff, documented workflows with other departments, a complete ecosystem, and a risk averse industry.  If you plan on getting a job tomorrow out in Hollywood, working in broadcast television or feature film, Media Composer needs to be your strongest software tool.

Continue reading “The Top 3 Software’s … What’s The Difference ??”

Video Editing And it’s Software’s

We all hear the Expression “Video Editing” , but Ever wonder what it really means??

 

Video editing is the manipulation and arrangement of video shots, Adding Effects, Transitions, and even titles then exporting it as a single movie. Video editing is used to structure and present all video information, including films and television shows, video advertisements and video essays.

Video editing has been dramatically spreaded in recent years by editing software’s available for personal computers.

Continue reading “Video Editing And it’s Software’s”

Basic Operation’s That SharePointer Needs For SharePointing By Using CSOM – Part 3

Previously in part one we discussed the main operation that developers needs to deal with SharePoint site , and in part 2 , we talked about  SharePoint list , and the bellow examples show how to use the .NET Framework CSOM to complete list item -related tasks.

SharePoint list item tasks

These examples demonstrate how to use the .NET Framework CSOM (Client side object model) to complete tasks that are related to list items.

Retrieve items from a SharePoint list

This example retrieves the items in a SharePoint list. You also need to add a using statement for Microsoft.SharePoint.Client.QueryExpression.

Note

You can use the FolderServerRelativeUrl property to further restrict the items that are returned to those in a specified folder.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

// Assume the web has a list named "Announcements". 
List announcementsList = context.Web.Lists.GetByTitle("Announcements"); 

// This creates a CamlQuery that has a RowLimit of 100, and also specifies Scope="RecursiveAll" 
// so that it grabs all list items, regardless of the folder they are in. 
CamlQuery query = CamlQuery.CreateAllItemsQuery(100); 
ListItemCollection items = announcementsList.GetItems(query); 

// Retrieve all items in the ListItemCollection from List.GetItems(Query). 
context.Load(items); 
context.ExecuteQuery(); 
foreach (ListItem listItem in items) 
{ 
    // We have all the list item data. For example, Title. 
    label1.Text = label1.Text + ", " + listItem["Title"]; 
} 

Create a new list item

This example creates a new SharePoint list item by using the ListItemCreationInformation class.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

// Assume that the web has a list named "Announcements". 
List announcementsList = context.Web.Lists.GetByTitle("Announcements"); 

// We are just creating a regular list item, so we don't need to 
// set any properties. If we wanted to create a new folder, for 
// example, we would have to set properties such as 
// UnderlyingObjectType to FileSystemObjectType.Folder. 
ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); 
ListItem newItem = announcementsList.AddItem(itemCreateInfo); 
newItem["Title"] = "New Item!"; 
newItem["Body"] = "Hello Developers world!"; 
newItem.Update(); 

context.ExecuteQuery();  

Update a list item

This example updates a SharePoint list item.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

// Assume that the web has a list named "Announcements". 
List announcementsList = context.Web.Lists.GetByTitle("Announcements"); 

// Assume there is a list item with ID=1. 
ListItem listItem = announcementsList.GetItemById(1); 

// Write a new value to the Body field of the Announcement item.
listItem["Body"] = "This is my new value!!"; 
listItem.Update(); 

context.ExecuteQuery();  

Delete a list item

This example deletes a SharePoint list item.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

// Assume that the web has a list named "Announcements". 
List announcementsList = context.Web.Lists.GetByTitle("Announcements"); 

// Assume that there is a list item with ID=2. 
ListItem listItem = announcementsList.GetItemById(2); 
listItem.DeleteObject(); 

context.ExecuteQuery(); } 

basic operation’s that SharePointer needs for SharePointing by using CSOM – part 2

Previously in part one we discussed the main operation that developers needs to deal with SharePoint site and here in part 2 to we’ll focus on SharePoint list , and the bellow examples show how to use the .NET Framework CSOM to complete list-related tasks.

Retrieve all SharePoint lists in a website

This example retrieves all SharePoint lists in a SharePoint website. To compile this code, you need to add a using statement for System.Linq.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

// The SharePoint web at the URL.
Web web = context.Web; 

// Retrieve all lists from the server. 
context.Load(web.Lists, 
             lists => lists.Include(list => list.Title, // For each list, retrieve Title and Id. 
                                    list => list.Id)); 

// Execute query. 
context.ExecuteQuery(); 

// Enumerate the web.Lists. 
foreach (List list in web.Lists) 
{ 
    label1.Text = label1.Text + ", " + list.Title; 
} 

Note

Alternatively, you can use the LoadQuery method to store the return value in another collection, rather than use the web.Lists property. You will also need to add using statements for System.Collections.Generic and System.Linq. Also, add an alias to the using statement for the Microsoft.SharePoint.Client namespace so you can refer to its classes unambiguously. For example, using SP = Microsoft.SharePoint.Client;.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

// The SharePoint web at the URL.
Web web = context.Web; 

// Retrieve all lists from the server, and put the return value in another 
// collection instead of the web.Lists. 
IEnumerable<SP.List> result = context.LoadQuery(web.Lists.Include( // For each list, retrieve Title and Id.
                                                                   list => list.Title, 
                                                                   list => list.Id)); 

// Execute query. 
context.ExecuteQuery(); 

// Enumerate the result. 
foreach (List list in web.Lists) 
{ 
    label1.Text = label1.Text + ", " + list.Title; 
} 

Create and update a SharePoint list

This example creates a SharePoint list and updates it by using the ListCreationInformation class.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

// The SharePoint web at the URL.
Web web = context.Web; 

ListCreationInformation creationInfo = new ListCreationInformation(); 
creationInfo.Title = "My List"; 
creationInfo.TemplateType = (int)ListTemplateType.Announcements; 
List list = web.Lists.Add(creationInfo); 
list.Description = "New Description"; 

list.Update(); 
context.ExecuteQuery(); 

Delete a SharePoint list

This example deletes a SharePoint list.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

// The SharePoint web at the URL.
Web web = context.Web; 

List list = web.Lists.GetByTitle("My List"); 
list.DeleteObject(); 

context.ExecuteQuery();  

Add a field to a SharePoint list

This example adds a field to a SharePoint list. Add an alias to the using statement for the Microsoft.SharePoint.Client namespace so you can refer to its classes unambiguously. For example, using SP = Microsoft.SharePoint.Client;.

Note

The example uses context.CastTo to do a cast. Before executing the query, the client library does not know the real type of the returned object “field”, and SharePoint.Field is the only possible type. If you know the real type, you can use the ClientContext.CastTo method to cast the object.

C#
// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net"); 

SP.List list = context.Web.Lists.GetByTitle("Articles"); 

SP.Field field = list.Fields.AddFieldAsXml("<Field DisplayName='MyField2' Type='Number' />", 
                                           true, 
                                           AddFieldOptions.DefaultValue); 
SP.FieldNumber fldNumber = context.CastTo<FieldNumber>(field); 
fldNumber.MaximumValue = 100; 
fldNumber.MinimumValue = 35; 
fldNumber.Update(); 

context.ExecuteQuery();  

basic operation’s that SharePointer needs for SharePointing by using CSOM – part 1

Yes, SharePoint is awesome and I really enjoyed with developing apps on it, and in this article I’ll list down the basic operation that SharePoint developer needs while SharePointing  by using CSOM

We have four main things to deal with in SharePoint

  • Operations on SharePoint site  – Part 1
  • Operations on SharePoint List- Part 2
  • Operations on SharePoint List item -Part 3
  • Operations on SharePoint Users- Part 4

And I’ll start with SharePoint site operation

Ø  Get all Website properties

Retrieve the title of a SharePoint website.

C#

// Starting with ClientContext, the constructor requires a URL to the
// server running SharePoint. 
ClientContext context = new ClientContext("http://Developersportal.net"); 
// The SharePoint web at the URL.
Web web = context.Web;  
// We want to retrieve the web's properties.
context.Load(web);
// Execute the query to the server.
context.ExecuteQuery(); 
// Now, the web's properties are available and we could display
// web properties, such as title. 
label1.Text = web.Title;

 

However you can retrieve only selected properties of a website

If you are  interested only in a few properties of the Site object. The SharePoint  Framework CSOM (Client side object model)  does not require you to get all properties from the object on a serve, so  you can use lambda expressions, to specifically requested property names.

By using this technique you’ll reduce the unnecessary data transfer between the client and the server..

Note that you need to add a using statement for System.Linq.

C#

// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net");  
// The SharePoint web at the URL.
Web web = context.Web;  
// We want to retrieve the web's title and description. 
context.Load(web, w => w.Title, w => w.Description);  
// Execute the query to server.
context.ExecuteQuery();  
// Now, only the web's title and description are available. If you 
// try to print out other properties, the code will throw 
// an exception because other properties are not available. 
label1.Text = web.Title;
label1.Text = web. Description;

 

Ø  Update SharePoint site’s properties

This example shows how to write to the website’s properties.

C#

// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net");  
// The SharePoint web at the URL.
Web web = context.Web;  
web.Title = "New Title (Devalopers Portal Awesome Team)";
web.Description = "New Description";  
// Note that the web.Update() does not trigger a request to the server
// because the client library until ExecuteQuery() is called. 
web.Update();  
// Execute the query to server.
context.ExecuteQuery();

 

Ø  Create a new SharePoint site

This example shows how to create a new SharePoint site as a subsite of the current website. Use the WebCreationInformation class to create a new website. You also need to add using statements for System.Collections.Generic and System.Text.

C#

// Starting with ClientContext, the constructor requires a URL to the 
// server running SharePoint. 
ClientContext context = new ClientContext("http://developersportal.net ");  
WebCreationInformation creation = new WebCreationInformation();
creation.Url = "sub site 1";
creation.Title = "Hello sub site 1"; 
Web newWeb = context.Web.Webs.Add(creation);
// Retrieve the new web information. c
ontext.Load(newWeb, w => w.Title); 
context.ExecuteQuery();  
label1.Text = newWeb.Title;

 

 

See You in Part 2

 

 

DataFlex – What is DataFlex?

Who?

The DataFlex platform is for enterprise development teams, vertical market software developers, application consultants and individuals that need to develop, deploy and maintain scalable, high performance business applications quickly at minimum cost.

For any type of user, DataFlex’s ability to build applications for all environments means less to learn, manage, maintain and pay for.

 

What? 

Simply, DataFlex is designed for developing business applications. With just one language, one studio and one robust framework, DataFlex can efficiently develop and deploy applications for mobile devices, desktop browsers and Windows PCs.

See What’s New in DataFlex 2017/19.0!

 

Why?

Today, companies’ operations, information, and customer services are delivered through software. The right software platform can provide competitive advantage and increase the speed of business. With advanced design, superior developer productivity, strong support from a trusted supplier and an active global community, developing business software with DataFlex is faster and lower in cost. DataFlex is the right software platform.

Where?

DataFlex cloud-based and premise-based applications are powering businesses on every continent and in all industry sectors including: health care, ITC, government, transportation, construction, legal, manufacturing, travel & leisure, financial services, retail, wholesale, agriculture, public utilities, broadcasting, churches and non-profit organizations and more.

SAP Crystal Reports

A robust production reporting tool, SAP Crystal Reports turns almost any data source into interactive, actionable information that can be accessed offline or online, from applications, portals and mobile devices.

sap-crystal-report2

Features & Benefits

SAP® Crystal Reports® software is the de facto standard in reporting. With SAP Crystal Reports 2013, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. A robust production reporting tool, SAP Crystal Reports turns almost any data source into interactive, actionable information that can be accessed offline or online, from applications, portals and mobile devices.

  • Flexible, customizable report design

    Create highly formatted, pixel-perfect reports quickly with SAP Crystal Reports’ intuitive design interface and efficient workflows.

  • Broad data connectivity .

    Connect to information sources spread across the organization directly. Data sources include: Native, ODBC, OLE DB, and JDBC connectivity to relational, OLAP, Web services, XML, enterprise data sources, and salesforce.com..

  • Powerful report delivery options

    Deliver personalized reports to your business users’ preferred destination in their preferred language and format.

  • Expanded support for Excel

    XLSX export takes full advantage of the updated Excel file format by allowing more data to be exported to a single worksheet, without spanning multiple worksheets.

  • Mobile Interactivity

    Interactive reports are now available through your mobile devices.

  • SAP Crystal Dashboard Design software, Adobe Flex, Adobe Flash and HTML 5 integration

    Enable SAP Crystal Reports developers to produce powerful “mash-ups” pulling data from various sources.

  • Windows 7 compatible

    SAP Crystal Reports software 2013 is certified compatible with Microsoft Windows 7.

Read More About SAP Business One From E-SkyTech.com