Wednesday, July 20, 2016

Windows PowerShell - "running scripts is disabled on this system."

When I try to execute my .ps1 script in Windows PowerShell ISE window, it is throwing exception like below:

"cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at http://go.microsoft.com/fwlink/?LinkID=135170.
    + CategoryInfo          : SecurityError: (:) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : UnauthorizedAccess  "

I found the solution one the article from the Internet.

This error happens due to a security measure which won't let scripts be executed on your system without you having approved of it. 

You can do it by set the execution policy in powershell command window.

Open the Windows PowerShell with "Run as administrator" and enter the below command:

set-executionpolicy remotesigned

Thursday, April 28, 2016

How to get Image from Picture Library using REST API

I used REST API to get the Image form Picture Library and display my Banner Dynamically.

I used normal RESTful HTTP url like asusual Path and Query string param in the sequence of SELECT, FILTER and ORDER BY accordingly  but I am not able to get "EncodedAbsUrl"  in the result.

After I googled I got some idea, form some forums.

Like I used SELECT statement as a last querystring param, like below:

http://sharePointchild.com/_api/Web/Lists/GetByTitle('HomeBanner')/Items?filter=IsActive%20eq%201&$top=1&$orderby=IsActive%20desc&$select=EncodedAbsUrl

Code:

$(document).ready(function(){

var siteColUrl=_spPageContextInfo.siteAbsoluteUrl;

$.ajax({
method:"GET",
headers:{"Accept":"application/json; odata=verbose"},
url:siteColUrl+"/_api/Web/Lists/GetByTitle('HomeBanner')/Items?filter=IsActive%20eq%201&$top=1&$orderby=IsActive%20desc&$select=EncodedAbsUrl",
success: function (data) {

        completeBannerdata(data);
   }
   ,
    error: function (error) {

              failiureBannerdata(error);
         
        }

});

})

function completeBannerdata(data)
{

var items = data.d.results;
if(items.length>0)
{
       $('#imgBanner').attr('src', items[0]["EncodedAbsUrl"]);
       }
}

 function failiureBannerdata(error)
 {

 }

SharePoint 2013 Error When Trying to Create New Publishing Page

I have Own content type which is base by Article pages, and associated with my Pages Library.
The library contains "articles" folder, we are placing all article relavant pages under this folder.
When user create a new page via "Add a page" link, we are moving that page from root folder to article folder via content organizer rule.

For testing, when I try to create a new Publishing page via "Add a Page" option, it got the error as below:

Invalid field name. {50631c24-1371-4ecf-a5ae-ed41b03f4499}   

I googled and got some reference,
we needs to add some of the fields to our content type.

Solution:

1. Go to the Content type page
2. Add the below columns to your content type:
    a. Hide from Internet Search Engines 
    b. Hide physical URLs from Search
    c. Meta Description
    d. Meta Keywords

set yes, for update all content types inheriting from this type. If required.

Click Ok.

Thursday, April 21, 2016

How to View PDF & HTML Files in Browsers in SharePoint 2013

The more secure way is to display PDF and HTML file in the browse are ShaerPoint portal. Add the MIME type of PDF and HTML file into your WebApplication's AllowedInlineDownloadedMimeTypes. Instead of enable the Permissive Option at Browser Handling section in WebApplication's General Settings.

Execute the below script in SharePoint PowerShell cmdlets:

$webApp = Get-SPWebApplication("http://www.samples.com")
$webApp.AllowedInlineDownloadedMimeTypes.Add("application/pdf")
$webApp.AllowedInlineDownloadedMimeTypes.Add("text/html")
$webApp.Update()

Friday, April 24, 2015

DotNet-SAP Connector - How to Read/Write data to SAP from DotNet



Read and Write data into SAP by DotNet console application.
1. Create VS console application.
2. To connect to SAP need 3 ddl as below:

  •  SAPConnectionManager
  • sapnco
  • sapnco_utils
download the above dlls and add into your application as a reference.

3. Enter SAP configuration settings entries in the app.config app settings.


