install OneNote 2013 in Win Server 2012 R2

After installed the Office 2013 in Windows server 2012 R2, we can run oneNote 2013 in this server, but when we open the OneNote, system show error that we need to install "Desktop Experience" , feature, but this feature does not show in feature.what OneNote is looking for is "Ink and Handwriting Services ". after install this feature, need to restart .

how to search in Google

   

1.      [] 完整詞組 search

2.       特定網站內搜尋 site:edu + 字串 (例句site:mobile01.com 網路)

3.       標點符號不列入

4.       依檔案類型search 字串 + filetype:ppt (ppt or pdf or xls or doc)

5.       特定或略過字詞或字元: “the” Gold river, search 的文件中定有 the 的字詞

但若用 – 表示忽略.例如 莎莎醬食譜-番茄.則表示在食譜中不需要番茄.

6.       限定金額收尋範圍使用 [..] 如$300..$500表示300~500之間

7.       數值轉換如 miles to km [使用 to ] 如 10 miles to km

8.       時間查詢 time + 城市或國家 like: time Taipei

9.       貨幣換算 [貨幣 1] in [貨幣 2] 例如 USD in Pesos

1.        Define : 查詢字義 , 例如  Define: swag(類似字典)

Cross-Docking

出處 : http://tw.myblog.yahoo.com/tang2002tw/article?mid=6211

Cross Docking 中文意思及解釋

  1.Cross Docking 中文意思
     a)越庫營運系統
     b)接駁式轉運
     c)即進即出

  2.Cross Docking 解釋 

傳統上企業均運用「倉儲營運系統（warehousing     operating system)管理存貨供應商將貨品運至倉儲中心（warehouse）而美國Wal-Mart 於90年代採用「越庫營運系統」（cross-docking operating system)供應商正確的貨品與數量出貨至越庫轉運中心，越庫轉運中心做入帳後，經過簡單分類後，貨品不需入越庫轉運中心倉庫，直接送至出貨口由貨車配送至零售商，貨品停留於越庫轉運中心的時間極為短暫。

越庫轉運中心可被視為貨品由供應商送至下游零售商時的一個中間轉運站，越庫轉運中心的存貨相當低，甚至可將其視為零存貨

這些「越庫營運系統」（cross-docking operating system)歸功於條碼(Barcode/Bar code)的發明

Nav2013 setting

We can install the Navision 2013 to 3-tires structure,
1. SQL Server, Save SQL DB only.
2. Nav Server, Install Nav 2013 Server. ( Server2, maybe a Hyper-V server, but on another physical Server)
3. RTC, Nav 2013 Client for end user.(On local user PC).
but on SQL server, must delegate to Nav Server.
http://msdn.microsoft.com/en-us/library/aa905162(v=sql.80).aspx

Open PDF file on SharePoint 2010

After install SP2010 and migrated SP2007 into 2010, open pdf file has problem.
So we need follow up some structure to modify CM & DOCICON.xml file.
follow up this:
http://www.youtube.com/watch?v=ay6Xvb2oIUU

PowerPivot installation

PowerPivot must be install with SharePoint Server, for Example; SQL Server installed in physical Server and SharePoint Server installed in a VM server,. When we need install PowerPivot from SQL install CD, we need install this with SharePoint Server in VM server.
ps. install PowerPivot only.


http://msdn.microsoft.com/en-us/library/ee210616(v=sql.105).aspx

Enable Office Web Application in SharePoint 2010

SharePoint 2010 support Office Web application, so we can use browser to browse office file in SharePoint. Before enable office web app, we need download and install.
1. Install Office Web Application
2. Run Configuration Wizard. after finish, system will open Central Administration. don't run Farm configure Wizard and closed wizard.
3. in Central Administration, Application Management -> Manage Service Application -> Secure Store Service, click "New" to add Excel Service ID in "Target Application ID" like 39235 (Excel)
4. Click Application Management -> Manage Service Application -> Excel Service Application ->Global Setting, set 39235 in "Application ID"
5. Now, when you right click excel file in library, you can see open by browser or client. if you want set browser is default, go to library setting -> advance setting, set browser is default.
6. on this time, you open Word or PowerPoint file, you will be get error message like "Word Web App cannot open this document for viewing because of an unexpected error". we need
7. Application Management -> Manage service on server to verify PowerPoint service and word viewing service is started.
8. If both application service are not in list, click "New" and then click "Word Viewing Service" and "Power Point Service Application".
9. in those application dialog box, in name, type those service name, in application pool, select "Use existing application pool" and then in the listbox, select "sharepoint web services default". then click "OK"
A. Now we can browse office file in browser.
B. came from : http://support.microsoft.com/kb/2028346

