[flexcoders] Re: User loads CSV file
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 flexcoders@yahoogroups.com, "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 flexcoders@yahoogroups.com, "valdhor" 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. > > > ... >
[flexcoders] Re: User loads CSV file
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 flexcoders@yahoogroups.com, "valdhor" <[EMAIL PROTECTED]> 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. > ...
[flexcoders] Re: User loads CSV file
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. You want to get this data into a MySQL database using Flex? You already have a way of getting the data into MySQL and you want to use Flex to display the data in various ways? Maybe if you defined the workflow and what you want to use Flex for, I would have a better idea on direction here. We (kinda) have the same thing here. We have thousands of dataloggers around the world that dump CSV files that are then pulled onto one Linux server (Using various shell scripts). I then use Flex and PHP to display the data in a useful fashion to my users. --- In flexcoders@yahoogroups.com, "cox.blair" <[EMAIL PROTECTED]> wrote: > > Sorry, It would initially be for a web page. Later the application > will be migrated to AIR. We are using PHP and MySQL for the database, > if that helps as well. > > Thanks, > Blair > > --- In flexcoders@yahoogroups.com, "valdhor" wrote: > > > > Would this be for an AIR app or a web page? > > > > > > --- In flexcoders@yahoogroups.com, "cox.blair" wrote: > > > > > > Hello everyone, > > > > > > I'm new here, so go easy on me. I'm essentially just beginning with >
[flexcoders] Re: User loads CSV file
Sorry, It would initially be for a web page. Later the application will be migrated to AIR. We are using PHP and MySQL for the database, if that helps as well. Thanks, Blair --- In flexcoders@yahoogroups.com, "valdhor" <[EMAIL PROTECTED]> wrote: > > Would this be for an AIR app or a web page? > > > --- In flexcoders@yahoogroups.com, "cox.blair" wrote: > > > > Hello everyone, > > > > I'm new here, so go easy on me. I'm essentially just beginning with
[flexcoders] Re: User loads CSV file
So if I had the user upload the file to the server and specified what the file should be named as, could I then load the contents of the file and store it in the MySQL database? I see all kinds of information about XML files, however I would need to write an app to convert a CSV to XML to load... Doesn't have to be that complicated. Cheers. How would you normally acquire bulk data from a user? These users would be logging data recorded from a measuring device. The device software exports the data as a CSV, to recap. Thanks, --- In flexcoders@yahoogroups.com, "valdhor" <[EMAIL PROTECTED]> wrote: > > Would this be for an AIR app or a web page? > > > --- In flexcoders@yahoogroups.com, "cox.blair" wrote: > > > > Hello everyone, > > > > I'm new here, so go easy on me. I'm essentially just beginning with > > Flex, needless to say, I'm ready to learn. Using Flex Builder 3. > > > > I've spent a few hours looking through many of the flex sites I've
[flexcoders] Re: User loads CSV file
Would this be for an AIR app or a web page? --- In flexcoders@yahoogroups.com, "cox.blair" <[EMAIL PROTECTED]> wrote: > > Hello everyone, > > I'm new here, so go easy on me. I'm essentially just beginning with > Flex, needless to say, I'm ready to learn. Using Flex Builder 3. > > I've spent a few hours looking through many of the flex sites I've > come across and the mail archive for this list and can't seem to find > the information I'm looking for. > > What I need to be able to do in our application is allow users to > import a CSV file so that we can save it to the MySQL db, then do the > work require to the data. The formatting of the CSV file will be > consistent and previously arranged. The db will contain the same > fields, it's just a matter of collecting the data. Right now, the file > must be a CSV, since this is what the measuring equipment exports as. > It needs to be as simple as possible for the user. > > If you could offer some hints or put me in the correct direction of an > example or tutorial, it would be appreciated. > > Cheers, > Blair >
