Solved

Flex accessing local data

Posted on 2009-05-17
12
852 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

729 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