Setup Scan to Email

To scan to email from an HP printer there are 2 major steps:

  1. Run the Scan to E-mail Wizard
  2. Configure the printer/scanner

Follow the below detailed instructions; I’m using a HP Officejet Pro 8610 and Office 365 email.

Run the Scan to E-mail Wizard

  1. Run the HP Officejet Pro Software
    1. This can be downloaded from HP if it’s not on the local computer already
  2. Run the Scan to E-mail Wizard
    1. HP Printer Software
  3. Add a new Outgoing Email Profile
    1. Add email address, name and PINScan to Email Setup
    2. Click Next
    3. Configure the SMTP Settings; I’m using Office 365
      1. Server: smtp.office365.com
      2. Port: 587
      3. SSL/TLS: Checked
      4. Enter O365 User ID and PasswordSMTP Setup
    4. Click Next
    5. Optional include sender checkbox
    6. Click Save and Test
    7. HP Email Profiles

Configure the Printer/Scanner

  1. Tap the printer touch screen
    1. Tap Scan
  2. Tap Scan > Email
    1. Scan to Email
    2. From:
      1. Select the profile configured in section aboveSelect From Profile
    3. To > + (adding a new destination email account)
      1. Type in email addressEnter Email Address
      2. Save with name
    4. Subject:
      1. Optional
  3. Tap Start Scan to test the setup

There you have it. I use this when sending scans to SharePoint or MS Teams, as well as sending scans to other users emails. A nice use for this is scanning invoices and purchase orders directly to an Invoices or Purchase Orders Document Library in SharePoint. This can be done by leveraging Teams. See Laura Rogers great post on Teams and incoming email.

Improving WordPress Performance

My Turtle Works web site was running slow. Being that it runs in WordPress I wondered if I needed better performance from the server. After calling ReadyHosting.com support they introduced me to a simpler way to improve performance. Optimizing the MySql tables used by WordPress.

Optimizing Tables

  1. Access phpMyAdmin
  2. Select your WordPress database
  3. Scroll to bottom of list and click Check All
  4. In the Drop Down showing With selected select Optimize table
  5. Very quickly a page displays showing all the tables and their status.

Once I optimized my home page load time went from 10 seconds to 3 seconds.

Installing BPC 10.0 NW Support Packages

Prep

Before beginning, document the current install by making screen shots of the System > Status in SAP GUI for reference.

Download Files

NOTE: NW BPC Support Packages are NOT cumulative, so download all the SPs between your current version and the latest.

  1. Retrieve the needed .SAR file(s) from the SAP Marketplace
  2. Software Downloads > Support Packages and Patches > A – Z Index > B
  3. SAP BPC FOR SAP NETWEAVER > SBOP PC 10.0 FOR SAP NW
  4. Comprised Software Component Versions > SAP CPM BPC ABAP 10.0 > Support Packages
    1. See Finding Prerequisites section below to identify what other files you need.
  5. Check the box for the SP and click Add to Download Basket.
  6. At this point, the SP is in the Approval List tab of your Download Basket and needs to be approved for download by SAP.
  7. Submit a ticket to the XX-SER-SAPSMP-SDM component asking them to approve the download.
  8. Once it is approved you may download it.

NOTE with Solution Manager, you can retreive the SP directly thru NetWeaver.

Finding Prerequisites:

  1. While at step 4 in the section above
  2. Click the Title of the Support Package
  3. Click Package Info
  4. Scroll down to Import conditions
  5. The above screen shot shows, that BPC and POASBC Add-ons must be installed. And SP01 for BPC and SP02 for POASBC must be installed. (POA = Portable Object Adapter from CORBA and SBC = Shared Business Components)

Upload Support Packages

The Support Packages need to be uploaded into NetWeaver and decompressed.

Load the Support Package into NetWeaver:

  1. On the NetWeaver server, logon to client 000 as Admin
  2. Run the SPAM transaction
  3. Go to the Support Packages menu
  4. Click Load Packages > From Front End
  5. Browse to the .SAR file location
  6. Click Open
  7. Click Decompress
  8. Repeat steps 1 thru 7 for all the SP files.

Transport Support Packages

Once the files are uploaded and decompressed, import them into the system:

  1. On the main SPAM display ensure ‘New Support Packages’ is selected under ‘Directory’
  2. Click Display
  3. Click the SP in the list
  4. Right click on the package and choose Define Queue
  5. Click the green checkmark (Continue)
  6. Click No to Adding Modification Adjustment Transports to the queue
  7. The window should close and in the main SPAM window, the Queue should display your SP
  8. Click the red truck button to transport the update
  9. Click the Continue to start the transport of the update into the system
  10. Once the transport finishes, ‘Confirm the Queue’ by clicking the green checkmark with a pencil.
  11. Repeat steps 1 thru 10 for all SP files.

