def test():
from Modules import commonBits
java_recorded_version = '1.6.0_10'
if window('Record Editor'):
commonBits.selectOldFilemenu(select_menu, 'Utilities',
'File Copy Menu')
click('*3')
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
select('FileChooser1', commonBits.sampleDir() + 'CpyCsvDtar020a.Txt')
commonBits.setRecordLayout2(select, 'DTAR020')
##select('ComboBox2', 'DTAR020')
select('DelimiterCombo', '<Tab>')
click('Right')
select('TabbedPane', '')
click('Right')
select('TabbedPane', '')
click('Copy2')
assert_p('TextField1', 'Text', 'Copy Done !!! ')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu('Window>>Menu>>Copy Menu')
click('*1')
select('FileChooser', commonBits.sampleDir() + 'CpyCsvDtar020.Txt')
if commonBits.isJRecord():
commonBits.setRecordLayout(
select, 'Tab Delimited names on the first line')
else:
commonBits.setRecordLayout(
select, 'Tab Delimited, names on the first line')
click('Right')
select('TabbedPane', '')
select('FileChooser', commonBits.sampleDir() + 'DTAR020a.bin')
commonBits.setRecordLayout(select, 'DTAR020')
click('Right')
select('TabbedPane', '')
click('Right')
select('TabbedPane', '')
click('Copy2')
assert_p('TextField1', 'Text', 'Copy Done !!! ')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu('Window>>Open File')
##click('MetalInternalFrameTitlePane', 299, 9)
select('FileChooser', commonBits.sampleDir() + 'DTAR020a.bin')
commonBits.setRecordLayout(select, 'DTAR020')
commonBits.doEdit(click)
select('Table', 'cell:9 - 2|STORE-NO,0(20)')
assert_p(
'Table', 'Content',
'[[69684558, 20, 40118, 0, 1, 19.00], [69684558, 20, 40118, 0, -1, -19.00], [69684558, 20, 40118, 0, 1, 5.01], [69694158, 20, 40118, 0, 1, 19.00], [69694158, 20, 40118, 0, -1, -19.00], [69694158, 20, 40118, 0, 1, 5.01], [63604808, 20, 40118, 0, 1, 4.87], [62684671, 20, 40118, 0, 1, 69.99], [62684671, 20, 40118, 0, -1, -69.99], [64634429, 20, 40118, 0, 1, 3.99], [66624458, 20, 40118, 0, 1, 0.89], [63674861, 20, 40118, 0, 10, 2.70], [65674532, 20, 40118, 0, 1, 3.59], [64614401, 59, 40118, 0, 1, 1.99], [64614401, 59, 40118, 0, 1, 1.99], [61664713, 59, 40118, 0, 1, 17.99], [61664713, 59, 40118, 0, -1, -17.99], [68634752, 59, 40118, 0, 1, 8.99], [60614487, 59, 40118, 0, 1, 5.95], [63644339, 59, 40118, 0, 1, 12.65], [60694698, 59, 40118, 0, 1, 3.99], [60664659, 59, 40118, 0, 1, 3.99], [62684217, 59, 40118, 0, 1, 9.99], [67674686, 59, 40118, 0, 1, 3.99], [61684613, 59, 40118, 0, 1, 12.99], [64624770, 59, 40118, 0, 1, 2.59], [69694814, 166, 40118, 0, 1, 2.50], [69694814, 166, 40118, 0, 1, 2.50], [69644164, 166, 40118, 0, 1, 21.59], [62684907, 166, 40118, 0, 1, 13.99], [62694193, 166, 40118, 0, 1, 13.99], [62694193, 166, 40118, 0, -1, -13.99], [62694193, 166, 40118, 0, 1, 11.99], [63654450, 166, 40118, 0, 1, 13.99], [62664576, 166, 40118, 0, 1, 9.72], [63634260, 166, 40118, 0, 1, 5.59], [64684534, 166, 40118, 0, 1, 14.99], [64674965, 166, 40118, 0, 1, 19.99], [64674965, 166, 40118, 0, -1, -19.99], [64674965, 166, 40118, 0, 1, 12.00], [60624523, 166, 40118, 0, 1, 12.00], [66624253, 166, 40118, 0, 1, 3.49], [66624253, 166, 40118, 0, 1, 3.49], [64654284, 166, 40118, 0, 1, 3.99], [60684907, 166, 40118, 0, 1, 5.50], [63624299, 166, 40118, 0, 1, 10.99], [63624367, 166, 40118, 0, 1, 11.19], [62694575, 166, 40118, 0, 1, 14.99], [69614011, 166, 40118, 0, 1, 6.99], [62634996, 166, 40118, 0, 1, 9.99], [67634503, 166, 40118, 0, 1, 24.99], [65604476, 166, 40118, 0, 1, 19.95], [62694170, 166, 40118, 0, 1, 16.99], [63684098, 166, 40118, 0, 1, 1.98], [63684098, 166, 40118, 0, 1, 1.98], [63684098, 166, 40118, 0, 1, 1.98], [64674609, 166, 40118, 0, 1, 29.99], [62614014, 166, 40118, 0, 1, 14.99], [61694741, 166, 40118, 0, 1, 9.06], [62614534, 166, 40118, 0, 1, 9.09], [64604876, 166, 40118, 0, 1, 29.62], [66624829, 166, 40118, 0, 1, 1.99], [62694843, 166, 40118, 0, 1, 13.59], [62684580, 166, 40118, 0, 1, 19.00], [62664909, 166, 40118, 0, 1, 3.29], [62674751, 166, 40118, 0, 1, 1.99], [62674492, 166, 40118, 0, 1, 1.49], [62674492, 166, 40118, 0, 1, 1.49], [62694706, 166, 40118, 0, 1, 13.59], [69644602, 166, 40118, 0, 1, 19.00], [63634768, 166, 40118, 0, 1, 12.00], [62684207, 166, 40118, 0, 1, 19.00], [69644961, 166, 40118, 0, 1, 9.60], [69604743, 166, 40118, 0, 1, 29.95], [63634081, 166, 40118, 0, 1, 3.89], [69614229, 166, 40118, 0, 1, 15.95], [62654454, 166, 40118, 0, 1, 5.95], [64634712, 166, 40118, 0, 1, 3.90], [62674092, 166, 40118, 0, 1, 15.99], [67664966, 166, 40118, 0, 1, 0.89], [67664966, 166, 40118, 0, 1, 0.89], [64674633, 166, 40118, 0, 1, 15.99], [64624081, 166, 40118, 0, 1, 26.24], [69674069, 166, 40118, 0, 1, 10.49], [62684028, 166, 40118, 0, 1, 29.99], [64604876, 166, 40118, 0, 1, 29.62], [68644966, 166, 40118, 0, 1, 12.50], [68644966, 166, 40118, 0, -1, -12.50], [68644966, 166, 40118, 0, 1, 0.01], [62664347, 166, 40118, 0, 1, 8.99], [62664231, 166, 40118, 0, 1, 8.99], [62694605, 166, 40118, 0, 1, 25.00], [69634922, 166, 40118, 0, 1, 19.00], [63694928, 166, 40118, 0, 1, 11.49], [60624185, 166, 40118, 0, 1, 8.99], [60624314, 166, 40118, 0, 1, 8.99], [69694959, 166, 40118, 0, 1, 11.99], [69624033, 166, 40118, 0, 1, 18.19], [62694485, 166, 40118, 0, 1, 17.56], [60614646, 166, 40118, 0, 1, 6.00], [63654066, 166, 40118, 0, 1, 24.99], [62684548, 166, 40118, 0, 1, 39.99], [62684548, 166, 40118, 0, 1, 39.99], [69694685, 166, 40118, 0, 1, 6.99], [63614741, 166, 40118, 0, 1, 27.99], [60664302, 166, 40118, 0, 1, 9.00], [60664241, 166, 40118, 0, 1, 9.00], [66674979, 166, 40118, 0, 1, 4.50], [62634862, 166, 40118, 0, 1, 11.89], [62604139, 166, 40118, 0, 1, 7.99], [62624382, 166, 40118, 0, 1, 18.98], [62624382, 166, 40118, 0, -1, -18.98], [69694937, 166, 40118, 0, 1, 2.50], [62624382, 166, 40118, 0, 1, 18.98], [62624382, 166, 40118, 0, 1, 18.98], [62624382, 166, 40118, 0, -1, -18.98], [62624382, 166, 40118, 0, -1, -18.98], [62624382, 166, 40118, 0, 1, 18.98], [62624382, 166, 40118, 0, 1, 18.98], [61684889, 166, 40118, 0, 1, 4.49], [68614651, 166, 40118, 0, 1, 3.99], [62664674, 166, 40118, 0, 1, 24.99], [61684889, 166, 40118, 0, 1, 4.49], [60694417, 166, 40118, 0, 1, 0.65], [65694328, 166, 40118, 0, 1, 0.59], [63684449, 166, 40118, 0, 1, 16.99], [62614815, 166, 40118, 0, 1, 20.00], [62664151, 166, 40118, 0, 1, 25.00], [64684719, 166, 40118, 0, 1, 9.99], [69654084, 166, 40118, 0, 1, 6.00], [69644897, 166, 40118, 0, 1, 5.08], [68654655, 166, 40118, 0, 1, 5.08], [68674560, 166, 40118, 0, 1, 5.99], [62694387, 166, 40118, 0, 1, 7.99], [62664568, 166, 40118, 0, 1, 5.99], [69634261, 166, 40118, 0, 1, 12.00], [69634660, 166, 40118, 0, 1, 12.00], [69684947, 166, 40118, 0, 1, 22.49], [60654072, 166, 40118, 0, 1, 4.33], [60654072, 166, 40118, 0, 1, 4.33], [69624221, 166, 40118, 0, 1, 16.99], [62654800, 166, 40118, 0, 1, 19.99], [64644495, 166, 40118, 0, 1, 29.65], [67664645, 166, 40118, 0, 1, 1.39], [60614265, 166, 40118, 0, 1, 15.99], [68604583, 166, 40118, 0, 1, 15.99], [60614265, 166, 40118, 0, 1, 15.99], [60614265, 166, 40118, 0, -1, -15.99], [60614265, 166, 40118, 0, -1, -15.99], [68604583, 166, 40118, 0, -1, -15.99], [68604583, 166, 40118, 0, 1, 15.99], [68604583, 166, 40118, 0, -1, -15.99], [68604583, 166, 40118, 0, 1, 12.80], [60614265, 166, 40118, 0, 1, 15.99], [60614265, 166, 40118, 0, -1, -15.99], [60614265, 166, 40118, 0, 1, 12.80], [69664661, 166, 40118, 0, 1, 14.95], [68664211, 166, 40118, 0, 1, 11.19], [60614707, 166, 40118, 0, 1, 6.00], [64604513, 166, 40118, 0, 1, 16.99], [60624864, 166, 40118, 0, 1, 15.00], [69644909, 166, 40118, 0, 1, 9.00], [60604100, 166, 40118, 0, 1, 13.30], [69634263, 166, 40118, 0, 1, 25.00], [69634263, 166, 40118, 0, -1, -25.00], [69634263, 166, 40118, 0, 1, 12.00], [61674701, 166, 40118, 0, 1, 3.99], [63654007, 166, 40118, 0, 1, 56.99], [67624103, 166, 40118, 0, 1, 16.50], [68614329, 166, 40118, 0, 1, 39.99], [67644384, 166, 40118, 0, 1, 23.96], [64644495, 166, 40118, 0, 1, 29.65], [60684484, 184, 40118, 0, 1, 9.00], [60684484, 184, 40118, 0, 1, 9.00], [67674299, 184, 40118, 0, 1, 4.99], [69664620, 184, 40118, 0, 1, 11.89], [69664620, 184, 40118, 0, -1, -11.89], [69664620, 184, 40118, 0, 1, 9.09], [60674210, 184, 40118, 0, -1, -15.00], [60664048, 184, 40118, 0, -1, -4.80], [60614866, 184, 40118, 0, -1, -4.80], [60664048, 184, 40118, 0, -1, -4.80], [60664048, 184, 40118, 0, -1, -4.80], [60614866, 184, 40118, 0, -1, -4.80], [69654081, 184, 40118, 0, 1, 12.99], [63664643, 184, 40118, 0, 1, 16.79], [69654135, 184, 40118, 0, 1, 12.99], [60644672, 184, 40118, 0, 1, 9.09], [62654852, 184, 40118, 0, -1, -19.59], [62674960, 184, 40118, 0, -1, -16.00], [62674960, 184, 40118, 0, 1, 16.00], [65674126, 184, 40118, 0, 1, 2.69], [60634192, 184, 40118, 0, 1, 24.99], [64634500, 184, 40118, 0, -1, -9.99], [66624803, 184, 40118, 0, 1, 2.00], [66624803, 184, 40118, 0, -1, -2.00], [66624803, 184, 40118, 0, 1, 1.04], [66624889, 184, 40118, 0, 1, 2.00], [66624889, 184, 40118, 0, -1, -2.00], [66624889, 184, 40118, 0, 1, 1.04], [60624241, 184, 40118, 0, 1, 34.99], [62644079, 184, 40118, 0, 1, 9.99], [62664183, 184, 40118, 0, -1, -20.99], [64654047, 184, 40118, 0, -1, -25.99], [62694327, 184, 40118, 0, -1, -10.39], [69604894, 184, 40118, 0, -1, -19.00], [67644821, 184, 40118, 0, -1, -14.99], [67644118, 184, 40118, 0, 1, 16.99], [66664981, 184, 40118, 0, 1, 3.09], [66684899, 184, 40118, 0, 1, 12.99], [64634942, 184, 40118, 0, 1, 15.99], [63654826, 184, 40118, 0, 1, 19.00], [69604993, 184, 40118, 0, -1, -14.39], [63624118, 184, 40118, 0, -1, -15.00], [62684517, 184, 40118, 0, -1, -29.99], [67634503, 184, 40118, 0, 1, 24.99], [62694782, 184, 40118, 0, -1, -16.99], [62694683, 184, 40118, 0, -1, -16.99], [62694782, 184, 40118, 0, -1, -16.99], [62694782, 184, 40118, 0, -1, -16.99], [62684096, 184, 40118, 0, 1, 14.00], [69644199, 184, 40118, 0, 1, 19.19], [60634366, 184, 40118, 0, 1, 7.99], [67654448, 184, 40118, 0, 1, 23.00], [67654448, 184, 40118, 0, -1, -23.00], [67654448, 184, 40118, 0, 1, 19.01], [69654459, 184, 40118, 0, 1, 5.08], [60664779, 184, 40118, 0, 1, 5.08], [63674002, 184, 40118, 0, -1, -29.99], [68604041, 184, 40118, 0, -1, -19.99], [67634503, 184, 40118, 0, 1, 24.99], [68644941, 184, 40118, 0, -1, -10.39], [68644941, 184, 40118, 0, -1, -10.39], [68644941, 184, 40118, 0, -1, -10.39], [68644941, 184, 40118, 0, -1, -10.39], [68644934, 184, 40118, 0, 1, 10.39], [62674884, 184, 40118, 0, -1, -8.99], [68654381, 184, 40118, 0, 1, 14.95], [64644433, 184, 40118, 0, 1, 24.99], [64604829, 184, 40118, 0, -1, -29.99], [62634996, 184, 40118, 0, 1, 9.99], [60624270, 184, 40118, 0, 1, 0.95], [63664932, 184, 40118, 0, 1, 1.59], [69684804, 184, 40118, 0, 1, 9.99], [68664363, 184, 40118, 0, -1, -29.95], [62694503, 184, 40118, 0, 1, 2.99], [62644205, 184, 40118, 0, 1, 24.99], [62604912, 184, 40118, 0, 1, 24.89], [64634802, 184, 40118, 0, 1, 4.29], [60664257, 184, 40118, 0, 1, 2.12], [62684043, 184, 40118, 0, -1, -19.95], [62684043, 184, 40118, 0, 1, 19.95], [64644860, 184, 40118, 0, -1, -3.95], [62644590, 184, 40118, 0, -1, -22.99], [64664587, 184, 40118, 0, -1, -16.99], [64604930, 184, 40118, 0, -1, -35.95], [60604880, 184, 40118, 0, 1, 9.00], [68674372, 184, 40118, 0, 1, 2.00], [63684755, 184, 40118, 0, 1, 2.00], [64684439, 184, 40118, 0, 1, 9.99], [67624120, 184, 40118, 0, 1, 0.98], [67624120, 184, 40118, 0, -1, -0.98], [67624120, 184, 40118, 0, 1, 0.49], [67624120, 184, 40118, 0, 1, 0.98], [67624120, 184, 40118, 0, -1, -0.98], [67624120, 184, 40118, 0, 1, 0.49], [66614192, 184, 40118, 0, 1, 1.23], [66614192, 184, 40118, 0, -1, -1.23], [66614192, 184, 40118, 0, 1, 0.69], [66614192, 184, 40118, 0, 1, 1.23], [66614192, 184, 40118, 0, -1, -1.23], [66614192, 184, 40118, 0, 1, 0.69], [67624473, 184, 40118, 0, 1, 0.50], [67624473, 184, 40118, 0, -1, -0.50], [67624473, 184, 40118, 0, 1, 0.19], [67614923, 184, 40118, 0, -1, -19.95], [63604715, 184, 40118, 0, -1, -6.99], [63604715, 184, 40118, 0, -1, -6.99], [63604715, 184, 40118, 0, -1, -6.99], [62684102, 184, 40118, 0, 1, 14.00], [63654091, 184, 40118, 0, 1, 4.95], [68694729, 184, 40118, 0, -1, -16.99], [60684563, 184, 40118, 0, 1, 9.59], [68664957, 184, 40118, 0, 1, 13.99], [67604116, 184, 40118, 0, 1, 21.00], [64664047, 184, 40118, 0, 1, 22.99], [67634497, 184, 40118, 0, 1, 24.99], [64664270, 184, 40118, 0, 1, 3.19], [60634150, 184, 40118, 0, -1, -14.99], [68684135, 184, 40118, 0, -1, -249.00], [68684135, 184, 40118, 0, 1, 269.00], [68684135, 184, 40118, 0, -1, -269.00], [68684135, 184, 40118, 0, 1, 249.00], [69624909, 184, 40118, 0, -1, -26.21], [62634962, 184, 40118, 0, -1, -6.89], [67614726, 184, 40118, 0, -1, -9.95], [68654094, 184, 40118, 0, -1, -4.50], [60674335, 184, 40118, 0, 1, 19.95], [60674335, 184, 40118, 0, -1, -19.95], [60674335, 184, 40118, 0, 1, 12.99], [60644305, 184, 40118, 0, 1, 0.89], [64604604, 184, 40118, 0, 1, 6.99], [63694367, 184, 40118, 0, 1, 19.00], [62644079, 184, 40118, 0, 1, 9.99], [67674119, 184, 40118, 0, 1, 1.89], [69614627, 184, 40118, 0, 1, 19.00], [69614740, 184, 40118, 0, 1, 19.00], [60614135, 184, 40118, 0, -1, -14.25], [69674452, 184, 40118, 0, 1, 19.99], [62694272, 184, 40118, 0, 1, 2.49], [69614274, 184, 40118, 0, 1, 9.95], [60634379, 184, 40118, 0, 1, 25.00], [60674904, 184, 40118, 0, 1, 19.00], [66614582, 184, 40118, 0, -1, -15.99], [64654096, 184, 40118, 0, 1, 4.95], [62634605, 184, 40118, 0, 1, 29.99], [69694354, 184, 40118, 0, 1, 2.99], [69634699, 184, 40118, 0, 1, 20.99], [69634712, 184, 40118, 0, 1, 20.99], [69664171, 184, 40118, 0, -1, -27.95], [69694479, 184, 40118, 0, 1, 14.99], [63634656, 184, 40118, 0, -1, -5.50], [69664149, 184, 40118, 0, -1, -5.99], [69664163, 184, 40118, 0, -1, -1.39], [67674341, 184, 40118, 0, -1, -19.95], [69644053, 184, 40118, 0, 1, 18.74], [63674184, 184, 40118, 0, 1, 164.00], [62604338, 184, 40118, 0, 1, 69.99], [62644344, 184, 40118, 0, 1, 10.99], [66644706, 184, 40118, 0, 1, 10.99], [62644528, 184, 40118, 0, 1, 10.99], [62644764, 184, 40118, 0, 1, 10.99], [62664135, 184, 40118, 0, 1, 11.00], [62664244, 184, 40118, 0, 1, 11.00], [62664197, 184, 40118, 0, 1, 11.00], [62654875, 184, 40118, 0, 1, 39.99], [64614653, 184, 40118, 0, 1, 34.99], [64614653, 184, 40118, 0, 1, 34.99], [61694023, 184, 40118, 0, 1, 14.99], [61694023, 184, 40118, 0, 1, 14.99], [60694909, 184, 40118, 0, 1, 2.00], [68614241, 184, 40118, 0, 1, 12.99], [69654638, 184, 40118, 0, 1, 6.00], [67634923, 184, 40118, 0, 1, 17.59], [64614285, 184, 40118, 0, 1, 22.99], [69644389, 184, 40118, 0, 1, 17.59], [68614787, 184, 40118, 0, 1, 27.99], [69644337, 184, 40118, 0, 1, 29.99], [68634061, 184, 40118, 0, 1, 27.99], [69644184, 184, 40118, 0, 1, 15.99], [63624756, 184, 40118, 0, 1, 21.00], [67604116, 184, 40118, 0, 1, 21.00], [68654451, 184, 40118, 0, 1, 27.99], [62614172, 184, 40118, 0, 1, 19.19], [61614174, 184, 40118, 0, 1, 49.99], [61614174, 184, 40118, 0, 1, 29.99], [62644445, 184, 40118, 0, 1, 69.95], [62634323, 184, 40118, 0, 1, 149.00], [66674079, 184, 40118, 0, 1, 3.95], [66674130, 184, 40118, 0, 1, 3.95], [61604095, 184, 40118, 0, 1, 12.50], [66664028, 184, 40118, 0, 1, 14.95], [68654621, 184, 40118, 0, 1, 12.95], [63694264, 184, 40118, 0, 1, 19.95], [63604361, 184, 40118, 0, 1, 3.99], [62634259, 184, 40118, 0, 1, 6.69], [62634259, 184, 40118, 0, 1, 6.69], [60684429, 184, 40118, 0, 1, 4.89], [60684037, 184, 40118, 0, 1, 9.95], [69694875, 184, 40118, 0, 1, 19.95], [69694875, 184, 40118, 0, 1, 19.95], [69694875, 184, 40118, 0, 1, 19.95], [69694875, 184, 40118, 0, -1, -19.95], [69694875, 184, 40118, 0, -1, -19.95], [69694875, 184, 40118, 0, -1, -19.95], [63604108, 184, 40118, 0, 1, 3.95], [63694928, 184, 40118, 0, 1, 11.49], [60634765, 184, 40118, 0, 1, 4.99], [69664668, 184, 40118, 0, 1, 8.95]]'
)
select('Table', 'cell:9 - 2|STORE-NO,0(20)')
rightclick('Table', '1 - 8|KEYCODE-NO,0')
## select('Table', 'cell:9 - 2|STORE-NO,0(20)')
select_menu('Edit Record')
## select('Table1', 'cell:9 - 2|STORE-NO,0(20)')
select('Table', 'cell:Data,0(69684558)')
assert_p('Table', 'Text', '69684558', 'Data,0')
select('Table', 'cell:Data,5(19.00)')
assert_p('Table', 'Text', '19.00', 'Data,5')
select('Table', 'cell:Hex,2(0040118c)')
assert_p('Table', 'Text', '000c', 'Hex,3')
select('Table', 'cell:Hex,2(0040118c)')
click('Right')
select('Table', 'cell:Data,2(40118)')
assert_p('Table', 'Text', '40118', 'Data,2')
select('Table', 'cell:Data,5(-19.00)')
assert_p('Table', 'Text', '-19.00', 'Data,5')
select('Table', 'cell:Data,5(-19.00)')
click('Right')
select('Table', 'cell:Data,0(69684558)')
assert_p('Table', 'Text', '20', 'Data,1')
select('Table', 'cell:Data,5(5.01)')
assert_p('Table', 'Text', '5.01', 'Data,5')
select('Table', 'cell:Data,4(1)')
assert_p('Table', 'Text', '1', 'Data,4')
select('Table', 'cell:Data,4(1)')
click('Right')
select('Table', 'cell:Data,5(19.00)')
assert_p('Table', 'Text', '19.00', 'Data,5')
select('Table', 'cell:Data,0(69694158)')
assert_p('Table', 'Text', '20', 'Data,1')
select('Table', 'cell:Data,1(20)')
assert_p('Table', 'Text', '20', 'Data,1')
select('Table', 'cell:Data,1(20)')
click('Right')
select('Table', 'cell:Data,5(-19.00)')
assert_p('Table', 'Text', '-19.00', 'Data,5')
select('Table', 'cell:Data,4(-1)')
assert_p('Table', 'Text', '-1', 'Data,4')
select('Table', 'cell:Data,0(69694158)')
assert_p('Table', 'Text', '69694158', 'Data,0')
select('Table', 'cell:Data,0(69694158)')
click('Right')
select('Table', 'cell:Data,5(5.01)')
assert_p('Table', 'Text', '5.01', 'Data,5')
select('Table', 'cell:Data,4(1)')
assert_p('Table', 'Text', '1', 'Data,4')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_10'
if window('Record Editor'):
commonBits.selectOldFilemenu(select_menu, 'Utilities',
'File Copy Menu')
click('*5')
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
select('FileChooser1', commonBits.sampleDir() + 'csvDTAR020comma.csv')
commonBits.setRecordLayout2(select, 'DTAR020')
if commonBits.isJRecord():
select('FileChooser3', commonBits.velocityDir() + 'toCsv_Comma.vm')
else:
select('FileChooser2', commonBits.velocityDir() + 'toCsv_Comma.vm')
click('Right')
select('TabbedPane', '')
##click('Copy2')
commonBits.copy(click)
rightclick('TextField')
assert_p('TextField1', 'Text', commonBits.fl('Copy Done !!!'))
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Open')
click('Open')
select('FileChooser', commonBits.sampleDir() + 'csvDTAR020comma.csv')
commonBits.doEdit(click)
if window(''):
select('CheckBox', 'true')
click(commonBits.fl('Go'))
commonBits.doSleep()
close()
commonBits.doSleep()
# select('Table', 'rows:[1,2,3,4,5,6,7,8,9,10,11],columns:[1|KEYCODE-NO,2|STORE-NO]')
select(
'Table',
'rows:[1,2,3,4,5,6,7,8,9,10,11],columns:[1|KEYCODE-NO,2|STORE-NO]')
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Table View #{Selected Records#}'))
## select('Table2', 'rows:[1,2,3,4,5,6,7,8,9,10,11],columns:[1|KEYCODE-NO,2|STORE-NO]')
select('Table', 'cell:1|KEYCODE-NO,3(69694158)')
## assert_p('Table', 'Content', '[[69684558, 20, 40118, 280, -1, -19.00], [69684558, 20, 40118, 280, 1, 5.01], [69694158, 20, 40118, 280, 1, 19.00], [69694158, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [63604808, 20, 40118, 170, 1, 4.87], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99], [64634429, 20, 40118, 957, 1, 3.99], [66624458, 20, 40118, 957, 1, 0.89], [63674861, 20, 40118, 957, 10, 2.70]]')
assert_p(
'Table', 'Content',
'[[69684558, 20, 40118, 280, 1, 5.01], [69694158, 20, 40118, 280, 1, 19.00], [69694158, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [63604808, 20, 40118, 170, 1, 4.87], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99], [64634429, 20, 40118, 957, 1, 3.99], [66624458, 20, 40118, 957, 1, 0.89], [63674861, 20, 40118, 957, 10, 2.70]]'
)
select('Table', 'cell:1|KEYCODE-NO,3(69694158)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
## select('Table', 'rows:[1,2,3,4,5,6,7,8,9,10,11],columns:[1|KEYCODE-NO,2|STORE-NO]')
## select('Table', 'rows:[1,2,3,4,5,6,7,8,9,10,11],columns:[1|KEYCODE-NO,2|STORE-NO]')
select_menu(
commonBits.fl('Window') + '>>csvDTAR020comma.csv>>' +
commonBits.fl('Table:'))
select(
'Table',
'rows:[20,21,22,23,24,25,26,27,28,29,30,31,32,33,34],columns:[1|KEYCODE-NO]'
)
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Table View #{Selected Records#}'))
## select('Table2', 'rows:[20,21,22,23,24,25,26,27,28,29,30,31,32,33,34],columns:[1|KEYCODE-NO]')
select('Table', 'cell:2|STORE-NO,5(59)')
assert_p(
'Table', 'Content',
'[[60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [62684217, 59, 40118, 957, 1, 9.99], [67674686, 59, 40118, 929, 1, 3.99], [61684613, 59, 40118, 335, 1, 12.99], [64624770, 59, 40118, 957, 1, 2.59], [69694814, 166, 40118, 360, 1, 2.50], [69694814, 166, 40118, 360, 1, 2.50], [69644164, 166, 40118, 193, 1, 21.59], [62684907, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, 1, 13.99], [62694193, 166, 40118, 375, -1, -13.99], [62694193, 166, 40118, 375, 1, 11.99], [63654450, 166, 40118, 320, 1, 13.99], [62664576, 166, 40118, 320, 1, 9.72]]'
)
select('Table', 'cell:2|STORE-NO,5(59)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
## select('Table', 'rows:[20,21,22,23,24,25,26,27,28,29,30,31,32,33,34],columns:[1|KEYCODE-NO]')
## select('Table', 'rows:[20,21,22,23,24,25,26,27,28,29,30,31,32,33,34],columns:[1|KEYCODE-NO]')
select_menu(
commonBits.fl('Window') + '>>csvDTAR020comma.csv>>' +
commonBits.fl('Table:'))
select('Table', 'cell:2|STORE-NO,38(166)')
rightclick('Table', '2|STORE-NO,38')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:2|STORE-NO,38(166)')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p(
'Table', 'Content',
'[[KEYCODE-NO, 1, , 64674965, 64674965], [STORE-NO, 2, , 166, 166], [DATE, 3, , 40118, 40118], [DEPT-NO, 4, , 235, 235], [QTY-SOLD, 5, , -1, -1], [SALE-PRICE, 6, , -19.99, -19.99]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('TextArea')
assert_p('TextArea', 'Text', '64674965,166,40118,235,-1,-19.99,')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p(
'Table', 'Content',
'[[KEYCODE-NO, 1, , 64674965, 64674965], [STORE-NO, 2, , 166, 166], [DATE, 3, , 40118, 40118], [DEPT-NO, 4, , 235, 235], [QTY-SOLD, 5, , 1, 1], [SALE-PRICE, 6, , 12.00, 12.00]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('TextArea')
assert_p('TextArea', 'Text', '64674965,166,40118,235,1,12.00,')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p(
'Table', 'Content',
'[[KEYCODE-NO, 1, , 60624523, 60624523], [STORE-NO, 2, , 166, 166], [DATE, 3, , 40118, 40118], [DEPT-NO, 4, , 261, 261], [QTY-SOLD, 5, , 1, 1], [SALE-PRICE, 6, , 12.00, 12.00]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('TextArea')
assert_p('TextArea', 'Text', '60624523,166,40118,261,1,12.00,')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p(
'Table', 'Content',
'[[KEYCODE-NO, 1, , 66624253, 66624253], [STORE-NO, 2, , 166, 166], [DATE, 3, , 40118, 40118], [DEPT-NO, 4, , 957, 957], [QTY-SOLD, 5, , 1, 1], [SALE-PRICE, 6, , 3.49, 3.49]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('TextArea')
click('TextArea')
assert_p('TextArea', 'Text', '66624253,166,40118,957,1,3.49,')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p(
'Table', 'Content',
'[[KEYCODE-NO, 1, , 66624253, 66624253], [STORE-NO, 2, , 166, 166], [DATE, 3, , 40118, 40118], [DEPT-NO, 4, , 957, 957], [QTY-SOLD, 5, , 1, 1], [SALE-PRICE, 6, , 3.49, 3.49]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('TextArea')
assert_p('TextArea', 'Text', '66624253,166,40118,957,1,3.49,')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
assert_p(
'Table', 'Content',
'[[KEYCODE-NO, 1, , 64654284, 64654284], [STORE-NO, 2, , 166, 166], [DATE, 3, , 40118, 40118], [DEPT-NO, 4, , 957, 957], [QTY-SOLD, 5, , 1, 1], [SALE-PRICE, 6, , 3.99, 3.99]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(40118)')
click('TextArea')
assert_p('TextArea', 'Text', '64654284,166,40118,957,1,3.99,')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table', 'cell:2|STORE-NO,38(166)')
select('Table', 'cell:2|STORE-NO,38(166)')
select_menu(
commonBits.fl('Window') + '>>csvDTAR020comma.csv>>' +
commonBits.fl('Table:'))
select('Table', 'cell:2|STORE-NO,38(166)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare Menu')
click('*2')
select('FileChooser', commonBits.sampleDir() + 'csvDTAR020comma.csv')
click('Right')
if window(''):
select('CheckBox', 'true')
click(commonBits.fl('Go'))
close()
select('TabbedPane', '')
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
click('Right')
select('TabbedPane', '')
select('Table',
'cell:' + commonBits.fl('Equivalent Record') + ',0(-1)')
select('Table', 'DTAR020', commonBits.fl('Equivalent Record') + ',0')
select('Table', 'cell:' + commonBits.fl('Equivalent Record') + ',0(0)')
select('Table1', 'cell:' + commonBits.fl('Field') + ',2(DATE)')
assert_p(
'Table1', 'Content',
'[[KEYCODE-NO, KEYCODE-NO], [STORE-NO, STORE-NO], [DATE, DATE], [DEPT-NO, DEPT-NO], [QTY-SOLD, QTY-SOLD], [SALE-PRICE, SALE-PRICE]]'
)
## select('Table1', '')
select('Table',
'cell:' + commonBits.fl('Record') + ',0(GeneratedCsvRecord)')
assert_p('Table', 'Content', '[[GeneratedCsvRecord, DTAR020]]')
select('Table',
'cell:' + commonBits.fl('Record') + ',0(GeneratedCsvRecord)')
click('Right')
select('TabbedPane', '')
click(commonBits.fl('Compare'))
assert_p('TextPane', 'Text', 'Files are Identical !!!')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_10'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'Ams_PODownload_20050101.txt')
select('ComboBox2', 'ams PO Download')
commonBits.doEdit(click)
select_menu('View>>Record Based Tree')
## select('Table', '1', 'Parent Record,0')
## select('Table', '0', 'Parent Record,2')
select('Table', 'ams PO Download: Header', 'Parent Record,0')
select('Table', 'ams PO Download: Detail', 'Parent Record,2')
select('Table', 'cell:Parent Record,2(0)')
click('Build')
select_menu('File>>Save Tree as XML')
if window('Open'):
select('File Name', 'xmlSaveAms_PODownload_20050101.xml')
click('Open')
close()
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu('Window>>Ams_PODownload_20050101.txt>>Table:')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'File Copy Menu')
click('*1')
select('FileChooser', commonBits.sampleDir() + 'xmlSaveAms_PODownload_20050101.xml')
click('Right')
select('TabbedPane', '')
select('FileChooser', commonBits.sampleDir() + 'Ams_PO_fromXmlSave.txt')
commonBits.setRecordLayout2(select, 'ams PO Download')
if commonBits.isJRecord():
click('Right')
click('Right')
select('TabbedPane', '')
select('Table', 'cell:Equivalent Record,2(-1)')
select('Table', 'cell:Equivalent Record,2(1)')
select('Table', 'ams PO Download: Header', 'Equivalent Record,2')
# select('Table', 'cell:Equivalent Record,2(1)')
select('Table1', 'cell:Field,4(Sequence_Number)')
assert_p('Table1', 'Content', '[[Xml~Name, ], [Xml~Prefix, ], [Xml~Namespace, ], [Record_Type, Record Type], [Sequence_Number, Sequence Number], [Vendor, Vendor], [PO, PO], [Entry_Date, Entry Date], [beg01_code, beg01 code], [Department, Department], [Expected_Reciept_Date, Expected Reciept Date], [Cancel_by_date, Cancel by date], [Department_Name, Department Name], [Prcoess_Type, Prcoess Type], [Order_Type, Order Type], [Xml~End, ], [Following~Text, ]]')
select('Table1', 'cell:Field,4(Sequence_Number)')
select('Table', 'cell:Equivalent Record,3(0)')
select('Table', 'ams PO Download: Detail', 'Equivalent Record,3')
# select('Table', 'cell:Equivalent Record,3(0)')
select('Table1', 'cell:Field,4(Pack_Qty)')
assert_p('Table1', 'Content', '[[Xml~Name, ], [Xml~Prefix, ], [Xml~Namespace, ], [Record_Type, Record Type], [Pack_Qty, Pack Qty], [Pack_Cost, Pack Cost], [APN, APN], [Product, Product], [pmg_dtl_tech_key, pmg dtl tech key], [Case_Pack_id, Case Pack id], [Product_Name, Product Name], [Xml~End, ], [Following~Text, ]]')
select('Table1', 'cell:Field,4(Pack_Qty)')
select('Table', 'ams PO Download: Allocation', 'Equivalent Record,4')
select('Table', 'cell:Equivalent Record,4(2)')
select('Table1', 'cell:Field,4(DC_Number_1)')
assert_p('Table1', 'Content', '[[Xml~Name, ], [Xml~Prefix, ], [Xml~Namespace, ], [Record_Type, Record Type], [DC_Number_1, DC Number 1], [Pack_Quantity_1, Pack Quantity 1], [DC_Number_2, DC Number 2], [Pack_Quantity_2, Pack Quantity 2], [DC_Number_4, DC Number 4], [Pack_Quantity_4, Pack Quantity 4], [DC_Number_5, DC Number 5], [Pack_Quantity_5, Pack Quantity 5], [DC_Number_6, DC Number 6], [Pack_Quantity_6, Pack Quantity 6], [DC_Number_7, DC Number 7], [Pack_Quantity_7, Pack Quantity 7], [DC_Number_8, DC Number 8], [Pack_Quantity_8, Pack Quantity 8], [DC_Number_9, DC Number 9], [Pack_Quantity_9, Pack Quantity 9], [DC_Number_10, DC Number 10], [Pack_Quantity_10, Pack Quantity 10], [Xml~End, ], [Following~Text, ]]')
## select('Table1', '')
select('Table', 'cell:Record,3(ams_PO_Download__Detail)')
assert_p('Table', 'Content', '[[XML Start_Document, ], [ams_PO_Download, ], [ams_PO_Download__Header, ams PO Download: Header], [ams_PO_Download__Detail, ams PO Download: Detail], [ams_PO_Download__Allocation, ams PO Download: Allocation], [/ams_PO_Download__Detail, ], [/ams_PO_Download__Header, ], [/ams_PO_Download, ]]')
select('Table', 'cell:Record,3(ams_PO_Download__Detail)')
click('ReFrame', 787, 576)
click('Right')
select('TabbedPane', '')
click('Copy2')
assert_p('TextField1', 'Text', 'Copy Done !!! ')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare Menu')
click('*2')
select('FileChooser', commonBits.sampleDir() + 'xmlSaveAms_PODownload_20050101.xml')
click('Right')
select('TabbedPane', '')
select('FileChooser', commonBits.sampleDir() + 'Ams_PODownload_20050101.txt')
click('Right')
select('TabbedPane', '')
select('Table', 'cell:Equivalent Record,2(-1)')
select('Table', 'ams PO Download: Header', 'Equivalent Record,2')
# select('Table', 'cell:Equivalent Record,2(1)')
select('Table1', 'cell:Field,3(Record_Type)')
assert_p('Table1', 'Content', '[[Xml~Name, ], [Xml~Prefix, ], [Xml~Namespace, ], [Record_Type, Record Type], [Sequence_Number, Sequence Number], [Vendor, Vendor], [PO, PO], [Entry_Date, Entry Date], [beg01_code, beg01 code], [Department, Department], [Expected_Reciept_Date, Expected Reciept Date], [Cancel_by_date, Cancel by date], [Department_Name, Department Name], [Prcoess_Type, Prcoess Type], [Order_Type, Order Type], [Xml~End, ], [Following~Text, ]]')
select('Table1', 'cell:Field,3(Record_Type)')
select('Table', 'ams PO Download: Detail', 'Equivalent Record,3')
select('Table', 'cell:Equivalent Record,3(0)')
select('Table1', 'cell:Field,4(Pack_Qty)')
assert_p('Table1', 'Content', '[[Xml~Name, ], [Xml~Prefix, ], [Xml~Namespace, ], [Record_Type, Record Type], [Pack_Qty, Pack Qty], [Pack_Cost, Pack Cost], [APN, APN], [Product, Product], [pmg_dtl_tech_key, pmg dtl tech key], [Case_Pack_id, Case Pack id], [Product_Name, Product Name], [Xml~End, ], [Following~Text, ]]')
select('Table1', 'cell:Field,4(Pack_Qty)')
select('Table', 'cell:Equivalent Record,4(2)')
select('Table', 'ams PO Download: Allocation', 'Equivalent Record,4')
## select('Table', 'cell:Equivalent Record,4(2)')
select('Table1', 'cell:Field,3(Record_Type)')
assert_p('Table1', 'Content', '[[Xml~Name, ], [Xml~Prefix, ], [Xml~Namespace, ], [Record_Type, Record Type], [DC_Number_1, DC Number 1], [Pack_Quantity_1, Pack Quantity 1], [DC_Number_2, DC Number 2], [Pack_Quantity_2, Pack Quantity 2], [DC_Number_4, DC Number 4], [Pack_Quantity_4, Pack Quantity 4], [DC_Number_5, DC Number 5], [Pack_Quantity_5, Pack Quantity 5], [DC_Number_6, DC Number 6], [Pack_Quantity_6, Pack Quantity 6], [DC_Number_7, DC Number 7], [Pack_Quantity_7, Pack Quantity 7], [DC_Number_8, DC Number 8], [Pack_Quantity_8, Pack Quantity 8], [DC_Number_9, DC Number 9], [Pack_Quantity_9, Pack Quantity 9], [DC_Number_10, DC Number 10], [Pack_Quantity_10, Pack Quantity 10], [Xml~End, ], [Following~Text, ]]')
## select('Table1', '')
select('Table', 'cell:Record,2(ams_PO_Download__Header)')
## assert_p('Table', 'Content', '[[XML Start_Document, -1], [ams_PO_Download, -1], [ams_PO_Download__Header, 1], [ams_PO_Download__Detail, 0], [ams_PO_Download__Allocation, 2], [/ams_PO_Download__Detail, -1], [/ams_PO_Download__Header, -1], [/ams_PO_Download, -1]]')
assert_p('Table', 'Content', '[[XML Start_Document, ], [ams_PO_Download, ], [ams_PO_Download__Header, ams PO Download: Header], [ams_PO_Download__Detail, ams PO Download: Detail], [ams_PO_Download__Allocation, ams PO Download: Allocation], [/ams_PO_Download__Detail, ], [/ams_PO_Download__Header, ], [/ams_PO_Download, ]]')
select('Table', 'cell:Record,2(ams_PO_Download__Header)')
click('ReFrame', 782, 600)
click('Right')
select('TabbedPane', '')
click('Compare')
assert_p('TextPane', 'Text', 'Files are Identical !!!')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu('Window>>Two Layout Compare')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Open')
select('FileChooser', commonBits.sampleDir() + 'Ams_PO_fromXmlSave.txt')
select('ComboBox2', 'ams PO Download')
commonBits.doEdit(click)
select('Table', 'cell:3 - 4|DC Number 1,3(5078)')
select('Table', 'cell:3 - 4|DC Number 1,4(5303)')
rightclick('Table', '3 - 4|DC Number 1,4')
select_menu('Edit Record')
### select('Table1', 'cell:3 - 4|DC Number 1,4(5303)')
select('Table', 'cell:Data,7(5177)')
assert_p('Table', 'Content', '[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5303, 5303], [Pack Quantity 1, 7, 8, 1, 00000001], [DC Number 2, 15, 4, 5169, 5169], [Pack Quantity 2, 19, 8, 1, 00000001], [DC Number 4, 39, 4, 5171, 5171], [Pack Quantity 4, 43, 8, 1, 00000001], [DC Number 5, 51, 4, 5177, 5177], [Pack Quantity 5, 55, 8, 1, 00000001], [DC Number 6, 63, 4, 5016, 5016], [Pack Quantity 6, 67, 8, 1, 00000001], [DC Number 7, 75, 4, 5089, 5089], [Pack Quantity 7, 79, 8, 2, 00000002], [DC Number 8, 87, 4, 5136, 5136], [Pack Quantity 8, 91, 8, 1, 00000001], [DC Number 9, 99, 4, 5011, 5011], [Pack Quantity 9, 103, 8, 1, 00000001], [DC Number 10, 111, 4, 5046, 5046], [Pack Quantity 10, 115, 8, 1, 00000001]]')
select('Table', 'cell:Data,7(5177)')
click('TextArea')
assert_p('TextArea', 'Text', 'S1530300000001516900000001517100000001517700000001501600000001508900000002513600000001501100000001504600000001')
click('Right')
click('TextArea')
assert_p('TextArea', 'Text', 'S1514500000001509600000002516200000001516300000001516400000001519200000001515000000001517500000001000000000000')
click('Right')
select('Table', 'cell:Data,4(040929)')
assert_p('Table', 'Content', '[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.358, 45358], [Vendor, 8, 10, 4338, 0000004338], [PO, 18, 12, 233872, 000000233872], [Entry Date, 30, 6, 040929, 040929], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 290, 290], [Expected Reciept Date, 52, 6, 050103, 050103], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, OPTIONS PL, OPTIONS PL], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]')
select('Table', 'cell:Data,4(040929)')
click('TextArea')
assert_p('TextArea', 'Text', 'H1453580000004338000000233872040929 00 290 050103050107 OPTIONS PLCFT')
click('Right')
select('Table', 'cell:Data,5(43372078)')
assert_p('Table', 'Content', '[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 14.0000, 000140000], [Pack Cost, 12, 13, 119.8400, 0000001198400], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 43372078, 43372078], [pmg dtl tech key, 72, 15, 2117152, 2117152], [Case Pack id, 87, 15, 45872078, 45872078], [Product Name, 101, 50, MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGA, MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGA]]')
select('Table', 'cell:Data,5(43372078)')
click('TextArea')
assert_p('TextArea', 'Text', 'D100014000000000011984000000000000000 433720782117152 45872078 MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGA')
click('Right')
select('Table', 'cell:Data,5(5057)')
assert_p('Table', 'Content', '[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5036, 5036], [Pack Quantity 1, 7, 8, 1, 00000001], [DC Number 2, 15, 4, 5043, 5043], [Pack Quantity 2, 19, 8, 1, 00000001], [DC Number 4, 39, 4, 5057, 5057], [Pack Quantity 4, 43, 8, 1, 00000001], [DC Number 5, 51, 4, 5065, 5065], [Pack Quantity 5, 55, 8, 1, 00000001], [DC Number 6, 63, 4, 5069, 5069], [Pack Quantity 6, 67, 8, 1, 00000001], [DC Number 7, 75, 4, 5076, 5076], [Pack Quantity 7, 79, 8, 1, 00000001], [DC Number 8, 87, 4, 5079, 5079], [Pack Quantity 8, 91, 8, 1, 00000001], [DC Number 9, 99, 4, 5094, 5094], [Pack Quantity 9, 103, 8, 1, 00000001], [DC Number 10, 111, 4, 5128, 5128], [Pack Quantity 10, 115, 8, 1, 00000001]]')
select('Table', 'cell:Data,5(5057)')
click('TextArea')
click('TextArea')
assert_p('TextArea', 'Text', 'S1503600000001504300000001505700000001506500000001506900000001507600000001507900000001509400000001512800000001')
click('Right')
click('TextArea')
assert_p('TextArea', 'Text', 'S1515100000001518000000001517300000001000000000000000000000000000000000000000000000000000000000000000000000000')
click('Right')
click('TextArea')
assert_p('TextArea', 'Text', 'H1453590000004468000000255906040929 00 290 050103050107 OPTIONS PLCFT')
select('Table', 'cell:Data,9(050103)')
assert_p('Table', 'Content', '[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.359, 45359], [Vendor, 8, 10, 4468, 0000004468], [PO, 18, 12, 255906, 000000255906], [Entry Date, 30, 6, 040929, 040929], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 290, 290], [Expected Reciept Date, 52, 6, 050103, 050103], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, OPTIONS PL, OPTIONS PL], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]')
select('Table', 'cell:Data,9(050103)')
click('Right')
select('Table', 'cell:Data,7(45872078)')
select('Table', 'cell:Data,2(101.2000)')
assert_p('Table', 'Content', '[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 29.0000, 000290000], [Pack Cost, 12, 13, 101.2000, 0000001012000], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 45874751, 45874751], [pmg dtl tech key, 72, 15, 2117337, 2117337], [Case Pack id, 87, 15, 45872078, 45872078], [Product Name, 101, 50, MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOC, MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOC]]')
select('Table', 'cell:Data,2(101.2000)')
click('TextArea')
assert_p('TextArea', 'Text', 'D100029000000000010120000000000000000 458747512117337 45872078 MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOC')
#click('MetalInternalFrameTitlePane', 503, 14)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table', 'cell:3 - 4|DC Number 1,4(5303)')
select('Table', 'cell:3 - 4|DC Number 1,4(5303)')
select_menu('Window>>Ams_PO_fromXmlSave.txt>>Table:')
select('Table', 'cell:3 - 4|DC Number 1,4(5303)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_10'
if window('Record Editor'):
if commonBits.isJRecord():
select('FileChooser', commonBits.cobolTestDir() + 'fjComp.bin')
else:
select_menu('Record Layouts>>Load Cobol Copybook')
select('FileChooser', commonBits.cobolTestDir() + 'fjComp.cbl')
select('ComputerOptionCombo', 'Fujitsu')
select('BmKeyedComboBox1', 'Other')
## select('BmKeyedComboBox1', '9')
click('Go')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Open')
select('FileChooser', commonBits.cobolTestDir() + 'fjComp.bin')
click('Open')
select_menu('Record Layouts>>Load Cobol Copybook')
select('FileChooser', commonBits.cobolTestDir() + 'fjComp.cbl')
select('BmKeyedComboBox1', 'Other')
# select('BmKeyedComboBox1', '9')
select('ComputerOptionCombo', 'Fujitsu')
click('Go')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Open')
commonBits.setCobolLayout(select, 'fjComp', 'Fujitsu')
click('Edit1')
select('Table', 'cell:30 - 2|Num1,5(-123.45)')
assert_p('Table', 'Text', '19.63', '30 - 2|Num1,7')
select('Table', 'cell:30 - 2|Num1,12(-63.79)')
assert_p('Table', 'Content', '[[1.23, ;, 1, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23, ;, 1.23], [-1.23, ;, -1, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, 1.23], [23.45, ;, 23, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45, ;, 23.45], [-23.45, ;, -23, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, -23.45, ;, 23.45], [123.45, ;, 23, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45, ;, 123.45], [-123.45, ;, -23, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, -123.45, ;, 123.45], [4567.89, ;, 67, ;, -19.63, ;, -19.63, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89, ;, 4567.89], [-4567.89, ;, -67, ;, 19.63, ;, 19.63, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, -4567.89, ;, 4567.89], [34567.89, ;, 67, ;, -166.19, ;, -166.19, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89, ;, 34567.89], [-34567.89, ;, -67, ;, 166.19, ;, 166.19, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, -34567.89, ;, 34567.89], [234567.89, ;, 67, ;, -50.99, ;, -50.99, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89, ;, 234567.89], [-234567.89, ;, -67, ;, 50.99, ;, 50.99, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, -234567.89, ;, 234567.89], [91234567.89, ;, 67, ;, -63.79, ;, -63.79, ;, 5335221.97, ;, 5335221.97, ;, 5335221.97, ;, 5335221.97, ;, 5335221.97, ;, 91234567.89, ;, 91234567.89, ;, 91234567.89, ;, 91234567.89, ;, 91234567.89, ;, 91234567.89, ;, 91234567.89, ;, 91234567.89, ;, 91234567.89, ;, 5335221.97], [-91234567.89, ;, -67, ;, 63.79, ;, 63.79, ;, -5335221.97, ;, -5335221.97, ;, -5335221.97, ;, -5335221.97, ;, -5335221.97, ;, -91234567.89, ;, -91234567.89, ;, -91234567.89, ;, -91234567.89, ;, -91234567.89, ;, -91234567.89, ;, -91234567.89, ;, -91234567.89, ;, -91234567.89, ;, 5335221.97], [987654321.12, ;, 21, ;, -68.64, ;, -68.64, ;, -188156.96, ;, -188156.96, ;, -188156.96, ;, -188156.96, ;, -188156.96, ;, 87654321.12, ;, 987654321.12, ;, 987654321.12, ;, 987654321.12, ;, 987654321.12, ;, 987654321.12, ;, 987654321.12, ;, 987654321.12, ;, 987654321.12, ;, 188156.96], [-987654321.12, ;, -21, ;, 68.64, ;, 68.64, ;, 188156.96, ;, 188156.96, ;, 188156.96, ;, 188156.96, ;, 188156.96, ;, -87654321.12, ;, -987654321.12, ;, -987654321.12, ;, -987654321.12, ;, -987654321.12, ;, -987654321.12, ;, -987654321.12, ;, -987654321.12, ;, -987654321.12, ;, 188156.96], [1987654321.12, ;, 21, ;, -130.08, ;, -130.08, ;, 11969364.96, ;, 11969364.96, ;, 11969364.96, ;, 11969364.96, ;, 11969364.96, ;, 87654321.12, ;, 987654321.12, ;, 1987654321.12, ;, 1987654321.12, ;, 1987654321.12, ;, 1987654321.12, ;, 1987654321.12, ;, 1987654321.12, ;, 1987654321.12, ;, 11969364.96], [-1987654321.12, ;, -21, ;, 130.08, ;, 130.08, ;, -11969364.96, ;, -11969364.96, ;, -11969364.96, ;, -11969364.96, ;, -11969364.96, ;, -87654321.12, ;, -987654321.12, ;, -1987654321.12, ;, -1987654321.12, ;, -1987654321.12, ;, -1987654321.12, ;, -1987654321.12, ;, -1987654321.12, ;, -1987654321.12, ;, 11969364.96], [21987654321.12, ;, 21, ;, -48.16, ;, -48.16, ;, -2578234.40, ;, -2578234.40, ;, -2578234.40, ;, -2578234.40, ;, -2578234.40, ;, 87654321.12, ;, 987654321.12, ;, 1987654321.12, ;, 21987654321.12, ;, 21987654321.12, ;, 21987654321.12, ;, 21987654321.12, ;, 21987654321.12, ;, 21987654321.12, ;, 2578234.40], [-21987654321.12, ;, -21, ;, 48.16, ;, 48.16, ;, 2578234.40, ;, 2578234.40, ;, 2578234.40, ;, 2578234.40, ;, 2578234.40, ;, -87654321.12, ;, -987654321.12, ;, -1987654321.12, ;, -21987654321.12, ;, -21987654321.12, ;, -21987654321.12, ;, -21987654321.12, ;, -21987654321.12, ;, -21987654321.12, ;, 2578234.40], [321987654321.12, ;, 21, ;, -130.08, ;, -130.08, ;, -6043860.00, ;, -6043860.00, ;, -6043860.00, ;, -6043860.00, ;, -6043860.00, ;, 87654321.12, ;, 987654321.12, ;, 1987654321.12, ;, 21987654321.12, ;, 321987654321.12, ;, 321987654321.12, ;, 321987654321.12, ;, 321987654321.12, ;, 321987654321.12, ;, 6043860.00], [-321987654321.12, ;, -21, ;, 130.08, ;, 130.08, ;, 6043860.00, ;, 6043860.00, ;, 6043860.00, ;, 6043860.00, ;, 6043860.00, ;, -87654321.12, ;, -987654321.12, ;, -1987654321.12, ;, -21987654321.12, ;, -321987654321.12, ;, -321987654321.12, ;, -321987654321.12, ;, -321987654321.12, ;, -321987654321.12, ;, 6043860.00], [4321987654321.12, ;, 21, ;, -130.08, ;, -130.08, ;, 5014029.28, ;, 5014029.28, ;, 5014029.28, ;, 5014029.28, ;, 5014029.28, ;, 87654321.12, ;, 987654321.12, ;, 1987654321.12, ;, 21987654321.12, ;, 321987654321.12, ;, 4321987654321.12, ;, 4321987654321.12, ;, 4321987654321.12, ;, 4321987654321.12, ;, 5014029.28], [-4321987654321.12, ;, -21, ;, 130.08, ;, 130.08, ;, -5014029.28, ;, -5014029.28, ;, -5014029.28, ;, -5014029.28, ;, -5014029.28, ;, -87654321.12, ;, -987654321.12, ;, -1987654321.12, ;, -21987654321.12, ;, -321987654321.12, ;, -4321987654321.12, ;, -4321987654321.12, ;, -4321987654321.12, ;, -4321987654321.12, ;, 5014029.28], [54321987654321.12, ;, 21, ;, 197.60, ;, 197.60, ;, 14388626.40, ;, 14388626.40, ;, 14388626.40, ;, 14388626.40, ;, 14388626.40, ;, 87654321.12, ;, 987654321.12, ;, 1987654321.12, ;, 21987654321.12, ;, 321987654321.12, ;, 4321987654321.12, ;, 54321987654321.12, ;, 54321987654321.12, ;, 54321987654321.12, ;, 14388626.40], [-54321987654321.12, ;, -21, ;, -197.60, ;, -197.60, ;, -14388626.40, ;, -14388626.40, ;, -14388626.40, ;, -14388626.40, ;, -14388626.40, ;, -87654321.12, ;, -987654321.12, ;, -1987654321.12, ;, -21987654321.12, ;, -321987654321.12, ;, -4321987654321.12, ;, -54321987654321.12, ;, -54321987654321.12, ;, -54321987654321.12, ;, 14388626.40], [654321987654321.12, ;, 21, ;, 197.60, ;, 197.60, ;, -1965227.04, ;, -1965227.04, ;, -1965227.04, ;, -1965227.04, ;, -1965227.04, ;, 87654321.12, ;, 987654321.12, ;, 1987654321.12, ;, 21987654321.12, ;, 321987654321.12, ;, 4321987654321.12, ;, 54321987654321.12, ;, 654321987654321.12, ;, 654321987654321.12, ;, 1965227.04], [-654321987654321.12, ;, -21, ;, -197.60, ;, -197.60, ;, 1965227.04, ;, 1965227.04, ;, 1965227.04, ;, 1965227.04, ;, 1965227.04, ;, -87654321.12, ;, -987654321.12, ;, -1987654321.12, ;, -21987654321.12, ;, -321987654321.12, ;, -4321987654321.12, ;, -54321987654321.12, ;, -654321987654321.12, ;, -654321987654321.12, ;, 1965227.04], [7654321987654321.12, ;, 21, ;, 197.60, ;, 197.60, ;, -20961492.00, ;, -20961492.00, ;, -20961492.00, ;, -20961492.00, ;, -20961492.00, ;, 87654321.12, ;, 987654321.12, ;, 1987654321.12, ;, 21987654321.12, ;, 321987654321.12, ;, 4321987654321.12, ;, 54321987654321.12, ;, 654321987654321.12, ;, 7654321987654321.12, ;, 20961492.00], [-7654321987654321.12, ;, -21, ;, -197.60, ;, -197.60, ;, 20961492.00, ;, 20961492.00, ;, 20961492.00, ;, 20961492.00, ;, 20961492.00, ;, -87654321.12, ;, -987654321.12, ;, -1987654321.12, ;, -21987654321.12, ;, -321987654321.12, ;, -4321987654321.12, ;, -54321987654321.12, ;, -654321987654321.12, ;, -7654321987654321.12, ;, 20961492.00], [-1.21, ;, -1, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, -1.21, ;, 1.21], [-1.22, ;, -1, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, -1.22, ;, 1.22], [-1.23, ;, -1, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, -1.23, ;, 1.23], [-1.24, ;, -1, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, -1.24, ;, 1.24], [-1.25, ;, -1, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, -1.25, ;, 1.25], [-1.26, ;, -1, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, -1.26, ;, 1.26], [-1.27, ;, -1, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, -1.27, ;, 1.27], [-1.28, ;, -1, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, -1.28, ;, 1.28], [-1.29, ;, -1, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, -1.29, ;, 1.29], [-1.20, ;, -1, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, -1.20, ;, 1.20]]')
select('Table', 'cell:30 - 2|Num1,19(48.16)')
assert_p('Table', 'RowCount', '40')
select('Table', 'cell:30 - 2|Num1,21(130.08)')
assert_p('Table', 'Text', '130.08', '30 - 2|Num1,21')
select('Table', 'cell:30 - 2|Num1,22(-130.08)')
rightclick('Table', '30 - 2|Num1,22')
select_menu('Edit Record')
### select('Table1', 'cell:30 - 2|Num1,22(-130.08)')
select('Table', 'cell:Data,8(5014029.28)')
assert_p('Table', 'Content', '''[[NumA, 1, 25, 4321987654321.12, 4,321,987,654,321.12, 2020202020342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, 21, , 0015], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, -130.08, � cd30], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, -130.08, � cd30], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, 5014029.28, 馔0, 1de2cd30], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, 5014029.28, 馔0, 1de2cd30], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, 5014029.28, 馔0, 1de2cd30], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, 5014029.28, 馔0, 1de2cd30], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, 5014029.28, 馔0, 1de2cd30], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, 87654321.12,
u� 000000020a75e130], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, 987654321.12, � 00000016fee0e530], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, 1987654321.12, .GW� 0000002e4757cd30], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, 21987654321.12, �稹� 000001fff0a1ed30], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, 321987654321.12, H垸� 00001d48dbf9cd30], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 5014029.28, 馔0, 1de2cd30]]''')
select('Table', 'cell:Data,0(4321987654321.12)')
assert_p('Table', 'Text', '21', 'Data,2')
select('Table', 'cell:Data,12(5014029.28)')
assert_p('Table', 'Content', '''[[NumA, 1, 25, 4321987654321.12, 4,321,987,654,321.12, 2020202020342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, 21, , 0015], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, -130.08, � cd30], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, -130.08, � cd30], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, 5014029.28, 馔0, 1de2cd30], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, 5014029.28, 馔0, 1de2cd30], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, 5014029.28, 馔0, 1de2cd30], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, 5014029.28, 馔0, 1de2cd30], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, 5014029.28, 馔0, 1de2cd30], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, 87654321.12,
u� 000000020a75e130], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, 987654321.12, � 00000016fee0e530], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, 1987654321.12, .GW� 0000002e4757cd30], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, 21987654321.12, �稹� 000001fff0a1ed30], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, 321987654321.12, H垸� 00001d48dbf9cd30], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 5014029.28, 馔0, 1de2cd30]]''')
select('Table', 'cell:Data,12(5014029.28)')
click('Right')
select('Table', 'cell:Data,16(-5014029.28)')
assert_p('Table', 'Content', '[[NumA, 1, 25, -4321987654321.12, -4,321,987,654,321.12, 202020202d342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, -21, ��, ffeb], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, 130.08, 2�, 32d0], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, 130.08, 2�, 32d0], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, -5014029.28, � 2�, e21d32d0], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, -5014029.28, � 2�, e21d32d0], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, -5014029.28, � 2�, e21d32d0], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, -5014029.28, � 2�, e21d32d0], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, -5014029.28, � 2�, e21d32d0], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, -87654321.12, ���� �, fffffffdf58a1ed0], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, -987654321.12, ���� �, ffffffe9011f1ad0], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, -1987654321.12, ���迅� ffffffd1b8a832d0], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, -21987654321.12, ���^�, fffffe000f5e12d0], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, -321987654321.12, ��夥$2�, ffffe2b7240632d0], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, -4321987654321.12, �赈 2�, fffe76eae21d32d0], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, -4321987654321.12, �赈 2�, fffe76eae21d32d0], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, -4321987654321.12, �赈 2�, fffe76eae21d32d0], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, -4321987654321.12, �赈 2�, fffe76eae21d32d0], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 5014029.28, 馔0, 1de2cd30]]')
select('Table', 'cell:Data,16(-5014029.28)')
click('Right')
select('Table', 'cell:Data,20(987654321.12)')
assert_p('Table', 'Content', '''[[NumA, 1, 25, 54321987654321.12, 54,321,987,654,321.12, 2020202035342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, 21, , 0015], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, 197.60, M0, 4d30], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, 197.60, M0, 4d30], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, 14388626.40, U肕0, 55c34d30], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, 14388626.40, U肕0, 55c34d30], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, 14388626.40, U肕0, 55c34d30], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, 14388626.40, U肕0, 55c34d30], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, 14388626.40, U肕0, 55c34d30], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, 87654321.12,
u� 000000020a75e130], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, 987654321.12, � 00000016fee0e530], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, 1987654321.12, .GW� 0000002e4757cd30], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, 21987654321.12, �稹� 000001fff0a1ed30], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, 321987654321.12, H垸� 00001d48dbf9cd30], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, 54321987654321.12, L嶶肕0, 00134c8e55c34d30], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, 54321987654321.12, L嶶肕0, 00134c8e55c34d30], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, 54321987654321.12, L嶶肕0, 00134c8e55c34d30], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 14388626.40, U肕0, 55c34d30]]''')
select('Table', 'cell:Data,20(987654321.12)')
click('Right')
select('Table', 'cell:Data,22(-1987654321.12)')
assert_p('Table', 'Content', '[[NumA, 1, 25, -54321987654321.12, -54,321,987,654,321.12, 2020202d35342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, -21, ��, ffeb], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, -197.60, 残, b2d0], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, -197.60, 残, b2d0], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, -14388626.40, �残, aa3cb2d0], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, -14388626.40, �残, aa3cb2d0], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, -14388626.40, �残, aa3cb2d0], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, -14388626.40, �残, aa3cb2d0], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, -14388626.40, �残, aa3cb2d0], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, -87654321.12, ���� �, fffffffdf58a1ed0], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, -987654321.12, ���� �, ffffffe9011f1ad0], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, -1987654321.12, ���迅� ffffffd1b8a832d0], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, -21987654321.12, ���^�, fffffe000f5e12d0], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, -321987654321.12, ��夥$2�, ffffe2b7240632d0], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, -4321987654321.12, �赈 2�, fffe76eae21d32d0], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, -54321987654321.12, �斐q�残, ffecb371aa3cb2d0], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, -54321987654321.12, �斐q�残, ffecb371aa3cb2d0], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, -54321987654321.12, �斐q�残, ffecb371aa3cb2d0], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 14388626.40, U肕0, 55c34d30]]')
select('Table', 'cell:Data,22(-1987654321.12)')
click('Right')
select('Table', 'cell:Data,22(1987654321.12)')
assert_p('Table', 'Content', '''[[NumA, 1, 25, 654321987654321.12, 654,321,987,654,321.12, 2020203635342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, 21, , 0015], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, 197.60, M0, 4d30], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, 197.60, M0, 4d30], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, -1965227.04, 鬒M0, f4494d30], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, -1965227.04, 鬒M0, f4494d30], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, -1965227.04, 鬒M0, f4494d30], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, -1965227.04, 鬒M0, f4494d30], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, -1965227.04, 鬒M0, f4494d30], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, 87654321.12,
u� 000000020a75e130], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, 987654321.12, � 00000016fee0e530], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, 1987654321.12, .GW� 0000002e4757cd30], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, 21987654321.12, �稹� 000001fff0a1ed30], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, 321987654321.12, H垸� 00001d48dbf9cd30], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, 54321987654321.12, L嶶肕0, 00134c8e55c34d30], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, 654321987654321.12, 鑦<鬒M0, 00e8763cf4494d30], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, 654321987654321.12, 鑦<鬒M0, 00e8763cf4494d30], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 1965227.04, 恫�, 0bb6b2d0]]''')
select('Table', 'cell:Data,22(1987654321.12)')
click('Right')
select('Table', 'cell:Data,22(-1987654321.12)')
assert_p('Table', 'Content', '[[NumA, 1, 25, -654321987654321.12, -654,321,987,654,321.12, 20202d3635342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, -21, ��, ffeb], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, -197.60, 残, b2d0], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, -197.60, 残, b2d0], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, 1965227.04, 恫�, 0bb6b2d0], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, 1965227.04, 恫�, 0bb6b2d0], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, 1965227.04, 恫�, 0bb6b2d0], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, 1965227.04, 恫�, 0bb6b2d0], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, 1965227.04, 恫�, 0bb6b2d0], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, -87654321.12, ���� �, fffffffdf58a1ed0], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, -987654321.12, ���� �, ffffffe9011f1ad0], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, -1987654321.12, ���迅� ffffffd1b8a832d0], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, -21987654321.12, ���^�, fffffe000f5e12d0], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, -321987654321.12, ��夥$2�, ffffe2b7240632d0], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, -4321987654321.12, �赈 2�, fffe76eae21d32d0], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, -54321987654321.12, �斐q�残, ffecb371aa3cb2d0], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, -654321987654321.12, �壝 恫�, ff1789c30bb6b2d0], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, -654321987654321.12, �壝 恫�, ff1789c30bb6b2d0], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 1965227.04, 恫�, 0bb6b2d0]]')
select('Table', 'cell:Data,22(-1987654321.12)')
click('Right')
select('Table', 'cell:Data,22(1987654321.12)')
assert_p('Table', 'Content', r'''[[NumA, 1, 25, 7654321987654321.12, 7,654,321,987,654,321.12, 20372c3635342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, 21, , 0015], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, 197.60, M0, 4d30], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, 197.60, M0, 4d30], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, -20961492.00, �M0, 830f4d30], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, -20961492.00, �M0, 830f4d30], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, -20961492.00, �M0, 830f4d30], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, -20961492.00, �M0, 830f4d30], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, -20961492.00, �M0, 830f4d30], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, 87654321.12,
u� 000000020a75e130], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, 987654321.12, � 00000016fee0e530], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, 1987654321.12, .GW� 0000002e4757cd30], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, 21987654321.12, �稹� 000001fff0a1ed30], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, 321987654321.12, H垸� 00001d48dbf9cd30], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, 4321987654321.12, � 馔0, 000189151de2cd30], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, 54321987654321.12, L嶶肕0, 00134c8e55c34d30], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, 654321987654321.12, 鑦<鬒M0, 00e8763cf4494d30], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, 7654321987654321.12,
焅噧M0, 0a9f5c87830f4d30], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 20961492.00, |鸩�, 7cf0b2d0]]''')
select('Table', 'cell:Data,22(1987654321.12)')
click('Right')
select('Table', 'cell:Data,22(-1987654321.12)')
assert_p('Table', 'Content', '[[NumA, 1, 25, -7654321987654321.12, -7,654,321,987,654,321.12, 2d372c3635342c3332312c3938372c3635342c3332312e3132], [sep0, 26, 1, ;, ;, 3b], [Num0, 27, 2, -21, ��, ffeb], [sep1, 29, 1, ;, ;, 3b], [Num1, 30, 2, -197.60, 残, b2d0], [sep2, 32, 1, ;, ;, 3b], [Num2, 33, 2, -197.60, 残, b2d0], [sep3, 35, 1, ;, ;, 3b], [Num3, 36, 4, 20961492.00, |鸩�, 7cf0b2d0], [sep4, 40, 1, ;, ;, 3b], [Num4, 41, 4, 20961492.00, |鸩�, 7cf0b2d0], [sep5, 45, 1, ;, ;, 3b], [Num5, 46, 4, 20961492.00, |鸩�, 7cf0b2d0], [sep6, 50, 1, ;, ;, 3b], [Num6, 51, 4, 20961492.00, |鸩�, 7cf0b2d0], [sep7, 55, 1, ;, ;, 3b], [Num7, 56, 4, 20961492.00, |鸩�, 7cf0b2d0], [sep8, 60, 1, ;, ;, 3b], [Num8, 61, 8, -87654321.12, ���� �, fffffffdf58a1ed0], [sep9, 69, 1, ;, ;, 3b], [Num9, 70, 8, -987654321.12, ���� �, ffffffe9011f1ad0], [sep10, 78, 1, ;, ;, 3b], [Num10, 79, 8, -1987654321.12, ���迅� ffffffd1b8a832d0], [sep11, 87, 1, ;, ;, 3b], [Num11, 88, 8, -21987654321.12, ���^�, fffffe000f5e12d0], [sep12, 96, 1, ;, ;, 3b], [Num12, 97, 8, -321987654321.12, ��夥$2�, ffffe2b7240632d0], [sep13, 105, 1, ;, ;, 3b], [Num13, 106, 8, -4321987654321.12, �赈 2�, fffe76eae21d32d0], [sep14, 114, 1, ;, ;, 3b], [Num14, 115, 8, -54321987654321.12, �斐q�残, ffecb371aa3cb2d0], [sep15, 123, 1, ;, ;, 3b], [Num15, 124, 8, -654321987654321.12, �壝 恫�, ff1789c30bb6b2d0], [sep16, 132, 1, ;, ;, 3b], [Num16, 133, 8, -7654321987654321.12, 鮜|鸩�, f560a3787cf0b2d0], [sep17, 141, 1, ;, ;, 3b], [Num17, 142, 4, 20961492.00, |鸩�, 7cf0b2d0]]')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_10'
if window('Record Editor'):
commonBits.selectOldFilemenu(select_menu, 'Utilities',
'File Copy Menu')
click('*1')
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
commonBits.setMainframeCobolLayout(select, 'DTAR020')
click('Right')
select('TabbedPane', '')
select('FileChooser',
commonBits.sampleDir() + 'zzzXfeReverse3DTAR020a.csv')
# click('ScrollPane$ScrollBar', 4, 51)
# select('ComboBox2', 'XfeDTAR020_reverse')
commonBits.setRecordLayout2(select, 'XfeDTAR020_reverse')
if commonBits.isJRecord():
click('Right')
click('Right')
select('TabbedPane', '')
select('Table1', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
assert_p(
'Table1', 'Content',
'[[KEYCODE-NO, KEYCODE-NO], [STORE-NO, STORE-NO], [DATE, DATE], [DEPT-NO, DEPT-NO], [QTY-SOLD, QTY-SOLD], [SALE-PRICE, SALE-PRICE]]'
)
# select('Table1', '')
select('Table', 'cell:' + commonBits.fl('Record') + ',0(DTAR020)')
doubleclick('Table', commonBits.fl('Record') + ',0')
select('Table', 'cell:' + commonBits.fl('Record') + ',0(DTAR020)')
doubleclick('Table', commonBits.fl('Record') + ',0')
assert_p('Table', 'Content', '[[DTAR020, XfeDTAR020_reverse]]')
## assert_p('Table', 'Content', '[[DTAR020, ]]')
select('Table', 'cell:' + commonBits.fl('Record') + ',0(DTAR020)')
click('Right')
select('TabbedPane', '')
# click(commonBits.fl('Choose File'))
# if window('Open'):
# click('Cancel')
# close()
select('FileChooser', commonBits.userDir() + 'copyDTAR020toCsv1.xml')
##commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'copyDTAR020toCsv1.xml')
commonBits.save1(click)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(
commonBits.fl('Window') + '>>' + commonBits.fl('Menu') + '>>' +
commonBits.fl('Copy Menu'))
click('*')
select('FileChooser', commonBits.userDir() + 'copyDTAR020toCsv1.xml')
##commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'copyDTAR020toCsv1.xml')
click(commonBits.fl('Run Copy Dialog'))
assert_p('FileChooser', 'Text', commonBits.sampleDir() + 'DTAR020.bin')
if commonBits.isRecordEditor():
assert_p('ComboBox2', 'Text', 'DTAR020')
click('Right')
select('TabbedPane', '')
assert_p('FileChooser', 'Text',
commonBits.sampleDir() + 'zzzXfeReverse3DTAR020a.csv')
# select('ComboBox2', 'Generic CSV - enter details')
# click('ScrollPane$ScrollBar', 8, 60)
# click('ScrollPane$ScrollBar', 8, 74)
# click('ScrollPane$ScrollBar', 8, 81)
# click('ScrollPane$ScrollBar', 8, 81)
if commonBits.isRecordEditor():
assert_p('ComboBox2', 'Text', 'XfeDTAR020_reverse')
click('Right')
select('TabbedPane', '')
select('Table1', 'cell:' + commonBits.fl('Field') + ',1(STORE-NO)')
assert_p(
'Table1', 'Content',
'[[KEYCODE-NO, KEYCODE-NO], [STORE-NO, STORE-NO], [DATE, DATE], [DEPT-NO, DEPT-NO], [QTY-SOLD, QTY-SOLD], [SALE-PRICE, SALE-PRICE]]'
)
# select('Table1', '')
select('Table', 'cell:' + commonBits.fl('Record') + ',0(DTAR020)')
doubleclick('Table', commonBits.fl('Record') + ',0')
assert_p('Table', 'Content', '[[DTAR020, XfeDTAR020_reverse]]')
## assert_p('Table', 'Content', '[[DTAR020, ]]')
select('Table', 'cell:' + commonBits.fl('Record') + ',0(DTAR020)')
click('Right')
select('TabbedPane', '')
#click('Copy2')
commonBits.copy(click)
assert_p('TextField1', 'Text', commonBits.fl('Copy Done !!!'))
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Open')
## click('MetalInternalFrameTitlePane', 105, 4)
select('FileChooser',
commonBits.sampleDir() + 'zzzXfeReverse3DTAR020a.csv')
commonBits.setRecordLayout(select, 'XfeDTAR020_reverse')
# click('ScrollPane$ScrollBar', 9, 93)
# click('ScrollPane$ScrollBar', 9, 102)
# click('ScrollPane$ScrollBar', 9, 102)
# click('ScrollPane$ScrollBar', 6, 92)
commonBits.doEdit(click)
select('Table', 'cell:2|SALE-PRICE,0(19.00)')
assert_p('Table', 'Text', '5.01', '2|SALE-PRICE,2')
select('Table', 'cell:2|SALE-PRICE,0(19.00)')
rightclick('Table', '2|SALE-PRICE,1')
select('Table', 'cell:2|SALE-PRICE,1(-19.00)')
assert_p('Table', 'RowCount', '379')
select('Table', 'cell:2|SALE-PRICE,2(5.01)')
assert_p('Table', 'ColumnCount', '6')
select(
'Table',
'rows:[4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20],columns:[2|SALE-PRICE]'
)
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Table View #{Selected Records#}'))
# select('Table2', 'rows:[4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20],columns:[2|SALE-PRICE]')
select('Table', 'cell:2|SALE-PRICE,2(4.87)')
assert_p(
'Table', 'Content',
'[[-1, -19.00, 280, 40118, 20, 69694158], [1, 5.01, 280, 40118, 20, 69694158], [1, 4.87, 170, 40118, 20, 63604808], [1, 69.99, 685, 40118, 20, 62684671], [-1, -69.99, 685, 40118, 20, 62684671], [1, 3.99, 957, 40118, 20, 64634429], [1, 0.89, 957, 40118, 20, 66624458], [10, 2.70, 957, 40118, 20, 63674861], [1, 3.59, 929, 40118, 20, 65674532], [1, 1.99, 957, 40118, 59, 64614401], [1, 1.99, 957, 40118, 59, 64614401], [1, 17.99, 335, 40118, 59, 61664713], [-1, -17.99, 335, 40118, 59, 61664713], [1, 8.99, 410, 40118, 59, 68634752], [1, 5.95, 878, 40118, 59, 60614487], [1, 12.65, 878, 40118, 59, 63644339], [1, 3.99, 620, 40118, 59, 60694698]]'
)
select('Table', 'cell:2|SALE-PRICE,2(4.87)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
# select('Table', 'rows:[4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20],columns:[2|SALE-PRICE]')
# select('Table', 'rows:[4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20],columns:[2|SALE-PRICE]')
select_menu(
commonBits.fl('Window') + '>>zzzXfeReverse3DTAR020a.csv>>' +
commonBits.fl('Table:'))
select('Table', 'cell:2|SALE-PRICE,16(-17.99)')
rightclick('Table', '2|SALE-PRICE,16')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:2|SALE-PRICE,16(-17.99)')
select('Table', 'cell:' + commonBits.fl('Data') + ',1(-17.99)')
assert_p('Table', 'Text',
'cell:' + commonBits.fl('Data') + ',1(-17.99)')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(335)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , -1, -1], [SALE-PRICE, 2, , -17.99, -17.99], [DEPT-NO, 3, , 335, 335], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 61664713, 61664713]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(335)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''-1þ-17.99þ335þ40118þ59þ61664713
23f233233f333f33333f33f33333333
d1ed17e99e335e40118e59e61664713''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(68634752)')
assert_p('Table', 'Text',
'cell:' + commonBits.fl('Data') + ',5(68634752)')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 8.99, 8.99], [DEPT-NO, 3, , 410, 410], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 68634752, 68634752]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ8.99þ410þ40118þ59þ68634752
3f3233f333f33333f33f33333333
1e8e99e410e40118e59e68634752''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 5.95, 5.95], [DEPT-NO, 3, , 878, 878], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 60614487, 60614487]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ5.95þ878þ40118þ59þ60614487
3f3233f333f33333f33f33333333
1e5e95e878e40118e59e60614487''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 12.65, 12.65], [DEPT-NO, 3, , 878, 878], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 63644339, 63644339]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ12.65þ878þ40118þ59þ63644339
3f33233f333f33333f33f33333333
1e12e65e878e40118e59e63644339''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',1(3.99)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 3.99, 3.99], [DEPT-NO, 3, , 620, 620], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 60694698, 60694698]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',1(3.99)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ3.99þ620þ40118þ59þ60694698
3f3233f333f33333f33f33333333
1e3e99e620e40118e59e60694698''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 3.99, 3.99], [DEPT-NO, 3, , 620, 620], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 60664659, 60664659]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ3.99þ620þ40118þ59þ60664659
3f3233f333f33333f33f33333333
1e3e99e620e40118e59e60664659''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(62684217)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 9.99, 9.99], [DEPT-NO, 3, , 957, 957], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 62684217, 62684217]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',5(62684217)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ9.99þ957þ40118þ59þ62684217
3f3233f333f33333f33f33333333
1e9e99e957e40118e59e62684217''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 3.99, 3.99], [DEPT-NO, 3, , 929, 929], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 67674686, 67674686]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ3.99þ929þ40118þ59þ67674686
3f3233f333f33333f33f33333333
1e3e99e929e40118e59e67674686''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(61684613)')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(335)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 12.99, 12.99], [DEPT-NO, 3, , 335, 335], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 61684613, 61684613]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(335)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ12.99þ335þ40118þ59þ61684613
3f33233f333f33333f33f33333333
1e12e99e335e40118e59e61684613''')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 2.59, 2.59], [DEPT-NO, 3, , 957, 957], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 59, 59], [KEYCODE-NO, 6, , 64624770, 64624770]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(40118)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''1þ2.59þ957þ40118þ59þ64624770
3f3233f333f33333f33f33333333
1e2e59e957e40118e59e64624770''')
close()