Parallels and Excel keyboard shortcut issues

I got Parallels so that I could seamlessly learn Windows Excel keyboard shortcuts for my MBA classes, on my Mac OSX Mojave Mid-2015 machine.

I didn’t want to dual-boot, because I saw my friend you before and it seemed arduous. That’s the opposite of what I need right now. Less barriers, not more.

Finally I came across a solution: https://kb.parallels.com/125000

Essentially, shutdown your Windows install > right click the Parallels icon in the dock > Select Configure. Navigate to the Keyboard and Mouse option. Change the Keyboard dropdown to “Optimize for Gaming”.

Boot up the VM of Windows and test out the keyboard shortcuts in Excel.

Mine worked. If yours did not, there is a secondary step in the KB link around this Keyboard/Excel shortcuts topic from the Parallels’ team.

How to OCR an image PDF to be able to TTS

I used FoxIT PhantomPDF with the OCR add-ons.

Step 1. Download FoxIT PhantomPDF for Mac (I used the trial as I’m hoping to get an education discount)

Step 2: Download the OCR Public add-on
Instructions: https://www.foxitsoftware.com/blog/how-to-install-ocr-in-foxit-phantompdf/

To download the Foxit OCR Add-ons, click here. Then follow the steps as shown in the image below:

  1. Select the red “Foxit PhantomPDF” tab, then scroll down to the bottom of the page.
  2. Select the OCR Public Add-on download

    * Note: You can download both of the add-ons at the same time, but you HAVE TO install the OCR PUBLIC first

Step 3. Install FoxIT PhantomPDF

Step 4: Don’t try and open the .fzip add-on files. Open FoxIT PhantomPDF > Help > Install Updates . Select the OCR Public Add-on and install it.
https://kb.foxitsoftware.com/hc/en-us/articles/360040658011-How-to-Install-FZIP-File

Step 5: Download the OCR Lang efig add-on
Instructions: https://www.foxitsoftware.com/blog/how-to-install-ocr-in-foxit-phantompdf/

To download the Foxit OCR Add-ons, click here. Then follow the steps as shown in the image below:

  1. Select the red “Foxit PhantomPDF” tab, then scroll down to the bottom of the page.
  2. Select the OCR Language Add-on download

Step 6: Open FoxIT PhantomPDF > Help > Install Updates . Select the OCR Lang efig Add-on and install it.
https://kb.foxitsoftware.com/hc/en-us/articles/360040658011-How-to-Install-FZIP-File

Step 7:

  • Find Convert in the top menu (it is beside Home)
  • Find the “OCR” item in the ribbon
  • Select a file
  • (if your file is greyed out try “Select Multiple”)
  • (if you get an Error/Warning message, try the round about technique to get the PDF if a different state.)

Roundabout technique:

(My issues was there was a passcode. I couldn’t read the warning in the FoxIT Multiple file select. I had downloaded Adobe Acrobat on a trial to try the same thing, and it provided me with the correct error. But, FoxIT is cheaper and great service so I went back to them for the process.)

The technique is something I learned from

“How to remove password from a pdf file” by howtotutorialsin

FOR THE RECORD: I’m only doing this for accessibility reasons and I do not suggest doing this for nefarious reasons.

On your Mac, go to the .pdf in Finder. Right click on the file. Open with > Google Chrome.

Go to Print > Print as PDF.

Return to FoxIT OCR and attempt the process again.

SPServices Sharepoint 2007 non-published site

Oh what a process this was.

Generally I just need to get content from a list and use it on multiple pages, so there is consistency.

(realize it only works on Chrome and FF. Not IE11 yet) 😦

 

Step 1: Make a dummy list to work with, and add a few columns with a few rows of data

 

Standards > Requirements List

 

Step 2: Get the js files I need

Codeplex? Github? Where the… are these files?

Codeplex for SPServices

https://spservices.codeplex.com/releases/view/119578

 

