CSV via FTP
Not saying it's better, but certainly easier to set-up.
 
-----Original Message-----
From: Gavin Cooney [mailto:[EMAIL PROTECTED]
Sent: Monday, 27 October 2003 3:40 PM
To: CFAussie Mailing List
Subject: [cfaussie] Clients DB updating online datasource

Hi all,
 
I am currently designing a website for another Organisation. It will be a basic directory-type website of a load of items in a Database. The organisation maintains its own database of items that will be published to the website.
 
There will be no network link between this DB and the webserver, so I’m planning to take a copy of this data into my own MySQL database, to be used as the datasource for the website.
 
Getting the initial records (and related jpgs etc) will be easy, but I have to decide how this data should be updated. Off the top of my head, I can see two main options:
 
1. Web Service:
I could write a SOAP Web Service using Cold Fusion (have never done this before) to allow the client update the data directly from their own end.
2. XML via form or URL variable:
The client send the relevant data to me in XML format via a form or URL variable. The page this is sent to could process the information, and output another XML file with a message “done” or and error message.
For security here, I suppose I could request a username and password field with each update. I could also restrict this to certain IPs (I know this can be faked tho).
For the images here, they could be submitted as form variables too.
 
I’m sure each of these have their pros and cons. Has anyone any better ideas, or comments on either of the above?
 
Thanks
 
Gav
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/

Reply via email to