Quickbooks Desktop pro 2017 and .Net Framework 4.7 causes crash

So i have been having a horrible time trying to make sure my books are up to date and making sure my invoices are being sent out.

BUT low and behold, all of a sudden Quickbook keeps crashing no matter what i do.  Open sample company, click about automatic updates, click create invoice... and so on.

After trying many things, i decided to run the Quickbook install diagnostics tool and of course it checks for .NET framework 4.6.1.

After days and days of this issue which i assume Quickbooks devs probably knows about and not released the information to the public.  the application does not run with .NET 4.7

if you are having this issue, then uninstall .NET Framework 4.7 from program files or from features depending on which version of windows you have.

I wonder if Quickbooks have a bug/resolution finders like some companies out there.   I should just send them a bill for this.   lol.

Have fun!

FYI, my version of Quickbooks is v.27.0.4005 before you tell me to update my quickbooks, i have and look at the date of this post. ;)

Find things in InfoPath form templates in a web application

This assessment and clean up process to get things ready for SharePoint online migration is pretty interesting.   So there are some custom web services created for InfoPath forms so that it can get data and functions (lots of date functions) that is not available out of the box.   So need to find all the published templates with the calls to these web services.

So after thinking about what can be done with code and reviewing the InfoPath interop classes leading nowhere.   I found an interesting article https://sharepintblog.com/2011/06/07/updating-infopath-form-templates-and-data-connections-with-powershell/

so with the code that they provided, i modified it to spit out all templates with the data connections to these web services.  

Hope this helps since it is saving a lot of time and effort to track these down and find a workaround.

--updated with the code to include list templates not just document libraries. 

Add-PSSnapin Microsoft.SharePoint.PowerShell –erroraction SilentlyContinue

## the web application to be searched for form libraries

$url = 'https://yoursharepointurl'

## temp working directory

$dir = 'D:\ExtractedForms'

$findstring = 'findthis String'

$exportFile = $false

foreach ($web in (Get-SPWebApplication $url | Get-SPSite -Limit All| Get-SPWeb -Limit All))

{

    foreach($list in $web.Lists)

    { 

        if ($list.DocumentTemplateUrl -ne $null -or $list.ContentTypes[0].ResourceFolder.Properties["_ipfs_infopathenabled"])

        {

            if ($list.ContentTypes[0].ResourceFolder.Properties["_ipfs_infopathenabled"])

            {

                #--------------- get the templateurl for the list template....  

                foreach($folder in $list.RootFolder.SubFolders)

                {

                    foreach($file in $folder.Files)

                    {

                        if($file.Name -eq 'template.xsn')

                        {

                            $listUrl = $web.Url + '/' + $list.RootFolder + '/' + $folder.Name

                            $templateUrl = $web.Url + '/' + $list.RootFolder + '/' + $folder.Name +'/template.xsn'

                            $exportFile = $true 

                        }

                    }               

                }             

                                          

            }

            elseif ($list.DocumentTemplateUrl.ToString().ToLower().EndsWith(".xsn"))

            {

                $listUrl = $web.Url + '/' + $list.rootFolder

                $templateUrl = $web.Url + '/' + $list.DocumentTemplateUrl

                $exportFile = $true 

            }

            if($exportFile)

            {

                ## download the form template

                $filename = $file.Name

                $fileID = $file.UniqueId.Tostring()

                $localfile = $fileID + "\" + $filename

                $file = $web.GetFile($templateUrl)

                $bytes = $file.OpenBinary();

                # Download the file to the path

                $localfile = $dir + "\" + $localfile

                New-Item "$dir\$fileID" -type directory -force | Out-Null

                New-Item "$dir\$fileID\Extracted" -type directory -force | Out-Null

                [System.IO.FileStream] $fs = New-Object System.IO.FileStream($localfile, "OpenOrCreate")

                $fs.Write($bytes, 0 , $bytes.Length)

                $fs.Close()

            

                ## crack open the form template

                EXPAND "$localfile" -F:* "$dir\$fileID\Extracted" | Out-Null

                

                ## get file content and check for string

                $extractedFiles = Get-ChildItem "$dir\$fileID\Extracted" *.x*

                foreach ($extractedFile in $extractedFiles)

                {

                    $efn = $extractedFile.Name

                    $f = [System.IO.File]::Open("$dir\$fileID\Extracted\$efn" ,"open","read","Read")

                    $sr = New-Object System.IO.StreamReader $f

                    $content = $sr.ReadToEnd()

                    $sr.close()

                    $f.close()                     

                     

                    if ($content.Contains($findstring))

                    {

                        Write-Host $templateUrl " :  " $extractedFile.Name -foreground green

                    }

                }               

            }

            $exportFile = $false

        }

    }

    $web.Dispose()

}