and find the 1.11.0 version of JQuery corelibrary

https://code.jquery.com/jquery/

 

and add them to the project

Step 3: Check they work and watch for XHTTP Request warnings – I think the SPServices service uses deprecrated async functions

Adding jQuery+SPServices to a SharePoint Page: Step One, Always

http://stackoverflow.com/questions/28322636/synchronous-xmlhttprequest-warning-and-script

adding seems to work

$.ajaxPrefilter(function( options, original_Options, jqXHR ) {
    options.async = true;
}); 

Step 4: Use these resources to get started

SPServices Stories #7 – Example Uses of SPServices, JavaScript and SharePoint

SPServices Stories #7 – Example Uses of SPServices, JavaScript and SharePoint

Step 5: Make sure you adding the weburl if you are using a subsite – you don’t need the vti_bin/list.asmx at the end of the url – if you have issues with grabbing the content and when you console.log your xdata you aren’t getting a responsexml to work with, double check the Network is bringing back the right content.

http://spservices.codeplex.com/wikipage?title=GetListItems

+ check the comments

(I tried :

http://stackoverflow.com/questions/11634206/sharepoint-getlistitems-not-returning-list-items

It looks like you need to access the root site. If, for some reason, you simply can’t use ECMAScript

clientContext = new SP.ClientContext();
var oWebsite = clientContext.get_site().get_rootWeb();  //this is the web object
var url = clientContext.get_site().Url; //this is the root url
var listServiceUrl = url + "/_vti_bin/lists.asmx";

You could always use location.host + "/_vti_bin/lists.asmx" if that’s safe in your current setup.

But I ended up going with:

/js/jquery-1.11.0.min.js
/js/jquery.SPServices-2014.02.min.js

$(document).ready(function() {

$.ajaxPrefilter(function( options, original_Options, jqXHR ) {
options.async = true;
});

//console.log(“hellow12e14”);
/*clientContext = new SP.ClientContext();
var oWebsite = clientContext.get_site().get_rootWeb(); //this is the web object
var url = clientContext.get_site().Url; //this is the root url
var listServiceUrl = url + “/_vti_bin/lists.asmx”;
console.log(listServiceUrl );*/

$().SPServices({
operation: “GetListItems”,
async: false,
listName: “Requirements List”,
webURL: “http://enablingsolutions.bns/standards” ,
CAMLViewFields: “”,
CAMLRowLimit: 0,
completefunc: function (xData, Status) {
//console.log(xData.responseXML);
//console.log($(xData.responseXML).SPFilterNode(“z:row”));
//console.log($(xData.responseXML).SPFilterNode(“z:row”).length);
var liHtml = “”;
$(xData.responseXML).SPFilterNode(“z:row”).each(function() {
//console.log($(this).attr(“ows_Title”));
liHtml += “

  • ” + $(this).attr(“ows_Title”) + “
  • “;

    });
    //console.log(liHtml);
    $(“#tasksUL”).append(liHtml);
    //console.log($(“#tasksUL”));
    }
    });
    });

     

    <ul id=”tasksUL”></ul>

     

    Later I will try

    http://spservices.codeplex.com/wikipage?title=%24%28%29.SPXmlToJson

     

     

     

    Resources:

    Good over view of functions

    jQuery Library for SharePoint Web Services (SPServices) 2014.02 Released

    Documentation

    http://spservices.codeplex.com/documentation

    http://spservices.codeplex.com/documentation#general-instructions

    Using SPServices with CAMLQuery to get ListItems

    Outlook – Setting up all emails to preview

    https://support.office.com/en-ie/article/display-the-three-line-autopreview-for-email-messages-853a3cff-752a-40d2-8382-be5102039663

     

    Depending on the day you may need to see an overall preview of all of your emails in Outlook to be efficient. Other times you may only need a short list of all your emails. Knowing these settings are important for people who need to shift focus quickly with their visual layout.