User Tag List

Results 1 to 6 of 6

Thread: Clickteam Fusion and database

  1. #1
    Clicker Fusion 2.5 DeveloperAndroid Export Module
    Fusion 2.5 (Steam)Android Export Module (Steam)

    Join Date
    Sep 2008
    Posts
    79
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Clickteam Fusion and database

    Hi!
    Is possible create and manage database and export strings in fusion?.. ,For exemple: open this database in Microsoft Excell as table format?
    Thks!

  2. #2
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export Module
    Fusion 2.5 (Steam)
    schrodinger's Avatar
    Join Date
    Nov 2014
    Posts
    3,155
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)
    You can export a comma delimited set of values to be imported in excel,
    by building this list and saving text through list object or file object (append text to a file),
    also, Named Variable Object extension has builtin save to .csv feature

    Don't know of any direct "text to .xls/.xlsx" feature however

    No database-to excel either,
    but you could build a little tool to cycle your database and output to .csv as above
    and if you use a SQLite database, you can use the SQLite extension

  3. #3
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleSWF Export ModuleInstall Creator ProPatch Maker
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Fusion 2.5+ DLC (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)Universal Windows Platform Export Module (Steam)
    DJFuego's Avatar
    Join Date
    Jul 2006
    Location
    UK
    Posts
    1,410
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    You could do this back in MMF 2.0 we had more SQL objects and a wonderful com+ object what this allowed you to do was connect via com connection to any application that provided this functionality and do what you wanted.
    Handy for Outlook and Excel. It's a shame that these objects don't transition to Fusion 2.5 with full functionality any more due to the age of them and the developers have not brought them up to date. Otherwise we would be able to do a lot more.

  4. #4
    Clicker Fusion 2.5 DeveloperAndroid Export Module
    Fusion 2.5 (Steam)Android Export Module (Steam)

    Join Date
    Sep 2008
    Posts
    79
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    wow... Tanhks!
    no way to conect with Microsof Acess too?
    Using ODBC extension or maybe active X object?


    My intention is to do something like the image automatically, using any database
    Images attachées Images attachées

  5. #5
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export Module
    Fusion 2.5 (Steam)
    schrodinger's Avatar
    Join Date
    Nov 2014
    Posts
    3,155
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)
    Yeah I guess you can draw data out of a Access Database with ODBC object,
    though I never personally tried, it should definitely work.

    In fact, it should even be able to dialogue with Excel spreadsheets...
    not 100% sure on the other sense though - doing insert/update on Excel should be not possible
    while with Access you could probably even send those SQL commands.

    You need your tool to work on your computer only, or doing some tool for other users...?
    What exactly are you going to do with this?

    Maybe we can give some more suitable idea


    EDIT_
    sorry I see your attached file only now.
    Mmmm.. you want to output a proper excel file straight from Fusion,
    without inbetween passages like loading data FROM the excel file.I guess...
    Not sure there's a fine way to do that.
    Some external tool allows for .txt to .xls conversion, but they are probably payment or anyway wouldn't allow you to "embed" them inside your application.
    ... no doable way I can think of actually ... hope someone can provide some other answer

  6. #6
    Clicker Fusion 2.5 DeveloperAndroid Export Module
    Fusion 2.5 (Steam)Android Export Module (Steam)

    Join Date
    Sep 2008
    Posts
    79
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I goin to do a system made in fusion to generate reports to Excell format... Because Clickteam Fusion not expor to PDF format.
    This system would be to my work.

Similar Threads

  1. Online Database with Clickteam Fusion 2.5 - GET object and String Parser
    By Sparckman in forum Guides, Tutorials, Examples, Widgets
    Replies: 8
    Last Post: 3rd November 2015, 03:06 PM
  2. Database with Clickteam Fusion 2.5 - Insert New Records
    By Sparckman in forum Guides, Tutorials, Examples, Widgets
    Replies: 0
    Last Post: 23rd October 2014, 05:40 AM
  3. Clickteam web/database server
    By droberson in forum Multimedia Fusion 2 - Technical Support
    Replies: 17
    Last Post: 18th January 2009, 12:53 AM
  4. MMF2 - Which SQL database will Clickteam support
    By droberson in forum Multimedia Fusion 2 - Technical Support
    Replies: 7
    Last Post: 28th August 2008, 02:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •