Configuring editors with SumatraPDF

This document explains how to configure your favourite editor for synchronization with SumatraPDF.

Introduction

Synchronization technologies

SumatraPDF supports two synchronization technologies: pdfsync and the more recent SyncTeX.

To use the first one you just need to load the 'pdfsync' package in your latex document as follows:
\usepackage{pdfsync}
When compiling your source file, LaTeX will generate a .pdfsync file along with the .pdf output file. This file can then be used by SumatraPDF to perform synchronization.

With SyncTeX it is not necessary to load any package. However you need to specify the 'synctex' switch when compiling your document with pdflatex:
pdflatex -synctex=-1 document.tex
Also make sure you have updated your TeX installation as only recent releases of pdftex support this feature (TeXLive 2008 and MikTex 2.7).

For more details on the synchronization feature of SumatraPDF, check the following posts: Post 1 Post 2 Post 3.

Inverse search

With the inverse search synchronization feature, double-clicking on the PDF file in SumatraPDF brings you directly to corresponding line in the .tex source file.

By default the WinEdt editor is invoked. If you are using the build of SumatraPDF from my website, then you can change this command by choosing the Menu 'File\Set inverse search command line'. The format of the string is:
"C:\Program Files\MyEditor\MyEditor.exe" PARAMETERS
where PARAMETERS can contain the following macros:
%f path to the TeX source file
%l line number
%c column number

Forward search

Forward search gives you the ability to go from the source .tex file to the corresponding location in the PDF. When you invoke a forward search from your editor, SumatraPDF automatically highlights the corresponding location in the PDF. The communication between the editor and SumatraPDF relies on the DDE protocol (Supported by most editors such as WinEdt and TeXnicCenter).

Synchronization in action

Screenshot

Configuration for commonly used editors

WinEdt

Inverse search
Inverse search command:
"C:\Program Files\WinEdt Team\WinEdt\winedt.exe" "[Open(|%f|);SelPar(%l,8)]"

Forward search
1- Download the macro file Sumatra-Find.edt.
2- Save it in the folder: C:\Program Files\WinEdt Team\WinEdt\Exec\
3- Open the menu 'Option\Execution Modes', tab 'Acrobat' and set the field 'PDF viewer Executable' to the path to your local copy of SumatraPDF-sync.EXE.
4- Go to the menu 'Option\Menu setup'. Create a new macro menu somewhere (under 'Accessories' for instance) and fill the options as follows:
Name: Sumatra Find
Macro: Exe('%b\Exec\Sumatra-Find.edt');
Requires File Filter: %P\%N.pdf
Start in: %P
Shortcut: F8

Now when editing a .tex file in WinEdt, you can invoke forward search by pressing F8.

TeXnicCenter

Latex compilation
If your are using synchronization based on the pdfsync package then you can just compile your TeX file as usually. If instead you prefer to use SyncTeX-based synchronization then you need to tweak the compilation switches in TeXnicCenter as follows:
1- Menu 'Build\Define output profiles...'
2- Select the profile "Latex=>PDF"
3- Select the tab '(La)TeX'
4- In the field 'Command line arguments to pass to the compiler' add -synctex=-1.

Inverse search
Inverse search command:
"C:\Program Files\TeXnicCenter\TEXCNTR.EXE" /ddecmd "[goto('%f', '%l')]"

If you are using the official build of SumatraPDF this setting can be set once for all at the command-line with:
C:\Program Files\TeXnicCenter\SumatraPDF.exe -inverse-search "\"C:\Program Files\TeXnicCenter\TEXCNTR.EXE\" /ddecmd \"[goto('%f', '%l')]\""

Forward search
To setup forward-search with TeXnicCenter proceed as follows:
1- Menu 'Build\Define output profiles...'
2- Select the profile "Latex=>PDF"
3- Select the tab 'Viewer'
4- Fill the options as follows:
Path of executable: c:\tools\SumatraPDF-sync.exe -reuse-instance
Forward search: select DDE command
Command: [ForwardSearch("%bm.pdf","%Wc",%l,0,0,0)]
Server: SUMATRA
Topic: control
View project's output: select DDE command
Command: [Open("%bm.pdf",0,1,1)]
Server: SUMATRA
Topic: control
Close document before running (La)TeX: Do not close

(nt)Emacs

Inverse search
Set the following inverse search command in SumatraPDF (menu 'File\Set inverse search command line'):
c:\emacs\bin\emacsclientw.exe +%l "%f"

Make sure the emacs server is started by by running the command
server-start
from within Emacs or by adding (server-start) to your emacs init file. (See Emacs doc)

Auctex settings
- Configure the pdflatex-command from the configure menu in emacs:
(LaTeX-command "latex -synctex=-1")
- Set 'Latex\Customize Auctex\Tex command\Tex Output View Style\Line containing the phrase <^pdf$>' to
C:\Programme\SumatraPDF\SumatraPDF.exe %o

