Hi everybody,

I run a Fedora Core 5 server.
I'd like to install a solution for this need:

. I have a product catalogue in an MS Access file.
. I need to have an html page with the list of all products
. each product in the list must link to a detail html page

All the data must be taken from the Access file directly OR from a file generated manually from it (XML for example).

What solution could apply? (If any...)
thank you
regards

There is a thread on something similar to this... since I lost my password etc this would be my first post... and it cannot contain links... (even to this site) :?

anyway... go to /linux/answers/Applications_GUI_Multimedia/Moving_MS_Access_Data_to_Linux

on this site...

That is: http://www.linuxquestions.org/linux/..._Data_to_Linux

(should have thought about that...)

Thanks Erikalm,
your link was really interesting. But the main point is not ms access: my data could be in xml files too or any other format.

Still, how can I implement them into a HTML page?

Thank you!

Ah, I see...

Well,

While there might be problems just magically converting the database or XML to HTML there are several technologies that could be used, with some level of programming.

Using a database you could try to look at PHP (http://www.php.net/), or JSP (http://java.sun.com/developer/onlineTraining/JSPIntro/), or if you just want a small script to display the data without the server hassle, Perl (http://www.uga.edu/~ucns/wsg/unix/pe...roduction.html) might work.

However if you're having an XML file you could look into XSLT (http://www.w3schools.com/xsl/xsl_intro.asp) and an XSLT tool (there are several in Linux... I'm using a tool called XmlStarlet, but that is on Ubuntu, it may exist in Fedora too, otherwise I'm sure there are others for Fedora).

Anyway, what tool to select depends on what you want to do with it. If you just want to make HTML out of XML without having to install a lot of things or learning to use them, I'd go with the XSLT track.

If however, you want a direct connection to the database, to see updates in the database immediately in the HTML, and so on, you may be better off putting the data in a Linux native database and reading from it with JSP/PHP/Perl. This also goes for if you want to make arbitrary selections of the data, for instance sort it differently depending on user demand, or select just certain rows for instance as a result of a user query (you can search and select, with XSLT too, but preferrably not "on demand").

HTH

/E