next »

[Bob B]

It seems that an addition of a non-recurring event only affects the events.id and events.txt files.  Is that correct?
If so, is there any reason not to use MySQL or another database to create those files?

------------------
 rdbenjamin@earthlink.net  
I'd like to see anything that has been done with this GREAT calendar program.

[Scott]

It also touches the schedule files.
No DB is used for portability reasons. CalendarScript relies on almost nothing in the environment, so it can be run almost anywhere. Many people don't have access to mySql, so they would be locked out from using CS. One of my goals was to create a program that could be loaded on almost any web server in the world, without any dependencies, and it would work out-of-the-box. And most of the time, that holds true  

------------------
Scott
CalendarScript.com

[Bob B]

It does work 'right out of the box'!
However, I have the potential of 1,000 'calendars' with about an average of two events per month for a total of 50,000 'online' events extending over a two year period.  These 'events' will already be in a MySQL database because of other applications.
I can set up the individual calendar structures, etc. within CS but I just need to create the needed event, etc. files outside.
I'll keep testing and see where it leads me.
Thanks for your great work.

------------------
 rdbenjamin@earthlink.net  
I'd like to see anything that has been done with this GREAT calendar program.

[DanO]

** One of my goals was to create a program that could be loaded on almost any web server in the world, without any dependencies **

Matt, since your calendar is modular by design, wouldn't it be relatively easy to create replacement routines to allow SQL tables to be used for the database requirements rather than the flat files? Those routines could be sold separately from the normal CalendarScript download as a product enhancement for those interested in it.

Dan O.

------------------

[Bob B]

---
Matt - I meant is there any reason for me not to use MySQL to create the needed events.txt, etc. files.  I didn't mean you.
---

I'm not seeking a change in CS, just info on what files I need to deal with if I want to replace the 'events' externally.
What do the 'schedule' files do if there are NO recurring events, just one-time-only events?
Thanks.

------------------
Bob Benjamin
   rdbenjamin@earthlink.net    
I'd like to see anything that has been done with this GREAT calendar program.

[This message has been edited by Bob B (edited January 23, 2004).]

[DanO]

** What do the 'schedule' files do if there are NO recurring events, just one-time-only events? **

The schedule.txt file holds the schedules for all events not just recurring ones.

Dan O.

------------------

[Bob B]

Import events.
I would like to obtain a script modification that would allow me to programatically import events.  The source file would have a static name and could be either CSV or tab separated.

I want to run, for example, csimport.cgi and have it import from source.txt or whatever.

Has anyone done this?

Is anyone familiar with CS & perl willing to do it for $$$?

Thanks.

------------------
Bob Benjamin
    rdbenjamin@earthlink.net    
Currently working on driving events from an external program.

[Scott]

I originally planned to put a layer between the calendar code and the "database" access, but decided against it primarily because of the flexibility of events formats. Changing db tables by adding columns, etc can be extremely tricky, or even impossible in some db's. Changing the schema to allow for flexible event formats without changing table structures would get big and messy, when most people would NOT use it. So I decided not to spend my time on it  

Bob - Generating the "database" files is not a bad idea at all. Could get a bit tricky, though - you might want to have a perl script query the db, massage the data, then output the appropriate files.

------------------
Scott
CalendarScript.com

[Bob B]

I figured that all of the logic to convert from a CSV into what CS needed was done by the import routine. (Admitedly I didn't check to see if that routine would add or delete fields. - and I didn't care as I am willing to do that in the prescribed manner.) I was/am willing to take responsibility for the DB output including header record, etc. but it wasn't clear to me what contortions(sp) CS was doing in import and exactly what had to be in each file for it to all work.  I noticed that one file seemed to be tracking how many events there are/were.

I'm just not good enough at Perl and familiar enough with CS to either (A) cut into the CSAdmin to create a modified import script or (B) know exactly what files and contents need to be created. All of my stuff will be single events as I will handle recurrances, if any, in the database.

Maybe if you could tell me what the needed files are and the file layouts I could take it from there.

Thanks for your time.

------------------
Bob Benjamin
    rdbenjamin@earthlink.net    
Currently working on driving events from an external program.