SharePoint 2010 Site Collection setting

After Farm created and configuration finished, we can login Central Administration Web Application page.
1. Create a user name at AD server, SP_PortalApp
2. Create a Web Application, default port is 80.
3. Host Header, we can set to "TestPortal.vff.com", don't select SSL.
4. Database name change to "WSS_Content_TestPortal"
5. Manage Account is vff\SP_PortalApp
6. System will auto created this Web Application
7. Go back AD server, in DNS, set Host(A) to resolve "Testportal.vff.com" to the IP address of SharePoint Server.
8. Create a Site Collection under "http://testportal.vff.com/". Title can set like "SharePoint 2010 Test Environrment " and enter Primary and Secondary Site Collection Administrator.
9. Now we can login "http://testportal.vff.com"

SharePoint 2010 installation Guide

1. Hardware.
    a. SQL Server; Win SVR 2008R2 *64 + MS SQL 2008 SP2. SQL Memory at least 4096MB
    b. SP2010 Server; Win SVR 2008R2 *64 + SharePoint 2010 Enterprise
2. Accounts ( as domain user)
    a. SP_Admin; added as a loca administrator on SP2010 Server only + dbcreator, public, securityadmin role in SQLserver
    b. SP_Farm
    c. SP_ServiceApp
3. Run "Prerequesteinstall.exe until get "success".
4. Run setup, input license key
5. Select "Server Farm" options, Don't select "standalone"
6. Select "Complete", Don't select "standalone"
7. Run Configuration Wizard after strp 6 finished.
8. Select "Create a new server farm" and next
9. in "Specify Configuration Database Setting"
    a. DB server is SQL Server
    b. DB Name, default is "SharePoint_Config", Don't change.
    c. User Name : SP_Farm & password
A. Enter and confirm your passphrase.
B. Specify a port number for Central Administration Web Application
C. After Wizard, CA will auto open, Select "Yes, I'm willing to participate"
D. Start the "Farm Wizard".
E. Use "vff\SP_ServiceApp" & password in "Service Account"
F. Select all service application except "Lotus Notes"
G. Now, in this wizard. we can create a home site by template.
H. Configure the outgoing e-mail.
I. Configure the secure state service.
    Appliaction Management -> Service Applicatioins -> Manage Service Application ->
    double click "secure store service" -> click "generate new key" then input "passphrase" and click "OK"
J. Set a simple search crawl schedule.
K. Done
 

PowerPivot on SharePoint 2010

PowerPivot on SharePoint 2010 are useful, but SharePoint must be "Server Farm" version. because standalone version couldn't add PowerPivot farm into SP2010.
view document :  PowerPivot for SharePoint – Existing Farm Installation
and this : http://msdn.microsoft.com/en-us/library/ee210616.aspx
and this: http://msdn.microsoft.com/en-us/library/ee210708.aspx

7/20 update. I created a document to know how to use Powerpivot and how to post pivot chart on SharePoint, document on Google Drive. Name is "Power Pivot for Excel and SharePoint"

prefix on IP setting

Prefix size	Network mask	Available subnets	Usable hosts per subnet	Total usable hosts
/24	255.255.255.0	1	254	254
/25	255.255.255.128	2	126	252
/26	255.255.255.192	4	62	248
/27	255.255.255.224	8	30	240
/28	255.255.255.240	16	14	224
/29	255.255.255.248	32	6	192
/30	255.255.255.252	64	2	128
/31	255.255.255.254	128	2 *	256

Cancel pending on Symantec backup Exec

Copy From : http://www.symantec.com/business/support/index?page=content&id=TECH87507

Problem

When trying to cancel an active backup job, the status shows as "Cancel Pending" for a long period of time and may appear to be hung

Cause

