Flex :: Excel - Standalone Application With No Database?
Jun 24, 2010
I am trying to develop an application which can be used locally by my team mates. its a sort of issue tracking application with report generation. am planning to do it on flex. in my company environment, i do have a lots of restrictions like, can't install AIR, no database, etc.
so am planning to develop on flex app, and put it in a shared drive. now the main problem is how can i store data. i have an idea like using excel files as database. I want opinion about this option, as well as, if anyone has tried reading and writing excel files from Flex application I want the suggestions also.
I am planning to develop a standalone application, which infact will be used for personal purposes. So only single user access may be there. I want to develop it in Flex. Just want some opinions from the gurus over here : Whether i should use Flex or AIR (I know only Flex, AIR i need to start learning)Which database i should use? SQLLite or HSQLDB or some other.
I want to set the default window size for a flex application that runs with a standalone player.I set width and height to 100% to be able to get the ResizeEvent and being able to adjust the layout if the user changes the window size. But I'd like to also define a default size.
What is the best way to open and parse and excell file from a Flex Application built using Adobe Flash Builder 4.5. I have done tons of research, most lead me to external libraries, I could deal with that if that is the best approach, but prefer a built in method.
How can i design a 3D carousel for video/images to run on standalone Flash Player on my Desktop? I am using Flash Builder 4 to develop this as a mxml application, but found that it doesn't allow access to local filesystem. My specific requirement is that I want it running on the local computer and in SWF files viewed in a user's browser. Is there a sample code to do what I am trying to do? This application has states and transition, like one state for a video gallery and one state for a image gallery
I'm developing a Adobe AIR application using Flash Builder 4. This app needs to access a remote PHP service which is being hosted on a remote web server. I am having troubles figuring out how to add a PHP data service which uses a remote service. I can add the PHP data service in Flash Builder as a service hosted on localhost, but given that this will not be feasible when the application is deployed, will not work. How to connect a Flash Builder (Flex) project to a remote PHP data service?
I have a mobile application that uses an sqlite database. I cannot seem to figure out how to access the next record when the user presses the 'next' button. My database is using 'id' as primary key with autoincrement as integer.
private function nextMoveRPart(event:EffectEvent):void { var cardNumber:int = parseInt(cardNumberLabel.text);
I am having an issue trying to set http headers when trying to access a web service.
I have read that I need a crossdomain.xml on the server, but is this only when the application is running in a browser - i.e. hosted somewhere.
My scenarion is that I am developing an app to run as a stand alone application (not in the browser) for a 3rd party device. This device does not support the flex mx packages.
The app calls a webservice and displays data. The webservice requires to be authenticated.
In JS i can use an XMLHTTPRequest and load the url using "https://username:password@server.com/service.asmxpassword@server.com/service.asmx" - attempting to do this in AS 3 using a URLRequest and URLLoader I get "#2044: Unhandled ioError:. text=Error #2032: Stream Error".
So I try to add a HTTP header instead, but this appears to be ignored - the credentials of the user who is currently logged into the network (idsid) is used instead.
Do i need a crossdomain.xml file on the server hosting the webservice even though my flash application will never be hosted. The server admin is not happy allowing all domains ("*") since I dont knwo what domain I am in as my flash app is not hosted.
Any help you can give me would be greatly appriciated. or perhaps there is an alternative way of doing this?
<code> var urlRequest:URLRequest = new URLRequest("https://server/service.asmx"); urlRequest.method = URLRequestMethod.POST; urlRequest.contentType = "text/xml";
var urlLoaderService:URLLoader = new URLLoader(); urlLoaderService.dataFormat = URLLoaderDataFormat.TEXT; urlLoaderService.addEventListener(Event.COMPLETE, onServiceLoaded);.....
I'm looking to develop an application that allows you to set up an online spreadsheet or to be able to draw a custom table format. Can someone point me in the right direction. I've been googling for a week now and can't find any direction.
I'm creating a standalone flash application. Now, I have a user interface with a menu, and I have to launch a new stage in fullscreen mode with at the center an 800x600 swf.How can I create the fullscreen?
I am currently working on software for student attendance. I use the flex / flash and php to create the software but I faced a problem barcode scanner, can not connect to the application to call the data from the database when students scan the barcode printed on their student card.
I'm exploring the feasibility of reading data from a local Excel file in a Flash application.
XLSX READER [URL], it's possible to read Excel 2007 files.
It works beautifully.
However, that function doesn't read Excel 97-2003 files.
I found this:
[URL]
Which should read Excel files in Flex, but I'm working on a Flash application, and it looks like as3xls relies on a number of Flex only functions and types (ArrayCollection, NumberFormatter, etc.)
Since I'm not familiar with Flex, I'm having a difficult time making the adjustments myself.
Has anyone built a Flash app that reads Excel 97-2003 files, and is willing to share tips or code?
Flash Player 10.2.153.1and Flash Player 10.2.159.1 are crashing my standalone application. Later with version 10.1 the application run ok, never crashes but was taking more than 90% CPU. The new Flash Player solve the problem of resources, and drop down CPU to 30%, but the application crashes always after a while, unespectly, or if I open the window of other application.
In the other hand when I disable the harware acceleration at the swf settings, the application goes crazy and start to make rapid flashes, and frame rate goes down to 8. [URL]. Right click on the Flash logo, Settings,then UNcheck the hardware acceleration in Display Settings.)
I'm on a Mac Mini Core 2 Duo with Mac OS X 10.6.7 (the last Snow Leopard these days). The graphical card is Nvidia GeForce 9400M.
I did test the application at a Mac Book Pro core i5, Mac OS X 10.6.7, graphica card Nvidia GeForce GT 330M and the application is more stable but finally crashes too.
Finally if I export my application with GPU Hardware acceleration at Publish Settings, my application crashes almost inmediatly after I open it in each of the computers.
My guess is that the new Flash Version is using my graphical proccesor in a corrupted way.
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?
Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything. So, my issue is this. I have a mySQL database hosted I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.Here is my licenseTracker.mxml
I have updated the mxml code to only show the needed code for the program to run the update.
I am new to Flex and have an issue I hope you all can help me out with.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything.
So, my issue is this. I have a mySQL database hosted on 000webhost.com, I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.
I am planning on using Flash Builder 4/Flex to write an AIR application which is primarily based around recording, storing and analyzing data.I'll be creating charts etc that need to update in almost real time.It's essential to me that the application be able to function without an internet connection so I need a local database of some variety,but I would also eventually like to build in online synchronization of the data where either database can be update each other based on newer information. Moreover, some type of encryption would definitely be welcome, and speed is a large concern
Synchronization: Primarily updates/additions/deletions will be done on the offline database, but ideally I want to have a web interface that will allow the same updates/additions/deletions and will be synced (beyond that I'm not sure exactly how to do it as I can model that based on what is most achievable).I'm wondering if there's any prebuilt engine that could handle the synchronization of 2 databases. I may end up having the web interface only be for additions, which would be significantly easier to sync.. and I may start that way, but i want to build with technologies that will best allow me to implement full online crud at some point.
Here is the issue: a client wants his entire equipment inventory accessible by persons navigating to his jquery mobile site. The inventory that exists on the desktop site was, as I understood, built with Flex. Is it possible to access this database for the jquery mobile site? I believe it is. I was then given this information from someone in the know:
Our users want to copy and paste some rows from an Excel spreadsheet, or a chart generated in Excel, into a text box within a Flex application.It would be ok for it not to be fully functional, like an ActiveX object, embedded in the flex app. If it converted it to a static image, that would be fine. But I don't know of any Flex component that supports this.
I am trying to develop a flash database manager for my company, and I already have the insert and "search" functions working okay. The problem comes up when trying to get the UPDATE working. [code]...
I am beginner to Flex3 .. I am developing simple application with login screen having fields user name and password. I wanted to know how i store this information in MySql database?
I'm a beginner with Flex Builder. I need to get application to communicate with an Access Database. I'm in the planning phase of implementing a Call Log for myself. I'd like my app to run on my desktop (AIR) and as a web app. Basically, I need to document my incoming service calls. My customers will give me an ID number, with this number I can post new service call info, or pull up past service calls and/or display their system info all different tables. How Flex communicates with databases? I know it uses XML, PHP, AMF, etc. Do I have to use PHP to return the XML coding for Flex to read? I'm familiar with PHP and MySQL within Flash; however, it seems that I have to use MS Access for this app.
I want to emded SQLite database (*.db file) to the AIR app, like images, mp3 etc.This is to ensure that it was impossible to copy my database for other users.
