[vtkusers] [ITK-users] Fwd: problem with convert itk to vtk

[Jon Haitz Legarreta]

Dear Roman,
I guess you'll need to know how to insert a blob into your mySQL database
[1], then build the appropriate query [3], and let VTK do the job.

Haven't tried it myself.

Another workaround, although perhaps riskier because you'd depende on two
locations in your disk, is may be to store the path to the .mhd file. Or
else, to read the file and store its contents into a table [2].

HTH,
JON HAITZ


[1] http://dev.mysql.com/doc/refman/4.1/en/blob.html
[2] http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html
[3]
http://www.vtk.org/Wiki/VTK/Examples/Cxx/Databases/SQL/MySQL/WriteToDatabase


On 21 May 2014 14:07, Роман Глуховский <roman_glu at mail.ru> wrote:

> Can somebody tell me how i can insert the .mhd File into the table?
>
> Thank you
>
> --
> Отправлено из мобильной Почты Mail.Ru <http://r.mail.ru/n121628926>
>
> Dienstag, 13 Mai 2014, 03:30PM +0200 от Dženan Zukić <dzenanz at gmail.com>:
>
> In addition to creating database, you also need to create a table before
> you can fill that table.
>
> On Tue, May 13, 2014 at 1:34 PM, Роман Глуховский  < roman_glu at mail.ru >
> wrote:
> >Thank you for your response.
> >Now i can write my loaded Dicom-Series on my harddisc as .raw and .mhd.
> >
> >It works to create a database, but when i try to write something, like in
> the example
> >
> http://www.vtk.org/Wiki/VTK/Examples/Cxx/Databases/SQL/MySQL/WriteToDatabase
> >I get this error:
> >
> >ERROR: In /home/joe/Programme/VTK-6.1.0/IO/MySQL/vtkMySQLQuery.cxx, line
> 588
> >vtkMySQLQuery (0xb116f0): Query returned an error: Table
> 'TestDatabase.TestTable' doesn't exist.
> >
> >Roman
> >
> >
> >
> >Sun, 11 May 2014 12:44:59 +0200 от Jon Haitz Legarreta <
> jhlegarreta at vicomtech.org >:
> >
> >>Hi  Роман ,
> >>since you  want to save the result of an image processing operation,
> another alternative is to save it to a .mhd/.raw metaimage, and save just
> the .mhd to your database. If you locate all your *.raw file in a given
> location, you could retrieve them reading the filename stored in the .mhd
> file.
> >>
> >>As Matt said in a reply to another post [1], saving to metaimage format
> after having applied some image processing may be better.
> >>
> >>HTH,
> >>JON HAITZ
> >>
> >>[1]
> http://public.kitware.com/pipermail/community/2014-April/002149.html
> >>
> >>
> >>
> >>On 8 May 2014 18:39, Dženan Zukić  < dzenanz at gmail.com > wrote:
> >>>He wants to save a processed (thresholded) image.
> >>>
> >>>
> >>>On Thu, May 8, 2014 at 6:20 PM, John Drescher  < drescherjm at gmail.com> wrote:
> >>>>>Of course, but the database must support large binary object type or
> something similar. Alternatively you could apply some  binary-to-text
> encoding .
> >>>>
> >>>>When I use a database for this I just put the filename of the DICOM
> file(s) in the database not the actual binary blob.
> >>>>
> >>>>John
> >>>
> >>>
> >>>_____________________________________
> >>>Powered by  www.kitware.com
> >>>
> >>>Visit other Kitware open-source projects at
> >>>http://www.kitware.com/opensource/opensource.html
> >>>
> >>>Kitware offers ITK Training Courses, for more information visit:
> >>>http://www.kitware.com/products/protraining.php
> >>>
> >>>Please keep messages on-topic and check the ITK FAQ at:
> >>>http://www.itk.org/Wiki/ITK_FAQ
> >>>
> >>>Follow this link to subscribe/unsubscribe:
> >>>http://www.itk.org/mailman/listinfo/insight-users
> >>>
> >>
> >>_____________________________________
> >>Powered by  www.kitware.com
> >>
> >>Visit other Kitware open-source projects at
> >>http://www.kitware.com/opensource/opensource.html
> >>
> >>Kitware offers ITK Training Courses, for more information visit:
> >>http://www.kitware.com/products/protraining.php
> >>
> >>Please keep messages on-topic and check the ITK FAQ at:
> >>http://www.itk.org/Wiki/ITK_FAQ
> >>
> >>Follow this link to subscribe/unsubscribe:
> >>http://www.itk.org/mailman/listinfo/insight-users
> >>
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.vtk.org/pipermail/vtkusers/attachments/20140522/af5ba77a/attachment.html>