Closed Thread Icon

Topic awaiting preservation: .txt database integration Pages that link to <a href="https://ozoneasylum.com/backlink?for=8423" title="Pages that link to Topic awaiting preservation: .txt database integration" rel="nofollow" >Topic awaiting preservation: .txt database integration\

 
Author Thread
Rondavu
Nervous Wreck (II) Inmate

From: Haverhill, MA, USA
Insane since: Dec 2002

posted posted 12-05-2002 04:52

I am trying to figure how a bowling center site I frequent updates their league stats database online using .txt files. Here is the link to the page that will bring up the stats. http://www.parkplacelanes.com/League%20Central.htm It is candlepin bowling so hold back the laughter. Just go onto wednesday and click sports and HF or whatever league you want to see what I mean. I understand Coldfusion and PHP techniques, but this is something different accessed through Javascript I think. Can anybody give me a freaking clue on this one. I would just search the search engines for the info but I don't know what to query google in order to find info on this topic. I assume it's an old way to integrate frequently updating info from a database uploaded (obviously), but I have never been exposed to it. Tell me the story. Sorry if I posted in the wrong spot. Beat me with a stick if I have been disobedient to the forum gods.

Sam
Bipolar (III) Inmate

From: Belgium
Insane since: Oct 2002

posted posted 12-05-2002 08:04

Try the following topic http://www.ozoneasylum.com/Forum2/HTML/001891.html .
Maybe you find something you can use. The text files used are export files from one database table, not a mixture of all kinds of information like you have, just one header record and then the data.



[This message has been edited by Sam (edited 12-05-2002).]

Petskull
Maniac (V) Mad Scientist

From: 127 Halcyon Road, Marenia, Atlantis
Insane since: Aug 2000

posted posted 12-05-2002 18:13

um.. I like databasing like this, but I'm not sure I understand what you're trying to do..


Code - CGI - links - DHTML - Javascript - Perl - programming - Magic - http://www.twistedport.com
ICQ: 67751342

Bugimus
Maniac (V) Mad Scientist

From: New California
Insane since: Mar 2000

posted posted 12-05-2002 20:10

It just looks to me like they are uploading text files and linking to them. Or if they have their own server, they may have the text files on a cron job to automate the updates. I don't see anything real weird other than linking to text files as opposed to HTML formatted ones.

. . : slicePuzzle

[This message has been edited by Bugimus (edited 12-06-2002).]

Sam
Bipolar (III) Inmate

From: Belgium
Insane since: Oct 2002

posted posted 12-06-2002 07:39

The site where I used this script is not yet online, it's part of an new site that will be online 01/01/2003. It's just a way of loading a textfile, without any html tags, and then displaying it in a nice formatted way with links, email addresses, pictures or whatever you want depending on the file. The text file is delivered by someone else so I don't need to update the entire page, only the textfile.

Bugimus
Maniac (V) Mad Scientist

From: New California
Insane since: Mar 2000

posted posted 12-06-2002 20:40

Sam, are you referring to SSIs? That is a great way to include text files into pages without much hassle.

. . : slicePuzzle

Rondavu
Nervous Wreck (II) Inmate

From: Haverhill, MA, USA
Insane since: Dec 2002

posted posted 12-07-2002 00:52

So how does a supplied database become one of these linked and formatted text files? Would the database have to first made into a comma delimited file? How do you get from point A (a database file of some sort supplied to the web developer) to point B (making it into a linked and formatted text file with minimal labor? What languages would you need to achieve this? Perl? CGI? If anyone could point me towards a tutorial online about this or some specific info about taking a database and then making a .txt file out of it I would be greatful. Nothing against the pervious link but it didn't sink in the way it was being presented to me in application to what I'm talking about. Thx



[This message has been edited by Rondavu (edited 12-07-2002).]

Sam
Bipolar (III) Inmate

From: Belgium
Insane since: Oct 2002

posted posted 12-09-2002 10:07

In my case someone just mails me a text file if there are changes. The text file is an export of a MS Access table (go to menu/file/export/ and then choose file type "text files..."). Look here for information about databinding.

No, I'm not using SSI's, it's just javascript.

Ok, view it at geocities http://www.geocities.com/borgunimatrix/databinding.htm



[This message has been edited by Sam (edited 12-09-2002).]

Rondavu
Nervous Wreck (II) Inmate

From: Haverhill, MA, USA
Insane since: Dec 2002

posted posted 12-09-2002 17:10

aaaah databinding. Thank you sam. I can certainly use this insight to research independantly now. Thank you for the starting point. I guess I didn't see the connection on your first post to the subject at hand but now I see. You are sam. I thank thee.

« BackwardsOnwards »

Show Forum Drop Down Menu