Automatic output from the desktop application to the web site calendar

I kind a know what I am after here, so please help me.
We got an event planning app. It would be really nice if there is an option to take the existing data and post that to the web based calendar and populate days of the month with title of the happening.

What are my options here?
Application is getting data from MS SQL 2000 database running on the remote server machine
howeiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jmelikaCommented:
Hi howei,

We certainly need a lot more information to understand your scenario and be able to help you out.

Is your application developed internally?  I mean can you add code to it or tweak it if necessary?  The database, is it hosted on your server or you do not have access to it?

As for the web based calendar, is it your own code as well?  What about its database?  Can we directly connect to the database?  If the answer is yes to all of the questions, then we can simply create a button your app to "publish" the data to your web app, and that button when executed it would insert the same records you collected from the app's database into your web's database.  We will need the structure of both databases to be able to help with that.

JM
howeiAuthor Commented:
Hi jmelika,

Application is not developed internally and chance of tweaking it directly is slim.

But the database is hosted on our server and someone who knows how to do it could pull the data out of it and place it on the web.

As far as web calendar, we don’t have that jet. I was thinking of some free ones or low cost ones that exist out there that could be used for this project.
So on our side you deal with MS SQL 2000 database.

Please note that out of lots of information about an event in the database, only the title of it associated with proper date and tame would need to be exported to the web.

jmelikaCommented:
Gotcha.

It is certainly doable.  The information will vary based on the source database structure, destination database structure, and method of synching.

What I mean by that is as follows:
- Source database: is actually the database your app reads.  The information you're pulling out has to be put in some sort of an "insert" and/or "update" statements to match the structure of your destination database.

- Destination database: is your web calendar's database.  Depending on how it's designed and where the information it displays is usually stored, you'd insert/update from the SQL statements previously mentioned.

- Method of synching: do you want users to sync manually, automatically sync on a regular basis, sync everything, sync some information, etc.

It's certainly doable.  I've actually done something very similar myself in the past for a clock in/out machine that I synched up with our payroll and vacation calendar.

Good luck!
JM

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
howeiAuthor Commented:
What this might cost to be done?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.