I had thought of that, but I'd just prefer to leave it up to them to do all the work, and not have to check a folder and view files.
 
Besides, we're using SCP here and it's limited to internal IP addresses, and i dont want open that can of worms.
 
I suppose I could also have the data mailed to a certain email address, and use CFPOP to check it and update the data from there. There's so many options....
 
Thanks
 
Gav
----- Original Message -----
From: Taco Fleur
Sent: Monday, October 27, 2003 4:44 PM
Subject: [cfaussie] RE: Clients DB updating online datasource

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/
---
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