| T O P I C R E V I E W |
| Henrik |
Posted - Apr 26 2007 : 07:24:46
I am just planning to use MLK, with web based subscription handling for users.
On such a web page I wish to list al the avaialable groups for subscription.
I wonder how a PHP code can collect the list of groups.
1. Groups seems to be stored in binary files, hard to extract...
2. The only user method I know is via email request ("SubscribeInfo"), which triggers the answer in a sent email.
Any suggestion how to list groups on web page ?
Thanks
Henrik |
| 8 L A T E S T R E P L I E S (Newest First) |
| justuspost |
Posted - May 04 2007 : 14:34:32
You may be able to dynamically generate the available user groups in this fashion, ODBC or having MLK write an update file, but this will ONLY make available the list names. This will not put the names into a user friendly form or allow a mail form to process them. If you plan to make available user friendly names for the groups, this will need to be scripted manually. Realistically I can't imagine that it will be often that one would be adding a group or rather often enough that it would matter.
Being dynamic in this case means that MLK, web page and script will need to be in sync. This is not difficult if the values are consistent, but if you would like some kind of presentation, there will be manual updating involved.
The one resolve for this would be for MLK to allow an alias or c-name for group names. I think that it would even be acceptable to require "" around the name for MLK to process an alias being that most of these will be sent via scripts and it would be easy to strip "" from a name being dynamically displayed on a web page.
Justus
|
| xequte |
Posted - May 04 2007 : 00:03:29
Hi Henrik
The ODBC driver is only sent as requested. So please email sales@xequte.com after your purchase goes through.
Nigel
Xequte Software
nigel@xequte.com |
| Henrik |
Posted - May 03 2007 : 07:53:30
Hello Nigel,
Purchase of business version is sent to Xequte by email (I hope I get my key soon).
I am looking forward to the ODBC driver.
Henrik
Henrik |
| xequte |
Posted - May 03 2007 : 06:00:38
Hi Henrik
There are instructions sent with the ODBC driver (available after purchasing the Business version). Essentially it allows any other database engine to directly read the MLK mailing list database.
A CSV file you are seeing is probably just a text back of your database.
Another way I have heard of a user generating the group list "dynamically" (and also remotely) involved parsing the response to a GroupInfo command.
We could also consider having MLK write an up-to-date copy of the group list to a plain text file.
Nigel
Xequte Software
nigel@xequte.com |
| Henrik |
Posted - May 02 2007 : 06:56:55
quote:
Originally posted by xequte
Hi Henrik
Another option if your MLK database is accessible from your web server is to use ODBC to directly read the MLK database.
Note: You need the Business version to use ODBC.
Nigel
Xequte Software
nigel@xequte.com
Hello Nigel,
Will I find guiding in docs on how to set up this ODBC? Which file/DB it should be pointing at? If not in docs, can you reply this?
I do not remember seeing it in users guide, and upon install we seem to have just a CSV file - can it be ODBC accessed?
Thanks,
Henrik
Henrik |
| Henrik |
Posted - May 02 2007 : 06:53:41
quote:
Originally posted by justuspost
What I have done in this situation is to write a php mail script that when the form is filled out, the info is mailed to an address that MLK checks. it is formatted in such a way that MLK can read it and follow a certain action.
If you want the groups on a page, you can simply have a list/dropdown/checkboxes of user friendly names for them to select. Then once the form is submitted, php will take that value and send it to mlk formatted however you need to subscribe them to that/those groups.
Justus
Hello Justus,
Thanks for the comment. However it does not solve my problem of having DYNAMIC list of groups: whenever the MLK admin adds a new group in MLK, it should appear on the webpage as one of the selectable groups. A static webform cannot do this. The next reaction about the ODBC solution may solve this.
Bye,
Henrik
Henrik |
| xequte |
Posted - Apr 29 2007 : 01:08:32
Hi Henrik
Another option if your MLK database is accessible from your web server is to use ODBC to directly read the MLK database.
Note: You need the Business version to use ODBC.
Nigel
Xequte Software
nigel@xequte.com |
| justuspost |
Posted - Apr 27 2007 : 16:14:41
What I have done in this situation is to write a php mail script that when the form is filled out, the info is mailed to an address that MLK checks. it is formatted in such a way that MLK can read it and follow a certain action.
If you want the groups on a page, you can simply have a list/dropdown/checkboxes of user friendly names for them to select. Then once the form is submitted, php will take that value and send it to mlk formatted however you need to subscribe them to that/those groups.
Justus |
