Pulling XML Spreadsheet Data Into Flash?
Feb 23, 2010
I am building a userinterface for some industrial instruments which output some data to a XML spreadsheet. This is the only way I can retreave these data's from the instruments.
Now, I need to make a flash that can pull out these data's from ex. "A1" and "A2" in this spreadsheet...
Here's a screenshot of the XML as it appears in EXCEL:
...and the XML as it appear if opened in Dreamweaver:
Code: Select all<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
[Code].....
View 8 Replies
Similar Posts:
Aug 28, 2010
I have been failing to do a thing with Flash actionscript2.0; Here is the problem-
My xml file name is: sea.xml On my fla file, there is a button named: do; and a movieClip named: loader;
What I am trying to do is- load xml only when the button is pressed. So I tried this-
myXML:XML = new XML;
do.onRelease = function(){
myXML.load("sea.xml");
}
[Code].....
View 1 Replies
Jan 1, 2012
I loop through two arrays and im checking their data, i have collison working for them but I want to add more A.I. by making them stop when they are a certain distance from each other. so i need a way to pull EACH object that is in the arrays x,y, pos and use that data. my distance var keep bouncing all over the place...
THIS is my code:
//check events between 2 objects
function CheckEventsEnemyFighterFighter():void
{
[Code]....
P.S. i need some tips for my coding... like should have i used a break in these for loops?
View 2 Replies
Aug 15, 2011
I am a pretty big newb- my challenge is get a flash page to look to a database and check for updates constantly (in the realm of 1update/second) then pull new data as it is added.
View 1 Replies
Apr 23, 2010
I'm wondering if anyone has figured out how to pull data from a column in a SharePoint 2007 list to be able to dyamically generate a reaction in a flash object.Our designer created a dashboard of thermometers for our projects that use two variables, % complete and status (green, yellow, red, blue).
As the end user, I want to be able to update my project in my SharePoint list and have it so that my updates automatically populate that flash based dashboard.Right now, he's using an XML document that is stored in a folder on our SharePoint site and then simply updating the XML file when there are changes.It would be ideal to pull this data from the list rather than having to update and then upload the xml document to the SharePoint site.
View 1 Replies
Sep 21, 2006
I created a file that pulls data from the worldofwarcraft.com serverstatus xml page.The data populates a dropdown list and you can choose the server and it tells you if its up or down. The mini app works great on my desktop, when I upload it to my server it no longer retrieves the data.
Is Bliz blocking my server address from recieving the data? Anyone know how to navigate around this. [URL]..If you want to test it grab the swf out of your cache and load it from your desktop, it will work.
View 6 Replies
Sep 10, 2009
I was running a test today and couldn't get flash to properly load data from php.Here's my textInput.php file:
Code:
<?php
$testVar = 'This is a sentence.';[code]....
why it's grabbing the entire php code, rather than just the echo?
View 3 Replies
Sep 8, 2010
I am trying to pull a text from within xml tags and place them in a text box when certain mc's are clicked. I am using the e.target to find the name of the mc clicked and grab info from tags with the same name as the target mc. The XML link is good as i can get data when doing tests with out using mentioned technique.
ActionScript Code:
package {
import flash.display.MovieClip;
import flash.net.URLRequest;
import flash.net.URLLoader;
import flash.events.Event;
[Code] .....
And the xml file
Code:
<statsIcons>
<pollutionIcon_mc> some text </pollutionIcon_mc>
</statsIcons>
View 1 Replies
May 25, 2005
pulling specific data from XML? This is what I mean...Supposed I have an XML file like this:
HTML Code:
<data>
<article>
<ID>1a</ID>
<related items>
[code]....
Now, in Flash I want to load all items that have "5f" listed as one of their related item. So only display articles where item = 5f
View 7 Replies
Apr 30, 2007
Basically, I am having trouble pulling in more than one line of XML data. Here is the line of code I am trying to manipulate to give me more than one line. I have tried duplicating it and changing the values... but it just updates which line it is displaying instead of the first and second one...
_root.setlist = this.firstChild.childNodes[0].childNodes[0].firstChild.nodeValue;
Inside of my XML document it is layed out like this....
<shows>
<show>
<setlist>
<song>Song 1</song>
</song>Song 2</song>
[Code]...
View 12 Replies
Mar 5, 2010
and E4X to pull in an XML file. I am wishing to display some text as subscipt. E.G with
G2, the 2 would be subscripted.if this can be done and if so how?
View 14 Replies
Aug 6, 2009
I am trying to create this slide show application that will show product information (Tennis Rackets) based on diffrent categories. A great programmer advised me that OOP would be a way to go, however i am having a difficulty with it.
I created: A document class called CustomClass --> this class downloads all XML data from the server and pushing the content of it into Arrays based on a category.These arrays are public, there is also a funciton iterateArray which places the children information somewhere.
[Code]...
View 7 Replies
Jan 12, 2009
Wondering if anyone can tell me whether it is possible to take an excel spreadsheet with its equations and all and place it into a Flash file so that it can work within the flash presentation.
Or would the only way to do this be to code the whole thing into flash from the start?
View 6 Replies
Oct 25, 2010
Is there any open source flash based spreadsheet application like google spreadsheets?
View 2 Replies
Sep 23, 2006
Newbie to XML here and I have what I *hope* is an easy problem, but I just don't know the answer. And as I have to try and show this by Monday, I'm sort of stuck. I am trying to pull in information about houses via an xml file. Each house has 1 address, 1 owner, 1 description, and about 6 photos. I have no problem accessing the address, owner, etc, and I can always access the first photo, but whenever I cycle through the photos, I seem to cycle through the first photo for every house, not every photo for each house.
Basically, I need the children <images> to go up by one, without the the parent going up by 1. I am hoping I am describing this well. My code looks like this:
[Code]...
View 4 Replies
Jul 24, 2010
I am trying to pull in information about houses via an xmlfile. Each house has 1 address, 1 owner, 1 description, and about 6photos. I have no problem accessing the address, owner, etc, and Ican always access the first photo, but whenever I cycle through thephotos, I seem to cycle through the first photo for every house,not every photo for each house.Basically, I need the children <images> to go up byone, without the the parent going up by 1. I am hoping I amdescribing this well.My code looks like this:
total = xmlNode.childNodes.length;
totalb =
xmlNode.childNodes[0].childNodes[5].childNodes.length;
[code].....
View 1 Replies
Jan 13, 2010
I'm looking for recommendations for a spreadsheet-like input facility to sit in an ASP MVC environment.
The client currently has a large number of very complex interlinked shared spreadsheets (which they are effectively running 90% of their core business from) for collecting and processing information. They wish to move this to a web application and require ASP MVC. They realise that they will not be able to display as much information on screen as they do currently with their spreadsheets, so a 40 x 60 grid should suffice in most cases. Of this they'll be a limited number of cells for data entry that will immediately update other cells in the grid using various spreadsheet-like formula. The grid must be AJAX enabled.
The quality of the user-interface is of primary concern here. As inevitably there will be a certain amount of resistance to move to database/web (and this project is a pilot anyway) the system must be as slick as possible. Almost as important is ease of implementation - the final system will be quite large so the quicker it is possible to configure the grid the better.
Either Open Source or commercial would be fine. HTML/Javascript, Silverlight and Flex implementations can all be considered.I initially asked a similar question a year ago (it's taken that long for the client to agree the project) but I'm sure options have changed since then and our environment is now better defined.
View 5 Replies
Mar 30, 2011
I want access gps coordinates from a Google spreadsheet to be able to position markers in my google maps flex air app.
I have made the spreadsheet public for anyone with the link.
View 1 Replies
Jan 15, 2010
I am creating a simple program which writes a string to a spreadsheet when it is copied to the system clipboard. Everything works great, except that if the text copied has multiple paragraphs and therefore has returns in it, when written to the file, they get interpretted as going to the next row of the spreadsheet. The, instead of writing all the text to one cell, the paragraphs get split up into multiple cells on multiple rows. How does one format the string so that paragraphs are still sepearated by a space, but it will write all of the text in one cell?
edit: Here's my code if it matters
Code:
stop()
Clipboard.generalClipboard.clear()
var file:File=File.desktopDirectory.resolvePath("communication of uncertainty data.ods");
var stream:FileStream = new FileStream();
[code]....
View 3 Replies
Jun 14, 2010
I imported two projects in Flex Builder 3 (A and B). Those two projects A and B are in the same folder and in mxml file which is located in A/src I have
<mx:Style source="../../B/b/assets/b.css" />
this relative path is correct, but Flex Builder keeps showing message: "Problem finding external stylesheet: ../../B/b/assets/b.css"
What am I doing wrong? Btw, I am newbie in flex, so,
View 1 Replies
Apr 6, 2009
if i have a name text field and the users type their name in and click submit, what code would i need to tell the form to send info like a google online spreadsheet or excel file?
i have a feeling ill need to use a xml file with scripts...but no idea where to start
View 1 Replies
Aug 7, 2009
Is it possible to create a contact form and have it saved onto an existing spreadsheet or xml file or text file on the hard drive without having to be connect to the internet?
View 0 Replies
Aug 17, 2009
I have a list of items in a database as well as images in a directory folder. I am looking for a flash app that can pull from the database to display the info and also the images and scroll this info vertically with associated links. I need to change this for each client by adding their unique "ID" in the code so their information pulls in correctly.
View 1 Replies
Sep 20, 2007
I have a xml like so:
<job>
<title/>
<items>
<item>
[Code]....
Basically I pulll xml data into flash and most comes in, but only the first set will show the name, after that it goes to "undefined". Secondly, I can't pull in the info.
View 2 Replies
Sep 12, 2011
I'm currently doing a project that has to be multi-lingual. I need to be able to use Flash Var's to locate the XML file.why the below code does not work?ere is my AS3 code:
var xmlPath:String;
xmlPath = root.loaderInfo.parameters(encodeURIComponent["xmlPath"]);
Here is my HTML code:
[code].....
View 1 Replies
Nov 27, 2004
so i got the info all in the database and then i have a php page that goes and retrieves the id that the e-mail sent through. here is my code on the load.php page so far:
[Code]...
View 6 Replies
Sep 27, 2007
I have a quick question that I am not 100% sure on. In my program I need flash to recognise if the object it is pulling in from XML is an: image/sound/mvie or animation. In XML the tag looks like this:
Code:
<mult_file type= "image" alt="alt text">intro.jpg</mult_file>.what I need flash to do is read the file type of it - I know how to put nodes in but how would I get it to find the type?
View 10 Replies
Jun 15, 2008
I am pulling a blog into flash through an XML sheet. I have a clip in the library that gets attached per blog entry. The issue I am having right now is not all the posts are the same length so I am trying to adjust the clips background to the height of the post text box, but they are all reading as the same height so they aren't properly adjusting. I even have the text boxes set to autoSize = true;
Here is my code..the resizeBlog function is where I am trying to resize it and then I want to adjust its y property accordingly.
[code]...
View 13 Replies
Nov 27, 2004
i got the info all in the database and then i have a php page that goes and retrieves the id that the e-mail sent through. here is my code on the load.php page so far:
PHP Code:
<?php
//database connect
require_once("connect.php");[code]...
now i've got all the records of value $card (lets say 8 for this instance) pulled into this php page, how would i go about loading them into flash with loadVars()? for the record names, i used this line to originally insert them:
PHP Code:
$result = mysql_query("INSERT into ecard (fname, femail, tname, temail, message) values ('$fromName', '$fromEmail', '$toName', '$toEmail', '$message')");
View 6 Replies
Feb 26, 2010
I'm currently looking to use Flash to pull in two separate media files and to play them at the same time. From what I know about Flash, it's certainly possible to play two files, but is it possible to play files without embedding them in the Flash file?
View 3 Replies
