GJ Tech Blog

tag:blogger.com,1999:blog-34416218815652867582026-03-25T15:43:42.497-07:00GJ Tech BlogMicrosoft Technologies(Sharepoint Server/Online, .NET, Power Platform, Azure Development, Project Server, SQL Server ... )Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.comBlogger87125tag:blogger.com,1999:blog-3441621881565286758.post-59355348752641234092025-12-28T02:30:00.000-08:002025-12-28T02:30:00.117-08:00SharePoint Online + Acumatica Integration Architecture (Using SPFx & OAuth2)

Modern SPFx + OAuth2 + Acumatica ERP Integration Integrating SharePoint Online with Acumatica ERP allows organizations to bring core ERP data—such as Stock Items, Customers, Vendors, Sales Orders, and Cases—directly into a modern SPFx web part. This post shows how authentication, tokens, and data flows work together in a secure enterprise-ready design. 🌐 High-Level Architecture The

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-87121309498742794792025-12-28T02:10:02.154-08:002025-12-28T02:19:46.123-08:00Displaying SharePoint Files Inside a Custom Acumatica Screen

Allow Users to Fetch Files From SharePoint Into Acumatica Entities Many organizations use SharePoint Online as their primary document management system while relying on Acumatica as their ERP. A common requirement is enabling users to view SharePoint files inside Acumatica and selectively attach them to ERP entities such as: Sales Orders Purchase Orders Vendor Profiles Customer

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-9891987564739388532025-12-25T22:51:00.000-08:002025-12-28T02:20:26.898-08:00Acumatica - SharePoint DMS IntegrationSPFx Library Extension + Approval Workflow

SharePoint–Acumatica DMS Integration — SPFx Library Extension SharePoint Online is a powerful DMS (versioning, metadata, workflows). Acumatica is the ERP system of record. This integration routes documents through SharePoint libraries, enforces approval and metadata, and only publishes validated documents into Acumatica. Overview A custom SPFx Library

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-71847415256640656422020-12-28T02:24:00.000-08:002025-12-28T02:25:56.500-08:00Authenticate SharePoint Online SOAP Services