Find custom action or activity in a designer created 2010 workflow

While cleaning up my SharePoint farm for the cloud migration, i ran into an interesting problem.   If there are custom activity or action created for your designer workflow, how do you track down which ones uses those custom action or activity.

Here is a simple code to go through a site collection that returns all 2010 workflows that is using your custom action/activity that you created with code.

Add-PSSnapin *sharepoint* -ErrorAction SilentlyContinue

$encode = New-Object System.Text.ASCIIEncoding

$site = get-spsite "type in url"

foreach($w in $site.allwebs)

{

    foreach($wf in $w.Lists["workflows"].items)

    {

        if($wf.Name -like "*.xoml")

        {

            $file   = $wf.File

            $data   = $file.OpenBinary()

          

            $test   = $encode.GetString($data)

            if($test.Contains("text to find.  usually the namespace of the assembly of custom dll") -or $test.Contains("more text"))

            {

                  write-host $w.url $wf.Name

            }

        }

    }

} 

Report Builder: Unable to install this application

When you encounter an error trying to edit your report and the error states that you can not install the REPORTBUILDER:


/_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application?ReportPath=


System.Deployment.Application.DeploymentException (Subscription)
  - Unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for this application or uninstall the preexisting application.
  - Source: System.Deployment
  - Stack trace:
   at System.Deployment.Application.SubscriptionStore.CheckApplicationPayload(CommitApplicationParams commitParams)
   at System.Deployment.Application.SubscriptionStore.CommitApplication(SubscriptionState& subState, CommitApplicationParams commitParams)
   at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)
   at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
   at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)


---------------------------------------


Solution is to rather then change the config or manifest file.   Delete the Clickonce application files on your desktop or machine that you are working on located:


%userprofile%\AppData\Local\Apps\2.0\XXXXX.xxx\YYYYYYYY.YYY\*.*


Here is the example of the folders/files that you need to delete.  the command line is as follows:


del C:\Users\masteroftheUniverse\AppData\Local\Apps\2.0\TN076DJP.QJ2\TDNJXD8N.KQ1\*.*


then try to edit the report again, no issues.

Fix Designer error: Server-side activities have been updated. You need to restart SharePoint Designer to use the updated version of activities.

I have SharePoint Designer 2013 installed and working fine till I needed to install Visual Studio 2015 (I installed Enterprise but this error seems to occur with other versions).   So I researched the issue where some say, you have to un-install then re-install in particular order. 


Just run a repair on the SharePoint 2013 designer in control panel.   If you still get the error, then check the cache folder in your user profile and make sure you have the following files:


replace the <yourname> and <sitename> with your information below.


c:\Users\<yourname>\AppData\Local\Microsoft\WebsiteCache\<sitename>\versionnumber\


Microsoft.SharePoint.WorkflowServices.Activities.Proxy.dll
Microsoft.Web.Design.Client.dll

Upgrade MySite to SharePoint 2013 but the photos are not linking back

So I didn't want to follow the Microsoft recommended directions to upgrade mysite for upgrading the service applications for Metadata and the user profile service.   Which  was fine for the metadata service since they weren't using anything on it.   But the user profile service does present one issue, the photo, which is stored in the user profiles.  


But I do have all the pictures on the mysite since it is stored at the root web under the User Photos library.  


here is the script to update the user photos with powershell,   replace the TODO with your information:




[Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
[Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server")
$siteurl = "TODO fill in mysite url"
$site = New-Object Microsoft.SharePoint.SPSite($siteurl)
$context = [Microsoft.Office.Server.ServerContext]::GetContext($site)
write-host $site.RootWeb.Lists["User Photos"]
#Get list of photos
$list = $site.RootWeb.Lists["User Photos"]
$upm = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
Write-host $list.Items.Count
foreach($listitem in $list.Items)
{
    if($listitem["Name"].ToString().Contains("LThumb") )
    {
      #  Write-host $listitem["Name"].ToString()
        $user = $listitem["Name"].ToString().Replace("_", "\").Substring(0, $listitem["Name"].ToString().LastIndexOf("_"))
    #    write-host $user
        $fullphotourl = $siteurl + "User%20Photos/Profile%20Pictures/" + $listitem["Name"].ToString();
        write-host $fullphotourl
        if ($upm.UserExists($user))
        {
            $profile = $upm.GetUserProfile($user)
            $profile["PictureURL"].Value = $fullphotourl;
            $profile.Commit();
        }
   
    }
}
$site.Dispose()

Infopath template update does not complete apply when the document has digital signature

Encountered a strange issue where the form library template does not get fully applied with the changes when the document is signed using the browser.   If you open the form using the client, the templates gets applied and everything is kosher.


So tried all the basic things to get the browser form to upgrade or relink the form with the update template but no go.


Only one thing would work so, I had to write a little powershell script to open the forms with the InfoPath filler and submit it so that the form is saved with the template updates.

if the file is bigger than 50 MBs, you have to change the setting on the client machine.  it is defaulted to 50MB but you have files that are bigger so the registry setting has to be changed to increase the FileSizeLimitInBytes value located at [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\WebClient\Parameters]

find the TODO and replace with your own value

--------------------------------------------------------

Import-Module "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -AssemblyName Microsoft.Office.Interop.InfoPath

#url
$site = "TODO:  url of the site"

#user name
$admin = "TODO: account name with domain.  I used user@domain"

#Get Password as secure String
$password = Read-Host "Enter Password" -AsSecureString

#Get the Client Context and Bind the Site Collection
$context = New-Object Microsoft.SharePoint.Client.ClientContext($site)

#Authenticate
$credentials = New-Object System.Net.NetworkCredential($admin , $password)
$context.Credentials = $credentials

write-host "authenicated"
$web = $context.Web

$context.Load($web)
$context.ExecuteQuery()

write-host $web.Title

$list = $context.Web.Lists.GetByTitle("TODO: ListName to be filled in")

#write-host $list.Title
$context.Load($list)
$context.ExecuteQuery()
write-host $list.Title
write-host $list.

$query = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery(1000, "Title");
$items = $list.GetItems($query);
$context.Load($items);
$context.ExecuteQuery();

 #$context.Url
write-host $items.Count
$iApp = New-Object  Microsoft.Office.Interop.InfoPath.ApplicationClass
#$sdoc = New-Objct Microsoft.Office.Interop.InfoPath.XDocumentClass
$versionMode = New-Object Microsoft.Office.Interop.InfoPath.XdDocumentVersionMode
foreach($li in $items)
{
    #write-host  $li["Title"].ToString()
   
    $url = "TODO: Url of the list" + $li["Title"].ToString()
  
   #write-host $url
   try
   {
    $xdoc = $iApp.XDocuments.Open($url) #, $versionMode.xdCanTransformSigned)
        $xdoc.Save()
            $xdoc.CloseDocument()
             write-host  "Done 1:  "  $li["Title"].ToString()
    }
    catch
    {
        try
        {
            $xdoc = $iApp.XDocuments.Open($url, 18)  # 16 for $versionMode.xdCanTransformSigned + 2 for xdUseExistingVersion)
             $xdoc.Save()
            $xdoc.CloseDocument()
             write-host  "Done 2:  "  $li["Title"].ToString()
        }
        catch {
            $ErrorMessage = $_.Exception.Message
          
             write-host  "ERROR:  " $ErrorMessage " ::: " $li["Title"].ToString()
        }
    }
   
   
}

$context.Dispose()