Clickteam Fusion and database

Welcome to our brand new Clickteam Community Hub! We hope you will enjoy using the new features, which we will be further expanding in the coming months.

A few features including Passport are unavailable initially whilst we monitor stability of the new platform, we hope to bring these online very soon. Small issues will crop up following the import from our old system, including some message formatting, translation accuracy and other things.

Thank you for your patience whilst we've worked on this and we look forward to more exciting community developments soon!

Clickteam.
  • 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

    a selection of my Fusion examples can be found Please login to see this link.

  • 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.

    Regards

    Ross

    Please login to see this link.

  • 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 :(

    a selection of my Fusion examples can be found Please login to see this link.

    Edited once, last by schrodinger (January 21, 2016 at 9:44 PM).

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!