Posts

Why not work with the CSV file and encoding together

Image
The answer is simple - Microsoft excel not support it. Came to do simple experiments (next exercise does not need to know Development). Open notepad-  Copy the following text (it is in Hebrew because of the example of the encoding) עמודה 1, עמודה 2, עמודה 3 טקסט 1, טקסט 2, טקסט 3 טקסט 11, טקסט 22, טקסט 33 Now save it with encoding - Unicode. The result you receive a Hebrew - but only one column. Now save it with encoding of UTF-8 Now the columns fine but where the Hebrew? If you try to open the same file in other programs such as One-Note it will work well. My recommendation to work less with CSV (with ms. excel). Yours, Roi

Apps for SharePoint 2013

Image
A few days ago out version of the SharePoint  2013   (15) Beta. An emerging idea of SharePoint 2013 is the Apps . What is Apps for SharePoint? And how is it different from the Solutions? To the best of my understanding, App is Package (. App) also contains a WSP course, but also AppManifest.xml and Other files. While solution (WSP) can build by self-developed or from Third-party. The app can be obtained from Internal App Catalog (contains apps approved and uploaded by the organization) or from Public SharePoint Store. Apps can be used in your hosted or on-premises SharePoint App code is installed on a separate web site from your other sites in its own, isolated, domain or in the cloud (cloud-based apps). While Solutions can be used in your hosted (sandbox solutions only) or on-premises SharePoint Solution code is installed as a full trust solution (in the global assembly cache) or as a sandboxed solution. For more information. You  can be viewed at … ...

Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.

Image
How to insert/update image column om SQL? When you try to do this on sql server 2008 you got an error update [tbl_items] set [ImagePlayer]= 'C:\Projects\Images\item.jpg' where [ID]=1 The error message was: Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query. Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query All you need is to do BulkColumn Code for update update [tbl_items] set [ImagePlayer]=BulkColumn FROM OPENROWSET ( Bulk 'C:\Projects\Images\item.jpg' , SINGLE_BLOB) AS BLOB where [ID]=1 (1 row(s) affected) Code for Insert INSERT INTO [ScoutMe].[dbo].[tbl_Players]   ([ID],   [ImagePlayer])    SELECT 1,      BulkColumn FROM OPENROWSET (        Bulk 'C:\Projects\Images\item.jpg' , SINGLE_BLOB) AS BLOB...

Saving changes is not permitted - Sql server

Image
I got an error message when I try to change my table on sql server 2008 R2 Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created. Saving changes is not permitted   All you need to is go to: Options -> Designers -> Table and Database Designers ... and turn off the " Prevent saving changes that requirde table re-creation " Prevent saving changes that requirde table re-creation and click OK Twice User Chenges Thanks, Roi

An attempt was made to load an assembly with an incorrect format microsoft.sharepoint.search.dll

Image
I recently came across the following error message when I gotten compile the project in release - after success in debug An attempt was made to load an assembly with an incorrect format microsoft.sharepoint.search.dll The solution is simple go to Project Properies -> Build ... and trun off the Generate serialization assembly Generate serialization assembly Yours, Roi

OAuth 2.0 protocol

Image
Today to share information of sharepoint with Facebook, Twitter, linkedin, google or live edu you need to create a SSO (single sign-on). As it seems, in sharepoint 15 (2013) we get a new protocol called OAuth 2.0. What is OAuth 2.0 protocol? OAuth 2.0 is an upgrade of Frotokl OAuth from 2006 (a more advanced generation evolution of the protocol). It allows us to authenticate a user and give it a specific and temporary approval of our application. OAuth specification is being developed in IETF WG and shell based on OAuth. The protocol has been implemented in applications of Android and iPhone user receiving the operating system (Yes. .. Android does not send the details of your gmail any foreign entity). Think now about a world in which the SP talking to him Ioser of Facebook, and get him to only specific permissions to share some information. SharePoint  15 will be continued... Roi

Enable-SPFeature: The Feature is not a Farm Level Feature and is not found in a Site level defined by the Url

Image
After running the following command Enable-SPFeature-Identity DocumentSet-URL http://url I received the following error Enable-SPFeature: The Feature is not a Farm Level Feature and is not found in a Site level defined by the Url ... Why ??? It happened to me because I copied some files at the time manually (not using the solution). The team system locks the files to ReadOnly . And the command fails (the readonly found only a deep excavation in the log files of sharepoint) The solution: D isables the ReadOnly for all the files in sub folders. It can be found here: Uncheck read only file for all sub folder with PowerShell I use this code at 14\Template folder Thanks, Roi