Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
I've programmed many databases both in Director and Flash, and find it much more code it myself than use an xtra like V12. For your example, I would assign each module an ID number, then in Excel or FileMaker, what ever data base you want to use, match the ID number up with the paths to the content and description ID, path, description 23498, moduleOne\myPDF.pdf, descriptionHere 23498, moduleOne\myPres.ppt, descriptionHere 9, moduleTwo\myPDF.pdf, descriptionHere 9, moduleTwo\myDoc.doc, descriptionHere etc. Save the data as a CSV file, and use Amber CSV Converter (http://www.processtext.com/abccsv.html) to convert it to XML. This creates a very easily readable XML file without a lot of extra crap like you get if you convert directly from Filemaker. There are plenty of examples of how to load the XML into Flash and save it in an Array. Assign the ID numbers to the proper nodes in the tree using the data parameter. When a user chooses a node, search your array for all the matches to the ID number and display the descriptions. ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
As long as your dataset is relatively small, XML is fine, but at some point a real database is going to be needed. I'm not sure how v12 with flash is going to work, but I have used Valentina with Director, and when you have 10's of thousands of records, you can't afford the disk space or speed penalty of xml files on a CD On Feb 25, 2006, at 12:37 PM, Danny wrote: I've programmed many databases both in Director and Flash, and find it much more code it myself than use an xtra like V12. For your example, I would assign each module an ID number, then in Excel or FileMaker, what ever data base you want to use, match the ID number up with the paths to the content and description ID, path, description 23498, moduleOne\myPDF.pdf, descriptionHere 23498, moduleOne\myPres.ppt, descriptionHere 9, moduleTwo\myPDF.pdf, descriptionHere 9, moduleTwo\myDoc.doc, descriptionHere etc. Save the data as a CSV file, and use Amber CSV Converter (http:// www.processtext.com/abccsv.html) to convert it to XML. This creates a very easily readable XML file without a lot of extra crap like you get if you convert directly from Filemaker. There are plenty of examples of how to load the XML into Flash and save it in an Array. Assign the ID numbers to the proper nodes in the tree using the data parameter. When a user chooses a node, search your array for all the matches to the ID number and display the descriptions. ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
That sounded interesting after reading the first sentence, after the second I knew we couldn't use it, Clark. Becasue we have to create something that works out of the box, - no installation required. I was thinking of the XML version already as well, but sometimes I am thinking that a db would be the cleaner soplution, and also offer less chance to mess up the file if it happens to be run from hard disk? But I only have some experience with databases, not very much with XML. Thanks for your thoughts! I'll check out SWFStudio nevertheless. Nik C On 23/02/06, clark slater [EMAIL PROTECTED] wrote: Hi Nik, Check out SWFStudio, it offers ADO connectivity. Downside is ADO has to be installed on the machine. Alternatively check out the Catalog plugin for SWFStudio - offers search functions through a flat tab delimited file. We used it to do exactly what you describe for a HUGE floor tile manufacturer's sample CD. Clark On 2/23/06, nik crosina [EMAIL PROTECTED] wrote: *Flash connecting to a database - all running on a DVD-ROM? * Is it possible? I am looking into doing exactly that for a massive trainig programme that needs to access and display a large number of modules in treeView (Flash Tree component) where each node connects to a record in the database that contains information the content (pointer to powerpoint, video, excel, doc, etc file) as well as subtitles (if the content is a video) If that description is too confusing then an answer to my basic question owuld be fantastic!! -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
Yes, That sounds like a fanastic option, I'll check that out for sure! Nik C On 24/02/06, Julien Vignali [EMAIL PROTECTED] wrote: Nik, I would suggest you to take a look at Zinc from Multidmedia. This great SWF2EXE tool offers MS Access MySQL database connectivity and a lot more thanks to {mdm}Script 2.0. Check out its features at http://www.multidmedia.com/software/zinc Hope it helps, Julien Vignali nik crosina a écrit : *Flash connecting to a database - all running on a DVD-ROM? * Is it possible? I am looking into doing exactly that for a massive trainig programme that needs to access and display a large number of modules in treeView (Flash Tree component) where each node connects to a record in the database that contains information the content (pointer to powerpoint, video, excel, doc, etc file) as well as subtitles (if the content is a video) If that description is too confusing then an answer to my basic question owuld be fantastic!! -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
Take a look at this one : http://www.inm.com/products/v12flash/ Sound promissing! Éric. nik crosina wrote: That sounded interesting after reading the first sentence, after the second I knew we couldn't use it, Clark. Becasue we have to create something that works out of the box, - no installation required. I was thinking of the XML version already as well, but sometimes I am thinking that a db would be the cleaner soplution, and also offer less chance to mess up the file if it happens to be run from hard disk? But I only have some experience with databases, not very much with XML. Thanks for your thoughts! I'll check out SWFStudio nevertheless. Nik C On 23/02/06, clark slater [EMAIL PROTECTED] wrote: Hi Nik, Check out SWFStudio, it offers ADO connectivity. Downside is ADO has to be installed on the machine. Alternatively check out the Catalog plugin for SWFStudio - offers search functions through a flat tab delimited file. We used it to do exactly what you describe for a HUGE floor tile manufacturer's sample CD. Clark On 2/23/06, nik crosina [EMAIL PROTECTED] wrote: *Flash connecting to a database - all running on a DVD-ROM? * Is it possible? I am looking into doing exactly that for a massive trainig programme that needs to access and display a large number of modules in treeView (Flash Tree component) where each node connects to a record in the database that contains information the content (pointer to powerpoint, video, excel, doc, etc file) as well as subtitles (if the content is a video) If that description is too confusing then an answer to my basic question owuld be fantastic!! -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
v12 and Flash! can onl;y be a good thing! I know it from director! good old inm! thanks, Nik On 2/24/06, Éric Thibault [EMAIL PROTECTED] wrote: Take a look at this one : http://www.inm.com/products/v12flash/ Sound promissing! Éric. nik crosina wrote: That sounded interesting after reading the first sentence, after the second I knew we couldn't use it, Clark. Becasue we have to create something that works out of the box, - no installation required. I was thinking of the XML version already as well, but sometimes I am thinking that a db would be the cleaner soplution, and also offer less chance to mess up the file if it happens to be run from hard disk? But I only have some experience with databases, not very much with XML. Thanks for your thoughts! I'll check out SWFStudio nevertheless. Nik C On 23/02/06, clark slater [EMAIL PROTECTED] wrote: Hi Nik, Check out SWFStudio, it offers ADO connectivity. Downside is ADO has to be installed on the machine. Alternatively check out the Catalog plugin for SWFStudio - offers search functions through a flat tab delimited file. We used it to do exactly what you describe for a HUGE floor tile manufacturer's sample CD. Clark On 2/23/06, nik crosina [EMAIL PROTECTED] wrote: *Flash connecting to a database - all running on a DVD-ROM? * Is it possible? I am looking into doing exactly that for a massive trainig programme that needs to access and display a large number of modules in treeView (Flash Tree component) where each node connects to a record in the database that contains information the content (pointer to powerpoint, video, excel, doc, etc file) as well as subtitles (if the content is a video) If that description is too confusing then an answer to my basic question owuld be fantastic!! -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
How about SWF Studio and SQLite? SQLite is a no-install database solution. Check out Andre Goliath's site: http://www.software-and-solutions.de/ He's put together a SQLite connector for SWF Studio. I don't know what the cost of v12flash will be (it's in beta right now), but judging by the pricing for their Director equivalent, the SWF Studio/SQLite option would be slightly cheaper, and of course you get a lot more than just database features with SWF Studio. Just another option. Derek Vadneau Northcode Inc. http://www.northcode.com - Original Message - From: nik crosina [EMAIL PROTECTED] To: Flashcoders mailing list flashcoders@chattyfig.figleaf.com Sent: Friday, February 24, 2006 12:28 PM Subject: SPAM-LOW: Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM v12 and Flash! can onl;y be a good thing! I know it from director! good old inm! thanks, Nik On 2/24/06, Éric Thibault [EMAIL PROTECTED] wrote: Take a look at this one : http://www.inm.com/products/v12flash/ Sound promissing! Éric. nik crosina wrote: That sounded interesting after reading the first sentence, after the second I knew we couldn't use it, Clark. Becasue we have to create something that works out of the box, - no installation required. I was thinking of the XML version already as well, but sometimes I am thinking that a db would be the cleaner soplution, and also offer less chance to mess up the file if it happens to be run from hard disk? But I only have some experience with databases, not very much with XML. Thanks for your thoughts! I'll check out SWFStudio nevertheless. Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
Are all of the data and referenced files on the DVD? We have done a database of Personal Protective Equipment for first responder with pictures of each piece of equipment and full descriptions on a CD. Built a search engine in Flash to select items based on several criteria. The pictures where stored as files and the database was just an XML file. Ron nik crosina wrote: *Flash connecting to a database - all running on a DVD-ROM? * Is it possible? I am looking into doing exactly that for a massive trainig programme that needs to access and display a large number of modules in treeView (Flash Tree component) where each node connects to a record in the database that contains information the content (pointer to powerpoint, video, excel, doc, etc file) as well as subtitles (if the content is a video) If that description is too confusing then an answer to my basic question owuld be fantastic!! -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Flash connecting to a database - all running on a DVD-ROM
Hi Nik, Check out SWFStudio, it offers ADO connectivity. Downside is ADO has to be installed on the machine. Alternatively check out the Catalog plugin for SWFStudio - offers search functions through a flat tab delimited file. We used it to do exactly what you describe for a HUGE floor tile manufacturer's sample CD. Clark On 2/23/06, nik crosina [EMAIL PROTECTED] wrote: *Flash connecting to a database - all running on a DVD-ROM? * Is it possible? I am looking into doing exactly that for a massive trainig programme that needs to access and display a large number of modules in treeView (Flash Tree component) where each node connects to a record in the database that contains information the content (pointer to powerpoint, video, excel, doc, etc file) as well as subtitles (if the content is a video) If that description is too confusing then an answer to my basic question owuld be fantastic!! -- Nik C ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com