Gammon Forum : MUSHclient : Plugins : Calendar

Entire forum ➜ MUSHclient ➜ Plugins ➜ Calendar - todo list, events

Calendar - todo list, events

It is now over 60 days since the last post. This thread is closed. Refresh page

Pages: 1 2 3

Posted by

Linda Sweden (164 posts) Bio

Date

Reply #15 on Fri 15 Nov 2002 09:53 PM (UTC)

Message

I'll try that, although my ISP time is almost up so I'll have to wait on reporting back until tomorrow.

Top

Posted by

Nick Gammon Australia (23,166 posts) Bio Forum Administrator

Date

Reply #16 on Fri 15 Nov 2002 10:02 PM (UTC)

Message

OK, good luck. In anticipation of this working I have added the appropriate links to the plugins page (the download for VBscript and ADO).

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

Posted by

Linda Sweden (164 posts) Bio

Date

Reply #17 on Sat 16 Nov 2002 04:55 PM (UTC)

Amended on Sat 16 Nov 2002 05:58 PM (UTC) by Linda

Message

Okay, installed the MDAC 2.5 thing, and now I am not crashing. However, upon reinstalling the plugin, I don't get any of the messages that should show up and if I try to type 'events' it tells me it can't find the file 'C:\MUSH\MushClient\Worlds\calendar.mdb'.

Maybe something is left over from the old install, and preventing a full new install?

Update: Hrm, okay, the calendar install worked in one world, so now the db is there for all worlds to use. The only thing that I know for sure is different between the two worlds, however, is that the one it worked in has pueblo/mxp enabled.

Btw, is it possible for me to edit the plugin to change the date format? American dating (m/d/y) confuses me entirely. ;)

Top

Posted by

Shadowfyr USA (1,791 posts) Bio

Date

Reply #18 on Sat 16 Nov 2002 06:10 PM (UTC)

Message

This is what make me nervous about using Microsoft.Jet.OLEDB.4.0 as the provider field without first having some why to make sure that v4.0 is installed and more importantly, that the Access driver is installed. Most programs that support databases include a copy of ODBC and the needed driver 'just in case' it is not up to date or the needed driver isn't installed on your machine. Also, looking at one of the script, it seems that while we check to see if the database exists, the script doesn't bother to verify that it was actually sucessfully created. This is not a good idea, since it not only doesn't inform you if the type of file you tried to create is unavailable or that it failed.

It could be that for some reason installing the MDAC 2.5 was only enough to give you access to creation, but that the ODBC drivers are still missing (I thing ODBC is a seperate package). If you go into the systems control panel and ODBC is in fact installed, there 'should' be a ODBC control panel in there. This is supposed to be part of the standard Windows install and should even more definitely be there if the machine has word, excel, access, etc. on it, but... Who knows how some of these systems get set up.

Top

Posted by

Linda Sweden (164 posts) Bio

Date

Reply #19 on Sat 16 Nov 2002 06:23 PM (UTC)

Message

I do have some ODBC stuff installed. I have Access 97 installed, and have recently been working on installing some kind of program that can handle transferring text or Access dbs to mySQL on another server.

However, I know not all of it is working; I was unable to install myODBC successfully to get Access to work directly with mySQL, and that failed install may have messed some stuff up (but I reinstall Access afterwards, and it appeared to replace the files with the right versions).

Anyhow, it did work when I installed it from one other world ... although isn't the db created supposed to be Access compatible? I can't seem to open it, at least.

Top

Posted by

Nick Gammon Australia (23,166 posts) Bio Forum Administrator

Date

Reply #20 on Sat 16 Nov 2002 08:19 PM (UTC)

Message

Quote:

However, upon reinstalling the plugin, I don't get any of the messages that should show up and if I try to type 'events' it tells me it can't find the file 'C:\MUSH\MushClient\Worlds\calendar.mdb'.

