BLOB image from Filemaker to Mysql

[philou54]

Hi again

Same problem, but in the reverse way. I can't export a multimdedia field from filemaker into a BLOB field in mysql.

In fact, it works a little bit because it shows me that the BLOB field is not empty (approximatively 9 bytes). I don't understand why? Any ideas?

The image from filemaker is not stored "as a reference"

Thanks

[Genx]

I was about to say is it stored as a reference... um. Hmmm, not sure. How are you trying to do this "export" exactly?

[philou54]

Hi Genx

In fact I do SQL execute with all my fields

[Genx]

Well, I believe it's just passing the text data int he container (i.e. go to tools->dataviewer and look at your container field).

Anyway, um, I think the only way you might be able to do this is by making a call to FileMaker via an ODBC driver (or try playing with it until you get it working).

[philou54]

Obviously you'are right, it's just passing the text data.

So I'm stuck?

What do you mean by "making a call to filemaker"?

[Genx]

Well, I didn't say you were stuck, i just said I don't know how to do it lol.

What i was referring to with "making a call to FM" was that you can use FM as your ODBC host (i.e. use the FM ODBC Driver) and make the call from MySQL for the container field in which case it MAY take the blobiness instead of the text data. I'd love to tell you if this works, but to be honest i've only ever tried it in the one direction of MySQL -> FM.

[The Shadow]

The odbc/jdbc guide says how:

http://www.filemaker.com/downloads/documentation/fm8_odbc_jdbc_developer.pdf

Use the GetAs() function described on pages 27-28. It looks something like:

  select GetAs( container, 'JPEG' ) from myTable

to return the actual binary data. The guide has a list of possible types also.

[Genx]

Thanks Shawn

[philou54]

I'm not sure I get what you said and what I red in this document (maybe because I'm french -)

Where should I put this statement with the "GetAS" function?

Is it a Filemaker function or a mysql/php one?

thanks

Sorry for being so dumy

[Genx]

Hi Philou,

If you read the documentation Shawn posted, it's pretty logical (edit: oh your french... there's probably a french version... probably)

SELECT GETAS(yourcontainer, 'JPEG') FROM YourTable

The essential bit there is GETAS(container, 'type')

Edited June 22, 2007 by Guest

[philou54]

Hi

Is it the field from Filemaker or from Mysql?

When I insert the "Getas" function it tells me "function unknown".

Can you post an example please?

Thanks a lot I'm sorry I bother you

[philou54]

I tried to find this function (in french and english version) but it does not exist. It's not a function!

I really don't understand....

[Genx]

I believe you make this call to FileMaker from something like PHP and then use an insert into statement to move it to MySQL.