I would probably set up two (or three) states in your Flex application - one to upload files to the server (See http://livedocs.adobe.com/flex/3/html/help.html?content=17_Networking_and_communications_9.html), one to manually enter data and one to display the data in a meaningful fashion.
I would then implement PHP scripts to import the data from the uploaded file into the MySQL database as well as to take manual updates to the data. Also I would use WebOrb to retrieve the data from PHP. --- In [email protected], "cox.blair" <[EMAIL PROTECTED]> wrote: > > Okay, the back story is we are creating a completely new application > based on a very complicated Excel based spreadsheet an engineer > designed to record the data collected from users. > > The program essentially trends this data. It will be entered manually > as well as collected from the device as I mentioned. The part I'm > trying to spec in my head is how I'll allow the user to take their CSV > data file and add it the application? I am new in this area, so I'm in > the learning curve. There will be so much data collected that setting > up a MySQL database to store it will be necessary. > > So I need to understand the best way to let user upload a file and for > me to be able to add the data to the database. Everything would have > to done by the Flex application - or php scripts within flex. > > Not sure how else to explain it. You could provide a general example > of importing data to a database from a CSV source. It would be saved > directly to the database, then be accessible via other modules of the > application to trend the data into a graph. The application will just > be a graphical version of the spreadsheet really. > > Thanks, > > --- In [email protected], "valdhor" <stevedepp@> wrote: > > > > So, let me get this straight.... > > > > You have a bunch of users out in the field collecting data with some > > kind of datalogger. This datalogger exports its data as CSV. > > > ... >
