?
Solved

Flex accessing local data

Posted on 2009-05-17
12
Medium Priority
?
858 Views
Last Modified: 2012-05-07
I am creating an application that draws on a lot of textual information, currently in a database. The app is to run locally, on end user machines only, not from a server, not connected to the web, and  built in flexbuilder 3. Therefore I need to access the data directly. I don't want to use AIR, but make this web-enabled as well. It looks like the only solution is to build the database containing all the content, in something local like Access, and then write it all out as an xml file, and access it directly from there. Not keen on this as editing the content will be a nightmare. Does anyone have any other solutions?
0
Comment
Question by:virgewest
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
12 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24409355
How about using Excel?
0
 
LVL 1

Expert Comment

by:jbake
ID: 24409731
if you are familar with python and python database connections, you could also design your database (mysql, postgres, ...) get the data with python and export it as xml.
0
 

Author Comment

by:virgewest
ID: 24410016
To tbsgadi: thanks, but how would excel help? can as3 directly query an excel table?
To jbake: thank you, but the problem is not with organising the data, but reading it locally, without exporting it to xml.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 46

Expert Comment

by:tbsgadi
ID: 24410034
I don't know whether you can directly access excel, but excel is very easy to edit & to export to xml.
0
 
LVL 1

Expert Comment

by:jbake
ID: 24410043
0
 

Author Comment

by:virgewest
ID: 24410326
The issue was whether I could avoid moving my data to xml, not how to get it into xxml.  I guess the answer is that xml is the only way to get data into flash. Is that right?  
0
 
LVL 1

Expert Comment

by:jbake
ID: 24410537
If you want to store the data locally there is also the SharedObject:

Storing local data @ livedocs.adobe.com

Problem in this Case is getting the Data from the Database and converting it to SharedObjects. Which database do you use?

0
 

Author Comment

by:virgewest
ID: 24410656
Data is currently in Access db. It will write out OK as xml, and I need to be able to query it with sql-like strings to get the content. So I think I'm stuck with xml. Maybe I have to write myself an xml editor for it!
0
 
LVL 19

Expert Comment

by:Jones911
ID: 24411063
Instead of using Flex use Air which can access the local filesystem and also jad SQL light inbuilt.  Flex can access the local files systems with the 3.2 ro 3.3 sdk there are some new features but it also requires Flash 10.

Rather then creating a Flex app select AIR app in Flexbuilder and you have full file access to the local machine and can have local databases using SQL light without needing to revert o mySQl, XML or some cvs format.
0
 

Author Comment

by:virgewest
ID: 24411781
Thanks jones911, but as I said in my first post, I need to avoid air and keep my app web-enabled, for the users who do have internet access, while not disadvantaging those who don't. Tough call, but I still think I end up with xml.
0
 
LVL 19

Expert Comment

by:Jones911
ID: 24411789
Take a look at this post on reading and writing local files with Flex and Flash 10 ti should prove usefull.

http://www.mikechambers.com/blog/2008/08/20/reading-and-writing-local-files-in-flash-player-10/
0
 

Accepted Solution

by:
virgewest earned 0 total points
ID: 24417440
Thanks for all the suggestions, but I think xml is the only answer. It just seems a drag to have to convert from a db to xml, then parse it all back to a db like array. Thanks anyway.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question