e-infrastructure | Thomas' Work Space

Yet another couple of glitches solved in setting up Outlook 2013 with Gmail IMAP for GoogleApps

2014/12/19 plagwitz Leave a comment

I googled and followed this useful guide. However, a couple of glitches remained:
Connection to Incoming mail server fails if you really just put your username:
1. put instead of username@companygoogledomain.com:
Test send of email message through outgoing server fails if you just followed instructions:
2. Click on button: “More” / tab: “Outgoing Server” / do check box “My outgoing server requires authentication ” and log on (I now prefer to be explicit, after the initial mixup of usernames for incoming and outgoing), enter your full user@compgoogledomain.com and password. No need to enable SPA, though.
Viola (and quousque tandem…, sigh ).

Categories: e-infrastructure, office-software Tags: 2013, gmail, imap, outlook

A little addendum about data types to the +N(“comment”) in-cell formula comment trick in Excel

2014/12/18 plagwitz Leave a comment

You are relying with this well-documented trick on the fact that addition of 0 will altering a numeric value.
However, what is not mentioned: not all work in Excel involves the number data type.
1. Try adding your comment or zero to a string data type, and you will get a #VALUE error.
2. Boolean, however, works also, since – as you can see when you have Excel evaluate your formula – if you try adding 0 to a Boolean data type, Excel casts the prior Boolean FALSE to 0 or TRUE to 1, and casts the result of your addition (of 0 = nothing) back to the same initial Boolean for further evaluation.
3. So just put your +N()-comments in those part of your formula that involve either number or Boolean data type, and avoid adding to strings, for example:

=IF(
    OR(
        ISBLANK(
            [Related issues]
        ),
        (            ISERR(
                FIND(
                    “#“,
                    [Related issues]
                )
            ) )
    ) +
    N(
        “do nothing if no related task in col:related issues“
    ),
    ““,
    IF(
        NOT(
            ISERR(
                FIND(
                    “,“,
                    [Related issues]
                )
            )
        ) +
        N(
            “do nothing if no 2nd value in col:related issues“
        ),
        CONCATENATE(
            MID(
                MID(
                    [Related issues],
                    FIND(
                        “,“,
                        [Related issues]
                    ) + 2,
                    LEN(
                        [Related issues]
                    ) –
                    FIND(
                        “,“,
                        [Related issues]
                    ) + 1 +
                    N(
                        “extracted the 2nd value from col:related issues“
                    )
                ),
                FIND(
                    “#“,
                    MID(
                        [Related issues],
                        FIND(
                            “,“,
                            [Related issues]
                        ) + 2,
                        LEN(
                            [Related issues]
                        ) –
                        FIND(
                            “,“,
                            [Related issues]
                        ) + 1
                    )
                ) + 1,
                4
            ) +
            N(
                “extracted the 4# of id of related issue“
            ),
            MID(
                MID(
                    [Relatedissues],
                    FIND(
                        “,“,
                        [Relatedissues]
                    ) + 2,
                    LEN(
                        [Relatedissues]
                    ) –
                    FIND(
                        “,“,
                        [Relatedissues]
                    ) + 1
                ),
                FIND(
                    “ “,
                    MID(
                        [Related issues],
                        FIND(
                            “,“,
                            [Related issues]
                        ) + 2,
                        LEN(
                            [Related issues]
                        ) –
                        FIND(
                            “,“,
                            [Related issues]
                        ) + 1
                    )
                ) + 1,
                2 +
                N(
                    “appended to or from to the 4# of id of related issue“
                )
            )
        ),
        ““
    )
)

This splits, extracts and copies values from a none to multi-value column for better sortability:

Categories: e-infrastructure, office-software Tags: comments, MS-Excel, worksheet-formulas

Fun with .docx to .html transforms by means of HtmlConverter from PowerTools for Open XML

2014/12/15 plagwitz Leave a comment

