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