<appSettings>
    <add key="SAP_ApplicationServerHost" value="ServerName/IP"/>
    <add key="SAP_SystemID" value="DEV"/>
    <add key="SAP_SystemNumber" value="00"/>
    <add key="SAP_User" value="userid"/>
    <add key="SAP_Password" value="password"/>
    <add key="SAP_Client" value="040"/>
    <add key="SAP_Language" value="EN"/>
</appSettings>

4. Add one new class for SAP configuration.
add "SAP.Middleware.Connector" namespace.
inherit the IDestinationCofiguration interface, and right click the call on it to implement the interface

using SAP.Middleware.Connector;

namespace SAPConenctCnsl
{
    public class SAPDstinConfig : IDestinationConfiguration
    {
        public bool ChangeEventsSupported()
        {
            return false;
        }

        public event RfcDestinationManager.ConfigurationChangeHandler ConfigurationChanged;


        public RfcConfigParameters GetParameters(string destinationName)

        {
            RfcConfigParameters parms = new RfcConfigParameters();
            parms.Add(RfcConfigParameters.Name, "DEV");
            parms.Add(RfcConfigParameters.AppServerHost, ConfigurationManager.AppSettings["SAP_ApplicationServerHost"]);
            parms.Add(RfcConfigParameters.SystemNumber, ConfigurationManager.AppSettings["SAP_SystemNumber"]);
            parms.Add(RfcConfigParameters.SystemID, ConfigurationManager.AppSettings["SAP_SystemID"]);
            parms.Add(RfcConfigParameters.User, ConfigurationManager.AppSettings["SAP_User"]);
            parms.Add(RfcConfigParameters.Password, ConfigurationManager.AppSettings["SAP_Password"]);
            parms.Add(RfcConfigParameters.Client, ConfigurationManager.AppSettings["SAP_Client"]);
            parms.Add(RfcConfigParameters.Language, ConfigurationManager.AppSettings["SAP_Language"]);
            parms.Add(RfcConfigParameters.PoolSize, "10");

            return parms;


        }

    }
}

5. add one more new class for Interface , to write your logics


using SAP.Middleware.Connector;
namespace SAPConenctCnsl
{
    public class SAPConntInterface
    {
        private RfcDestination rfcDestination;

// To test the connection

        public bool TestConnection(string destinationName)
        {
            bool result = false;

            try

            {
                rfcDestination = RfcDestinationManager.GetDestination(destinationName);
                if (rfcDestination != null)
                {
                    rfcDestination.Ping();
                    result = true;
                }

            }

            catch (Exception ex)
            {

                result = false;

                throw new Exception("Connection Failed :" + ex.Message);
            }
            return result;
        }
// Getting data with out RFC parameters
 public DataTable GET_VENDOR_CODE(string destinationName)
        {
            RfcRepository rfcRepository = GetRepository(destinationName);
            IRfcFunction rfcFunction = rfcRepository.CreateFunction("Z__GET_VENDOR_CODE");
            rfcFunction.Invoke(rfcDestination);
            IRfcTable tableVendorDetails = rfcFunction.GetTable("GT_VENDORCODE_TAB");
            DataTable dt = new DataTable();
            ConvertToDotNetTable(tableVendorDetails, dt);
            return dt;
        }

// Getting Data from RFC passing string params, and invoke from Table ==> Structure, but return as Table

        public DataTable Get__BANKCODE_Data(string destinationName,string strBankCode)
        {
            RfcRepository rfcRespository = GetRepository(destinationName);
            IRfcFunction rfcFunction = rfcRespository.CreateFunction("Z__GET_BANKCODE_RET");
            IRfcTable t_items = rfcFunction.GetTable("BANK_COUNTRY_KEY");
            RfcStructureMetadata am = rfcRespository.GetStructureMetadata("ZBNKA_BANKS");
            IRfcStructure articol = am.CreateStructure();
            articol.SetValue("ZBANKS",strBankCode);
            t_items.Append(articol);
            rfcFunction.Invoke(rfcDestination);
            IRfcTable tableBankCode = rfcFunction.GetTable("GT_BNKA");
            DataTable dt = new DataTable();
            ConvertToDotNetTable(tableBankCode, dt);
            return dt;
        }


