Pickwiki - User contributions [en]

Community

2020-07-22T19:11:49Z

TonyG: Removed dead u2ug.org

MV professionals, vendors, and end-users exchange information in [[UserGroups]] and in online forums.

* [http://groups.google.com/group/mvdbms/about MVDBMS forum] Most used community group for all Pick-based platforms
* https://rocket.connectedcommunity.org/forums/allforums (D3, mvBase, mvEnterprise, etc)
* http://groups.google.com/group/jBASE (T24[[/Globus]])
* http://groups.google.com/group/OpenQM (Commercial QM)
* http://groups.google.com/group/openqm-opensource ([[OpenQM]] FLOSS)
* http://groups.google.com/group/reality-database
* http://revelation.com/Revelation.nsf/byTitle/281E3E1A480FB44C85256DC1002427C5?OpenDocument
* <nowiki>LinkedIn</nowiki> groups:
** http://www.linkedin.com/groups/Pick-Users-Group-64935
** http://www.linkedin.com/groups/Multivalue-Database-1876518 (not as much traffic)
* [http://sbxa.wikia.com SB[[/XA]] Wiki]
* [http://u2-world.com U2-World.com]
* [[Cache|Caché]] forum http://groups.google.com/group/InterSystems-MV

Product- and vendor-specific forums have also been formed:
* http://groups.google.com/group/mvnet
* http://groups.google.com/group/DesignBais-Forum
* http://groups.google.com/group/BRIZ
* http://www.precisonline.com/forum
* http://www.t24all.com/forum/ jBase / T24 / Temenos
* http://forum.asent.com/ ([[AccuTerm]])

Facebook communities are not listed here yet. Send Facebook references to [[TonyG]].

Twitter links have been added here. People and companies "tweet" frequently on Pick-related matters and this has become a "community" of it's own. Send @ references to [[TonyG]]. To broadcast a message to anyone interested in MV[[/Pick]], the #multivalue hash tag is commonly used.

Some Twitter users:
* <nowiki>@CdMPick</nowiki>
* <nowiki>@clifoliver</nowiki>
* <nowiki>@dickthiot</nowiki>
* <nowiki>@dwolt</nowiki>
* <nowiki>@ElkieHolland</nowiki>
* <nowiki>@fusionwareInt</nowiki>
* <nowiki>@GlennSallis</nowiki>
* <nowiki>@houbenator</nowiki>
* <nowiki>@IntlSpectrum</nowiki>
* <nowiki>@ISCRTaylor</nowiki>
* <nowiki>@jonsisk</nowiki>
* <nowiki>@KevinPowick</nowiki>
* <nowiki>@madhump</nowiki>
* <nowiki>@markbschramm</nowiki>
* <nowiki>@mikepluta</nowiki>
* <nowiki>@moecaneda</nowiki>
* <nowiki>@mvcmap</nowiki>
* <nowiki>@mvdbman</nowiki>
* <nowiki>@MyPickCloud</nowiki>
* <nowiki>@pickcoder</nowiki>
* <nowiki>@pickProgrammers</nowiki>
* <nowiki>@PickteamTweets</nowiki>
* <nowiki>@PRC_SJPlus</nowiki>
* <nowiki>@RevSoftUS</nowiki>
* <nowiki>@RocketU2</nowiki>
* <nowiki>@rossferris</nowiki>
* <nowiki>@salesbluefinity</nowiki>
* <nowiki>@SAPUGtweets</nowiki>
* <nowiki>@SimonVerona</nowiki>
* <nowiki>@Spellinator</nowiki>
* <nowiki>@symeonb</nowiki>
* <nowiki>@TAivazian</nowiki>
* <nowiki>@TheMpower1Group</nowiki>
* <nowiki>@TigerLogicPick</nowiki>
* <nowiki>@TonyGravagno</nowiki>
* <nowiki>@TSCMVS</nowiki>
* <nowiki>@Paradigm_system</nowiki>

Some forums break discussions between technical and social. Some are moderated, others are not. Each forum has a unique personality of its own. Some are more adverse to advertising then others.

The community also includes some [[Blogs]].

If you are searching the community for work, or someone to do development, see the [[Employment]] page.

----

[[Tags]]: job jobs help wanted employment work contractors consultants services forums discussions google usergroups user groups

(Above [[tags]] added by TG in response to CDP thread about searchability of this site. These tags should help people to find this page using the Search box if they're looking for help or work. See Tags page for details.)

Community

2020-07-22T19:10:33Z

TonyG: Fix Accuterm forum

MV professionals, vendors, and end-users exchange information in [[UserGroups]] and in online forums.

* [http://groups.google.com/group/mvdbms/about MVDBMS forum] Most used community group for all Pick-based platforms
* Website and Email forums on the U2 Users Group site: http://u2ug.org
* [[Cache|Caché]] forum http://groups.google.com/group/InterSystems-MV
* https://rocket.connectedcommunity.org/forums/allforums (D3, mvBase, mvEnterprise, etc)
* http://groups.google.com/group/jBASE (T24[[/Globus]])
* http://groups.google.com/group/OpenQM (Commercial QM)
* http://groups.google.com/group/openqm-opensource ([[OpenQM]] FLOSS)
* http://groups.google.com/group/reality-database
* http://revelation.com/Revelation.nsf/byTitle/281E3E1A480FB44C85256DC1002427C5?OpenDocument
* <nowiki>LinkedIn</nowiki> groups:
** http://www.linkedin.com/groups/Pick-Users-Group-64935
** http://www.linkedin.com/groups/Multivalue-Database-1876518 (not as much traffic)
* [http://sbxa.wikia.com SB[[/XA]] Wiki]
* [http://u2-world.com U2-World.com]

Product- and vendor-specific forums have also been formed:
* http://groups.google.com/group/mvnet
* http://groups.google.com/group/DesignBais-Forum
* http://groups.google.com/group/BRIZ
* http://www.precisonline.com/forum
* http://www.t24all.com/forum/ jBase / T24 / Temenos
* http://forum.asent.com/ ([[AccuTerm]])

Facebook communities are not listed here yet. Send Facebook references to [[TonyG]].

Twitter links have been added here. People and companies "tweet" frequently on Pick-related matters and this has become a "community" of it's own. Send @ references to [[TonyG]]. To broadcast a message to anyone interested in MV[[/Pick]], the #multivalue hash tag is commonly used.

Some Twitter users:
* <nowiki>@CdMPick</nowiki>
* <nowiki>@clifoliver</nowiki>
* <nowiki>@dickthiot</nowiki>
* <nowiki>@dwolt</nowiki>
* <nowiki>@ElkieHolland</nowiki>
* <nowiki>@fusionwareInt</nowiki>
* <nowiki>@GlennSallis</nowiki>
* <nowiki>@houbenator</nowiki>
* <nowiki>@IntlSpectrum</nowiki>
* <nowiki>@ISCRTaylor</nowiki>
* <nowiki>@jonsisk</nowiki>
* <nowiki>@KevinPowick</nowiki>
* <nowiki>@madhump</nowiki>
* <nowiki>@markbschramm</nowiki>
* <nowiki>@mikepluta</nowiki>
* <nowiki>@moecaneda</nowiki>
* <nowiki>@mvcmap</nowiki>
* <nowiki>@mvdbman</nowiki>
* <nowiki>@MyPickCloud</nowiki>
* <nowiki>@pickcoder</nowiki>
* <nowiki>@pickProgrammers</nowiki>
* <nowiki>@PickteamTweets</nowiki>
* <nowiki>@PRC_SJPlus</nowiki>
* <nowiki>@RevSoftUS</nowiki>
* <nowiki>@RocketU2</nowiki>
* <nowiki>@rossferris</nowiki>
* <nowiki>@salesbluefinity</nowiki>
* <nowiki>@SAPUGtweets</nowiki>
* <nowiki>@SimonVerona</nowiki>
* <nowiki>@Spellinator</nowiki>
* <nowiki>@symeonb</nowiki>
* <nowiki>@TAivazian</nowiki>
* <nowiki>@TheMpower1Group</nowiki>
* <nowiki>@TigerLogicPick</nowiki>
* <nowiki>@TonyGravagno</nowiki>
* <nowiki>@TSCMVS</nowiki>
* <nowiki>@Paradigm_system</nowiki>

Some forums break discussions between technical and social. Some are moderated, others are not. Each forum has a unique personality of its own. Some are more adverse to advertising then others.

The community also includes some [[Blogs]].

If you are searching the community for work, or someone to do development, see the [[Employment]] page.

----

[[Tags]]: job jobs help wanted employment work contractors consultants services forums discussions google usergroups user groups

(Above [[tags]] added by TG in response to CDP thread about searchability of this site. These tags should help people to find this page using the Search box if they're looking for help or work. See Tags page for details.)

Community

2020-07-22T19:08:11Z

TonyG: Removed/corrected old entries

MV professionals, vendors, and end-users exchange information in [[UserGroups]] and in online forums.

* [http://groups.google.com/group/mvdbms/about MVDBMS forum] Most used community group for all Pick-based platforms
* Website and Email forums on the U2 Users Group site: http://u2ug.org
* [[Cache|Caché]] forum http://groups.google.com/group/InterSystems-MV
* https://rocket.connectedcommunity.org/forums/allforums (D3, mvBase, mvEnterprise, etc)
* http://groups.google.com/group/jBASE (T24[[/Globus]])
* http://groups.google.com/group/OpenQM (Commercial QM)
* http://groups.google.com/group/openqm-opensource ([[OpenQM]] FLOSS)
* http://groups.google.com/group/reality-database
* http://revelation.com/Revelation.nsf/byTitle/281E3E1A480FB44C85256DC1002427C5?OpenDocument
* <nowiki>LinkedIn</nowiki> groups:
** http://www.linkedin.com/groups/Pick-Users-Group-64935
** http://www.linkedin.com/groups/Multivalue-Database-1876518 (not as much traffic)
* [http://sbxa.wikia.com SB[[/XA]] Wiki]
* [http://u2-world.com U2-World.com]

Product- and vendor-specific forums have also been formed:
* http://groups.google.com/group/mvnet
* http://groups.google.com/group/DesignBais-Forum
* http://groups.google.com/group/BRIZ
* http://www.precisonline.com/forum
* http://www.t24all.com/forum/ jBase / T24 / Temenos
* http://www.asent.com/forum/ ([[AccuTerm]])

Facebook communities are not listed here yet. Send Facebook references to [[TonyG]].

Twitter links have been added here. People and companies "tweet" frequently on Pick-related matters and this has become a "community" of it's own. Send @ references to [[TonyG]]. To broadcast a message to anyone interested in MV[[/Pick]], the #multivalue hash tag is commonly used.

Some Twitter users:
* <nowiki>@CdMPick</nowiki>
* <nowiki>@clifoliver</nowiki>
* <nowiki>@dickthiot</nowiki>
* <nowiki>@dwolt</nowiki>
* <nowiki>@ElkieHolland</nowiki>
* <nowiki>@fusionwareInt</nowiki>
* <nowiki>@GlennSallis</nowiki>
* <nowiki>@houbenator</nowiki>
* <nowiki>@IntlSpectrum</nowiki>
* <nowiki>@ISCRTaylor</nowiki>
* <nowiki>@jonsisk</nowiki>
* <nowiki>@KevinPowick</nowiki>
* <nowiki>@madhump</nowiki>
* <nowiki>@markbschramm</nowiki>
* <nowiki>@mikepluta</nowiki>
* <nowiki>@moecaneda</nowiki>
* <nowiki>@mvcmap</nowiki>
* <nowiki>@mvdbman</nowiki>
* <nowiki>@MyPickCloud</nowiki>
* <nowiki>@pickcoder</nowiki>
* <nowiki>@pickProgrammers</nowiki>
* <nowiki>@PickteamTweets</nowiki>
* <nowiki>@PRC_SJPlus</nowiki>
* <nowiki>@RevSoftUS</nowiki>
* <nowiki>@RocketU2</nowiki>
* <nowiki>@rossferris</nowiki>
* <nowiki>@salesbluefinity</nowiki>
* <nowiki>@SAPUGtweets</nowiki>
* <nowiki>@SimonVerona</nowiki>
* <nowiki>@Spellinator</nowiki>
* <nowiki>@symeonb</nowiki>
* <nowiki>@TAivazian</nowiki>
* <nowiki>@TheMpower1Group</nowiki>
* <nowiki>@TigerLogicPick</nowiki>
* <nowiki>@TonyGravagno</nowiki>
* <nowiki>@TSCMVS</nowiki>
* <nowiki>@Paradigm_system</nowiki>

Some forums break discussions between technical and social. Some are moderated, others are not. Each forum has a unique personality of its own. Some are more adverse to advertising then others.

The community also includes some [[Blogs]].

If you are searching the community for work, or someone to do development, see the [[Employment]] page.

----

[[Tags]]: job jobs help wanted employment work contractors consultants services forums discussions google usergroups user groups

(Above [[tags]] added by TG in response to CDP thread about searchability of this site. These tags should help people to find this page using the Search box if they're looking for help or work. See Tags page for details.)

Talk:MultiValueConsultants

2015-05-28T22:22:41Z

TonyG: Created page with "Asked author of recent changes to fix newly introduced anomalies. ~~~~"

Asked author of recent changes to fix newly introduced anomalies. [[User:TonyG|Tony Gravagno]] ([[User talk:TonyG|talk]]) 15:22, 28 May 2015 (PDT)

User talk:TonyG

2015-05-17T22:53:11Z

TonyG:

Have a comment for me? Leave it here. I'll get an email whenever this page is modified. Feel free to suggest action on some part of this site. Or if you just need to contact me, post a message here and I'll get an email. Please remember that all content on this site is readily available for public viewing, so please do not post any private/sensitive notes.

User talk:TonyG

2015-05-17T22:47:09Z

TonyG: Created page with "Have a comment for me? Leave it here..."

Have a comment for me? Leave it here...

User:TonyG

2015-05-17T22:44:55Z

TonyG:

Tony Gravagno owns Nebula Research and Development which provides MV-related products, consultation, and development services. Tony is very visible in the community and helps to manage PickWiki, the MVDBMS Google Group, and the LinkedIn Pick Users Group.

30+ years in Pick/MV, focusing on communications and advanced integration with the DBMS.

Services offered: GUI, mobile, telephony (phone menus, inbound/outbound calls, SMS, email, elegant reporting, application integration, DBMS exchanges, web services, EDI.

Primary tools: .NET (C#, ASP.NET, etc), Java, PHP

Development tools include: mv.NET, DesignBais, Telerik controls, Xamarin (Android, iOS, WinPhone mobile)

Any MV platform including: D3, U2, QM, mvBase, jBase

Common links for contact and more information:
* Email: TG @ and then use the Nebula-RnD domain with .com at the end
* http://Nebula-RnD.com/blog
* http://Twitter.com/TonyGravagno
* http://LinkedIn.com/in/TonyGravagno
* http://groups.google.com/group/mvdbms
* http://LinkedIn.com/groups/Pick-Users-Group-64935
* https://bitbucket.org/FOSS4MV
* mvTalk: See http://OConv.com/mvTalk/

<hr>
Last Updated: [[User:TonyG|Tony Gravagno]] ([[User talk:TonyG|talk]]) 15:44, 17 May 2015 (PDT)

User:TonyG

2015-05-17T22:42:48Z

TonyG: New page

Tony Gravagno owns Nebula Research and Development which provides MV-related products, consultation, and development services. Tony is very visible in the community and helps to manage PickWiki, the MVDBMS Google Group, and the LinkedIn Pick Users Group.

30+ years in Pick/MV, focusing on communications and advanced integration with the DBMS.

Services offered: GUI, mobile, telephony (phone menus, inbound/outbound calls, SMS, email, elegant reporting, application integration, DBMS exchanges, web services, EDI.

Primary tools: .NET (C#, ASP.NET, etc), Java, PHP

Development tools include: mv.NET, DesignBais, Telerik controls, Xamarin (Android, iOS, WinPhone mobile)

Any MV platform including: D3, U2, QM, mvBase, jBase

Common links for contact and more information:
* Email: TG @ and then use the Nebula-RnD domain with .com at the end
* http://Nebula-RnD.com/blog
* http://Twitter.com/TonyGravagno
* http://LinkedIn.com/in/TonyGravagno
* http://groups.google.com/group/mvdbms
* http://LinkedIn.com/groups/Pick-Users-Group-64935
* https://bitbucket.org/FOSS4MV
* mvTalk: See http://OConv.com/mvTalk/

<hr>
Last Updated: [[User:TonyG|Nebula R and D]] ([[User talk:TonyG|talk]]) 15:42, 17 May 2015 (PDT)

SandBox

2015-05-17T21:53:27Z

TonyG:

The [[SandBox]] is a page where you can type out wiki syntax to see the results. For syntax details see: [http://www.usemod.com/cgi-bin/wiki.pl?TextFormattingRules Text Formatting Rules]
----
Internal anchor link: [[#myanchor|I don't like spam!]]

Spam spam spam spam, spam spam, spam. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
spammity spam! 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
Spam spam spam spam, spam spam, spam. 

<div id="myanchor">== I DON'T LIKE SPAM! ==</div>

Ohh, I luv it!!

[[NotepadPlusPlus|notepad++]]

Fixed the internal anchor for anyone interested [[User:TonyG|Nebula R and D]] ([[User talk:TonyG|talk]]) 14:53, 17 May 2015 (PDT)

Accessing U2 From PHP

2015-05-15T22:29:42Z

TonyG:

[[HowTos]] >> [[CreateWebInterfaces]] >> Accessing U2 from PHP

See also [[AccessFromPhp]] which includes other cross-platform ways to use PHP with MV. The techniques on this U2-specific page, and much of the code, can be used anywhere, and the code on the other page can augment solutions found here.

2008-01-14 from the u2ug users mailing list

== Rocket Articles on U2 and PHP ==
(from David Wolverton)

Look at this page for several articles on PHP and U2:

* https://u2devzone.rocketsoftware.com/

== PHP Web Services Strategy ==
(from Brian Leach)

PHP has good support for Web Services, so you could surface some UDT functionality that way. There was also an article on <nowiki>DeveloperWorks</nowiki> on
creating a custom PHP module that exposed some of the [[InterCall]] library, though it was a long way from a complete solution.

I also dimly remember someone writing an article on using a Java bridge to expose either RedBack objects or UOJ to PHP.

Some time ago I asked IBM whether they would be willing to publish the UniObjects protocol so that third parties could write clients for those environments it doesn't support, like PHP - but that wasn't too well received and I didn't follow up on it. Instead, I wrote a web services library (before IBM released theirs) and tested that through with PHP's SOAP support.

== Using the PHP COM library ==
(from Tony Gravagno)

With PHP5 you can just use the PHP COM library to access UO or UO.NET from PHP directly. It should be a LOT easier with PHP5 than PHP4. Here's an example that I've created after a brief reference to the UO doc (haven't tried to execute):

<pre>
<?php
$UOSession = new COM("UniObjects.Unioiafctrl")
or die("Cant instantiate UO");
$UOSession->HostName = "yourhost";
$UOSession->AccountPath = "d:\path\acct";
$UOSession->DatabaseType = 1; // UV here
$UOSession->UserName = ""; // *nix only?
$UOSession->Password = ""; // *nix only?
$UOSession->Connect; // need to check result
if ($UOSession->IsActive) {
$UOSession->Command->Text = "COUNT VOC"; // whatever
$UOSession->Command->Exec;
$U2Error = $UOSession->Command->Error;
$U2Status = $UOSession->Command->CommandStatus;
echo "Result is {$UOSession->Command->Response}";
// may need to loop on $UOSession->Command->NextBlock
}
$UOSession->Disconnect;
$UOSession = null;
?>
</pre>

This can do the same with UO.NET, mv.NET, and I'm guessing you can create an ADODB.Connection with a DSN and make SQL queries as well - all of this only over Windows. I believe FusionWare would have a similar Java-based solution for instantiating an object in PHP and accessing U2 entirely with <nowiki>*nix</nowiki>.

----
(from Steve Morley)

I converted our Admin system to work from the web via PHP5.

Install UNIDK on the webserver and put the following code inside a PHP page. This will initiate the connection to the Unidata server and allow you to talk via UniObjects.

<pre>
<?php
$Hostname = "192.168.0.1";
$Username = "admin";
$Password = "password";
$Accountpath = "c:\ibm\mydemoaccount";
$UdSession = new COM("UniObjects.unioaifctrl");
$UdSession->HostName = $Hostname;
$UdSession->AccountPath = $Accountpath;
$UdSession->UserName = $Username;
$UdSession->Password = $Password;
$UdSession->Connect();
?>
</pre>

----
(from Brian Leach)

COM is windows-specific (which is why I didn't think to suggest it for PHP.) If you want to use UniObjects on Linux you'll need to use UOJ (Java version).

== u2pipe ==
(from Rex Gozar)
http://www.autopower.com/rgozar/pixel.gif

I wrote [[u2pipe]] because I wanted (1) a single set of API subroutines on the U2 backend to handle all the business logic, and (2) to be able to port the API to different GUI clients (currently <nowiki>ColdFusion</nowiki> and PHP).

For our web application here, I created "web service subroutines" on the U2 backend, and wrote a PHP library of matching functions for the frontend to access them.

== Javascript and UniObjects ==
(Rick Brown)

We wrote <nowiki>JavaScript</nowiki> that basically uses <nowiki>UniObjects</nowiki> to connect to Unidata and run a subroutine. We pass data back to the PHP program in XML format. The <nowiki>JavaScript</nowiki> is just used as the connector, one input and one output. We have a few different <nowiki>UniBasic</nowiki> subroutines that can be called, one even allows the PHP developer to send a series of sentences in ECL format and receive the results in XML. The <nowiki>JavaScript</nowiki> is maybe 18 lines, and we run it on Tomcat.

This works well for getting smaller data sets to the Web, not so great for hundreds of records. Our PHP developer simply takes the returned XML and throws it into an array. With the same basic <nowiki>JavaScript</nowiki> we can pass the name of a subroutine to call, and provide input variables from PHP (Or pretty much any language with HTTP access)

Using HTTP as our transport for the XML is kind of a kludge, but has opened a lot of information to our web developers.

== Using U2 Web Development Environment ([[RedBack]]) ==

I wrote an object which allows full access to all the functionality in [[U2WDE]] from within PHP. This is a pure PHP script which requires no additional extensions to use. See https://github.com/gheydon/redback for the download and examples on how to use.

== Getting PHP / Java / Universe (Unidata) to Work Together ==

[[PhpJavaIntegration]]: as PHP does not as of this date support the Universe database, this is one approach to get data into your PHP application.

Talk:RunAProgram

2015-05-15T22:05:59Z

TonyG: Created page with "[TG] There are three topics: 1) Running a program on the client from the server 2) Running a program on the server from a remote client 3) Running a program on the..."

[TG] There are three topics: 
1) Running a program on the client from the server 
2) Running a program on the server from a remote client 
3) Running a program on the server from the MV environment 
Anyone think it's worthwhile to separate these into different pages?

RunAProgram

2015-05-15T22:05:12Z

TonyG:

HomePage>>HowTos>>[[RunAProgram]]

The problem: you want a program to run on a windows PC as a result of something that happens on your Windows or Unix-based server.
It's usually less of an issue to have a Unix server run something on a Unix client, or Windows server to Windows client - there's plenty of built in ways for that to work. So we'll just consider a Windows PC with a network connection (LAN,WAN or VPN) to a Unix server.

For this to work "something", some program, has to be running on the PC.

==== 0) [[TerminalEmulators]] ====

The most common "something" is a terminal emulator and they pretty much all allow you to send an escape sequence and fire off a program. If you want the program to run in response to something the user did on the server, this is the most straightforward way to do it. Also, if you have a serial connection, this is probably the only option.

* wIntegrate:
<PRE>
Use the WIN.PCRUN command installed on the server, CALL WIN.PCRUN(COMMAND,ARGS)
</PRE>

* [[AccuTerm]]:
To execute a command and return to PICK/BASIC immediately:
<PRE>
PRINT CHAR(27):CHAR(2):"<":command:CHAR(13)
</PRE>
To execute a command and wait for the command to terminate before returning to PICK/BASIC:
<PRE>
PRINT CHAR(27):CHAR(2):">":command:CHAR(13)
</PRE>

See <nowiki>AccuTerm</nowiki> help for details: From the Help Introduction, see <nowiki>AccuTerm</nowiki> Programming. Also see Help on Object Bridge.

More examples are at [[AccuTermFileTransfer]].

* [[ViaDuct]]:
<PRE>
?
</PRE>

* Powerterm:
<PRE>
PRINT CHAR(27):"$tS":COMMAND:CHAR(27):"\"
</PRE>

* Netterm:
Start/run the program specified by COMMAND.
<PRE>
CRT CHAR(27):"[]":COMMAND:CHAR(27):"[1*
</PRE>
Send the URL to the client's WWW browser for processing.
<PRE>
CRT CHAR(27):'[]':URL:CHAR(27):'[0*'
</PRE>
Start/run the program specified by COMMAND and wait till it terminates. COMMAND can contain both the program to run and command line arguments.
<PRE>
CRT CHAR(27):"[]":COMMAND:CHAR(27):"[9*"
</PRE>
Start the program associated with the extension contained within FILENAME.
<PRE>
CRT CHAR(27):"[]":FILENAME:CHAR(27):"[12*
</PRE>

==== 1) Doit ====

Doit is a small utility program that installs a tray applet on the client. The server sends it the path of a file to open.

http://www.chiark.greenend.org.uk/~sgtatham/doit/

==== 2) Install rcmd ====

Either from the windows resource kit, or purchase it from mks. You can then issue an rcmd from the unix side.

http://www.dynawell.com/support/ResKit/winnt.asp

http://www.mkssoftware.com/support/kb/faqs.asp?product=Toolkit&type=tech#art140

==== 3) Install or turn on a telnet server ====

W2K/XP come with a telnet server, or you can purchase one. Then use http://expect.nist.gov to script the login/command process.

http://www.goodtechsys.com/

==== 4) Install an SSH server ====

Just like Telnet, only secure!

http://tech.erdelynet.com/cygwin-sshd.html

==== 5a) Write a small server program ====

Have the program listen on a predefined port. There are obvious security issues here, but with a little handwaving we can move past them :-)

Recent U2 products can create socket connections from basic and connect to the server. Sample code for this is at [[BasicSocketClient]].

Here's a stripped down example of a server in [http://www.python.org Python]:

urlserver.py
<PRE>
import SocketServer
import os

class UrlHandler(SocketServer.StreamRequestHandler):
def handle(self):
url=self.rfile.readline(512)
print "opening "+url
os.system("start "+url)

server=SocketServer.TCPServer( ('', 79), UrlHandler)
server.serve_forever()
</PRE>

On the pc, type "python urlserver.py" to start the server up, then from another machine, "telnet pc-address 79" and then type the url to go to - the client will open up a browser and go to that address.

==== 5b) ...and here's another in VBScript ====

urlserver.vbs
<PRE>
Option Explicit

' Heavily cribbed from the amazing 4K webserver at:
' http://www.interclasse.com/scripts/4KWebServer.php

Dim oSck
On Error Resume Next
Err.Number=0
Set oSck=WScript.CreateObject("MSWinsock.Winsock","s_")
Select Case Err.Number
Case 0
case &H80040112
echo "No licence found. Install Visual Studio"
case &H80020009
echo "ActiveX Winsock not in the registry, check if installed or use regsvr32"
Case else
echo "Error " & Err.Number & " - &H" & Hex(Err.Number) & " - " & Err.Description
End Select
On Error Goto 0

oSck.LocalPort=79
oSck.Listen
echo "Listening on port " & oSck.LocalPort
Do
' Sleep for 2 seconds
WScript.sleep 2000
Loop

Sub echo(S)
WScript.Echo Now & " " & S
End Sub

Sub s_ConnectionRequest(Byval requestID)
oSck.Close
echo oSck.RemoteHostIP & " - Connection request:" & requestID
oSck.Accept requestID
End Sub

Sub s_Close
oSck.Close
echo "closed - re-listening"
oSck.Listen
End Sub

Sub s_[[SendComplete]]
oSck.close
oSck.Listen
End Sub

Sub s_Error(ByVal N, D, ByVal C, ByVal S, ByVal F, ByVal H, Y)
echo "Error" & N & " - " & D
oSck.Close
oSck.Listen
End Sub

Sub s_DataArrival(Byval b)
Dim S,sh

S=""
oSck.GetData S
S=left(S,len(S)-2)
S=left(S,512)
echo S

set sh = createobject("wscript.shell")
on error resume next
sh.run "cmd /c start " & S
on error goto 0

oSck.Close
oSck.Listen
End Sub
</PRE>

On the PC, type "cscript urlserver.vbs" to start the server up, then from another machine, "telnet pc-address 79" and then type the url to go to - the client will open up a browser and go to that address.

==== 6) Have a polling program on the client ====

If the client and the server share access to a directory (via samba or NFS for example), the server can drop a file in the common directory and a program running on the client can watch for new files. When one is found it can read the file and perform some action based on the contents. Here's a VB example:

<PRE>
Private Sub Form_Load()
txtScheduleNum.Enabled = False
cboCategory.Enabled = False
cmdOK.Enabled = False
cmdPreview.Enabled = False
Label1.Enabled = False
Label3.Enabled = False

Me.Show
' Start the poll right away
Timer1_Timer
End Sub

Private Sub [[Timer1_Timer]]()
TxtLog.ForeColor = vbBlack
LogMsg "Checking c:\batch"
Set fso = CreateObject("Scripting.FileSystemObject")
Set dir = fso.GetFolder("C:\BATCH")

For Each file In dir.Files
If LCase(Right(file.Name, 3)) = "pdf" Then
Timer1.Enabled = False
TxtLog.Enabled = False
fstr = file.Name
hpsname = Left(fstr, Len(fstr) - 3) & "hps"
justname = Left(fstr, Len(fstr) - 3)
LogMsg fstr
Label1.Enabled = True
Label3.Enabled = True
cboCategory.Enabled = True
cmdOK.Enabled = True
cmdPreview.Enabled = True
' Enable some controls and do something with the file
txtScheduleNum.SetFocus
Exit For
End If
Next
End Sub
</PRE>

==== 7) Consider using a solution created specifically to solve the problem ====
(Ad)
The following link goes to the Nebula R&D forum where an offering is discussed and a link is provided to a blog entry for more information. As of the time of this writing the software is fully usable but is not being offered as a product simply for lack of demand. That situation can change with a compelling business case. http://nebula-rnd.com/forum/index.php/topic,51.0.html
(/Ad)

A general description of this approach, not specific to the Nebula solution, would be to write a PC program in your favourite language (.Net, Java, Flex for example), that runs on the PC and makes periodic calls to a Pick program using whatever technology makes sense for your Pick variety. In the U2 world, this would be [[UniObjects]], though a web services call that hides the connection details from the client, and be much more likely to work through firewalls, would make more sense.

Note: this is not exactly the problem we are trying to solve on this page. The problem is "how do I run a program on the client side, on demand from a Pick program?" The polling solutions presented suffer from a lag between something happening on the server and a program running on the client.

==== Running a program on the server from outside ====
Connectivity to MV is discussed many places in this wiki and any language can be used to execute BASIC business rules and return a result. A unique freeware program called [http://nebula-rnd.com/freeware/ MV Exec] uses [[Mv.NET|mv.NET]] to run any query, any command, any program on a MV server from any PC.

TODO: Expand on this topic with info about D3 compile to executable with G option, UDT, notes about unique jBASE exe/dll design...

Row2Col

2015-05-15T21:44:31Z

TonyG:

HomePage>>SourceCode>>BasicSource>>[[Row2Col]]

This utility can transpose a dynamic array item's fields into values, and vice versa. I originally wrote it for [[AccuTerm]] GUI programming, where I needed to load records into grid controls. Calling the utility a second time on the same variable will transpose it back to its original "shape"; in order to do this accurately, all fields must contain the same number of values. It's pretty fast on large records too, since it only passes through the original item a few times (instead of extracting and replacing hundreds of fields and values.)

<pre>
For example:

0001: apple}banana}cantalope 0001: apple}111}red}0
0002: 111}222}333 becomes 0002: banana}222}green}1
0003: red}green}blue 0003: cantalope}333}blue}0
0004: 0}1}0