Troubleshooting

If a transport fails with Objects_Locked error

  1. Capture the detail like Request #, Objects (ex. R3TR SICF WEB)
  2. To fix the issue, the lock(s) must be release. They must be releases in the Tasks, Requests order
    1. Use SE01
    2. Click the locked task
    3. Click the Truck button
    4. Do steps 2 and 3 for all locked tasks
    5. Click the locked request
    6. Click the Truck button

If the lock is occurring in a client other than 000, you must login to that client to release the locks.

appSettings for a SharePoint Timer Job

The SPTimerJobs run under OWSTIMER.exe which doesn’t use web.config or it seems machine.config. So add an OWSTIMER.EXE.config file to C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12BIN. This is the format of the file:








IE8 Caching Login With Favorites

Situation

I recently had a strange SharePoint experience, where a certain user would always find me logged in to SharePoint when he launched it!

History

On this users I had switched users within SharePoint once, so I could show him features he didn’t have permissions for. I then saved a Favorite in his browser so he could easily get to SharePoint and left his office. A week later, I’m in a meeting with the user and I notice I’m logged into SharePoint on his laptop!!!

Remedy

After a little investigation, I come to discover IE8 caches credentials with the favorite! What on earth was Microsoft thinking?

To solve this, I deleted his favorite, logged into SharePoint with his credentials and saved a new favorite. Now all is good.

Moving From September to October in BPC

Moving to October causes some trouble because we are moving from a 1 digit period (Jan = 1, Sep = 9) to a 2 digit period (Oct = 10). This causes problems during the Convert Task in SSIS. The actuals to transform text file contains all the correct data, the actuals to load text file contains only a header. The transformation fails.

To resolve this problem a change to the transformation file needs to occur. Follow these steps to make the change:

  1. eData > Manage Transformation File
  2. Select the file, in our case Actual CMS.xls
  3. Under the *MAPPING section find TIME=*COL(4) + *STR(.) + *COL(5) or TIME=*COL(4) + *STR(.0) + *COL(5)
  4. For 1 digit periods change *STR(.) to *STR(.0)
  5. For 2 digit periods change *STR(.0) TO *STR(.)
  6. Click on Validate and save transformation definitions in the Action Pane on the right.
  7. When prompted to Save, just select the same file, so in our case Actual CMS.xls.
  8. Click Yet to replace the existing file.
  9. Close the Transformation file

Installing MOSS in VirtualBox Environment – Notes

Machine Environment:

Windows Server 2008 64bits Install the .NET Framework 3.0 Features Configure service accounts, see this for details. Have SQL Server prepared, preferabbly on another VM and using a named instance. In my case I had to put SQL on the same VM because networking between VMs was unstable.

MOSS Setup:

  1. Server Type: Select Advanced -> Complete install
  2. File Location: Install MOSS to non OS drive
  3. Before running the SharePoint Products and Technologies Wizard, neither any databases, application pools or web sites are created. However D:Program FilesMicrosoft Office Servers12.0 is created.


SharePoint Products and Technologies Wizard:

Create a new farm
Config DB Settings:

  1. MOSS_Farm_Config
  2. spSql account for the database

Config Central Admin Web Application

  1. Port 9991
  2. Use NTLM authentication

Performing configuration tasks 1 thru 9

  1. Create Config DB
  2. Install Help collections
  3. Securing SharePoint resources
  4. Registering SharePoint services
  5. Registering SharePoint features
  6. Provisioning Central Admin Web App
  7. Installing the application content files
  8. Finalizing the Products and Technologies configuration

At this point the following items have been created:

  1. MOSS_Farm_Config DB
  2. SharePoint_AdminContent_GUID DB
  3. OfficeServerApplicationPool (NetworkService identity)
  4. SharePoint Central Administration Application Pool (spsqluser identity)
  5. Office Server Web Services Web Site – uses OfficeServer App Pool
  6. SharePoint Central Administration v3 Web Site

and the Central Admin Site displays in the browser. At this point address the Administrator Tasks displayed.

Administrator Tasks

READ FIRST

Displays the Quick Start Guide

Deploy Servers???

Nothing required for a small farm

Assign services to servers

Excel Calculation Services – just start it, no configuration required.

