2016年6月10日星期五

Alternate access URLs have not been configured (SharePoint 2016)

Applies to: SharePoint Server 2013, SharePoint Foundation 2016
Summary: Learn how to resolve the SharePoint Health Analyzer rule "Alternate access URLs have not been configured."
Rule Name: Alternate access URLs have not been configured.
Summary: A default zone URL must not point to the computer name of a Web front-end server. Because this installation has more than one Web front-end server, an incorrectly configured default zone URL can result in a variety of errors, including incorrect links and failed operations.
Cause: A default zone URL is pointing to the computer name of a Web front-end server.
Resolution: Change the default zone URL to a URL that differs from the computer name of any Web front-end server.
  1. Verify that the user account that is performing this procedure is a member of the Farm Administrators group.
  2. On the Central Administration home page, in the System Settings section, click Configure alternate access mappings.
  3. On the Alternate Access Mappings page, on the Alternate Access Mapping Collection menu, click Change Alternate Access Mapping Collection.
  4. In the Select An Alternate Access Mapping Collection dialog box, click the alternate access mapping collection for which you want to change the default zone URL.
  5. On the Alternate Access Mappings page, click Edit Public URLs.
  6. On the Edit Public Zone URLs page, in the Default text box, type a new default zone URL that differs from the computer name of any Web front-end server, and then click Save.

2016年6月8日星期三

妙用excel做字符串的拼接处理

今日做前端开发,很费力的要把将近两千行的数据item预载入在线表格中,需要特定的数据格式,形如,

data = [
  [1, "string", ***],
  [2, "string", ***],
  ....
]

当前已有的是item_num和item_name目录。刚开始的思路是将其全部复制进txt文本,形如
如下格式,然后用python做字符串的拼接处理。

item_num, item_name
item_num, item_name
....

发现小问题了,每一行后的\n都需要split消除;若想得到List的形式,又会引入新的“”;拼接为单一的一个string不是很友好...果断舍弃,扔一边儿去接着看js各种轮子。

这时,手头的excel灵光乍现!!

1.首先将item_num和item_name分别复制进excel中,得到两列。
2.插入列,填补内容
3.同一行若干个单元格合并,小小的公式“=A2&B2&C2&D2&E2”



合并之后,如图


末列的单元格就是我想要的数据子格式啦。全部复制进[]中,我的data预载入数据就有了,


最终web端在线表格有了预载入的数据,如图,



再次为我的帅气和机智叹服。

2016年6月3日星期五

Outlook full problem

A couldn't find her old mail which has been archived and moved by B.

So I help her to export the history Outlook data, file -> Open&Export -> Open Outlook Data File -> locate and select target data file, then it's ok.

************Outlook full problem***********************

users always meet problem that outlook is full because user's space is only 1G, so AutoArchive is necessary.

To solve this problem, I find an idea,

1. new local data file at Account Settings, which named local_backup, of course, we could also new subfolder named inbox/Drafts/@/#$#
2. archive
   - AutoArchive, for inbox or sent items, we have choices at AutoArchive to delete old mails according to the time and AutoArchive them to local data file
   - Manual, whenever our mailbox is full we could select them to move into local_backup and then delete them
3. in local_backup folder, we could find what we need. One more important, search All Outlook items or All Mailboxes is very helpful.

2016年5月30日星期一

windows下为python安装*.whl

给我一个Terminal,我可以创造一个世界。

给我一台windows,我只能活在盖茨的世界里。

环境win7 64bit,python2.7,怎么安装.whl的拓展包呢?什么环境变量,pip的都不用管了,只需要cmd下一句话,

python -m pip install ***********.whl


就可以啦