I don't quite understand that. It is supposed to check for the database every time. Did you wait the 5 seconds for the plugin to check the database? It waits that long because if it does it immediately any error message disappear because the window hasn't been created yet.

Anyway, sounds like it is working now. :)

Quote:

Btw, is it possible for me to edit the plugin to change the date format? American dating (m/d/y) confuses me entirely. ;)

I had hoped it would get the date format from the current system format. Do you have your local format set in the Regional Settings control panel? It is important that you do. For me that made the dates display in Australian format. On the web page some of the examples are in American format simply because the PC I used to get those examples from was still in the default (American English) mode.

Anyway, I have released version 1.1 of that plugin that does further checks of the CreateObject calls in the initialisation, and also does a "FormatDateTime" call for each displayed date, which according to the VB documentation ought to display the dates according to the regional settings.

Quote:

Also, looking at one of the script, it seems that while we check to see if the database exists, the script doesn't bother to verify that it was actually sucessfully created. This is not a good idea, since it not only doesn't inform you if the type of file you tried to create is unavailable or that it failed.

If you can tell me the call to make to verify that the database exists and is a correctly formatted database I will be happy to make it. However it sounds from Linda's post that the file was not there at all, which is what my (rather simple) check was supposed to detect. I am making the assumption that if the "create database" call succeeds then it has in fact created a database.

Quote:

It could be that for some reason installing the MDAC 2.5 was only enough to give you access to creation, but that the ODBC drivers are still missing (I thing ODBC is a seperate package).

I am not sure why you are worried about ODBC. You may remember from the earlier posts about databases that the whole idea here was to bypass ODBC. The calls open the database by name (file name) not by ODBC data source name. Thus the availability of ODBC should be irrelevant to the exercise.

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

Posted by Nick Gammon Australia (23,166 posts) Bio Forum Administrator

Date Reply #21 on Sat 16 Nov 2002 08:23 PM (UTC)

Message

Quote:

Anyhow, it did work when I installed it from one other world ... although isn't the db created supposed to be Access compatible? I can't seem to open it, at least.

Yes it certainly is, however I also seem to recall from earlier discussions that there was an incompatibility between the engine type 5 and Access 97. Ah, the joys of Microsoft products!

Linda, if you open the plugin (you can do this from the Plugins menu by selecting the plugin and clicking Edit) and then change the line which has "Engine Type=5" to "Engine Type=4", and then save and reinstall, you should get an Access 97 database. See this forum post, last entry on the first page:



http://www.gammon.com.au/forum/bbshowpost.php?bbsubject_id=1552

However you will then need to delete your database file and let it get recreated as it won't be backwards compatible, ie. the damage is done once it is created.

It is probably worth it in your case to get the earlier engine, because then you can just open the database in Access and play around with it.

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

Posted by

Nick Gammon Australia (23,166 posts) Bio Forum Administrator

Date

Reply #22 on Sat 16 Nov 2002 08:26 PM (UTC)

Message

Quote:

This is what make me nervous about using Microsoft.Jet.OLEDB.4.0 as the provider field without first having some why to make sure that v4.0 is installed and more importantly, that the Access driver is installed.

It makes me nervous too, but the checks in the plugin to see if "CreateObject" succeeds should partly guarantee that the drivers are there.

Also, distributing the database drivers is both an overhead, and possibly not legal, however I have put pointers to the pages where they can be found on the plugins page.

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

Posted by

Linda Sweden (164 posts) Bio

Date

Reply #23 on Sat 16 Nov 2002 08:44 PM (UTC)

Message

1) The date format: It appears to display properly (according to my system settings), I was just confused by the fact that it has to be entered as mm/dd/yyyy

2) I deleted the old db, downloaded the updated plugin and changed the engine to 4. However, upon reinstalling it I once again get the error of it not creating the db and then saying the file doesn't exist. Maybe the plugin should include a 'createdatabase' command?

Top

Posted by