i.e. 4 fields with 3 values each becomes 3 fields with 4 values each.
</pre>

2008-01-18 by [[Rex Gozar]] A discussion on [[Community|comp.databases.pick]] suggested some techniques to make this program faster. The new 1.2 revision takes advantage of [[UniVerse]]'s internal optimizations to make it 6x faster.

The first optimization was to take advantage of Universe's ability to quickly traverse from field to field within a string. (Note that traversing values is NOT optimized in Universe.) DCOUNT'ing the fields to check the value counts cut a significant amount of time off the processing.

The second optimization uses Universe's REMOVE function to load the values into a dimensioned array. This function traverses both fields and values quickly, and also cut processing time.

The discussion (and benchmarks) leads me to conclude that for small data sets (under 100KB and under 1000 values), simpler home-grown solutions are usually adequate. [[ROW2COL]] now has good performance for smaller data sets, and also scales well to large data sets (over 500KB and over 10,000 values).

My benchmark results in milliseconds:
 70KB variable with 1,000 fields or values: 22ms (new) vs. 140ms (old)
 704KB variable with 10,000 fields or values: 225ms (new) vs. 1428ms (old)

<pre>
SUBROUTINE [[ROW2COL]](ITEM)
******
* [[ROW2COL]] $Revision: 1.2 $
* Transpose table data "rows" (fields) to "columns" (values).
* Copyright (C) 2004 Rex Gozar
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
* http://www.gnu.org/licenses/lgpl.html
*
* Rex Gozar
* rkgozar@juno.com
******
$OPTIONS DEFAULT
***
* Find the maximum number of fields and the maximum
* number of values per field. Note that all fields
* must have the same number of values; otherwise,
* additional delimiters would need to be added as
* placeholders and the resulting item could not be
* "flipped" back into its original form.
***
ITEMLEN = LEN(ITEM)
FMAX = DCOUNT(ITEM, @FM)
VMAX = DCOUNT(ITEM<1>, @VM)
FOR FMC = 2 TO FMAX
VMC = DCOUNT(ITEM<FMC>, @VM)
IF VMC NE VMAX THEN
ABORTM "FIELDS DO NOT HAVE THE SAME VALUE COUNT"
END
NEXT FMC
***
* Extract the elements and load them into an array.
* This should be faster than <> extraction on large items.
***
DIM ARRAY(FMAX,VMAX)
ITEM = ITEM
TEXT = ''
FMC = 1
VMC = 1
LOOP
TEXT := REMOVE(ITEM, MORE)
DELIM = (IF MORE THEN CHAR(256-MORE) ELSE '')
BEGIN CASE
CASE DELIM EQ @VM
ARRAY(FMC,VMC) = TEXT
VMC += 1
TEXT = ''
CASE DELIM EQ @FM OR DELIM EQ ''
ARRAY(FMC,VMC) = TEXT
FMC += 1
VMC = 1
TEXT = ''
CASE @TRUE
TEXT := DELIM
END CASE
WHILE MORE REPEAT
***
* Build the new item so values are fields and fields
* are values.
***
BUFFER = SPACE(ITEMLEN)
BUFPOS = 1
EQU APPEND$TEXT LIT "BUFFER[BUFPOS,LEN(TEXT)] = TEXT ; BUFPOS += LEN(TEXT)"
FOR VMC = 1 TO VMAX
IF VMC # 1 THEN
TEXT = @FM
APPEND$TEXT
END
FOR FMC = 1 TO FMAX
IF FMC # 1 THEN
TEXT = @VM
APPEND$TEXT
END
TEXT = ARRAY(FMC,VMC)
APPEND$TEXT
NEXT FMC
NEXT VMC
***
* Done.
***
ITEM = BUFFER
RETURN
END
</pre>