When trying to cancel an active job, the job status may show as "Cancel Pending" (see image below) for a long period of time.  Note that the time takes to cancel a running job varies depends on the activities run before the cancelling.  The cancelling job will stay in "Cancel Pending" until the activities timeout before the job terminated completely.  If the job stay in "Cancel Pending" for excessively long period of time, it may appear hung with the following reasons:

• Backup exec services not responding.
• Process of cancellation stuck,and process still running.
• Eg. Common behavior of applications when hung due to slow system performance .
• Respond time of the process or service with the Operating System.

Solution

WARNING / NOTES:

• Job needs to  be cancled manualy.
• This method will cancel ALL jobs that are currently running.

STEPS:

 In the Backup Exec Console-
1. Click on "Tools" > " Backup Exec Services" to open the servicesmgr.exe2. Click on "Restart all services" (In most cases, this process will get to the bengine service and appear hung)
3. Open Windows task manager and click on the "Processes" tab
4. Enable "Show Processes from all users"
5. Click on the "Image Name" column to sort alphabetically
6. Locate and highlight the following services .

• Pvlsvr.exe(Backup  exec device and media service)
• Beengine.exe(Backup exec job engine service)
• Beremote.exe(backup exec Remote Agent for Windows Server service)

7.Right Click on the above services in order and click on "End Process Tree" to terminate this process.

8.Close the task manager and return to the services manager

9.After the services are terminated in Windows-

10."Restart all services" process in the services manager should continue and complete.

Once this has completed, Open Backup Exec console and the backup job that was hung will no longer show in the active jobs.

Check the  Job history below.The cancled job will be displayed with the Error RPC services were restarted by user .No action required.

How to Manage Administrator Permissions on My Sites

