Hello,
i have a problem with my time values.
im importing a CSV with time values (20:12:25.256).
My problem is RapidMiner doesnt change correctly. He shows me 20:12:25 MEZ
Here my XML:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.3.005">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="5.3.005" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="read_csv" compatibility="5.3.005" expanded="true" height="60" name="Read CSV" width="90" x="179" y="120">
<parameter key="csv_file" value="C:\Users\Kolodziej\Desktop\IVEU\Tabellen\Mammo.csv"/>
<parameter key="date_format" value="dd.MM.yyyy "/>
<list key="annotations">
<parameter key="0" value="Name"/>
</list>
<parameter key="encoding" value="windows-1252"/>
<list key="data_set_meta_data_information">
<parameter key="0" value="id.true.integer.attribute"/>
<parameter key="1" value="importdate.true.date_time.attribute"/>
<parameter key="2" value="state.true.integer.attribute"/>
<parameter key="3" value="error.true.attribute_value.attribute"/>
<parameter key="4" value="caseID.true.integer.attribute"/>
<parameter key="5" value="caseNumber.true.integer.attribute"/>
<parameter key="6" value="operatorId.true.binominal.attribute"/>
<parameter key="7" value="equipmentID.true.binominal.attribute"/>
<parameter key="8" value="FileMetaInformationGroupLength.true.attribute_value.attribute"/>
<parameter key="9" value="FileMetaInformationVersion.true.integer.attribute"/>
<parameter key="10" value="MediaStorageSOPClassUID.true.binominal.attribute"/>
<parameter key="11" value="MediaStorageSOPInstanceUID.true.polynominal.attribute"/>
<parameter key="12" value="TransferSyntaxUID.true.binominal.attribute"/>
<parameter key="13" value="ImplementationClassUID.true.binominal.attribute"/>
<parameter key="14" value="ImplementationVersionName.true.polynominal.attribute"/>
<parameter key="15" value="SourceApplicationEntityTitle.true.attribute_value.attribute"/>
<parameter key="16" value="ImageType.true.polynominal.attribute"/>
<parameter key="17" value="RecognitionCode.true.attribute_value.attribute"/>
<parameter key="18" value="InstanceCreationDate.true.date.attribute"/>
<parameter key="19" value="InstanceCreationTime.true.binominal.attribute"/>
<parameter key="20" value="InstanceCreatorUID.true.attribute_value.attribute"/>
<parameter key="21" value="SOPClassUID.true.binominal.attribute"/>
<parameter key="22" value="SOPInstanceUID.true.polynominal.attribute"/>
<parameter key="23" value="RelatedGeneralSOPClassUID.true.attribute_value.attribute"/>
<parameter key="24" value="OriginalSpecializedSOPClassUID.true.attribute_value.attribute"/>
<parameter key="25" value="StudyDate.true.date.attribute"/>
<parameter key="26" value="SeriesDate.true.date.attribute"/>
<parameter key="27" value="AcquisitionDate.true.date.attribute"/>
<parameter key="28" value="ContentDate.true.date.attribute"/>
<parameter key="29" value="OverlayDate.true.date.attribute"/>
<parameter key="30" value="CurveDate.true.date.attribute"/>
<parameter key="31" value="AcquisitionDateTime.true.numeric.attribute"/>
<parameter key="32" value="StudyTime.true.polynominal.attribute"/>
<parameter key="33" value="SeriesTime.true.nominal.attribute"/>
<parameter key="34" value="AcquisitionTime.true.nominal.attribute"/>
<parameter key="35" value="ContentTime.true.nominal.attribute"/>
<parameter key="36" value="OverlayTime.true.nominal.attribute"/>
<parameter key="37" value="CurveTime.true.nominal.attribute"/>
<parameter key="38" value="DataSetType.true.attribute_value.attribute"/>
<parameter key="39" value="DataSetSubtype.true.attribute_value.attribute"/>
<parameter key="40" value="AccessionNumber.true.binominal.attribute"/>
<parameter key="41" value="Modality.true.binominal.attribute"/>
<parameter key="42" value="ModalitiesInStudy.true.binominal.attribute"/>
<parameter key="43" value="SOPClassesInStudy.true.attribute_value.attribute"/>
<parameter key="44" value="ConversionType.true.binominal.attribute"/>
<parameter key="45" value="PresentationIntentType.true.binominal.attribute"/>
<parameter key="46" value="Manufacturer.true.polynominal.attribute"/>
<parameter key="47" value="InstitutionName.true.polynominal.attribute"/>
<parameter key="48" value="InstitutionAddress.true.polynominal.attribute"/>
<parameter key="49" value="InstitutionCodeSequence.true.attribute_value.attribute"/>
<parameter key="50" value="ReferringPhysicianName.true.binominal.attribute"/>
<parameter key="51" value="ReferringPhysicianAddress.true.attribute_value.attribute"/>
<parameter key="52" value="ReferringPhysicianTelephoneNumbers.true.attribute_value.attribute"/>
<parameter key="53" value="ReferringPhysicianIdentificationSequence.true.attribute_value.attribute"/>
<parameter key="54" value="CodeValue.true.attribute_value.attribute"/>
<parameter key="55" value="CodingSchemeDesignator.true.attribute_value.attribute"/>
<parameter key="56" value="CodingSchemeVersion.true.attribute_value.attribute"/>
<parameter key="57" value="CodeMeaning.true.attribute_value.attribute"/>
<parameter key="58" value="StationName.true.polynominal.attribute"/>
<parameter key="59" value="StudyDescription.true.binominal.attribute"/>
<parameter key="60" value="ProcedureCodeSequence.true.attribute_value.attribute"/>
<parameter key="61" value="SeriesDescription.true.polynominal.attribute"/>
<parameter key="62" value="SeriesDescriptionCodeSequence.true.attribute_value.attribute"/>
<parameter key="63" value="InstitutionalDepartmentName.true.binominal.attribute"/>
<parameter key="64" value="PhysiciansOfRecord.true.binominal.attribute"/>
<parameter key="65" value="PhysiciansOfRecordIdentificationSequence.true.attribute_value.attribute"/>
<parameter key="66" value="PerformingPhysicianName.true.binominal.attribute"/>
<parameter key="67" value="PerformingPhysicianIdentificationSequence.true.attribute_value.attribute"/>
<parameter key="68" value="NameOfPhysiciansReadingStudy.true.attribute_value.attribute"/>
<parameter key="69" value="PhysiciansReadingStudyIdentificationSequence.true.attribute_value.attribute"/>
<parameter key="70" value="OperatorsName.true.binominal.attribute"/>
<parameter key="71" value="OperatorIdentificationSequence.true.attribute_value.attribute"/>
<parameter key="72" value="AdmittingDiagnosesDescription.true.attribute_value.attribute"/>
<parameter key="73" value="AdmittingDiagnosesCodeSequence.true.attribute_value.attribute"/>
<parameter key="74" value="ManufacturerModelName.true.polynominal.attribute"/>
<parameter key="75" value="ReferencedResultsSequence.true.attribute_value.attribute"/>
<parameter key="76" value="ReferencedStudySequence.true.binominal.attribute"/>
<parameter key="77" value="ReferencedPerformedProcedureStepSequence.true.attribute_value.attribute"/>
<parameter key="78" value="ReferencedSeriesSequence.true.attribute_value.attribute"/>
<parameter key="79" value="ReferencedPatientSequence.true.attribute_value.attribute"/>
<parameter key="80" value="ReferencedVisitSequence.true.attribute_value.attribute"/>
<parameter key="81" value="ReferencedImageSequence.true.attribute_value.attribute"/>
<parameter key="82" value="ReferencedCurveSequence.true.attribute_value.attribute"/>
<parameter key="83" value="ReferencedInstanceSequence.true.attribute_value.attribute"/>
<parameter key="84" value="ReferencedRealWorldValueMappingInstanceSequence.true.attribute_value.attribute"/>
<parameter key="85" value="ReferencedSOPClassUID.true.attribute_value.attribute"/>
<parameter key="86" value="ReferencedSOPInstanceUID.true.attribute_value.attribute"/>
<parameter key="87" value="SOPClassesSupported.true.attribute_value.attribute"/>
<parameter key="88" value="ReferencedFrameNumber.true.attribute_value.attribute"/>
<parameter key="89" value="SimpleFrameList.true.attribute_value.attribute"/>
<parameter key="90" value="CalculatedFrameList.true.attribute_value.attribute"/>
<parameter key="91" value="TimeRange.true.attribute_value.attribute"/>
<parameter key="92" value="FrameExtractionSequence.true.attribute_value.attribute"/>
<parameter key="93" value="MultiFrameSourceSOPInstanceUID.true.attribute_value.attribute"/>
<parameter key="94" value="TransactionUID.true.attribute_value.attribute"/>
<parameter key="95" value="FailureReason.true.attribute_value.attribute"/>
<parameter key="96" value="FailedSOPSequence.true.attribute_value.attribute"/>
<parameter key="97" value="ReferencedSOPSequence.true.attribute_value.attribute"/>
<parameter key="98" value="StudiesContainingOtherReferencedInstancesSequence.true.attribute_value.attribute"/>
<parameter key="99" value="RelatedSeriesSequence.true.attribute_value.attribute"/>
<parameter key="100" value="LossyImageCompressionRetired.true.attribute_value.attribute"/>
<parameter key="101" value="DerivationDescription.true.attribute_value.attribute"/>
<parameter key="102" value="SourceImageSequence.true.attribute_value.attribute"/>
<parameter key="103" value="StageName.true.attribute_value.attribute"/>
<parameter key="104" value="StageNumber.true.attribute_value.attribute"/>
<parameter key="105" value="NumberOfStages.true.attribute_value.attribute"/>
<parameter key="106" value="ViewName.true.attribute_value.attribute"/>
<parameter key="107" value="ViewNumber.true.attribute_value.attribute"/>
<parameter key="108" value="NumberOfEventTimers.true.attribute_value.attribute"/>
<parameter key="109" value="NumberOfViewsInStage.true.attribute_value.attribute"/>
<parameter key="110" value="EventElapsedTimes.true.attribute_value.attribute"/>
<parameter key="111" value="EventTimerNames.true.attribute_value.attribute"/>
<parameter key="112" value="EventTimerSequence.true.attribute_value.attribute"/>
<parameter key="113" value="EventTimeOffset.true.attribute_value.attribute"/>
<parameter key="114" value="EventCodeSequence.true.attribute_value.attribute"/>
<parameter key="115" value="TransducerPosition.true.attribute_value.attribute"/>
<parameter key="116" value="TransducerOrientation.true.attribute_value.attribute"/>
<parameter key="117" value="AnatomicStructure.true.attribute_value.attribute"/>
<parameter key="118" value="AnatomicRegionSequence.true.binominal.attribute"/>
<parameter key="119" value="FrameType.true.attribute_value.attribute"/>
<parameter key="120" value="PatientName.true.polynominal.attribute"/>
<parameter key="121" value="PatientID.true.polynominal.attribute"/>
<parameter key="122" value="IssuerOfPatientID.true.attribute_value.attribute"/>
<parameter key="123" value="TypeOfPatientID.true.attribute_value.attribute"/>
<parameter key="124" value="IssuerOfPatientIDQualifiersSequence.true.attribute_value.attribute"/>
<parameter key="125" value="PatientBirthDate.true.date.attribute"/>
<parameter key="126" value="PatientBirthTime.true.attribute_value.attribute"/>
<parameter key="127" value="PatientSex.true.polynominal.attribute"/>
<parameter key="128" value="PatientInsurancePlanCodeSequence.true.attribute_value.attribute"/>
<parameter key="129" value="OtherPatientIDs.true.binominal.attribute"/>
<parameter key="130" value="OtherPatientNames.true.binominal.attribute"/>
<parameter key="131" value="OtherPatientIDsSequence.true.attribute_value.attribute"/>
<parameter key="132" value="PatientBirthName.true.attribute_value.attribute"/>
<parameter key="133" value="PatientAge.true.polynominal.attribute"/>
<parameter key="134" value="PatientSize.true.attribute_value.attribute"/>
<parameter key="135" value="PatientSizeCodeSequence.true.attribute_value.attribute"/>
<parameter key="136" value="PatientWeight.true.real.attribute"/>
<parameter key="137" value="PatientAddress.true.binominal.attribute"/>
<parameter key="138" value="InsurancePlanIdentification.true.attribute_value.attribute"/>
<parameter key="139" value="PatientMotherBirthName.true.attribute_value.attribute"/>
<parameter key="140" value="MedicalRecordLocator.true.attribute_value.attribute"/>
<parameter key="141" value="PregnancyStatus.true.integer.attribute"/>
<parameter key="142" value="LastMenstrualDate.true.attribute_value.attribute"/>
<parameter key="143" value="BodyPartExamined.true.binominal.attribute"/>
</list>
</operator>
<operator activated="true" class="nominal_to_date" compatibility="5.3.005" expanded="true" height="76" name="Nominal to Date" width="90" x="313" y="120">
<parameter key="attribute_name" value="StudyTime"/>
<parameter key="date_type" value="time"/>
<parameter key="date_format" value="HH:mm:ss.SSS"/>
<parameter key="time_zone" value="Europe/Berlin"/>
<parameter key="locale" value="German"/>
</operator>
<connect from_op="Read CSV" from_port="output" to_op="Nominal to Date" to_port="example set input"/>
<connect from_op="Nominal to Date" from_port="example set output" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>