Linda Sweden (164 posts) Bio

Date

Reply #24 on Sat 16 Nov 2002 08:47 PM (UTC)

Message

And yes, the discrepancy between the worlds remains: only the world with pueblo/mxp enabled reports back anything at all when the plugin is installed.

Top

Posted by Nick Gammon Australia (23,166 posts) Bio Forum Administrator

Date

Reply #25 on Sat 16 Nov 2002 08:58 PM (UTC)

Amended on Sat 16 Nov 2002 08:59 PM (UTC) by Nick Gammon

Message

I am successfully entering events using dd/mm/yy, eg.


event boxing day AT 26/12
futureevents

Event 'boxing day' AT '26/12' added to the database

--------Future events--------

#2: water garden AT 20/11/02
#1: Christmas AT 25/12/02
#4: boxing day AT 26/12/02

As for the install problem, there was a recently-reported problem that timers in plugins are not working properly. Perhaps this is related to that? I saw the same thing myself when I opened the world from scratch.

However once the database is created the problem should go away (for you) for good.

Can you open it from Access now?

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

Posted by

Linda Sweden (164 posts) Bio

Date

Reply #26 on Sat 16 Nov 2002 09:10 PM (UTC)

Amended on Sat 16 Nov 2002 09:11 PM (UTC) by Linda

Message

Ah, I thought I had to stick to the date format listed in the example.

But I can't open it in Access yet because right now I am unable to get the database created. I've installed and reinstalled the plugin a few times, in different worlds, but no luck.

In all worlds except one nothing happens (although it does install, because if I type events it reports it can't find the db file), and in one world it is reported as installed, but it also reports it can't find the db file.

Update: Okay, deleting the files in the 'state' directory allowed me to reinstall the plugin and get the db created.

Top

Posted by

Nick Gammon Australia (23,166 posts) Bio Forum Administrator

Date

Reply #27 on Sat 16 Nov 2002 09:17 PM (UTC)

Amended on Sat 16 Nov 2002 09:18 PM (UTC) by Nick Gammon

Message

Ugh. OK, I did keep a variable there that stops you creating a database once you typed "setdatabase" but you didn't type that did you?

Anyway, which example are you referring to? All my examples I did "my way" which were dd/mm/yy.

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

Posted by

Linda Sweden (164 posts) Bio

Date

Reply #28 on Sat 16 Nov 2002 09:31 PM (UTC)

Message

Nope, didn't type setdatabase.

Well, at least it did work eventually and now the created db does work in Access.

I had to uninstall the plugins from all worlds, save the worlds and clean out the state directory, and then it seemed to work. So I guess that removed all traces of the previous install.

And okay, now I have the hang of the dating. I was confused by how it would return my system dating even if I entered in another format, but now its sorted out. It works whether I use dd/mm/yyyy or yyyy/mm/dd to enter.

Top

Posted by

Nick Gammon Australia (23,166 posts) Bio Forum Administrator

Date

Reply #29 on Sat 16 Nov 2002 09:59 PM (UTC)

Message

Each plugin has an "id" which is near the start of the plugin file. In the case of the Calendar it is "805364a6309ecdf2b4e366cf". Removing the state files with that in the second part of the file name would have been sufficient. In my case the file was called:

dc68d2c6f8b154d243e917bc-805364a6309ecdf2b4e366cf-state.xml

The first part of the name is the world's ID, the second part the plugin's ID.

Thus, this command would have worked (in a DOS window):

del *-805364a6309ecdf2b4e366cf-state.xml

However *why* you had to do that isn't totally clear.

I am glad it is now working, hopefully it will now solve the problems you wanted solved. You can change the number of days in the future showed when you type "events" by modifying the number "14" in about the 3rd line of the plugin.

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

143,025 views.

This is page 2, subject is 3 pages long: 1 2 3

It is now over 60 days since the last post. This thread is closed. Refresh page

Go to topic: Search the forum

top