Get from RyanT ( http://blogs.syrinx.com/blogs/sharepoint/archive/2007/10/19/how-to-manage-administrator-permissions-on-my-sites.aspx )

How to Manage Administrator Permissions on My Sites

A number of our clients have been confused by the concept of SharePoint 2007 My Sites because of some of the perceived and legitimate architectural difference between the My Site Web Application and traditional Web Applications created by administrators for use in portals and standard Site Collections.

This article will not dive into all differences between a My Site Web Application and other Web Applications, but will merely show you how can assure your ability to administer and manage individual My Sites, or the entire My Site Web Application by giving administration rights to those users and groups that need it.

Manage users via the entire Web Application

If you want to give user or group access to the entire My Site Web Application, you can do this the same way you would with a traditional Web Application via the following steps:

1. Go to SharePoint Central Administration -->Application Management

2. Choose "Policy for Web Application" under the "Application Security" group.

3. Make sure you select the correct Web Application for your My Site in the "Web Application" drop down list on the right.

4. Select "Add Users" on the upper left.

5. Choose "All Zones" by default on the "Add Users" screen and click "Next".

6. Add the appropriate user(s) or Active Directory group that you want to have control over your My Site Web Application.  Select the level of control. Click "Finish".

These users should now have appropriate access to all My Sites in the Web Application. Administrator groups given "Full Control" can now browse to individual My Sites and should see the "Site Actions" button to make administration available.

Manage individual My Site administrators via Central Administration

A lot of people don't realize that every My Site is an individual Site Collection, not just a Site or Web. For the purpose of this article, it makes sense to architect My Sites like this from an administration perspective because Site Collections represent the top level for user permissions and management. This methodology allows individual My Site owners to manage the permissions of their own My Site without requiring assistance or requests from the SharePoint administrators.

To add a specific user or Active Directory group to an individual My Site from Central Administration, follow these steps:

1. Go to SharePoint Central Administration -->  Application Management

2. Click "Site Collection Administrators" under the "SharePoint Site Management" group.

3. Make sure you select the correct Site Collection for your My Site in the "Site Collection" drop down list on the right.

4. The "Primary Site Administrator" is most likely the user that owns the My Site.

5. You can add a user or Active Directory group as the "Secondary site collection administrator" in the box below the primary admin.  Click "OK".

Using this method you can use Central Administration to assign administration rights to specific My Sites.

Manage user permissions via the individual My Site

You can also manage permissions on any My Site where you already have Site Collection Administration access by navigating directly to the specific My Site.  Central Administration access is not required.

1. Navigate directly to any My Site where you already have administration access and go to "Site Settings" via the "Site Actions" button.  If you don't see the "Site Actions" button and cannot navigate to: /personal//_layouts/settings.aspx">http://<web_application>/personal/<user_name>/_layouts/settings.aspxthen you do not have administration or "Full Control" permissions on this Site Collection.

2.From "Site Settings" select "Site collection administrators" from the "Users and Permissions" group on the left-hand side.

3. The "Site Collection Administrators" link allows you to create additional users or groups with Site Collection Administration permissions on this My Site.  Simply add the users or Active Directory groups and click "OK".

Although beyond the scope of this article, if you select "People and Groups" instead of "Site collection administrators" in step #3, you can manage more granular permissions on the My Site as you can with any traditional Site Collection. You can also assign individual users or groups specific permissions on list or list items within your My Site.

How to update site collection quota and lock

作者：jiania |出處：博客園| 2011/12/22 13:19:19 |閱讀43次

出至 http://www.haogongju.net/art/1138698

我們在創建網站集的時候，在頁面的最後一項，有一個“配額模板”的選項，通過它可以設置該網站集的容量大小。默認有兩種選擇“無配額”及“個人模板”。

除了創建網站集的時候進行限制外，默認情況下，對於每個用戶的個人站點是使用“個人模板”進行限制的，每個個人網站限制為100M。

一、創建配額模板

在“管理中心”的“應用程序管理”頁面，點擊“SharePoint網站管理”下的“配額模板”。

在“模板名稱”處，默認選擇的是“編輯現有模板”，可以通過下拉菜單選擇現有模板進行修改。也可以選擇“新建配額模板”創建一個新的。

在“存儲限制值”處，分別填入相關數字即可。

二、修改網站集配額

在“管理中心”的“應用程序管理”頁面，點擊“SharePoint網站管理”下的“網站集配額和鎖定”。

在“網站集”處可以選擇要設置的網站集。

“網站鎖定信息”可以對選擇的網站集的狀態進行設定。

在“網站配額信息”處，可以選擇一個配額模板。如果網站空間已經有使用過的，還會在最下面顯示一行“當前所用的存儲空間”來告訴你已經使用了多少。

三、個人網站配額設置

在存儲個人網站的網站集中，還可以單獨對每一個個人網站進行配額的限制。這樣方便我們的設置。例如老闆的個人網站就可以放寬一些限制了，哈哈。

在“網站集配額和設定”頁面，點擊“網站集”後面的小箭頭，點擊“更改網站集”。

在“選擇網站集”頁麵點擊“更改Web應用程序”

選擇存放個人網站的網站集，這裡選擇“SharePoint - 9000”。

返回後可以看到左邊的“URL”下面會列出目前存在的個人網站。選擇一個需要修改的，例如“/personal/ynzf ”。

在“網站配置信息”中，可以選擇相應的配額模板或者自定義配額的大小。

注：配額限制的大小，有時候會出現超過存儲空間限制的情況。例如限制了100M的大小。你先上傳一個80M的文件，因為沒有超過限制，還可以繼續上傳，上傳的文件如果超過了限制大小也可以，例如你還可以繼續上傳一個80M的文件。當超過限制後就無法再繼續操作了

how to integrate the report service into SharePoint 2010

Report Service 可以整合進 SharePoint 2010. 因此 user 可在不同的site執行已經定義好的報表.例如我可以在sales的site執行跟sales 有關的報表且該報表受site permission管理.
設定如下:
1. 開啟 reporting services configuration manager
2. 進入 Database -> Change database -> select "sharepoint Integrated Mode" and DB Name is RS_SharePoint
3. RS will created a DB under SQL\MSSQLSERVER ( default instant name)
4. open Central Administrator by admin
5. select "General Application Setting -> Report Service Integration
6. set "report server web service URL to http://servername:80/reportserver and use "windows authentication"
7. SharePoint will auto configurate, sometime we need manually to turn on ( activate) Report service
8. click "Site Action" -> site setting
9. select "Site Collection features" under "Site Collection Administration" and active "Report Server Integration Feature" & "Report Server Central Administration Feature"
10. upload .rdl to document
11. right click this rdl to open setting.
12. run this report on SP

How to use template to import Fixed Assets into SAP B1

Original we used RedMoon Fixed Asserts to run our Fixed Assets. but on last year, RedMoon wasn't support SAP B1. so we need to use SAP B1 default Fixed Asset add-on.
經過多次實驗,在template excel file我得到以下結論
1. Item Code = Fixed Asset Class (須先在SBO設定).
2. Depr Start Date ($Q2) 須修改成每月的第一天.例如Capitalization Date ($E2) = 2003-01-25 則須改成 2003-02-01 (建議是16號以前為當月1號,15號以後是下個月1號 )
    公式如下:  =If(Day($E2) < 16, $E2 - Day($E2) + 1, Date(Year($E2), Month($E2) + 1, Day(1)))
3. remaining count 計算方式如下: $R2 - Datedif($Q2, "2012-1-1","m"), 2012-1-1的用意是若使用2012 period的話就使用2012-1-1.若是使用2011的話則改成2011-1-1 ($R2 為 useful life)
4. APCHist 是原先購入金額, APC 則是現今的價格.計算方式為 (Apchist/useful )* RemainingLife
5. save as to csv file then open by notepad, delete head and change "," to ";"
6.日期的格式為YYYY-MM-DD
7. import error = 1, 通常是格式錯誤
8. Number imported assets:0, Number of processed assets:2 則是remaining life or depr start date 錯誤

Couldn't open Project Server

當我試著開啟 project server時,系統告知無法開啟.上網查詢後排解方式如下
1. 確定是否 sharePoint 2010 server 的問題.
2. 開啟 http://servername/pwa/_layouts/settings.aspx 若沒問題表示此為 PWA的問題
3. 使用SharePoint Production configuration 去讓系統重新 config 一次
4. 一切如常.PWA 開啟成功

Publish Pivot Table into SharePoint 2010

在sharepoint2010的版本上不需要將pivot table 檔案下載到Local後執行.因為SP2010支援PT使用瀏覽器.方法如下
1. 開啟Excel2010 & PT
2. 將Report Filter 的欄位另外命名 ( 例如我們將 Year 置於 $A$1, 我們則將 $A$2 命名為 YearRange)
3. Column Labels & Row Labels 不需要命名
4. 存檔後選擇"Save&Send" 後再選 "save to SharePoint",並選定SharePoint 的Site
5. 點選 "Publish Option",開啟後移到"Parameters" Tab.
6. 點選 "Add",螢幕出現在步驟 1 所命名的"名稱".勾選後離開
7. 存檔.回到SP2010即可看到剛才上傳的 PT

IF function couldn't work on my PC

user 問我一個vlookup的問題.我告訴他應該是format type issue.修改後再使用IF的子句將data補齊為4碼.公式如下,
If( Lan(G2)=2, "00"&G2, If(lan(G2)=3,"0"&G2, G2))
但是在我PC的EXCEL2010 run 的有問題.再別台PC上正常.後來發現我為了run別個程式將list seperate (Control panel -> Region and Language -> additional setting ) 改成 "|". 因此公式中的逗號改成 | 就可以運行了.

AD server crushed and restore

星期一是悲慘的一天,早上來到公司後發現上網有些問題.但是intranet很正常.SAP B1, SharePoint都運行順利.因此研判是DNS出問題了.以往只要AD重開機便可.因此請下手重開.沒想到20分鐘後還是無法關機.我的system admin 問我該如何.我說硬關機再開機吧.沒想到AD就如此掰掰了.好在我們有備份AD及檔案的backup tape.早上忙著改USER的DNS.
晚上consultant 9 點到公司開始修復 AD.
1. download "bartpe" 的軟體以便將 AD local 的 administrator password 改成空白 (我忘了密碼了)
2. 開機執行 directory recover ( 相當於 safe mode 下的 recover).系統此時會做 check disk 直到早上3點
3. 再一次進入 Directory Recover 後啟動 Symantec Exec 12 以便回存.旦啟動不了.因此上網查了一下原因.原來是service的啟動受權限影響無法啟動.須將權限改成localsystem.
4. 找到backup tape 昨日的 system file backup回存後重開機.
Wow!!!成功了AD救回來了.
結論是
1. AD放在一部非domain的hyperv 伺服器上.每日備份此 Hyper-V
2. 一段時間WinServer需restart 一次
我該買包乖乖放在server room.