The transform is FOSS and platform-independent:
1. It neither requires Office nor Windows (The OpenXML SDK runs on Linux via Mono on the server.
2. However, the most recent installment of Powertools for OpenXML, a high-level API to the OpenXML SDK, comes with a PowerShell interface (benefit: no Visual studio requirement).
Valuable features of the transform, among many other things, are:
1. HtmlConverter is able to translate MS-Word styles into CSS (insofar needed – my code style has “No proofing” set, however, this cannot be implemented on the WWW), so the layout is preserved as designed, but w/o need for inline formatting:

        span.pt-StrongEmphasis-000052 {
            font-family: Calibri;
            font-size: 11pt;
            font-style: italic;
            font-weight: bold;
            margin: 0in;
            padding: 0in;
        }

        span.pt-lowCodeConsoleChar0 {
            color: #FFFFFF;
            background: #000000;
            font-family: Consolas;
            font-size: 10pt;
            font-weight: normal;
            margin: 0in;
            padding: 0in;
        }

     &lt;h3 dir=&quot;ltr&quot; class=&quot;pt-000040&quot;&gt;
            &lt;span class=&quot;pt-000041&quot;&gt;2.2.1&lt;/span&gt;&lt;span class=&quot;pt-000042&quot;&gt;&lt;span class=&quot;pt-000043&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;pt-Heading2Char&quot;&gt;&lt;b&gt;References&lt;/b&gt;&lt;/span&gt;
          &lt;/h3&gt;

          &lt;p dir=&quot;ltr&quot; class=&quot;pt-BodyText&quot;&gt;
            &lt;span class=&quot;pt-DefaultParagraphFont-000003&quot;&gt;&lt;br /&gt;
            &amp;lrm;&lt;/span&gt;&lt;span class=&quot;pt-000000&quot;&gt;&amp;nbsp;&lt;/span&gt;
          &lt;/p&gt;

          &lt;h1 dir=&quot;ltr&quot; class=&quot;pt-000006&quot;&gt;
            &lt;span class=&quot;pt-000007&quot;&gt;&lt;b&gt;3&lt;/b&gt;&lt;/span&gt;&lt;span class=&quot;pt-000008&quot;&gt;&lt;b&gt;&lt;span class=&quot;pt-000009&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;span class=&quot;pt-Heading1Char&quot;&gt;&lt;b&gt;Introduction&lt;/b&gt;&lt;/span&gt;
          &lt;/h1&gt;

          &lt;h2 dir=&quot;ltr&quot; class=&quot;pt-000018&quot;&gt;
            &lt;span class=&quot;pt-000019&quot;&gt;3.1&lt;/span&gt;&lt;span class=&quot;pt-000020&quot;&gt;&lt;span class=&quot;pt-000021&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;pt-Heading2Char&quot;&gt;&lt;b&gt;Purpose of Document&lt;/b&gt;&lt;/span&gt;
          &lt;/h2&gt;

There are many more options that I have not yet tried:

            SimplifyMarkupSettings simplifyMarkupSettings = new SimplifyMarkupSettings
            {
                RemoveComments = true,
                RemoveContentControls = true,
                RemoveEndAndFootNotes = true,
                RemoveFieldCodes = false,
                RemoveLastRenderedPageBreak = true,
                RemovePermissions = true,
                RemoveProof = true,
                RemoveRsidInfo = true,
                RemoveSmartTags = true,
                RemoveSoftHyphens = true,
                RemoveGoBackBookmark = true,
                ReplaceTabsWithSpaces = false,
            };
            MarkupSimplifier.SimplifyMarkup(wordDoc, simplifyMarkupSettings);

            FormattingAssemblerSettings formattingAssemblerSettings = new FormattingAssemblerSettings
            {
                RemoveStyleNamesFromParagraphAndRunProperties = false,
                ClearStyles = false,
                RestrictToSupportedLanguages = htmlConverterSettings.RestrictToSupportedLanguages,
                RestrictToSupportedNumberingFormats = htmlConverterSettings.RestrictToSupportedNumberingFormats,
                CreateHtmlConverterAnnotationAttributes = true,
                OrderElementsPerStandard = false,
                ListItemRetrieverSettings = new ListItemRetrieverSettings()
                {
                    ListItemTextImplementations = htmlConverterSettings.ListItemImplementations,
                },
            };

One would really wish there was a way to get such HTML cleaned up automatically (ouch!):

               &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;M&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;anaged requirements for system integration&amp;nbsp;&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;of Center&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;&amp;nbsp;&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;software&amp;nbsp;&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;with&amp;nbsp;&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;iLearning&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;&amp;nbsp;and with content production and management (BPD). To mitigate lack of integration of $50k LMS software investment into departmental workflow&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;,&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;&amp;nbsp;&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;developed&amp;nbsp;&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;and documented&amp;nbsp;&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;software to automate&lt;/span&gt;
                &lt;span class=&quot;pt-DefaultParagraphFont-000006&quot;&gt;&amp;nbsp;creation of 4K+ user accounts p.a., 30K+ learning documents and 100K+ interactive content paths in LMS.&lt;/span&gt;

There are also much more serious conversion errors:

MS-Word displays a plain text content control and a repeating section content control within a table, containing one Combobox and one plain text content control per row, perfectly:

Convert-DocxToHtml gobbles the content completely (and so does Google Docs Preview):

The underlying HTML has just a blank table under each heading:

    &lt;div class=&quot;pt-000001&quot;&gt;
        &lt;p dir=&quot;ltr&quot; class=&quot;pt-qiCVHeading1&quot;&gt;
          &lt;span class=&quot;pt-DefaultParagraphFont-000002&quot;&gt;Profile&lt;/span&gt;
        &lt;/p&gt;
      &lt;/div&gt;
      &lt;div align=&quot;left&quot;&gt;
        &lt;table border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; dir=&quot;ltr&quot; class=&quot;pt-000003&quot; /&gt;
      &lt;/div&gt;
      &lt;div class=&quot;pt-000001&quot;&gt;
        &lt;p dir=&quot;ltr&quot; class=&quot;pt-qiCVHeading1&quot;&gt;
          &lt;span class=&quot;pt-DefaultParagraphFont-000002&quot;&gt;Technologies&lt;/span&gt;
        &lt;/p&gt;
      &lt;/div&gt;
      &lt;div align=&quot;left&quot;&gt;
        &lt;table border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; dir=&quot;ltr&quot; class=&quot;pt-000003&quot; /&gt;
      &lt;/div&gt;

MS-Word shows:Yet need to look in to the underlying XML to see whether the .docx is to blame for that…
But HtmlConverter output in IE or Firefox: The underlying HTML reveals that the css does not get applied in the right place:

 	&lt;tr&gt;
                &lt;td class=&quot;pt-000079&quot;&gt;
                  &lt;p dir=&quot;ltr&quot; class=&quot;pt-BodyTextSmall&quot;&gt;
                    &lt;span class=&quot;pt-BodyTextSmallChar-000081&quot;&gt;AD&lt;/span&gt;
                  &lt;/p&gt;
                &lt;/td&gt;
                &lt;td colspan=&quot;2&quot; class=&quot;pt-000079&quot;&gt;
                  &lt;p dir=&quot;ltr&quot; class=&quot;pt-BodyTextSmall&quot;&gt;
                    &lt;span class=&quot;pt-BodyTextSmallChar-000081&quot;&gt;Active Driector, Microsfot&amp;rsquo;s directory implementation.&lt;/span&gt;
                  &lt;/p&gt;
                &lt;/td&gt;
              &lt;/tr&gt;

              &lt;tr&gt;
                &lt;td class=&quot;pt-000086&quot;&gt;
                  &lt;p dir=&quot;ltr&quot; class=&quot;pt-BodyTextSmall&quot;&gt;
                    &lt;span class=&quot;pt-000085&quot;&gt;&amp;nbsp;&lt;/span&gt;
                  &lt;/p&gt;
                &lt;/td&gt;
                &lt;td colspan=&quot;2&quot; class=&quot;pt-000086&quot;&gt;
                  &lt;p dir=&quot;ltr&quot; class=&quot;pt-BodyTextSmall&quot;&gt;
                    &lt;span class=&quot;pt-000085&quot;&gt;&amp;nbsp;&lt;/span&gt;
                  &lt;/p&gt;
                &lt;/td&gt;
              &lt;/tr&gt;

One could imagine MS-Word acting less strictly than OpenXML PowerTools:Convert-DocxToHtml, like a web-browser’s parser tolerates and displays bad HTML. However, not only would need to be justified how MS-Word can also serve as the originating HTML WYSIWYG editor. The OpenXML PowerTools:Get-OpenXmlValidationErrors for both of the above documents does not seem to find any OpenXML errors that could explain the bad conversion (other than dozens of Sch_UndeclaredAttribute errors (Version-related? Not sure how this could be) , there is only a Pkg_PartIsNotAllowed relating to a glossary).

Also yet to do:
1. When (not always!) does my page title end up as empty?
```
&lt;title&gt;&lt;/title&gt;
```
2. Defaults to doctype xhtml, not html(5).
Done:
```
openXml\OxPt\OxPtCmdlets\OxPtHelper.cs:var htmlString = html.ToString(SaveOptions.None); // trp: requesting pretty-printing, was:html.ToString(SaveOptions.DisableFormatting);
```

Categories: e-infrastructure, service-is-documenting Tags: Convert-DocxToHtml, Get-OpenXmlValidationErrors, MS-Word, openxml, powertools-for-openxml, single-sourcing, XML

How to fix primary screen on Linux laptop not coming out of sleep

2014/10/17 plagwitz Leave a comment

Problem: My Debian (Jessie) Linux laptop has issues with juggling a secondary screen and sleeping at the same time. More specifically, it seems:
1. It seems if you come out of sleep with a secondary screen connected, even if you put the laptop to sleep with “it” (o.k., not the same “it”, just spec-wise the equivalent FULL HD LCD screen on VGA – being able to easily move the laptop to work in multiple places is kind of the point of having one in the first place), the primary laptop screen seems to remain asleep completely. FN keys to switch primary and secondary screen on laptop have no effect.
2. If you disconnect the secondary screen, Linux does fall back onto the primary screen, however, “forgets” to turn the backlight on. FN keys to up brightness have no effect
3. have not found a reliable way avoiding the issue – maybe always disconnecting secondary screen before putting laptop to sleep? If you don’t want to have to do this, or forget, try to use this:
Workaround:
1. While I could get to the tty shell on secondary screen using CTRL+ALT+F1, but using xrandr --auto gave can't open display.
2. However, try installing this utility which I found recommended in a different context:
  1. aptitude search xbacklight
  2. xbacklight - simple utility to set the backlight level
  3. aptitude install xbacklight
  4. Switch to a non-elevated user (or else you’ll get: No protocol specified" , "Primary laptop", "Can't open display :0", Why can't I run GUI apps from 'root': "No protocol specified"? : " In Debian $XAUTHORITY is usually not set explicitly.", "xauth list xauth: file /root/.Xauthority does not exist" ).
  5. Then issue: xbacklight -set 50 OR issue xbacklight -inc 50.
  6. Viola: “Fiat lux”…
  7. Sleep takes out your primary screen and you are not good at blind starting, finding and typing into your Konsole? Right-click on the desktop of your secondary scree, “Run command”, and issue the same command line.
  8. Thank you, xbacklight.

Categories: e-infrastructure, Glitches&Errors, os, service-is-testing-troubleshooting-debugging Tags: backlight, debian, jessie, linux, power-management

How to export BMC Remedy data into Excel other than via copy-paste

2014/10/10 plagwitz Leave a comment

This question came up during consulting (Disclaimer: BMC provides non-customers only limited access to online documentation and trial software).
BMC Remedy Action Request System 8.1 supports a wide variety of reports, including from a query builder, and editing of reports, using the free Eclipse data visualization and reporting plugin BIRT, and exports of reports in a wide variety of formats, including Excel ( you can find more on Exporting to Excel in these articles).
BMC can also read excel and other data: “Data Management is a web-enabled dataload tool that enables you to import data into your system” (source) .
BMC Remedy provides ODBC connectivity (note: read-only , so no round-tripping!). Applications that have been used with this feature include Access, Crystal Reports and Excel. In principal, querying an ODBC data source from Excel (2007 and up) works like this:
On the Excel machine, install the BMC-provided ODBC driver into ODBCINST.INI (contains information about ODBC drivers available system-wide).
Create an ODBC connection, save office data connection files as .odc file for easy reuse.
Query the Remedy database using SQL from ribbon: ” Data” / section:”Get External Data”:”From other sources”/ menu item: “From Microsoft Query”, select the Remedy Database, clear “Use the Query Wizard”, log in, in “Microsoft Query” window, add Remedy data tables, then columns to display, then go to menu: “File”/ “Return Data to Microsoft Office Excel”.
Some BMC-ODBC-driver-specific limitations are covered in BMC Remedy AR System ODBC considerations
If the exact required functionality is not built in, BMC remedy also provides extension points for developing plugins. See Application development with BMC Remedy Developer Studio, which happens with using BMC Remedy Developer Studio, a freely downloadable add-on which can be enabled by a vendor call.

Categories: audience-is-IT-staff, e-infrastructure, service-is-it-managing Tags: bmc-remedy

We can nest controls in repeating content controls, including repeating content controls

2014/10/06 plagwitz Leave a comment

Just saying, since it seems not easy to find within web search results the ones that nest nesting….
Have not tried accessing the results in OpenXML yet which will have to be done via the control ID
1. since repeating:
2. does not autoincrement the titles and tags.

Categories: animated-GIFs, e-infrastructure, service-is-documenting Tags: 2013, content-controls, MS-Word

How to get Square brackets (and hide comments) with ISO690 in Word 2013 bibliography styles

2014/09/14 plagwitz 2 comments

Lots of people online seem to be looking for square brackets with citations in ISO690 style in Word 2013, but having no luck with getting the Bibliography XSL for older Word versions to work. Trying to edit the old XSL still results in it not loading into the MS-Word Citation Style dropdown.
What is needed is a way to parse the XSL and debug load errors. In the meantime…
I had better luck with starting from the current Word2013 ISO style. If you stream Office365, this is now in %appdata%\Microsoft\Templates\LiveContent\15\Managed\Word Document Bibliography Styles
1. Puzzlingly, there is also a %appdata%\Microsoft\Bibliography\Style which some of your edited files get copied to – go figure….
2. The ISO690 file I based my variation on is called : TC102851224[[fn=iso690nmerical]].xsl
3. Copy this file to %appdata%\Microsoft\Templates\LiveContent\15\User\Word Document Bibliography Styles\
4. Open it with a text editor (I use NotePad++).
5. Change “Openbracket” section like so: And the corresponding for closebracket
  <!– trp: –>
  [
6. Same principle change for the corresponding for “Closebracket“
  1. Lst time I carelessly introduced printing space characters before my closing brackets – just copy the leading chars from a working XML line if you run into this problem.
I also needed to not print “Comment”-field of the source in my bibliography”
1. Search for:
2. Comment out the “print”-action inside (easier than changing each bibliographgy type):<!– trp:
  –>
Change the style name. MS-Word 2013 uses “StyleNameLocalized” instead of “StyleName”, so I added a qualifier to each localized name within the test:
ISO 690YOURNAMEHERE
Restart MS-Word, and with luck, your styles will show in the ribbon References section style dropdown: . Apply them (using F9):
Download: TC102851224[[fn=iso690nmericalsquare0comments]]

Categories: e-infrastructure, e-research, office-software, service-is-documenting Tags: 2013, bibliographies, comments, iso690, MS-Word, square-brackets, styles, XML, xsl

Windows Live Spaces url forwarding still working

2014/08/28 plagwitz Leave a comment

It is a long time ago that I migrated my blog from Windows Live Spaces to WordPress.
It appeared to me recently that the URL forwarding from the original web pages to WordPress which was part of the migration package that Microsoft offered, had stopped working – regrettably, since I still have old documents pointing to the original pages, and the cryptic URL naming scheme seems to make it difficult to find out where the original ULR pointed to.
However, it seems that only some forwarding stopped working. If I reformat URL format 1 (which redirects to the WordPress homepage) to format 2, the forward still works:

Categories: blog, e-infrastructure Tags: blogging, redirecting, windows-live-spaces, wordpress

Newer Entries Older Entries

Thomas' Work Space

Archive

Yet another couple of glitches solved in setting up Outlook 2013 with Gmail IMAP for GoogleApps

A little addendum about data types to the +N(“comment”) in-cell formula comment trick in Excel

Fun with .docx to .html transforms by means of HtmlConverter from PowerTools for Open XML

How to fix primary screen on Linux laptop not coming out of sleep

How to export BMC Remedy data into Excel other than via copy-paste

We can nest controls in repeating content controls, including repeating content controls

How to get Square brackets (and hide comments) with ISO690 in Word 2013 bibliography styles

Windows Live Spaces url forwarding still working

Blog Stats

Your message has been sent

Top Posts & Pages

Top Clicks

Categories

Email Subscription

Archives

Top