HLPlanet.com

Service Log :: TiddlyWiki - updated/extracted SectionLinksPlugin

Author: PiotrL
Subject: TiddlyWiki - updated/extracted SectionLinksPlugin
Posted: Sat Dec 04, 2010 4:01 pm (GMT 1)
Topic Replies: 0

I have spent several hours trying to integrate SectionLinksPlugin with my notebook (implemented using TiddlyWiki).

Original version of this plugin can be found here:
http://www.tiddlytools.com/#SectionLinksPlugin

I was trying to use it for Table Of Contents (TOC) feature.
Below you can find ready-to-be-used TiddlyWiki with that plugin already installed.

In general you need to create or update 4 tiddlers in order to integrate this plugin:
- SectionLinksPlugin (create)
- CoreTweaks (create or update)
- ViewTemplate (for automatic TOC support in every tiddler)
- StyleSheet (for some layout changes)

See attached file with ready-to-be-used empty TiddlyWiki (2.6.1) with installed SectionLinksPlugin (1.4.0a).

After plugin installation just add on the end of your tiddler:

Code:

<<sectionTOC>>

Note:
- if your are using older version of TiddlyWiki it maybe required to change CoreTweaks - see line with "sectionSeparator" (uncomment it - remove "//")

Service Log :: How to search on AS/400 (iSeries)?

Author: PiotrL
Subject: How to search on AS/400 (iSeries)?
Posted: Sat Aug 25, 2007 2:35 pm (GMT 1)
Topic Replies: 0

Introduction
IBM's AS/400 file system is a multi-level object hierarchy as follows:
* Libraries
** Files (Objects)
*** Members

If you want to execute full-text search on several objects you will need to write / use a special tool.
Such a tool is presented in this article.
This tool (RCMD) is a REXX shell-like command processor which can be further modified to handle more commands.
In the current version it handles only one useful command - "lst" - "list".
This command can be used to search for a specific library, object or member by using it's name or contents.

RCMD is a REXX based on several system commands, below is a list of these and similar commands that can be used for searching.

Download link
>> download RCMD

Related services
>> REXX script implementation (AS/400, iSeries, z/OS, PC)

Comments
Your comments are welcome! Please help us improve the content!
>> discuss this article

Search commands
1. How to list libraries with a specified name?
a) SQL - QSYS2/SYSTABLES
You can use SQL command to find libraries with a specified name.
SQL command can be executed using "STRSQL" command processor.
Libraries and files are stored within QSYS2/SYSTABLES global table.
Note that you need to use "FOR READ ONLY" option.

Example SQL:

Code:

SELECT DISTINCT SYSTEM_TABLE_SCHEMA FROM QSYS2/SYSTABLES
WHERE SYSTEM_TABLE_SCHEMA LIKE ?
FOR READ ONLY

b) DSPOBJD
DSPOBJ is a system command that can be used to find libraries or objects.
The form presented below generates output to a specified file (TempLib / OBJD).

Example code extracted from REXX (requires QSYS and TempLib variables, QSYS is predefined in REXX).

Code:

'DSPOBJD OBJ('QSYS'/*ALL) OBJTYPE(*LIB)',
'DETAIL(*FULL) OUTPUT(*OUTFILE)',
'OUTFILE('TempLib || '/OBJD)'

2. How to list files (objects) with a specified name?
a) QShell FIND
QShell is a command processor that allows user to execute Unix-like commands.
QShell commands can be executed directly - using "QSH CMD" command or using QSH command processor.
If you want to execute QShell command using command processor then start it with "QSH" command and then later you can execute commands without "QSH CMD" prefix.

Example below uses "find" command to search for a file with a specified name.

First command (CRTPF) creates an output file.
Second ("RM") is required only if you want to repeat search (by using steps 2 and 3).
Third command ("find") performs the search.

Code:

CRTPF FILE(mylib/testo) RCDLEN(300)
QSH CMD('rm /qsys.lib/mylib.lib/testo.file/*')
QSH CMD('find /qsys.lib/MYLIB.LIB -name *PGL.FILE > /qsys.lib/mylib.lib/testo.file/output.mbr')

b) SQL - QSYS2/SYSTABLES
You can use QSYS2/SYSTABLES also to search for a specific file with a SQL command:

Code:

SELECT SYSTEM_TABLE_NAME FROM QSYS2/SYSTABLES
WHERE SYSTEM_TABLE_SCHEMA LIKE ?
AND SYSTEM_TABLE_NAME LIKE ?
FOR READ ONLY

c) DSPOBJD
The same command as above - DSPOBJD, but here used to search for a file.
Example code extracted from REXX (requires TempLib, WrkF, LibN variables):