The older 1.1 revision for comparison. I don't think it contains any Universe-specific functions or statements.
<pre>
SUBROUTINE [[ROW2COL]](ITEM)
******
* [[ROW2COL]] $Revision: 1.1 $
* Transpose table data "rows" (fields) to "columns" (values).
* Copyright (C) 2004 Rex Gozar
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
* http://www.gnu.org/licenses/lgpl.html
*
* Rex Gozar
* rkgozar@juno.com
******
$OPTIONS DEFAULT
***
* Find the maximum number of fields and the maximum
* number of values per field. Note that all fields
* must have the same number of values; otherwise,
* additional delimiters would need to be added as
* placeholders and the resulting item could not be
* "flipped" back into its original form.
***
ITEMLEN = LEN(ITEM)
FMC = 1
VMC = 1
VMAX = 0
J = 0
LOOP
J += 1
C = ITEM[J,1]
BEGIN CASE
CASE C = @VM
VMC += 1
CASE C = @FM OR C = ''
IF FMC = 1 THEN
VMAX = VMC
END ELSE
IF VMC # VMAX THEN
ABORTM "FIELDS DO NOT HAVE THE SAME VALUE COUNT"
END
END
IF C = @FM THEN
FMC += 1
END
VMC = 1
END CASE
WHILE C # '' REPEAT
FMAX = FMC
***
* Extract the elements and load them into an array.
* This should be faster than <> extraction on large items.
***
DIM ARRAY(FMAX,VMAX)
MAT ARRAY = ''
FMC = 1
VMC = 1
TEXTPOS = 1
TEXTLEN = 0
J = 0
LOOP
J += 1
C = ITEM[J,1]
BEGIN CASE
CASE C = @VM
ARRAY(FMC,VMC) = ITEM[TEXTPOS,TEXTLEN]
TEXTPOS = J + 1
TEXTLEN = 0
VMC += 1
CASE C = @FM OR C = ''
ARRAY(FMC,VMC) = ITEM[TEXTPOS,TEXTLEN]
TEXTPOS = J + 1
TEXTLEN = 0
FMC += 1
VMC = 1
CASE 1
TEXTLEN += 1
END CASE
WHILE C # '' REPEAT
***
* Build the new item so values are fields and fields
* are values.
***
BUFFER = SPACE(ITEMLEN)
BUFPOS = 1
FOR VMC = 1 TO VMAX
IF VMC # 1 THEN
TEXTLEN = 1
BUFFER[BUFPOS,TEXTLEN] = @FM
BUFPOS += TEXTLEN
END
FOR FMC = 1 TO FMAX
IF FMC # 1 THEN
TEXTLEN = 1
BUFFER[BUFPOS,TEXTLEN] = @VM
BUFPOS += TEXTLEN
END
TEXT = ARRAY(FMC,VMC)
TEXTLEN = LEN(TEXT)
BUFFER[BUFPOS,TEXTLEN] = TEXT
BUFPOS += TEXTLEN
NEXT FMC
NEXT VMC
***
* Done.
***
ITEM = BUFFER
RETURN
END

</pre>

http://www.autopower.com/rgozar/pixel.gif

AccuTerm

2015-05-15T21:36:18Z

TonyG:

[http://www.zumasys.com/products/accuterm AccuTerm™ by Zumasys] is a terminal emulator used to connect to various <nowiki>multivalued databases</nowiki>. [[AccuTerm]] also provides an communication pipe between the client PC and server allowing it to transfer files between the two machines, start processes on the client PC, and provide a "GUI engine" to frontend legacy programming.

AccuTerm was written by Pete Schellenbach who originally developed the software under AccuSoft Enterprises. He is now Zumasys Director of Product Development. 

See also
[[AccuTermKeyboardMapping]]
[[AccuTermKeywords]]
[[RunAProgram]]
[[AccuTermFileTransfer]]
[[ConnectToMicrosoftExcel]]
[[Row2Col]]

[[Tags]]: emulation character screen GUI user-interface telnet ssh

AccuTerm

2015-05-15T21:16:36Z

TonyG:

[[AccuTerm]]™ is a terminal emulator used to connect to various <nowiki>multivalued databases</nowiki>. [[AccuTerm]] also provides an communication pipe between the client PC and server allowing it to transfer files between the two machines, start processes on the client PC, and provide a "GUI engine" to frontend legacy programming.

AccuTerm was written by Pete Schellenbach who originally developed the software under AccuSoft Enterprises. He is now Zumasys Director of Product Development.
website: [[AccuTerm]]™ by [http://www.zumasys.com/products/accuterm Zumasys]

See also
[[AccuTermKeyboardMapping]], [[AccuTermKeywords]]

[[Tags]]: emulation character screen GUI user-interface telnet ssh

CreateWebInterfaces

2015-05-15T21:05:50Z

TonyG:

[[HowTos]] >> <nowiki>CreateWebInterfaces</nowiki>

= How do I create a web interface to the information in my MV DBMS? =

== Commercial Solutions ==

*Informer from Entrinsik http://www.entrinsik.com/solutions/informer.cfm

*<nowiki>WebView</nowiki> from Sierra Bravo http://www.sierra-bravo.com/webview.php

*Full-featued Online Store w/ Pick API Interface, Royalty Free - http://www.sierra-bravo.com

*<nowiki>WebWizard</nowiki> from ERIS (Eagle Rock Information Systems) http://www.eaglerock-is.com/wwiz.asp

*Visage from Stamina Software http://www.stamina.com.au/Products/Visage/Products_Visage.htm

*A video on [http://nebula-rnd.com/products/gallery.htm this page], provided by Nebula Research and Development, demonstrates how to create a web service client and server with the .NET Framework. The connectivity to the <nowiki>DBMS</nowiki> is through [[mv.NET]].

*<nowiki>DesignBais</nowiki> from <nowiki>DesignBais</nowiki> International http://designbais.com/

== Open Source Solutions ==

* [[u2pipe]] Connect a web server to a U2 (Universe or Unidata) database via u2pipe.

* MVWWW http://mvwww.sourceforge.net/ - not actively maintained, not entirely dead either.

* JScript for U2 ([[JS4U2]]) http://www3.sympatico.ca/ian_renfrew/JS4U2/docframe.html - not actively maintained, mostly dead, someone should assume this worthy project.

* [[RESTful Web Services]] Connect to the MV database using web services

* [[RedBack]] for PHP https://github.com/gheydon/redback for a pure PHP implementation for Redback 4

== In House Solutions ==

* [[Accessing_U2_From_PHP]] Suggestions gathered from the u2ug users mailing list.

*You can use [[UniObjects for Java]] to develop anything you can imagine. Ideas include Struts-based web applications running under Tomcat (or another Servlet container) and XML-based Web Services with Apache Axis. See [[JavaSource]] for more info.

*You can use PHP or Perl and [[InterCall]] together
**Jeff Butera has a working example, and Brooklyn Law School is using a modified version of it.
**A post to u2-users from Ken Hall saying he also has PHP->Intercall working. <nowiki>http://www.mail-archive.com/u2-users%40listserver.u2ug.org/msg06853.html</nowiki> (per Ken Hall, this is no longer available)
**[[PerlSource]] has some code samples from the dawn of time

== See also ==

* The [[OpenQM]] web site contains notes on connecting [[OpenQM]] directly to a web server using a cgi executable and the QMClient library. The same principle should be able to be applied to other [[MultiValue]] databases. See: http://www.openqm.com/cgi/lbscgi.exe?T0=h&X=hvegquw43e&t1=presentations

* [[HowTos]] page on this site has a number of ways "how to" access MV from various languages.

Main Page

2015-04-02T17:36:23Z

TonyG: Added link to MoveToMediaWiki

{{#seo:
|title=PickWiki | Powered by Zumasys
|titlemode=replace
|description=The site is all about Pick/MultiValue databases and applications. PickWiki was created by Ian McGowan and is now managed by Zumasys.
}}

Welcome to the <big>'''PickWiki!'''</big> This site is about [[MultiValuedDatabases| Multivalue Databases]]. Learn more about the evolution of the [[Pick Operating System]].

== News ==

* 2015-03-09 Management of pickwiki.com has been transitioned to [http://www.zumasys.com Zumasys] and the original UseMod Wiki platform has been migrated to MediaWiki
* 2015-01-15 [http://www.zumasys.com/admin/zumasys-acquires-jbase-database/ Zumasys acquires jBase!]
* 2013-12-15 Pickwiki.com has been migrated from a virtual to a physical server hosted at www.ovh.com

== About PickWiki ==
This wiki runs on MediaWiki and is currently managed by Zumasys.
* [[Special:Allpages| Index]] - All pages
* [[Special:RecentChanges| Recent Changes]]
* Information about the [[MoveToMediaWiki]]
* [[Special:ListUsers]] - As a registered user, you can create your own page and your updates will automatically link to it!

== Some useful starting points ==
* [[HistoryOfMV | Pick/MultiValue Turns 50 Years Old]]
* [[InMemoriam| In Memoriam]] - Remembering those who are no longer with us
* [[MultiValuedDatabases#Licensees | Pick Licensees]] - List of Pick Licensees
* [[MultiValuedDatabases| MultiValued Databases]] - Describes the database and its history
* [[Getting_Started|Getting Started]] with MultiValued Databases
* [[HowTos]] - Common issues and solutions, like creating web interfaces
* [[SourceCode| Source Code]] - Programming and technical articles

== Other resources==
* [[Blogs]] related to [[MultiValue]] software
* [[Community]] page includes links to [[employment]], [[UserGroups]] and forums to post questions
* [[Freeware]] - All free, mostly open source
* [[MultiValueConsultants| MultiValue Consultants]] - Need some help? Find the perfect person!
* [[MultiValueCompanies| MultiValue Companies]] - List of companies which use MultiValue databases

== Help ==

* [http://en.wikipedia.org/wiki/Help:Wiki_markup Text Formatting Rules]
* [http://www.mediawiki.org/wiki/Help:FAQ MediaWiki FAQ]

MoveToMediaWiki

2015-04-02T17:32:56Z

TonyG: Modified the header to reflect current activity

= Site migrated to <nowiki>MediaWiki</nowiki>! =

In March 2015, Ian McGowan passed the data for this site to Zumasys, where for all the reasons documented below, it was migrated to MediaWiki. Zumasys is now serving the community as site host and curator. Site content is still the responsibility of the community.

People will probably have questions about the site: How do we use it? Where can we ask questions? What's being done here? The answers will be changing over time. The search mechanisms will be changed, new features will be added, and the resource will stabilize.

For now, the info below is being left as a historical reference. It will be updated as time permits.

* To discuss the site and what's happening, we're planning to use the [https://groups.google.com/forum/#!forum/mvdbms MVDBMS Google Group].
* For live chat, join mvTalk at Slack.com. See the invitation [https://groups.google.com/d/msg/mvdbms/VbrTU1svUYc/9OFyB2DuBz8J here].

Community members are encouraged to create an account here and to contribute. If you have comments or questions about content but you don't want to modify the content, click the "discussion" tab at the top of any page. There you can recommend changes or explain the content without actually changing it. If you want to know when content changes, click the "watch" tab or check the [[Special:RecentChanges]] page.

More to come soon...

= We're moving to <nowiki>MediaWiki</nowiki>! =

(2009/01/07) After some discussion and research (see [[NewWikiIdeas]]), a decision has been made to move this environment to <nowiki>MediaWiki</nowiki>. That decision isn't carved in stone, but we've already created a new wiki environment which is now in test mode. All data has been ported there. Ian, Rex, and Tony are now identifying what didn't convert properly. We'll probably write small BASIC utilities to zap the data as required so that it fits with <nowiki>MediaWiki</nowiki>.

== Why <nowiki>MediaWiki</nowiki>? ==

(A note from Tony Gravagno to Ian <nowiki>McGowan</nowiki> and Rex Gozar, now shared with <nowiki>MediaWiki</nowiki> visitors.)
----
:I was encouraged to look into alternatives to <nowiki>MediaWiki</nowiki>. What follows are my current thoughts on the matter. I will continue with my effort to port into <nowiki>MediaWiki</nowiki> as an experiment, and if someone has some compelling reason to choose something else then Ian can make the choice.

:After doing a bit of research, my choice for porting <nowiki>MediaWiki</nowiki> to a new Wiki platform is still <nowiki>MediaWiki</nowiki>. Here is why:

: * It's standard. This precludes "why didn't you use something more standard" arguments.
: * Just about anyone can jump in to help administer it, not so with fringe alternatives.
: * The core and extensions are well maintained by hundreds of people, eliminating the problem of porting to software that later dies through lack of interest, as is the case with many FOSS projects.
: * There are a wealth of extensions, enabling us to respond with new features.
: * Arguments against <nowiki>MediaWiki</nowiki> are not compelling and most of them seem to be a few years old. When asked "why <nowiki>MediaWiki</nowiki>", I'd have to respond "why not?".
: * Porting to another platform can result in questions like "why doesn't this work" or "what happened to that?" Our chances of resolving these issues quickly with [[MediaWiki]] are much better than with other platforms.

:One problem we want to resolve is the need to use "weird" syntax in page edits:

:People want to contribute content without learning a new language to do it. Unfortunately options for WYSIWYG editors for any wiki are limited. Most wiki have no WYSIWYG. So by definition, content management with wiki almost always requires some knowledge of wiki syntax. However, <nowiki>MediaWiki</nowiki> has about four WYSIWYG options. Only one of them, [http://mediawiki.fckeditor.net/ FCKEditor] (another popular standard), is cross-browser, not considered experimental, and is actively developed/maintained. Therefore, my implementation of <nowiki>MediaWiki</nowiki> would include FCKEditor.

:No WYSIWYG tools support the full range of wiki features. Instead of "what you see is what you get", the reality today is more like "what you get is close to what you mean but not necessarily what you thought you were going to see". Refinement and using special features will require some knowledge of wiki syntax which can be added by putting the editor in raw mode.

:Summary

:No solution is perfect. <nowiki>MediaWiki</nowiki>, FCKEditor, and all of these related FOSS tools have their faults. But the proposed solution is still better than what we have now. This project is defined as being nothing more than a wiki web site, not a CMS where we might choose [http://drupal.org/ Drupal] or [http://www.joomla.org/ Joomla], and not a documentation site where we might choose [http://www.dokuwiki.org/dokuwiki [[DocuWiki]]]. <nowiki>PickWiki</nowiki> is not funded or corporately sponsored, and not maintained by people who have a lot of free time. In this limited scope and with consideration for easy maintenance and ease of use by the intended audience, <nowiki>MediaWiki</nowiki> seems to be the proper choice for this site.
----

== More Q&A ==
* When is this happening?
** An environment is currently in test mode. Testing will continue as time permits, as long as required. Expect to see a test site by February 2010 and a new live site by March 2010.
* Can we see the new site before it goes live?
** We'll open the test site for UAT (User Acceptance Testing) when we've eliminated the initial conversion issues. People will be welcome to beat up the new environment before we relocate it back here to <nowiki>PickWiki</nowiki>.com.
* Will our existing user IDs be preserved?
** We're not sure yet.
* What features will be available?
** The site will have a minimal set of extensions to reduce complexity and maintenance, but suggestions are welcome for must-have features.
** Initially the focus will be on:
*** ease of editing
*** visual appeal (without glitz)
*** security
*** elimination of spam, graffiti, and other abuse
*** searchability with categories, tags, etc
*** ability for people to comment without posting content (this is actually a feature built-in to <nowiki>MediaWiki</nowiki> with <nowiki>Talk/Discussion</nowiki> pages but we'll try to ensure that people can effectively collaborate on content
* Will history of changes be preserved?
** (From Ian) With any transition, it would be nice to convert history, not just the existing content: http://www.mediawiki.org/wiki/Manual:Importing_external_content
** We'll try to ensure that all revision history is maintained but we can't guarantee it. Let's assume that the new site will move forward from the conversion date with no history, and that any history will be a nice bonus.
* What if I don't like <nowiki>MediaWiki</nowiki>?
** Please propose an alternative and provide some good reasoning.
* Can I recommend other features?
** Sure, post ideas here or email Tony, Ian, or Rex.
* How can I help?
** Share your thoughts.
** Post content.
** Find links to web pages with content that should be included here.
** Spend a few minutes beating up on the test site when we open it up.

Employment

2014-06-30T19:31:55Z

TonyG: *

If you are available for employment or contracting work, there are a few things you should do:

* Create a compelling CV or résumé.
* Contact the DBMS providers with which you are most familiar. For many end-users, the only resource they know of for employees or services is their DBMS provider. DBMS-specific pages are provided here (please add more if there are any). These include jobs which may be at the DBMS companies themselves as well as jobs listed by the DBMS companies for their user base:
** [http://www.revelation.com/devnet.nsf/Main+View/E2552236FE02EE0985256620004A095F?OpenDocument Revelation Software Developer Network] OpenInsight
** [http://tigerlogic.com/tigerlogic/company/careers/index.jsp Tiger Logic] (D3, mvBase, mvEnterprise)
** [http://www.jbase.com/careers.html jBase International] Corporate opportunities
* If you can do consulting/contractor work, post a brief summary about yourself on the MultiValueConsultants page.
* Attend a meeting at one of the MV UserGroups.
* Post a note to a forum listed on the [[Community]] page.
* See the International Spectrum Jobs page : http://www.intl-spectrum.com/MultiValue_Jobs.aspx
* Post your availability at [http://www.pickjobs.net/ PickJobs.net]
* If you're in the UK, see Twitter [https://twitter.com/#!/MultiValueJobs @MultiValueJobs]

If you are an employer or you need short-term assistance, visit the above resources.

If you offer or require services, the most common mistakes people seem to make in this market are as follows:
* Not enough information: specify your requirements and your skills, the platforms you use, and the kind of work you do or that needs to be done.
* Employer looking for a superhero: If you need someone with experience in MV, Oracle, Java, .NET, security, GUI, accounting, and thermodynamics, you should consider hiring/contracting more than one person.
* Rates: If your rate or salary requirement is high, you need to justify it. If you are an employer offering US$20k for a superhero you're wasting your time. The economy is bad but appropriate value must be placed on the experience you require.
* Employers frequently aren't I.T. savvy, or simply don't know what questions to ask an MV professional. It's hard to determine if someone is qualified if you can't ask the right questions. Seek help. Get a neutral opinion before hiring. Check the above resources.
* Employees - this is a small market and there are some end-user shops that turnover Pick people as fast as they can burn them out. Ask around, ask employers if you can talk to some of their people or former contractors. You're entitled to gather opinions on employers too.

Anyone can post a note to the categories below:

== Looking for a full-time employee ==
Posted for Jeff Caspari, http://www.labhealth.com
We have an opening for an experienced Pick (D3) programmer who can learn <nowiki>DesignBAIS</nowiki> very quickly and help us with our backlog of software development projects. This can be done remotely from your location. The most important aspects will be your ability to become productive and proficient with <nowiki>DesignBAIS</nowiki> quickly and your ability to communicate directly and positively with our customers. Our company has been producing laboratory software for over 25 years. If you are interested in hearing more, please send your resume directly to me with your contact information. Thank you, jcaspari@labhealth.com

== Looking for full-time employment ==
Gary Gowans:

Experienced Pick Databasic programmer analyst - all flavours. IBM 'certified'! Financial Systems, Logistice, Manufacturing, Health and Local Government experience. Trouble shooting, migration and 'help!' support a specialty. Excellent communication and interpersonal skills.

Also general Business Analysis, systems and application support, testing, etc. Experience with web-based applications, HTML, Javascript, etc.

Permanent work within reach of Edinburgh sought (but not expected!)

email gfg.it(remove)@btinternet.com

See GFG IT Services for contract work...

...

== Looking for development assistance or consulting ==
...

== Available for development and consulting ==
GFG IT Services Ltd.
Experienced Pick Databasic programmer analyst - all flavours. IBM 'certified'! Financial Systems, Logistice, Manufacturing, Health and Local Government experience.

Trouble shooting, migration and 'help!' support a specialty. Excellent communication and interpersonal skills. Have suitcase, will travel...

email gfg.it(remove)@btinternet.com
...

Community

2013-03-14T21:25:17Z

TonyG: Added list of tweeters

MV professionals, vendors, and end-users exchange information in UserGroups and in online forums.

* [http://groups.google.com/groups?group=comp.databases.pick comp.databases.pick] newsgroup is the grandaddy of them all
** CDP is now dead, archive prior to 2012 is useful, afterward it's complete abuse.
** Disregard anything there from 2012 forward. Consider CDP as read-only.
* [http://groups.google.com/group/mvdbms/about MVDBMS forum] New (12/2011) community group for all Pick-based platforms (CDP replacement)
* Internet message boards such as http://www.dbforums.com.
* Website and Email forums on the U2 Users Group site: http://u2ug.org
* [[Cache|Caché]] forum http://groups.google.com/group/InterSystems-MV
* http://forums.tigerlogic.com (D3, mvBase, mvEnterprise, etc)
* http://groups.google.com/group/jBASE (T24/Globus)
* http://groups.google.com/group/OpenQM (Commercial QM)
* http://groups.google.com/group/openqm-opensource (OpenQM FLOSS)
* http://groups.google.com/group/reality-database
* http://revelation.com/Revelation.nsf/byTitle/281E3E1A480FB44C85256DC1002427C5?OpenDocument
* <nowiki>LinkedIn</nowiki> groups:
** http://www.linkedin.com/groups/Pick-Users-Group-64935
** http://www.linkedin.com/groups/Multivalue-Database-1876518 (not as much traffic)

Product- and vendor-specific forums have also been formed:
* http://groups.google.com/group/mvnet
* http://groups.google.com/group/DesignBais-Forum
* http://groups.google.com/group/BRIZ
* http://nebula-rnd.com/forum/
* http://www.precisonline.com/forum
* http://www.cuusers.org/cuuserforum/
* http://www.t24all.com/forum/
* http://www.asent.com/forum/ (AccuTerm)

Facebook communities are not listed here yet. Send Facebook references to TonyG.

Twitter links have been added here. People and companies "tweet" frequently on Pick-related matters and this has become a "community" of it's own. Send @ references to TonyG. To broadcast a message to anyone interested in MV/Pick, the #multivalue hash tag is commonly used.

Some Twitter users:
* <nowiki>@CdMPick</nowiki>
* <nowiki>@clifoliver</nowiki>
* <nowiki>@dickthiot</nowiki>
* <nowiki>@dwolt</nowiki>
* <nowiki>@ElkieHolland</nowiki>
* <nowiki>@fusionwareInt</nowiki>
* <nowiki>@GlennSallis</nowiki>
* <nowiki>@houbenator</nowiki>
* <nowiki>@IntlSpectrum</nowiki>
* <nowiki>@ISCRTaylor</nowiki>
* <nowiki>@jonsisk</nowiki>
* <nowiki>@KevinPowick</nowiki>
* <nowiki>@madhump</nowiki>
* <nowiki>@markbschramm</nowiki>
* <nowiki>@mikepluta</nowiki>
* <nowiki>@moecaneda</nowiki>
* <nowiki>@mvcmap</nowiki>
* <nowiki>@mvdbman</nowiki>
* <nowiki>@MyPickCloud</nowiki>
* <nowiki>@pickcoder</nowiki>
* <nowiki>@pickProgrammers</nowiki>
* <nowiki>@PickteamTweets</nowiki>
* <nowiki>@PRC_SJPlus</nowiki>
* <nowiki>@RevSoftUS</nowiki>
* <nowiki>@RocketU2</nowiki>
* <nowiki>@rossferris</nowiki>
* <nowiki>@salesbluefinity</nowiki>
* <nowiki>@SAPUGtweets</nowiki>
* <nowiki>@SimonVerona</nowiki>
* <nowiki>@Spellinator</nowiki>
* <nowiki>@symeonb</nowiki>
* <nowiki>@TAivazian</nowiki>
* <nowiki>@TheMpower1Group</nowiki>
* <nowiki>@TigerLogicPick</nowiki>
* <nowiki>@TonyGravagno</nowiki>
* <nowiki>@TSCMVS</nowiki>

Some forums break discussions between technical and social. Some are moderated, others are not. Each forum has a unique personality of its own. Some are more adverse to advertising then others.

The community also includes some [[Blogs]].

If you are searching the community for work, or someone to do development, see the [[Employment]] page.

----

[[Tags]]: job jobs help wanted employment work contractors consultants services forums discussions google usergroups user groups

(Above [[tags]] added by TG in response to CDP thread about searchability of this site. These tags should help people to find this page using the Search box if they're looking for help or work. See Tags page for details.)

AccuTermKeywords

2012-10-11T03:31:44Z

TonyG: Significant update, added QM

AccuTerm has the wED (Windows Editor) which provides syntax highlighting for BASIC programs. v7.1 allows keywords to be defined on the server. With this enhancement, a developer can open wED on different MultiValuedDatabases and get platform-specific highlighting! See the product documentation for details about how to use this feature.

This page provides lists of keywords which can be used for various platforms as well as some ideas for how the lists can be used. It is currently organized as follows:
* General Statements are BASIC statement keywords which should be supported on all platforms. Use this as your base list.
* General Functions are BASIC cross-platform functions. Add these to your statements list or set them as your User keywords and assign a different highlight style for more diversity in your code.
* [[D3]], [[mvBase]], [[QM]], [[UniVerse]], etc. These sections provide platform-specific keywords for statements and functions.

Since this is a new page, please add comments to the top Comments section regarding structure, merging lists, etc. We can clean up the comments later.

If you would like to contribute to this page, edit it yourself or email TonyG with your notes.

You can help by:
* Providing new Statement or Function keywords for specific platforms.
* Noting when keywords should be made General or when General keywords are really platform-specific.
* Suggesting alternative ways to make this information more useful to colleagues.

= How to use these lists =

Create an item called WED in ACCUTERMCTRL that looks like this:
<pre>
X
ACCUTERMCTRL\KEY1
ACCUTERMCTRL\KEY2
</pre>
( See <nowiki>AccuTerm</nowiki> v7.1 release notes for details on that item and additional attributes. )

Now create two more items in ACCUTERMCTRL called KEY1 and KEY2 (actual names are up to you but need to agree with item above). Copy/paste all General Statements into KEY1 (start with the ;comment). Follow those with statements for your platform. Copy/paste all General Functions into KEY2. Follow those with functions for your platform. Save the items. Now open WED and in Tools/Settings, check Enable BASIC syntax highlighting. Check the Highlight tab to ensure the colors of various code elements are easy to distinguish. Click OK to save the settings. Your code will now be highlighted using the keyword lists. Update your KEY items whenever the date below is more recent than your own.

= Comments =
New page: 2012-sep-6
Updated: 2012-oct-8, 10

TG:
* Expression operators and @values added to Functions rather than Statements out of personal preference. Some people won't want these highlighted at all. Just remove them after copying to your DBMS.
* See wED settings to understand "+", "-", and "=" suffixes.
* Lines in keyword lists beginning with semicolon ";" are comments.
* Lists presented here in vertical format with PRE tags for easy copy/paste into DBMS editor. Putting everything in one line would be more elegant but would then require conversion. This is just easier.
* Lists are sorted for easy searching and for finding errors.
* These lists are a work in progress - they are not complete. Nothing has been "forgotten". Many keywords and platforms have simply not been manually added yet. Please send your list updates to TonyG or add them here.
* Some of the organization may be non-intuitive. For example, some Transaction statements are General and others are platform-specific. This is because some commands are found in more than one platform. When this is the case, a statement (or function) are put into the general category - the keyword may not be general across all platforms but it's general enough to be found in more than one platform, so it is not platform specific.
* A suggestion has already been made to enhance AccuTerm to allow separation of "System" and "User" keywords into several lists which can be used for Statements, Functions, Operands, Compiler Directives, and perhaps other keyword classes.
* There is some duplication between statements and functions, like CONVERT and LOCATE. These may be separated later.
* It can't hurt to copy all statements from all platforms into a single list and copy that to all of your systems (same for functions).
* Any statement or function which is on more than one platform is considered "general". The only statements and functions defined for a specific platform are those that are not found anywhere else. Entries here are subject to movement and correction.

= General Statements =
<pre>
; Cross-platform as of 2012-oct-10
$CHAIN
$INCLUDE
ABORT
BEGIN CASE+
BEGIN TRANSACTION+
BREAK
END CASE-
COMMIT
CALL
CAPTURING
CASE=
CHAIN
CLEAR
CLEARDATA
CLEARFILE
CLEARCOMMON
CLEARINPUT
CLEARSELECT
CLOSE
CLOSESEQ
COMMIT
COMMON
COMPARE
CONVERT
CREATE
CRT
DATA
DEBUG
DEL
DELETELIST
DELETEU
DIM
DIMENSION
DO
ECHO
ELSE+
END-
END TRANSACTION-
ENTER
EQU
EQUATE
ERRMSG
ERROR
EXECUTE
FILE
FILELOCK
FILEUNLOCK
FIND
FLUSH
FOOTING
FOR+
FROM
FUNCTION
GET
GETLIST
GETX
GO
GOSUB
GOTO
HEADING
HUSH
IF
IFR
IN
INCLUDE
INPUT
INPUTERR
INPUTIF
INPUTNULL
INPUTTRAP
INS
KEY
KEYEDIT
KEYEXIT
KEYTRAP
LOCATE
LOCK
LOCKED+
LOOP+
MAT
MATBUILD
MATPARSE
MATREAD
MATREADL
MATREADU
MATWRITE
MATWRITEU
NAP
NEXT-
NOBUF
NULL
OFF
ON ERROR
ON
OPEN
OPENPATH
OPENSEQ
PAGE
PERFORM
PRECISION
PRINT
PRINTER
PRINTER RESET
PRINTERR
PROCREAD
PROCWRITE
PROGRAM
PROMPT
READ
READBLK
READL
READLIST
READNEXT
READSEQ
READT
READTX
READU
READV
READVL
READVU
RECORDLOCKL
RECORDLOCKU
RELEASE
REMOVE
REPEAT-
RETURN
RETURNING
REWIND
ROLLBACK
RQM
SEEK
SELECT
SELECTE
SELECTINDEX
SETREM
SLEEP
STEP
STOP
SUB
SUBROUTINE
TA
TCLREAD
THEN+
TIMEOUT
TO
TRANSACTION START+
TTYSET
UNLOCK
UNTIL=
WEOF
WEOFSEQ
WHILE=
WRITE
WRITET
WRITEU
WRITEV
WRITEVU
</pre>

= General Functions =
<pre>
; Cross-platform
@AM
@FM
@SM
@VM
ABS
ABSS
ACOS
ALPHA
AND
ANDS
ASCII
ASIN
ASSIGNED
ATAN
BITAND
BITNOT
BITOR
BITRESET
BITSET
BITTEST
BITXOR
CAT
CATS
CHANGE
CHECKSUM
CHAR
COL1
COL2
COS
CONVERT
COUNT
COUNTS
DATE
DCOUNT
DELETE
DIV
DOWNCASE
DQUOTE
DTX
EBCDIC
ENCRYPT
EQS
EREPLACE
EXCHANGE
EXP
EXTRACT
FIELD
FILEINFO
FMT
FMTS
FOLD
GE
GES
GETREM
GT
ICONV
IFS
INDEX
INDEXS
INDICES
INMAT
INSERT
INT
ITYPE
KEYIN
LE
LEN
LENS
LES
LG
LN
LOCATE
LOWER
LT
LTS
MATCH
MATCHFIELD
MAXIMUM
MINIMUM
MOD
MODS
NE
NEG
NEGS
NES
NOT
NOTS
NUM
NUMS
OCONV
OCONVS
OR
ORS
PWR
RAISE
REM
REPLACE
REUSE
RND
SEEK
SELECTINFO
SENTENCE
SEQ
SIN
SORT
SOUNDEX
SPACE
SQRT
SQUOTE
STATUS
STR
STRS
SUM
SUMMATION
SWAP
SYSTEM
TAN
TERMINFO
TIME
TIMEDATE
TRANS
TRIM
TRIMB
TRIMBS
TRIMF
TRIMFS
UNASSIGNED
XLATE
XTD
</pre>

== D3 ==
=== Statements ===
<pre>
; D3-Specific
$OPTIONS
AUX
BEGIN WORK+
CASING ON
CASING OFF
CFUNCTION
COMMIT WORK
END WORK-
INPUTCTRL
ROOT
SEND
SENDX
TRANSACTION CACHE OFF
TRANSACTION CACHE ON
TRANSACTION FLUSH
TRANSACTION ROLLBACK
</pre>
=== Functions ===
<pre>
; D3-Specific
ACCESS
ERROR
OCCURS
SCAN
</pre>

== mvBase ==
=== Statements ===
<pre>
; mvBase-Specific
$*
BLOCK
BREAKKEY ON
BREAKKEY OFF
CONNECT
CONSOLE
CRT ON
DISCONNECT
INPUT CTRL ON
INPUT CTRL OFF
INPUTPROMPT
LOCK-BEEP
READB
READF
SPOOLQ
UCLOSE
UCREATE
UDELETE
UERROR
UEXECUTE
ULOCK
ULSEEK
UMESSAGE
UNBLOCK
UOPEN
UREAD
UREADLINE
USING
USYSTEM
UWAITFOR
UWRITE
WAKEUP
WRITEB
WRITEBU
WRITEFU
</pre>
=== Functions ===
<pre>
; mvBase-Specific
LINESTATUS
</pre>

== QM ==
=== Statements ===
<pre>
; QM-specific
ABORTE
ABORTM
CLASS
CREATE.FILE
DEFFUN
DELETE
DELETESEQ
DIR
DISINHERIT
DISPLAY
DPARSE
DPARSE.CSV
EXIT
FINDSTR
FORMLIST
GETPU
INHERIT
INPUTCLEAR
INPUTCSV
INPUTFIELD
LOGMSG
LOCAL
MARK.MAPPING
MATREADCSV
OS.EXECUTE
OSDELETE
OSREAD
OSWRITE
PAUSE
PRINTER NAME
PRINTER SETTING
PRIVATE
PUBLIC
READCSV
REMARK
REMOVE.BREAK.HANDLER
RESTORE.SCREEN
SAVELIST
SELECTLEFT
SELECTN
SELECTRIGHT
SELECTV
SET.ARG
SET.BREAK.HANDLER
SET.EXIT.STATUS
SETLEFT
SETPU
SETRIGHT
SSELECT
STOPE
STOPM
WAKE
WEOFSEQF
VOID
</pre>
=== Functions ===
<pre>
; QM-specific
ACCEPT.SOCKET.CONNECTION
ARG
ARG.COUNT
BINDKEY
CATALOGED
CATALOGUED
CHILD
CLOSE.SOCKET
COMPARE
CONFIG
CONNECT.PORT
CREATE.SERVER.SOCKET
CROP
CSVDQ
DECRYPT
ENV
FIELDS
FIELDSTORE
FOLDS
GET.MESSAGES
GET.PORT.PARAMS
GETNLS
GTS
ICONVS
IDIV
KEYCODE
KEYINC
KEYINR
KEYREADY
LISTINDEX
MATCHESS
MAX
MIN
OBJECT
OBJINFO
OPEN.SOCKET
OS.ERROR
OUTERJOIN
PRINTER.SETTING
QUOTE
RDIV
READ.SOCKET
READLOCKED
REMOVE
REMOVEF
RTRANS
SAVE.SCREEN
SERVER.ADDR
SET.PORT.PARAMS
SET.SOCKET.MODE
SETNLS
SHIFT
SOCKET.INFO
SOUNDEXS
SPACES
SPLICE
SUBR
SUBSTITUTE
SUBSTRINGS
SWAPCASE
TRIMS
TTYGET
VSLICE
WRITE.SOCKET
</pre>

== Unidata ==
=== Statements ===
<pre>
</pre>
=== Functions ===
<pre>
</pre>

== Universe ==
=== Statements ===
<pre>
; Universe-Specific
$MAP
AUTHORIZATION
AUXMAP
BSCAN
CAT
CONTINUE
FILELOCK
FILEUNLOCK
GETX
GROUPSTORE
INPUTDISP
INPUTDP
OPENCHECK
OPENDEV
RANDOMIZE
READLOCKED
RECORDLOCKL
RECORDLOCKU
REVREMOVE
SEND
SET TRANSACTION ISOLATION LEVEL
STATUS
SUBR
TABSTOP
TTYCTL
TTYGET
WRITEBLK
WRITELIST
WRITESEQ
UPRINT
</pre>
=== Functions ===
<pre>
; Universe-Specific
acceptConnection
ADDS
BYTE
BYTELEN
BYTETYPE
BYTEVAL
CENTURY.PIVOT
CHARS
CLEARPROMPTS
closeSocket
CloseXMLData
COSH
DIGEST
DIVS
ENCODE
EOF
EXP
FADD
FDIV
FFIX
FFLT
FIX
FMTDP
FMTDSP
FMUL
FOLDDP
FSUB
GET
getHTTPDefault
GETLOCALE
getSocketErrorMessage
getSocketInformation
getSocketOptions
GROUP
ICHECK
ILPROMPT
INCONVS
ISNULL
ISNULLS
LEFT
LENDP
LENSDP
LOCALEINFO
MULS
OpenXMLData
PrepareXML
protocolLogging
RECORDLOCKED
readSocket
ReadXMLData
REAL
ReleaseXML
RIGHT
RPC.CALL
RPC.CONNECT
RPC.DISCONNECT
SADD
SCMP
SDIV
SEQS
setHTTPDefault
SETLOCALE
setRequestHeader
setSocketOptions
SIGNATURE
SINH
SMUL
SSUB
SUBS
TANH
TPARM
TPRINT
UNICHAR
UNICHARS
UNISEQ
UNISEQS
UPCASE
writeSocket
XLATE
XMLError
</pre>

== Add more DBMS platforms here ==

AccuTermKeywords

2012-09-06T17:05:27Z

TonyG: New page

Employment

2012-06-09T19:51:05Z

TonyG: Removed old posting

HowTos

2012-02-16T03:34:44Z

TonyG: Added link to R83 virtualization PDF (hosting on my site until PW moves to MediaWiki)

If you have commonly asked "How do I do..." questions (or even better answers!) add a page here. These are topics that come up over and over, and the goal of this section is to capture the best answers.

Each page is structured as a general discussion of the problem and some approaches, and then specific implementations for each O/S and or database (e.g. Unix vs. Windows, Pick R83 vs UniVerse vs D3)

* [[How to Register|How to Register as a new PickWiki user]]
* How to find [[Employment]], developers, [[MultiValueConsultants|MultiValue Consultants]], etc
* [[AccessFromDotNet|Access from .NET]]
* [[AccessFromJava|Access from Java]]
* [[AccessFromPhp|Access from PHP]]
* [[AccessFromPerl|Access from Perl]]
* [[AccessFromVB|Access from Visual Basic]]
* [[AutomateNTBackup|Automate (Windows) NT Backup]]
* [[ConnectToMicrosoftAccess|Connect to Microsoft Access]]
* [[ConnectToMicrosoftExcel|Connect to Microsoft Excel]]
* [[ConnectToMicrosoftWord|Connect to Microsoft Word]]
* [[CreatePDFDocuments|Create PDF Documents]]
* [[CreateWebInterfaces|Create Web Interfaces]]
* [[GetUniOleDbWorking|Get UniOLEDB Working]]
* [[GoogleMaps|Launch GoogleMaps]]
* MigratePickToPick - Notes about migrating from one Pick/MV platform to another
* [[RunAProgram|Run a Program on a client PC]]
* [[SendAnEmail|Send an Email]]
* [[UseWithOpenOffice|Use with OpenOffice]]
* [[ViewCallStack|View Call Stack]]
* [http://nebula-rnd.com/freeware/SetupBochsForR83_v3.pdf Virtualize R83 in Windows] (1.5MB PDF document by Dave M, temporarily hosted off-site)

SyntaxFiles

2011-02-18T18:38:22Z

TonyG: Added Vim for jBase and link for AccuTerm mapping

Syntax Files for Editing programs

[[EditPlus]] , Edit Plus databasic (UV10) syntax file

[[UniBasicEl]], Syntax highlighting in Emacs

[[TextPad]], Syntax highlighting in TextPad

[[Beyond Compare]], Beyond Compare SB+ Paragraph formatter. Allows you to compare SB+ Paragraph Processes

[[NotepadPlusPlus|Notepad++]] syntax highlighting for Pick BASIC

<nowiki>UniBASIC</nowiki> syntax highlighting for [http://www.vim.org/scripts/script.php?script_id=2143 Vim]

jBase syntax highlighting for [http://markmail.org/search/?q=jbase%20vim%20syntax Vim]

See also AccuTermKeyboardMapping.

AccuTermKeyboardMapping

2010-08-07T23:21:54Z

TonyG: Minor updates

= Mapping your keyboard in AccuTerm for specific environments =

If you use AccuTerm, you can modify the character sequence sent to a server whenever you use specific keyboard keys.

The keyboard mappings below can be placed in your .atcf config file to facilitate navigation in various MV DBMS environments. This allows you to use standard keys for Insert, Delete, <nowiki>PageUp</nowiki>, Home, arrows, etc. Load a map then check your AccuTerm settings to see what each key does. Preferences of individuals will vary, change as you wish.

Keys defined like 3112="^[[61~" simply remain unmapped.

Note that when your keyboard is mapped to the DBMS, if you shell out to the OS your keystrokes will still be mapped to the DBMS. It may be possible to create a macro which does SH or ! to shell out, while toggling the keyboard for the OS.

: Please feel free to add mappings to this page and to add to the information provided here. This page was created as a stub for more information and certainly is not yet a complete resource on this topic.

== For [[D3]] TCL and in the Update Processor. ==
This sets F9 to copy, F10 to cut, F11 to end the copy/cut, and F12 to paste.
F8 deletes to EOL. F4 is mapped to ctrl-x to exit/quit.
F3 is used for <nowiki>Find/Replace</nowiki>, which corresponds to common Windows app mapping.
(Add more descriptions of mapping here)

<pre>
[Keyboard]
1008="^ZZ"
1013="^N"
33="^ZY"
1033="^T"
34="^P"
1034="^ZE"
35="^G"
1035="^CC"
36="^D"
37="^J"
38="^B"
39="^K"
40="^N"
45="^R"
1045="^CP"
46="^L"
1046="^CD"
112="^?"
2112="^XS"
3112="^[[61~"
113="^CR"
2113="^XF"
3113="^[[62~"
114="^A"
1114="^[[53~"
2114="^XX"
3114="^[[63~"
115="^X"
1115="^[[54~"
3115="^[[64~"
116="^Q"
1116="^[[55~"
3116="^[[65~"
117="^Y"
1117="^[[56~"
3117="^[[66~"
118="^R"
1118="^[[57~"
119="^E"
1119="^[[58~"
120="^CL"
1120="^[[59~"
121="^CD"
1121="^[[60~"
122="^CC"
1122="^[[61~"
123="^CP"
1123="^[[62~"
2123="^XO"
1124="^[[63~"
1125="^[[64~"
1126="^[[65~"
1127="^[[66~"
1253="^N"
10112="1 Help"
11112="PasteCB"
10113="2 Merge"
11113="Script Paste"
10114="3 Find"
10115="4 Exit"
10116="5 Ctrl Q"
10117="6 Ctrl Y"
10118="7 Replace1"
10119="8 Clear"
10120="9 Copy/L"
10121="10 Copy/D"
10122="11 Copy/X"
10123="12 Paste"
</pre>

== For [[QM]] and SED ==
The keys are mapped similarly to D3, so that you can use the same function keys in both environments without having to remember the underlying keystrokes.

Note that SED does copy/cut/paste differently in the way it defines blocks of text.
(Add more descriptions of mapping here)

<pre>
[Keyboard]
33="^[V"
34="^V"
35="^E"
36="^A"
37="^B"
38="^P"
39="^F"
40="^N"
45="^O"
46="^D"
112="^XC"
114="^[S"
1114="^[R"
115="^XS"
116="^XR"
1116="^XQ"
117="^G"
119="^K"
120="^[W"
121="^W"
122="^[."
123="^Y"
10112="Exit"
10114="FindF"
11114="FindR"
10115="Save"
10116="Replace"
11116="ReplaceQ"
10117="Cancel"
10119="Kill Line"
10120="Copy"
10121="Cut"
10122="Start"
</pre>

AccuTerm

2010-08-07T23:12:31Z

TonyG: Added tags

AccuTerm is a terminal emulator used to connect to various <nowiki>multivalued databases</nowiki>. AccuTerm also provides an communication pipe between the client PC and server allowing it to transfer files between the two machines, start processes on the client PC, and provide a "GUI engine" to frontend legacy programming.

website: [http://www.asent.com AccuSoft Enterprises]

See also
AccuTermKeyboardMapping

[[Tags]]: emulation character screen GUI user-interface

RunAProgram

2010-02-15T23:25:03Z

TonyG: Created AccuTermFileTransfer page and added link here

HomePage>>HowTos>>RunAProgram

The problem: you want a program to run on a windows PC as a result of something that happens on your Windows or Unix-based server.
It's usually less of an issue to have a Unix server run something on a Unix client, or Windows server to Windows client - there's plenty of built in ways for that to work. So we'll just consider a Windows PC with a network connection (LAN,WAN or VPN) to a Unix server.

For this to work "something", some program, has to be running on the PC.

==== 0) TerminalEmulators ====

The most common "something" is a terminal emulator and they pretty much all allow you to send an escape sequence and fire off a program. If you want the program to run in response to something the user did on the server, this is the most straightforward way to do it. Also, if you have a serial connection, this is probably the only option.

* wIntegrate:
<PRE>
Use the WIN.PCRUN command installed on the server, CALL WIN.PCRUN(COMMAND,ARGS)
</PRE>

* Accuterm:
To execute a command and return to PICK/BASIC immediately:
<PRE>
PRINT CHAR(27):CHAR(2):"<":command:CHAR(13)
</PRE>
To execute a command and wait for the command to terminate before returning to PICK/BASIC:
<PRE>
PRINT CHAR(27):CHAR(2):">":command:CHAR(13)
</PRE>

See <nowiki>AccuTerm</nowiki> help for details: From the Help Introduction, see <nowiki>AccuTerm</nowiki> Programming. Also see Help on Object Bridge.

More examples are at AccuTermFileTransfer.

* ViaDuct:
<PRE>
?
</PRE>

* Powerterm:
<PRE>
PRINT CHAR(27):"$tS":COMMAND:CHAR(27):"\"
</PRE>

* Netterm:
Start/run the program specified by COMMAND.
<PRE>
CRT CHAR(27):"[]":COMMAND:CHAR(27):"[1*
</PRE>
Send the URL to the client's WWW browser for processing.
<PRE>
CRT CHAR(27):'[]':URL:CHAR(27):'[0*'
</PRE>
Start/run the program specified by COMMAND and wait till it terminates. COMMAND can contain both the program to run and command line arguments.
<PRE>
CRT CHAR(27):"[]":COMMAND:CHAR(27):"[9*"
</PRE>
Start the program associated with the extension contained within FILENAME.
<PRE>
CRT CHAR(27):"[]":FILENAME:CHAR(27):"[12*
</PRE>

==== 1) Doit ====

Doit is a small utility program that installs a tray applet on the client. The server sends it the path of a file to open.

<PRE>
http://www.chiark.greenend.org.uk/~sgtatham/doit/
</PRE>

==== 2) Install rcmd ====

Either from the windows resource kit, or purchase it from mks. You can then issue an rcmd from the unix side.

<PRE>
http://www.dynawell.com/support/ResKit/winnt.asp
http://www.mkssoftware.com/support/kb/faqs.asp?product=Toolkit&type=tech#art140
</PRE>

==== 3) Install or turn on a telnet server ====

W2K/XP come with a telnet server, or you can purchase one. Then use http://expect.nist.gov to script the login/command process.

<PRE>
http://www.goodtechsys.com/
</PRE>

==== 4) Install an ssh server ====

Just like telnet, only secure!

<PRE>
http://tech.erdelynet.com/cygwin-sshd.html
</PRE>

==== 5a) Write a small server program ====

Have the program listen on a predefined port. There are obvious security issues here, but with a little handwaving we can move past them :-)

Recent U2 products can create socket connections from basic and connect to the server. Sample code for this is at BasicSocketClient.

Here's a stripped down example of a server in <a href="http://www.python.org">Python</a>:

urlserver.py
<PRE>
import SocketServer
import os

class UrlHandler(SocketServer.StreamRequestHandler):
def handle(self):
url=self.rfile.readline(512)
print "opening "+url
os.system("start "+url)

server=SocketServer.TCPServer( ('', 79), UrlHandler)
server.serve_forever()
</PRE>

On the pc, type "python urlserver.py" to start the server up, then from another machine, "telnet pc-address 79" and then type the url to go to - the client will open up a browser and go to that address.

==== 5b) ...and here's another in vbscript ====

urlserver.vbs
<PRE>
Option Explicit

' Heavily cribbed from the amazing 4K webserver at:
' http://www.interclasse.com/scripts/4KWebServer.php

Dim oSck
On Error Resume Next
Err.Number=0
Set oSck=WScript.CreateObject("MSWinsock.Winsock","s_")
Select Case Err.Number
Case 0
case &H80040112
echo "No licence found. Install Visual Studio"
case &H80020009
echo "ActiveX Winsock not in the registry, check if installed or use regsvr32"
Case else
echo "Error " & Err.Number & " - &H" & Hex(Err.Number) & " - " & Err.Description
End Select
On Error Goto 0

oSck.LocalPort=79
oSck.Listen
echo "Listening on port " & oSck.LocalPort
Do
' Sleep for 2 seconds
WScript.sleep 2000
Loop

Sub echo(S)
WScript.Echo Now & " " & S
End Sub

Sub s_ConnectionRequest(Byval requestID)
oSck.Close
echo oSck.RemoteHostIP & " - Connection request:" & requestID
oSck.Accept requestID
End Sub

Sub s_Close
oSck.Close
echo "closed - re-listening"
oSck.Listen
End Sub

Sub s_SendComplete
oSck.close
oSck.Listen
End Sub

Sub s_Error(ByVal N, D, ByVal C, ByVal S, ByVal F, ByVal H, Y)
echo "Error" & N & " - " & D
oSck.Close
oSck.Listen
End Sub

Sub s_DataArrival(Byval b)
Dim S,sh

S=""
oSck.GetData S
S=left(S,len(S)-2)
S=left(S,512)
echo S

set sh = createobject("wscript.shell")
on error resume next
sh.run "cmd /c start " & S
on error goto 0

oSck.Close
oSck.Listen
End Sub
</PRE>

On the pc, type "cscript urlserver.vbs" to start the server up, then from another machine, "telnet pc-address 79" and then type the url to go to - the client will open up a browser and go to that address.

==== 6) Have a polling program on the client ====

If the client and the server share access to a directory (via samba or NFS for example), the server can drop a file in the common directory and a program running on the client can watch for new files. When one is found it can read the file and perform some action based on the contents. Here's a VB example:

<PRE>
Private Sub Form_Load()
txtScheduleNum.Enabled = False
cboCategory.Enabled = False
cmdOK.Enabled = False
cmdPreview.Enabled = False
Label1.Enabled = False
Label3.Enabled = False

Me.Show
' Start the poll right away
Timer1_Timer
End Sub

Private Sub Timer1_Timer()
TxtLog.ForeColor = vbBlack
LogMsg "Checking c:\batch"
Set fso = CreateObject("Scripting.FileSystemObject")
Set dir = fso.GetFolder("C:\BATCH")

For Each file In dir.Files
If LCase(Right(file.Name, 3)) = "pdf" Then
Timer1.Enabled = False
TxtLog.Enabled = False
fstr = file.Name
hpsname = Left(fstr, Len(fstr) - 3) & "hps"
justname = Left(fstr, Len(fstr) - 3)
LogMsg fstr
Label1.Enabled = True
Label3.Enabled = True
cboCategory.Enabled = True
cmdOK.Enabled = True
cmdPreview.Enabled = True
' Enable some controls and do something with the file
txtScheduleNum.SetFocus
Exit For
End If
Next
End Sub
</PRE>

==== 7) Consider using a solution created specifically to solve the problem ====
(Ad)
The following link goes to the Nebula R&D forum where an offering is discussed and a link is provided to a blog entry for more information. As of the time of this writing the software is fully usable but is not being offered as a product simply for lack of demand. That situation can change with a compelling business case. http://nebula-rnd.com/forum/index.php/topic,51.0.html
(/Ad)

A general description of this approach, not specific to the Nebula solution, would be to write a PC program in your favourite language (.Net, Java, Flex for example), that runs on the PC and makes periodic calls to a Pick program using whatever technology makes sense for your Pick variety. In the U2 world, this would be UniObjects, though a web services call that hides the connection details from the client, and be much more likely to work through firewalls, would make more sense.

Note: this is not exactly the problem we are trying to solve on this page. The problem is "how do I run a program on the client side, on demand from a Pick program?" The polling solutions presented suffer from a lag between something happening on the server and a program running on the client.

==== Running a program on the server from outside ====
Connectivity to MV is discussed many places in this wiki and any language can be used to execute BASIC business rules and return a result. A unique freeware program called [http://nebula-rnd.com/freeware/ MV Exec] uses [[Mv.NET|mv.NET]] to run any query, any command, any program on a MV server from any PC.

TODO: Expand on this topic with info about D3 compile to executable with G option, UDT, notes about unique jBASE exe/dll design...

== Discussion ==
[TG] There are three topics: 
1) Running a program on the client from the server 
2) Running a program on the server from a remote client 
3) Running a program on the server from the MV environment 
Anyone think it's worthwhile to separate these into different pages?

AccuTermFileTransfer

2010-02-15T23:24:44Z

TonyG: New page

= Examples for file transfers with [http://www.asent.com AccuTerm] =

This simple example uses the <nowiki>DosSvc</nowiki> program provided with <nowiki>AccuTerm</nowiki>. It allows you to easily transfer data to/from a PC without using ESCape sequences.

<nowiki>DosSvc</nowiki> will download the data in SEND.DATA to SEND.PATH\SEND.FILE, then it will execute CMD, then (assuming you have stored a file with results from CMD, it will upload back to MV the data at GET.PATH\GET.FILE.

Just modify the variables and run.

<PRE>
* CMD = DOS COMMAND TO EXECUTE
* SEND.PATH = DOS DIRECTORY TO SEND SEND.DATA TO BEFORE CMD
* SEND.FILE = DOS FILE NAME TO SEND SEND.DATA TO BEFORE CMD
* SEND.DATA = DATA TO SEND TO SEND.FILE
* GET.PATH = DOS DIRECTORY TO GET GET.DATA FROM AFTER CMD
* GET.FILE = DOS FILE NAME TO GET GET.DATA FROM AFTER CMD
*
* OUTPUT:
* GET.DATA = DATA RECEIVED FROM GET.FILE
*
SEND.PATH = "C:\TEMP\AT_TRANSFER"
SEND.FILE = "TARGET.TXT"
SEND.DATA = "This is the data to be sent to the PC"
CMD = "DIR ":SEND.PATH:" > ": SEND.PATH :"\FILELIST.TXT"
GET.PATH = SEND.PATH
GET.FILE = "FILELIST.TXT"
GET.DATA = ""
*
CALL DOSSVC(CMD, SEND.PATH, SEND.FILE, SEND.DATA, GET.PATH, GET.FILE, GET.DATA)
CRT "File listing:"
FOR ATB = 1 TO DCOUNT(GET.DATA,@AM)
CRT GET.DATA<ATB>
NEXT ATB
</PRE>

MoveToMediaWiki

2010-01-07T21:29:54Z

TonyG: Revised date reference

= We're moving to <nowiki>MediaWiki</nowiki>! =

(2009/01/07) After some discussion and research (see NewWikiIdeas), a decision has been made to move this environment to <nowiki>MediaWiki</nowiki>. That decision isn't carved in stone, but we've already created a new wiki environment which is now in test mode. All data has been ported there. Ian, Rex, and Tony are now identifying what didn't convert properly. We'll probably write small BASIC utilities to zap the data as required so that it fits with <nowiki>MediaWiki</nowiki>.

== Why <nowiki>MediaWiki</nowiki>? ==

(A note from Tony Gravagno to Ian <nowiki>McGowan</nowiki> and Rex Gozar, now shared with <nowiki>MediaWiki</nowiki> visitors.)
----
:I was encouraged to look into alternatives to <nowiki>MediaWiki</nowiki>. What follows are my current thoughts on the matter. I will continue with my effort to port into <nowiki>MediaWiki</nowiki> as an experiment, and if someone has some compelling reason to choose something else then Ian can make the choice.

:After doing a bit of research, my choice for porting <nowiki>MediaWiki</nowiki> to a new Wiki platform is still <nowiki>MediaWiki</nowiki>. Here is why:

: * It's standard. This precludes "why didn't you use something more standard" arguments.
: * Just about anyone can jump in to help administer it, not so with fringe alternatives.
: * The core and extensions are well maintained by hundreds of people, eliminating the problem of porting to software that later dies through lack of interest, as is the case with many FOSS projects.
: * There are a wealth of extensions, enabling us to respond with new features.
: * Arguments against <nowiki>MediaWiki</nowiki> are not compelling and most of them seem to be a few years old. When asked "why <nowiki>MediaWiki</nowiki>", I'd have to respond "why not?".
: * Porting to another platform can result in questions like "why doesn't this work" or "what happened to that?" Our chances of resolving these issues quickly with MediaWiki are much better than with other platforms.

:One problem we want to resolve is the need to use "weird" syntax in page edits:

:People want to contribute content without learning a new language to do it. Unfortunately options for WYSIWYG editors for any wiki are limited. Most wiki have no WYSIWYG. So by definition, content management with wiki almost always requires some knowledge of wiki syntax. However, <nowiki>MediaWiki</nowiki> has about four WYSIWYG options. Only one of them, [http://mediawiki.fckeditor.net/ FCKEditor] (another popular standard), is cross-browser, not considered experimental, and is actively developed/maintained. Therefore, my implementation of <nowiki>MediaWiki</nowiki> would include FCKEditor.

:No WYSIWYG tools support the full range of wiki features. Instead of "what you see is what you get", the reality today is more like "what you get is close to what you mean but not necessarily what you thought you were going to see". Refinement and using special features will require some knowledge of wiki syntax which can be added by putting the editor in raw mode.

:Summary

:No solution is perfect. <nowiki>MediaWiki</nowiki>, FCKEditor, and all of these related FOSS tools have their faults. But the proposed solution is still better than what we have now. This project is defined as being nothing more than a wiki web site, not a CMS where we might choose [http://drupal.org/ Drupal] or [http://www.joomla.org/ Joomla], and not a documentation site where we might choose [http://www.dokuwiki.org/dokuwiki DocuWiki]. <nowiki>PickWiki</nowiki> is not funded or corporately sponsored, and not maintained by people who have a lot of free time. In this limited scope and with consideration for easy maintenance and ease of use by the intended audience, <nowiki>MediaWiki</nowiki> seems to be the proper choice for this site.
----

== More Q&A ==
* When is this happening?
** An environment is currently in test mode. Testing will continue as time permits, as long as required. Expect to see a test site by February 2010 and a new live site by March 2010.
* Can we see the new site before it goes live?
** We'll open the test site for UAT (User Acceptance Testing) when we've eliminated the initial conversion issues. People will be welcome to beat up the new environment before we relocate it back here to <nowiki>PickWiki</nowiki>.com.
* Will our existing user IDs be preserved?
** We're not sure yet.
* What features will be available?
** The site will have a minimal set of extensions to reduce complexity and maintenance, but suggestions are welcome for must-have features.
** Initially the focus will be on:
*** ease of editing
*** visual appeal (without glitz)
*** security
*** elimination of spam, graffiti, and other abuse
*** searchability with categories, tags, etc
*** ability for people to comment without posting content (this is actually a feature built-in to <nowiki>MediaWiki</nowiki> with <nowiki>Talk/Discussion</nowiki> pages but we'll try to ensure that people can effectively collaborate on content
* Will history of changes be preserved?
** (From Ian) With any transition, it would be nice to convert history, not just the existing content: http://www.mediawiki.org/wiki/Manual:Importing_external_content
** We'll try to ensure that all revision history is maintained but we can't guarantee it. Let's assume that the new site will move forward from the conversion date with no history, and that any history will be a nice bonus.
* What if I don't like <nowiki>MediaWiki</nowiki>?
** Please propose an alternative and provide some good reasoning.
* Can I recommend other features?
** Sure, post ideas here or email Tony, Ian, or Rex.
* How can I help?
** Share your thoughts.
** Post content.
** Find links to web pages with content that should be included here.
** Spend a few minutes beating up on the test site when we open it up.

NewWikiIdeas

2010-01-07T21:29:17Z

TonyG: Moved content to MoveToMediaWiki

NewWikiIdeas

2010-01-07T21:19:27Z

TonyG: Announce MediaWiki initiatives

= Ideas for new Wiki software for <nowiki>PickWiki</nowiki>.com =

= Alternatives =

* http://www.mediawiki.org/wiki/MediaWiki is the software that powers Wikipedia.
* [http://www.dokuwiki.org/dokuwiki DocuWiki]
* Comparisons of many wiki packages: [http://www.wikimatrix.org/ WikiMatrix.org]
* Google search for [http://www.google.com/search?q=wiki+comparison wiki comparison]s
* Google search for [http://www.google.com/search?q=mediawiki+alternatives mediawiki alternatives]

= We're moving to <nowiki>MediaWiki</nowiki>! =

A decision has been made to move this environment to <nowiki>MediaWiki</nowiki>. That decision isn't carved in stone, but we've already created a new wiki environment which is now in test mode. All data has been ported there. Ian, Rex, and Tony are now identifying what didn't convert properly. We'll probably write small BASIC utilities to zap the data as required so that it fits with <nowiki>MediaWiki</nowiki>.

== Why <nowiki>MediaWiki</nowiki>? ==

(A note from Tony Gravagno to Ian <nowiki>McGowan</nowiki> and Rex Gozar, now shared with <nowiki>MediaWiki</nowiki> visitors.)
----
:I was encouraged to look into alternatives to <nowiki>MediaWiki</nowiki>. What follows are my current thoughts on the matter. I will continue with my effort to port into <nowiki>MediaWiki</nowiki> as an experiment, and if someone has some compelling reason to choose something else then Ian can make the choice.

:After doing a bit of research, my choice for porting <nowiki>MediaWiki</nowiki> to a new Wiki platform is still <nowiki>MediaWiki</nowiki>. Here is why:

: * It's standard. This precludes "why didn't you use something more standard" arguments.
: * Just about anyone can jump in to help administer it, not so with fringe alternatives.
: * The core and extensions are well maintained by hundreds of people, eliminating the problem of porting to software that later dies through lack of interest, as is the case with many FOSS projects.
: * There are a wealth of extensions, enabling us to respond with new features.
: * Arguments against <nowiki>MediaWiki</nowiki> are not compelling and most of them seem to be a few years old. When asked "why <nowiki>MediaWiki</nowiki>", I'd have to respond "why not?".
: * Porting to another platform can result in questions like "why doesn't this work" or "what happened to that?" Our chances of resolving these issues quickly with MediaWiki are much better than with other platforms.

:One problem we want to resolve is the need to use "weird" syntax in page edits:

:People want to contribute content without learning a new language to do it. Unfortunately options for WYSIWYG editors for any wiki are limited. Most wiki have no WYSIWYG. So by definition, content management with wiki almost always requires some knowledge of wiki syntax. However, <nowiki>MediaWiki</nowiki> has about four WYSIWYG options. Only one of them, [http://mediawiki.fckeditor.net/ FCKEditor] (another popular standard), is cross-browser, not considered experimental, and is actively developed/maintained. Therefore, my implementation of <nowiki>MediaWiki</nowiki> would include FCKEditor.

:No WYSIWYG tools support the full range of wiki features. Instead of "what you see is what you get", the reality today is more like "what you get is close to what you mean but not necessarily what you thought you were going to see". Refinement and using special features will require some knowledge of wiki syntax which can be added by putting the editor in raw mode.

:Summary

:No solution is perfect. <nowiki>MediaWiki</nowiki>, FCKEditor, and all of these related FOSS tools have their faults. But the proposed solution is still better than what we have now. This project is defined as being nothing more than a wiki web site, not a CMS where we might choose [http://drupal.org/ Drupal] or [http://www.joomla.org/ Joomla], and not a documentation site where we might choose [http://www.dokuwiki.org/dokuwiki DocuWiki]. <nowiki>PickWiki</nowiki> is not funded or corporately sponsored, and not maintained by people who have a lot of free time. In this limited scope and with consideration for easy maintenance and ease of use by the intended audience, <nowiki>MediaWiki</nowiki> seems to be the proper choice for this site.
----

== More Q&A ==
* When is this happening?
** An environment is currently in test mode. Testing will continue as time permits, as long as required. Expect to see a test site by February 2010 and a new live site by March 2010.
* Can we see the new site before it goes live?
** We'll open the test site for UAT (User Acceptance Testing) when we've eliminated the initial conversion issues. People will be welcome to beat up the new environment before we relocate it back here to <nowiki>PickWiki</nowiki>.com.
* Will our existing user IDs be preserved?
** We're not sure yet.
* What features will be available?
** The site will have a minimal set of extensions to reduce complexity and maintenance, but suggestions are welcome for must-have features.
** Initially the focus will be on:
*** ease of editing
*** visual appeal (without glitz)
*** security
*** elimination of spam, graffiti, and other abuse
*** searchability with categories, tags, etc
*** ability for people to comment without posting content (this is actually a feature built-in to <nowiki>MediaWiki</nowiki> with <nowiki>Talk/Discussion</nowiki> pages but we'll try to ensure that people can effectively collaborate on content
* Will history of changes be preserved?
** (From Ian) With any transition, it would be nice to convert history, not just the existing content: http://www.mediawiki.org/wiki/Manual:Importing_external_content
** We'll try to ensure that all revision history is maintained but we can't guarantee it. Let's assume that the new site will move forward from the conversion date with no history, and that any history will be a nice bonus.
* What if I don't like <nowiki>MediaWiki</nowiki>?
** Please propose an alternative and provide some good reasoning.
* Can I recommend other features?
** Sure, post ideas here or email Tony, Ian, or Rex.
* How can I help?
** Share your thoughts.
** Post content.
** Find links to web pages with content that should be included here.
** Spend a few minutes beating up on the test site when we open it up.

CSV2ARRAY

2009-12-20T00:12:25Z

TonyG: Added See Also and tags

HomePage>>SourceCode>>BasicSource>><nowiki>CSV2ARRAY</nowiki>

This is a tool to convert a CSV file to a dynamic array.

''Background''
:The main goal of this tool is to provide a good conversion from ''CSV''. This is a Microsoft file format commonly used for ''flat file'' data exchange (until people start using XML universally). I have found many different bits and pieces around to convert CSV, most of which don't handle the possibilities of CSV or do the conversion badly.

:The program was designed for UV as a ''function'' requiring a ''csv document'' and input ''arguments'' and returns a result ''value'', and sets ''status()'' if conversion fails. It means it can be easily called from basic or an I-type subr() statement. See the comments in the code for examples and details of methods and the arguments required.

<PRE>
function CSV2ARRAY(doc,opts)
* function to convert a csv to an array
* 1.0 23-Jul-2007 stuart boydell - Original
*
* doc: csv document
* line breaks in cells get converted to subVal marks (@sm)
* nb. U2 autoconverts char(10) / char(13) to normalised (nix/win) crlf - so best to get your csv raw.
* opts: 'N' returns a normalised dynamic array // eg orthagonal to excel: columns to attributes, cells to values
*

equ E.PROG.NAME to 'CSV2ARRAY',
E.VERSION to '1.0',
E.COMMA to ',',
E.QUOTE to '"',
E.WINCRLF to char(10):char(13) ;*// CSV is usually produced by a win program - so parse win crlf

returnValue = oconv('','c') ;*// set RV to '' and status() function to false
occurs = 1

lmx = maximum(counts(doc,E.COMMA)) ;*// <<TODO>> incomplete use of these in normalisation
lmn = minimum(counts(doc,E.COMMA))

doc = change(doc,E.WINCRLF,@am) ;*// crlf to @am
doc = convert(E.COMMA:char(10),@vm:@sm,doc) ;*// commas to vm // char(10) to sm (manual cell breaks alt-enter)

loop while findstr E.QUOTE in doc,occurs setting a,v do
docLine = raise(doc<a>)
newDocLine = ''
max = dcount(docLine,@am)
for i = max to 1 step -1
cell = docLine
if cell[1] = E.QUOTE then
*// make sure commas are replaced // should be an even number of quotes per cell
loop while cell[1,1] # E.QUOTE and mod(count(cell,E.QUOTE),2) and i > 0 do
i -= 1
cell = docLine:E.COMMA:cell
repeat
if cell[1,1] = E.QUOTE and cell[1] = E.QUOTE then
cell = cell[2,len(cell)-2]
end
cell = change(cell,str(E.QUOTE,2),E.QUOTE)
end
if len(newDocLine) then
ins cell before newDocLine<1>
end else
*// deal with inserting '' into empty array.
if i = max-1 and cell = '' then newDocLine = @am else newDocLine = cell
end
next i
occurs += count(newDocLine,E.QUOTE)
doc<a> = lower(newDocLine)
repeat

if opts = 'N' then ;*// do mv normalisation
max = dcount(doc,@am)
newDoc = raise(doc<1>)
if count(newDoc,@am) < lmx then newDoc<lmx+1> = ''
for i = 2 to max
newDoc = splice(newDoc,char(222),raise(doc))
next i
doc = convert(char(222),@vm,newDoc)
end
opts = err
returnVal = doc
return(returnVal)
end
</PRE>

HomePage>>SourceCode>>BasicSource>><nowiki>CSV2ARRAY</nowiki>

== See Also ==

Web page devoted to CSV processing: [[CSV]]

----

[[Tags]]: excel google docs openoffice calc csv comma-delimited tab-delimited spreadsheet worksheet

CSV

2009-12-19T19:52:32Z

TonyG: New page

( New page needs more content )

= Creating, Parsing, Importing, and Exporting CSV files =
It's tempting to lump CSV files and Excel together but this delimited file format is used by many other applications as well. Almost every MV developer will be asked to import or export a CSV file in his/her career.

== Creating CSV files ==
A CSV file is commonly either comma-delimited or tab-delimited. There actually is no official spec for CSV files, what gets quoted, how quotes or carriage returns are embedded in an element, etc. There are only accepted standards.

Add references to CSV creation code/techniques here

== Parsing CSV files ==

To parse from a CSV file to a dimensioned or dynamic array, a few utilities are available - see each one and feel free to comment here on quality, suitability, etc.

* [[CSV2ARRAY]]
* http://home.primus.ca/~lxp/prog.convert.from.csv.htm
* http://groups.google.com/group/comp.databases.pick/browse_frm/thread/b1ee5c93580758e4/c406cbf83f54d7d8

== Importing and Exporting CSV files ==
All MV environments support an interface to the host file system. With D3 this is an OSFI DOS: reference with a path. In U2 this would be a type 1 or type 19 file. In other platforms one would use a DIRECTORY file. The easiest way to import or export CSV, like any text file, is simply to open the directory containing (or to contain) the file using your MV-specific interface, then just read/write the item like any other.

From there most people wonder how they get that data into Excel (or another application), or how they get data from Excel (or another application into CSV in the first place. There are innumerable tools for import/export of CSV with various products. Many products will open a CSV natively, or save CSV as an option. In other cases conversion utilities are available. See [http://www.google.com/search?q=excel+to+csv+php this google link] for Excel to CSV tools, and use similar queries to find something that suits your needs. A freeware tool for exporting multiple Excel spreadsheets (tabs) from a workbook is provided at http://Nebula-RnD.com/freeware/.

== See Also ==
ConnectToMicrosoftExcel

----

[[Tags]]: excel google docs openoffice calc csv comma-delimited tab-delimited spreadsheet worksheet

ConnectToMicrosoftExcel

2009-12-19T19:25:30Z

TonyG: Added tags and See Also

== Exporting data from MV to Excel ==
* Create a CSV or other Tab-Delimited file. When a .csv file is opened with Excel you'll get a basic set of columns and rows.
* Use the AccuTerm FTD utility to import and export with .xls files. AccuTerm also has [http://www.asent.com/code.html samples] to use Excel formulas to access MV. See
* [http://nebula-rnd.com/products/xlite.htm <nowiki>NebulaXLite</nowiki>] allows creation of rich documents from BASIC, compared to plain data in cells.

== Importing data from Excel to MV ==
* As above, see AccuTerm.
* See [http://nebula-rnd.com/blog/tech/2007/11/excel-to-mv1.html this blog entry] for discussion of a possible future product as well as code to integrate Excel with MV via a web service: Search the blog for notes about integration with Microsoft Office applications like Outlook.

== Direct Connectivity vs import/export ==
This can be accomplished with any connectivity code and Microsoft Office add-ins. Look into Microsoft VSTO (Visual Studio Tools for Office) to create the Excel integration piece. Other methods can be used such as XLAs or VBA macros. Excel development is a field unto itself. Use tools like [[UniObjects|UniObjects.NET]], [[mv.NET]], or <nowiki>ON.NET</nowiki> to do the actual connectivity directly into MV. For clients outside of the intranet, create the add-in with a web service interface and connect into any MV platform using standard web service methods. (TG)

== See Also ==
There are various solutions on this site for converting Excel to CSV and parsing CSV to dynamic or dimensioned arrays.

== Misc discussions ==
http://groups.google.com/groups?hl=en&q=group:comp.databases.pick+excel

----

[[Tags]]: excel csv spreadsheets

InMemoriam

2009-09-28T07:56:50Z

TonyG: *

For some time now I've felt that there needed to be a place to record our memories of and the contributions of those Pick community members that are no longer with us.
The [http://www.microdata-alumni.org/ Microdata Alumni] web site has a page for departed members of that community but I wanted to cast a wider net.

So this seems to be the most appropriate place to start this collective memory.

I will seed this list with the individuals that come to mind and fill in details as I have time. Please join me in adding to this list and updating the individual pages if you have something to contribute.

In Memoriam:
*[[DickPickMem|Dick Pick]]
*[[DonNelsonMem|Don Nelson]]
*[[KenSimmsMem|Ken Simms]]
*[[DennisAulerMem|Dennis Auler]]
*[[BrunoBenincaMem|Bruno Beninca]]
*[[JeffBurslemMem|Jeff Burslem]]
*[[MikeGanzMem|Mike Ganz]]
*[[CliffMyersMem|Cliff Myers]]
*[[BruceNicholMem|Bruce Nichol]]
*[[BillThurmanMem|Bill Thurman]]
*[[JohnTimmonsMem|John Timmons]]
*[[HenryVuMem|Henry Vu]]
*[[DaveWeaverMem|Dave Weaver]]

* Rather than being a collection of technotes, PickWiki was originally created by [[Ian McGowan]] as a repository for anecdotes about the history of the Pick DBMS. Please feel free to add notes, or links to forum postings or web pages to help build this unique resource. See also: ColorfulCharacters
* Except for Dick, Don, and Ken, I alphabetized the names on this page. Please let me know if there is any disagreement about this. (TG)

HenryVuMem

2009-09-28T07:52:54Z

TonyG: New page

Henry Vu was a fine engineer at Pick Systems and a friend to all who worked with him. He and his wife Tammy were killed in a car accident in 1999.

[http://groups.google.com/group/comp.databases.pick/browse_frm/thread/472f7b5f04ccf2fd notes] from John Bramley at Pick Systems at the time of Henry's passing

DaveWeaverMem

2009-09-28T07:48:28Z

TonyG: New page

Dave Weaver was a long time VAR and friend to many in the community.
Please feel free to post notes here about him.

* [http://groups.google.com/group/comp.databases.pick/browse_frm/thread/ddf0c6b824e16ab forum announcement] at the time of his passing

DonNelsonMem

2009-09-28T07:45:41Z

TonyG: New page

Notes about Don Nelson of TRW, one of the co-creators of the "Pick" DBMS model

* [http://groups.google.com/group/comp.databases.pick/browse_frm/thread/d6e8f30a48676786 couple notes] by Henry Eggers
* [http://groups.google.com/groups/search?hl=en&ie=UTF-8&q=group%3Acomp.databases.pick+%22don+nelson%22 here] is a link to a Google search of CDP for anything related to Don Nelson. It would be nice if someone could find some significant notes and post them or links to them here. Thanks.

BruceNicholMem

2009-09-28T07:34:44Z

TonyG: New page

In memory of Bruce Nichol of Talon Computer Services

[http://groups.google.com/group/comp.databases.pick/browse_frm/thread/76810c1565f2b84a forum posting] at the time of his passing

DickPickMem

2009-09-28T06:55:06Z

TonyG: Started collection of links

http://www.microdata-alumni.org/images/early_dp_200.jpg

People are welcome to post text or links to text with anecdotes about Dick Pick:
* [http://groups.google.com/group/comp.databases.pick/browse_frm/thread/24890c60a96e8a62 forum notes] from Kevin Nelson and Henry Eggers about the tribute get-together after Dick's passing
* [http://groups.google.com/group/comp.databases.pick/browse_frm/thread/9fafeeaa9b95de79 forum posting] from Simon Meth a couple days after Dick's passing
* [http://groups.google.com/group/comp.databases.pick/browse_frm/thread/385d199a369dc087 notes] from Jon Sisk, and various links including the infamous picture of dick on the inversion table (frequently referred to as the gravity boots)

TerminalEmulators

2009-09-06T18:41:00Z

TonyG: Added HostAccess

== Common Terminal Emulators used in the MV market ==
* AccuTerm - <nowiki>AccuSoft</nowiki> Enterprises http://asent.com/ (Pete Schellenbach, owner)
* Anzio - Rasmussen Software http://anzio.com/products/anziowin.htm (Bob Rasmussen, owner)
* MVTerm - For mvBase only http://www.rainingdata.com/products/dbms/mvb/index.html
** Why the heck is this listed as a [http://appdb.winehq.org/appbrowse.php?catId=25 WINE app]?
** Training? http://www.mvbase.com/
* SBTerm - Comes with SB+ (SystemBuilder) U2-only http://www-01.ibm.com/software/data/u2/sb/
* ViaDuct FX - Via Systems http://www.viasystemsinc.com/external/Viaduct.htm
* Winnix - http://winnix.com (Only one (?) that runs as GUI on PDA with Windows Mobile/CE)
* Wintegrate - http://www-01.ibm.com/software/data/u2/wintegrate/

Almost never referenced anymore:
* Carnation for Mac - http://www.carnationsoftware.com/
* <nowiki>HostAccess</nowiki> - http://en.wikipedia.org/wiki/Rogue_Wave_(company)

Work just fine, but without MV specific features, and usually just vt100 support
* Putty - http://google.com/search?btnI=1&q=putty. Free!
* Powerterm - http://www.ericom.com/clientbased.asp. Nice scripting language.

If you are still using telnet as a protocol for these emulators, it's time to join the 21st Century and make the jump to [http://en.wikipedia.org/wiki/Secure_Shell Secure Shell]

MigrateD3toQM

2009-07-21T19:09:17Z

TonyG: Link back to MigratePickToPick

Notes here are intended to help developers and end-users with migration from D3 to QM.

= Code changes required/recommended =
* See this discussion regarding ICONV: http://groups.google.com/group/OpenQM/t/6fe6477c3def5d24

= Options and Modes to make QM behave more like D3 =
...

= Verb differences, alias assignments =
...

= Connectivity =
* D3 class library vs QMClient
* FlashCONNECT vs Coyote
* OSFI vs QMNet (not the same as QMClient.NET)

= Handling Case Sensitivity =
...
= New functionality one can expect in QM =
* Optional object-oriented BASIC

----
[ MigratePickToPick index ]

MigratePickToPick

2009-07-21T19:06:54Z

TonyG: New page

Add notes here of a general nature regarding MV/MV migrations.

For platform-specific details, see the following:
* MigrateD3toQM (Use headers on this page as a template for others)
* MigrateD3toCache (Doesn't yet exist - create it if you're inspired)
* MigrateUnidataToUniverse (Doesn't yet exist - create it if you're inspired)
* MigrateUniverseToReality (Doesn't yet exist - create it if you're inspired)
* MigrateRealityToD3 (Doesn't yet exist - create it if you're inspired)
* Migrate... add any XtoY or XxToYy platform here

SendAnEmail

2009-06-25T20:53:28Z

TonyG: Added link to U2 forum discussion

Was there some old content for this page?

The following utilities have all been recommended in MV forums for e-mailing from MV BASIC. Most of these are not Pick-based programs, so the general approach is to EXECUTE "!command " : OPTIONS in order to send your email. Some software is for free, some for fee, and quality often varies completely independent of the cost. If you know of other options, please update this list.

Since we're here, note that e-mailing to a cell/mobile phone is not the same as SMS. Lookup SMS in a search engine for details.

== Under Unix ==
* Sendmail
* Mutt http://www.mutt.org/

== Under Windows ==
* BLAT 
** http://sourceforge.net/projects/blat 
** http://www.blat.net/
* <nowiki>PixieRobot</nowiki> http://www.pixieware.com/databyemail.htm
* <nowiki>ActiveFax</nowiki> (for fax and e-mail) http://www.actfax.com/
* Ask about Visage.Emailer: http://www.stamina.com.au
* <nowiki>PrintWizard</nowiki> http://www.anzio.com/
* <nowiki>NebulaMail</nowiki> http://nebula-rnd.com/products/mail.htm
* <nowiki>PicLan</nowiki>-IP Mail Server http://piclan.com/over-mail.htm
* Postie http://www.infradig.com/ (Shareware, author site is erratic, try [http://www.brothersoft.com/postie-10818.html here])

== Retrieving e-mail : POP3 / IMAP ==
* http://pages.interlog.com/~tcharron/getmail.html
* <nowiki>NebulaMail</nowiki> http://nebula-rnd.com/products/mail.htm
* Postie http://www.infradig.com/
* http://fetchmail.berlios.de/
* Forum discussion [http://listserver.u2ug.org/pipermail/u2-users/2009-June/000361.html here]

Since fax is mentioned above, another utility used for fax with MV is [http://www.esker.com/products/fax_software_unix.asp VSI-FAX]

= Usage Examples ==
== Examples for Unix, sendmail and others ==
WRITE MAIL.BODY ON DIR.F, "MAIL"
EXECUTE "!mail -s test user@domain.com < /path/to/dir.f/MAIL"
* [http://groups.google.com/group/comp.databases.pick/browse_frm/thread/9ee197e923cc730a/9a3ae5a4e71762a0?hl=en&ie=UTF-8&q=group:comp.databases.pick+Infinetivity sendmail example] provided by Jeff Kaufman in CDP
* Another [http://groups.google.com/group/comp.databases.pick/msg/9b8b565ec6645fa4?hl=en sendmail example] by Glen Batchelor

From Frank Winans
OPEN "unix:/tmp" to F.TMP else stop 'tmp'
BODY = "HELLO" :@AM:"LINE TWO OF EMAIL"
WRITE BODY ON F.TMP,'foo.txt'
CMD = "!cat /tmp/foo.txt | mail "
CMD := " -s 'my email subject' "
CMD := " someb...@somewhere.com"
CMD := " ; rm /tmp/foo.txt"
EXECUTE CMD CAPTURING BUCKET

== Examples for Windows ==
=== Blat ===
* [http://groups.google.com/group/comp.databases.pick/browse_frm/thread/40ca166c488cf608 Full code] from Ricky Ginsburg
* [http://groups.google.com/group/comp.databases.pick/browse_frm/thread/426ec51416b7e9f4 Another code base] from Robert Uiterwyk
* Brian Leach posted a note [http://212.241.202.162/cms/cmsforum.wsp?action=topic&forum=6&topic=171 here] that shows how to send with BLAT, and also shows how to create a direct verb pointer.

UserGroups

2009-06-17T14:43:27Z

TonyG: Add DMUG, OPUG, TigerLogic Nov-09 Conference

In the past there were many Pick / MV groups. Many are now defunct. Over time those groups have given way to more product-specific groups, focused on each specific DBMS, specific connectivity tools, and specific business applications.

The prevalence of online communities in the form of web discussion may have helped contribute to the demise of monthly/quarterly personal get-togethers. A list of MV-centric online discussion forums is on the [[Community]] page.

== Industry ==
* International Spectrum http://www.intl-spectrum.com/

== Live Regional DBMS Groups ==
* SAPUG - The Seattle Area <nowiki>Pick/Unix</nowiki> Group http://www.sapug.org/Welcome.php
* TEXMUG Texas Multi-value User Group http://www.texmug.org/
* CMUG - Colorado Pick Users Group http://cmug.plaxogroups.com/ (Plaxo site requires registration)
* DMUG - Germany https://www.xing.com/app/network?op=home;tab=1;name=dmug (Xing site requires registration) (New Group)
* OPUG - Ohio http://groups.google.com/group/opugmail?hl=en (New Group)

== Live Product-specific Groups (DBMS and Tools) ==
* International UniVerse and Unidata User Group http://u2ug.org
** IBM has at least three worldwide events for U2 users: http://212.241.202.162/cms/cmsview.wsp?id=68
** Anything regional?
* InterSystems
** Several online forums and local groups http://www.intersystems.com/cache/devcorner/index.html
** Worldwide (<nowiki>DevCon</nowiki>) conferences http://www.intersystems.com/events/index.html
* Revelation / OpenInsight
** [http://revelation.com/revelation.nsf/byTitle/User+Group+Homepage?OpenDocument groups] (BARUG, HARUG, DARUG, etc)
** <nowiki>SoCalRUG</nowiki> - Southern Calif Revelation User Group http://www.srpcs.com/rev_socalrug.aspx
* jBase may have semi-annual worldwide conferences [http://www.jbase.com/news/user_conference.html 2007 recap]
* TigerLogic will have a worldwide conference in November 2009 Watch [http://www.rainingdata.com/news/index.html this page] for details.

== Live Application-specific Groups (Business software) ==
* Columbia Ultimate Business Systems (CUBS) http://www.columbiaultimate.com/events/cuusers_con.aspx
* Datatel http://www.datatel.com/events.cfm
* SHIMS?
* Epicor / Avante / Dataflo <nowiki>ManFact</nowiki> http://www.epicor.com/Customers/Pages/UserGroups.aspx

== Inactive or Completely Gone ==
* AAPUG - Atlanta Area Pick Users Group http://www.aapug.org/
* CPUG - Chicago Pick Users Group
* CDBMA - California Data Base Management Association
* Nevada Multi-Value User Group
* Northern California Pick Users Group http://www.ncpu.org/
* OSDA - Open Systems Database Association http://www.osda.org/ (website up, group is disolved)
* <nowiki>TigerLogic Corp</nowiki> has a very [http://www.rainingdata.com/news/usergroups/index.html old and invalid list] of Pick User Groups. If anything on that list is active, please update this page.

== Miscellaneous Groups ==
* Microdata Alumni http://www.microdata-alumni.org/
* A growing group of ex-employees of Pick Systems / Raining Data / TigerLogic meets semi-regularly for dinner in Orange County on the first Tuesday of each month. Contact TonyG for details.

Triggers

2009-06-11T16:26:19Z

TonyG: New page

New page needs content

Yes, Pick/MultiValue DBMS platforms support database triggers. A trigger is a BASIC subroutine that is executed when the database is accessed for Read or Write operations.

All MV platforms support triggers differently but in short you usually need to globally catalog a BASIC subroutine and then somehow register it so that the system knows that it exists.

Links to forum discussions and articles should be added below.

== D3 ==
See product documentation.

== Caché ==

== Reality ==
International Spectrum Magazine [http://www.intl-spectrum.com/mag/MARAPR.2008/default.aspx article]

== Unidata ==

== Universe ==
Search for triggers in [http://www.google.com/search?q=site%3Ahttp%3A%2F%2Fwww.mail-archive.com+u2+trigger U2 Users Forum]

International Spectrum Magazine [http://www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx article]

Is this valid? : http://www.indexinfocus.com/dl/u2list/200207/35152.html

AccessFromPhp

2009-06-10T06:39:43Z

TonyG: Added link to pfinders.com

[http://sourceforge.net/project/showfiles.php?group_id=16418 java d3] : in fact this opensource library offers client program and server program (in Pick BASIC for D3 right now).
The first section is a collection of D3 programs that make up a socket server. The second section is devoted to client programs that can call this server. There are currently working clients for Java, PHP, COM, C#, and Python.

[http://forums.rainingdata.com/index.php?showtopic=869&st=0&#entry2591 This forum posting] includes source to access D3 from PHP using FlashCONNECT. However the server can be any process that returns a delimited string, the connectivity can be any valid pipe. So you can use the same technique to access jBase with REST, U2 with a WebService and UniObjects ... any technology of your choice.

[[Accessing U2 from PHP]] is U2-specific, but as with the above the same techniques, and code to a great extent, can be used with any MV environment.

Web Application Server: PHP to D3 : http://www.pfinders.com/phptod3/