def test():
set_java_recorded_version("1.6.0_22")
if frame(' - Open File:0'):
select('File', commonBits.sampleDir() + 'DTAR020_tst1.bin')
commonBits.setRecordLayout(select, 'DTAR020')
click('Edit')
close()
if frame('Table: - DTAR020_tst1.bin:0'):
assert_content('JTable_22', [ ['63604808', '20', '40118', '170', '1', '4870'],
['69684558', '20', '40118', '280', '1', '19000'],
['69684558', '20', '40118', '280', '-1', '-19000'],
['69694158', '20', '40118', '280', '1', '5010'],
['62684671', '20', '40118', '685', '1', '69990'],
['62684671', '20', '40118', '685', '-1', '-69990'],
['61664713', '59', '40118', '335', '1', '17990'],
['61664713', '59', '40118', '335', '-1', '-17990'],
['61684613', '59', '40118', '335', '1', '12990'],
['68634752', '59', '40118', '410', '1', '8990'],
['60694698', '59', '40118', '620', '1', '3990'],
['60664659', '59', '40118', '620', '1', '3990'],
['60614487', '59', '40118', '878', '1', '5950'],
['68654655', '166', '40118', '60', '1', '5080'],
['69624033', '166', '40118', '80', '1', '18190'],
['60604100', '166', '40118', '80', '1', '13300'],
['68674560', '166', '40118', '170', '1', '5990']
])
select('JTable_22', 'rows:[3,4,5,6],columns:[3|DATE]')
## keystroke('JTable_22', 'Ctrl+D')
keystroke('JTable_22', 'Delete')
close()
if window('Line Delete confirmation '):
click('OptionPane.button')
close()
if frame('Table: - DTAR020_tst1.bin:0'):
select('JTable_22', 'rows:[],columns:[11 - 4|DATE]')
assert_content('JTable_22', [ ['63604808', '20', '40118', '170', '1', '4870'],
['69684558', '20', '40118', '280', '1', '19000'],
['69684558', '20', '40118', '280', '-1', '-19000'],
['61664713', '59', '40118', '335', '-1', '-17990'],
['61684613', '59', '40118', '335', '1', '12990'],
['68634752', '59', '40118', '410', '1', '8990'],
['60694698', '59', '40118', '620', '1', '3990'],
['60664659', '59', '40118', '620', '1', '3990'],
['60614487', '59', '40118', '878', '1', '5950'],
['68654655', '166', '40118', '60', '1', '5080'],
['69624033', '166', '40118', '80', '1', '18190'],
['60604100', '166', '40118', '80', '1', '13300'],
['68674560', '166', '40118', '170', '1', '5990']
])
close()
pass
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'zzzCsvTest5.csv')
commonBits.setRecordLayout(select, 'zzzCsvTest5')
click('Edit1')
select('Table', 'cell:3|Field 3,0(33)')
assert_p(
'Table', 'Content',
'[[111, 22, 33, 44, 55, 66, 77], [1, 2;3;4:1;2;3;4:4;5;6, 333, 2;3;4;5;6, 555, 1:2:3, 777], [111, 22, 33, 44, 55, 66, 77], [1, 2;3;4:1;2;3;4:4;5;6, 333, 2;3;4;5;6, 555, 1:2:3, 777]]'
)
select('Table', 'cell:5|Field 5,0(55)')
assert_p('Table', 'Text', '55', '5|Field 5,0')
select('Table', 'cell:5|Field 5,0(55)')
rightclick('Table', '1|Field 1,0')
select_menu('Edit Record')
## select('Table1', 'cell:5|Field 5,0(55)')
select('Table', 'cell:Text,0(111)')
assert_p('Table', 'Text', 'cell:Text,0(111)')
select('Table', 'cell:Text,2(33)')
#assert_p('Table', 'Content', '[[Field 1, 1, , 111, 111], [Array 1 (; and :), 2, , 22, 22], [Field 3, 3, , 33, 33], [Array 2 (;), 4, , 44, 44], [Field 5, 5, , 55, 55], [Array 3 (:), 6, , 66, 66], [Field 7, 7, , 77, 77]]')
select('Table', 'cell:Text,2(33)')
click('TextArea')
click('TextArea')
assert_p('TextArea', 'Text', '111|22|33|44|55|66|77')
click('Right')
select('Table', 'cell:Text,1(2;3;4:1;2;3;4:4;5;6)')
assert_p('Table', 'Text', '2;3;4:1;2;3;4:4;5;6', 'Text,1')
select('Table', 'cell:Text,2(333)')
#assert_p('Table', 'Content', '[[Field 1, 1, , 1, 1], [Array 1 (; and :), 2, , 2;3;4:1;2;3;4:4;5;6, 2;3;4:1;2;3;4:4;5;6], [Field 3, 3, , 333, 333], [Array 2 (;), 4, , 2;3;4;5;6, 2;3;4;5;6], [Field 5, 5, , 555, 555], [Array 3 (:), 6, , 1:2:3, 1:2:3], [Field 7, 7, , 777, 777]]')
select('Table', 'cell:Text,2(333)')
click('TextArea')
assert_p('TextArea', 'Text',
'1|2;3;4:1;2;3;4:4;5;6|333|2;3;4;5;6|555|1:2:3|777')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('LayoutCombo', 'Full Line')
select('Table', 'cell:Full Line,0(111|22|33|44|55|66|77)')
assert_p('Table', 'Text', '111|22|33|44|55|66|77', 'Full Line,0')
select(
'Table',
'cell:Full Line,1(1|2;3;4:1;2;3;4:4;5;6|333|2;3;4;5;6|555|1:2:3|777)'
)
assert_p(
'Table', 'Content',
'[[111|22|33|44|55|66|77], [1|2;3;4:1;2;3;4:4;5;6|333|2;3;4;5;6|555|1:2:3|777], [111|22|33|44|55|66|77], [1|2;3;4:1;2;3;4:4;5;6|333|2;3;4;5;6|555|1:2:3|777]]'
)
select(
'Table',
'cell:Full Line,1(1|2;3;4:1;2;3;4:4;5;6|333|2;3;4;5;6|555|1:2:3|777)'
)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select(
'FileChooser',
commonBits.sampleDir() + 'Ams_LocDownload_20041228_Extract2.txt')
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
doubleclick('BaseDisplay$HeaderToolTips', '10 - 35|Loc Name')
select('Table', 'cell:10 - 35|Loc Name,2(Blacktown)')
assert_p(
'Table', 'Content',
'[[TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5138, ST, Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, A], [TAR, 5096, ST, Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, A], [TAR, 5062, ST, Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, A], [TAR, 5002, ST, Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, NSW, A], [TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [TAR, 5030, ST, Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, A], [TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [TAR, 5054, ST, Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, A], [TAR, 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, NSW, A], [TAR, 5146, ST, Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 0830, NT, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, A], [TAR, 5141, ST, The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, A], [TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A]]'
)
select('Table', 'cell:10 - 35|Loc Name,3(Cairns Central)')
assert_p('Table', 'RowCount', '17')
select('Table', 'cell:10 - 35|Loc Name,3(Cairns Central)')
rightclick('Table', '10 - 35|Loc Name,1')
select_menu('Sort')
## select('Table1', 'cell:10 - 35|Loc Name,3(Cairns Central)')
## select('List', 'ams Store')
select('Table', 'Loc Type', commonBits.fl('Field') + ',0')
select('Table', 'Loc Name', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(Loc Name)')
commonBits.sort(click)
select('Table', 'cell:10 - 35|Loc Name,2(Hendra DC)')
#click('ToolTip', 35, 15)
select('Table', 'cell:10 - 35|Loc Name,3(Huntingwood DC)')
assert_p(
'Table', 'Content',
'[[TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A], [TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [TAR, 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, NSW, A], [TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5138, ST, Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, A], [TAR, 5096, ST, Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, A], [TAR, 5062, ST, Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, A], [TAR, 5002, ST, Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, NSW, A], [TAR, 5030, ST, Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, A], [TAR, 5054, ST, Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, A], [TAR, 5146, ST, Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 0830, NT, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, A], [TAR, 5141, ST, The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, A]]'
)
select('Table', 'cell:10 - 35|Loc Name,6(Blacktown)')
assert_p('Table', 'RowCount', '17')
select('Table', 'cell:10 - 35|Loc Name,6(Blacktown)')
select_menu(commonBits.fl('Data') + '>>' + commonBits.fl('Sort'))
## select('Table1', 'cell:10 - 35|Loc Name,6(Blacktown)')
## select('List', 'ams Store')
select('Table', 'cell:' + commonBits.fl('Field') + ',0(Loc State)')
click('ScrollPane$ScrollBar', 10, 102)
select('Table', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(Loc Nbr)')
commonBits.sort(click)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
if window(
commonBits.fl('Save Changes to file: ' +
commonBits.sampleDir() +
'Ams_LocDownload_20041228_Extract2.txt')):
click('No')
close()
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'utf8_ams Store')
click('Edit1')
select(
'Table',
'rows:[0,1,2,3,4,5,6,7],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type,10 - 35|Loc Name]'
)
select_menu('View>>Column View #{Selected Records#}')
## select('Table2', 'rows:[0,1,2,3,4,5,6,7],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type,10 - 35|Loc Name]')
select('Table', 'cell:Row 1,3(DC - Taras Ave)')
assert_p('Table', 'Text', 'DC', 'Row 1,2')
select('Table', 'cell:Row 2,3(VIC West Ad Support)')
assert_p('Table', 'Text', 'VIC West Ad Support', 'Row 2,3')
select('Table', 'cell:Row 3,3(NSW North Sydney Ad Support)')
assert_p('Table', 'Text', 'VIC West Ad Support', 'Row 2,3')
select('Table', 'cell:Row 2,5(Lot 2 Little Boundary Rd)')
assert_p('Table', 'Text', 'Lot 2 Little Boundary Rd', 'Row 2,5')
select('Table', 'cell:Row 1,5(30-68 Taras Ave)')
## assert_p('Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW], [A, A, A, A, A, A, A, A]]')
if commonBits.isMissingCol():
## assert_p('Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW]]')
assert_p(
'Table', 'Content',
'[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW]]'
)
assert_p(
'Table', 'Content',
'[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW], [A, A, A, A, A, A, A, A]]'
)
else:
assert_p(
'Table', 'Content',
'[[TAR, TAR, TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019, 5033, 5035], [DC, DC, DC, DC, ST, ST, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith, Blacktown, Rockdale], [, , , , Bankstown, Penrith, Marayong, Building B, Portside DC], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street, Dock 2, 11 Melissa Place, 2-8 Mc Pherson Street], [Altona North, Laverton, , , Condell Park, Penrith, Marayong, Botany], [3025, 3028, , , 2200, 2750, 2148, 2019], [VIC, VIC, , , NSW, NSW, NSW, NSW], [A, A, A, A, A, A, A, A]]'
)
select('Table', 'cell:Row 5,5(Unit 2, 39-41 Allingham Street)')
assert_p('Table', 'Text', '58 Leland Street', 'Row 6,5')
select('Table', 'cell:Row 6,5(58 Leland Street)')
assert_p('Table', 'Text', 'Penrith', 'Row 6,6')
select('Table', 'cell:Row 6,5(58 Leland Street)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select(
'Table',
'rows:[0,1,2,3,4,5,6,7],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type,10 - 35|Loc Name]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'utf8_ams Store')
click('Edit1')
select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)')
rightclick('Table', '10 - 35|Loc Name,1')
select_menu('Edit Record')
## select('Table1', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)')
select('Table', 'cell:Data,3(VIC West Ad Support)')
assert_p('Table', 'Text', 'VIC West Ad Support', 'Data,3')
select('Table', 'cell:Data,3(VIC West Ad Support)')
assert_p('Table', 'Text', 'cell:Data,3(VIC West Ad Support)')
select('Table', 'cell:Data,3(VIC West Ad Support)')
if commonBits.isMissingCol():
assert_p('Table', 'RowCount', '9')
else:
assert_p('Table', 'RowCount', '10')
select('Table', 'cell:Data,3(VIC West Ad Support)')
select('Table', 'cell:Data,4()')
select('Table', 'cell:Data,4()')
click('Right')
click('Left')
click('Left')
select('Table', 'cell:Data,2(DC)')
if commonBits.isMissingCol():
assert_p('Table', 'RowCount', '9')
else:
assert_p('Table', 'RowCount', '10')
select('Table', 'cell:Data,2(DC)')
assert_p('Table', 'ColumnCount', '5')
select('Table', 'cell:Data,2(DC)')
click('RightM')
select('Table', 'cell:Data,3(Kalgoorlie (not yet open))')
assert_p('Table', 'Text', 'Kalgoorlie (not yet open)', 'Data,3')
select('Table', 'cell:Data,3(Kalgoorlie (not yet open))')
click('LeftM')
select('Table', 'cell:Data,3(DC - Taras Ave)')
assert_p('Table', 'Text', 'DC - Taras Ave', 'Data,3')
select('Table', 'cell:Data,3(DC - Taras Ave)')
assert_p('Table', 'Text', 'cell:Data,3(DC - Taras Ave)')
select('Table', 'cell:Data,3(DC - Taras Ave)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'zzAms_LocDownload_tab.csv')
commonBits.setRecordLayout(select, 'Generic CSV - enter details')
commonBits.doEdit(click)
if window(''):
select('CheckBox', 'false')
click(commonBits.fl('Go'))
close()
select('Table', 'cell:4|D,0(Loc_Name)')
assert_p('Table', 'Text', 'WA Ad Support', '4|D,4')
select('Table', 'cell:6|F,0(Loc_Addr_Ln2)')
assert_p('Table', 'Text', 'Loc_Addr_Ln2', '6|F,0')
select('Table', 'cell:6|F,9(Cnr. Urunga Pde & The Kingsway)')
assert_p('Table', 'Text', 'Cnr. Urunga Pde & The Kingsway', '6|F,9')
select('Table', 'cell:4|D,6(Penrith)')
assert_p('Table', 'Text', 'Penrith', '4|D,6')
select('Table', 'rows:[0,1,2],columns:[4|D]')
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Column View #{Selected Records#}'))
### select('Table2', 'rows:[0,1,2],columns:[1|A,2|B]')
select('Table', 'cell:Row 1,2(Loc_Type)')
assert_p('Table', 'Text', 'Altona North', 'Row 2,6')
select('Table', 'cell:Row 1,6(Loc_Addr_Ln3)')
assert_p('Table', 'Text', 'Loc_Postcode', 'Row 1,7')
select('Table', 'cell:Row 2,5(30-68 Taras Ave)')
assert_p('Table', 'Text', '30-68 Taras Ave', 'Row 2,5')
select('Table', 'cell:Row 2,5(30-68 Taras Ave)')
assert_p(
'Table', 'Content',
'[[Brand_Id, TAR, TAR], [Loc_Nbr, 5839, 5850], [Loc_Type, DC, DC], [Loc_Name, DC - Taras Ave, VIC West Ad Support], [Loc_Addr_Ln1, , ], [Loc_Addr_Ln2, 30-68 Taras Ave, Lot 2 Little Boundary Rd], [Loc_Addr_Ln3, Altona North, Laverton], [Loc_Postcode, 3025, 3028], [Loc_State, VIC, VIC], [Loc_Actv_Ind, A, A], [, , ]]'
)
select('Table', 'cell:Row 1,7(Loc_Postcode)')
assert_p('Table', 'RowCount', '11')
select('Table', 'cell:Row 1,7(Loc_Postcode)')
assert_p('Table', 'ColumnCount', '3')
select('Table', 'cell:Row 1,3(Loc_Name)')
select('Table1', 'cell:' + commonBits.fl('Field') + ',3(D)')
assert_p('Table1', 'Text', 'D', commonBits.fl('Field') + ',3')
select('Table1', 'cell:' + commonBits.fl('Field') + ',3(D)')
assert_p(
'Table1', 'Content',
'[[A, 1, ], [B, 2, ], [C, 3, ], [D, 4, ], [E, 5, ], [F, 6, ], [G, 7, ], [H, 8, ], [I, 9, ], [J, 10, ], [K, 11, ]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'utf8a_Ams_PODownload_20041231.txt')
commonBits.setRecordLayout(select, 'utf8_ams PO Download')
click(commonBits.fl('Edit') + '1')
select_menu(
commonBits.fl('View') + '>>' + commonBits.fl('Record Based Tree'))
select('Table', 'ams PO Download: Header',
commonBits.fl('Parent Record') + ',0')
select('Table', 'ams PO Download: Detail',
commonBits.fl('Parent Record') + ',2')
## select('Table', '1', commonBits.fl('Parent Record') + ',0')
## select('Table', '0', commonBits.fl('Parent Record') + ',2')
select('Table', 'cell:' + commonBits.fl('Parent Record') + ',2(0)')
click(commonBits.fl('Build'))
select('LayoutCombo', 'ams PO Download: Detail')
#####
select('JTreeTable', 'cell:Pack Qty,3(45352.0000)')
assert_p('JTreeTable', 'Text', 'cell:Pack Qty,3(45352.0000)')
select('JTreeTable', 'cell:Pack Cost,4(5341294987)')
## assert_p('JTreeTable', 'Content', '[[, , H1, 45349.0000, 6060286225, 40909, , 0, LADIES KNIC, FT, ], [, , H1, 45350.0000, 62280000002, 22227040909, , 0, LADIES KNIC, FT, ], [, , H1, 45351.0000, 62280000002, 22243040909, , 0, LADIES KNIC, FT, ], [, , H1, 45352.0000, 5341294915, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45353.0000, 5341294987, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45354.0000, 5341295139, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45355.0000, 5341303662, 41110, , 0, YOUTH SHOEC, FT, ], [, , H1, 45356.0000, 5341304100, 41111, , 0, YOUTH SHOEC, FT, ]]')
assert_p(
'JTreeTable', 'Content',
'[[, , H1, 45349.0000, 606028.6225, 40909, , 0, LADIES KNIC, FT, ], [, , H1, 45350.0000, 6228000.0002, 22227040909, , 0, LADIES KNIC, FT, ], [, , H1, 45351.0000, 6228000.0002, 22243040909, , 0, LADIES KNIC, FT, ], [, , H1, 45352.0000, 534129.4915, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45353.0000, 534129.4987, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45354.0000, 534129.5139, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45355.0000, 534130.3662, 41110, , 0, YOUTH SHOEC, FT, ], [, , H1, 45356.0000, 534130.4100, 41111, , 0, YOUTH SHOEC, FT, ]]'
)
select('JTreeTable', 'cell:Pack Cost,3(5341294915)')
assert_p('JTreeTable', 'Text', '534129.4987', 'Pack Cost,4')
select('JTreeTable', 'cell:Pack Cost,5(5341295139)')
assert_p('JTreeTable', 'RowCount', '8')
select('JTreeTable', 'cell:Pack Qty,2(45351.0000)')
rightclick('JTreeTable', 'Pack Qty,2')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:Pack Qty,3(6.0000)')
assert_p('JTreeTable', 'Text', '6.0000', 'Pack Qty,3')
select('JTreeTable', 'cell:Pack Qty,4(3.0000)')
assert_p('JTreeTable', 'RowCount', '12')
select('JTreeTable', 'cell:Pack Qty,5(44.0000)')
## assert_p('JTreeTable', 'Content', '[[, , H1, 45349.0000, 606028.6225, 40909, , 0, LADIES KNIC, FT, ], [, , H1, 45350.0000, 6228000.0002, 22227040909, , 0, LADIES KNIC, FT, ], [, , H1, 45351.0000, 6228000.0002, 22243040909, , 0, LADIES KNIC, FT, ], [, , D1, 6.0000, 148.3200, 0, , 45614531, 2075352, 45614531, DONKEY 24-006607 SHWL WRAP CARD], [, , D1, 3.0000, 148.3200, 0, , 45614944, 2075353, 45614944, MILK 24-006607 SHWL WRAP CARD], [, , D1, 44.0000, 148.3200, 0, , 45615071, 2075354, 45615071, M.ROSE 24-006607 SHWL WRAP CARD], [, , D1, 3.0000, 148.3200, 0, , 45615156, 2075355, 35615156, AQUA 24-006607 SHWL WRAP CARD], [, , H1, 45352.0000, 5341294915, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45353.0000, 5341294987, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45354.0000, 5341295139, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45355.0000, 5341303662, 41110, , 0, YOUTH SHOEC, FT, ], [, , H1, 45356.0000, 5341304100, 41111, , 0, YOUTH SHOEC, FT, ]]')
assert_p(
'JTreeTable', 'Content',
'[[, , H1, 45349.0000, 606028.6225, 40909, , 0, LADIES KNIC, FT, ], [, , H1, 45350.0000, 6228000.0002, 22227040909, , 0, LADIES KNIC, FT, ], [, , H1, 45351.0000, 6228000.0002, 22243040909, , 0, LADIES KNIC, FT, ], [, , D1, 6.0000, 148.3200, 0, , 45614531, 2075352, 45614531, DONKEY 24-006607 SHWL WRAP CARD], [, , D1, 3.0000, 148.3200, 0, , 45614944, 2075353, 45614944, MILK 24-006607 SHWL WRAP CARD], [, , D1, 44.0000, 148.3200, 0, , 45615071, 2075354, 45615071, M.ROSE 24-006607 SHWL WRAP CARD], [, , D1, 3.0000, 148.3200, 0, , 45615156, 2075355, 35615156, AQUA 24-006607 SHWL WRAP CARD], [, , H1, 45352.0000, 534129.4915, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45353.0000, 534129.4987, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45354.0000, 534129.5139, 41013, , 0, WOMENS SHOC, FT, ], [, , H1, 45355.0000, 534130.3662, 41110, , 0, YOUTH SHOEC, FT, ], [, , H1, 45356.0000, 534130.4100, 41111, , 0, YOUTH SHOEC, FT, ]]'
)
select('JTreeTable', 'cell:Pack Qty,5(44.0000)')
rightclick('JTreeTable', 'Pack Qty,5')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:Pack Qty,6(50090.0000)')
assert_p('JTreeTable', 'Text', '50440.0000', 'Pack Qty,7')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_20'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'DTAR1000_Store_file_std.bin')
commonBits.setRecordLayout(select, 'DTAR1000 VB')
click('Edit1')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
## select('FileChooser', '/C:/Program Files/RecordEdit/HSQLDB/SampleFiles/DTAR020.bin')
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
commonBits.setRecordLayout(select, 'DTAR020')
commonBits.doEdit(click)
if commonBits.isVersion81():
click('Export')
else:
click('SaveAs1')
select('TabbedPane', 'Xml')
# select('ComboBox1', 'XML')
## select('FileChooser', '/C:/Program Files/RecordEdit/HSQLDB/SampleFiles/x1DTAR020.bin.xml')
select('FileChooser', commonBits.sampleDir() + 'x1DTAR020.bin.xml')
click('Save File')
click('Open')
## select('FileChooser', '/C:/Program Files/RecordEdit/HSQLDB/SampleFiles/x1DTAR020.bin.xml')
select('FileChooser', commonBits.sampleDir() + 'x1DTAR020.bin.xml')
commonBits.doEdit(click)
select('JTreeTable', 'cell:Tree,1(null)')
rightclick('JTreeTable', 'Tree,1')
select_menu('Expand Tree')
## select('JTreeTable', 'cell:Xml~Prefix,3(null)')
assert_p('JTreeTable', 'RowCount', '381')
select('JTreeTable', 'cell:Xml~Prefix,2(null)')
rightclick('JTreeTable', 'Xml~Prefix,2')
select_menu('Edit Record')
##select('JTreeTable', 'cell:Xml~Prefix,2(null)')
select('Table', 'cell:Data,3(69684558)')
assert_p('Table', 'Text', '40118', 'Data,5')
select('Table', 'cell:Data,5(40118)')
assert_p('Table', 'Content', '[[Xml~Name, 0, , DTAR020, DTAR020], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [KEYCODE-NO, 5, , 69684558, 69684558], [STORE-NO, 6, , 20, 20], [DATE, 7, , 40118, 40118], [DEPT-NO, 8, , 280, 280], [QTY-SOLD, 9, , 1, 1], [SALE-PRICE, 10, , 19.00, 19.00], [Xml~End, 1, , True, True], [Following~Text, 2, , , ]]')
click('Right')
select('Table', 'cell:Data,5(40118)')
select('Table', 'cell:Data,5(40118)')
assert_p('Table', 'Content', '[[Xml~Name, 0, , DTAR020, DTAR020], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [KEYCODE-NO, 5, , 69684558, 69684558], [STORE-NO, 6, , 20, 20], [DATE, 7, , 40118, 40118], [DEPT-NO, 8, , 280, 280], [QTY-SOLD, 9, , -1, -1], [SALE-PRICE, 10, , -19.00, -19.00], [Xml~End, 1, , True, True], [Following~Text, 2, , , ]]')
select('Table', 'cell:Data,5(40118)')
click('Right')
select('Table', 'cell:Data,6(280)')
select('Table', 'cell:Data,6(280)')
assert_p('Table', 'Content', '[[Xml~Name, 0, , DTAR020, DTAR020], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [KEYCODE-NO, 5, , 69684558, 69684558], [STORE-NO, 6, , 20, 20], [DATE, 7, , 40118, 40118], [DEPT-NO, 8, , 280, 280], [QTY-SOLD, 9, , 1, 1], [SALE-PRICE, 10, , 5.01, 5.01], [Xml~End, 1, , True, True], [Following~Text, 2, , , ]]')
select('Table', 'cell:Data,6(280)')
click('Right')
select('Table', 'cell:Data,5(40118)')
select('Table', 'cell:Data,5(40118)')
assert_p('Table', 'Content', '[[Xml~Name, 0, , DTAR020, DTAR020], [Xml~Prefix, 3, , , ], [Xml~Namespace, 4, , , ], [KEYCODE-NO, 5, , 69694158, 69694158], [STORE-NO, 6, , 20, 20], [DATE, 7, , 40118, 40118], [DEPT-NO, 8, , 280, 280], [QTY-SOLD, 9, , 1, 1], [SALE-PRICE, 10, , 19.00, 19.00], [Xml~End, 1, , True, True], [Following~Text, 2, , , ]]')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'zzzCsvTest4.csv')
commonBits.setRecordLayout(select, 'zzzCsvTest4')
click(commonBits.fl('Edit') + '1')
select('Table', 'cell:1|Field 1,0(111)')
assert_p(
'Table', 'Content',
'[[111, 22, 33, 44, 55, 66, 77], [1, 2;3;4|1;2;3;4|4;5;6, 333, 2;3;4;5;6, 555, 1:2:3, 1|33|33|11], [111, 22, 33, 44, 55, 66, 1|2|1], [1, 2;3;4|1;2;3;4|4;5;6, 333, 2;3;4;5;6, 555, 1:2:3, 11|2|11]]'
)
select('Table', 'cell:3|Field 3,1(333)')
assert_p('Table', 'Text', '333', '3|Field 3,1')
select('Table', 'cell:3|Field 3,1(333)')
select('LayoutCombo', commonBits.fl('Full Line'))
#select('Table', 'cell:' + commonBits.fl('Full Line') + ',1(1"2;3;4|1;2;3;4|4;5;6"3332;3;4;5;65551:2:3"1|33|33|11")')
#assert_p('Table', 'Content', '[[111223344556677], [1"2;3;4|1;2;3;4|4;5;6"3332;3;4;5;65551:2:3"1|33|33|11"], [1112233445566"1|2|1"], [1"2;3;4|1;2;3;4|4;5;6"3332;3;4;5;65551:2:3"11|2|11"]]')
#select('Table', 'cell:' + commonBits.fl('Full Line') + ',3(1"2;3;4|1;2;3;4|4;5;6"3332;3;4;5;65551:2:3"11|2|11")')
#assert_p('Table', 'Text', '1"2;3;4|1;2;3;4|4;5;6"3332;3;4;5;65551:2:3"11|2|11"', 'Full Line,3')
select(
'Table', 'cell:' + commonBits.fl('Full Line') +
',3(1"2;3;4|1;2;3;4|4;5;6"3332;3;4;5;65551:2:3"11|2|11")')
select('LayoutCombo', 'zzzCsvTest4')
#select('Table', '')
rightclick('Table', '1|Field 1,0')
select_menu(commonBits.fl('Edit Record'))
select('Table', 'cell:' + commonBits.fl('Text') + ',0(111)')
assert_p('Table', 'Text', '111', commonBits.fl('Text') + ',0')
select('Table', 'cell:' + commonBits.fl('Text') + ',1(22)')
assert_p(
'Table', 'Content',
'[[Field 1, 1, , 111, 111], [Array 1 (; and |), 2, , 22, 22], [Field 3, 3, , 33, 33], [Array 2 (;), 4, , 44, 44], [Field 5, 5, , 55, 55], [Array 3 (:), 6, , 66, 66], [Array 4 (|), 7, , 77, 77]]'
)
select('Table', 'cell:' + commonBits.fl('Text') + ',1(22)')
click('Right')
select('Table',
'cell:' + commonBits.fl('Text') + ',1(2;3;4|1;2;3;4|4;5;6)')
assert_p('Table', 'Text', '1', commonBits.fl('Text') + ',0')
select('Table', 'cell:' + commonBits.fl('Text') + ',2(333)')
assert_p(
'Table', 'Content',
'[[Field 1, 1, , 1, 1], [Array 1 (; and |), 2, , 2;3;4|1;2;3;4|4;5;6, 2;3;4|1;2;3;4|4;5;6], [Field 3, 3, , 333, 333], [Array 2 (;), 4, , 2;3;4;5;6, 2;3;4;5;6], [Field 5, 5, , 555, 555], [Array 3 (:), 6, , 1:2:3, 1:2:3], [Array 4 (|), 7, , 1|33|33|11, 1|33|33|11]]'
)
select('Table', 'cell:' + commonBits.fl('Text') + ',2(333)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'zzzCsvTest4.csv')
commonBits.setRecordLayout(select, 'zzzCsvTest4')
click('Edit1')
select('Table', 'cell:2|Array 1 (; and |),0(22)')
rightclick('Table', '1|Field 1,0')
select_menu('Edit Record')
select('Table', 'cell:Data,0(111)')
assert_p('Table', 'Text', '111', 'Data,0')
select('Table', 'cell:Text,0(111)')
assert_p(
'Table', 'Content',
'[[Field 1, 1, , 111, 111], [Array 1 (; and |), 2, , 22, 22], [Field 3, 3, , 33, 33], [Array 2 (;), 4, , 44, 44], [Field 5, 5, , 55, 55], [Array 3 (:), 6, , 66, 66], [Array 4 (|), 7, , 77, 77]]'
)
select('Table', '11144', 'Data,0')
select('Table', 'cell:Text,0(11144)')
assert_p('Table', 'Text', '11144', 'Text,0')
doubleclick('TextArea')
click('TextArea')
rightclick('TextArea')
#assert_p('TextArea', 'Text', '11144223344556677')
select('Table', '111\'55', 'Data,0')
select('Table', 'cell:Text,0(111\'55)')
assert_p('Table', 'Text', '111\'55', 'Text,0')
click('Right')
select('Table', 'cell:Text,0(1)')
assert_p(
'Table', 'Content',
'[[Field 1, 1, , 1, 1], [Array 1 (; and |), 2, , 2;3;4|1;2;3;4|4;5;6, 2;3;4|1;2;3;4|4;5;6], [Field 3, 3, , 333, 333], [Array 2 (;), 4, , 2;3;4;5;6, 2;3;4;5;6], [Field 5, 5, , 555, 555], [Array 3 (:), 6, , 1:2:3, 1:2:3], [Array 4 (|), 7, , 1|33|33|11, 1|33|33|11]]'
)
select('Table', 'cell:Text,1(2;3;4|1;2;3;4|4;5;6)')
assert_p('Table', 'Text', '2;3;4|1;2;3;4|4;5;6', 'Text,1')
select('Table', 'cell:Text,2(333)')
doubleclick('TextArea')
click('TextArea')
#assert_p('TextArea', 'Text', '1"2;3;4|1;2;3;4|4;5;6"3332;3;4;5;65551:2:3"1|33|33|11"')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
if window('Save Changes to file: ' + commonBits.sampleDir() +
'zzzCsvTest4.csv'):
click('No')
close()
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare Menu')
click('*2')
click('Choose File')
if window('Open'):
select(commonBits.selectPane(),
'Ams_LocDownload_20041228_Extract.txt')
click('Open')
close()
commonBits.setRecordLayout(select, 'ams Store')
click('Right')
select('TabbedPane', '')
click('Choose File')
if window('Open'):
select(commonBits.selectPane(),
'Ams_LocDownload_20041228_Extract2.txt')
click('Open')
close()
commonBits.setRecordLayout(select, 'ams Store')
click('Right')
select('TabbedPane', '')
click('Right')
select('TabbedPane', '')
click('Compare')
select('Table', 'cell:Loc Name,11(Highpoint City)')
assert_p('Table', 'Text', 'St Marys', 'Loc Name,12')
select('Table', 'cell:Loc Name,14(Bass Hill)')
assert_p(
'Table', 'Content',
'[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 0830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]'
)
select('Table', 'cell:Loc Name,14(Bass Hill)')
click('All Included Lines')
select('Table', 'cell:Loc Addr Ln1,8(Marayong)')
assert_p(
'Table', 'Content',
'[[, , , , , , , , , , , , ], [, Inserted, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, , , , , , , , , , , , ], [, Inserted, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, Old, 1, TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 3, , , , , , , , , , ], [, Old, 2, TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [, New, 4, , , , , , , , , , ], [, Old, 3, TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 5, , , , , , , , , , ], [, Old, 4, TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [, New, 6, , 5096, , Canberra Civic, Target Canberra, Canberra City Centre, Akuna Ave, Canberra, 2601, ACT, ], [, Old, 5, TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [, New, 7, , 5012, , Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, ], [, Old, 6, TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [, New, 8, , 5030, , Epping, Epping Plaza Shopping Centre, Cnr. High & Cooper Streets, Epping, 3076, VIC, ], [, Old, 7, TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [, New, 9, , 5054, , Highpoint City, Laverton, Lot 2, Cnr Lt Boundry & Old Geelong Road, Laverton, 3028, VIC, ], [, Old, 8, TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [, New, 10, , 5062, , Castletown, Townsville, Cnr. Woolcock St. & Kings Road, Townsville, 4810, QLD, ], [, Old, 9, TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [, New, 11, , 5138, , Cairns Central, Cairns, Cnr. McLeod & Aplin Streets, Cairns, 4870, QLD, ], [, Old, 10, TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [, New, 12, , 5141, , The Willows, Thuringowa Central, Cnr Thuringowa Drive & Range Rd, Thuringowa Central, 4817, QLD, ], [, Old, 11, TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [, New, 13, , 5146, , Palmerston, Palmerston Shopping Centre, Temple Terrace, Palmerston, 0830, NT, ], [, Old, 12, TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [, New, 14, , 5002, , Coffs Harbour, Coffs Harbour, Cnr. Park Beach Road & Pacific Hwy, Coffs Harbour, 2450, , ], [, Old, 13, TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [, New, 15, , 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, , ], [, , , , , , , , , , , , ], [, Inserted, 16, TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [, , , , , , , , , , , , ], [, Inserted, 17, TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A]]'
)
select('Table', 'cell:Loc Addr Ln1,8(Marayong)')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_20'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'DTAR1000_Store_file_std.bin')
commonBits.setRecordLayout(select, 'xDTAR1000 VB')
click(commonBits.fl('Edit') + '1')
select('Table', 'rows:[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30],columns:[5 - 50|STORE-NAME]')
select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Table View #{Selected Records#}'))
## select('Table2', 'rows:[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30],columns:[5 - 50|STORE-NAME]')
assert_p('Table', 'Content', '[[3, 40, Q Mackay, N, Y, N, N, N, N], [4, 20, V Ballarat, N, Y, N, N, N, N], [5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [9, 50, S Centrepoint, N, Y, N, N, N, N], [10, 40, Q Earlville, N, Y, N, N, N, N], [11, 10, N Cessnock, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [15, 10, N Bankstown, N, Y, N, N, N, N], [16, 10, N Glendale, N, Y, N, N, N, N], [19, 10, N Penrith, N, Y, N, N, N, N], [20, 40, Q Indooroopilly, N, Y, N, N, N, N], [21, 50, S Tea Tree Plaza, N, Y, N, N, N, N], [23, 20, V Warnambool, N, Y, N, N, N, N], [24, 50, S Newton, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [26, 50, S Edwardstown, N, Y, N, N, N, N], [27, 40, Q Runaway Bay, N, Y, N, N, N, N], [28, 20, V Launceston, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N], [35, 10, N Rockdale, N, Y, N, N, N, N], [36, 60, W Fremantle, N, Y, N, N, N, N], [21, 10, N Miranda, N, Y, N, N, N, N], [38, 40, Q Maroochydore, N, Y, N, N, N, N], [39, 20, V Colac, N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:'))
select('Table', 'rows:[2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30],columns:[5 - 50|STORE-NAME]')
select('Table', 'rows:[2,3],columns:[5 - 50|STORE-NAME]')
click('Delete2')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:') + '1')
assert_p('Table', 'Content', '[[5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [9, 50, S Centrepoint, N, Y, N, N, N, N], [10, 40, Q Earlville, N, Y, N, N, N, N], [11, 10, N Cessnock, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [15, 10, N Bankstown, N, Y, N, N, N, N], [16, 10, N Glendale, N, Y, N, N, N, N], [19, 10, N Penrith, N, Y, N, N, N, N], [20, 40, Q Indooroopilly, N, Y, N, N, N, N], [21, 50, S Tea Tree Plaza, N, Y, N, N, N, N], [23, 20, V Warnambool, N, Y, N, N, N, N], [24, 50, S Newton, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [26, 50, S Edwardstown, N, Y, N, N, N, N], [27, 40, Q Runaway Bay, N, Y, N, N, N, N], [28, 20, V Launceston, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N], [35, 10, N Rockdale, N, Y, N, N, N, N], [36, 60, W Fremantle, N, Y, N, N, N, N], [21, 10, N Miranda, N, Y, N, N, N, N], [38, 40, Q Maroochydore, N, Y, N, N, N, N], [39, 20, V Colac, N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:'))
select('Table', 'rows:[6,7,8],columns:[5 - 50|STORE-NAME]')
click('Delete2')
assert_p('Table', 'Content', '[[1, 20, V Geelong, N, Y, N, N, N, N], [2, 40, Q Coffs Harbour, N, Y, N, N, N, N], [5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [15, 10, N Bankstown, N, Y, N, N, N, N], [16, 10, N Glendale, N, Y, N, N, N, N], [19, 10, N Penrith, N, Y, N, N, N, N], [20, 40, Q Indooroopilly, N, Y, N, N, N, N], [21, 50, S Tea Tree Plaza, N, Y, N, N, N, N], [23, 20, V Warnambool, N, Y, N, N, N, N], [24, 50, S Newton, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [26, 50, S Edwardstown, N, Y, N, N, N, N], [27, 40, Q Runaway Bay, N, Y, N, N, N, N], [28, 20, V Launceston, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N], [35, 10, N Rockdale, N, Y, N, N, N, N], [36, 60, W Fremantle, N, Y, N, N, N, N], [21, 10, N Miranda, N, Y, N, N, N, N], [38, 40, Q Maroochydore, N, Y, N, N, N, N], [39, 20, V Colac, N, Y, N, N, N, N], [40, 40, Q Tweed Heads, N, Y, N, N, N, N], [42, 20, V Reservoir, N, Y, N, N, N, N], [43, 60, W Morley, N, Y, N, N, N, N], [44, 50, S Mt Gambier, N, Y, N, N, N, N], [45, 60, W Carousel, N, Y, N, N, N, N], [46, 10, N Dubbo, N, Y, N, N, N, N], [47, 50, S Sefton Park, N, Y, N, N, N, N], [48, 40, Q Bundaberg, N, Y, N, N, N, N], [49, 40, Q Rockhampton, N, Y, N, N, N, N], [52, 10, N Eastwood, N, Y, N, N, N, N], [54, 20, V Highpoint City, N, Y, N, N, N, N], [55, 10, N Leichhardt, N, Y, N, N, N, N], [57, 60, W Victoria Park, N, Y, N, N, N, N], [58, 20, V Knox City, N, Y, N, N, N, N], [59, 40, Q Buranda, N, Y, N, N, N, N], [60, 10, N St Marys, N, Y, N, N, N, N], [61, 20, V Waverley Gardens, N, Y, N, N, N, N], [62, 40, Q Castletown, N, Y, N, N, N, N], [64, 20, V Hoppers Crossing, N, Y, N, N, N, N], [65, 60, W Innaloo, N, Y, N, N, N, N], [67, 20, V Morwell Mid Valley, N, Y, N, N, N, N], [68, 40, Q Mt Gravatt, N, Y, N, N, N, N], [69, 60, W Midland, N, Y, N, N, N, N], [70, 10, N Bass Hill, N, Y, N, N, N, N], [72, 60, W Geraldton, N, Y, N, N, N, N], [73, 40, Q Southport, N, Y, N, N, N, N], [74, 10, N Campbelltown, N, Y, N, N, N, N], [75, 20, V Sale, N, Y, N, N, N, N], [76, 60, W Bull Creek, N, Y, N, N, N, N], [77, 50, S Elizabeth, N, Y, N, N, N, N], [78, 10, N Warringah Mall, N, Y, N, N, N, N], [79, 60, W Stirling, N, Y, N, N, N, N], [80, 20, V Sunshine, N, Y, N, N, N, N], [81, 10, N Ashfield, N, Y, N, N, N, N], [82, 20, V Box Hill, N, Y, N, N, N, N], [83, 40, Q Springwood, N, Y, N, N, N, N], [84, 40, Q Brookside, N, Y, N, N, N, N], [85, 10, N Roselands, N, Y, N, N, N, N], [86, 20, V Southland, N, Y, N, N, N, N], [87, 20, V Chadstone, N, Y, N, N, N, N], [88, 20, V Templestowe, N, Y, N, N, N, N], [89, 10, N Erina, N, Y, N, N, N, N], [90, 10, N Carlingford Court, N, Y, N, N, N, N], [91, 10, N Chatswood, N, Y, N, N, N, N], [92, 20, V Malvern, N, Y, N, N, N, N], [93, 10, N Liverpool, N, Y, N, N, N, N], [94, 60, W Whitford City, N, Y, N, N, N, N], [95, 10, N Eastgarden, N, Y, N, N, N, N], [96, 10, N Canberra Civic, N, Y, N, N, N, N], [97, 20, V Fountain Gate, N, Y, N, N, N, N], [98, 20, V Frankston, N, Y, N, N, N, N], [99, 20, V Glen Waverley, N, Y, N, N, N, N], [100, 20, V Waurn Ponds, N, Y, N, N, N, N], [125, 10, N Mt Druitt, N, Y, N, N, N, N], [126, 40, Q Robina, N, Y, N, N, N, N], [127, 50, S Marion, N, Y, N, N, N, N], [128, 60, W Rockingham, N, Y, N, N, N, N], [129, 10, N Macquarie, N, Y, N, N, N, N], [131, 20, V Melbourne City, N, Y, N, N, N, N], [132, 20, V Glenorchy, N, Y, N, N, N, N], [133, 40, Q Browns Plains, N, Y, N, N, N, N], [134, 50, S Reynella, N, Y, N, N, N, N], [135, 40, Q Capalaba, N, Y, N, N, N, N], [136, 10, N Charlestown, N, Y, N, N, N, N], [137, 20, V Dandenong, N, Y, N, N, N, N], [138, 40, Q Cairns Central, N, Y, N, N, N, N], [139, 40, Q Toowoomba, N, Y, N, N, N, N], [140, 40, Q Pacific Fair, N, Y, N, N, N, N], [141, 40, Q The Willows, N, Y, N, N, N, N], [142, 50, S Hollywood Plaza, N, Y, N, N, N, N], [143, 40, Q Hervey Bay, N, Y, N, N, N, N], [144, 10, N Parramatta, N, Y, N, N, N, N], [145, 10, N Port Macquarie, N, Y, N, N, N, N], [146, 40, Q Palmerston, N, Y, N, N, N, N], [149, 20, V Broadmeadows, N, Y, N, N, N, N], [150, 10, N Cowra, N, Y, N, N, N, N], [151, 60, W Perth, N, Y, N, N, N, N], [152, 20, V Mornington, N, Y, N, N, N, N], [153, 20, V Pakenham, N, Y, N, N, N, N], [154, 10, N Shellharbour, N, Y, N, N, N, N], [155, 40, Q Redbank, N, Y, N, N, N, N], [156, 40, Q Morayfield, N, Y, N, N, N, N], [157, 20, V Chirnside Park, N, Y, N, N, N, N], [158, 20, V Brimbank Central, N, Y, N, N, N, N], [159, 50, S Whyalla, N, Y, N, N, N, N], [160, 20, V Watergardens, N, Y, N, N, N, N], [161, 20, V Hobart, N, Y, N, N, N, N], [162, 10, N Tuggeranong, N, Y, N, N, N, N], [163, 10, N Queanbeyan, N, Y, N, N, N, N], [164, 10, N Tuggerah, N, Y, N, N, N, N], [165, 10, N Hurstville, N, Y, N, N, N, N], [166, 40, Q Chermside, N, Y, N, N, N, N], [167, 40, Q Northlakes, N, Y, N, N, N, N], [168, 20, V Airport West, N, Y, N, N, N, N], [169, 10, N Hornsby, N, Y, N, N, N, N], [170, 10, N Bondi, N, Y, N, N, N, N], [171, 10, N Burwood, N, Y, N, N, N, N], [173, 60, W Bunbury, N, Y, N, N, N, N], [174, 40, Q Carindale, N, Y, N, N, N, N], [175, 10, N Tamworth, N, Y, N, N, N, N], [177, 10, N Castle Hill, N, Y, N, N, N, N], [178, 10, N Blacktown, N, Y, N, N, N, N], [179, 20, V Greensborough, N, Y, N, N, N, N], [180, 60, W Joondalup, N, Y, N, N, N, N], [183, 20, V Swan Hill, N, Y, N, N, N, N], [184, 40, Q Brisbane CBD, N, Y, N, N, N, N], [186, 20, B Narre Warren (Closed), N, Y, N, N, N, N], [188, 10, N Macarthur Square, N, Y, N, N, N, N], [189, 20, B Northland Baby Target, N, Y, N, N, N, N], [191, 50, B Golden Grove, N, Y, N, N, N, N], [192, 10, N Wetherill Park, N, Y, N, N, N, N], [193, 60, W Kalgoorlie, N, Y, N, N, N, N], [194, 50, S Mildura, N, Y, N, N, N, N], [195, 40, Q Bribie Island, N, Y, N, N, N, N], [196, 60, W Meadow Springs, N, Y, N, N, N, N], [197, 50, S Unley, N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:') + '1')
assert_p('Table', 'Content', '[[5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [15, 10, N Bankstown, N, Y, N, N, N, N], [16, 10, N Glendale, N, Y, N, N, N, N], [19, 10, N Penrith, N, Y, N, N, N, N], [20, 40, Q Indooroopilly, N, Y, N, N, N, N], [21, 50, S Tea Tree Plaza, N, Y, N, N, N, N], [23, 20, V Warnambool, N, Y, N, N, N, N], [24, 50, S Newton, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [26, 50, S Edwardstown, N, Y, N, N, N, N], [27, 40, Q Runaway Bay, N, Y, N, N, N, N], [28, 20, V Launceston, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N], [35, 10, N Rockdale, N, Y, N, N, N, N], [36, 60, W Fremantle, N, Y, N, N, N, N], [21, 10, N Miranda, N, Y, N, N, N, N], [38, 40, Q Maroochydore, N, Y, N, N, N, N], [39, 20, V Colac, N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:'))
select('Table', 'rows:[9,10,11],columns:[5 - 50|STORE-NAME]')
click('Delete2')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:') + '1')
assert_p('Table', 'Content', '[[5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [15, 10, N Bankstown, N, Y, N, N, N, N], [16, 10, N Glendale, N, Y, N, N, N, N], [23, 20, V Warnambool, N, Y, N, N, N, N], [24, 50, S Newton, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [26, 50, S Edwardstown, N, Y, N, N, N, N], [27, 40, Q Runaway Bay, N, Y, N, N, N, N], [28, 20, V Launceston, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N], [35, 10, N Rockdale, N, Y, N, N, N, N], [36, 60, W Fremantle, N, Y, N, N, N, N], [21, 10, N Miranda, N, Y, N, N, N, N], [38, 40, Q Maroochydore, N, Y, N, N, N, N], [39, 20, V Colac, N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:'))
select('Table', 'rows:[12,13,14],columns:[5 - 50|STORE-NAME]')
click('Delete2')
assert_p('Table', 'Content', '[[1, 20, V Geelong, N, Y, N, N, N, N], [2, 40, Q Coffs Harbour, N, Y, N, N, N, N], [5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [15, 10, N Bankstown, N, Y, N, N, N, N], [16, 10, N Glendale, N, Y, N, N, N, N], [23, 20, V Warnambool, N, Y, N, N, N, N], [24, 50, S Newton, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N], [35, 10, N Rockdale, N, Y, N, N, N, N], [36, 60, W Fremantle, N, Y, N, N, N, N], [21, 10, N Miranda, N, Y, N, N, N, N], [38, 40, Q Maroochydore, N, Y, N, N, N, N], [39, 20, V Colac, N, Y, N, N, N, N], [40, 40, Q Tweed Heads, N, Y, N, N, N, N], [42, 20, V Reservoir, N, Y, N, N, N, N], [43, 60, W Morley, N, Y, N, N, N, N], [44, 50, S Mt Gambier, N, Y, N, N, N, N], [45, 60, W Carousel, N, Y, N, N, N, N], [46, 10, N Dubbo, N, Y, N, N, N, N], [47, 50, S Sefton Park, N, Y, N, N, N, N], [48, 40, Q Bundaberg, N, Y, N, N, N, N], [49, 40, Q Rockhampton, N, Y, N, N, N, N], [52, 10, N Eastwood, N, Y, N, N, N, N], [54, 20, V Highpoint City, N, Y, N, N, N, N], [55, 10, N Leichhardt, N, Y, N, N, N, N], [57, 60, W Victoria Park, N, Y, N, N, N, N], [58, 20, V Knox City, N, Y, N, N, N, N], [59, 40, Q Buranda, N, Y, N, N, N, N], [60, 10, N St Marys, N, Y, N, N, N, N], [61, 20, V Waverley Gardens, N, Y, N, N, N, N], [62, 40, Q Castletown, N, Y, N, N, N, N], [64, 20, V Hoppers Crossing, N, Y, N, N, N, N], [65, 60, W Innaloo, N, Y, N, N, N, N], [67, 20, V Morwell Mid Valley, N, Y, N, N, N, N], [68, 40, Q Mt Gravatt, N, Y, N, N, N, N], [69, 60, W Midland, N, Y, N, N, N, N], [70, 10, N Bass Hill, N, Y, N, N, N, N], [72, 60, W Geraldton, N, Y, N, N, N, N], [73, 40, Q Southport, N, Y, N, N, N, N], [74, 10, N Campbelltown, N, Y, N, N, N, N], [75, 20, V Sale, N, Y, N, N, N, N], [76, 60, W Bull Creek, N, Y, N, N, N, N], [77, 50, S Elizabeth, N, Y, N, N, N, N], [78, 10, N Warringah Mall, N, Y, N, N, N, N], [79, 60, W Stirling, N, Y, N, N, N, N], [80, 20, V Sunshine, N, Y, N, N, N, N], [81, 10, N Ashfield, N, Y, N, N, N, N], [82, 20, V Box Hill, N, Y, N, N, N, N], [83, 40, Q Springwood, N, Y, N, N, N, N], [84, 40, Q Brookside, N, Y, N, N, N, N], [85, 10, N Roselands, N, Y, N, N, N, N], [86, 20, V Southland, N, Y, N, N, N, N], [87, 20, V Chadstone, N, Y, N, N, N, N], [88, 20, V Templestowe, N, Y, N, N, N, N], [89, 10, N Erina, N, Y, N, N, N, N], [90, 10, N Carlingford Court, N, Y, N, N, N, N], [91, 10, N Chatswood, N, Y, N, N, N, N], [92, 20, V Malvern, N, Y, N, N, N, N], [93, 10, N Liverpool, N, Y, N, N, N, N], [94, 60, W Whitford City, N, Y, N, N, N, N], [95, 10, N Eastgarden, N, Y, N, N, N, N], [96, 10, N Canberra Civic, N, Y, N, N, N, N], [97, 20, V Fountain Gate, N, Y, N, N, N, N], [98, 20, V Frankston, N, Y, N, N, N, N], [99, 20, V Glen Waverley, N, Y, N, N, N, N], [100, 20, V Waurn Ponds, N, Y, N, N, N, N], [125, 10, N Mt Druitt, N, Y, N, N, N, N], [126, 40, Q Robina, N, Y, N, N, N, N], [127, 50, S Marion, N, Y, N, N, N, N], [128, 60, W Rockingham, N, Y, N, N, N, N], [129, 10, N Macquarie, N, Y, N, N, N, N], [131, 20, V Melbourne City, N, Y, N, N, N, N], [132, 20, V Glenorchy, N, Y, N, N, N, N], [133, 40, Q Browns Plains, N, Y, N, N, N, N], [134, 50, S Reynella, N, Y, N, N, N, N], [135, 40, Q Capalaba, N, Y, N, N, N, N], [136, 10, N Charlestown, N, Y, N, N, N, N], [137, 20, V Dandenong, N, Y, N, N, N, N], [138, 40, Q Cairns Central, N, Y, N, N, N, N], [139, 40, Q Toowoomba, N, Y, N, N, N, N], [140, 40, Q Pacific Fair, N, Y, N, N, N, N], [141, 40, Q The Willows, N, Y, N, N, N, N], [142, 50, S Hollywood Plaza, N, Y, N, N, N, N], [143, 40, Q Hervey Bay, N, Y, N, N, N, N], [144, 10, N Parramatta, N, Y, N, N, N, N], [145, 10, N Port Macquarie, N, Y, N, N, N, N], [146, 40, Q Palmerston, N, Y, N, N, N, N], [149, 20, V Broadmeadows, N, Y, N, N, N, N], [150, 10, N Cowra, N, Y, N, N, N, N], [151, 60, W Perth, N, Y, N, N, N, N], [152, 20, V Mornington, N, Y, N, N, N, N], [153, 20, V Pakenham, N, Y, N, N, N, N], [154, 10, N Shellharbour, N, Y, N, N, N, N], [155, 40, Q Redbank, N, Y, N, N, N, N], [156, 40, Q Morayfield, N, Y, N, N, N, N], [157, 20, V Chirnside Park, N, Y, N, N, N, N], [158, 20, V Brimbank Central, N, Y, N, N, N, N], [159, 50, S Whyalla, N, Y, N, N, N, N], [160, 20, V Watergardens, N, Y, N, N, N, N], [161, 20, V Hobart, N, Y, N, N, N, N], [162, 10, N Tuggeranong, N, Y, N, N, N, N], [163, 10, N Queanbeyan, N, Y, N, N, N, N], [164, 10, N Tuggerah, N, Y, N, N, N, N], [165, 10, N Hurstville, N, Y, N, N, N, N], [166, 40, Q Chermside, N, Y, N, N, N, N], [167, 40, Q Northlakes, N, Y, N, N, N, N], [168, 20, V Airport West, N, Y, N, N, N, N], [169, 10, N Hornsby, N, Y, N, N, N, N], [170, 10, N Bondi, N, Y, N, N, N, N], [171, 10, N Burwood, N, Y, N, N, N, N], [173, 60, W Bunbury, N, Y, N, N, N, N], [174, 40, Q Carindale, N, Y, N, N, N, N], [175, 10, N Tamworth, N, Y, N, N, N, N], [177, 10, N Castle Hill, N, Y, N, N, N, N], [178, 10, N Blacktown, N, Y, N, N, N, N], [179, 20, V Greensborough, N, Y, N, N, N, N], [180, 60, W Joondalup, N, Y, N, N, N, N], [183, 20, V Swan Hill, N, Y, N, N, N, N], [184, 40, Q Brisbane CBD, N, Y, N, N, N, N], [186, 20, B Narre Warren (Closed), N, Y, N, N, N, N], [188, 10, N Macarthur Square, N, Y, N, N, N, N], [189, 20, B Northland Baby Target, N, Y, N, N, N, N], [191, 50, B Golden Grove, N, Y, N, N, N, N], [192, 10, N Wetherill Park, N, Y, N, N, N, N], [193, 60, W Kalgoorlie, N, Y, N, N, N, N], [194, 50, S Mildura, N, Y, N, N, N, N], [195, 40, Q Bribie Island, N, Y, N, N, N, N], [196, 60, W Meadow Springs, N, Y, N, N, N, N], [197, 50, S Unley, N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:'))
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:') + '1')
assert_p('Table', 'Content', '[[5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [15, 10, N Bankstown, N, Y, N, N, N, N], [16, 10, N Glendale, N, Y, N, N, N, N], [23, 20, V Warnambool, N, Y, N, N, N, N], [24, 50, S Newton, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N], [35, 10, N Rockdale, N, Y, N, N, N, N], [36, 60, W Fremantle, N, Y, N, N, N, N], [21, 10, N Miranda, N, Y, N, N, N, N], [38, 40, Q Maroochydore, N, Y, N, N, N, N], [39, 20, V Colac, N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:'))
select('Table', 'rows:[15,16,17,18,19],columns:[5 - 50|STORE-NAME]')
click('Delete2')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:') + '1')
assert_p('Table', 'Content', '[[5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [15, 10, N Bankstown, N, Y, N, N, N, N], [16, 10, N Glendale, N, Y, N, N, N, N], [23, 20, V Warnambool, N, Y, N, N, N, N], [24, 50, S Newton, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:'))
select('Table', 'rows:[7,8,9,10],columns:[5 - 50|STORE-NAME]')
click('Delete2')
assert_p('Table', 'Content', '[[1, 20, V Geelong, N, Y, N, N, N, N], [2, 40, Q Coffs Harbour, N, Y, N, N, N, N], [5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N], [40, 40, Q Tweed Heads, N, Y, N, N, N, N], [42, 20, V Reservoir, N, Y, N, N, N, N], [43, 60, W Morley, N, Y, N, N, N, N], [44, 50, S Mt Gambier, N, Y, N, N, N, N], [45, 60, W Carousel, N, Y, N, N, N, N], [46, 10, N Dubbo, N, Y, N, N, N, N], [47, 50, S Sefton Park, N, Y, N, N, N, N], [48, 40, Q Bundaberg, N, Y, N, N, N, N], [49, 40, Q Rockhampton, N, Y, N, N, N, N], [52, 10, N Eastwood, N, Y, N, N, N, N], [54, 20, V Highpoint City, N, Y, N, N, N, N], [55, 10, N Leichhardt, N, Y, N, N, N, N], [57, 60, W Victoria Park, N, Y, N, N, N, N], [58, 20, V Knox City, N, Y, N, N, N, N], [59, 40, Q Buranda, N, Y, N, N, N, N], [60, 10, N St Marys, N, Y, N, N, N, N], [61, 20, V Waverley Gardens, N, Y, N, N, N, N], [62, 40, Q Castletown, N, Y, N, N, N, N], [64, 20, V Hoppers Crossing, N, Y, N, N, N, N], [65, 60, W Innaloo, N, Y, N, N, N, N], [67, 20, V Morwell Mid Valley, N, Y, N, N, N, N], [68, 40, Q Mt Gravatt, N, Y, N, N, N, N], [69, 60, W Midland, N, Y, N, N, N, N], [70, 10, N Bass Hill, N, Y, N, N, N, N], [72, 60, W Geraldton, N, Y, N, N, N, N], [73, 40, Q Southport, N, Y, N, N, N, N], [74, 10, N Campbelltown, N, Y, N, N, N, N], [75, 20, V Sale, N, Y, N, N, N, N], [76, 60, W Bull Creek, N, Y, N, N, N, N], [77, 50, S Elizabeth, N, Y, N, N, N, N], [78, 10, N Warringah Mall, N, Y, N, N, N, N], [79, 60, W Stirling, N, Y, N, N, N, N], [80, 20, V Sunshine, N, Y, N, N, N, N], [81, 10, N Ashfield, N, Y, N, N, N, N], [82, 20, V Box Hill, N, Y, N, N, N, N], [83, 40, Q Springwood, N, Y, N, N, N, N], [84, 40, Q Brookside, N, Y, N, N, N, N], [85, 10, N Roselands, N, Y, N, N, N, N], [86, 20, V Southland, N, Y, N, N, N, N], [87, 20, V Chadstone, N, Y, N, N, N, N], [88, 20, V Templestowe, N, Y, N, N, N, N], [89, 10, N Erina, N, Y, N, N, N, N], [90, 10, N Carlingford Court, N, Y, N, N, N, N], [91, 10, N Chatswood, N, Y, N, N, N, N], [92, 20, V Malvern, N, Y, N, N, N, N], [93, 10, N Liverpool, N, Y, N, N, N, N], [94, 60, W Whitford City, N, Y, N, N, N, N], [95, 10, N Eastgarden, N, Y, N, N, N, N], [96, 10, N Canberra Civic, N, Y, N, N, N, N], [97, 20, V Fountain Gate, N, Y, N, N, N, N], [98, 20, V Frankston, N, Y, N, N, N, N], [99, 20, V Glen Waverley, N, Y, N, N, N, N], [100, 20, V Waurn Ponds, N, Y, N, N, N, N], [125, 10, N Mt Druitt, N, Y, N, N, N, N], [126, 40, Q Robina, N, Y, N, N, N, N], [127, 50, S Marion, N, Y, N, N, N, N], [128, 60, W Rockingham, N, Y, N, N, N, N], [129, 10, N Macquarie, N, Y, N, N, N, N], [131, 20, V Melbourne City, N, Y, N, N, N, N], [132, 20, V Glenorchy, N, Y, N, N, N, N], [133, 40, Q Browns Plains, N, Y, N, N, N, N], [134, 50, S Reynella, N, Y, N, N, N, N], [135, 40, Q Capalaba, N, Y, N, N, N, N], [136, 10, N Charlestown, N, Y, N, N, N, N], [137, 20, V Dandenong, N, Y, N, N, N, N], [138, 40, Q Cairns Central, N, Y, N, N, N, N], [139, 40, Q Toowoomba, N, Y, N, N, N, N], [140, 40, Q Pacific Fair, N, Y, N, N, N, N], [141, 40, Q The Willows, N, Y, N, N, N, N], [142, 50, S Hollywood Plaza, N, Y, N, N, N, N], [143, 40, Q Hervey Bay, N, Y, N, N, N, N], [144, 10, N Parramatta, N, Y, N, N, N, N], [145, 10, N Port Macquarie, N, Y, N, N, N, N], [146, 40, Q Palmerston, N, Y, N, N, N, N], [149, 20, V Broadmeadows, N, Y, N, N, N, N], [150, 10, N Cowra, N, Y, N, N, N, N], [151, 60, W Perth, N, Y, N, N, N, N], [152, 20, V Mornington, N, Y, N, N, N, N], [153, 20, V Pakenham, N, Y, N, N, N, N], [154, 10, N Shellharbour, N, Y, N, N, N, N], [155, 40, Q Redbank, N, Y, N, N, N, N], [156, 40, Q Morayfield, N, Y, N, N, N, N], [157, 20, V Chirnside Park, N, Y, N, N, N, N], [158, 20, V Brimbank Central, N, Y, N, N, N, N], [159, 50, S Whyalla, N, Y, N, N, N, N], [160, 20, V Watergardens, N, Y, N, N, N, N], [161, 20, V Hobart, N, Y, N, N, N, N], [162, 10, N Tuggeranong, N, Y, N, N, N, N], [163, 10, N Queanbeyan, N, Y, N, N, N, N], [164, 10, N Tuggerah, N, Y, N, N, N, N], [165, 10, N Hurstville, N, Y, N, N, N, N], [166, 40, Q Chermside, N, Y, N, N, N, N], [167, 40, Q Northlakes, N, Y, N, N, N, N], [168, 20, V Airport West, N, Y, N, N, N, N], [169, 10, N Hornsby, N, Y, N, N, N, N], [170, 10, N Bondi, N, Y, N, N, N, N], [171, 10, N Burwood, N, Y, N, N, N, N], [173, 60, W Bunbury, N, Y, N, N, N, N], [174, 40, Q Carindale, N, Y, N, N, N, N], [175, 10, N Tamworth, N, Y, N, N, N, N], [177, 10, N Castle Hill, N, Y, N, N, N, N], [178, 10, N Blacktown, N, Y, N, N, N, N], [179, 20, V Greensborough, N, Y, N, N, N, N], [180, 60, W Joondalup, N, Y, N, N, N, N], [183, 20, V Swan Hill, N, Y, N, N, N, N], [184, 40, Q Brisbane CBD, N, Y, N, N, N, N], [186, 20, B Narre Warren (Closed), N, Y, N, N, N, N], [188, 10, N Macarthur Square, N, Y, N, N, N, N], [189, 20, B Northland Baby Target, N, Y, N, N, N, N], [191, 50, B Golden Grove, N, Y, N, N, N, N], [192, 10, N Wetherill Park, N, Y, N, N, N, N], [193, 60, W Kalgoorlie, N, Y, N, N, N, N], [194, 50, S Mildura, N, Y, N, N, N, N], [195, 40, Q Bribie Island, N, Y, N, N, N, N], [196, 60, W Meadow Springs, N, Y, N, N, N, N], [197, 50, S Unley, N, Y, N, N, N, N]]')
select_menu(commonBits.fl('Window') + '>>DTAR1000_Store_file_std.bin>>' + commonBits.fl('Table:') + '1')
assert_p('Table', 'Content', '[[5, 20, V Albury, N, Y, N, N, N, N], [6, 20, V Wodonga, N, Y, N, N, N, N], [7, 20, V Shepparton, N, Y, N, N, N, N], [8, 20, V Bendigo, N, Y, N, N, N, N], [12, 20, V Ringwood, N, Y, N, N, N, N], [25, 50, S Fulham Gardens, N, Y, N, N, N, N], [30, 20, V Epping, N, Y, N, N, N, N], [32, 20, V Camberwell, N, Y, N, N, N, N], [33, 10, Y Blacktown (Closed), N, Y, N, N, N, N]]')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table1', 'Loc Type', commonBits.fl('Field') + ',0')
select('Table1', ' = ', commonBits.fl('Operator') + ',0')
select('Table1', 'dc', commonBits.fl('Value') + ',0')
select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table1', '8', commonBits.fl('Value') + ',1')
select('Table1', 'cell:' + commonBits.fl('Value') + ',1()')
select('Table', 'false', commonBits.fl('Include') + ',0')
select('Table', 'false', commonBits.fl('Include') + ',2')
select('Table', 'false', commonBits.fl('Include') + ',7')
select('Table', 'false', commonBits.fl('Include') + ',6')
select('Table', 'false', commonBits.fl('Include') + ',5')
#select('Table1', 'cell:' + commonBits.fl('Include') + ',5(false)')
commonBits.filter(click)
select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)')
assert_p(
'Table', 'Content',
'[[5839, DC - Taras Ave, , VIC, A], [5850, VIC West Ad Support, , VIC, A], [5853, NSW North Sydney Ad Support, , , A], [5866, WA Ad Support, , , A], [5887, QLD Ad Support, , , A], [5888, SA Ad Support, , , A], [5895, VIC East Ad Support, , , A], [5897, Sydney Gate DC, No 2 Sydney Gate, NSW, A], [5958, State Warehouse WA, Target State Warehouse (WA) FCL, WA, A], [5968, Beverly DC, Beverly DC, SA, A]]'
)
select('Table', 'cell:10 - 35|Loc Name,7(Sydney Gate DC)')
assert_p('Table', 'Text', 'cell:10 - 35|Loc Name,7(Sydney Gate DC)')
select('Table', 'cell:10 - 35|Loc Name,5(SA Ad Support)')
assert_p('Table', 'RowCount', '10')
select('Table', 'cell:10 - 35|Loc Name,7(Sydney Gate DC)')
rightclick('Table', '10 - 35|Loc Name,7')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:10 - 35|Loc Name,7(Sydney Gate DC)')
select('Table', 'cell:' + commonBits.fl('Data') + ',1(Sydney Gate DC)')
assert_p(
'Table', 'Content',
'[[Loc Nbr, 4, 4, 5897, 5897], [Loc Name, 10, 35, Sydney Gate DC, Sydney Gate DC], [Loc Addr Ln1, 45, 40, No 2 Sydney Gate, No 2 Sydney Gate], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(NSW)')
assert_p('Table', 'Text', 'cell:' + commonBits.fl('Data') + ',3(NSW)')
select('Table', 'cell:' + commonBits.fl('Data') + ',1(Sydney Gate DC)')
assert_p('Table', 'RowCount', '5')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table', 'false', commonBits.fl('Include') + ',0')
select('Table', 'false', commonBits.fl('Include') + ',2')
select('Table', 'false', commonBits.fl('Include') + ',5')
select('Table', 'false', commonBits.fl('Include') + ',6')
select('Table', 'false', commonBits.fl('Include') + ',7')
#select('Table1', 'cell:' + commonBits.fl('Include') + ',7(false)')
select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',0')
select('Table1', '1', commonBits.fl('Value') + ',0')
select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table1', '2', commonBits.fl('Value') + ',1')
select('Table1', 'cell:' + commonBits.fl('Value') + ',1()')
commonBits.filter(click)
select('Table', 'cell:45 - 40|Loc Addr Ln1,4(Derwent Park)')
assert_p('Table', 'Text', 'Derwent Park', '45 - 40|Loc Addr Ln1,4')
select(
'Table',
'cell:45 - 40|Loc Addr Ln1,5(Chermside Shopping Centre, G ie Rd)')
assert_p(
'Table', 'Content',
'[[5129, Macquarie, Maquarie Centre, NSW, A], [5162, Tuggeranong, Hyperdome Shopping Centre, NSW, A], [5012, Ringwood, Ringwood, VIC, A], [5152, Mornington, Mornington, VIC, A], [5132, Glenorchy, Derwent Park, TAS, A], [5172, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, QLD, A], [5126, Robina, Robina Town Centre, QLD, A], [5021, Tea Tree Plaza, Myer Tea Tree Plaza, SA, A], [5127, Marion, Adelaide Airport, SA, A], [5142, Hollywood Plaza, Hollywood Plaza Shopping Centre, SA, A], [5128, Rockingham, Rockingham Shopping Centre., WA, A], [5192, Wetherill Park, , , A]]'
)
select('Table', 'cell:45 - 40|Loc Addr Ln1,7(Myer Tea Tree Plaza)')
assert_p('Table', 'RowCount', '12')
select('Table', 'cell:10 - 35|Loc Name,2(Ringwood)')
rightclick('Table', '10 - 35|Loc Name,2')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:10 - 35|Loc Name,2(Ringwood)')
select('Table', 'cell:' + commonBits.fl('Data') + ',1(Ringwood)')
assert_p(
'Table', 'Content',
'[[Loc Nbr, 4, 4, 5012, 5012], [Loc Name, 10, 35, Ringwood, Ringwood], [Loc Addr Ln1, 45, 40, Ringwood, Ringwood], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(VIC)')
assert_p('Table', 'Text', 'VIC', commonBits.fl('Data') + ',3')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(Ringwood)')
assert_p('Table', 'RowCount', '5')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
click(commonBits.fl('Choose File'))
if window('Open'):
select(commonBits.selectPane(), 'utf8a_Ams_LocDownload_20041228.txt')
click('Open')
close()
commonBits.setRecordLayout(select, 'utf8_ams Store')
click(commonBits.fl('Edit') + '1')
select('Table', 'cell:4 - 4|Loc Nbr,0(5839)')
rightclick('Table', '4 - 4|Loc Nbr,0')
select_menu( commonBits.fl('Edit Record'))
click('Find')
#click('MetalInternalFrameTitlePane', 194, 3)
select('TextField', 'Shopping Centre')
select('ComboBox1', commonBits.fl('Contains'))
##click('Find1')
commonBits.find(click)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(Kalgoorlie (not yet open))')
## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5193, 5193], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Kalgoorlie (not yet open), Kalgoorlie (not yet open)], [Loc Addr Ln1, 45, 40, Shopping Centre, Shopping Centre], [Loc Addr Ln2, 85, 40, Cnr Cassidy and Egan Streets, Cnr Cassidy and Egan Streets], [Loc Addr Ln3, 125, 35, Kalgoorlie, Kalgoorlie], [Loc Postcode, 160, 10, 6430, 6430], [Loc State, 170, 3, WA, WA], [Loc Actv Ind, 173, 1, A, A]]')
## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
if commonBits.isMissingCol():
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW]]')
else:
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(Kalgoorlie (not yet open))')
select('ComboBox1', commonBits.fl('Contains'))
select('ComboBox2', commonBits.fl('Backward'))
commonBits.find(click)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(Carindale)')
## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
if commonBits.isMissingCol():
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW]]')
else:
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5169, 5169], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Hornsby, Hornsby], [Loc Addr Ln1, 45, 40, Westfield Shopping Centre, Westfield Shopping Centre], [Loc Addr Ln2, 85, 40, George Street, George Street], [Loc Addr Ln3, 125, 35, Hornsby, Hornsby], [Loc Postcode, 160, 10, 2077, 2077], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
click('Choose File')
if window('Open'):
select(commonBits.selectPane(),
'utf8a_Ams_LocDownload_20041228.txt')
click('Open')
close()
commonBits.setRecordLayout(select, 'utf8_ams Store')
click('Edit1')
## select('Table', 'rows:[0,1,2,3,4,5],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type]')
select('Table', 'rows:[0,1,2,3,4,5],columns:[8 - 2|Loc Type]')
select_menu('View>>Column View #{Selected Records#}')
## select('Table2', 'rows:[0,1,2,3,4,5],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type]')
select('Table', 'cell:Row 1,0(TAR)')
assert_p('Table1', 'Text', '3', 'Len,0')
select('Table', 'cell:Row 1,1(5839)')
## assert_p('Table', 'Content', '[[TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019], [DC, DC, DC, DC, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith], [, , , , Bankstown, Penrith], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street], [Altona North, Laverton, , , Condell Park, Penrith], [3025, 3028, , , 2200, 2750], [VIC, VIC, , , NSW, NSW], [A, A, A, A, A, A]]')
if commonBits.isMissingCol():
assert_p(
'Table', 'Content',
'[[TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019], [DC, DC, DC, DC, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith], [, , , , Bankstown, Penrith], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street], [Altona North, Laverton, , , Condell Park, Penrith], [3025, 3028, , , 2200, 2750], [VIC, VIC, , , NSW, NSW]]'
)
else:
assert_p(
'Table', 'Content',
'[[TAR, TAR, TAR, TAR, TAR, TAR], [5839, 5850, 5853, 5866, 5015, 5019], [DC, DC, DC, DC, ST, ST], [DC - Taras Ave, VIC West Ad Support, NSW North Sydney Ad Support, WA Ad Support, Bankstown, Penrith], [, , , , Bankstown, Penrith], [30-68 Taras Ave, Lot 2 Little Boundary Rd, , , Unit 2, 39-41 Allingham Street, 58 Leland Street], [Altona North, Laverton, , , Condell Park, Penrith], [3025, 3028, , , 2200, 2750], [VIC, VIC, , , NSW, NSW], [A, A, A, A, A, A]]'
)
select('Table', 'cell:Row 1,1(5839)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table',
'rows:[0,1,2,3,4,5],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type]')
select('Table',
'rows:[8,11,15],columns:[4 - 4|Loc Nbr,8 - 2|Loc Type]')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'Ams_LocDownload_20041228_Extract.txt')
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
select('Table', 'rows:[1,2,3],columns:[10 - 35|Loc Name]')
select_menu(commonBits.fl('Edit') + '>>' + commonBits.fl('Cut Record#{s#}'))
select('Table', 'cell:10 - 35|Loc Name,5(Bass Hill)')
assert_p('Table', 'Content', '[[TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A]]')
select('Table', 'cell:45 - 40|Loc Addr Ln1,4(St. Mary\'s)')
assert_p('Table', 'RowCount', '10')
select('Table', 'cell:45 - 40|Loc Addr Ln1,6(Campbelltown Mall)')
select_menu(commonBits.fl('Edit') + '>>' + commonBits.fl('Paste Record#{s#}'))
select('Table', 'cell:10 - 35|Loc Name,7(Penrith)')
assert_p('Table', 'Content', '[[TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A], [TAR, 5081, ST, Ashfield, Ashfield Mall, Knox Street, Ashfield, 2131, NSW, A], [TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A]]')
select('Table', 'cell:10 - 35|Loc Name,4(St Marys)')
assert_p('Table', 'RowCount', '13')
select('Table', 'rows:[9,10,11],columns:[45 - 40|Loc Addr Ln1]')
select_menu(commonBits.fl('Edit') + '>>' + commonBits.fl('Delete Record#{s#}'))
select('Table', 'cell:8 - 2|Loc Type,4(ST)')
assert_p('Table', 'Content', '[[TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A]]')
select('Table', 'cell:10 - 35|Loc Name,7(Penrith)')
assert_p('Table', 'RowCount', '10')
select('Table', 'rows:[1,2,3],columns:[10 - 35|Loc Name]')
select_menu(commonBits.fl('Edit') + '>>' + commonBits.fl('Copy Record#{s#}'))
select('Table', 'cell:10 - 35|Loc Name,7(Penrith)')
select_menu(commonBits.fl('Edit') + '>>' + commonBits.fl('Paste Record#{s#} Prior'))
select('Table', 'cell:8 - 2|Loc Type,5(ST)')
assert_p('Table', 'Content', '[[TAR, 5015, ST, Bankstown, Bankstown, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5085, ST, Roselands, Condell park, Unit 2, 39-41 Allingham Street, Condell Park, 2200, NSW, A]]')
select('Table', 'cell:10 - 35|Loc Name,7(Miranda)')
assert_p('Table', 'RowCount', '13')
select('Table', 'cell:10 - 35|Loc Name,7(Miranda)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
if window(commonBits.fl('Save Changes to file: ' + commonBits.sampleDir() + 'Ams_LocDownload_20041228_Extract.txt')):
click('No')
close()
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'Unknown_Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'Unknown Text IO')
click('Edit1')
## click('Find1')
## select('TextField', 'Cnr')
##commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Table:')
click('Filter1')
select('Table1', 'Data', 'Field,0')
select('Table1', 'Cnr', 'Value,0')
select('Table1', 'cell:Value,0()')
click('Filter1')
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Table:')
select_menu('Edit>>Change Layout')
select('ComboBox2', 'ams Store')
## click('ScrollPane$ScrollBar', 5, 22)
click('Go')
## select('Table', '')
rightclick('Table', '10 - 35|Loc Name,7')
select_menu('Edit Record')
assert_p(
'Table', 'Content',
'[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5035, 5035], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Rockdale, Rockdale], [Loc Addr Ln1, 45, 40, Building B, Portside DC, Building B, Portside DC], [Loc Addr Ln2, 85, 40, 2-8 Mc Pherson Street, 2-8 Mc Pherson Street], [Loc Addr Ln3, 125, 35, Botany, Botany], [Loc Postcode, 160, 10, 2019, 2019], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]'
)
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Table:1')
## select('Table', '')
rightclick('Table', '10 - 35|Loc Name,7')
select_menu('Edit Record')
assert_p(
'Table', 'Content',
'[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5163, 5163], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Queanbeyan, Queanbeyan], [Loc Addr Ln1, 45, 40, Riverside Plaza Shopping Centre, Riverside Plaza Shopping Centre], [Loc Addr Ln2, 85, 40, Cnr Monaro St & Fallick Lane, Cnr Monaro St & Fallick Lane], [Loc Addr Ln3, 125, 35, Queanbeyan, Queanbeyan], [Loc Postcode, 160, 10, 2620, 2620], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
click(commonBits.fl('Choose File'))
if window('Open'):
select(commonBits.selectPane(), 'Ams_LocDownload_20041228.txt')
click('Open')
close()
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
select('Table', '1', '45 - 40|Loc Addr Ln1,0')
select('Table', '22', '45 - 40|Loc Addr Ln1,1')
select('Table', '33', '85 - 40|Loc Addr Ln2,2')
select('Table', 'cell:125 - 35|Loc Addr Ln3,2()')
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare with Disk')
## select('Table1', 'cell:125 - 35|Loc Addr Ln3,2()')
select('Table', 'cell:Loc Name,0(DC - Taras Ave)')
assert_p('Table', 'Text', 'DC - Taras Ave', 'Loc Name,0')
select('Table', 'cell:Loc Name,0(DC - Taras Ave)')
### assert_p('Table', 'Content', '[[, Old, 1, TAR, 5839, DC, DC - Taras Ave, 1, 30-68 Taras Ave, Altona North, 3025, VIC, A], [, New, 1, , , , , , , , , , ], [, Old, 2, TAR, 5850, DC, VIC West Ad Support, 22, Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, New, 2, , , , , , , , , , ], [, Old, 3, TAR, 5853, DC, NSW North Sydney Ad Support, , 33, , , , A], [, New, 3, , , , , , , , , , ]]')
assert_p('Table', 'Content', '[[, Old, 1, TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [, New, 1, , , , , 1, , , , , ], [, Old, 2, TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [, New, 2, , , , , 22, , , , , ], [, Old, 3, TAR, 5853, DC, NSW North Sydney Ad Support, , , , , , A], [, New, 3, , , , , , 33, , , , ]]')
select('Table', 'cell:Loc Name,0(DC - Taras Ave)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table', 'cell:125 - 35|Loc Addr Ln3,2()')
select('Table', 'cell:125 - 35|Loc Addr Ln3,2()')
## if window(r'Save Changes to file: C:\Program Files\RecordEdit\HSQLDB\SampleFiles\Ams_LocDownload_20041228.txt'):
## click('No')
## click('No')
## close()
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'ams Store')
click('Edit1')
assert_p('Table', 'Text', 'DC - Taras Ave', '10 - 35|Loc Name,0')
assert_p('Table', 'Text', 'Bankstown', '10 - 35|Loc Name,4')
doubleclick('BaseDisplay$HeaderToolTips', '10 - 35|Loc Name')
assert_p('Table', 'Text', 'Airport West', '10 - 35|Loc Name,0')
assert_p('Table', 'Text', 'Bass Hill', '10 - 35|Loc Name,5')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
if window(r'Save Changes to file: ' + commonBits.sampleDir() +
'Ams_LocDownload_20041228.txt'):
click('No')
close()
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'utf8a_Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'utf8_ams Store')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',0')
select('Table1', '1', commonBits.fl('Value') + ',0')
select('Table1', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table1', '2', commonBits.fl('Value') + ',1')
select('Table1', 'cell:' + commonBits.fl('Value') + ',1()')
commonBits.filter(click)
select('Table', 'cell:10 - 35|Loc Name,5(Strathpine - Not Yet Open)')
assert_p('Table', 'Text', 'Strathpine - Not Yet Open',
'10 - 35|Loc Name,5')
select('Table', 'cell:10 - 35|Loc Name,6(Robina)')
## assert_p('Table', 'Content', '[[TAR, 5129, ST, Macquarie, Maquarie Centre, Dock 2, Talavera Road, North Ryde, 2113, NSW, A], [TAR, 5162, ST, Tuggeranong, Hyperdome Shopping Centre, Pitman Street, Tuggernong, 2900, NSW, A], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, A], [TAR, 5152, ST, Mornington, Mornington, Cnr Franklin & Gordon Streets, Momington, 3931, VIC, A], [TAR, 5132, ST, Glenorchy, Derwent Park, Lot 12-13 Riverside Industrial Estate, Derwent park, 7009, TAS, A], [TAR, 5172, ST, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, , Strathpine, 4032, QLD, A], [TAR, 5126, ST, Robina, Robina Town Centre, Robina Parkway, Robina, 4226, QLD, A], [TAR, 5021, ST, Tea Tree Plaza, Myer Tea Tree Plaza, 976 North East Road, Modbury, 5092, SA, A], [TAR, 5127, ST, Marion, Adelaide Airport, Frank Collopy Court, Adelaide Airport, 5950, SA, A], [TAR, 5142, ST, Hollywood Plaza, Hollywood Plaza Shopping Centre, Winzor Road, Salisbury Downs, 5108, SA, A], [TAR, 5128, ST, Rockingham, Rockingham Shopping Centre., Cnr. Read Street & Council Avenue, Rockingham, 6168, WA, A], [TAR, 5192, ST, Wetherill Park, , , , , , A]]')
if commonBits.isMissingCol():
assert_p(
'Table', 'Content',
'[[TAR, 5129, ST, Macquarie, Maquarie Centre, Dock 2, Talavera Road, North Ryde, 2113, NSW], [TAR, 5162, ST, Tuggeranong, Hyperdome Shopping Centre, Pitman Street, Tuggernong, 2900, NSW], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC], [TAR, 5152, ST, Mornington, Mornington, Cnr Franklin & Gordon Streets, Momington, 3931, VIC], [TAR, 5132, ST, Glenorchy, Derwent Park, Lot 12-13 Riverside Industrial Estate, Derwent park, 7009, TAS], [TAR, 5172, ST, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, , Strathpine, 4032, QLD], [TAR, 5126, ST, Robina, Robina Town Centre, Robina Parkway, Robina, 4226, QLD], [TAR, 5021, ST, Tea Tree Plaza, Myer Tea Tree Plaza, 976 North East Road, Modbury, 5092, SA], [TAR, 5127, ST, Marion, Adelaide Airport, Frank Collopy Court, Adelaide Airport, 5950, SA], [TAR, 5142, ST, Hollywood Plaza, Hollywood Plaza Shopping Centre, Winzor Road, Salisbury Downs, 5108, SA], [TAR, 5128, ST, Rockingham, Rockingham Shopping Centre., Cnr. Read Street & Council Avenue, Rockingham, 6168, WA], [TAR, 5192, ST, Wetherill Park, , , , , ]]'
)
else:
assert_p(
'Table', 'Content',
'[[TAR, 5129, ST, Macquarie, Maquarie Centre, Dock 2, Talavera Road, North Ryde, 2113, NSW, A], [TAR, 5162, ST, Tuggeranong, Hyperdome Shopping Centre, Pitman Street, Tuggernong, 2900, NSW, A], [TAR, 5012, ST, Ringwood, Ringwood, Seymour Street, Ringwood, 3134, VIC, A], [TAR, 5152, ST, Mornington, Mornington, Cnr Franklin & Gordon Streets, Momington, 3931, VIC, A], [TAR, 5132, ST, Glenorchy, Derwent Park, Lot 12-13 Riverside Industrial Estate, Derwent park, 7009, TAS, A], [TAR, 5172, ST, Strathpine - Not Yet Open, Chermside Shopping Centre, G ie Rd, , Strathpine, 4032, QLD, A], [TAR, 5126, ST, Robina, Robina Town Centre, Robina Parkway, Robina, 4226, QLD, A], [TAR, 5021, ST, Tea Tree Plaza, Myer Tea Tree Plaza, 976 North East Road, Modbury, 5092, SA, A], [TAR, 5127, ST, Marion, Adelaide Airport, Frank Collopy Court, Adelaide Airport, 5950, SA, A], [TAR, 5142, ST, Hollywood Plaza, Hollywood Plaza Shopping Centre, Winzor Road, Salisbury Downs, 5108, SA, A], [TAR, 5128, ST, Rockingham, Rockingham Shopping Centre., Cnr. Read Street & Council Avenue, Rockingham, 6168, WA, A], [TAR, 5192, ST, Wetherill Park, , , , , , A]]'
)
select('Table', 'cell:10 - 35|Loc Name,7(Tea Tree Plaza)')
assert_p('Table', 'RowCount', '12')
select('Table', 'cell:10 - 35|Loc Name,7(Tea Tree Plaza)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
commonBits.setRecordLayout(select, 'DTAR020')
click('Edit1')
select_menu('View>>Field Based Tree')
## select('List', 'DTAR020')
select('Table', 'STORE-NO', 'Field,0')
select('Table', 'DEPT-NO', 'Field,1')
select('Table', 'cell:Field,1(DEPT-NO)')
#click('MetalInternalFrameTitlePane', 153, 11)
#click('MetalInternalFrameTitlePane', 146, 3)
#click('MetalInternalFrameTitlePane', 199, 6)
click('Build Tree')
select('JTreeTable', 'cell:STORE-NO,2(null)')
assert_p('JTreeTable', 'RowCount', '4')
select('JTreeTable', 'cell:STORE-NO,2(null)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'Ams_LocDownload_20041228.txt')
click(commonBits.fl('Choose File'))
if window('Open'):
click('Open')
close()
commonBits.setRecordLayout(select, 'ams Store')
commonBits.doEdit(click)
## click(commonBits.fl('Edit') + '1')
click('Filter')
select('Table1', 'Loc Type', commonBits.fl('Field') + ',0')
select('Table1', 'dc', commonBits.fl('Value') + ',0')
select('Table1', 'cell:' + commonBits.fl('Value') + ',0()')
commonBits.filter(click)
select('Table', 'cell:10 - 35|Loc Name,2(NSW North Sydney Ad Support)')
rightclick('Table', '10 - 35|Loc Name,2')
select('Table', 'cell:10 - 35|Loc Name,2(NSW North Sydney Ad Support)')
assert_p(
'Table', 'Content',
'[[TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [TAR, 5853, DC, NSW North Sydney Ad Support, , , , , , A], [TAR, 5866, DC, WA Ad Support, , , , , , A], [TAR, 5700, DC, Head Office, , , , , , A], [TAR, 5887, DC, QLD Ad Support, , , , , , A], [TAR, 5888, DC, SA Ad Support, , , , , , A], [TAR, 5109, DC, National Ad Support, , , , , , A], [TAR, 5895, DC, VIC East Ad Support, , , , , , A], [TAR, 5897, DC, Sydney Gate DC, No 2 Sydney Gate, 830 Bourke Street, Waterloo, 2017, NSW, A], [TAR, 5949, DC, Central Returns Centre, , 214-228 Blackshaws Rd, Altona North, , VIC, A], [TAR, 5951, DC, NSW West Sydney Ad Support, , , , , , A], [TAR, 5952, DC, TAS Ad Support, , , , , , A], [TAR, 5953, DC, North Geelong Warehouse, Target Head Office, 12 Thompson Road, North Geelong, 3215, VIC, A], [TAR, 5954, DC, State Warehouse NSW, Target State Warehouse NSW (Westgate), Warehouse D Murtha Street, Arndell Park, 2148, NSW, A], [TAR, 5955, DC, State Warehouse VIC, Target State Warehouse VIC (Patricks), 180 Fitzgerald Road, Laverton, 3028, VIC, A], [TAR, 5957, DC, State Warehouse SA, Target State Warehouse (Patricks), 180 Fitzgerald Road, Laverton, 3028, VIC, A], [TAR, 5958, DC, State Warehouse WA, Target State Warehouse (WA) FCL, 56 Dowd Street, Welshpool, 6106, WA, A], [TAR, 5956, DC, State Warehouse QLD, Target State Warehouse QLD (RMS), 243 Bradman Street, Acacia Ridge, 4110, QLD, A], [TAR, 5959, DC, NSW South Sydney Ad Support, South Sydney Ad Support, 753 Hume Highway, Bass Hill, , NSW, A], [TAR, 5960, DC, NSW East Sydney Ad Support, Building B, Portside Distribution Ce, 2 - 8 Mc Pherson Street,, Botany, 2019, NSW, A], [TAR, 5963, DC, QLD South Ad Support, , , , , , A], [TAR, 5964, DC, QLD North Ad Support, , , , , , A], [TAR, 5965, DC, Canning Vale DC, Canning Vale DC, Cnr Nicholson & Bannister Rd\'s, Canning Vale, 6155, WA, A], [TAR, 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, NSW, A], [TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A], [TAR, 5969, DC, Woodlands DC (DO NOT USE), Woodlands DC, Lot 9 Mills Road, Braeside, 3195, VIC, A]]'
)
select('Table', 'cell:10 - 35|Loc Name,2(NSW North Sydney Ad Support)')
assert_p('Table', 'RowCount', '28')
select('Table', 'cell:10 - 35|Loc Name,2(NSW North Sydney Ad Support)')
doubleclick('BaseDisplay$HeaderToolTips', '4 - 4|Loc Nbr')
select('Table', 'cell:10 - 35|Loc Name,0(National Ad Support)')
assert_p(
'Table', 'Content',
'[[TAR, 5109, DC, National Ad Support, , , , , , A], [TAR, 5700, DC, Head Office, , , , , , A], [TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [TAR, 5853, DC, NSW North Sydney Ad Support, , , , , , A], [TAR, 5866, DC, WA Ad Support, , , , , , A], [TAR, 5887, DC, QLD Ad Support, , , , , , A], [TAR, 5888, DC, SA Ad Support, , , , , , A], [TAR, 5895, DC, VIC East Ad Support, , , , , , A], [TAR, 5897, DC, Sydney Gate DC, No 2 Sydney Gate, 830 Bourke Street, Waterloo, 2017, NSW, A], [TAR, 5949, DC, Central Returns Centre, , 214-228 Blackshaws Rd, Altona North, , VIC, A], [TAR, 5951, DC, NSW West Sydney Ad Support, , , , , , A], [TAR, 5952, DC, TAS Ad Support, , , , , , A], [TAR, 5953, DC, North Geelong Warehouse, Target Head Office, 12 Thompson Road, North Geelong, 3215, VIC, A], [TAR, 5954, DC, State Warehouse NSW, Target State Warehouse NSW (Westgate), Warehouse D Murtha Street, Arndell Park, 2148, NSW, A], [TAR, 5955, DC, State Warehouse VIC, Target State Warehouse VIC (Patricks), 180 Fitzgerald Road, Laverton, 3028, VIC, A], [TAR, 5956, DC, State Warehouse QLD, Target State Warehouse QLD (RMS), 243 Bradman Street, Acacia Ridge, 4110, QLD, A], [TAR, 5957, DC, State Warehouse SA, Target State Warehouse (Patricks), 180 Fitzgerald Road, Laverton, 3028, VIC, A], [TAR, 5958, DC, State Warehouse WA, Target State Warehouse (WA) FCL, 56 Dowd Street, Welshpool, 6106, WA, A], [TAR, 5959, DC, NSW South Sydney Ad Support, South Sydney Ad Support, 753 Hume Highway, Bass Hill, , NSW, A], [TAR, 5960, DC, NSW East Sydney Ad Support, Building B, Portside Distribution Ce, 2 - 8 Mc Pherson Street,, Botany, 2019, NSW, A], [TAR, 5963, DC, QLD South Ad Support, , , , , , A], [TAR, 5964, DC, QLD North Ad Support, , , , , , A], [TAR, 5965, DC, Canning Vale DC, Canning Vale DC, Cnr Nicholson & Bannister Rd\'s, Canning Vale, 6155, WA, A], [TAR, 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, NSW, A], [TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A], [TAR, 5969, DC, Woodlands DC (DO NOT USE), Woodlands DC, Lot 9 Mills Road, Braeside, 3195, VIC, A]]'
)
select('Table', 'cell:4 - 4|Loc Nbr,2(5839)')
assert_p('Table', 'Text', '5839', '4 - 4|Loc Nbr,2')
doubleclick('BaseDisplay$HeaderToolTips', '10 - 35|Loc Name')
select('Table', 'cell:10 - 35|Loc Name,1(Canning Vale DC)')
assert_p(
'Table', 'Content',
'[[TAR, 5968, DC, Beverly DC, Beverly DC, 117 Main Street, Beverly, 5009, SA, A], [TAR, 5965, DC, Canning Vale DC, Canning Vale DC, Cnr Nicholson & Bannister Rd\'s, Canning Vale, 6155, WA, A], [TAR, 5949, DC, Central Returns Centre, , 214-228 Blackshaws Rd, Altona North, , VIC, A], [TAR, 5839, DC, DC - Taras Ave, , 30-68 Taras Ave, Altona North, 3025, VIC, A], [TAR, 5700, DC, Head Office, , , , , , A], [TAR, 5967, DC, Hendra DC, Hendra DC, Cnr Headly Ave & Nudgee Road, Hendra, 4011, QLD, A], [TAR, 5966, DC, Huntingwood DC, Huntingwood DC, 35 Huntingwood Drive, Huntingwood, 2148, NSW, A], [TAR, 5959, DC, NSW South Sydney Ad Support, South Sydney Ad Support, 753 Hume Highway, Bass Hill, , NSW, A], [TAR, 5960, DC, NSW East Sydney Ad Support, Building B, Portside Distribution Ce, 2 - 8 Mc Pherson Street,, Botany, 2019, NSW, A], [TAR, 5853, DC, NSW North Sydney Ad Support, , , , , , A], [TAR, 5951, DC, NSW West Sydney Ad Support, , , , , , A], [TAR, 5109, DC, National Ad Support, , , , , , A], [TAR, 5953, DC, North Geelong Warehouse, Target Head Office, 12 Thompson Road, North Geelong, 3215, VIC, A], [TAR, 5887, DC, QLD Ad Support, , , , , , A], [TAR, 5964, DC, QLD North Ad Support, , , , , , A], [TAR, 5963, DC, QLD South Ad Support, , , , , , A], [TAR, 5888, DC, SA Ad Support, , , , , , A], [TAR, 5954, DC, State Warehouse NSW, Target State Warehouse NSW (Westgate), Warehouse D Murtha Street, Arndell Park, 2148, NSW, A], [TAR, 5958, DC, State Warehouse WA, Target State Warehouse (WA) FCL, 56 Dowd Street, Welshpool, 6106, WA, A], [TAR, 5956, DC, State Warehouse QLD, Target State Warehouse QLD (RMS), 243 Bradman Street, Acacia Ridge, 4110, QLD, A], [TAR, 5957, DC, State Warehouse SA, Target State Warehouse (Patricks), 180 Fitzgerald Road, Laverton, 3028, VIC, A], [TAR, 5955, DC, State Warehouse VIC, Target State Warehouse VIC (Patricks), 180 Fitzgerald Road, Laverton, 3028, VIC, A], [TAR, 5897, DC, Sydney Gate DC, No 2 Sydney Gate, 830 Bourke Street, Waterloo, 2017, NSW, A], [TAR, 5952, DC, TAS Ad Support, , , , , , A], [TAR, 5895, DC, VIC East Ad Support, , , , , , A], [TAR, 5850, DC, VIC West Ad Support, , Lot 2 Little Boundary Rd, Laverton, 3028, VIC, A], [TAR, 5866, DC, WA Ad Support, , , , , , A], [TAR, 5969, DC, Woodlands DC (DO NOT USE), Woodlands DC, Lot 9 Mills Road, Braeside, 3195, VIC, A]]'
)
select('Table', 'cell:10 - 35|Loc Name,1(Canning Vale DC)')
rightclick('Table', '10 - 35|Loc Name,1')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:10 - 35|Loc Name,1(Canning Vale DC)')
select(
'Table', 'cell:' + commonBits.fl('Data') +
',5(Cnr Nicholson & Bannister Rd\'s)')
assert_p(
'Table', 'Content',
'[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5965, 5965], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Canning Vale DC, Canning Vale DC], [Loc Addr Ln1, 45, 40, Canning Vale DC, Canning Vale DC], [Loc Addr Ln2, 85, 40, Cnr Nicholson & Bannister Rd\'s, Cnr Nicholson & Bannister Rd\'s], [Loc Addr Ln3, 125, 35, Canning Vale, Canning Vale], [Loc Postcode, 160, 10, 6155, 6155], [Loc State, 170, 3, WA, WA], [Loc Actv Ind, 173, 1, A, A]]'
)
select(
'Table', 'cell:' + commonBits.fl('Data') +
',5(Cnr Nicholson & Bannister Rd\'s)')
click('Right')
select('Table',
'cell:' + commonBits.fl('Data') + ',5(214-228 Blackshaws Rd)')
assert_p('Table', 'Text', '214-228 Blackshaws Rd',
commonBits.fl('Data') + ',5')
select('Table',
'cell:' + commonBits.fl('Data') + ',5(214-228 Blackshaws Rd)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
#click('WindowsInternalFrameTitlePane', 627, 14)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'Unknown_Ams_LocDownload_20041228.txt')
commonBits.setRecordLayout(select, 'Unknown Text IO')
click('Edit1')
rightclick('Table', '1 - 1|Data,6')
select_menu('Edit Record')
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Table:')
select('Table', 'rows:[5,6,7,8,9,10,11,12,13,14],columns:[1 - 1|Data]')
select_menu('View>>Table View #{Selected Records#}')
### select('Table2', 'rows:[5,6,7,8,9,10,11,12,13,14],columns:[1 - 1|Data]')
### select('Table', '')
rightclick('Table', '1 - 1|Data,7')
select_menu('Edit Record')
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Table:')
select('Table', 'rows:[5,6,7,8,9,10,11,12,13,14],columns:[1 - 1|Data]')
select('Table', 'rows:[5,6,7,8,9,10,11,12,13,14],columns:[1 - 1|Data]')
select_menu('Edit>>Change Layout')
### select('Table', 'rows:[5,6,7,8,9,10,11,12,13,14],columns:[1 - 1|Data]')
### select('ComboBox2', 'ams PO Download')
select('ComboBox2', 'ams Store')
click('Go')
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Table:')
## select('Table', '')
rightclick('Table', '10 - 35|Loc Name,5')
select_menu('Edit Record')
select('Table', 'cell:Data,2(ST)')
assert_p(
'Table', 'Content',
'[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5019, 5019], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Penrith, Penrith], [Loc Addr Ln1, 45, 40, Penrith, Penrith], [Loc Addr Ln2, 85, 40, 58 Leland Street, 58 Leland Street], [Loc Addr Ln3, 125, 35, Penrith, Penrith], [Loc Postcode, 160, 10, 2750, 2750], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]'
)
select('Table', 'cell:Data,2(ST)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Record:')
select('Table', 'cell:Data,3(Blacktown)')
assert_p(
'Table', 'Content',
'[[Brand Id, 1, 3, TAR, TAR, 544152], [Loc Nbr, 4, 4, 5033, 5033, 35303333], [Loc Type, 8, 2, ST, ST, 5354], [Loc Name, 10, 35, Blacktown, Blacktown, 426c61636b746f776e2020202020202020202020202020202020202020202020202020], [Loc Addr Ln1, 45, 40, Marayong, Marayong, 4d617261796f6e672020202020202020202020202020202020202020202020202020202020202020], [Loc Addr Ln2, 85, 40, Dock 2, 11 Melissa Place, Dock 2, 11 Melissa Place, 446f636b20322c203131204d656c6973736120506c61636520202020202020202020202020202020], [Loc Addr Ln3, 125, 35, Marayong, Marayong, 4d617261796f6e67202020202020202020202020202020202020202020202020202020], [Loc Postcode, 160, 10, 2148, 2148, 32313438202020202020], [Loc State, 170, 3, NSW, NSW, 4e5357], [Loc Actv Ind, 173, 1, A, A, 41]]'
)
#### assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR, 544152], [Loc Nbr, 4, 4, 5033, 5033, 35303333], [Loc Type, 8, 2, ST, ST, 5354], [Loc Name, 10, 35, Blacktown, Blacktown, 426c61636b746f776e2020202020202020202020202020202020202020202020202020], [Loc Addr Ln1, 45, 40, Marayong, Marayong, 4d617261796f6e672020202020202020202020202020202020202020202020202020202020202020], [Loc Addr Ln2, 85, 40, Dock 2, 11 Melissa Place, Dock 2, 11 Melissa Place, 446f636b20322c203131204d656c6973736120506c61636520202020202020202020202020202020], [Loc Addr Ln3, 125, 35, Marayong, Marayong, 4d617261796f6e67202020202020202020202020202020202020202020202020202020], [Loc Postcode, 160, 10, 2148, 2148, 32313438202020202020], [Loc State, 170, 3, NSW, NSW, 4e5357], [Loc Actv Ind, 173, 1, A, A, 41]]')
select('Table', 'cell:Data,3(Blacktown)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Table:1')
assert_p(
'Table', 'Content',
'[[TAR, 5019, ST, Penrith, Penrith, 58 Leland Street, Penrith, 2750, NSW, A], [TAR, 5033, ST, Blacktown, Marayong, Dock 2, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5035, ST, Rockdale, Building B, Portside DC, 2-8 Mc Pherson Street, Botany, 2019, NSW, A], [TAR, 5037, ST, Miranda, Westfield Shoppingtown, Cnr. Urunga Pde & The Kingsway, Miranda, 2228, NSW, A], [TAR, 5052, ST, Eastwood, Marayong Offsite Reserve, 11 Melissa Place, Marayong, 2148, NSW, A], [TAR, 5055, ST, Leichhardt, Marketown, Marion Street, Leichhardt, 2040, NSW, A], [TAR, 5060, ST, St Marys, St. Mary\'s, Charles Hackett Drive, St Mary\'s, 2760, NSW, A], [TAR, 5070, ST, Bass Hill, Bass Hill Plaza, 753 Hume Highway, Bass Hill, 2197, NSW, A], [TAR, 5074, ST, Campbelltown, Campbelltown Mall, 303 Queen Street, Campbelltown, 2560, NSW, A], [TAR, 5078, ST, Warringah Mall, Frenchs Forest, Units 2-3, 14 Aquatic Drive, Frenchs Forest, 2086, NSW, A]]'
)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu('Window>>Unknown_Ams_LocDownload_20041228.txt>>Record:')
assert_p(
'Table', 'Content',
'[[Brand Id, 1, 3, TAR, TAR, 544152], [Loc Nbr, 4, 4, 5070, 5070, 35303730], [Loc Type, 8, 2, ST, ST, 5354], [Loc Name, 10, 35, Bass Hill, Bass Hill, 426173732048696c6c2020202020202020202020202020202020202020202020202020], [Loc Addr Ln1, 45, 40, Bass Hill Plaza, Bass Hill Plaza, 426173732048696c6c20506c617a6120202020202020202020202020202020202020202020202020], [Loc Addr Ln2, 85, 40, 753 Hume Highway, 753 Hume Highway, 3735332048756d652048696768776179202020202020202020202020202020202020202020202020], [Loc Addr Ln3, 125, 35, Bass Hill, Bass Hill, 426173732048696c6c2020202020202020202020202020202020202020202020202020], [Loc Postcode, 160, 10, 2197, 2197, 32313937202020202020], [Loc State, 170, 3, NSW, NSW, 4e5357], [Loc Actv Ind, 173, 1, A, A, 41]]'
)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
from Modules import commonBits
click('Choose File')
if window('Open'):
select(commonBits.selectPane(), 'utf8a_Ams_LocDownload_20041228.txt')
click('Open')
close()
commonBits.setRecordLayout(select, 'utf8_ams Store')
click('Edit1')
select('Table', 'cell:4 - 4|Loc Nbr,0(5839)')
rightclick('Table', '4 - 4|Loc Nbr,4')
select_menu('Edit Record')
select('Table', 'cell:Data,3(Bankstown)')
## assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
if commonBits.isMissingCol():
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW]]')
else:
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5015, 5015], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Bankstown, Bankstown], [Loc Addr Ln1, 45, 40, Bankstown, Bankstown], [Loc Addr Ln2, 85, 40, Unit 2, 39-41 Allingham Street, Unit 2, 39-41 Allingham Street], [Loc Addr Ln3, 125, 35, Condell Park, Condell Park], [Loc Postcode, 160, 10, 2200, 2200], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:Data,3(Bankstown)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Choose File')
if window('Open'):
select(commonBits.selectPane(), 'utf8a_Ams_PODownload_20041231.txt')
click('Open')
close()
commonBits.setRecordLayout(select, 'utf8_ams PO Download')
commonBits.doEdit(click)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Choose File')
if window('Open'):
select(commonBits.selectPane(), 'utf8a_Ams_LocDownload_20041228.txt')
click('Open')
close()
##assert_p('ComboBox2', 'Text', 'ams Store')
click('Edit1')
select('Table', 'cell:4 - 4|Loc Nbr,0(5839)')
rightclick('Table', '10 - 35|Loc Name,5')
select_menu('Edit Record')
select('Table', 'cell:Data,4(Penrith)')
assert_p('Table', 'Text', 'Penrith', 'Data,4')
select('Table', 'cell:Data,4(Penrith)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
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() + 'zzAms_PODownload_20041231.txt')
#click('Choose File')
#if window('Open'):
# keystroke('File Name', 'Enter')
# select('FilePane$3', 'zzAms_PODownload_20041231.txt')
# click('Open')
#close()
## select('ComboBox1', 'Ams')
commonBits.setRecordLayout(select, 'zzAms PO Download')
commonBits.doEdit(click)
click('Filter')
click('Filter1')
## ---
select('LayoutCombo', 'ams PO Download: Header')
select('Table', 'cell:3 - 5|Sequence Number,1(45.350)')
assert_p('Table', 'Text', '45.351', '3 - 5|Sequence Number,2')
select('Table', 'cell:3 - 5|Sequence Number,1(45.350)')
assert_p('Table', 'RowCount', '8')
select('Table', 'cell:1 - 2|Record Type,2(H1)')
rightclick('Table', '1 - 2|Record Type,2')
select_menu('Edit Record')
## select('Table1', 'cell:1 - 2|Record Type,2(H1)')
select('Table', 'cell:Data,3(222243)')
assert_p('Table', 'Text', '222243', 'Data,3')
select('Table', 'cell:Data,9(050102)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.351, 45351], [Vendor, 8, 10, 6228, 0000006228], [PO, 18, 12, 222243, 000000222243], [Entry Date, 30, 6, 040909, 040909], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050102, 050102], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNI, LADIES KNI], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select('Table', 'cell:Data,9(050102)')
click('Right')
select('Table', 'cell:Data,1(45.352)')
assert_p('Table', 'Text', '5341', 'Data,2')
select('Table', 'cell:Data,1(45.352)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.352, 45352], [Vendor, 8, 10, 5341, 0000005341], [PO, 18, 12, 294915, 294915], [Entry Date, 30, 6, 041013, 041013], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 475, 475], [Expected Reciept Date, 52, 6, 041231, 041231], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, P, P], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, WOMENS SHO, WOMENS SHO], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select('Table', 'cell:Data,1(45.352)')
click('Right')
select('Table', 'cell:Data,3(294987)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.353, 45353], [Vendor, 8, 10, 5341, 0000005341], [PO, 18, 12, 294987, 294987], [Entry Date, 30, 6, 041013, 041013], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 475, 475], [Expected Reciept Date, 52, 6, 041231, 041231], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, P, P], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, WOMENS SHO, WOMENS SHO], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select('Table', 'cell:Data,3(294987)')
click('Right')
select('Table', 'cell:Data,3(295139)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.354, 45354], [Vendor, 8, 10, 5341, 0000005341], [PO, 18, 12, 295139, 295139], [Entry Date, 30, 6, 041013, 041013], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 475, 475], [Expected Reciept Date, 52, 6, 041231, 041231], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, P, P], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, WOMENS SHO, WOMENS SHO], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
commonBits.setRecordLayout(select, 'DTAR020')
click('Edit1')
select(
'Table',
'rows:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30],columns:[9 - 2|STORE-NO,11 - 4|DATE]'
)
select_menu('View>>Field Based Tree')
## select('Table1', 'rows:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30],columns:[9 - 2|STORE-NO,11 - 4|DATE]')
## select('List', 'DTAR020')
select('ComboBox', 'Selected Records')
select('Table', 'STORE-NO', 'Field,0')
select('Table', 'DEPT-NO', 'Field,1')
select('Table', 'cell:Field,1(DEPT-NO)')
click('Build Tree')
select('JTreeTable', 'cell:KEYCODE-NO,1(null)')
assert_p('JTreeTable', 'RowCount', '3')
select('JTreeTable', 'cell:KEYCODE-NO,1(null)')
rightclick('JTreeTable', 'KEYCODE-NO,2')
select_menu('Expand Tree')
select('JTreeTable', 'cell:Tree,3(null)')
assert_p('JTreeTable', 'RowCount', '6')
select('JTreeTable', 'cell:Tree,3(null)')
rightclick('JTreeTable', 'Tree,4')
select('JTreeTable', 'cell:Tree,4(null)')
rightclick('JTreeTable', 'Tree,4')
select_menu('Expand Tree')
select('JTreeTable', 'cell:KEYCODE-NO,5(69644164)')
assert_p(
'JTreeTable', 'Content',
'[[, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , 69644164, 166, 40118, 193, 1, 21.59], [, , , , , , , ]]'
)
select('JTreeTable', 'cell:Tree,3(null)')
rightclick('JTreeTable', 'Tree,3')
select_menu('Expand Tree')
select('JTreeTable', 'cell:KEYCODE-NO,4(69694814)')
assert_p(
'JTreeTable', 'Content',
'[[, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , 69694814, 166, 40118, 360, 1, 2.50], [, , 69694814, 166, 40118, 360, 1, 2.50], [, , , , , , , ], [, , 69644164, 166, 40118, 193, 1, 21.59], [, , , , , , , ]]'
)
select('JTreeTable', 'cell:KEYCODE-NO,1(null)')
rightclick('JTreeTable', 'KEYCODE-NO,1')
select_menu('Expand Tree')
select('JTreeTable', 'cell:KEYCODE-NO,4(null)')
assert_p('JTreeTable', 'RowCount', '18')
select('JTreeTable', 'cell:KEYCODE-NO,5(null)')
rightclick('JTreeTable', 'KEYCODE-NO,5')
select_menu('Expand Tree')
select('JTreeTable', 'cell:KEYCODE-NO,6(60614487)')
assert_p(
'JTreeTable', 'Content',
'[[, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , 60614487, 59, 40118, 878, 1, 5.95], [, , 63644339, 59, 40118, 878, 1, 12.65], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , 69694814, 166, 40118, 360, 1, 2.50], [, , 69694814, 166, 40118, 360, 1, 2.50], [, , , , , , , ], [, , 69644164, 166, 40118, 193, 1, 21.59], [, , , , , , , ]]'
)
select('JTreeTable', 'cell:KEYCODE-NO,13(null)')
rightclick('JTreeTable', 'KEYCODE-NO,13')
select_menu('Collapse Tree')
select('JTreeTable', 'cell:KEYCODE-NO,7(63644339)')
assert_p('JTreeTable', 'RowCount', '14')
select('JTreeTable', 'cell:Tree,10(null)')
rightclick('JTreeTable', 'KEYCODE-NO,10')
select_menu('Expand Tree')
select('JTreeTable', 'cell:KEYCODE-NO,11(67674686)')
assert_p(
'JTreeTable', 'Content',
'[[, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , 60614487, 59, 40118, 878, 1, 5.95], [, , 63644339, 59, 40118, 878, 1, 12.65], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ], [, , 67674686, 59, 40118, 929, 1, 3.99], [, , , , , , , ], [, , , , , , , ], [, , , , , , , ]]'
)
select('JTreeTable', 'cell:KEYCODE-NO,10(null)')
rightclick('JTreeTable', 'KEYCODE-NO,10')
select_menu('Collapse Tree')
select('JTreeTable', 'cell:KEYCODE-NO,9(null)')
assert_p('JTreeTable', 'RowCount', '14')
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')
click('Right')
select('TabbedPane', '')
select('FileChooser', commonBits.sampleDir() + 'XfeReverseDTAR020.txt')
## select('ComboBox1', 'Other')
## select('ComboBox2', 'XfeDTAR020_reverse')
commonBits.setRecordLayout(select, 'XfeDTAR020_reverse')
click('Right')
select('TabbedPane', '')
select('Table1', 'cell:Field,3(DEPT-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:Record,0(DTAR020)')
select('Table', 'cell:Record,0(DTAR020)')
assert_p('Table', 'Content', '[[DTAR020, XfeDTAR020_reverse]]')
# assert_p('Table', 'Content', '[[DTAR020, ]]')
select('Table', 'cell:Record,0(DTAR020)')
click('Right')
select('TabbedPane', '')
click('Copy2')
assert_p('TextField1', 'Text', 'Copy Done !!! ')
click('Open')
select('FileChooser', commonBits.sampleDir() + 'XfeReverseDTAR020.txt')
## select('ComboBox2', 'XML - Build Layout')
commonBits.setRecordLayout(select, 'XfeDTAR020_reverse')
## select('ComboBox2', 'XfeDTAR020_reverse')
commonBits.doEdit(click)
select('Table', 'cell:2|SALE-PRICE,0(19.00)')
assert_p('Table', 'Text', '19.00', '2|SALE-PRICE,0')
select('Table', 'cell:2|SALE-PRICE,1(-19.00)')
assert_p('Table', 'RowCount', '379')
select('Table', 'cell:2|SALE-PRICE,3(19.00)')
assert_p(
'Table', 'Content',
'[[1, 19.00, 280, 40118, 20, 69684558], [-1, -19.00, 280, 40118, 20, 69684558], [1, 5.01, 280, 40118, 20, 69684558], [1, 19.00, 280, 40118, 20, 69694158], [-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], [1, 3.99, 620, 40118, 59, 60664659], [1, 9.99, 957, 40118, 59, 62684217], [1, 3.99, 929, 40118, 59, 67674686], [1, 12.99, 335, 40118, 59, 61684613], [1, 2.59, 957, 40118, 59, 64624770], [1, 2.50, 360, 40118, 166, 69694814], [1, 2.50, 360, 40118, 166, 69694814], [1, 21.59, 193, 40118, 166, 69644164], [1, 13.99, 375, 40118, 166, 62684907], [1, 13.99, 375, 40118, 166, 62694193], [-1, -13.99, 375, 40118, 166, 62694193], [1, 11.99, 375, 40118, 166, 62694193], [1, 13.99, 320, 40118, 166, 63654450], [1, 9.72, 320, 40118, 166, 62664576], [1, 5.59, 320, 40118, 166, 63634260], [1, 14.99, 440, 40118, 166, 64684534], [1, 19.99, 235, 40118, 166, 64674965], [-1, -19.99, 235, 40118, 166, 64674965], [1, 12.00, 235, 40118, 166, 64674965], [1, 12.00, 261, 40118, 166, 60624523], [1, 3.49, 957, 40118, 166, 66624253], [1, 3.49, 957, 40118, 166, 66624253], [1, 3.99, 957, 40118, 166, 64654284], [1, 5.50, 805, 40118, 166, 60684907], [1, 10.99, 870, 40118, 166, 63624299], [1, 11.19, 870, 40118, 166, 63624367], [1, 14.99, 475, 40118, 166, 62694575], [1, 6.99, 905, 40118, 166, 69614011], [1, 9.99, 650, 40118, 166, 62634996], [1, 24.99, 970, 40118, 166, 67634503], [1, 19.95, 830, 40118, 166, 65604476], [1, 16.99, 851, 40118, 166, 62694170], [1, 1.98, 410, 40118, 166, 63684098], [1, 1.98, 410, 40118, 166, 63684098], [1, 1.98, 410, 40118, 166, 63684098], [1, 29.99, 485, 40118, 166, 64674609], [1, 14.99, 366, 40118, 166, 62614014], [1, 9.06, 432, 40118, 166, 61694741], [1, 9.09, 432, 40118, 166, 62614534], [1, 29.62, 801, 40118, 166, 64604876], [1, 1.99, 957, 40118, 166, 66624829], [1, 13.59, 193, 40118, 166, 62694843], [1, 19.00, 265, 40118, 166, 62684580], [1, 3.29, 957, 40118, 166, 62664909], [1, 1.99, 957, 40118, 166, 62674751], [1, 1.49, 957, 40118, 166, 62674492], [1, 1.49, 957, 40118, 166, 62674492], [1, 13.59, 193, 40118, 166, 62694706], [1, 19.00, 265, 40118, 166, 69644602], [1, 12.00, 270, 40118, 166, 63634768], [1, 19.00, 265, 40118, 166, 62684207], [1, 9.60, 230, 40118, 166, 69644961], [1, 29.95, 250, 40118, 166, 69604743], [1, 3.89, 929, 40118, 166, 63634081], [1, 15.95, 902, 40118, 166, 69614229], [1, 5.95, 845, 40118, 166, 62654454], [1, 3.90, 845, 40118, 166, 64634712], [1, 15.99, 851, 40118, 166, 62674092], [1, 0.89, 929, 40118, 166, 67664966], [1, 0.89, 929, 40118, 166, 67664966], [1, 15.99, 220, 40118, 166, 64674633], [1, 26.24, 280, 40118, 166, 64624081], [1, 10.49, 910, 40118, 166, 69674069], [1, 29.99, 520, 40118, 166, 62684028], [1, 29.62, 801, 40118, 166, 64604876], [1, 12.50, 902, 40118, 166, 68644966], [-1, -12.50, 902, 40118, 166, 68644966], [1, 0.01, 902, 40118, 166, 68644966], [1, 8.99, 370, 40118, 166, 62664347], [1, 8.99, 370, 40118, 166, 62664231], [1, 25.00, 261, 40118, 166, 62694605], [1, 19.00, 261, 40118, 166, 69634922], [1, 11.49, 904, 40118, 166, 63694928], [1, 8.99, 500, 40118, 166, 60624185], [1, 8.99, 500, 40118, 166, 60624314], [1, 11.99, 270, 40118, 166, 69694959], [1, 18.19, 80, 40118, 166, 69624033], [1, 17.56, 193, 40118, 166, 62694485], [1, 6.00, 60, 40118, 166, 60614646], [1, 24.99, 275, 40118, 166, 63654066], [1, 39.99, 415, 40118, 166, 62684548], [1, 39.99, 415, 40118, 166, 62684548], [1, 6.99, 360, 40118, 166, 69694685], [1, 27.99, 395, 40118, 166, 63614741], [1, 9.00, 270, 40118, 166, 60664302], [1, 9.00, 270, 40118, 166, 60664241], [1, 4.50, 360, 40118, 166, 66674979], [1, 11.89, 355, 40118, 166, 62634862], [1, 7.99, 335, 40118, 166, 62604139], [1, 18.98, 370, 40118, 166, 62624382], [-1, -18.98, 370, 40118, 166, 62624382], [1, 2.50, 360, 40118, 166, 69694937], [1, 18.98, 370, 40118, 166, 62624382], [1, 18.98, 370, 40118, 166, 62624382], [-1, -18.98, 370, 40118, 166, 62624382], [-1, -18.98, 370, 40118, 166, 62624382], [1, 18.98, 370, 40118, 166, 62624382], [1, 18.98, 370, 40118, 166, 62624382], [1, 4.49, 685, 40118, 166, 61684889], [1, 3.99, 370, 40118, 166, 68614651], [1, 24.99, 471, 40118, 166, 62664674], [1, 4.49, 685, 40118, 166, 61684889], [1, 0.65, 929, 40118, 166, 60694417], [1, 0.59, 929, 40118, 166, 65694328], [1, 16.99, 320, 40118, 166, 63684449], [1, 20.00, 405, 40118, 166, 62614815], [1, 25.00, 455, 40118, 166, 62664151], [1, 9.99, 410, 40118, 166, 64684719], [1, 6.00, 60, 40118, 166, 69654084], [1, 5.08, 60, 40118, 166, 69644897], [1, 5.08, 60, 40118, 166, 68654655], [1, 5.99, 170, 40118, 166, 68674560], [1, 7.99, 432, 40118, 166, 62694387], [1, 5.99, 432, 40118, 166, 62664568], [1, 12.00, 261, 40118, 166, 69634261], [1, 12.00, 261, 40118, 166, 69634660], [1, 22.49, 280, 40118, 166, 69684947], [1, 4.33, 905, 40118, 166, 60654072], [1, 4.33, 905, 40118, 166, 60654072], [1, 16.99, 355, 40118, 166, 69624221], [1, 19.99, 355, 40118, 166, 62654800], [1, 29.65, 801, 40118, 166, 64644495], [1, 1.39, 929, 40118, 166, 67664645], [1, 15.99, 395, 40118, 166, 60614265], [1, 15.99, 905, 40118, 166, 68604583], [1, 15.99, 395, 40118, 166, 60614265], [-1, -15.99, 395, 40118, 166, 60614265], [-1, -15.99, 395, 40118, 166, 60614265], [-1, -15.99, 905, 40118, 166, 68604583], [1, 15.99, 905, 40118, 166, 68604583], [-1, -15.99, 905, 40118, 166, 68604583], [1, 12.80, 905, 40118, 166, 68604583], [1, 15.99, 395, 40118, 166, 60614265], [-1, -15.99, 395, 40118, 166, 60614265], [1, 12.80, 395, 40118, 166, 60614265], [1, 14.95, 904, 40118, 166, 69664661], [1, 11.19, 193, 40118, 166, 68664211], [1, 6.00, 60, 40118, 166, 60614707], [1, 16.99, 235, 40118, 166, 64604513], [1, 15.00, 261, 40118, 166, 60624864], [1, 9.00, 261, 40118, 166, 69644909], [1, 13.30, 80, 40118, 166, 60604100], [1, 25.00, 261, 40118, 166, 69634263], [-1, -25.00, 261, 40118, 166, 69634263], [1, 12.00, 261, 40118, 166, 69634263], [1, 3.99, 670, 40118, 166, 61674701], [1, 56.99, 670, 40118, 166, 63654007], [1, 16.50, 801, 40118, 166, 67624103], [1, 39.99, 905, 40118, 166, 68614329], [1, 23.96, 193, 40118, 166, 67644384], [1, 29.65, 801, 40118, 166, 64644495], [1, 9.00, 220, 40118, 184, 60684484], [1, 9.00, 220, 40118, 184, 60684484], [1, 4.99, 905, 40118, 184, 67674299], [1, 11.89, 355, 40118, 184, 69664620], [-1, -11.89, 355, 40118, 184, 69664620], [1, 9.09, 355, 40118, 184, 69664620], [-1, -15.00, 275, 40118, 184, 60674210], [-1, -4.80, 60, 40118, 184, 60664048], [-1, -4.80, 60, 40118, 184, 60614866], [-1, -4.80, 60, 40118, 184, 60664048], [-1, -4.80, 60, 40118, 184, 60664048], [-1, -4.80, 60, 40118, 184, 60614866], [1, 12.99, 70, 40118, 184, 69654081], [1, 16.79, 193, 40118, 184, 63664643], [1, 12.99, 70, 40118, 184, 69654135], [1, 9.09, 160, 40118, 184, 60644672], [-1, -19.59, 345, 40118, 184, 62654852], [-1, -16.00, 490, 40118, 184, 62674960], [1, 16.00, 490, 40118, 184, 62674960], [1, 2.69, 929, 40118, 184, 65674126], [1, 24.99, 500, 40118, 184, 60634192], [-1, -9.99, 957, 40118, 184, 64634500], [1, 2.00, 170, 40118, 184, 66624803], [-1, -2.00, 170, 40118, 184, 66624803], [1, 1.04, 170, 40118, 184, 66624803], [1, 2.00, 170, 40118, 184, 66624889], [-1, -2.00, 170, 40118, 184, 66624889], [1, 1.04, 170, 40118, 184, 66624889], [1, 34.99, 500, 40118, 184, 60624241], [1, 9.99, 650, 40118, 184, 62644079], [-1, -20.99, 320, 40118, 184, 62664183], [-1, -25.99, 320, 40118, 184, 64654047], [-1, -10.39, 375, 40118, 184, 62694327], [-1, -19.00, 275, 40118, 184, 69604894], [-1, -14.99, 60, 40118, 184, 67644821], [1, 16.99, 60, 40118, 184, 67644118], [1, 3.09, 901, 40118, 184, 66664981], [1, 12.99, 901, 40118, 184, 66684899], [1, 15.99, 270, 40118, 184, 64634942], [1, 19.00, 275, 40118, 184, 63654826], [-1, -14.39, 220, 40118, 184, 69604993], [-1, -15.00, 250, 40118, 184, 63624118], [-1, -29.99, 475, 40118, 184, 62684517], [1, 24.99, 970, 40118, 184, 67634503], [-1, -16.99, 193, 40118, 184, 62694782], [-1, -16.99, 193, 40118, 184, 62694683], [-1, -16.99, 193, 40118, 184, 62694782], [-1, -16.99, 193, 40118, 184, 62694782], [1, 14.00, 310, 40118, 184, 62684096], [1, 19.19, 193, 40118, 184, 69644199], [1, 7.99, 904, 40118, 184, 60634366], [1, 23.00, 70, 40118, 184, 67654448], [-1, -23.00, 70, 40118, 184, 67654448], [1, 19.01, 70, 40118, 184, 67654448], [1, 5.08, 60, 40118, 184, 69654459], [1, 5.08, 60, 40118, 184, 60664779], [-1, -29.99, 310, 40118, 184, 63674002], [-1, -19.99, 870, 40118, 184, 68604041], [1, 24.99, 970, 40118, 184, 67634503], [-1, -10.39, 60, 40118, 184, 68644941], [-1, -10.39, 60, 40118, 184, 68644941], [-1, -10.39, 60, 40118, 184, 68644941], [-1, -10.39, 60, 40118, 184, 68644941], [1, 10.39, 60, 40118, 184, 68644934], [-1, -8.99, 350, 40118, 184, 62674884], [1, 14.95, 235, 40118, 184, 68654381], [1, 24.99, 801, 40118, 184, 64644433], [-1, -29.99, 805, 40118, 184, 64604829], [1, 9.99, 650, 40118, 184, 62634996], [1, 0.95, 670, 40118, 184, 60624270], [1, 1.59, 929, 40118, 184, 63664932], [1, 9.99, 851, 40118, 184, 69684804], [-1, -29.95, 415, 40118, 184, 68664363], [1, 2.99, 929, 40118, 184, 62694503], [1, 24.99, 590, 40118, 184, 62644205], [1, 24.89, 590, 40118, 184, 62604912], [1, 4.29, 904, 40118, 184, 64634802], [1, 2.12, 901, 40118, 184, 60664257], [-1, -19.95, 878, 40118, 184, 62684043], [1, 19.95, 878, 40118, 184, 62684043], [-1, -3.95, 805, 40118, 184, 64644860], [-1, -22.99, 590, 40118, 184, 62644590], [-1, -16.99, 432, 40118, 184, 64664587], [-1, -35.95, 801, 40118, 184, 64604930], [1, 9.00, 250, 40118, 184, 60604880], [1, 2.00, 845, 40118, 184, 68674372], [1, 2.00, 845, 40118, 184, 63684755], [1, 9.99, 929, 40118, 184, 64684439], [1, 0.98, 940, 40118, 184, 67624120], [-1, -0.98, 940, 40118, 184, 67624120], [1, 0.49, 940, 40118, 184, 67624120], [1, 0.98, 940, 40118, 184, 67624120], [-1, -0.98, 940, 40118, 184, 67624120], [1, 0.49, 940, 40118, 184, 67624120], [1, 1.23, 940, 40118, 184, 66614192], [-1, -1.23, 940, 40118, 184, 66614192], [1, 0.69, 940, 40118, 184, 66614192], [1, 1.23, 940, 40118, 184, 66614192], [-1, -1.23, 940, 40118, 184, 66614192], [1, 0.69, 940, 40118, 184, 66614192], [1, 0.50, 940, 40118, 184, 67624473], [-1, -0.50, 940, 40118, 184, 67624473], [1, 0.19, 940, 40118, 184, 67624473], [-1, -19.95, 875, 40118, 184, 67614923], [-1, -6.99, 432, 40118, 184, 63604715], [-1, -6.99, 432, 40118, 184, 63604715], [-1, -6.99, 432, 40118, 184, 63604715], [1, 14.00, 310, 40118, 184, 62684102], [1, 4.95, 805, 40118, 184, 63654091], [-1, -16.99, 855, 40118, 184, 68694729], [1, 9.59, 220, 40118, 184, 60684563], [1, 13.99, 80, 40118, 184, 68664957], [1, 21.00, 801, 40118, 184, 67604116], [1, 22.99, 801, 40118, 184, 64664047], [1, 24.99, 970, 40118, 184, 67634497], [1, 3.19, 929, 40118, 184, 64664270], [-1, -14.99, 160, 40118, 184, 60634150], [-1, -249.00, 878, 40118, 184, 68684135], [1, 269.00, 878, 40118, 184, 68684135], [-1, -269.00, 878, 40118, 184, 68684135], [1, 249.00, 878, 40118, 184, 68684135], [-1, -26.21, 235, 40118, 184, 69624909], [-1, -6.89, 530, 40118, 184, 62634962], [-1, -9.95, 160, 40118, 184, 67614726], [-1, -4.50, 170, 40118, 184, 68654094], [1, 19.95, 485, 40118, 184, 60674335], [-1, -19.95, 485, 40118, 184, 60674335], [1, 12.99, 485, 40118, 184, 60674335], [1, 0.89, 929, 40118, 184, 60644305], [1, 6.99, 366, 40118, 184, 64604604], [1, 19.00, 290, 40118, 184, 63694367], [1, 9.99, 650, 40118, 184, 62644079], [1, 1.89, 929, 40118, 184, 67674119], [1, 19.00, 265, 40118, 184, 69614627], [1, 19.00, 265, 40118, 184, 69614740], [-1, -14.25, 230, 40118, 184, 60614135], [1, 19.99, 970, 40118, 184, 69674452], [1, 2.49, 957, 40118, 184, 62694272], [1, 9.95, 902, 40118, 184, 69614274], [1, 25.00, 290, 40118, 184, 60634379], [1, 19.00, 261, 40118, 184, 60674904], [-1, -15.99, 670, 40118, 184, 66614582], [1, 4.95, 805, 40118, 184, 64654096], [1, 29.99, 405, 40118, 184, 62634605], [1, 2.99, 929, 40118, 184, 69694354], [1, 20.99, 80, 40118, 184, 69634699], [1, 20.99, 80, 40118, 184, 69634712], [-1, -27.95, 250, 40118, 184, 69664171], [1, 14.99, 280, 40118, 184, 69694479], [-1, -5.50, 929, 40118, 184, 63634656], [-1, -5.99, 903, 40118, 184, 69664149], [-1, -1.39, 903, 40118, 184, 69664163], [-1, -19.95, 901, 40118, 184, 67674341], [1, 18.74, 230, 40118, 184, 69644053], [1, 164.00, 957, 40118, 184, 63674184], [1, 69.99, 870, 40118, 184, 62604338], [1, 10.99, 432, 40118, 184, 62644344], [1, 10.99, 432, 40118, 184, 66644706], [1, 10.99, 432, 40118, 184, 62644528], [1, 10.99, 432, 40118, 184, 62644764], [1, 11.00, 405, 40118, 184, 62664135], [1, 11.00, 405, 40118, 184, 62664244], [1, 11.00, 405, 40118, 184, 62664197], [1, 39.99, 471, 40118, 184, 62654875], [1, 34.99, 265, 40118, 184, 64614653], [1, 34.99, 265, 40118, 184, 64614653], [1, 14.99, 650, 40118, 184, 61694023], [1, 14.99, 650, 40118, 184, 61694023], [1, 2.00, 998, 40118, 184, 60694909], [1, 12.99, 70, 40118, 184, 68614241], [1, 6.00, 60, 40118, 184, 69654638], [1, 17.59, 60, 40118, 184, 67634923], [1, 22.99, 70, 40118, 184, 64614285], [1, 17.59, 193, 40118, 184, 69644389], [1, 27.99, 70, 40118, 184, 68614787], [1, 29.99, 70, 40118, 184, 69644337], [1, 27.99, 70, 40118, 184, 68634061], [1, 15.99, 193, 40118, 184, 69644184], [1, 21.00, 801, 40118, 184, 63624756], [1, 21.00, 801, 40118, 184, 67604116], [1, 27.99, 193, 40118, 184, 68654451], [1, 19.19, 193, 40118, 184, 62614172], [1, 49.99, 620, 40118, 184, 61614174], [1, 29.99, 620, 40118, 184, 61614174], [1, 69.95, 801, 40118, 184, 62644445], [1, 149.00, 905, 40118, 184, 62634323], [1, 3.95, 901, 40118, 184, 66674079], [1, 3.95, 901, 40118, 184, 66674130], [1, 12.50, 902, 40118, 184, 61604095], [1, 14.95, 902, 40118, 184, 66664028], [1, 12.95, 902, 40118, 184, 68654621], [1, 19.95, 830, 40118, 184, 63694264], [1, 3.99, 901, 40118, 184, 63604361], [1, 6.69, 901, 40118, 184, 62634259], [1, 6.69, 901, 40118, 184, 62634259], [1, 4.89, 904, 40118, 184, 60684429], [1, 9.95, 904, 40118, 184, 60684037], [1, 19.95, 904, 40118, 184, 69694875], [1, 19.95, 904, 40118, 184, 69694875], [1, 19.95, 904, 40118, 184, 69694875], [-1, -19.95, 904, 40118, 184, 69694875], [-1, -19.95, 904, 40118, 184, 69694875], [-1, -19.95, 904, 40118, 184, 69694875], [1, 3.95, 901, 40118, 184, 63604108], [1, 11.49, 904, 40118, 184, 63694928], [1, 4.99, 904, 40118, 184, 60634765], [1, 8.95, 903, 40118, 184, 69664668]]'
)
select('Table', 'cell:2|SALE-PRICE,3(19.00)')
rightclick('Table', '1|QTY-SOLD,1')
select('Table', 'cell:1|QTY-SOLD,1(-1)')
rightclick('Table', '1|QTY-SOLD,1')
select_menu('Edit Record')
## select('Table1', 'cell:1|QTY-SOLD,1(-1)')
select('Table', 'cell:Data,1(-19.00)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , -1, -1], [SALE-PRICE, 2, , -19.00, -19.00], [DEPT-NO, 3, , 280, 280], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 20, 20], [KEYCODE-NO, 6, , 69684558, 69684558]]'
)
select('Table', 'cell:Data,1(-19.00)')
click('HexThreeLineField')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''-1þ-19.00þ280þ40118þ20þ69684558
23f233233f333f33333f33f33333333
d1ed19e00e280e40118e20e69684558''')
click('Right')
select('Table', 'cell:Data,1(5.01)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 5.01, 5.01], [DEPT-NO, 3, , 280, 280], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 20, 20], [KEYCODE-NO, 6, , 69684558, 69684558]]'
)
select('Table', 'cell:Data,1(5.01)')
click('Right')
select('Table', 'cell:Data,2(280)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 19.00, 19.00], [DEPT-NO, 3, , 280, 280], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 20, 20], [KEYCODE-NO, 6, , 69694158, 69694158]]'
)
select('Table', 'cell:Data,2(280)')
click('Right')
select('Table', 'cell:Data,3(40118)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , -1, -1], [SALE-PRICE, 2, , -19.00, -19.00], [DEPT-NO, 3, , 280, 280], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 20, 20], [KEYCODE-NO, 6, , 69694158, 69694158]]'
)
select('Table', 'cell:Data,3(40118)')
click('HexThreeLineField')
assert_p(
'HexThreeLineField', 'Text', '''-1þ-19.00þ280þ40118þ20þ69694158
23f233233f333f33333f33f33333333
d1ed19e00e280e40118e20e69694158''')
click('Right')
select('Table', 'cell:Data,3(40118)')
assert_p(
'Table', 'Content',
'[[QTY-SOLD, 1, , 1, 1], [SALE-PRICE, 2, , 5.01, 5.01], [DEPT-NO, 3, , 280, 280], [DATE, 4, , 40118, 40118], [STORE-NO, 5, , 20, 20], [KEYCODE-NO, 6, , 69694158, 69694158]]'
)
select('Table', 'cell:Data,3(40118)')
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare Menu')
## select('Table', 'cell:Data,3(40118)')
click('*2')
select('FileChooser', commonBits.sampleDir() + 'DTAR020.bin')
click('Right')
select('TabbedPane', '')
select('FileChooser', commonBits.sampleDir() + 'XfeReverseDTAR020.txt')
click('Right')
## select('TabbedPane', '')
select('Table1', 'cell:Field,0(KEYCODE-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:Record,0(DTAR020)')
select('Table', 'cell:Record,0(DTAR020)')
assert_p('Table', 'Content', '[[DTAR020, XfeDTAR020_reverse]]')
## assert_p('Table', 'Content', '[[DTAR020, ]]')
select('Table', 'cell:Record,0(DTAR020)')
click('Right')
select('TabbedPane', '')
click('Compare')
assert_p('TextPane', 'Text', 'Files are Identical !!!')
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('*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_03'
if window('Record Editor'):
click(commonBits.fl('Choose File'))
if window('Open'):
select(commonBits.selectPane(), 'Ams_LocDownload_20041228.txt')
click('Open')
close()
commonBits.setRecordLayout(select, 'ams Store')
click(commonBits.fl('Edit') + '1')
select('Table', 'cell:1 - 3|Brand Id,2(TAR)')
rightclick('Table', '1 - 3|Brand Id,2')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:1 - 3|Brand Id,2(TAR)')
click('Find1')
## click('MetalInternalFrameTitlePane', 230, 8)
select('TextField', 'West')
select('TextField1', 'West_')
select('ComboBox', commonBits.fl('All Fields'))
click(commonBits.fl('Replace'))
## select('Table', '')
select('Table',
'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown)')
select('Table',
'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown)')
assert_p('Table', 'Text', 'West_field Shoppingtown',
commonBits.fl('Data') + ',4')
select('Table',
'cell:' + commonBits.fl('Data') + ',4(West_field Shoppingtown)')
## click('MetalInternalFrameTitlePane', 253, 21)
commonBits.findA(click)
## click('MetalInternalFrameTitlePane', 80, 17)
select('ComboBox', commonBits.fl('All Fields'))
commonBits.find(click)
assert_p('Table', 'Text', 'Westfield Phoenix Plaza',
commonBits.fl('Data') + ',4')
commonBits.find(click)
## click('MetalInternalFrameTitlePane', 80, 17)
select('ComboBox', commonBits.fl('All Fields'))
commonBits.find(click)
## click(commonBits.fl('Replace'))
## select('ComboBox', commonBits.fl('All Fields'))
click(commonBits.fl('Replace'))
select(
'Table',
'cell:' + commonBits.fl('Data') + ',4(West_field Phoenix Plaza)')
select(
'Table',
'cell:' + commonBits.fl('Data') + ',4(West_field Phoenix Plaza)')
## assert_p('Table', 'Text', 'West_field Phoenix Plaza', commonBits.fl('Data') + ',4')
select(
'Table',
'cell:' + commonBits.fl('Data') + ',4(West_field Phoenix Plaza)')
commonBits.find(click)
## click('MetalInternalFrameTitlePane', 80, 17)
select('ComboBox', commonBits.fl('All Fields'))
commonBits.find(click)
click(commonBits.fl('Replace'))
## select('Table', '')
select(
'Table', 'cell:' + commonBits.fl('Data') +
',4(West_field Shoppingtown Eastgardens)')
select(
'Table', 'cell:' + commonBits.fl('Data') +
',4(West_field Shoppingtown Eastgardens)')
## assert_p('Table', 'Text', '152 Bunnerong Road', commonBits.fl('Data') + ',5')
select(
'Table', 'cell:' + commonBits.fl('Data') +
',4(West_field Shoppingtown Eastgardens)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table', 'cell:1 - 3|Brand Id,2(TAR)')
select('Table', 'cell:1 - 3|Brand Id,2(TAR)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
# if window(r'Save Changes to file: ' + commonBits.implementationSampleDir() + 'Ams_LocDownload_20041228.txt'):
# click('No')
# close()
close()
def test():
set_java_recorded_version("1.6.0_22")
if frame(' - Open File:0'):
select('File', commonBits.sampleDir() + 'DTAR020_tst1.bin')
##select('Record Layout', 'DTAR020')
commonBits.setRecordLayout(select, 'DTAR020')
click('Edit')
close()
if window('Protocol Buffer Editor'):
select_menu('File>>Export as CSV file')
if frame('Export1 - DTAR020_tst1.bin:0'):
select('Delimiter', ';')
select('names on first line', 'true')
select('Edit Output File', 'true')
select('Keep screen open', 'true')
click('save file')
close()
if frame('Table: - DTAR020_tst1.bin.csv:0'):
select('JTable_22', 'rows:[6],columns:[2|Store_No]')
assert_content('JTable_22', [ ['63604808', '20', '40118', '170', '1', '4870'],
['69684558', '20', '40118', '280', '1', '19000'],
['69684558', '20', '40118', '280', '-1', '-19000'],
['69694158', '20', '40118', '280', '1', '5010'],
['62684671', '20', '40118', '685', '1', '69990'],
['62684671', '20', '40118', '685', '-1', '-69990'],
['61664713', '59', '40118', '335', '1', '17990'],
['61664713', '59', '40118', '335', '-1', '-17990'],
['61684613', '59', '40118', '335', '1', '12990'],
['68634752', '59', '40118', '410', '1', '8990'],
['60694698', '59', '40118', '620', '1', '3990'],
['60664659', '59', '40118', '620', '1', '3990'],
['60614487', '59', '40118', '878', '1', '5950'],
['68654655', '166', '40118', '60', '1', '5080'],
['69624033', '166', '40118', '80', '1', '18190'],
['60604100', '166', '40118', '80', '1', '13300'],
['68674560', '166', '40118', '170', '1', '5990']
])
select('JTable_22', 'rows:[6],columns:[2|Store_No]')
select('JTable_22', 'rows:[6],columns:[2|Store_No]')
select('Layouts', 'Full Line')
select('JTable_22', 'rows:[5],columns:[Full Line]')
assert_content('JTable_22', [ ['63604808;20;40118;170;1;4870'],
['69684558;20;40118;280;1;19000'],
['69684558;20;40118;280;-1;-19000'],
['69694158;20;40118;280;1;5010'],
['62684671;20;40118;685;1;69990'],
['62684671;20;40118;685;-1;-69990'],
['61664713;59;40118;335;1;17990'],
['61664713;59;40118;335;-1;-17990'],
['61684613;59;40118;335;1;12990'],
['68634752;59;40118;410;1;8990'],
['60694698;59;40118;620;1;3990'],
['60664659;59;40118;620;1;3990'],
['60614487;59;40118;878;1;5950'],
['68654655;166;40118;60;1;5080'],
['69624033;166;40118;80;1;18190'],
['60604100;166;40118;80;1;13300'],
['68674560;166;40118;170;1;5990']
])
select('JTable_22', 'rows:[5],columns:[Full Line]')
click('Close')
## select('JTable_22', '', '{5, Full Line}')
## select('JTable_22', 'rows:[5],columns:[Full Line]')
close()
if frame('Export1 - DTAR020_tst1.bin:0'):
select('JTable_29', 'false', '{1, Include}')
select('JTable_29', 'false', '{4, Include}')
# select('JTable_33', 'rows:[1],columns:[Include]')
# select('JTable_33', 'rows:[4],columns:[Include]')
click('save file')
close()
if frame('Table: - DTAR020_tst1.bin.csv:0'):
select('JTable_22', 'rows:[8],columns:[2|DATE]')
assert_content('JTable_22', [ ['63604808', '40118', '170', '4870'],
['69684558', '40118', '280', '19000'],
['69684558', '40118', '280', '-19000'],
['69694158', '40118', '280', '5010'],
['62684671', '40118', '685', '69990'],
['62684671', '40118', '685', '-69990'],
['61664713', '40118', '335', '17990'],
['61664713', '40118', '335', '-17990'],
['61684613', '40118', '335', '12990'],
['68634752', '40118', '410', '8990'],
['60694698', '40118', '620', '3990'],
['60664659', '40118', '620', '3990'],
['60614487', '40118', '878', '5950'],
['68654655', '40118', '60', '5080'],
['69624033', '40118', '80', '18190'],
['60604100', '40118', '80', '13300'],
['68674560', '40118', '170', '5990']
])
select('JTable_22', 'rows:[8],columns:[2|DATE]')
select('JTable_22', 'rows:[8],columns:[2|DATE]')
select('Layouts', 'Full Line')
select('JTable_22', 'rows:[6],columns:[Full Line]')
assert_content('JTable_22', [ ['63604808;40118;170;4870'],
['69684558;40118;280;19000'],
['69684558;40118;280;-19000'],
['69694158;40118;280;5010'],
['62684671;40118;685;69990'],
['62684671;40118;685;-69990'],
['61664713;40118;335;17990'],
['61664713;40118;335;-17990'],
['61684613;40118;335;12990'],
['68634752;40118;410;8990'],
['60694698;40118;620;3990'],
['60664659;40118;620;3990'],
['60614487;40118;878;5950'],
['68654655;40118;60;5080'],
['69624033;40118;80;18190'],
['60604100;40118;80;13300'],
['68674560;40118;170;5990']
])
select('JTable_22', 'rows:[6],columns:[Full Line]')
click('Close')
## select('JTable_22', '', '{6, Full Line}')
## select('JTable_22', 'rows:[6],columns:[Full Line]')
close()
if frame('Export1 - DTAR020_tst1.bin:0'):
select('names on first line', 'false')
click('save file')
close()
if frame('Table: - DTAR020_tst1.bin.csv:0'):
select('JTable_22', 'rows:[5],columns:[2|DATE]')
assert_content('JTable_22', [ ['63604808', '40118', '170', '4870'],
['69684558', '40118', '280', '19000'],
['69684558', '40118', '280', '-19000'],
['69694158', '40118', '280', '5010'],
['62684671', '40118', '685', '69990'],
['62684671', '40118', '685', '-69990'],
['61664713', '40118', '335', '17990'],
['61664713', '40118', '335', '-17990'],
['61684613', '40118', '335', '12990'],
['68634752', '40118', '410', '8990'],
['60694698', '40118', '620', '3990'],
['60664659', '40118', '620', '3990'],
['60614487', '40118', '878', '5950'],
['68654655', '40118', '60', '5080'],
['69624033', '40118', '80', '18190'],
['60604100', '40118', '80', '13300'],
['68674560', '40118', '170', '5990']
])
select('JTable_22', 'rows:[5],columns:[2|DATE]')
click('Close')
## select('JTable_22', '', '{5, 2|DATE}')
## select('JTable_22', 'rows:[5],columns:[2|DATE]')
close()
if frame('Export1 - DTAR020_tst1.bin:0'):
select('JTable_29', 'true', '{1, Include}')
select('JTable_29', 'true', '{4, Include}')
# select('JTable_33', 'rows:[1],columns:[Include]')
# select('JTable_33', 'rows:[4],columns:[Include]')
select('Delimiter', '|')
select('Add Quote to all Text Fields', 'true')
click('save file')
close()
if frame('Table: - DTAR020_tst1.bin.csv:0'):
select('JTable_22', 'rows:[6],columns:[3|DATE]')
assert_content('JTable_22', [ ['63604808', '20', '40118', '170', '1', '4870'],
['69684558', '20', '40118', '280', '1', '19000'],
['69684558', '20', '40118', '280', '-1', '-19000'],
['69694158', '20', '40118', '280', '1', '5010'],
['62684671', '20', '40118', '685', '1', '69990'],
['62684671', '20', '40118', '685', '-1', '-69990'],
['61664713', '59', '40118', '335', '1', '17990'],
['61664713', '59', '40118', '335', '-1', '-17990'],
['61684613', '59', '40118', '335', '1', '12990'],
['68634752', '59', '40118', '410', '1', '8990'],
['60694698', '59', '40118', '620', '1', '3990'],
['60664659', '59', '40118', '620', '1', '3990'],
['60614487', '59', '40118', '878', '1', '5950'],
['68654655', '166', '40118', '60', '1', '5080'],
['69624033', '166', '40118', '80', '1', '18190'],
['60604100', '166', '40118', '80', '1', '13300'],
['68674560', '166', '40118', '170', '1', '5990']
])
select('JTable_22', 'rows:[6],columns:[3|DATE]')
select('JTable_22', 'rows:[6],columns:[3|DATE]')
select('Layouts', 'Full Line')
select('JTable_22', 'rows:[7],columns:[Full Line]')
assert_content('JTable_22', [ ['63604808|20|40118|170|1|4870'],
['69684558|20|40118|280|1|19000'],
['69684558|20|40118|280|-1|-19000'],
['69694158|20|40118|280|1|5010'],
['62684671|20|40118|685|1|69990'],
['62684671|20|40118|685|-1|-69990'],
['61664713|59|40118|335|1|17990'],
['61664713|59|40118|335|-1|-17990'],
['61684613|59|40118|335|1|12990'],
['68634752|59|40118|410|1|8990'],
['60694698|59|40118|620|1|3990'],
['60664659|59|40118|620|1|3990'],
['60614487|59|40118|878|1|5950'],
['68654655|166|40118|60|1|5080'],
['69624033|166|40118|80|1|18190'],
['60604100|166|40118|80|1|13300'],
['68674560|166|40118|170|1|5990']
])
select('JTable_22', 'rows:[7],columns:[Full Line]')
click('Close')
## select('JTable_22', '', '{7, Full Line}')
## select('JTable_22', 'rows:[7],columns:[Full Line]')
close()
if frame('Export1 - DTAR020_tst1.bin:0'):
select('Add Quote to all Text Fields', 'false')
select('Delimiter', '~')
click('save file')
close()
if frame('Table: - DTAR020_tst1.bin.csv:0'):
select('JTable_22', 'rows:[6],columns:[3|DATE]')
assert_content('JTable_22', [ ['63604808', '20', '40118', '170', '1', '4870'],
['69684558', '20', '40118', '280', '1', '19000'],
['69684558', '20', '40118', '280', '-1', '-19000'],
['69694158', '20', '40118', '280', '1', '5010'],
['62684671', '20', '40118', '685', '1', '69990'],
['62684671', '20', '40118', '685', '-1', '-69990'],
['61664713', '59', '40118', '335', '1', '17990'],
['61664713', '59', '40118', '335', '-1', '-17990'],
['61684613', '59', '40118', '335', '1', '12990'],
['68634752', '59', '40118', '410', '1', '8990'],
['60694698', '59', '40118', '620', '1', '3990'],
['60664659', '59', '40118', '620', '1', '3990'],
['60614487', '59', '40118', '878', '1', '5950'],
['68654655', '166', '40118', '60', '1', '5080'],
['69624033', '166', '40118', '80', '1', '18190'],
['60604100', '166', '40118', '80', '1', '13300'],
['68674560', '166', '40118', '170', '1', '5990']
])
select('JTable_22', 'rows:[6],columns:[3|DATE]')
select('JTable_22', 'rows:[6],columns:[3|DATE]')
select('Layouts', 'Full Line')
select('JTable_22', 'rows:[6],columns:[Full Line]')
## assert_p('JViewport_21', 'Enabled', 'true')
select('JTable_22', 'rows:[5],columns:[Full Line]')
select('JTable_22', 'rows:[5],columns:[Full Line]')
assert_content('JTable_22', [ ['63604808~20~40118~170~1~4870'],
['69684558~20~40118~280~1~19000'],
['69684558~20~40118~280~-1~-19000'],
['69694158~20~40118~280~1~5010'],
['62684671~20~40118~685~1~69990'],
['62684671~20~40118~685~-1~-69990'],
['61664713~59~40118~335~1~17990'],
['61664713~59~40118~335~-1~-17990'],
['61684613~59~40118~335~1~12990'],
['68634752~59~40118~410~1~8990'],
['60694698~59~40118~620~1~3990'],
['60664659~59~40118~620~1~3990'],
['60614487~59~40118~878~1~5950'],
['68654655~166~40118~60~1~5080'],
['69624033~166~40118~80~1~18190'],
['60604100~166~40118~80~1~13300'],
['68674560~166~40118~170~1~5990']
])
select('JTable_22', 'rows:[5],columns:[Full Line]')
click('Close')
## select('JTable_22', '', '{5, Full Line}')
## select('JTable_22', 'rows:[5],columns:[Full Line]')
close()
## window_closed('Record Editor')
close()
pass