Connect To Office 365 SharePoint Online site through SOAP service, authenticate user and get the list of all SharePoint List . 1. Authenticate User Function , Get Authenticate cookie - public static CookieContainer GetAuthCookies(Uri webUri, string userName, string password){    var securePassword = new SecureString();    foreach (char c in password) {

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-43846460875142900282017-12-07T05:56:00.000-08:002017-12-07T05:56:22.895-08:00SharePoint Site Retention Solution

SharePoint sites can quickly grow , keeping outdated/inactive sites around takes up storage space, makes it difficult for people to find current information, and may also be undesirable for compliance reasons.  Retention policies are particularly helpful for organizations that allow large groups of users to create their own sites. This policy is extremely important for organization, because

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-78710330567312983272015-03-12T01:55:00.000-07:002015-03-12T01:55:24.396-07:00ListView Day Filter in SharePoint

There was a query at technet forum , "Requirement to show "Daily" stats on a custom list.  Criteria are to show items modified between 3pm yesterday to 3pm today. " Solution -   1- Create a Calculated column in list. The formula should be  - Name - ModifiedHrs Type - Calculated Formula:     =HOUR(Modified) Format -Number (1, 1.0, 100) Number of

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com1tag:blogger.com,1999:blog-3441621881565286758.post-2798531692502034842015-03-12T01:32:00.003-07:002015-03-12T01:32:50.029-07:00Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown

Problem : In a sharepoint 2013 Installation or SP1/CU installation ,  after installation when start psconfig wizard, it throws error - " An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: Failed to upgrade SharePoint Products."Solution:  Restart your Timer service before you run config

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-5205020414619431232014-12-28T02:26:00.000-08:002025-12-28T02:28:23.709-08:00hide empty list view webpart

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-59555772319497857542013-11-27T23:46:00.001-08:002015-01-12T22:05:04.534-08:00Forms Based Authentication (FBA) in SharePoint 2013

Setting Forms Based Authentication (FBA) in SharePoint 2013 is almost same as to SharePoint 2010 [ http://gj80blogtech.blogspot.in/2010/12/forms-based-authentication-in.html ]. Some differences are in .net framework version (4.0),  web.config entries ,  .Net 4.0 membership provider configuration not supported in IIS directly, No option for classic mode authentication now etc. In this

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-42720420915169536172013-10-20T01:12:00.000-07:002013-10-20T01:12:01.976-07:00Install SharePoint 2013 on a single server by using machine user

This installation guide will help in installation of SharePoint 2013 on a single server non-domain environment. Especially for development environment we need to install SharePoint, SQLServer and other required software on a single machine. The default SharePoint installation require domain accounts and environment, but for development purpose we will do some trick to do the installation by using

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-51490883639207424792013-08-29T01:17:00.001-07:002013-08-29T01:17:06.532-07:00Create New Secure Store Service Application ID in SharePoint 2010 using PowerShell

Use CreateSecureStoreApplicationID function to new SharePoint Secure Store Application ID using Powershell. Parameters :  $sssName - Mandatory - SharePoint Web Url - e.g. http://server:port/  $sssFriendlyName - Mandatory - SharePoint Library Name  $sssContactEmail - Mandatory - File Path on hard drive , e.g. .\abc.xlsx $sssAdminIdentity $sssAdminPassword $

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-4986273583389198862013-08-26T04:52:00.000-07:002013-08-26T04:52:31.994-07:00Add Excel Web Access WebPart Using PowerShell

Use Add-EWAWebPart function to add a Excel Web Access webpart in a SharePoint page using PowerShell script. Parameters :  $webUrl - Mandatory - SharePoint Web Url - e.g. http://server:port/  $ExcelFileURL - Mandatory - Excel File URL  $pageRelativeUrl - Mandatory - SharePoint WebPart Page Relative Url , e.g. "Library/page.aspx" $zone - Mandatory -  The WebPartZoneBase

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-43074600802597365062013-08-23T06:06:00.000-07:002013-08-23T06:06:43.789-07:00Create Blank WebPart Page Using PowerShell

Use CreateBlankWebpartPage function to create blank webpart page in a Non-Publishing SharePoint web. Parameters :  $webUrl - Mandatory - SharePoint Web Url - e.g. http://server:port/  $WebPartPageName - Mandatory - New page name $WebPartPageLibraryName - Mandatory - Parent Library name for new page $pageLayout - Mandatory - Page Layout code - Int function

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-6056993048088519382013-08-19T08:34:00.000-07:002013-08-19T08:34:00.272-07:00Upload File In Document Library Using PowerShell

Use UploadFileInLibrary function to upload a file in SharePoint document Library. Parameters :  $webUrl - Mandatory - SharePoint Web Url - e.g. http://server:port/  $DocLibName - Mandatory - SharePoint Library Name  $FilePath - Mandatory - File Path on hard drive , e.g. .\abc.xlsx function UploadFileInLibrary {     [CmdletBinding()]    Param(&

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-25218097679394963282013-08-16T08:36:00.001-07:002013-08-16T08:36:19.325-07:00Create SharePoint List / Library Using PowerShell

Use CreateSharePointLibrary function to create a new SharePoint List or Library. Parameters :  $webUrl - Mandatory - SharePoint Web Url - e.g. http://server:port/  $LibraryName - Mandatory - SharePoint Library Name  $Discription - Mandatory - SharePoint Library Description  $LibraryTemplate - Mandatory - SharePoint Library Template  function

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-57212823148675659002013-08-01T04:54:00.000-07:002013-09-13T04:56:00.259-07:00Configure SSRS in SharePoint 2010

Here are the required steps for configuring SQL Server Reporting Services in SharePoint 2010 integrated mode. My Test Environment : Single Server For SharePoint And SQL/SSRS Server , e.g. Server Name - GJ-PC Prerequisites : Make sure you installed Reporting Service feature during SQL Server 2008 R2 Installation. Else add Reporting Services features to your existing SQL installation. SQL/

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-52938045650268788722011-05-25T23:28:00.001-07:002011-05-25T23:28:57.171-07:00Customization Using JQuery

Client-Side Programming in Sharepoint # 5 - Customization Using JQuerySave jquery-1.3.2.js in local document library (Jquery) , and update jquery file references in below scripts.You can placed these script either on the page in SPD editor or in CEWP.List Forms (Edit/Display) - Hide created and modified by block from list forms (Edit, Display)<script type="text/javascript" src="/Jquery/

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-22401636848127947062011-05-24T23:02:00.000-07:002011-05-24T23:13:48.070-07:00Customize List View Using Jquery

Client-Side Programming in Sharepoint # 4 - Customize List View Using JquerySharePoint views allow us to show SharePoint Lists in different ways. You can select subset of columns to show on the tabular grid, Can define sorting, filters, grouping, paging etc on list items. As Views represent logical subset of list record, so a list can have multiple views. Sometime we need to customize these OOB

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-28229133667218003732010-12-06T21:13:00.000-08:002010-12-06T21:18:04.901-08:00Forms Based Authentication in SharePoint 2010 - Part 2

<< Forms Based Authentication in SharePoint 2010 - Part 1 Custom Login FormYou Can create a custom login form for your FBA enabled web application in following steps… Locate _forms folder of your webapplication (C:\inetpub\wwwroot\wss\VirtualDirectories\port\_forms) Create a new folder FBA in _forms; Create new page Login.aspx in FBA Folder; add all Resources in this folder e.g. images

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com1tag:blogger.com,1999:blog-3441621881565286758.post-44130577687950073552010-12-06T04:47:00.001-08:002010-12-06T21:19:15.566-08:00Forms Based Authentication in SharePoint 2010 - Part 1

We can create web applications either using Classic Based Authentication or Claims based Authentication in SharePoint 2010. Classic Mode Authentication refers to the integrated windows authentication. Claims Based Authentication is built on Windows Identity Foundation , we can enable windows as well as form authentication on this mode. Forms based authentication can only be configured with web

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-23023684070039412722010-07-19T04:40:00.000-07:002010-10-05T22:25:04.449-07:00SSRS Error - Report Server has encountered a SharePoint error (rsSharePointError) Get Online Help User cannot be found.

Reporting Services Error - Report Server has encountered a SharePoint error (rsSharePointError) Get Online Help User cannot be found.Case 1: - If the user (Author) of site is removed/deleted from the site collection. Or if We have restore the database to different server and the Author is not there in new environment . In that case this error is very common when the document library or site(that

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-8439986946346505222010-06-24T00:43:00.000-07:002010-06-24T00:43:41.007-07:00Server error: http://go.microsoft.com/fwlink?LinkID=96177

Server error: http://go.microsoft.com/fwlink?LinkID=96177 While trying to install - WSS SP1 - MOSS 2007 Service Pack 1 - Februray Cummulative Update 2010 on MOSS 2007 SP2 or (!) KB979445 - wss-kb977022 After the installation completed , SharePoint Products and Technology Configuration Wizard get stuck at task 9 of 10. When tried to access any site, encountered the following error: Server

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-9182979588282604932010-05-31T22:43:00.000-07:002010-05-31T22:45:24.805-07:00Daily Timesheet Comment in Project Server 2007

Project server, Out of the Box, Timesheet (my timesheet) allow us to enter comments for each task (single comments for whole week). But it does not allow us to enter daily comments for each task. For Example, in one week I have worked on 2 tasks , as - Task 1 - Mon , Tue, Wed ; Task2 – Thu , Fri OOB I can only enter 2 comments (one for Task 1 and one for Task 2) , there is no provision for

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com2tag:blogger.com,1999:blog-3441621881565286758.post-87439178059384882252010-04-22T00:44:00.000-07:002010-04-22T00:44:50.780-07:00Configure AJAX In Sharepoint 2007

For enabling Ajax in SharePoint 2007, We need first to configure SharePoint Portal to support AJAX. We can do it in following way - Installing ASP.NET AJAX on servers in your farm install the full " AJAX Extensions " from ajax.asp.net Download ajextoolkit - http://ajaxcontroltoolkit.codeplex.com/releases/view/11121 Configure SharePoint to support AJAX & AjaxControlToolkit – For enabling

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0tag:blogger.com,1999:blog-3441621881565286758.post-10119110372716463992010-03-10T22:02:00.000-08:002010-03-10T22:02:49.527-08:00SharePoint Conference 2009 Resources

Office 2010 Videos What's New in Office 2010 for Developers Develop Advanced Access Web Databases and Publish to SharePoint Excel and Excel Services: The Top 10 Features You Need to Know Customizing Office 2010 Backstage View and Ribbon Deep Dive Open XML and the Open XML SDK ----------------- SharePoint 2010 Videos Overview of the SharePoint 2010 Developer Platform Developing

Ganesh Jathttp://www.blogger.com/profile/01836674607354426725noreply@blogger.com0