Outlook全局通讯录(Global Adress Book)无法同步引出的一系列问题

公司有自己的exchange邮件服务器，用户一般用Outlook收发邮件、日程表、安排会议。有若干同事一直在反映，无法在通讯录里看到公司的全局通讯录，平时手工添加甚是麻烦。

I tried download Address Book(at SEND/RECEIVE->Send/Receive Groups->Download Address Book), but it didn't work.

Then I tried this,

1. First backup data file, remove actually account in Outlook then re-add it, not manually add but automatically.

2. Install Outlook Certificate which locates on M:\IT_Public\Programs\Outlook Certificate.

3. Re-start Outlook and import backup data file, problem is solved!

Before, in file->info->account settings, there isn't Delegate Access, Download Address Book or Manage Mobile setting choice. Right now, it all has.

Though the problem is solved, I'm still not sure it caused by certificate or during add account procedure. I guess the former administrator didn't find Outlook certificate at time so he added account manually. In my way, I added certificate during adding account automatically procedure.

It's not a problem, give me root, I can solve everything. I won't tell you that I have no permission to log in exchange server.

-.-

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.

妙用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端在线表格有了预载入的数据，如图，

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

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.