Access -> Dynamic website, XML?

[Olavxxx]

Hi,
I have this customer, that has a customer-database, where they want to be able to import the customer-database on to the website.

They do not have any special knowledge about any type of web-system, so I made them a custom CMS, with WYSIWYG interface (FCKeditor).

This works great, and they understand how to update theire pages, but:
As I said, there is the MS Access DB, with customer-listing.
I tried checking which exports are availible in MS Access 2002, and they where (amongst other):
* XML
* RTF
* XLS
* HTM(L)

- The HTML was a very rotten export, so I dont think that is good for anything.
- The RTF looks nicely formatted
- I did not try the XLS
- The XLS looks ok.

What striked me, was:
Maybe I should make an upload-script, where I let them upload the XML file and then I retrieve information from the XML?

Or, maybe I should on upload, put this data in an mysql table?

The XML file will contain about 300 entries, and the schema will look something like:

<?xml version="1.0" encoding="UTF-8" ?>
- <dataroot xmlnsd="urn:schemas-microsoft-comfficedata">
- <Kunstnere>
<Medl_nr>0001</Medl_nr>
<Org>Something</Org>
<Etternavn>Doe</Etternavn>
<Fornavn>John</Fornavn>
<Adresse>Secret</Adresse>
<Postnr>2323</Postnr>
<Poststed>Somewhere</Poststed>
<Noter>mail@127.0.0.1

http://127.0.0.1/</Noter>

</Kunstnere>
</dataroot>

eg:
Is the "Only" sollution here to:
1. Upload XML
2. Insert XML in SQL
3. Gather data from SQL

I think I have to LIMIT how many I show per-page, as I guess 300 is a tad too many

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[Vragabond]

This might be a bad idea but since Access is VB backened, I would simply loop through records in Access and make a php file with mysql inserts. Upload the file and execute it. Probably you could do all that from within Access, giving your users just one button like 'add data to website'.

 

[Olavxxx]

The database will be offline, only one table from the database is to be viewed online.

eg. That's why I thought an export of the relevant table would be the most appropriate sollution.

I thought that XML (as should be a standard) would therefore be the best sollution.

What format it is in backend, is not a concern if you export in XML, that is the point of XML.

My general q however: Should I make a php-script insert the XML data into SQL?

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[i3iz]

DaBtucher-
I went to your webpage volvo-power. I clicked members and it asked for name and password. But when i clicked RND picture, then i was able to browse the members pictures. with out needing to login. I couldnt find and e-mail so i figured this would be the best way to tell you.
--i3iz

--i3iz
Technical Newbie

 

[Olavxxx]

i3iz: this is not a fault, if you look at "members pictures without login", it will work.

eg. there is one for editing guestbooks and one for not.

I know it might be confusing, but at first, there was no guestbook in the one without login. I however thought that it might be nice for google-stats, that google could crawl the internal guestbooks.

this site however, is not the one I'm working on atm. for the XML project.

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[i3iz]

oh, which one are you working on for the xml project?

--i3iz
Technical Newbie