Code:

'DSPOBJD OBJ('LibN'/*ALL) OBJTYPE(*ALL)',
'DETAIL(*FULL) OUTPUT(*OUTFILE)',
'OUTFILE('TempLib || '/'WrkF')'

3. How to search for a text on a member level?
a) FNDSTRPDM
The simplest method to search for a specific text on iSeries is to use FNDSTRPDM (used also inside RCMD).
Enter "FNDSTRPDM" and press F4 to list all available parameters for this command.

b) QShell grep
You can use "grep" command on iSeries. Use QShell processor for this.
Example below executes search with parameters:
library: srchlib,
file: qlblsrc,
member name: *,
temp library: mylib,
text: 'DELETE'

Example:

Code:

CRTPF FILE(mylib/testo) RCDLEN(300)
rm /qsys.lib/mylib.lib/testo.file/*
grep 'DELETE' /qsys.lib/srchlib.lib/qlblsrc.file/* >/qsys.lib/mylib.lib/testo.file/a.mbr

c) SQL alias + SELECT
You can use SQL to search through member's contents. In order to do this you need to perform "create alias" command before the search as below:

Code:

CREATE ALIAS MYLIB/MYDATA FOR ASGLIB/QLBLSRC(B27171)
SELECT SRCSEQ, SRCDAT, SRCDTA FROM MYLIB/MYDATA

Note: RCMD requires CPYFTOREXQ command which is presented in IBM's "REXX/400 Programmer's Guide".
It is also included within the attached zip file

Service Log :: TiddlyWiki - essential plugins and projects

Author: PiotrL
Subject: TiddlyWiki - essential plugins and projects
Posted: Thu Aug 23, 2007 10:59 pm (GMT 1)
Topic Replies: 0

Overview
I have completed my list of best plugins for TiddlyWiki.
TiddlyWiki is a tool for making & organizing notes, in a way similar to Wikipedia.
The difference is that the whole TiddlyWiki document library along with software required for such a document is stored in a single HTML file!

All you need to edit such a document is a web browser with JavaScript support enabled.
Applications for TiddlyWiki include:
- GTD tool (Get Things Done) - organizer-like tool
- Blogging
- note library
- wiki document library (encyclopedia-like document)

One TiddlyWiki document consists of several chunks called "tiddlers". Each tiddler can be associated with several tags.
Tags are used to connect tiddlers with each other.

Example TiddlyWiki document can be found at TiddlyWiki Home Page.

Related services
* TiddlyWiki cuctom plugin implementation/modification
* JavaScript script modification
>> get a quote

Comments
Your comments are welcome! Please help us improve the content!
>> leave a comment

About Repository
The plugin repository attached to this article has been completed on 2007/08 and I suppose plugins included in it are already outdated or will be soon. This is a reason I recommend you to search for a newer version of a plugin if it is suitable for you.

The repository is a TiddlyWiki document based on Monkey Pirate TiddlyWiki.
>> download repository

Installing Plugins
To install any of the mentioned below plugins you need to copy a document part called "tiddler" containing the plugin
including all fields: title, tags, body. Some plugins consist of several parts (examples, documentation),
usually you can find all the parts using "*Project" tag.

Note: if you install many plugins, your TiddlyWiki document can become slow during load, so please keep installed plugin list at minimum.

See also: How to install a TiddlyWiki plugin

Modified plugins
Some plugins has been modified by me to handle more options. Here is a list of changes:

DeleteAllTagged (two hours)
- added option to specify tags used to search tiddlers for deletion

tagCloud plugin (one day)
- added option for filtering tags by associated tiddler title
- added option for filtering tags by associated tags within the same tiddler
- added option to display non-tiddler tags in italics
- added mask support for excluded tags

Plugin projects
Some plugins consist of many tiddlers. Such a plugin is associated with a selected common tag named as "*Project".

List of projects:
- FormTiddlerProject - several tiddlers adding support for HTML forms inside TiddlyWiki document
- ReminderProject - plugin for reminder definition and listing (including cyclic reminders)

Recommended plugin list
A list of selected plugins is presented below.

# CalendarPlugin
- adds calendar control - useful for ReminderProject

# DataTiddlerPlugin
- Enhance your tiddlers with structured data (such as strings, booleans, numbers)
that can be easily accessed and modified through named fields (inJavaScript code).

# DeleteAllTagged
- Delete tiddlers associated with a specified tag

# ExportTiddlersPlugin
- export tiddlers from TiddlyWiki document, select them with tags

# ForEachTiddlerPlugin
- Create customizable lists, tables etc. for your selections of tiddlers. Specify the tiddlers to include and their order through a powerful language.

# FormTiddlerPlugin
- See #FormTiddlerProject

# ImportTiddlersPlugin
- import tiddlers from TiddlyWiki document

# LessBackupsPlugin
- You end up with just backup one per year, per month, per weekday, per hour, minute, and second.

# NestedSlidersPlugin
- make some parts of tiddlers invisible on start

# NewFromTemplateMacro
- create tiddlers from predefined tiddlers

# ReminderMacros
- see #ReminderProject

# SearchOptionsPlugin
- Extend core search function with additional user-configurable options

# TiddlerWithParamsPlugin
- adds parameters to <<tiddler...>> so you can include tiddlers in tiddlers with a specified values. Useful for form-like tiddlers (e.g. projects)

# ToggleTagPlugin
- Makes a checkbox which toggles a tag in a tiddler

# YourSearchPlugin
- nice, on-fly, multi-page version of search plugin

# tagCloud plugin
- a tag cloud plugin

Other plugins in the repository
# CheckboxPlugin
- adds checkbox that can be used to associate a tiddler with a selected tag

# CloseOnCancelPlugin
- Closes the tiddler if you click new tiddler then cancel. Default behaviour is to leave it open

# ConfigTweaksPlugin
- specify default option values

# DatePlugin
- Formatted dates plus popup menu with 'journal' link, changes and (optional) reminders

# ExtendTagButtonPlugin
- Adds a New tiddler button in the tag drop down

# HideWhenPlugin
- hide/show parts of templates (for use with ViewTemplate and EditTemplate) basing on tags

# IncludePlugin
- Include TiddlyWiki documents inside other TiddlyWiki documents. Allows to search through included documents.

# MptwLayoutPlugin
- pre-installed plugin for Monkey Pirate TiddlyWiki

# NewHerePlugin
- adds "New here" button creating new tiddler with a tag equal to current tiddler's title

# NewMeansNewPlugin
- if 'New Tiddler' already exists then create 'New Tiddler (1)' and so on

# PartTiddlerPlugin
- split tiddlers into parts that can be referenced

# QuickOpenTagPlugin
- Changes tag links to make it easier to open tags as tiddlers

# RenameTagsPlugin
- Allows you to easily rename or delete tags across multiple tiddlers

# SaveCloseTiddlerPlugin
- Provides two extra toolbar commands, saveCloseTiddler and cancelCloseTiddler

# SelectPalettePlugin
- Lets you easily change colour palette

# TagglyTaggingPlugin
- tagglyTagging macro is a replacement for the builtin tagging macro
(pre-installed with Monkey Pirate TiddlyWiki)

# TiddlerListMacro
- The TiddlerListMacro lists tiddlers with SQL-Like features

# redirect
- redirect user from one tiddler to another

Recommended links
- TiddlyWiki Home Page, http://www.tiddlywiki.com
- TiddlyTools, www.tiddlytools.com/
- abegoExtensions (plugins), http://tiddlywiki.abego-software.de/
- Macrocodex (documentation for developers), http://gimcrackd.com/etc/src/codex/

Service Log :: Taditor - How to open Hebrew text files using windows-1255?

Author: PiotrL
Subject: Taditor - How to open Hebrew text files using windows-1255?
Posted: Sat Feb 17, 2007 3:56 pm (GMT 1)
Topic Replies: 0

Quote:

How to configure Taditor to correctly open Hebrew text files using windows-1255?

In a default setup Taditor detects your windows-1255 documents as EBCDIC (not as popular code page class for PC as 1255),
so what has to be done:

1. Go to:
Settings -> Environment Options -> Text Format -> Advanced ->
-> Disable EBCDIC auto-detection

2. Change option to "on"/"marked" state.

3. Close options window by accepting changes using OK button.

4. Reload/load the document.

If default code page is 1255 then you will a correct view.

You can change default code page using either:
- keyboard layout
- Settings -> Environment Options ->
-> Default Text Properties

Comments
Your comments are welcome! Please help us improve the content!
>> discuss this article

Service Log :: Writing Excel spreadsheets using PHP

Author: PiotrL
Subject: Writing Excel spreadsheets using PHP
Posted: Sat Feb 17, 2007 3:50 pm (GMT 1)
Topic Replies: 0

Overview
Question:

Code:

What is "Spreadsheet/Excel/Writer.php"? How to use it?

It's a PEAR (PHP library) module. The article below presents steps necessary to use it.

Comments
Your comments are welcome! Please help us improve the content!
>> discuss this article

Article
Steps:
1. Install PEAR

On shared web-hosting machine:
http://builder.com.com/5100-6371-5163311.html

On your personal computer:
See: PHP / Apache / Perl integration on Windows w/ PEAR.Walters Way

2. Install apropriate PEAR module "PEAR::Spreadsheet_Excel_Writer":

Code:

pear install OLE
pear install Spreadsheet_Excel_Writer

How to install PEAR packages:
http://www.go-pear.org/manual/en/installation.cli.php

3. How to use this writer module?

http://www.phphacks.com/content/view/26/33/
http://www.sitepoint.com/article/pear-spreadsheet_excel_writer

4. Final notes
You can also try to use XLS in XML format (Office 2003 and above). Just write a spreadsheet template using this format and then parse it as XML template file.

See:
1. XML Parsing using PHP
2. PHP XML Parsing Basics -- A Tutorial
3. Parsing XML using PHP

Tags: PHP PEAR Excel Spreadsheet

Service Log :: IBM Express-C 9.1 tips for Windows XP users

Author: PiotrL
Subject: IBM Express-C 9.1 tips for Windows XP users
Posted: Sat Feb 17, 2007 3:32 pm (GMT 1)
Topic Replies: 0

Here are some tips regarding IBM Express-C DB2 V9.1 database.

What problems can you encounter?

Problem 1

Code:

SQL1032N No start database manager command was issued. SQLSTATE=57019, SQLCODE=-1032

When you will see such an error you probably have to restart you computer - if you want to login as a different user account. This is because the database system does not support XP fast user switching, so when you login-in using one user you cannot switch to other users. According to IBM fix for this issue is planned in 2007.Q1.

More details: Express-C 9.1 under Windows XP with multiple login

Problem 2
It seams you don't have permissions to login-in to database. It is probably because you didn't assigned user to one of the following roles:
DB2ADMINS
DB2USERS

Use Windows control panel to manage user accounts.

Comments
Your comments are welcome! Please help us improve the content!
>> discuss this article

Service Log :: How to open EBCDIC 80-column files in Taditor?

Author: bbadmin
Subject: How to open EBCDIC 80-column files in Taditor?
Posted: Wed Feb 14, 2007 10:04 pm (GMT 1)
Topic Replies: 0

Question

Quote:

What are *all* of the settings that need to be changed to view 80-column "punch card" files in EBCDIC?

Comments
Your comments are welcome! Please help us improve the content!
>> discuss this article

Article
1. First most important option - automatic detection:
Settings -> Environment Options -> Text Format -> Advanced
-> Disable EBCDIC auto-detection

It should be "off"/unchecked for your case.

2. Default view mode for EBCDIC.

By default hex mode is used so you can read files without end-of-line characters.

Settings -> Environment Options -> Text Format
-> EBCDIC: default view mode is hex

It should be "off"/unchecked if you want to edit EBCDIC as text file.

3. Default text format.

After that you should be able to open EBCDIC files using "File |
Advanced | Import" command (if you use files without end-of-line,
otherwise simple "Open" should be enough).

But how to open EBCDIC automatically if I use always 80-column files?

You can prepare a format file (or used the attached one) that will be
used every time your EBCDIC file is about to be open.

Just follow these steps (or skip to 4th step).
a) execute File | Advanced | Import
b) select the file
c) select record length and click "Next"
d) select code page
e) click "Import" (file should be open correctly)
f) execute "File | Save As" and select a temporary name, for example:
"c:\temp\test.jcl"
g) you have just created a format description file
"c:\temp\test.jcl.info".

4. Taditor - default format file setup.

Copy the file to (more on that in Help -> "default format"):
"<Taditor Home Dir>\Config\_def_info_fext_jcl.info"
example:
"C:\Program Files\HLPlanet Taditor\Config\_def_info_fext_jcl.info"

After that anytime you open a file with extension "*.JCL" it will be
opened correctly. You can also copy the file to other names to handle
more file extensions:

_def_info_fext_cbl.info - for "*.CBL"
_def_info_fext_cob.info - for "*.COB"... etc.

Service Log :: How to add "Open with" command for Taditor?

Author: bbadmin
Subject: How to add "Open with" command for Taditor?
Posted: Sat Dec 30, 2006 6:24 pm (GMT 1)
Topic Replies: 0

There was a question from one of Taditor users:

How to add "Open with Taditor" command in Explorer presented as the top-level popup menu command for all file types?

The solution is simple - you can use a special registry file associated with this post - unpack it and execute by double-clicking on "open_taditor.reg" file.

This solution works only if you have installed Taditor in default directory:
"c:\Program Files\HLPlanet Taditor\Taditor.exe"

If you have selected a different directory, you need to edit the REG file and change a path to Taditor stored inside it.

This solution is temporary - probably it will be included with one of next releases.

Regards,
Piotr