def test():
from Modules import commonBits
java_recorded_version = '1.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'Ams_PODownload_20050101.txt')
select('ComboBox2', 'ams PO Download')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table', 'false', commonBits.fl('Include') + ',0')
select('Table', 'false', commonBits.fl('Include') + ',2')
#select('Table', 'cell:' + commonBits.fl('Include') + ',2(false)')
commonBits.filter(click)
select('Table', 'cell:3 - 5|Sequence Number,1(45.358)')
assert_p('Table', 'Content', '[[H1, 45.357, 4338, 233863, 040929, , 00, , 290, 050103, 050107, , , , OPTIONS PL, C, FT], [H1, 45.358, 4338, 233872, 040929, , 00, , 290, 050103, 050107, , , , OPTIONS PL, C, FT], [H1, 45.359, 4468, 255906, 040929, , 00, , 290, 050103, 050107, , , , OPTIONS PL, C, FT], [H1, 45.360, 4448, 290908, 040929, , 00, , 290, 050103, 050107, , , , OPTIONS PL, C, FT], [H1, 45.361, 4228, 292210, 040929, , 00, , 290, 050103, 050107, , , , OPTIONS PL, C, FT], [H1, 45.362, 5220, 211984, 040929, , 00, , 200, 050103, 050107, , , , LADIES KNI, C, FT], [H1, 45.363, 5110, 211985, 040929, , 00, , 200, 050103, 050107, , , , LADIES KNI, C, FT], [H1, 45.364, 5110, 211987, 040929, , 00, , 200, 050103, 050106, , , , LADIES KNI, C, FT], [H1, 45.365, 13112, 211549, 041005, , 00, , 220, 050103, 050108, , , , LADIES KNI, C, FT], [H1, 45.366, 13312, 211555, 041005, , 00, , 220, 050103, 050107, , , , LADIES KNI, C, FT], [H1, 45.367, 12212, 222556, 041005, , 00, , 220, 050103, 050107, , , , LADIES KNI, C, FT], [H1, 45.368, 1312, 211617, 041005, , 00, , 220, 050103, 050117, , , , LADIES KNI, C, FT]]')
select('Table', 'cell:8 - 10|Vendor,5(5220)')
assert_p('Table', 'Text', '5220', '8 - 10|Vendor,5')
select('Table', 'cell:8 - 10|Vendor,6(5110)')
assert_p('Table', 'RowCount', '12')
select('Table', 'cell:3 - 5|Sequence Number,7(45.364)')
rightclick('Table', '3 - 5|Sequence Number,7')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:3 - 5|Sequence Number,7(45.364)')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(211987)')
assert_p('Table', 'Content', '[[Record Type, 1, 2, H1, H1], [Sequence Number, 3, 5, 45.364, 45364], [Vendor, 8, 10, 5110, 0000005110], [PO, 18, 12, 211987, 000000211987], [Entry Date, 30, 6, 040929, 040929], [Filler, 36, 8, , ], [beg01 code, 44, 2, 00, 00], [beg02 code, 46, 2, , ], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050103, 050103], [Cancel by date, 58, 6, 050106, 050106], [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:' + commonBits.fl('Data') + ',9(050103)')
assert_p('Table', 'Text', 'cell:' + commonBits.fl('Data') + ',9(050103)')
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 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]]')
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() + 'Ams_PODownload_20050101.txt')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table', 'false', commonBits.fl('Include') + ',0')
select('Table', 'false', commonBits.fl('Include') + ',2')
select(
'Table',
'cell:' + commonBits.fl('Record') + ',1(ams PO Download: Header)')
select('Table1', 'false', commonBits.fl('Include') + ',6')
select('Table1', 'false', commonBits.fl('Include') + ',7')
select('Table1', 'false', commonBits.fl('Include') + ',1')
select('Table1', 'false', commonBits.fl('Include') + ',0')
select('Table1', 'false', commonBits.fl('Include') + ',5')
#select('Table1', 'cell:' + commonBits.fl('Include') + ',5(false)')
commonBits.filter(click)
select('Table', 'cell:30 - 6|Entry Date,4(040929)')
assert_p('Table', 'Text', '040929', '30 - 6|Entry Date,6')
select('Table', 'cell:48 - 4|Department,6(200)')
assert_p(
'Table', 'Content',
'[[4338, 233863, 040929, 290, 050103, 050107, , , , OPTIONS PL, C, FT], [4338, 233872, 040929, 290, 050103, 050107, , , , OPTIONS PL, C, FT], [4468, 255906, 040929, 290, 050103, 050107, , , , OPTIONS PL, C, FT], [4448, 290908, 040929, 290, 050103, 050107, , , , OPTIONS PL, C, FT], [4228, 292210, 040929, 290, 050103, 050107, , , , OPTIONS PL, C, FT], [5220, 211984, 040929, 200, 050103, 050107, , , , LADIES KNI, C, FT], [5110, 211985, 040929, 200, 050103, 050107, , , , LADIES KNI, C, FT], [5110, 211987, 040929, 200, 050103, 050106, , , , LADIES KNI, C, FT], [13112, 211549, 041005, 220, 050103, 050108, , , , LADIES KNI, C, FT], [13312, 211555, 041005, 220, 050103, 050107, , , , LADIES KNI, C, FT], [12212, 222556, 041005, 220, 050103, 050107, , , , LADIES KNI, C, FT], [1312, 211617, 041005, 220, 050103, 050117, , , , LADIES KNI, C, FT]]'
)
select('Table', 'cell:52 - 6|Expected Reciept Date,8(050103)')
assert_p('Table', 'RowCount', '12')
select('Table', 'cell:52 - 6|Expected Reciept Date,8(050103)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table2', 'cell:' + commonBits.fl('Field') + ',0(null)')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Filter.RecordSelection_JTbl', 'false', commonBits.fl('Include') + ',1')
select('Filter.RecordSelection_JTbl', 'cell:' + commonBits.fl('Record') + ',2(ams PO Download: Allocation)')
select('Fields.FieldRelationship_JTbl', '03', commonBits.fl('Value') + ',0')
select('Fields.FieldRelationship_JTbl', 'DC Number 1', commonBits.fl('Field') + ',0')
select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',0(DC Number 1)')
##click(commonBits.fl('Filter'))
commonBits.filter(click)
## select('TabbedPane1', 'Table:')
select_menu(commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' + commonBits.fl('Table:'))
assert_p('LineList.FileDisplay_JTbl1', 'Content', '[[D1, 0, 70000000, 0, 222, 4331, 45310000, 5, 45400000, 7, 207, 5359, , 4561, 4531, D, ONKEY 24, -6, 607 SHWL], [D1, 0, 40000000, 1, 48320000, 0561, 49440000, 5, 45400000, 4, 207, 5360, , 5614, 944, M, ILK 24-0, 660, 7 SHWL W], [D1, 4, 80000000, 1, 48320000, 5561, 50710000, 5, 45400000, 48, 207, 5361, , 5561, 5071, M, .ROSE 24, -6, 607 SHWL], [S1, 5036, 3, 5043, 5, 3331, 50710003, 5065, 4, 5069, 4, 5076, 4, 5079, 2, 5094, 4, 5128, 3], [D1, 0, 40000000, 1, 48320000, 5561, 51560000, 5, 45400000, 4, 207, 5362, , 5561, 5156, A, QUA 24-0, 660, 7 SHWL W], [D1, 1, 60000006, 2281, 48320000, 0222, 45310000, 5, 45400000, 16, 207, 5348, , 5614, 531, D, ONKEY 24, -6, 607 SHWL], [D1, 0, 80000000, 1, 48320000, 6222, 49440000, 5, 45400000, 8, 207, 5349, , 6561, 4944, M, ILK 24-0, 660, 7 SHWL W], [D1, 10, 80000000, 1, 48320000, 6222, 50710000, 5, 45400001, 8, 207, 5350, , 6561, 5071, M, .ROSE 24, -6, 607 SHWL], [S1, 5303, 2, 5169, 2, 5171, 3, 5177, 4, 5016, 2, 5089, 4, 5136, 3, 5011, 2, 5046, 2], [D1, 0, 80000000, 1, 48320000, 5222, 51560000, 5, 45400000, 8, 207, 5351, , 5561, 5156, M, .ROSE 24, -6, 607 SHWL], [D1, 0, 60000000, 1, 48320000, 4561, 45310000, 5, 45400000, 6, 207, 5352, , 4561, 4531, D, ONKEY 24, -6, 607 SHWL], [D1, 0, 30000000, 1, 48320000, 4561, 49440000, 5, 45400000, 3, 207, 5353, , 4561, 4944, M, ILK 24-0, 660, 7 SHWL W], [D1, 4, 40000000, 1, 48320000, 4561, 50710000, 5, 45400000, 44, 207, 5354, , 4561, 5071, M, .ROSE 24, -6, 607 SHWL], [D1, 0, 30000000, 1, 48320000, 4561, 51560000, 5, 45400000, 3, 207, 5355, , 3561, 5156, A, QUA 24-0, 660, 7 SHWL W], [D1, 3, 0, 2, 92680000, 4584, 66800000, 7, 27200000, 30, 212, 736, , 4561, 5156, C, ONCERTO, BLAC, K LEATHE], [S1, 5036, 2, 5043, 3, 5057, 1, 5065, 2, 5069, 2, 5076, 3, 5079, 1, 5094, 3, 5128, 3], [D1, 2, 90000000, 1, 98360000, 4584, 67720000, 5, 45400000, 29, 212, 1104, , 5846, 772, A, NGEL PIN, K SY, NTHETIC], [S1, 5036, 2, 5043, 3, 5057, 1, 5065, 2, 5069, 2, 5076, 3, 5079, 1, 5094, 2, 5128, 3], [D1, 2, 90000000, 1, 98360000, 4584, 74890000, 5, 45400000, 29, 212, 1627, , 4584, 7489, A, NGEL PIN, K SY, NTHETIC], [S1, 5036, 2, 5043, 3, 5057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 3, 5128, 3], [D1, 2, 50000000, 4, 65480000, 4584, 87070000, 9, 9000000, 25, 217, 9843, , 4584, 8707A, A, NGEL PIN, K SY, NTHETIC], [S1, 5036, 2, 5043, 2, 5057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [D1, 0, 80000000, 0, 82160000, 4616, 47900000, 3, 63600000, 8, 220, 3070, , 4616, 4790B8, A, NGEL PIN, K SY, NTHETIC], [D1, 2, 40000000, 1, 12970000, 4616, 47900000, 3, 63600000, 24, 220, 3056, , 4616, 4790, A, NGEL PIN, K SY, NTHETIC], [S1, 5036, 1, 5043, 2, 5057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [D1, 0, 70000000, 0, 82160000, 4616, 53600000, 3, 63600000, 7, 220, 3075, , 4616, 5360B8, C, ABERETCA, RAME, L MICRO], [D1, 2, 30000000, 1, 12970000, 4616, 53600000, 3, 63600000, 23, 220, 3072, , 4616, 5360, C, ABERETCA, RAME, L MICRO], [S1, 5036, 1, 5043, 2, 5057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 1, 5128, 2], [D1, 0, 80000000, 0, 83840000, 4592, 85530000, 3, 63600000, 8, 220, 3222, , 4592, 8553B8, C, ABERETCA, RAME, L MICRO], [D1, 2, 20000000, 1, 25760000, 4592, 85530000, 3, 63600000, 22, 220, 3219, , 4592, 8553, C, ABERETCA, RAME, L MICRO], [S1, 5036, 1, 5043, 2, 5057, 1, 5065, 1, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [D1, 2, 20000000, 1, 25760000, 1593, 57590000, 3, 63600000, 22, 220, 3223, , 593, 5759, J, AZZ DUST, Y PI, NK HEELE], [S1, 5036, 1, 5043, 2, 5057, 1, 5065, 1, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [D1, 0, 70000000, 0, 83840000, 4593, 57590000, 3, 63600000, 7, 220, 3224, , 4593, 5759B8, J, AZZ DUST, Y PI, NK HEELE]]')
select_menu(commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' + commonBits.fl('Filter Options'))
select('Filter.RecordSelection_JTbl', 'cell:' + commonBits.fl('Include') + ',0(true)')
##click(commonBits.fl('Filter'))
commonBits.filter(click)
## select('TabbedPane1', 'Table:')
select_menu(commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' + commonBits.fl('Table:'))
assert_p('LineList.FileDisplay_JTbl2', 'Content', '[[S1, 5036, 3, 5043, 5, 3331, 50710003, 5065, 4, 5069, 4, 5076, 4, 5079, 2, 5094, 4, 5128, 3], [S1, 5303, 2, 5169, 2, 5171, 3, 5177, 4, 5016, 2, 5089, 4, 5136, 3, 5011, 2, 5046, 2], [S1, 5036, 2, 5043, 3, 5057, 1, 5065, 2, 5069, 2, 5076, 3, 5079, 1, 5094, 3, 5128, 3], [S1, 5036, 2, 5043, 3, 5057, 1, 5065, 2, 5069, 2, 5076, 3, 5079, 1, 5094, 2, 5128, 3], [S1, 5036, 2, 5043, 3, 5057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 3, 5128, 3], [S1, 5036, 2, 5043, 2, 5057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [S1, 5036, 1, 5043, 2, 5057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [S1, 5036, 1, 5043, 2, 5057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 1, 5128, 2], [S1, 5036, 1, 5043, 2, 5057, 1, 5065, 1, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [S1, 5036, 1, 5043, 2, 5057, 1, 5065, 1, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2]]')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'csv2DTAR020_tst1.bin.csv')
## select('System_Txt', 'CSV')
if commonBits.version() == 'MsAccess':
select('Record Layout_Txt',
'Comma Delimited, names on the first line')
else:
select('System_Txt', 'CSV')
click(commonBits.fl('Edit') + '1')
## select_menu(commonBits.fl('Edit') + '>>' + commonBits.fl('Update Csv Columns'))
## select('FieldChange_JTbl', commonBits.fl('Number'), commonBits.fl('Type') + ',5')
## select('FieldChange_JTbl', commonBits.fl('Number'), commonBits.fl('Type') + ',1')
## select('FieldChange_JTbl', 'cell:' + commonBits.fl('Type') + ',1(Number)')
## click(commonBits.fl('Apply'))
## click('Filter1')
## select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',0(null)')
## select('Fields.FieldRelationship_JTbl', 'SALE-PRICE', commonBits.fl('Field') + ',0')
## select('Fields.FieldRelationship_JTbl', '5.95', commonBits.fl('Value') + ',0')
## select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',1(null)')
## click('Filter1')
## assert_p('LineList.FileDisplay_JTbl', 'Content', '[[60614487, 59, 40118, 878, 1, 5.95]]')
## click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Filter1')
select('Fields.FieldRelationship_JTbl', 'SALE-PRICE',
commonBits.fl('Field') + ',0')
select('Fields.FieldRelationship_JTbl', '5.95',
commonBits.fl('Value') + ',0')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Operator') + ',0(Contains)')
select('Fields.FieldRelationship_JTbl', commonBits.fl('>= (Numeric)'),
commonBits.fl('Operator') + ',0')
## select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Operator') + ',0(>=)')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [62684671, 20, 40118, 685, 1, 69.99], [61664713, 59, 40118, 335, 1, 17.99], [61684613, 59, 40118, 335, 1, 12.99], [68634752, 59, 40118, 410, 1, 8.99], [60614487, 59, 40118, 878, 1, 5.95], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30], [68674560, 166, 40118, 170, 1, 5.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',1(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',1')
select('Fields.FieldRelationship_JTbl', '59',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[61664713, 59, 40118, 335, 1, 17.99], [61684613, 59, 40118, 335, 1, 12.99], [68634752, 59, 40118, 410, 1, 8.99], [60614487, 59, 40118, 878, 1, 5.95]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'csv2DTAR020_tst1.bin.csv')
select('System_Txt', 'CSV')
click(commonBits.fl('Edit') + '1')
## select_menu(commonBits.fl('Edit') + '>>' + commonBits.fl('Update Csv Columns'))
## select('FieldChange_JTbl', commonBits.fl('Number'), commonBits.fl('Type') + ',5')
## select('FieldChange_JTbl', commonBits.fl('Number'), commonBits.fl('Type') + ',1')
## select('FieldChange_JTbl', 'cell:' + commonBits.fl('Type') + ',1(Number)')
## click(commonBits.fl('Apply'))
click('Filter1')
# select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',0(null)')
select('Fields.FieldRelationship_JTbl', 'SALE-PRICE',
commonBits.fl('Field') + ',0')
select('Fields.FieldRelationship_JTbl', '5.96',
commonBits.fl('Value') + ',0')
# select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',1(null)')
# commonBits.filter(click)
# assert_p('LineList.FileDisplay_JTbl', 'Content', '[[60614487, 59, 40118, 878, 1, 5.95]]')
# click('BasicInternalFrameTitlePane$NoFocusButton2')
# select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Operator') + ',0(Contains)')
select('Fields.FieldRelationship_JTbl', commonBits.fl('< (Numeric)'),
commonBits.fl('Operator') + ',0')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[63604808, 20, 40118, 170, 1, 4.87], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, -1, -17.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [60614487, 59, 40118, 878, 1, 5.95], [68654655, 166, 40118, 60, 1, 5.08]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
## select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',1(null)')
select('Fields.FieldRelationship_JTbl', commonBits.fl('< (Numeric)'),
commonBits.fl('Operator') + ',0')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',1')
select('Fields.FieldRelationship_JTbl', '59',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl', commonBits.fl('< (Numeric)'),
commonBits.fl('Operator') + ',0')
## select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[61664713, 59, 40118, 335, -1, -17.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [60614487, 59, 40118, 878, 1, 5.95]]'
)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[61664713, 59, 40118, 335, -1, -17.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [60614487, 59, 40118, 878, 1, 5.95]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'csv2DTAR020_tst1.bin.csv')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',0(null)')
select('Fields.FieldRelationship_JTbl', 'SALE-PRICE',
commonBits.fl('Field') + ',0')
select('Fields.FieldRelationship_JTbl', '>=',
commonBits.fl('Operator') + ',0')
select('Fields.FieldRelationship_JTbl', '3.99',
commonBits.fl('Value') + ',0')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',1()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[63604808, 20, 40118, 170, 1, 4.87], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, 1, 69.99], [68634752, 59, 40118, 410, 1, 8.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [60614487, 59, 40118, 878, 1, 5.95], [68654655, 166, 40118, 60, 1, 5.08], [68674560, 166, 40118, 170, 1, 5.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',1(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',1')
select('Fields.FieldRelationship_JTbl', '59',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[68634752, 59, 40118, 410, 1, 8.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [60614487, 59, 40118, 878, 1, 5.95]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl', '20',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[63604808, 20, 40118, 170, 1, 4.87], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, 1, 69.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl', '166',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[68654655, 166, 40118, 60, 1, 5.08], [68674560, 166, 40118, 170, 1, 5.99]]'
)
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.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
click(commonBits.fl('Edit') + '1')
assert_p('LineList.Layouts_Txt', 'Text', commonBits.fl('Prefered'))
click('Filter1')
select('Filter.RecordSelection_JTbl', 'cell:' + commonBits.fl('Include') + ',0(true)')
select('Filter.RecordSelection_JTbl', 'cell:' + commonBits.fl('Include') + ',2(true)')
assert_p('Filter.RecordSelection_JTbl', 'Content', '[[ams PO Download: Detail, false], [ams PO Download: Header, true], [ams PO Download: Allocation, false]]')
commonBits.filter(click)
assert_p('LineList.Layouts_Txt', 'Text', commonBits.fl('Prefered'))
assert_p('LineList.FileDisplay_JTbl', 'Content', '[[H1, 45.349, 6060, 286225, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT, , ], [H1, 45.350, 6228, 222227, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT, , ], [H1, 45.351, 6228, 222243, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT, , ], [H1, 45.352, 5341, 294915, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT, , ], [H1, 45.353, 5341, 294987, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT, , ], [H1, 45.354, 5341, 295139, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT, , ], [H1, 45.355, 5341, 303662, 041110, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT, , ], [H1, 45.356, 5341, 304100, 041111, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT, , ]]')
click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'csv2DTAR020_tst1.bin.csv')
click(commonBits.fl('Edit') + '1')
select_menu(
commonBits.fl('Edit') + '>>' + commonBits.fl('Update Csv Columns'))
select('FieldChange_JTbl', commonBits.fl('Number'),
commonBits.fl('Type') + ',5')
select('FieldChange_JTbl', commonBits.fl('Number'),
commonBits.fl('Type') + ',1')
select('FieldChange_JTbl',
'cell:' + commonBits.fl('Type') + ',1(Number)')
click(commonBits.fl('Apply'))
click('Filter1')
## select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',0(null)')
select('Fields.FieldRelationship_JTbl', 'SALE-PRICE',
commonBits.fl('Field') + ',0')
select('Fields.FieldRelationship_JTbl', commonBits.fl('<= (Text)'),
commonBits.fl('Operator') + ',0')
select('Fields.FieldRelationship_JTbl', '3.99',
commonBits.fl('Value') + ',0')
## select('Fields.FieldRelationship_JTbl', 'cell:Or,1()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99], [61684613, 59, 40118, 335, 1, 12.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
## select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Field') + ',1(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',1')
select('Fields.FieldRelationship_JTbl', '20',
commonBits.fl('Value') + ',1')
## select('Fields.FieldRelationship_JTbl', 'cell:' + commonBits.fl('Value') + ',2()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , SALE-PRICE, true, ' + commonBits.fl('<= (Text)') +
', 3.99], [, ' + commonBits.fl('And') + ', STORE-NO, true, ' +
commonBits.fl('Contains') + ', 20], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [62684671, 20, 40118, 685, -1, -69.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl', '59',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , SALE-PRICE, true, ' + commonBits.fl('<= (Text)') +
', 3.99], [, ' + commonBits.fl('And') + ', STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99], [61684613, 59, 40118, 335, 1, 12.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl', '16',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30]]'
)
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()
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table1', 'Loc Type', commonBits.fl('Field') + ',0')
select('Table1', 'st', commonBits.fl('Value') + ',0')
select('Table1', 'cell:' + commonBits.fl('Field') + ',2(null)')
commonBits.save1(click)
#select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1')
commonBits.selectFileName(
select, keystroke,
commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1')
commonBits.save1(click)
select_menu(
commonBits.fl('Window') + '>>Ams_LocDownload_20041228.txt>>' +
commonBits.fl('Filter Options'))
commonBits.filter(click)
select('Table', 'cell:10 - 35|Loc Name,0(Bankstown)')
assert_p('Table', 'Text', 'Bankstown', '10 - 35|Loc Name,0')
select('Table', 'cell:8 - 2|Loc Type,1(ST)')
rightclick('Table', '8 - 2|Loc Type,1')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:8 - 2|Loc Type,1(ST)')
select('Table',
'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)')
assert_p('Table', 'Text', 'Penrith', commonBits.fl('Data') + ',6')
select('Table',
'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)')
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:' + commonBits.fl('Data') + ',5(58 Leland Street)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table', 'cell:8 - 2|Loc Type,1(ST)')
select('Table', 'cell:8 - 2|Loc Type,1(ST)')
select_menu(
commonBits.fl('Window') + '>>Ams_LocDownload_20041228.txt>>' +
commonBits.fl('Table:'))
select('Table2', 'cell:8 - 2|Loc Type,1(ST)')
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Execute Saved Filter'))
##select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() +'xx1')
commonBits.selectFileName(
select, keystroke,
commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx1')
click(commonBits.fl('Run'))
select('Table', 'cell:10 - 35|Loc Name,2(Blacktown)')
assert_p('Table', 'Text', 'Blacktown', '10 - 35|Loc Name,2')
select('Table', 'cell:10 - 35|Loc Name,5(Eastwood)')
rightclick('Table', '10 - 35|Loc Name,5')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:10 - 35|Loc Name,5(Eastwood)')
select(
'Table',
'cell:' + commonBits.fl('Data') + ',4(Marayong Offsite Reserve)')
assert_p('Table', 'Text', 'Marayong Offsite Reserve',
commonBits.fl('Data') + ',4')
select(
'Table',
'cell:' + commonBits.fl('Data') + ',4(Marayong Offsite Reserve)')
assert_p(
'Table', 'Content',
'[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5052, 5052], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Eastwood, Eastwood], [Loc Addr Ln1, 45, 40, Marayong Offsite Reserve, Marayong Offsite Reserve], [Loc Addr Ln2, 85, 40, 11 Melissa Place, 11 Melissa Place], [Loc Addr Ln3, 125, 35, Marayong, Marayong], [Loc Postcode, 160, 10, 2148, 2148], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]'
)
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('Filter')
commonBits.filter(click)
select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)')
assert_p('Table', 'Text', 'VIC West Ad Support', '10 - 35|Loc Name,1')
select('Table', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)')
select_menu(commonBits.fl('Data') + '>>' + commonBits.fl('Sort'))
# select('Table1', 'cell:10 - 35|Loc Name,1(VIC West Ad Support)')
## select('List', 'ams Store')
select('Table', 'cell:' + commonBits.fl('Field') + ',0( )')
click('ScrollPane$ScrollBar', 9, 108)
select('Table', 'Loc State', commonBits.fl('Field') + ',0')
select('Table', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(Loc Nbr)')
commonBits.sort(click)
select('Table', 'cell:10 - 35|Loc Name,0(National Ad Support)')
assert_p('Table', 'Text', 'cell:10 - 35|Loc Name,0(National Ad Support)')
select('Table', 'cell:10 - 35|Loc Name,12(Canberra Civic)')
assert_p('Table', 'Text', 'cell:10 - 35|Loc Name,12(Canberra Civic)')
select('Table', 'cell:10 - 35|Loc Name,12(Canberra Civic)')
rightclick('Table', '10 - 35|Loc Name,12')
select_menu(commonBits.fl('Edit Record'))
select('Table', 'cell:' + commonBits.fl('Data') + ',2(ST)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5096, 5096], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Canberra Civic, Canberra Civic], [Loc Addr Ln1, 45, 40, Target Canberra, Target Canberra], [Loc Addr Ln2, 85, 40, Canberra City Centre, Akuna Ave, Canberra City Centre, Akuna Ave], [Loc Addr Ln3, 125, 35, Canberra, Canberra], [Loc Postcode, 160, 10, 2601, 2601], [Loc State, 170, 3, ACT, ACT], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(ST)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(Coffs Harbour)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5002, 5002], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Coffs Harbour, Coffs Harbour], [Loc Addr Ln1, 45, 40, Coffs Harbour, Coffs Harbour], [Loc Addr Ln2, 85, 40, Cnr. Park Beach Road & Pacific Hwy, Cnr. Park Beach Road & Pacific Hwy], [Loc Addr Ln3, 125, 35, Coffs Harbour, Coffs Harbour], [Loc Postcode, 160, 10, 2450, 2450], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(Coffs Harbour)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(Albury)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5005, 5005], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Albury, Albury], [Loc Addr Ln1, 45, 40, Albury, Albury], [Loc Addr Ln2, 85, 40, Kiewa Street, Kiewa Street], [Loc Addr Ln3, 125, 35, Albury, Albury], [Loc Postcode, 160, 10, 2640, 2640], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(Albury)')
click('RightM')
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)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table', 'cell:10 - 35|Loc Name,12(Canberra Civic)')
rightclick('Table', '10 - 35|Loc Name,4')
select_menu('Sort')
## select('List', 'ams Store')
select('Table', 'Loc Type', commonBits.fl('Field') + ',0')
select('Table', 'Loc Nbr', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(Loc Nbr)')
commonBits.sort(click)
select('Table', 'cell:10 - 35|Loc Name,0(National Ad Support)')
assert_p('Table', 'Text', 'National Ad Support', '10 - 35|Loc Name,0')
select('Table', 'cell:10 - 35|Loc Name,0(National Ad Support)')
rightclick('Table', '10 - 35|Loc Name,0')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:10 - 35|Loc Name,0(National Ad Support)')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(National Ad Support)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5109, 5109], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, National Ad Support, National Ad Support], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(National Ad Support)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(Head Office)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5700, 5700], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Head Office, Head Office], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, , ], [Loc Addr Ln3, 125, 35, , ], [Loc Postcode, 160, 10, , ], [Loc State, 170, 3, , ], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(Head Office)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(30-68 Taras Ave)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5839, 5839], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, DC - Taras Ave, DC - Taras Ave], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, 30-68 Taras Ave, 30-68 Taras Ave], [Loc Addr Ln3, 125, 35, Altona North, Altona North], [Loc Postcode, 160, 10, 3025, 3025], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(30-68 Taras Ave)')
click('Right')
click('Right')
click('Right')
click('Right')
click('Right')
click('Right')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(No 2 Sydney Gate)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5897, 5897], [Loc Type, 8, 2, DC, DC], [Loc Name, 10, 35, Sydney Gate DC, Sydney Gate DC], [Loc Addr Ln1, 45, 40, No 2 Sydney Gate, No 2 Sydney Gate], [Loc Addr Ln2, 85, 40, 830 Bourke Street, 830 Bourke Street], [Loc Addr Ln3, 125, 35, Waterloo, Waterloo], [Loc Postcode, 160, 10, 2017, 2017], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(No 2 Sydney Gate)')
click('RightM')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Cnr Grove Way & Golden Grove)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5305, 5305], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Golden Grove, Golden Grove], [Loc Addr Ln1, 45, 40, The Golden Way, The Golden Way], [Loc Addr Ln2, 85, 40, Cnr Grove Way & Golden Grove, Cnr Grove Way & Golden Grove], [Loc Addr Ln3, 125, 35, Golden Grove, Golden Grove], [Loc Postcode, 160, 10, 5125, 5125], [Loc State, 170, 3, SOU, SOU], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Cnr Grove Way & Golden Grove)')
click('Left')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(2-50 Murray Road)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5304, 5304], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Northland Baby Target, Northland Baby Target], [Loc Addr Ln1, 45, 40, Northland Shopping Centre, Northland Shopping Centre], [Loc Addr Ln2, 85, 40, 2-50 Murray Road, 2-50 Murray Road], [Loc Addr Ln3, 125, 35, East Preston, East Preston], [Loc Postcode, 160, 10, 3072, 3072], [Loc State, 170, 3, VIC, VIC], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(2-50 Murray Road)')
click('Left')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Gilchrist Drive)')
assert_p('Table', 'Text', 'Gilchrist Drive', commonBits.fl('Data') + ',5')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Gilchrist Drive)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5303, 5303], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Macarthur Square, Macarthur Square], [Loc Addr Ln1, 45, 40, Macarthur Square, Macarthur Square], [Loc Addr Ln2, 85, 40, Gilchrist Drive, Gilchrist Drive], [Loc Addr Ln3, 125, 35, Campbelltown, Campbelltown], [Loc Postcode, 160, 10, 2560, 2560], [Loc State, 170, 3, NSW, NSW], [Loc Actv Ind, 173, 1, A, A]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Gilchrist Drive)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
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_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'DTAR020_tst1.bin')
click(commonBits.fl('Edit') + '1')
assert_p('LineList.Layouts_Txt', 'Text', 'DTAR020')
click('Filter1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',0(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',0')
select('Fields.FieldRelationship_JTbl', '20',
commonBits.fl('Value') + ',0')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',1()')
# assert_p('Fields.FieldRelationship_JTbl', 'Content', '[[STORE-NO, true, ' + commonBits.fl('Contains') + ', 20], [, true, ' + commonBits.fl('Contains') + ', ], [, true, ' + commonBits.fl('Contains') + ', ], [, true, ' + commonBits.fl('Contains') + ', ]]')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',1()')
commonBits.filter(click)
assert_p('LineList.Layouts_Txt', 'Text', 'DTAR020')
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[63604808, 20, 40118, 170, 1, 4.87], [69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(
commonBits.fl('Window') + '>>DTAR020_tst1.bin>>' +
commonBits.fl('Table:'))
select('LineList.FileDisplay_JTbl',
'rows:[1,2,3,4,5,6,7],columns:[9 - 2|STORE-NO,11 - 4|DATE]')
select_menu(
commonBits.fl('View') + '>>' +
commonBits.fl('Table View #{Selected Records#}'))
assert_p('LineList.Layouts_Txt', 'Text', 'DTAR020')
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99]]'
)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99]]'
)
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_PODownload_20050101.txt')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table', 'false', commonBits.fl('Include') + ',0')
select('Table', 'false', commonBits.fl('Include') + ',2')
select(
'Table',
'cell:' + commonBits.fl('Record') + ',1(ams PO Download: Header)')
select('Table1', 'false', commonBits.fl('Include') + ',0')
select('Table1', 'false', commonBits.fl('Include') + ',1')
select('Table1', 'false', commonBits.fl('Include') + ',6')
select('Table1', 'false', commonBits.fl('Include') + ',7')
select('Table1', 'false', commonBits.fl('Include') + ',5')
#select('Table1', 'cell:' + commonBits.fl('Include') + ',5(false)')
select('Table2', 'Vendor', commonBits.fl('Field') + ',0')
select('Table2', ' = ', commonBits.fl('Operator') + ',0')
select('Table2', '5110', commonBits.fl('Value') + ',0')
select('Table2', 'cell:' + commonBits.fl('Value') + ',0()')
commonBits.filter(click)
select('Table', 'cell:30 - 6|Entry Date,0(040929)')
assert_p(
'Table', 'Content',
'[[5110, 211985, 040929, 200, 050103, 050107, , , , LADIES KNI, C, FT], [5110, 211987, 040929, 200, 050103, 050106, , , , LADIES KNI, C, FT]]'
)
select('Table', 'cell:52 - 6|Expected Reciept Date,1(050103)')
assert_p('Table', 'RowCount', '2')
select('Table', 'cell:52 - 6|Expected Reciept Date,1(050103)')
rightclick('Table', '18 - 12|PO,0')
select('Table', 'cell:18 - 12|PO,0(211985)')
rightclick('Table', '18 - 12|PO,0')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:18 - 12|PO,0(211985)')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(050103)')
assert_p(
'Table', 'Content',
'[[Vendor, 8, 10, 5110, 0000005110], [PO, 18, 12, 211985, 000000211985], [Entry Date, 30, 6, 040929, 040929], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050103, 050103], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNI, LADIES KNI], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',5(050107)')
rightclick('Table', commonBits.fl('Data') + ',5')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(050107)')
assert_p(
'Table', 'Content',
'[[Vendor, 8, 10, 5110, 0000005110], [PO, 18, 12, 211985, 000000211985], [Entry Date, 30, 6, 040929, 040929], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050103, 050103], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNI, LADIES KNI], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select('Table', '201', commonBits.fl('Data') + ',3')
select('Table', 'cell:' + commonBits.fl('Text') + ',3(201)')
rightclick('Table', commonBits.fl('Text') + ',3')
select('Table', 'cell:' + commonBits.fl('Text') + ',3(201)')
assert_p('Table', 'Text', '201', commonBits.fl('Text') + ',3')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(050103)')
assert_p(
'Table', 'Content',
'[[Vendor, 8, 10, 5110, 0000005110], [PO, 18, 12, 211985, 000000211985], [Entry Date, 30, 6, 040929, 040929], [Department, 48, 4, 201, 201], [Expected Reciept Date, 52, 6, 050103, 050103], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNI, LADIES KNI], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select('Table', '200', commonBits.fl('Data') + ',3')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(050103)')
assert_p(
'Table', 'Content',
'[[Vendor, 8, 10, 5110, 0000005110], [PO, 18, 12, 211985, 000000211985], [Entry Date, 30, 6, 040929, 040929], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050103, 050103], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNI, LADIES KNI], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
select('Table', 'LADIES KNw', commonBits.fl('Text') + ',9')
select('Table', 'cell:' + commonBits.fl('Data') + ',9(LADIES KNw)')
assert_p('Table', 'Text', 'LADIES KNw', commonBits.fl('Data') + ',9')
select('Table', 'cell:' + commonBits.fl('Data') + ',10(C)')
assert_p(
'Table', 'Content',
'[[Vendor, 8, 10, 5110, 0000005110], [PO, 18, 12, 211985, 000000211985], [Entry Date, 30, 6, 040929, 040929], [Department, 48, 4, 200, 200], [Expected Reciept Date, 52, 6, 050103, 050103], [Cancel by date, 58, 6, 050107, 050107], [EDI Type, 68, 1, , ], [Add Date, 69, 6, , ], [Filler, 75, 1, , ], [Department Name, 76, 10, LADIES KNw, LADIES KNw], [Prcoess Type, 86, 1, C, C], [Order Type, 87, 2, FT, FT]]'
)
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()
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table1', 'Loc Type', commonBits.fl('Field') + ',0')
select('Table1', 'st', commonBits.fl('Value') + ',0')
select('Table1', 'cell:' + commonBits.fl('Field') + ',2(null)')
commonBits.save1(click)
##select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx2')
commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx2')
commonBits.save1(click)
select_menu(commonBits.fl('Window') + '>>Ams_LocDownload_20041228.txt>>' + commonBits.fl('Filter Options'))
commonBits.filter(click)
select('Table', 'cell:10 - 35|Loc Name,0(Bankstown)')
assert_p('Table', 'Text', 'Bankstown', '10 - 35|Loc Name,0')
select('Table', 'cell:8 - 2|Loc Type,1(ST)')
rightclick('Table', '8 - 2|Loc Type,1')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:8 - 2|Loc Type,1(ST)')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)')
assert_p('Table', 'Text', 'Penrith', commonBits.fl('Data') + ',6')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(58 Leland Street)')
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:' + commonBits.fl('Data') + ',5(58 Leland Street)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table', 'cell:8 - 2|Loc Type,1(ST)')
select('Table', 'cell:8 - 2|Loc Type,1(ST)')
select_menu(commonBits.fl('Window') + '>>Ams_LocDownload_20041228.txt>>' + commonBits.fl('Table:'))
select('Table2', 'cell:8 - 2|Loc Type,1(ST)')
select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Execute Saved Filter'))
##select('FileChooser', commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx2')
commonBits.selectFileName(select, keystroke, commonBits.userDir() + 'Filter' + commonBits.fileSep() + 'xx2')
click(commonBits.fl('Run Dialog')
)
select('Table1', 'cell:' + commonBits.fl('Value') + ',0(st)')
rightclick('Table1', commonBits.fl('Value') + ',0')
select('Table1', 'cell:' + commonBits.fl('Value') + ',0(st)')
rightclick('Table1', commonBits.fl('Value') + ',0')
assert_p('Table1', 'Text', 'st', commonBits.fl('Value') + ',0')
select('Table1', 'cell:' + commonBits.fl('Value') + ',0(st)')
## assert_p('Table1', 'Content', '[[Loc Type, true, Contains, st], [, true, Contains, ], [, true, Contains, ], [, true, Contains, ]]')
## assert_p('Table1', 'Content', '[[, , Loc Type, true, Contains, st], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ], [, And, , true, Contains, ]]');
## assert_p('Table1', 'Content', '[[, , Loc Type, true, ' + commonBits.fl('Contains') + ', st], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ]]');
assert_p('Table1', 'Content', '[[, , Loc Type, true, ' + commonBits.fl('Contains') + ', st], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ]]');
## assert_p('Table1', 'Content', '[[, , Loc Type, true, ' + commonBits.fl('Contains') + ', st], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ], [, And, , true, ' + commonBits.fl('Contains') + ', ]]');
select('Table1', 'cell:' + commonBits.fl('Value') + ',0(st)')
commonBits.filter(click)
select('Table', 'cell:10 - 35|Loc Name,6(Leichhardt)')
assert_p('Table', 'Text', 'Leichhardt', '10 - 35|Loc Name,6')
select('Table', 'cell:10 - 35|Loc Name,13(Carlingford Court)')
rightclick('Table', '10 - 35|Loc Name,13')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:10 - 35|Loc Name,13(Carlingford Court)')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Dock 1, 11 Melissa Place)')
assert_p('Table', 'Text', 'Dock 1, 11 Melissa Place', commonBits.fl('Data') + ',5')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(Dock 1, 11 Melissa Place)')
assert_p('Table', 'Content', '[[Brand Id, 1, 3, TAR, TAR], [Loc Nbr, 4, 4, 5090, 5090], [Loc Type, 8, 2, ST, ST], [Loc Name, 10, 35, Carlingford Court, Carlingford Court], [Loc Addr Ln1, 45, 40, , ], [Loc Addr Ln2, 85, 40, Dock 1, 11 Melissa Place, Dock 1, 11 Melissa Place], [Loc Addr Ln3, 125, 35, Marayong, Marayong], [Loc Postcode, 160, 10, 2148, 2148], [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_10'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'zzAms_PODownload_20041231.txt')
commonBits.setRecordLayout(select, 'zzAms PO Download')
commonBits.doEdit(click)
click('Filter')
select(
'Table',
'cell:' + commonBits.fl('Record') + ',0(ams PO Download: Detail)')
select('Table2', 'cell:' + commonBits.fl('Field') + ',0(null)')
select(
'Table',
'cell:' + commonBits.fl('Record') + ',0(ams PO Download: Detail)')
select('Table2', 'Record Type', commonBits.fl('Field') + ',0')
select('Table2', 'd', commonBits.fl('Value') + ',0')
select('Table2', 'cell:' + commonBits.fl('Value') + ',0()')
select('Table', 'false', commonBits.fl('Include') + ',1')
select('Table', 'cell:' + commonBits.fl('Include') + ',2(true)')
commonBits.filter(click)
select('Table', 'cell:3 - 9|Pack Qty,2(48.0000)')
assert_p('Table', 'Text', '16.0000', '3 - 9|Pack Qty,4')
select('Table', 'cell:3 - 9|Pack Qty,3(4.0000)')
assert_p('Table', 'RowCount', '24')
select('Table', 'cell:3 - 9|Pack Qty,6(108.0000)')
assert_p('Table', 'Text', '108.0000', '3 - 9|Pack Qty,6')
select('Table', 'cell:3 - 9|Pack Qty,6(108.0000)')
rightclick('Table', '1 - 2|Record Type,4')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:3 - 9|Pack Qty,6(108.0000)')
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075348)')
assert_p('Table', 'Text', '2075348', commonBits.fl('Data') + ',6')
select(
'Table', 'cell:' + commonBits.fl('Data') +
',8( DONKEY 24-006607 SHWL WRAP CARD)')
assert_p('Table', 'Text', ' DONKEY 24-006607 SHWL WRAP CARD',
commonBits.fl('Data') + ',8')
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075348)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 16.0000, 000160000], [Pack Cost, 12, 13, 6228148.3200, 0062281483200], [APN, 25, 13, 2222, 0000000002222], [Filler, 38, 1, , ], [Product, 39, 8, 2224531, 02224531], [pmg dtl tech key, 72, 15, 2075348, 2075348], [Case Pack id, 87, 15, 5614531, 5614531], [Product Name, 101, 50, DONKEY 24-006607 SHWL WRAP CARD, DONKEY 24-006607 SHWL WRAP CARD]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075348)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075349)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 8.0000, 000080000], [Pack Cost, 12, 13, 148.3200, 0000001483200], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 62224944, 62224944], [pmg dtl tech key, 72, 15, 2075349, 2075349], [Case Pack id, 87, 15, 65614944, 65614944], [Product Name, 101, 50, MILK 24-006607 SHWL WRAP CARD, MILK 24-006607 SHWL WRAP CARD]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075349)')
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075350)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 108.0000, 001080000], [Pack Cost, 12, 13, 148.3200, 0000001483200], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 62225071, 62225071], [pmg dtl tech key, 72, 15, 2075350, 2075350], [Case Pack id, 87, 15, 65615071, 65615071], [Product Name, 101, 50, M.ROSE 24-006607 SHWL WRAP CARD, M.ROSE 24-006607 SHWL WRAP CARD]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075350)')
click('TextArea')
assert_p(
'TextArea', 'Text',
'D100108000000000014832000000000000000 62225071000000054540000108 2075350 65615071 M.ROSE 24-006607 SHWL WRAP CARD '
)
click('Right')
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075351)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 8.0000, 000080000], [Pack Cost, 12, 13, 148.3200, 0000001483200], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 52225156, 52225156], [pmg dtl tech key, 72, 15, 2075351, 2075351], [Case Pack id, 87, 15, 55615156, 55615156], [Product Name, 101, 50, M.ROSE 24-006607 SHWL WRAP CARD, M.ROSE 24-006607 SHWL WRAP CARD]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',6(2075351)')
click('TextArea')
assert_p('ScrollPane1', 'Enabled', 'true')
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')
commonBits.setRecordLayout(select, 'zzAms PO Download')
commonBits.doEdit(click)
click('Filter')
select('Table', 'false', commonBits.fl('Include') + ',1')
select(
'Table',
'cell:' + commonBits.fl('Record') + ',0(ams PO Download: Detail)')
select('Table2', 'cell:' + commonBits.fl('Field') + ',0(null)')
select(
'Table',
'cell:' + commonBits.fl('Record') + ',0(ams PO Download: Detail)')
select('Table2', 'Record Type', commonBits.fl('Field') + ',0')
select('Table2', 's', commonBits.fl('Value') + ',0')
select('Table2', 'cell:' + commonBits.fl('Value') + ',1()')
commonBits.filter(click)
select('LayoutCombo', 'ams PO Download: Detail')
select('Table', 'cell:3 - 9|Pack Qty,2(50360.0000)')
assert_p('Table', 'Text', '50360.0000', '3 - 9|Pack Qty,2')
select('Table', 'cell:3 - 9|Pack Qty,4(50430.0000)')
assert_p('Table', 'ColumnCount', '9')
select('Table', 'cell:3 - 9|Pack Qty,4(50430.0000)')
rightclick('Table', '3 - 9|Pack Qty,2')
select_menu(commonBits.fl('Edit Record'))
## select('LayoutCombo', 'ams PO Download: Detail')
## select('Table1', 'cell:3 - 9|Pack Qty,4(50430.0000)')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(550450000000)')
## assert_p('Table', 'Content', '[[Record Type, 1, 2, S1, S1], [Pack Qty, 3, 9, 50360.0000, 503600000], [Pack Cost, 12, 13, 3504300.0000, 0035043000000], [APN, 25, 13, 550450000000, 0550450000000], [Filler, 38, 1, 5, 5], [Product, 39, 8, 33315071, 33315071], [pmg dtl tech key, 72, 15, 004507600000004, 004507600000004], [Case Pack id, 87, 15, 507900000002509, 507900000002509], [Product Name, 101, 50, 9400000004512800000003, 9400000004512800000003]]')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5036, 5036], [Pack Quantity 1, 7, 8, 3, 00000003], [DC Number 2, 15, 4, 5043, 5043], [Pack Quantity 2, 19, 8, 5, 00000005], [DC Number 4, 39, 4, 3331, 3331], [Pack Quantity 4, 43, 8, 50710003, 50710003], [DC Number 5, 51, 4, 5065, 5065], [Pack Quantity 5, 55, 8, 4, 00000004], [DC Number 6, 63, 4, 5069, 5069], [Pack Quantity 6, 67, 8, 4, 00000004], [DC Number 7, 75, 4, 5076, 5076], [Pack Quantity 7, 79, 8, 4, 00000004], [DC Number 8, 87, 4, 5079, 5079], [Pack Quantity 8, 91, 8, 2, 00000002], [DC Number 9, 99, 4, 5094, 5094], [Pack Quantity 9, 103, 8, 4, 00000004], [DC Number 10, 111, 4, 5128, 5128], [Pack Quantity 10, 115, 8, 3, 00000003]]'
)
select('Table',
'cell:' + commonBits.fl('Data') + ',6(004507600000004)')
assert_p('Table', 'Text', '5065', commonBits.fl('Data') + ',7')
select('Table',
'cell:' + commonBits.fl('Data') + ',6(004507600000004)')
click('TextArea')
assert_p(
'TextArea', 'Text',
'S1503600000003504300000005504500000005333150710003506500000004506900000004507600000004507900000002509400000004512800000003'
)
click('Right')
## select('LayoutCombo', 'ams PO Download: Detail')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(350720000000)')
## assert_p('Table', 'Content', '[[Record Type, 1, 2, S1, S1], [Pack Qty, 3, 9, 51510.0000, 515100000], [Pack Cost, 12, 13, 4518000.0000, 0045180000000], [APN, 25, 13, 350720000000, 0350720000000], [Filler, 38, 1, 2, 2], [Product, 39, 8, 51730000, 51730000], [pmg dtl tech key, 72, 15, 000 00000000, 000 00000000], [Case Pack id, 87, 15, 00000000, 00000000], [Product Name, 101, 50, 00000000 00000000, 00000000 00000000]]')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5151, 5151], [Pack Quantity 1, 7, 8, 4, 00000004], [DC Number 2, 15, 4, 5180, 5180], [Pack Quantity 2, 19, 8, 3, 00000003], [DC Number 4, 39, 4, 5173, 5173], [Pack Quantity 4, 43, 8, 2, 00000002], [DC Number 5, 51, 4, , ], [Pack Quantity 5, 55, 8, 0, 00000000], [DC Number 6, 63, 4, , ], [Pack Quantity 6, 67, 8, 0, 00000000], [DC Number 7, 75, 4, , ], [Pack Quantity 7, 79, 8, 0, 00000000], [DC Number 8, 87, 4, , ], [Pack Quantity 8, 91, 8, 0, 00000000], [DC Number 9, 99, 4, , ], [Pack Quantity 9, 103, 8, 0, 00000000], [DC Number 10, 111, 4, , ], [Pack Quantity 10, 115, 8, 0, 00000000]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',3(350720000000)')
click('TextArea')
assert_p(
'TextArea', 'Text',
'S1515100000004518000000003507200000002517300000002 00000000 00000000 00000000 00000000 00000000 00000000'
)
click('Right')
## select('LayoutCombo', 'ams PO Download: Detail')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(150650000000)')
assert_p('Table', 'Text', '1', commonBits.fl('Data') + ',4')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(33315156)')
## assert_p('Table', 'Content', '[[Record Type, 1, 2, S1, S1], [Pack Qty, 3, 9, 50430.0000, 504300000], [Pack Cost, 12, 13, 1504500.0000, 0015045000000], [APN, 25, 13, 150650000000, 0150650000000], [Filler, 38, 1, 1, 1], [Product, 39, 8, 33315156, 33315156], [pmg dtl tech key, 72, 15, 000 00000000, 000 00000000], [Case Pack id, 87, 15, 00000000, 00000000], [Product Name, 101, 50, 00000000 00000000, 00000000 00000000]]')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5043, 5043], [Pack Quantity 1, 7, 8, 1, 00000001], [DC Number 2, 15, 4, 5045, 5045], [Pack Quantity 2, 19, 8, 1, 00000001], [DC Number 4, 39, 4, 3331, 3331], [Pack Quantity 4, 43, 8, 51560001, 51560001], [DC Number 5, 51, 4, , ], [Pack Quantity 5, 55, 8, 0, 00000000], [DC Number 6, 63, 4, , ], [Pack Quantity 6, 67, 8, 0, 00000000], [DC Number 7, 75, 4, , ], [Pack Quantity 7, 79, 8, 0, 00000000], [DC Number 8, 87, 4, , ], [Pack Quantity 8, 91, 8, 0, 00000000], [DC Number 9, 99, 4, , ], [Pack Quantity 9, 103, 8, 0, 00000000], [DC Number 10, 111, 4, , ], [Pack Quantity 10, 115, 8, 0, 00000000]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',5(33315156)')
click('TextArea')
select('Table',
'cell:' + commonBits.fl('Data') + ',6(000 00000000)')
select('Table',
'cell:' + commonBits.fl('Data') + ',6(000 00000000)')
click('TextArea')
assert_p(
'TextArea', 'Text',
'S1504300000001504500000001506500000001333151560001 00000000 00000000 00000000 00000000 00000000 00000000'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'csv2DTAR020_tst1.bin.csv')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',0(null)')
select('Fields.FieldRelationship_JTbl', 'SALE-PRICE',
commonBits.fl('Field') + ',0')
select('Fields.FieldRelationship_JTbl', commonBits.fl('Starts With'),
commonBits.fl('Operator') + ',0')
select('Fields.FieldRelationship_JTbl', '-',
commonBits.fl('Value') + ',0')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',0()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, -1, -19.00], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, -1, -17.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',0(-)')
rightclick('Fields.FieldRelationship_JTbl', 'And,1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',1(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',1')
select('Fields.FieldRelationship_JTbl', '1',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
## assert_p('Fields.FieldRelationship_JTbl', 'Content', '[[, , SALE-PRICE, true, ' + commonBits.fl('Starts With') + ', -], [' + commonBits.fl('Or') + ', , STORE-NO, true, ' + commonBits.fl('Contains') + ', 1], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ]]')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , SALE-PRICE, true, ' + commonBits.fl('Starts With') +
', -], [' + commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 1], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, -1, -19.00], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, -1, -17.99], [68654655, 166, 40118, 60, 1, 5.08], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30], [68674560, 166, 40118, 170, 1, 5.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',2(null)')
select('Fields.FieldRelationship_JTbl', 'DEPT-NO',
commonBits.fl('Field') + ',2')
select('Fields.FieldRelationship_JTbl', ' = ',
commonBits.fl('Operator') + ',2')
select('Fields.FieldRelationship_JTbl', '80',
commonBits.fl('Value') + ',2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',3()')
## assert_p('Fields.FieldRelationship_JTbl', 'Content', '[[, , SALE-PRICE, true, ' + commonBits.fl('Starts With') + ', -], [' + commonBits.fl('Or') + ', , STORE-NO, true, ' + commonBits.fl('Contains') + ', 1], [, ' + commonBits.fl('And') + ', DEPT-NO, true, = , 80], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ]]')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , SALE-PRICE, true, ' + commonBits.fl('Starts With') +
', -], [' + commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 1], [, ' + commonBits.fl('And') +
', DEPT-NO, true, = , 80], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',3()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, -1, -19.00], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, -1, -17.99], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',3(null)')
select('Fields.FieldRelationship_JTbl', 'KEYCODE-NO',
commonBits.fl('Field') + ',3')
select('Fields.FieldRelationship_JTbl', commonBits.fl('Starts With'),
commonBits.fl('Operator') + ',3')
select('Fields.FieldRelationship_JTbl', '606',
commonBits.fl('Value') + ',3')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',3()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, -1, -19.00], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, -1, -17.99], [60604100, 166, 40118, 80, 1, 13.30]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',3(606)')
rightclick('Fields.FieldRelationship_JTbl', 'And,3')
select('Fields.FieldRelationship_JTbl', '60',
commonBits.fl('Value') + ',3')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',4()')
## assert_p('Fields.FieldRelationship_JTbl', 'Content', '[[, , SALE-PRICE, true, ' + commonBits.fl('Starts With') + ', -], [' + commonBits.fl('Or') + ', , STORE-NO, true, ' + commonBits.fl('Contains') + ', 1], [, ' + commonBits.fl('And') + ', DEPT-NO, true, = , 80], [' + commonBits.fl('Or') + ', , KEYCODE-NO, true, ' + commonBits.fl('Starts With') + ', 60], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') + ', ]]')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , SALE-PRICE, true, ' + commonBits.fl('Starts With') +
', -], [' + commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 1], [, ' + commonBits.fl('And') +
', DEPT-NO, true, = , 80], [' + commonBits.fl('Or') +
', , KEYCODE-NO, true, ' + commonBits.fl('Starts With') +
', 60], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',4()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, -1, -19.00], [62684671, 20, 40118, 685, -1, -69.99], [61664713, 59, 40118, 335, -1, -17.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [60614487, 59, 40118, 878, 1, 5.95], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('File_Txt', commonBits.sampleDir() + 'csv2DTAR020_tst1.bin.csv')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',0(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',0')
select('Fields.FieldRelationship_JTbl', '20',
commonBits.fl('Value') + ',0')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[63604808, 20, 40118, 170, 1, 4.87], [69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, 1, 69.99], [62684671, 20, 40118, 685, -1, -69.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',1(null)')
select('Fields.FieldRelationship_JTbl', 'SALE-PRICE',
commonBits.fl('Field') + ',1')
select('Fields.FieldRelationship_JTbl', '<',
commonBits.fl('Operator') + ',1')
select('Fields.FieldRelationship_JTbl', '6',
commonBits.fl('Value') + ',1')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',2()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[63604808, 20, 40118, 170, 1, 4.87], [69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, -1, -69.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',2(null)')
select('Fields.FieldRelationship_JTbl', 'DEPT-NO',
commonBits.fl('Field') + ',2')
select('Fields.FieldRelationship_JTbl', '8',
commonBits.fl('Value') + ',2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',3()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [62684671, 20, 40118, 685, -1, -69.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl', '80',
commonBits.fl('Value') + ',2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',3()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',3()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',3()')
rightclick('Fields.FieldRelationship_JTbl', 'And,3')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',3(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',3')
select('Fields.FieldRelationship_JTbl', '59',
commonBits.fl('Value') + ',3')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',4()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [' +
commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',4()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99], [61684613, 59, 40118, 335, 1, 12.99], [68634752, 59, 40118, 410, 1, 8.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [60614487, 59, 40118, 878, 1, 5.95]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',4(null)')
select('Fields.FieldRelationship_JTbl', 'SALE-PRICE',
commonBits.fl('Field') + ',4')
select('Fields.FieldRelationship_JTbl', '<',
commonBits.fl('Operator') + ',4')
select('Fields.FieldRelationship_JTbl', '6',
commonBits.fl('Value') + ',4')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',5()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [' +
commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',5()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [61664713, 59, 40118, 335, 1, 17.99], [61664713, 59, 40118, 335, -1, -17.99], [61684613, 59, 40118, 335, 1, 12.99], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [60614487, 59, 40118, 878, 1, 5.95]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',5(null)')
select('Fields.FieldRelationship_JTbl', 'DEPT-NO',
commonBits.fl('Field') + ',5')
select('Fields.FieldRelationship_JTbl', '6',
commonBits.fl('Value') + ',5')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',4(6)')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [' +
commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 6], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',4(6)')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',4(6)')
rightclick('Fields.FieldRelationship_JTbl', 'And,6')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',6(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',6')
select('Fields.FieldRelationship_JTbl', '166',
commonBits.fl('Value') + ',6')
select('Fields.FieldRelationship_JTbl', ' = ',
commonBits.fl('Operator') + ',6')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Operator') + ',6( = )')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [' +
commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 6], [' +
commonBits.fl('Or') + ', , STORE-NO, true, = , 166], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Operator') + ',6( = )')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [68654655, 166, 40118, 60, 1, 5.08], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30], [68674560, 166, 40118, 170, 1, 5.99]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',7(null)')
select('Fields.FieldRelationship_JTbl', 'SALE-PRICE',
commonBits.fl('Field') + ',7')
select('Fields.FieldRelationship_JTbl', '>=',
commonBits.fl('Operator') + ',7')
select('Fields.FieldRelationship_JTbl', '<',
commonBits.fl('Operator') + ',7')
select('Fields.FieldRelationship_JTbl', '5',
commonBits.fl('Value') + ',7')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',8()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [' +
commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 6], [' +
commonBits.fl('Or') + ', , STORE-NO, true, = , 166], [, ' +
commonBits.fl('And') + ', SALE-PRICE, true, <, 5], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',8()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl', '5.09',
commonBits.fl('Value') + ',7')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',8()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [' +
commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 6], [' +
commonBits.fl('Or') + ', , STORE-NO, true, = , 166], [, ' +
commonBits.fl('And') + ', SALE-PRICE, true, <, 5.09], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',8()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [68654655, 166, 40118, 60, 1, 5.08], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',8(null)')
select('Fields.FieldRelationship_JTbl', 'DEPT-NO',
commonBits.fl('Field') + ',8')
select('Fields.FieldRelationship_JTbl', '80',
commonBits.fl('Value') + ',8')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',9()')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [' +
commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 6], [' +
commonBits.fl('Or') + ', , STORE-NO, true, = , 166], [, ' +
commonBits.fl('And') + ', SALE-PRICE, true, <, 5.09], [, ' +
commonBits.fl('And') + ', DEPT-NO, true, ' +
commonBits.fl('Contains') + ', 80], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',9()')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30]]'
)
click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',9()')
rightclick('Fields.FieldRelationship_JTbl', 'And,9')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Field') + ',9(null)')
select('Fields.FieldRelationship_JTbl', 'STORE-NO',
commonBits.fl('Field') + ',9')
select('Fields.FieldRelationship_JTbl', '166',
commonBits.fl('Value') + ',9')
select('Fields.FieldRelationship_JTbl', 'KEYCODE-NO',
commonBits.fl('Field') + ',10')
select('Fields.FieldRelationship_JTbl', '8',
commonBits.fl('Value') + ',10')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',9(166)')
assert_p(
'Fields.FieldRelationship_JTbl', 'Content',
'[[, , STORE-NO, true, ' + commonBits.fl('Contains') +
', 20], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 80], [' +
commonBits.fl('Or') + ', , STORE-NO, true, ' +
commonBits.fl('Contains') + ', 59], [, ' + commonBits.fl('And') +
', SALE-PRICE, true, <, 6], [, ' + commonBits.fl('And') +
', DEPT-NO, true, ' + commonBits.fl('Contains') + ', 6], [' +
commonBits.fl('Or') + ', , STORE-NO, true, = , 166], [, ' +
commonBits.fl('And') + ', SALE-PRICE, true, <, 5.09], [, ' +
commonBits.fl('And') + ', DEPT-NO, true, ' +
commonBits.fl('Contains') + ', 80], [' + commonBits.fl('Or') +
', , STORE-NO, true, ' + commonBits.fl('Contains') +
', 166], [, ' + commonBits.fl('And') + ', KEYCODE-NO, true, ' +
commonBits.fl('Contains') + ', 8], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ], [, ' + commonBits.fl('And') +
', , true, ' + commonBits.fl('Contains') + ', ], [, ' +
commonBits.fl('And') + ', , true, ' + commonBits.fl('Contains') +
', ], [, ' + commonBits.fl('And') + ', , true, ' +
commonBits.fl('Contains') + ', ]]')
select('Fields.FieldRelationship_JTbl',
'cell:' + commonBits.fl('Value') + ',9(166)')
commonBits.filter(click)
assert_p(
'LineList.FileDisplay_JTbl', 'Content',
'[[69684558, 20, 40118, 280, 1, 19.00], [69684558, 20, 40118, 280, -1, -19.00], [69694158, 20, 40118, 280, 1, 5.01], [60694698, 59, 40118, 620, 1, 3.99], [60664659, 59, 40118, 620, 1, 3.99], [68654655, 166, 40118, 60, 1, 5.08], [69624033, 166, 40118, 80, 1, 18.19], [60604100, 166, 40118, 80, 1, 13.30], [68674560, 166, 40118, 170, 1, 5.99]]'
)
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.5.0_11'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
click(commonBits.fl('Edit') + '1')
click('Filter1')
select('Table', 'false', commonBits.fl('Include') + ',0')
select('Table', 'false', commonBits.fl('Include') + ',2')
#select('Table', 'cell:' + commonBits.fl('Include') + ',2(false)')
##click('Filter1')
commonBits.filter(click)
select('Table', 'cell:8 - 10|Vendor,2(6228)')
assert_p('Table', 'Content', '[[H1, 45.349, 6060, 286225, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [H1, 45.350, 6228, 222227, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [H1, 45.351, 6228, 222243, 040909, , 00, , 200, 050102, 050107, , , , LADIES KNI, C, FT], [H1, 45.352, 5341, 294915, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [H1, 45.353, 5341, 294987, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [H1, 45.354, 5341, 295139, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [H1, 45.355, 5341, 303662, 041110, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT], [H1, 45.356, 5341, 304100, 041111, , 00, , 310, 041231, 050107, P, , , YOUTH SHOE, C, FT]]')
select('Table', 'cell:8 - 10|Vendor,3(5341)')
assert_p('Table', 'RowCount', '8')
select('Table', 'cell:8 - 10|Vendor,3(5341)')
select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Sorted Field Tree'))
## select('Table1', 'cell:8 - 10|Vendor,3(5341)')
select('List', 'ams PO Download: Detail')
select('List', 'ams PO Download: Header')
select('Table', 'Entry Date', commonBits.fl('Field') + ',0')
select('Table', 'Vendor', commonBits.fl('Field') + ',1')
select('Table', 'cell:' + commonBits.fl('Field') + ',1(Vendor)')
click(commonBits.fl('Build Tree'))
## select('JTreeTable', 'cell:APN,1(null)')
select('JTreeTable', 'cell:Record Type,1(null)')
assert_p('JTreeTable', 'RowCount', '4')
## select('JTreeTable', 'cell:Pack Qty,1(null)')
## rightclick('JTreeTable', 'Pack Qty,1')
select('JTreeTable', 'cell:Vendor,1(null)')
rightclick('JTreeTable', 'Vendor,1')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',2(null)')
assert_p('JTreeTable', 'RowCount', '5')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',3(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',3')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',2(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',2')
select_menu(commonBits.fl('Expand Tree'))
select('JTreeTable', 'cell:Record Type,3(H1)')
select('JTreeTable', 'cell:Record Type,3(H1)')
select('LayoutCombo', 'ams PO Download: Header')
select('JTreeTable', 'cell:PO,4(294987)')
if commonBits.version() == 'MsAccess':
assert_p('JTreeTable', 'Content', '[[, , , , , , , , , , , , , , , , , , ], [, , D1, , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ], [, , H1, 45.352, 5341, 294915, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.353, 5341, 294987, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.354, 5341, 295139, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ]]')
else:
assert_p('JTreeTable', 'Content', '[[, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ], [, , H1, 45.352, 5341, 294915, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.353, 5341, 294987, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.354, 5341, 295139, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ]]')
## assert_p('JTreeTable', 'Content', '[[, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ], [, , H1, 45.352, 5341, 294915, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.353, 5341, 294987, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , H1, 45.354, 5341, 295139, 041013, , 00, , 475, 041231, 050107, P, , , WOMENS SHO, C, FT], [, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ], [, , , , , , , , , , , , , , , , , , ]]')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',2(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',2')
select_menu(commonBits.fl('Collapse Tree'))
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',1(null)')
rightclick('JTreeTable', commonBits.fl('Tree') + ',1')
select_menu(commonBits.fl('Collapse Tree'))
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',1(null)')
select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Record View #{Selected Records#}'))
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',1(null)')
select('Table', 'cell:' + commonBits.fl('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:' + commonBits.fl('Data') + ',1(45.352)')
click('RightM')
assert_p('Table', 'Text', '')
doubleclick('TextField')
assert_p('TextField', 'Text', '3')
select('Table', 'cell:' + commonBits.fl('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]]')
select('Table', 'cell:' + commonBits.fl('Data') + ',3(295139)')
click('Left')
select('Table', 'cell:' + commonBits.fl('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:' + commonBits.fl('Data') + ',3(294987)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('JTreeTable', 'cell:' + commonBits.fl('Tree') + ',1(null)')
close()
