<div dir="ltr"><div><div><div><div>Dear Roman,<br></div>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.<br><br></div><div>Haven't tried it myself.<br>
<br></div></div>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].<br>
<br></div>HTH,<br>JON HAITZ<br><br><div><div>
<div><div><div><br>[1] <a href="http://dev.mysql.com/doc/refman/4.1/en/blob.html" target="_blank">http://dev.mysql.com/doc/refman/4.1/en/blob.html</a><br>[2] <a href="http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html</a><br>
[3] <a href="http://www.vtk.org/Wiki/VTK/Examples/Cxx/Databases/SQL/MySQL/WriteToDatabase" target="_blank">http://www.vtk.org/Wiki/VTK/Examples/Cxx/Databases/SQL/MySQL/WriteToDatabase</a><br><br><div><div><div class="gmail_extra">
<br><div class="gmail_quote">
On 21 May 2014 14:07, Роман Глуховский <span dir="ltr"><<a href="mailto:roman_glu@mail.ru" target="_blank">roman_glu@mail.ru</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div><p dir="ltr">Can somebody tell me how i can insert the .mhd File into the table? </p>
<p dir="ltr">Thank you</p>
<p dir="ltr">--<br>
Отправлено из мобильной Почты <a href="http://r.mail.ru/n121628926" target="_blank">Mail.Ru</a><br></p>
<p dir="ltr">Dienstag, 13 Mai 2014, 03:30PM +0200 от Dženan Zukić <<a href="mailto:dzenanz@gmail.com" target="_blank">dzenanz@gmail.com</a>>:</p><div><div>
<p dir="ltr">In addition to creating database, you also need to create a table before you can fill that table.</p>
<p dir="ltr">On Tue, May 13, 2014 at 1:34 PM, Роман Глуховский < <a href="mailto:roman_glu@mail.ru" target="_blank">roman_glu@mail.ru</a> > wrote:<br>
>Thank you for your response.<br>
>Now i can write my loaded Dicom-Series on my harddisc as .raw and .mhd.<br>
><br>
>It works to create a database, but when i try to write something, like in the example<br>
><a href="http://www.vtk.org/Wiki/VTK/Examples/Cxx/Databases/SQL/MySQL/WriteToDatabase" target="_blank">http://www.vtk.org/Wiki/VTK/Examples/Cxx/Databases/SQL/MySQL/WriteToDatabase</a><br>
>I get this error:<br>
><br>
>ERROR: In /home/joe/Programme/VTK-6.1.0/IO/MySQL/vtkMySQLQuery.cxx, line 588<br>
>vtkMySQLQuery (0xb116f0): Query returned an error: Table 'TestDatabase.TestTable' doesn't exist.<br>
><br>
>Roman<br>
><br>
><br>
><br>
>Sun, 11 May 2014 12:44:59 +0200 от Jon Haitz Legarreta < <a href="mailto:jhlegarreta@vicomtech.org" target="_blank">jhlegarreta@vicomtech.org</a> >:<br>
><br>
>>Hi Роман ,<br>
>>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.<br>
>><br>
>>As Matt said in a reply to another post [1], saving to metaimage format after having applied some image processing may be better.<br>
>><br>
>>HTH,<br>
>>JON HAITZ<br>
>><br>
>>[1] <a href="http://public.kitware.com/pipermail/community/2014-April/002149.html" target="_blank">http://public.kitware.com/pipermail/community/2014-April/002149.html</a><br>
>><br>
>><br>
>><br>
>>On 8 May 2014 18:39, Dženan Zukić < <a href="mailto:dzenanz@gmail.com" target="_blank">dzenanz@gmail.com</a> > wrote:<br>
>>>He wants to save a processed (thresholded) image.<br>
>>><br>
>>><br>
>>>On Thu, May 8, 2014 at 6:20 PM, John Drescher < <a href="mailto:drescherjm@gmail.com" target="_blank">drescherjm@gmail.com</a> > wrote:<br>
>>>>>Of course, but the database must support large binary object type or something similar. Alternatively you could apply some binary-to-text encoding .<br>
>>>><br>
>>>>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.<br>
>>>><br>
>>>>John<br>
>>><br>
>>><br>
>>>_____________________________________<br>
>>>Powered by <a href="http://www.kitware.com" target="_blank">www.kitware.com</a><br>
>>><br>
>>>Visit other Kitware open-source projects at<br>
>>><a href="http://www.kitware.com/opensource/opensource.html" target="_blank">http://www.kitware.com/opensource/opensource.html</a><br>
>>><br>
>>>Kitware offers ITK Training Courses, for more information visit:<br>
>>><a href="http://www.kitware.com/products/protraining.php" target="_blank">http://www.kitware.com/products/protraining.php</a><br>
>>><br>
>>>Please keep messages on-topic and check the ITK FAQ at:<br>
>>><a href="http://www.itk.org/Wiki/ITK_FAQ" target="_blank">http://www.itk.org/Wiki/ITK_FAQ</a><br>
>>><br>
>>>Follow this link to subscribe/unsubscribe:<br>
>>><a href="http://www.itk.org/mailman/listinfo/insight-users" target="_blank">http://www.itk.org/mailman/listinfo/insight-users</a><br>
>>><br>
>><br>
>>_____________________________________<br>
>>Powered by <a href="http://www.kitware.com" target="_blank">www.kitware.com</a><br>
>><br>
>>Visit other Kitware open-source projects at<br>
>><a href="http://www.kitware.com/opensource/opensource.html" target="_blank">http://www.kitware.com/opensource/opensource.html</a><br>
>><br>
>>Kitware offers ITK Training Courses, for more information visit:<br>
>><a href="http://www.kitware.com/products/protraining.php" target="_blank">http://www.kitware.com/products/protraining.php</a><br>
>><br>
>>Please keep messages on-topic and check the ITK FAQ at:<br>
>><a href="http://www.itk.org/Wiki/ITK_FAQ" target="_blank">http://www.itk.org/Wiki/ITK_FAQ</a><br>
>><br>
>>Follow this link to subscribe/unsubscribe:<br>
>><a href="http://www.itk.org/mailman/listinfo/insight-users" target="_blank">http://www.itk.org/mailman/listinfo/insight-users</a><br>
>><br>
></p>
</div></div></div>
</blockquote></div><br></div></div></div></div></div></div></div></div></div>