       //Insert data into One table

public void test(string destinationName)
        {
            try
            {
         RfcRepository rfcRepository = GetRepository(destinationName);
        IRfcFunction bapiTEST = rfcRepository.CreateFunction("Z__SET_PAYMENT_PLAN");
             IRfcTable tblInput = bapiTEST.GetTable("GT_CPP");

             RfcStructureMetadata metaData = rfcRepository.GetStructureMetadata("Z_CPP_TAB");

             IRfcStructure tblInputSt = metaData.CreateStructure();

             tblInputSt.SetValue("SCHONO", "10000001");

             tblInputSt.SetValue("COUTY", "MSY");
             tblInputSt.SetValue("BANKL", "BR");
             tblInputSt.SetValue("ENDDT", "2015-01-01");
    tblInput.Append(tblInputSt);

 IRfcStructure tblInputSt1 = metaData.CreateStructure();


tblInputSt1.SetValue("SCHONO", "11200000");

tblInputSt1.SetValue("COUTY", "MSY");
tblInputSt1.SetValue("BANKL", "BR");
tblInputSt1.SetValue("ENDDT", "2015-01-01");
tblInput.Append(tblInputSt1);
   
RfcSessionManager.BeginContext(rfcDestination);
bapiTEST.Invoke(rfcDestination);
IRfcTable t_items = bapiTEST.GetTable("LOG");
        List<string> lstReturn = new List<string>();
if (t_items.RowCount > 0)
{
   for (int i = 0; i < t_items.RowCount; i++)
   {
       lstReturn.Add(t_items[i].GetString(0));
   }
      }

RfcSessionManager.EndContext(rfcDestination)

   
            }
            catch (RfcCommunicationException ex)
            {
            }
            catch (RfcLogonException ex)
            {
                // user could not logon...
            }
            catch (RfcAbapRuntimeException ex)
            {
                // serious problem on ABAP system side...
            }
            catch (RfcAbapBaseException ex)
            {
                // The function module returned an ABAP exception, an ABAP message
                // or an ABAP class-based exception...
            }
        }

              //Insert data into mutiple table using Changing RFC Param

        public void SET__SCHOLAR_MASTER(string destinationName, DataSet ds)
        {
            try
            {

            

            object obj = null;
            RfcRepository rfcRepository = GetRepository(destinationName);
            IRfcFunction rfcFunction = rfcRepository.CreateFunction("Z__SET_SCHOLAR_MASTER");
            foreach (DataTable dt in ds.Tables)
            {
            IRfcTable tblGTCPP = rfcFunction.GetTable(dt.TableName);
            string strTblStName = string.Empty;
            if (dt.TableName.Contains("GT_ZT"))
            {
                strTblStName = dt.TableName.Replace("GT_Z", "");
            }
            //GT_ZB011
            if (dt.TableName.Contains("GT_ZB"))
            { 
                strTblStName = dt.TableName.Replace("GT_", "");
            }
            RfcStructureMetadata metaData = rfcRepository.GetStructureMetadata(strTblStName);
            IRfcStructure tblInputStructM = metaData.CreateStructure();

            

                foreach (DataRow dr in dt.Rows)
                {
                    IRfcStructure tblInputStruct = metaData.CreateStructure();
                    foreach (DataColumn column in dt.Columns)
                    {
                        obj = dr[column];
                        tblInputStruct.SetValue(column.ToString(), obj);

                    }

                    
                    tblGTCPP.Append(tblInputStruct);
                }
            }

            RfcSessionManager.BeginContext(rfcDestination);

            rfcFunction.Invoke(rfcDestination);
            IRfcTable tblLog = rfcFunction.GetTable("LOG");

            List<string> lstReturn = new List<string>();

            if (tblLog.RowCount > 0)
            {
                for (int i = 0; i < tblLog.RowCount; i++)
                {
                    lstReturn.Add(tblLog[i].GetString(0));

                }


            }

            RfcSessionManager.EndContext(rfcDestination);
            }
            catch (RfcCommunicationException ex)
            {
            }
            catch (RfcLogonException ex)
            {
                // user could not logon...
            }
            catch (RfcAbapRuntimeException ex)
            {
                // serious problem on ABAP system side...
            }
            catch (RfcAbapBaseException ex)
            {
                // The function module returned an ABAP exception, an ABAP message
                // or an ABAP class-based exception...
            }
        }
      
// Build Repository        
        private RfcRepository GetRepository(string destinationName)
        {
            rfcDestination = null;
            rfcDestination = RfcDestinationManager.GetDestination(destinationName);
            RfcRepository rfcRepository = rfcDestination.Repository;
            return rfcRepository;
        }

// Convert to DotNet DataTable