Configure Office SharePoint Server Search Service Settings

  1. Farm Search Service Account – spSearch
  2. Configuring this search doesn’t create a database, app pool or web site

Configure Windows SharePoint Services Search Service Settings – This provides search capabilities within the Help content

  1. Service Account – spSearch
  2. Content Access Account – spContentAccess
  3. Database MOSS_WSS_Search created

Configure server farm’s shared services (New Shared Services Provider)

SSP Name – TurtleSSP

Create a new Web Application

NOTE: The SSP needs its own Web application. This will be the second web application for the system (Central Admin was the first).

IIS Web Site

  1. Description: MOSS TurtleSSP
  2. Port: 9992

Application Pool

  1. MOSS TurtleSSP – 9992
  2. Service Account: spAppPool

Database Name and Authentication

  1. DB Name: MOSS_TurtleSSP_Admin

MOSS_TurtleSSP_Admin DB created
MOSS_TurtleSSP – 9992 App Pool created
MOSS TurtleSSP – 9992 Web Site created

My Site Location

Create a new Web Application

NOTE: The SSP needs its own Web application. This will be the second web application for the system (Central Admin was the first).

IIS Web Site

  1. Description: MOSS MySite
  2. Port: 9993

Application Pool

  1. MOSS MySite – 9993
  2. Service Account: spAppPool

Database Name and Authentication

  1. DB Name: MOSS_TurtleSSP_MySite_Content)

MOSS_TurtleSSP_MySite_Content DB created
MOSS_MySite – 9993 App Pool created
MOSS MySite – 9993 Web Site created

SSP Service Credentials

Service Account: spSsp (This account is for SSP Web services to use for inter-server comm and running SSP timer jobs)

SSP Database

Used for Service specific data

  1. DB Name: MOSS_TurtleSSP_Content

Search Database

  1. DB Name: MOSS_TurtleSSP_Search

MOSS_TurtleSSP_Content DB created
MOSS_TurtleSSP_Search DB created
TurtleSSP App Pool created
(Don’t recall the opp to name this MOSS_TurtleSSP, it appears to grab the name of the SSP)


SP 2007: New Web Application, Site Collection and Document Center in a VirtualBox Environment

Create New Web Application

IIS Web Site

  1. Description: MOSS Web App – 80 (Consider TurtlePoint Web App – 80)
  2. Port: 80

Application Pool

  1. App Pool Name: MOSS Web App – 80 (Consider TurtlePoint Web App – 80)
  2. Account: spAppPool

Database Name and Authentication

  1. DB Name: MOSS_WebApp_Content

MOSS_WebApp_Content DB created
MOSS Web App Web – 80 Site created
MOSS Web App – 80 App Pool created

Create New Site Collection

Title and Description

  1. Title: Turtle Point

Template Selection

  1. Publishing > Collaboration Portal

Primary Site Collection Administrator

  1. TURTLELLCAdministrator

No new database, web site or app pool created

BPC Drillthrough for CMS Actuals

Actuals Activity

Current year Actuals data is pulled from 1 table:

GTRAN – G/L Transactions

For previous year Actuals, data is pulled from:

GTLYN – Last Year G/L Transactions

Opening Balances

Retrieved from GLMT

FinanceDrillThrough Table

For Activity and Opening Balances, data is written to the FinanceDrillThrough table which looks like this:

Column_name Type Length Nullable
Entity nvarchar 64 no
Account numeric 9 no
Period numeric 5 no
JournalType nvarchar 2 yes
TranDate datetime 8 yes
TranSource nvarchar 4 no
Amount numeric 9 no
RefNum nvarchar 20 yes
RefDesc nvarchar 60 no
RevEntry nvarchar 2 yes
Century numeric 5 yes
Year numeric 5 yes
PostDate datetime 8 yes
Batch numeric 5 yes
MinorSalesCode nvarchar 6 yes
MajorSalesCode nvarchar 6 yes

Rollups

The GetFinanceDrillThrough stored procedure calls functions that explode rollups into base level members.

Pulling Data From CMS into BPC

Several Files (tables) in CMS are used when pulling data.

MAST – G/L Chart of Account Header
GLMT – G/L Chart of Account Totals for Year

Most of the data comes from GLMT. That is, activity and opening balance comes from GLMT. Properties like account type and company are retrieved from MAST.

Retrieving data from any system requires the same thing. Pulling Company(Entity), Account, Account Type (P&L, BS), Opening Balance and Activity. In some cases, Company is broken up as well such as Payroll and Operations. In those cases that breakdown must be retrieved as well.