This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Export Customer List from Firebird

Former Member
Former Member
I work for an Office Automation company who sells Konica Minolta printers. We sell scan solutions which use an embedded java client on our printers. This lets the user answer questions directly from the touch-screen of the device. We then save the scan and an XML file with the answers to be used as metadat when imported into M-Files. The embedded software is called Document Navigator and allows me to create dropdown lists from SQL queries, XML files or VBScripts.
:o

I am not a programmer and I am looking for a way to easily query the firebird database to retrieve a list of Customers from M-FIles. Many of my clients do not own SQL and I would like to try find a more affordable solutions.

I tried to create an ODBC conx to the firebird database but do not have the password.
:'(

Can you think of any way that I can either automate a data export from M-files as XML or even to another SQL database to be used in our capture software.

If I can find a solution to this it will greatly increase our sales of M-Files. I would even be happy to pay if the amount isn't too high.

Thanks in advance.

Darren
  • Former Member
    Former Member
    Hi Darren,

    i work for a company who sells Konica Minolta MFP too and have the same request...
    Did you have had some answer for this old topic ?

    Cheers
    Boc
  • Former Member
    Former Member
    Install SQL Express Edition
    Create Customer table in SQL Express with appropriate columns (SQL management studio can handle)
    Connect your M-Files Customer Object Type to the SQL table, check the insert/update boxes in the GUI, map the table columns to M-Files fields and click any default button you see.
    *presto* you're done.
    drink coffee.
  • Former Member
    Former Member
    Hi pschokker,

    Many thanks for this brillant idea ! That works really fine.

    Boc