26 July 2012

Why not work with the CSV file and encoding together

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

17 July 2012

Apps for SharePoint 2013

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 …
SharePoint 2013 Preview: App Overview for IT Pro
http://www.microsoft.com/en-us/download/details.aspx?id=30373

Other interesting links:
Download Microsoft SharePoint Server 2013 Preview
http://technet.microsoft.com/en-US/evalcenter/hh973397.aspx?wt.mc_id=TEC_121_1_33
SharePoint Foundation 2013 Preview
http://www.microsoft.com/en-us/download/details.aspx?id=30373

There will be continued on SP 2013...
Yours,
Roi K

08 July 2012

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

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

Yours,
Roi Kolbinger :)


01 July 2012

Saving changes is not permitted - Sql server

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