I could use some help trying to use JMP to parse an very lengthy XML file (approximately 225K lines) to create a single data table but have not been able to get very far after several hours of coding a script file and several internet searches. I will place a snippet of the XML file below that contain a section of the file that I am trying to parse to create the table. There are other sections within the XML file that use the Tag "SubTest" but if the "TestDescription" child tag within the "SubTest" tag does not contain the term "Freq_Offset" the script needs to ignore it so the data is not added to the data table. The "SubTest" section has several "Record" children sections at the beginning. These are the parameters used when performing the measurements and need to be added to the Data table. The measurement tags after the initial "Record" tags also needs to be added to the data table along with the test criteria and pass/fail results for each Measurement tag. If someone can help me get started with the structure of the XML Parsing script that creates a smaller version fo the data table I can take it from there and create the rest of the required columns and populate the data from the XML file. I am just getting stuck with trying to create the script that would conditionally add the row to the data table based on the criteria listed above, and to extract the data from the child tags of the "SubTest" tag.
The entire XML file and the beginning of the script file I started (but failed miserably) is attached and contained within the zip file.
Thanks in advance for the assistance.
Current_Cycle_Count:1_Test_Run_Count:1_Network_Modulation:_200G_200ZR_oFEC_QPSK_1_S_Client_Rate:CAUI_LESS_FEC_Network_Lane:LANE_0
11-14-2021 09:57:49.125
11-14-2021 10:17:17.817
Freq_Offset_Rx Laser_Mode:RX_EQ_TX
11-14-2021 09:57:49.125
PASS
127
0
Freq_Offset_Rx Laser_Mode:RX_EQ_TX
NA
PASS
11-14-2021 09:57:49.125
Current_Cycle_Count
1
11-14-2021 09:57:49.125
Config
Test_Run_Count
1
11-14-2021 09:57:49.126
Config
Network_Modulation
_200G_200ZR_oFEC_QPSK_1_S
11-14-2021 09:57:49.127
Config
Client_Rate
CAUI_LESS_FEC
11-14-2021 09:57:49.129
Config
Network_Lane
LANE_0
11-14-2021 09:57:49.130
Config
Grid_Spacing
GHZ_25
11-14-2021 09:57:49.131
Config
Frequency_Mode
CHANNEL
11-14-2021 09:57:49.132
Config
Rx Laser_Mode
RX_EQ_TX
11-14-2021 09:57:49.133
Config
Laser_Tuning_Mode
SYNC
11-14-2021 09:57:49.134
Config
Tx_Laser_Frequency_(THz)
196.125
11-14-2021 09:57:49.135
Config
Rx_Laser_Frequency_(THz)
196.125
11-14-2021 09:57:49.136
Config
NE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 09:58:36.150
Tuning duration = 0.0011014 seconds; Timeout Limit = 120 seconds
Status
NE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 09:58:36.161
Tuning duration = 0.0011412 seconds; Timeout Limit = 120 seconds
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 09:59:22.964
Tuning duration = 0.0010715 seconds; Timeout Limit = 120 seconds
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 09:59:22.976
Tuning duration = 0.001003 seconds; Timeout Limit = 120 seconds
Status
NE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 09:59:42.525
Near End Module Demoluation Lock State post turnup completion
Status
NE_rxn_demod_lol_count_LANE_0
0
Near End Module Demoluation Lock Count value post turnup completion
11-14-2021 09:59:42.526
Data
NE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 09:59:42.527
Near End Module Uncorrected Blocks counts post turnup completion
Status
FE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:00:01.077
Far End Module Demoluation Lock State post turnup completion
Status
FE_demod_lock_count_LANE_0
0
Far End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:00:01.078
Data
FE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:00:01.079
Far End Module Uncorrected Blocks counts post turnup completion
Status
ntwk_laser_tune_cntl__ind_rx_laser_tune_cntl_LANE_0
EQ
PASS
RX_EQ_TX
RX_EQ_TX
11-14-2021 10:00:01.082
Status
ntwk_laser_tune_cntl__laser_tune_mode_LANE_0
EQ
PASS
SYNC
SYNC
11-14-2021 10:00:01.085
Status
ntwk_laser_tune_cntl__freq_spec_method_LANE_0
EQ
PASS
CHANNEL
CHANNEL
11-14-2021 10:00:01.087
Status
tx_chan_cntl__grid_spacing_LANE_0
EQ
PASS
GHZ_25
GHZ_25
11-14-2021 10:00:01.091
Status
rx_chan_cntl__grid_spacing_LANE_0
EQ
PASS
GHZ_25
GHZ_25
11-14-2021 10:00:01.093
Status
UUT_Network Config0
_200G_200ZR_oFEC_QPSK_1_S
11-14-2021 10:00:01.106
Setup
UUT_Client Config0
CAUI_LESS_FEC
11-14-2021 10:00:01.108
Setup
UUT_Operating Modulation0
DP_QPSK
11-14-2021 10:00:01.109
Setup
UUT_Operating FEC0
OFEC
11-14-2021 10:00:01.110
Setup
UUT_Operating Diffen0
False
11-14-2021 10:00:01.111
Setup
NE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:00:01.138
Tuning duration = 0.0011739 seconds; Timeout Limit = 120 seconds
Status
NE_Tx_FTF_Offset_For_Base_OffsetLANE_0
EQ
PASS
0
0
11-14-2021 10:00:01.140
Verifying the Near End Tx FTF Offset Value is equal to the set value
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:00:01.149
Tuning duration = 0.0010374 seconds; Timeout Limit = 120 seconds
Status
FE_Tx_FTF_Offset_For_Base_OffsetLANE_0
EQ
PASS
0
0
11-14-2021 10:00:01.155
Verifying the Far End Tx FTF Offset Value is equal to the set value
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:00:01.164
Tuning duration = 0.0019846 seconds; Timeout Limit = 120 seconds
Status
FE_Rx_FTF_Offset_For_Base_OffsetLANE_0
EQ
PASS
0
0
11-14-2021 10:00:01.169
Verifying the Far End Rx FTF Offset Value is equal to the set value
Status
NE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:00:17.525
Data
NE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:00:34.661
Wavelength Meter Range: Target Freq(THz) = 196125, Max Freq(THz) = 196.124534, Min Freq(THz) = 196.124497
Status
NE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:00:34.671
Data
FE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:00:34.679
Data
FE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:00:51.878
Wavelength Meter Range: Target Freq(THz) = 196125, Max Freq(THz) = 196.124615, Min Freq(THz) = 196.124575
Status
FE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:00:51.887
Data
NE_BeforeFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.48
1.5
11-14-2021 10:00:51.911
Check if Near End tx_freq_1__freq_thz is less than 1.5GHz apart from WLM measured freq (per STP)
Status
FE_BeforeFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.4
1.5
11-14-2021 10:00:51.912
Check if Far End tx_freq_1__freq_thz is less than 1.5GHz apart from WLM measured freq (per STP)
Status
NE_BaseOffset
80
11-14-2021 10:00:51.913
Data
NE_Tx_Operating_Freq_LANE_0
LEGE
PASS
196.125
196.124,196.126
11-14-2021 10:00:51.934
tx_freq_1__freq_thz
Status
FE_Tx_Operating_Freq_LANE_0
LEGE
PASS
196.125
196.124,196.126
11-14-2021 10:00:51.935
tx_freq_1__freq_thz
Status
Rx_Operating_Freq_Pre_Reg_Update_LANE_0
EQ
PASS
196.125
196.125
11-14-2021 10:00:51.940
rx_freq_1__freq_thz before the Rx Frequency Register is updated
Status
Rx_Operating_Freq_Post_Reg_Update_LANE_0
EQ
PASS
196.125
196.125
11-14-2021 10:00:53.025
rx_freq_1__freq_thz after the Rx Frequency Register is updated
Status
Tx_FTF_Offset_(MHz)
6000
11-14-2021 10:00:53.026
Config
Rx_FTF_Offset_(MHz)
6000
11-14-2021 10:00:53.027
Config
FreqOffset
6000
Frequency Offset
11-14-2021 10:00:53.239
Data
NE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:01:39.435
Tuning duration = 0.002132 seconds; Timeout Limit = 120 seconds
Status
NE_Tx_FTF_Offset_LANE_0
EQ
PASS
6000
6000
11-14-2021 10:01:39.452
Verifying the Near End Tx FTF Offset Value is equal to the set value
Status
NE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:01:59.523
Near End Module Demoluation Lock State post turnup completion
Status
NE_rxn_demod_lol_count_LANE_0
0
Near End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:01:59.524
Data
NE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:01:59.525
Near End Module Uncorrected Blocks counts post turnup completion
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:01:59.536
Tuning duration = 0.0011099 seconds; Timeout Limit = 120 seconds
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:01:59.547
Tuning duration = 0.0020992 seconds; Timeout Limit = 120 seconds
Status
NE_Freq_Offset_Monitor_MinAvgMax_PreFtfOffset_LANE_0
LEGE
PASS
5921
5865,5976
11-14-2021 10:02:25.618
Near End ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, and 5921 Values Pre FTF Offset
Status
NE_Freq_Offset_Monitor_PreFtfOffset_LANE_0
LEGE
PASS
5841
5500,6500
11-14-2021 10:02:25.646
Near End ntwk_ave_freq_offset_pm__freq_mhz Pre FTF Offset
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:03:11.058
Tuning duration = 0.0019701 seconds; Timeout Limit = 120 seconds
Status
FE_Tx_FTF_Offset_LANE_0
EQ
PASS
6000
6000
11-14-2021 10:03:11.064
Verifying the Far End Tx FTF Offset Value is equal to the set value
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:03:11.074
Tuning duration = 0.0011227 seconds; Timeout Limit = 120 seconds
Status
FE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:03:31.076
Far End Module Demoluation Lock State post turnup completion
Status
FE_demod_lock_count_LANE_0
0
Far End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:03:31.077
Data
FE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:03:31.078
Far End Module Uncorrected Blocks counts post turnup completion
Status
NE_Freq_Offset_Monitor_MinAvgMax_PostFtfOffset_LANE_0
LEGE
PASS
-19
-78,49
11-14-2021 10:03:51.622
Near End ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, ntwk_ave_freq_offset_pm__freq_mhz Values Post FTF Offset
Status
NE_Freq_Offset_Monitor_PostFtfOffset_LANE_0
LEGE
PASS
-61
-500,500
11-14-2021 10:03:51.623
Near End ntwk_ave_freq_offset_pm__freq_mhz Post FTF Offset
Status
FE_Freq_Offset_Monitor_MinAvgMax_LANE_0
LEGE
PASS
18
-42,78
11-14-2021 10:04:12.186
Far End Rx ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, ntwk_ave_freq_offset_pm__freq_mhz Values
Status
FE_Freq_Offset_Monitor_LANE_0
LEGE
PASS
-1.99999999999996
-500,500
11-14-2021 10:04:12.190
Far End 78
Status
NE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:04:28.524
Data
NE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:04:45.208
Wavelength Meter Range: Target Freq(THz) = 196131, Max Freq(THz) = 196.130469, Min Freq(THz) = 196.130437
Status
NE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:04:45.216
Data
FE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:04:45.225
Data
FE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:05:02.487
Wavelength Meter Range: Target Freq(THz) = 196131, Max Freq(THz) = 196.130507, Min Freq(THz) = 196.130465
Status
FE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:05:02.497
Data
NE_AfterFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.55
1.5
11-14-2021 10:05:02.524
Check if Near End operating freq is less than 1.5GHz apart from WLM measured freq (per STP).
Status
FE_AfterFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.52
1.5
11-14-2021 10:05:02.525
Check if Far End operating freq is less than 1.5GHz apart from WLM measured freq (per STP).
Status
AfterFTF_ActualOffset
392260935
11-14-2021 10:05:02.526
Data
FE_ConvolutedOffsetAccuracyMHz_LANE_0
LEGE
PASS
5919.97099999999
-6000,6000
11-14-2021 10:05:02.527
= FTF_Offset - Base_Offset - FE_Offset_Monitor_Max
Status
FE_DiffActualAndMaxOffsetMHz_LANE_0
LEGE
PASS
-77.970999999988
-6000,6000
11-14-2021 10:05:02.529
ActualOffset between WLM measurements after FTF - FE_Offset_Monitor_Max
Status
NE_ConvolutedOffsetAccuracyMHz_LANE_0
LEGE
PASS
5871
-6000,6000
11-14-2021 10:05:02.530
= FTF_Offset - Base_Offset - NE_Offset_Monitor_Max
Status
NE_DiffActualAndMaxOffsetMHz_LANE_0
LEGE
PASS
-48.970999999988
-6000,6000
11-14-2021 10:05:02.531
ActualOffset between WLM measurements after FTF - NE_Offset_Monitor_Max
Status
Tx_FTF_Offset_(MHz)
3000
11-14-2021 10:05:02.555
Config
Rx_FTF_Offset_(MHz)
3000
11-14-2021 10:05:02.557
Config
FreqOffset
3000
Frequency Offset
11-14-2021 10:05:02.771
Data
NE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:05:25.890
Tuning duration = 0.0020008 seconds; Timeout Limit = 120 seconds
Status
NE_Tx_FTF_Offset_LANE_0
EQ
PASS
3000
3000
11-14-2021 10:05:25.894
Verifying the Near End Tx FTF Offset Value is equal to the set value
Status
NE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:05:45.524
Near End Module Demoluation Lock State post turnup completion
Status
NE_rxn_demod_lol_count_LANE_0
0
Near End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:05:45.525
Data
NE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:05:45.526
Near End Module Uncorrected Blocks counts post turnup completion
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:06:31.046
Tuning duration = 0.0020023 seconds; Timeout Limit = 120 seconds
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:06:31.058
Tuning duration = 0.0011643 seconds; Timeout Limit = 120 seconds
Status
NE_Freq_Offset_Monitor_MinAvgMax_PreFtfOffset_LANE_0
LEGE
PASS
2922
2844,3002
11-14-2021 10:06:51.620
Near End ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, and 2922 Values Pre FTF Offset
Status
NE_Freq_Offset_Monitor_PreFtfOffset_LANE_0
LEGE
PASS
2842
2500,3500
11-14-2021 10:06:51.642
Near End ntwk_ave_freq_offset_pm__freq_mhz Pre FTF Offset
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:07:14.510
Tuning duration = 0.0020022 seconds; Timeout Limit = 120 seconds
Status
FE_Tx_FTF_Offset_LANE_0
EQ
PASS
3000
3000
11-14-2021 10:07:14.522
Verifying the Far End Tx FTF Offset Value is equal to the set value
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:07:14.532
Tuning duration = 0.0011315 seconds; Timeout Limit = 120 seconds
Status
FE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:07:35.076
Far End Module Demoluation Lock State post turnup completion
Status
FE_demod_lock_count_LANE_0
0
Far End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:07:35.078
Data
FE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:07:35.079
Far End Module Uncorrected Blocks counts post turnup completion
Status
NE_Freq_Offset_Monitor_MinAvgMax_PostFtfOffset_LANE_0
LEGE
PASS
-88
-178,-2
11-14-2021 10:07:55.620
Near End ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, ntwk_ave_freq_offset_pm__freq_mhz Values Post FTF Offset
Status
NE_Freq_Offset_Monitor_PostFtfOffset_LANE_0
LEGE
PASS
8.00000000000004
-500,500
11-14-2021 10:07:55.621
Near End ntwk_ave_freq_offset_pm__freq_mhz Post FTF Offset
Status
FE_Freq_Offset_Monitor_MinAvgMax_LANE_0
LEGE
PASS
88
-11,188
11-14-2021 10:08:16.173
Far End Rx ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, ntwk_ave_freq_offset_pm__freq_mhz Values
Status
FE_Freq_Offset_Monitor_LANE_0
LEGE
PASS
108
-500,500
11-14-2021 10:08:16.174
Far End 188
Status
NE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:08:32.523
Data
NE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:08:49.762
Wavelength Meter Range: Target Freq(THz) = 196128, Max Freq(THz) = 196.127397, Min Freq(THz) = 196.127361
Status
NE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:08:49.772
Data
FE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:08:49.781
Data
FE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:09:07.018
Wavelength Meter Range: Target Freq(THz) = 196128, Max Freq(THz) = 196.12749, Min Freq(THz) = 196.127464
Status
FE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:09:07.028
Data
NE_AfterFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.62
1.5
11-14-2021 10:09:07.052
Check if Near End operating freq is less than 1.5GHz apart from WLM measured freq (per STP).
Status
FE_AfterFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.52
1.5
11-14-2021 10:09:07.053
Check if Far End operating freq is less than 1.5GHz apart from WLM measured freq (per STP).
Status
AfterFTF_ActualOffset
392254861
11-14-2021 10:09:07.054
Data
FE_ConvolutedOffsetAccuracyMHz_LANE_0
LEGE
PASS
2919.90500000001
-3000,3000
11-14-2021 10:09:07.055
= FTF_Offset - Base_Offset - FE_Offset_Monitor_Max
Status
FE_DiffActualAndMaxOffsetMHz_LANE_0
LEGE
PASS
-187.905000000012
-3000,3000
11-14-2021 10:09:07.056
ActualOffset between WLM measurements after FTF - FE_Offset_Monitor_Max
Status
NE_ConvolutedOffsetAccuracyMHz_LANE_0
LEGE
PASS
2918
-3000,3000
11-14-2021 10:09:07.057
= FTF_Offset - Base_Offset - NE_Offset_Monitor_Max
Status
NE_DiffActualAndMaxOffsetMHz_LANE_0
LEGE
PASS
-1.90500000001248
-3000,3000
11-14-2021 10:09:07.058
ActualOffset between WLM measurements after FTF - NE_Offset_Monitor_Max
Status
Tx_FTF_Offset_(MHz)
-3000
11-14-2021 10:09:07.081
Config
Rx_FTF_Offset_(MHz)
-3000
11-14-2021 10:09:07.082
Config
FreqOffset
-3000
Frequency Offset
11-14-2021 10:09:07.294
Data
NE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:09:53.424
Tuning duration = 0.0010081 seconds; Timeout Limit = 120 seconds
Status
NE_Tx_FTF_Offset_LANE_0
EQ
PASS
-3000
-3000
11-14-2021 10:09:53.429
Verifying the Near End Tx FTF Offset Value is equal to the set value
Status
NE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:10:13.520
Near End Module Demoluation Lock State post turnup completion
Status
NE_rxn_demod_lol_count_LANE_0
0
Near End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:10:13.521
Data
NE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:10:13.522
Near End Module Uncorrected Blocks counts post turnup completion
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:10:35.979
Tuning duration = 0.0020676 seconds; Timeout Limit = 120 seconds
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:10:35.992
Tuning duration = 0.0010806 seconds; Timeout Limit = 120 seconds
Status
NE_Freq_Offset_Monitor_MinAvgMax_PreFtfOffset_LANE_0
LEGE
PASS
-3071
-3157,-2987
11-14-2021 10:10:56.627
Near End ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, and -3071 Values Pre FTF Offset
Status
NE_Freq_Offset_Monitor_PreFtfOffset_LANE_0
LEGE
PASS
-3151
-3500,-2500
11-14-2021 10:10:56.652
Near End ntwk_ave_freq_offset_pm__freq_mhz Pre FTF Offset
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:11:20.034
Tuning duration = 0.0019994 seconds; Timeout Limit = 120 seconds
Status
FE_Tx_FTF_Offset_LANE_0
EQ
PASS
-3000
-3000
11-14-2021 10:11:20.041
Verifying the Far End Tx FTF Offset Value is equal to the set value
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:11:20.048
Tuning duration = 0.0011216 seconds; Timeout Limit = 120 seconds
Status
FE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:11:40.073
Far End Module Demoluation Lock State post turnup completion
Status
FE_demod_lock_count_LANE_0
0
Far End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:11:40.074
Data
FE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:11:40.075
Far End Module Uncorrected Blocks counts post turnup completion
Status
NE_Freq_Offset_Monitor_MinAvgMax_PostFtfOffset_LANE_0
LEGE
PASS
-36
-126,55
11-14-2021 10:12:00.624
Near End ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, ntwk_ave_freq_offset_pm__freq_mhz Values Post FTF Offset
Status
NE_Freq_Offset_Monitor_PostFtfOffset_LANE_0
LEGE
PASS
-44
-500,500
11-14-2021 10:12:00.626
Near End ntwk_ave_freq_offset_pm__freq_mhz Post FTF Offset
Status
FE_Freq_Offset_Monitor_MinAvgMax_LANE_0
LEGE
PASS
33
-61,125
11-14-2021 10:12:21.172
Far End Rx ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, ntwk_ave_freq_offset_pm__freq_mhz Values
Status
FE_Freq_Offset_Monitor_LANE_0
LEGE
PASS
45
-500,500
11-14-2021 10:12:21.173
Far End 125
Status
NE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:12:37.521
Data
NE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:12:54.517
Wavelength Meter Range: Target Freq(THz) = 196122, Max Freq(THz) = 196.121486, Min Freq(THz) = 196.121447
Status
NE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:12:54.525
Data
FE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:12:54.535
Data
FE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:13:11.698
Wavelength Meter Range: Target Freq(THz) = 196122, Max Freq(THz) = 196.121544, Min Freq(THz) = 196.121505
Status
FE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:13:11.709
Data
NE_AfterFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.53
1.5
11-14-2021 10:13:11.731
Check if Near End operating freq is less than 1.5GHz apart from WLM measured freq (per STP).
Status
FE_AfterFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.48
1.5
11-14-2021 10:13:11.732
Check if Far End operating freq is less than 1.5GHz apart from WLM measured freq (per STP).
Status
AfterFTF_ActualOffset
392242994
11-14-2021 10:13:11.734
Data
FE_ConvolutedOffsetAccuracyMHz_LANE_0
LEGE
PASS
2919.94599999999
-3000,3000
11-14-2021 10:13:11.735
= FTF_Offset - Base_Offset - FE_Offset_Monitor_Max
Status
FE_DiffActualAndMaxOffsetMHz_LANE_0
LEGE
PASS
-124.945999999994
-3000,3000
11-14-2021 10:13:11.737
ActualOffset between WLM measurements after FTF - FE_Offset_Monitor_Max
Status
NE_ConvolutedOffsetAccuracyMHz_LANE_0
LEGE
PASS
2865
-3000,3000
11-14-2021 10:13:11.738
= FTF_Offset - Base_Offset - NE_Offset_Monitor_Max
Status
NE_DiffActualAndMaxOffsetMHz_LANE_0
LEGE
PASS
-54.9459999999942
-3000,3000
11-14-2021 10:13:11.739
ActualOffset between WLM measurements after FTF - NE_Offset_Monitor_Max
Status
Tx_FTF_Offset_(MHz)
-6000
11-14-2021 10:13:11.762
Config
Rx_FTF_Offset_(MHz)
-6000
11-14-2021 10:13:11.763
Config
FreqOffset
-6000
Frequency Offset
11-14-2021 10:13:11.987
Data
NE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:13:35.428
Tuning duration = 0.0020025 seconds; Timeout Limit = 120 seconds
Status
NE_Tx_FTF_Offset_LANE_0
EQ
PASS
-6000
-6000
11-14-2021 10:13:35.441
Verifying the Near End Tx FTF Offset Value is equal to the set value
Status
NE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:13:55.521
Near End Module Demoluation Lock State post turnup completion
Status
NE_rxn_demod_lol_count_LANE_0
0
Near End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:13:55.522
Data
NE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:13:55.523
Near End Module Uncorrected Blocks counts post turnup completion
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:14:18.494
Tuning duration = 0.0020545 seconds; Timeout Limit = 120 seconds
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:14:18.509
Tuning duration = 0.001152 seconds; Timeout Limit = 120 seconds
Status
NE_Freq_Offset_Monitor_MinAvgMax_PreFtfOffset_LANE_0
LEGE
PASS
-6090
-6179,-5990
11-14-2021 10:14:39.622
Near End ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, and -6090 Values Pre FTF Offset
Status
NE_Freq_Offset_Monitor_PreFtfOffset_LANE_0
LEGE
PASS
-6170
-6500,-5500
11-14-2021 10:14:39.646
Near End ntwk_ave_freq_offset_pm__freq_mhz Pre FTF Offset
Status
FE Tx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:15:25.495
Tuning duration = 0.0019664 seconds; Timeout Limit = 120 seconds
Status
FE_Tx_FTF_Offset_LANE_0
EQ
PASS
-6000
-6000
11-14-2021 10:15:25.502
Verifying the Far End Tx FTF Offset Value is equal to the set value
Status
FE Rx FTF Tuning Complete
EQ
PASS
1
1
11-14-2021 10:15:25.515
Tuning duration = 0.0020059 seconds; Timeout Limit = 120 seconds
Status
FE_demod_lock_state_LANE_0
EQ
PASS
1
1
11-14-2021 10:15:46.072
Far End Module Demoluation Lock State post turnup completion
Status
FE_demod_lock_count_LANE_0
0
Far End Module Demoluation Lock Count value post turnup completion
11-14-2021 10:15:46.073
Data
FE_UCBs_LANE_0
EQ
PASS
0
0
11-14-2021 10:15:46.074
Far End Module Uncorrected Blocks counts post turnup completion
Status
NE_Freq_Offset_Monitor_MinAvgMax_PostFtfOffset_LANE_0
LEGE
PASS
-60
-157,38
11-14-2021 10:16:06.619
Near End ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, ntwk_ave_freq_offset_pm__freq_mhz Values Post FTF Offset
Status
NE_Freq_Offset_Monitor_PostFtfOffset_LANE_0
LEGE
PASS
-20
-500,500
11-14-2021 10:16:06.620
Near End ntwk_ave_freq_offset_pm__freq_mhz Post FTF Offset
Status
FE_Freq_Offset_Monitor_MinAvgMax_LANE_0
LEGE
PASS
66
-32,155
11-14-2021 10:16:27.174
Far End Rx ntwk_max_freq_offset_pm__freq_mhz, ntwk_min_freq_offset_pm__freq_mhz, ntwk_ave_freq_offset_pm__freq_mhz Values
Status
FE_Freq_Offset_Monitor_LANE_0
LEGE
PASS
75
-500,500
11-14-2021 10:16:27.175
Far End 155
Status
NE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:16:43.519
Data
NE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:17:00.554
Wavelength Meter Range: Target Freq(THz) = 196119, Max Freq(THz) = 196.11844, Min Freq(THz) = 196.118413
Status
NE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:17:00.564
Data
FE_TxPulseShape
LASER_FREQ_TEST
11-14-2021 10:17:00.573
Data
FE_Wavelegnth_Meter_Rage_LANE_0
LE
PASS
0
0.2
11-14-2021 10:17:17.723
Wavelength Meter Range: Target Freq(THz) = 196119, Max Freq(THz) = 196.118516, Min Freq(THz) = 196.118477
Status
FE_TxPulseShape
ROOT_RAISED_COSINE
11-14-2021 10:17:17.734
Data
NE_AfterFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.57
1.5
11-14-2021 10:17:17.787
Check if Near End operating freq is less than 1.5GHz apart from WLM measured freq (per STP).
Status
FE_AfterFTF_OperatingVsWLMFreqGHz_LANE_0
LE
PASS
0.5
1.5
11-14-2021 10:17:17.789
Check if Far End operating freq is less than 1.5GHz apart from WLM measured freq (per STP).
Status
AfterFTF_ActualOffset
392236922
11-14-2021 10:17:17.790
Data
FE_ConvolutedOffsetAccuracyMHz_LANE_0
LEGE
PASS
5919.92800000001
-6000,6000
11-14-2021 10:17:17.791
= FTF_Offset - Base_Offset - FE_Offset_Monitor_Max
Status
FE_DiffActualAndMaxOffsetMHz_LANE_0
LEGE
PASS
-154.928000000011
-6000,6000
11-14-2021 10:17:17.792
ActualOffset between WLM measurements after FTF - FE_Offset_Monitor_Max
Status
NE_ConvolutedOffsetAccuracyMHz_LANE_0
LEGE
PASS
5882
-6000,6000
11-14-2021 10:17:17.793
= FTF_Offset - Base_Offset - NE_Offset_Monitor_Max
Status
NE_DiffActualAndMaxOffsetMHz_LANE_0
LEGE
PASS
-37.9280000000113
-6000,6000
11-14-2021 10:17:17.794
ActualOffset between WLM measurements after FTF - NE_Offset_Monitor_Max
Status
11-14-2021 10:17:17.817
00:19:28.691
Hi @kprentiss ,
Why not use the File-->Open and use the XML Import Wizard?
Using the XML snippet provided produced the attached table.
Would this approach work for you?
cheers,
Stan
JMP XML Import Wizard--Guess = HugeJMP XML Import Wizard--Guess = HugeJMP XML Import Wizard--Guess = Huge
