Users will not be able to be fully offline, unless you make the app an AIR app, or make "also" an AIR and online version of the program.
They don't have to have the database or tomcat installed, that should be on the server and they just pull data from it.
But they can't be working from the local harddrive unless is AIR app.
The client is very worried about the data security so instead of him accessing the database from the server he would prefer having it on his desktop (which is why the excel tool was sent along with the mdb file). If he agrees to access the server then we have to get the server and tomcat installed on on of their servers because they wouldnt prefer accessing the data from one of our servers
Thata's fine. If the Flex app SWF comes from your server though, you may need a crossdomain file setup.
So i believe there is no way it can be done offline like in excel.
And what about the trend line feature that is in excel..is there anything similar to that in flex?
As mentioned earlier, for creating an standalone desktop application, you need to create an Adobe AIR project in Flex. With Adobe Flex w/ AIR you can use Local SQLite databases provided in AIR.
Adobe has a good tutorial for this at: http://livedocs.adobe.com/flex/3/html/help.html?content=SQL_01.html
You said the data could be online on the user's server, that's not offline. If it must be offline, as in data coming from a file on the user's local machine, then Flex no, AIR (using Flex) yes.
yeah i am aware that it can be done using a server..as u said i need it to be offline ie data coming from clients local machine.. so its possible in AIR using flex.. any tutorial to help be with it? or a brief idea about it?
This link shows reading a file from the local file system into an XML object:
Then just process the XML as usual.
You can write the file to local file system as well.
Download SalesBuilder is a dahsboard app, it includes data
synchronization, and a local encrypted database
I have downloaded the Salesbuilder Application and really like the features, but what about licensing issues? Are we able to use this application's original source code, modify it to our needs, add new code and use it commercially? If not, what do we need to do to obtain a license? Additionally, are there any tutorials or walkthroughs which go into detail on the source code which is also supplied. If we are to modify the code and such, has anyone successfully re-written or modified the code and have demonstration files? I keep getting errors on my end.
The first error I am receiving is "an incorrect number of arguments. Expected no more than 4" on the resource DatabaseEncryption.mxml
The source code is here where the error number faults to:
sqlConnection.open(_databaseFile, SQLMode.CREATE, false, 1024, encryptionKey);
The second error I am receiving is "Type was not found or was not a compile-time constant. Update Event" on the resource salesbuilder.mxml
The third and repeating group of errors are "Type was not found ...SandboxMouseEvent" on the resource salesbuilder.
Do you have any advice? You have been very helpful in the past and thought you may know how to solve my problem with SQLite and Air/Salesbuilder...