        private static void ConvertToDotNetTable(IRfcTable tableVendorDetails, DataTable dt)
        {
            for (int i = 0; i < tableVendorDetails.ElementCount; i++)
            {
                RfcElementMetadata metadata = tableVendorDetails.GetElementMetadata(i);
                dt.Columns.Add(metadata.Name);
            }
            foreach (IRfcStructure row in tableVendorDetails)
            {
                DataRow dr = dt.NewRow();
                for (int elem = 0; elem < tableVendorDetails.ElementCount; elem++)
                {
                    RfcElementMetadata metadata = tableVendorDetails.GetElementMetadata(elem);
                    
                }
                dt.Rows.Add(dr);
            }
        }

        


        public DataSet buildTestChangeDataSet()

        {
            DataSet ds = new DataSet();

            // Table GT_ZT9B01

            DataTable dtGT_ZT9B01 = new DataTable("GT_ZT9B01");
             
                     
            dtGT_ZT9B01.Columns.Add("MANDT", typeof(string));
            dtGT_ZT9B01.Columns.Add("DISPCD", typeof(int));
            dtGT_ZT9B01.Columns.Add("DISPNAME", typeof(string));
            dtGT_ZT9B01.Columns.Add("COURSE", typeof(int));
            dtGT_ZT9B01.Columns.Add("CATEG", typeof(int));

            DataRow drGT_ZT9B01 = dtGT_ZT9B01.NewRow();

            
            drGT_ZT9B01["MANDT"] = "2014-01-01";
            drGT_ZT9B01["DISPCD"] = 2;
            drGT_ZT9B01["DISPNAME"] = "BR";
            drGT_ZT9B01["COURSE"] = 2;
            drGT_ZT9B01["CATEG"] = 3;

            dtGT_ZT9B01.Rows.Add(drGT_ZT9B01);


            drGT_ZT9B01 = dtGT_ZT9B01.NewRow();


            drGT_ZT9B01["MANDT"] = "2014-02-02";

            drGT_ZT9B01["DISPCD"] = 21;
            drGT_ZT9B01["DISPNAME"] = "BR";
            drGT_ZT9B01["COURSE"] = 2;
            drGT_ZT9B01["CATEG"] = 3;

            dtGT_ZT9B01.Rows.Add(drGT_ZT9B01);



            // Table GT_ZT9B08

            DataTable dtGT_ZT9B08 = new DataTable("GT_ZT9B08");
           // dtGT_ZT9B08.DisplayExpression = "T9B08";

            dtGT_ZT9B08.Columns.Add("CLIENT", typeof(string));

            dtGT_ZT9B08.Columns.Add("LEVSD", typeof(int));
            dtGT_ZT9B08.Columns.Add("DESCRIP", typeof(string));
           
            DataRow drGT_ZT9B08 = dtGT_ZT9B08.NewRow();

            drGT_ZT9B08["CLIENT"] = "111";

            drGT_ZT9B08["LEVSD"] = 2;
            drGT_ZT9B08["DESCRIP"] = "BR1";
            
            dtGT_ZT9B08.Rows.Add(drGT_ZT9B08);

            drGT_ZT9B08 = dtGT_ZT9B08.NewRow();


            drGT_ZT9B08["CLIENT"] = "112";

            drGT_ZT9B08["LEVSD"] = 21;
            drGT_ZT9B08["DESCRIP"] = "BR2";

            dtGT_ZT9B08.Rows.Add(drGT_ZT9B08);


            // adding tables into dataset


            ds.Tables.Add(dtGT_ZT9B08);

            ds.Tables.Add(dtGT_ZT9B01);
             
            return ds;
        
        }
    }

}

