Converting Faircom C-TREE database to MySQL ?

[micmac888]

This is a very open question, sorry for that but I'm relatively new to MySQL
and I'm in front of a problem for which my searches on the web gave no real
answer.

It's about database files at the Faircom C-TREE format (www.faircom.com).
Faircom software is proprietary and not open source. Three is a free limited
SDK available but that's totally new for me and I'm not sure of what can be
done or not with it yet. And I have no real knowledge of C-TREE, to be
honest, only some theory.

I would like to "convert" these kind of databases to MySQL, directly or not.
I would have to do this seeveral times a year so I'm looking for a
relatively easy and automatic solution if possible.

Is there any available ready-to-use solution? (I won't be against paying a
bit for it, but our project is totally non-commercial, so we can't spend a
lot.)

Or is there any document describing in details how to achieve this?

Or at least some clear directions?

Thanks in advance. :)

[ThanksButNo]

On Jun 2, 6:22 am, "micmac888" <MichelMspam...@owanadoo.fr> wrote:
> This is a very open question, sorry for that but I'm relatively new to MySQL
> and I'm in front of a problem for which my searches on the web gave no real
> answer.
>
> It's about database files at the Faircom C-TREE format (www.faircom.com).
> Faircom software is proprietary and not open source. Three is a free limited
> SDK available but that's totally new for me and I'm not sure of what can be
> done or not with it yet. And I have no real knowledge of C-TREE, to be
> honest, only some theory.
>
> I would like to "convert" these kind of databases to MySQL, directly or not.
> I would have to do this seeveral times a year so I'm looking for a
> relatively easy and automatic solution if possible.

The issue is getting the data OUT of Faircom. Once you can
get the data OUT, then you have any number of mechanisms for
getting the data IN to MySQL.

E.g., can you get it exported to a CSV file?

Your first step is to figure out how to get the data OUT in
some automated method(s). I don't know where you can go to
get that kind of information, other than to contact Faircom.

/:-/

[Gordon Burditt]

>This is a very open question, sorry for that but I'm relatively new to MySQL
>and I'm in front of a problem for which my searches on the web gave no real
>answer.
>
>It's about database files at the Faircom C-TREE format (www.faircom.com).
>Faircom software is proprietary and not open source. Three is a free limited
>SDK available but that's totally new for me and I'm not sure of what can be
>done or not with it yet. And I have no real knowledge of C-TREE, to be
>honest, only some theory.

Does C-TREE support SQL? If so, it should not be that hard to write
SQL for C-TREE that generates a simple file format understandable
by MySQL, such as comma-separated-values, tab-separated-values, or
even generate SQL insert statements (like mysqldump does, but
you'll probably need to do it knowing the schema involved). Then
import it into MySQL.

If not, what kind of format CAN you generate as an export format?
(Look at mysqlimport for the sort of thing MySQL can import). csv?

[bijava...@gmail.com]

Hi,

If anyone has done CTREE Database import to My sql. COuld you please let me know.

My Goal is to Import Data from C-TREE Database to Mysql Tables. Please Can any one help on this.


Appreciate your Help on this.

Thanks,
Srinivasa