Forward search
1- Download the script file sumatra-forward.el
2- Update your init.el or .emacs file to load the sumatra-forward script by adding the following command:
(require 'sumatra-forward)
3- Make sure that you have the ddeclient tools. (It is bundled with ntemacs)
4- Restart Emacs
5- Press F8 in the TeX document to trigger a forward-search

Further explanations on how to make Emacs+Auctex work with SumatraPDF are available here.

Vim

Julien Cornebise and Manuel Pégourié-Gonnard have developed a patch for Vim-latex. You can download it from vim-fwdsumatra.zip.
Installation instructions are provided in the zip file.

Источник

Мобильные разводки

• Нумер раз (КоммерсантЪ)

Сводные таблицы в Excel

1. Удаление отсутствующих элементов в выпадающих меню

Problems: Old Items Remain in Pivot Field Dropdowns

The data in the pivot table source may change, and items that were previously in the source are no longer included. For example, some sales reps may leave the company, and the names of their replacements appear in the source table.

Even after you refresh the pivot table, the names of the old sales reps will appear, along with the new names. In the list at right, Cartier has replace Gill, but Gill still appears in the list.

Solution 1: Manually Clear Old Items
To manually clear the old items from the list:

1. If you manually created any groups that include the old items, ungroup those items.
2. Drag the pivot field out of the pivot table.
3. On the Pivot toolbar, click the Refresh button.
4. Drag the pivot field back to the pivot table.

Solution 2: Change the Retain Items Setting in Excel 2007
To prevent old items from being retained in an Excel 2007 pivot table, you can change an option setting:

1. Right-click a cell in the pivot table
2. Click on PivotTable options
3. Click on the Data tab
4. In the Retain Items section, select None from the drop down list.
5. Click OK, then refresh the pivot table.

Solution 3: Programmatically Clear Old Items -- Excel 2002 or later

In Excel 2002, and later versions, you can programmatically change the pivot table properties, to prevent missing items from appearing, or clear items that have appeared.

Sub DeleteMissingItems2002All()
'prevents unused items in non-OLAP PivotTables
'pivot table tutorial by contextures.com
Dim pt As PivotTable
Dim ws As Worksheet
Dim pc As PivotCache
'change the settings
For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
pt.PivotCache.MissingItemsLimit = xlMissingItemsNone
Next pt
Next ws


'refresh all the pivot caches
For Each pc In ActiveWorkbook.PivotCaches
On Error Resume Next
pc.Refresh
Next pc


End Sub

Материал из книги "Excel 2007 PivotTables Recipes", взято отсюда

Хороший журнал про разработку ПО

CrassTalk

Top 3 Online Backup Services

Текст взят отсюда, опыт эксплуатации -- собственный.

Online backup services work much like traditional backup software. With an online backup service, however, your important data is transmitted over the Internet and securely stored on a server in a professional data center instead of being stored on your own CDs, DVDs, or backup tapes.

The reason I list only 3 online backup services, even though there are dozens of choices, is because these few stand so far above the rest. Save yourself some time and check these out.

1. Mozy
Without reservation, Mozy is my pick as the best online backup service. Any exceptional backup service should be easy to use, cost effective, automatic, reliable, and easy to restore from. Mozy is nearly the perfect embodiment of these requirements.

To get started with Mozy, visit their website and sign up for an account. Download and install their software, tell it what files or types of files to backup, and then set it to automatically backup whenever you like.

MozyHome Free is, you guessed it, completely free and gives you up to 2 GB of storage on Mozy's servers.

MozyHome costs $4.95/month and allows for an unlimited amount of data backup. This service sets Mozy above all others.

2. IDrive-E
IDrive-E is similar in most ways to Mozy and other online backup services. Some features that make IDrive-E stand out among the competition include mapped drive support, file sharing, more frequent continuous backup, and support for server operating systems.

I found their software to be a little less user friendly than Mozy's, but if their unique features are high on your priority list, IDrive-E may be just what you're looking for in an online backup service.

IDrive-E Basic is completely free and gives you up to 2 GB of storage.

IDrive-E Pro costs $4.95/month and they advertise "unlimited backup". However, their Terms of Usage page defines "unlimited" as no more than 150 GB.

3. Carbonite
Carbonite's online backup service works in a similar way to the other services - you download and configure a piece of software and the backup is handled automatically in the background.

I found Carbonite's software to be slow and I thought it was integrated too heavily into my computer. Mozy's and IDrive-E's software programs were more independent and feature rich, while Carbonite's became more of a part of my computer by integrating directly into Windows Explorer and my desktop. If you don't mind this type of software, Carbonite may be your first choice for backing up online - many people rave about this service.

Carbonite's service costs $49.95/year and allows for an unlimited amount of data backup.

========================
Использовал Mozy и iDrive. Впечатления смешанные, но, в целом, доволен. Первый более гламурный и "тупой", второй -- более управляемый, но грубый.

Как сэкономить? Можно получить купоны, для этого используем Google, например, так.
Или смотрим специальные сайты, например, этот.

В чем различие между Инцидентом и Запросом?

Q: What is the difference between incident and a service request?

A: Incident is not planned and means that the service is disrupted, Service Request has a planned process or procedure ready to be executed, for example password reset.

I will explain you with an example.
1. Service Request -> Request for a new PC
2. Incident -> My PC is not working
In certain conceptions request for a new PC could be classified as Change Request.

Thus, some examples of Service requests would be...
Add toner to the printer
Run a report
Etc.

Использование MS Visio в качестве inside plant

Вослед почившему CA NetViz (подробно на русском можно поглядеть, например, здесь) возникли идеи использования MS Visio в качестве надстройки-визуализатора.
И сразу находятся ответы в сети

• Network topology using Visio 2007
• Integrating Visio 2007: Introduction to Integrating Visio with Other Microsoft Programs
• Integrating Visio 2007 and Access 2007
• Integrating Visio 2007 and Microsoft SQL Server 2005