6. At Program file


            string destinationConfigName = "DEV";
            IDestinationConfiguration destinationConfig = null;
            

             SAPConntInterface objSAPConntInterface = new  SAPConntInterface();

            objSAPConntInterface.TestConnection(destinationConfigName);
           objSAPConntInterface.GET__VENDOR_CODE(destinationConfigName);         
           objSAPConntInterface.Get__BANKCODE_Data(destinationConfigName, "MYS");
           objSAPConntInterface.test(destinationConfigName);
           
          DataSet ds=  objSAPConntInterface.buildTestChangeDataSet();

          objSAPConntInterface.SET__SCHOLAR_MASTER(destinationConfigName, ds);

Tuesday, April 14, 2015

Read Data from Excel in C-Sharp


public DataTable ReadExcelData()
        {
            string strFilePath=@"D:\SampleFolder\Sample.xls";
            DataTable dt=new DataTable();
            string con = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilePath + ";Extended Properties='Excel 8.0;HDR=Yes;'";
            string strQuery = "select * from [Sheet1$] where ColumnName='No'";
            using (OleDbConnection connection = new OleDbConnection(con))
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand(strQuery, connection);

                using (OleDbDataAdapter dbAdapter = new OleDbDataAdapter())
                {
                    dbAdapter.SelectCommand = command;
                    command.Connection = connection;
                 DataSet   resultsDataSet = new DataSet();
                   
                    {
                        dbAdapter.Fill(resultsDataSet);
                        dt = resultsDataSet.Tables[0];
                    }
                 
                }
            }
            return dt;
        }

Convert WordDocument to PDF using C-Sharp


// Create a new Microsoft Word application object
               MSWord.Application word = new MSWord.Application();

               // C# doesn't have optional arguments so we'll need a dummy value
               object oMissing = System.Reflection.Missing.Value;

               // Get list of Word files in specified directory
               DirectoryInfo dirInfo = new DirectoryInfo(path);
               FileInfo[] wordFiles = dirInfo.GetFiles(@"D:\HtmlFolder\Sample.doc");

               word.Visible = false;
               word.ScreenUpdating = false;

               foreach (FileInfo wordFile in wordFiles)
               {
                   // Cast as Object for word Open method
                   Object filename = (Object)wordFile.FullName;

                   // Use the dummy value as a placeholder for optional arguments
                   MSWord.Document doc = word.Documents.Open(ref filename, ref oMissing,
                       ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
                       ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
                       ref oMissing, ref oMissing, ref oMissing, ref oMissing);
                   doc.Activate();

                   object outputFileName = wordFile.FullName.Replace(".doc", ".pdf");
                   object fileFormat = MSWord.WdSaveFormat.wdFormatPDF;

                   // Save document into PDF Format
                   doc.SaveAs(ref outputFileName,
                       ref fileFormat, ref oMissing, ref oMissing,
                       ref oMissing, ref oMissing, ref oMissing, ref oMissing,
                       ref oMissing, ref oMissing, ref oMissing, ref oMissing,
                       ref oMissing, ref oMissing, ref oMissing, ref oMissing);

                   // Close the Word document, but leave the Word application open.
                   // doc has to be cast to type _Document so that it will find the
                   // correct Close method.              
                   object saveChanges = MSWord.WdSaveOptions.wdDoNotSaveChanges;
                   ((MSWord._Document)doc).Close(ref saveChanges, ref oMissing, ref oMissing);
                   doc = null;
               }

               // word has to be cast to type _Application so that it will find
               // the correct Quit method.
               ((MSWord._Application)word).Quit(ref oMissing, ref oMissing, ref oMissing);
               word = null;