def test():
from Modules import commonBits
java_recorded_version = '1.6.0_22'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'DTAR020~~.bin')
select('ComboBox2', 'DTAR020')
click('Edit1')
select('Table', '11', 'Data,0')
select('Table', '0.11', 'Data,5')
select('Table', 'cell:Data,3(0)')
click('Save1')
click('Save1')
if commonBits.isNimbusLook():
click('InternalFrameTitlePane.closeButton')
click('InternalFrameTitlePane.closeButton')
else:
click('BasicInternalFrameTitlePane$NoFocusButton2')
click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Edit1')
assert_p('Table', 'Content', '[[11, 0, 0, 0, 0, 0.11]]')
click('Delete2')
click('Save1')
if commonBits.isNimbusLook():
click('InternalFrameTitlePane.closeButton')
else:
click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Edit1')
assert_p(
'Table', 'Content',
'[[KEYCODE-NO, 1, 8, , , ], [STORE-NO, 9, 2, 0, , ], [DATE, 11, 4, 0, , ], [DEPT-NO, 15, 2, 0, , ], [QTY-SOLD, 17, 5, 0, , ], [SALE-PRICE, 22, 6, 0.00, , ]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'Ams_PODownload_20050101.txt')
click(commonBits.fl('Layout Wizard'))
select('Multiple Records #{fixed length#}', 'true')
click('Right')
select('TabbedPane', '')
## select('Table', '')
rightclick('Table', 'B,0')
assert_p('TextField1', 'Text', '1')
assert_p('TextField2', 'Text', '1')
select('CheckBox', 'true')
select('CheckBox', 'false')
assert_p('Table', 'Content', '[[H, 1, 4, 5, 3, 5, 7, 0, 0, 0, 0, 0, 0, 4, 3, 3, 8, 0, 0, 0, 0, 0, 0, 2, 3, 3, 8, 6, 3, 0, 4, 0, 9, 2, 9, , , , , , , , , 0, 0, , , 2, 9, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 7, 5, 9, 6, 6, , , , , , , , , O, P, T, I, O, N, S, , P, L, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 4, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 8, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 4, 5, 8, 7, 2, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 4, 5, 4, 4, 0, 0, 0, 0, 0, 4, 4, , , , , , , , 2, 1, 1, 7, 0, 9, 3, , , , , , , , , 4, 5, 8, 7, 2, 0, 7, 8, , , , , , , , M, T, H, 5, 0, 3, 3, H, , D, U, S, T, Y, , P, I, N, K, , L, /, S, , F, A, N, C, Y, , C, R, E, W, , C, \', M, E, R, E, , C, A, R, D, I, G, A, N], [S, 1, 5, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 9, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 3, 3, 0, 0, 0, 0, 0, 0, 0, 1, 3, 3, 3, 7, 2, 0, 7, 8, 0, 0, 0, 1, 5, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 5, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 5, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 9, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 6, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 1, 4, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 6, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 5, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 9, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 5, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [H, 1, 4, 5, 3, 5, 8, 0, 0, 0, 0, 0, 0, 4, 3, 3, 8, 0, 0, 0, 0, 0, 0, 2, 3, 3, 8, 7, 2, 0, 4, 0, 9, 2, 9, , , , , , , , , 0, 0, , , 2, 9, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 7, 5, 9, 6, 5, , , , , , , , , O, P, T, I, O, N, S, , P, L, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 9, 8, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 4, 3, 3, 7, 2, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 4, 5, 4, 4, 0, 0, 0, 0, 0, 1, 4, , , , , , , , 2, 1, 1, 7, 1, 5, 2, , , , , , , , , 4, 5, 8, 7, 2, 0, 7, 8, , , , , , , , M, T, H, 5, 0, 3, 3, H, , D, U, S, T, Y, , P, I, N, K, , L, /, S, , F, A, N, C, Y, , C, R, E, W, , C, \', M, E, R, E, , C, A, R, D, I, G, A, N], [S, 1, 5, 0, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 5, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 8, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 1, 5, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 8, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 3, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [H, 1, 4, 5, 3, 5, 9, 0, 0, 0, 0, 0, 0, 4, 4, 6, 8, 0, 0, 0, 0, 0, 0, 2, 5, 5, 9, 0, 6, 0, 4, 0, 9, 2, 9, , , , , , , , , 0, 0, , , 2, 9, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 7, 5, 9, 6, 6, , , , , , , , , O, P, T, I, O, N, S, , P, L, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 2, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 4, 5, 8, 7, 4, 7, 5, 1, 0, 0, 0, 0, 0, 0, 0, 4, 0, 9, 0, 0, 0, 0, 0, 0, 2, 9, , , , , , , , 2, 1, 1, 7, 3, 3, 7, , , , , , , , , 4, 5, 8, 7, 2, 0, 7, 8, , , , , , , , M, T, H, 5, 0, 3, 0, H, , B, L, K, , L, /, S, , V, L, V, T, , R, I, B, B, O, N, , S, C, O, O, P, , C, \', M, E, R, E, , W, /, B, R, O, O, C, H], [S, 1, 5, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 9, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 2, 3, 5, 3, 3, 4, 7, 5, 1, 0, 0, 0, 1, 5, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 4, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 1, 6, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 6, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 8, 9, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 4, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 1, 6, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 9, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 5, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [H, 1, 4, 5, 3, 6, 0, 0, 0, 0, 0, 0, 0, 4, 4, 4, 8, 2, 9, 0, 9, 0, 8, , , , , , , 0, 4, 0, 9, 2, 9, , , , , , , , , 0, 0, , , 2, 9, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 7, 5, 9, 6, 7, , , , , , , , , O, P, T, I, O, N, S, , P, L, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 9, 4, 4, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, , 4, 5, 8, 7, 4, 7, 5, 1, 0, 0, 0, 0, 0, 0, 0, 4, 0, 9, 0, 0, 0, 0, 0, 0, 1, 4, , , , , , , , 2, 1, 1, 7, 3, 4, 7, , , , , , , , , 3, 5, 8, 7, 4, 7, 5, 1, , , , , , , , M, T, H, 5, 0, 3, 0, H, , B, L, K, , L, /, S, , V, L, V, T, , R, I, B, B, O, N, , S, C, O, O, P, , C, \', M, E, R, E, , W, /, B, R, O, O, C, H], [S, 1, 5, 0, 8, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 5, 0, 0, 0, 0, 0, 0, 0, 1, 3, 5, 8, 4, 4, 7, 5, 1, 0, 0, 0, 1, 5, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 2, 7, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 3, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 8, 4, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [H, 1, 4, 5, 3, 6, 1, 0, 0, 0, 0, 0, 0, 4, 2, 2, 8, 0, 0, 0, 0, 0, 0, 2, 9, 2, 2, 1, 0, 0, 4, 0, 9, 2, 9, , , , , , , , , 0, 0, , , 2, 9, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 7, 5, 9, 6, 5, , , , , , , , , O, P, T, I, O, N, S, , P, L, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2, 5, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 5, 8, 7, 4, 7, 5, 1, 0, 0, 0, 0, 0, 0, 0, 4, 0, 9, 0, 0, 0, 0, 0, 0, 1, 2, , , , , , , , 2, 1, 1, 7, 3, 5, 4, , , , , , , , , 3, 5, 8, 7, 4, 7, 5, 1, , , , , , , , M, T, H, 5, 0, 3, 0, H, , B, L, K, , L, /, S, , V, L, V, T, , R, I, B, B, O, N, , S, C, O, O, P, , C, \', M, E, R, E, , W, /, B, R, O, O, C, H], [S, 1, 5, 0, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 5, 0, 0, 0, 0, 0, 0, 0, 1, 3, 5, 3, 3, 4, 7, 5, 1, 0, 0, 0, 1, 5, 0, 6, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 8, 0, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 3, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [H, 1, 4, 5, 3, 6, 2, 0, 0, 0, 0, 0, 0, 5, 2, 2, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 9, 8, 4, 0, 4, 0, 9, 2, 9, , , , , , , , , 0, 0, , , 2, 0, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 7, 5, 9, 6, 5, , , , , , , , , L, A, D, I, E, S, , K, N, I, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 8, 4, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 1, 1, 9, 1, 6, 9, 7, 0, 0, 0, 0, 0, 0, 0, 2, 7, 2, 6, 0, 0, 0, 0, 0, 1, 1, , , , , , , , 2, 3, 2, 7, 9, 2, 8, , , , , , , , , 3, 5, 8, 9, 1, 6, 9, 7, , , , , , , , S, K, Y, , B, L, U, E, , S, K, P, 0, 2, , L, /, W, E, I, G, H, T, , P, O, N, C, H, O, , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 5, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 1, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 1, 8, 0, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 8, 4, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 3, 3, 9, 1, 8, 2, 6, 0, 0, 0, 0, 0, 0, 0, 2, 7, 2, 6, 0, 0, 0, 0, 0, 1, 1, , , , , , , , 2, 3, 2, 7, 9, 3, 1, , , , , , , , , 3, 5, 8, 9, 1, 8, 2, 6, , , , , , , , D, U, S, T, Y, , P, I, N, K, , S, K, P, 0, 2, , L, /, W, E, I, G, H, T, , P, O, N, C, H, O, , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 4, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 5, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 1, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 1, 8, 0, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [H, 1, 4, 5, 3, 6, 3, 0, 0, 0, 0, 0, 0, 5, 1, 1, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 9, 8, 5, 0, 4, 0, 9, 2, 9, , , , , , , , , 0, 0, , , 2, 0, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 7, 5, 9, 6, 6, , , , , , , , , L, A, D, I, E, S, , K, N, I, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 2, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 3, 5, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 1, 1, 9, 1, 6, 9, 7, 0, 0, 0, 0, 0, 0, 0, 2, 7, 2, 6, 0, 0, 0, 0, 0, 2, 8, , , , , , , , 2, 3, 2, 7, 9, 3, 3, , , , , , , , , 3, 5, 8, 9, 1, 6, 9, 7, , , , , , , , S, K, Y, , B, L, U, E, , S, K, P, 0, 2, , L, /, W, E, I, G, H, T, , P, O, N, C, H, O, , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 3, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 3, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 9, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 4, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 9, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 5, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 2, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 3, 5, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 1, 1, 9, 1, 8, 2, 6, 0, 0, 0, 0, 0, 0, 0, 2, 7, 2, 6, 0, 0, 0, 0, 0, 2, 8, , , , , , , , 2, 3, 2, 7, 9, 3, 6, , , , , , , , , 3, 5, 8, 9, 1, 8, 2, 6, , , , , , , , D, U, S, T, Y, , P, I, N, K, , S, K, P, 0, 2, , L, /, W, E, I, G, H, T, , P, O, N, C, H, O, , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 3, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 3, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 9, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 7, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 4, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 9, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 9, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 5, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [H, 1, 4, 5, 3, 6, 4, 0, 0, 0, 0, 0, 0, 5, 1, 1, 0, 0, 0, 0, 0, 0, 0, 2, 1, 1, 9, 8, 7, 0, 4, 0, 9, 2, 9, , , , , , , , , 0, 0, , , 2, 0, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 6, 5, 9, 6, 7, , , , , , , , , L, A, D, I, E, S, , K, N, I, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 3, 5, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 1, 1, 9, 1, 6, 9, 7, 0, 0, 0, 0, 0, 0, 0, 2, 7, 2, 6, 0, 0, 0, 0, 0, 1, 5, , , , , , , , 2, 3, 2, 7, 9, 8, 2, , , , , , , , , 3, 5, 8, 9, 1, 6, 9, 7, , , , , , , , S, K, Y, , B, L, U, E, , S, K, P, 0, 2, , L, /, W, E, I, G, H, T, , P, O, N, C, H, O, , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 2, 7, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 3, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 8, 4, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 3, 5, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 5, 2, 2, 1, 8, 2, 6, 0, 0, 0, 0, 0, 0, 0, 2, 7, 2, 6, 0, 0, 0, 0, 0, 1, 5, , , , , , , , 2, 3, 2, 7, 9, 8, 5, , , , , , , , , 3, 5, 8, 9, 1, 8, 2, 6, , , , , , , , D, U, S, T, Y, , P, I, N, K, , S, K, P, 0, 2, , L, /, W, E, I, G, H, T, , P, O, N, C, H, O, , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 5, 5, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 3, 9, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 2, 7, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 3, 8, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 2, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 7, 4, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 8, 4, 0, 0, 0, 0, 0, 0, 0, 1, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , 0, 0, 0, 0, 0, 0, 0, 0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [H, 1, 4, 5, 3, 6, 5, 0, 0, 0, 0, 0, 1, 3, 1, 1, 2, 0, 0, 0, 0, 0, 0, 2, 1, 1, 5, 4, 9, 0, 4, 1, 0, 0, 5, , , , , , , , , 0, 0, , , 2, 2, 0, , 0, 5, 0, 1, 0, 3, 0, 5, 0, 1, 0, 8, 5, 9, 6, 6, , , , , , , , , L, A, D, I, E, S, , K, N, I, C, F, T, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 1, 2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 7, 2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 5, 1, 1, 6, 9, 7, 9, 0, 0, 0, 0, 0, 0, 0, 2, 2, 7, 2, 0, 0, 0, 0, 1, 2, 3, , , , , , , , 2, 0, 9, 8, 1, 3, 6, , , , , , , , , 3, 5, 9, 2, 6, 9, 7, 9, , , , , , , , S, A, 1, 3, , C, H, O, C, , M, U, S, T, A, N, G, , P, R, T, , R, A, G, L, A, N, , S, W, E, A, T, , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 1, 9, 0, 0, 0, 0, 0, 0, 0, 6, 5, 0, 3, 3, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 3, 5, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 6, 5, 0, 5, 2, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 6, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 6, 5, 0, 8, 1, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 8, 5, 0, 0, 0, 0, 0, 0, 0, 4, 5, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 9, 1, 0, 0, 0, 0, 0, 0, 0, 5, 5, 0, 9, 3, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 9, 5, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 2, 9, 0, 0, 0, 0, 0, 0, 0, 6, 5, 1, 4, 4, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 6, 5, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 1, 5, 1, 6, 9, 0, 0, 0, 0, 0, 0, 0, 4, 5, 1, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 7, 1, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 7, 7, 0, 0, 0, 0, 0, 0, 0, 5, 5, 1, 7, 8, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 1, 6, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 8, 9, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 3, 6, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 4, 6, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 4, 5, 0, 0, 0, 0, 0, 0, 0, 4, 5, 0, 9, 6, 0, 0, 0, 0, 0, 0, 0, 6, 5, 1, 5, 4, 0, 0, 0, 0, 0, 0, 0, 5, 5, 1, 6, 2, 0, 0, 0, 0, 0, 0, 0, 5, 5, 1, 6, 3, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 6, 4, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 9, 2, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 7, 5, 0, 0, 0, 0, 0, 0, 0, 2, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 1, 3, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 7, 2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 5, 1, 1, 7, 2, 0, 4, 0, 0, 0, 0, 0, 0, 0, 2, 2, 7, 2, 0, 0, 0, 0, 1, 3, 3, , , , , , , , 2, 0, 9, 8, 1, 3, 7, , , , , , , , , 3, 5, 9, 2, 7, 2, 0, 4, , , , , , , , S, A, 1, 3, , P, A, L, E, , B, L, U, E, , M, P, , R, A, G, L, E, N, , S, W, E, A, T, , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 1, 9, 0, 0, 0, 0, 0, 0, 0, 7, 5, 0, 3, 3, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 3, 5, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 6, 5, 0, 5, 2, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 6, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 7, 5, 0, 8, 1, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 8, 5, 0, 0, 0, 0, 0, 0, 0, 4, 5, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 9, 1, 0, 0, 0, 0, 0, 0, 0, 6, 5, 0, 9, 3, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 9, 5, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 2, 9, 0, 0, 0, 0, 0, 0, 0, 6, 5, 1, 4, 4, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 6, 5, 0, 0, 0, 0, 0, 0, 0, 2, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 6, 9, 0, 0, 0, 0, 0, 0, 0, 4, 5, 1, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 7, 1, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 7, 7, 0, 0, 0, 0, 0, 0, 0, 6, 5, 1, 7, 8, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 1, 6, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 8, 9, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 3, 6, 0, 0, 0, 0, 0, 0, 0, 2, 5, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 2, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 4, 6, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 4, 5, 0, 0, 0, 0, 0, 0, 0, 4, 5, 0, 9, 6, 0, 0, 0, 0, 0, 0, 0, 6, 5, 1, 5, 4, 0, 0, 0, 0, 0, 0, 0, 5, 5, 1, 6, 2, 0, 0, 0, 0, 0, 0, 0, 5, 5, 1, 6, 3, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 6, 4, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 9, 2, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 2, 5, 1, 7, 5, 0, 0, 0, 0, 0, 0, 0, 2, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [D, 1, 0, 0, 0, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 7, 2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, , 3, 1, 1, 2, 7, 4, 1, 9, 0, 0, 0, 0, 0, 0, 0, 2, 2, 7, 2, 0, 0, 0, 0, 0, 8, 1, , , , , , , , 2, 0, 9, 8, 1, 3, 9, , , , , , , , , 3, 5, 9, 2, 7, 4, 1, 9, , , , , , , , S, A, 1, 3, , P, A, L, E, , P, I, N, K, , M, P, , P, R, T, , R, A, G, L, A, N, , S, W, E, A, T, , , , , , , , , , , , , , , , ], [S, 1, 5, 0, 1, 9, 0, 0, 0, 0, 0, 0, 0, 5, 5, 0, 3, 7, 0, 0, 0, 0, 0, 0, 0, 5, 5, 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 5, 5, 0, 7, 8, 0, 0, 0, 0, 0, 0, 0, 5, 5, 0, 8, 5, 0, 0, 0, 0, 0, 0, 0, 4, 5, 0, 9, 1, 0, 0, 0, 0, 0, 0, 0, 5, 5, 0, 9, 3, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 9, 5, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 2, 9, 0, 0, 0, 0, 0, 0, 0, 5, 5, 1, 4, 4, 0, 0, 0, 0, 0, 0, 0, 3, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ], [S, 1, 5, 1, 6, 9, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 7, 7, 0, 0, 0, 0, 0, 0, 0, 6, 5, 1, 7, 8, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 8, 9, 0, 0, 0, 0, 0, 0, 0, 3, 5, 0, 4, 6, 0, 0, 0, 0, 0, 0, 0, 3, 5, 1, 4, 5, 0, 0, 0, 0, 0, 0, 0, 4, 5, 0, 9, 6, 0, 0, 0, 0, 0, 0, 0, 5, 5, 1, 5, 4, 0, 0, 0, 0, 0, 0, 0, 4, 5, 1, 6, 2, 0, 0, 0, 0, 0, 0, 0, 4, 5, 1, 6, 3, 0, 0, 0, 0, 0, 0, 0, 3, , , , , , , , , , , , , , , , , , , , , , , , , , , , , ]]')
click('Right')
select('TabbedPane', '')
select('Table', 'Header', commonBits.fl('Record Name') + ',0')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',0()')
keystroke('Table', 'Down', commonBits.fl('Record Name') + ',0')
select('Table', 'Detail', commonBits.fl('Record Name') + ',1')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',1()')
keystroke('Table', 'Down', commonBits.fl('Record Name') + ',1')
select('Table', 'Store', commonBits.fl('Record Name') + ',2')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',1(Detail)')
if commonBits.isVersion80():
assert_p('Table', 'Content', '[[H, Header, false, true], [D, Detail, false, true], [S, Store, false, true]]')
else:
assert_p('Table', 'Content', '[[H, Header], [D, Detail], [S, Store]]')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',1(Detail)')
click('Right')
select('TabbedPane', '')
if commonBits.isNimbusLook():
assert_p('Table', 'Background', 'DerivedColor(color=255,255,255 parent=nimbusLightBackground offsets=0.0,0.0,0.0,0 pColor=255,255,255')
else:
assert_p('Table', 'Background', '[r=255,g=255,b=255]')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
if window('Record Editor'):
select('FileChooser',
commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
click(commonBits.fl('Edit') + '1')
select('Table', 'cell:3 - 4|DC Number 1,0(4534)')
rightclick('Table', '1 - 2|Record Type,1')
select('Table', 'cell:3 - 4|DC Number 1,0(4534)')
rightclick('Table', '1 - 2|Record Type,1')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:3 - 4|DC Number 1,0(4534)')
select('Table', '17.0000', commonBits.fl('Data') + ',1')
select('Table', '0.0102', commonBits.fl('Data') + ',2')
select('Table', 'cell:' + commonBits.fl('Data') + ',4()')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 17.0000, 000170000], [Pack Cost, 12, 13, 0.0102, 0000000000102], [APN, 25, 13, 2222500000000, 2222500000000], [Filler, 38, 1, , ], [Product, 39, 8, 43314531, 43314531], [pmg dtl tech key, 72, 15, 2075359, 2075359], [Case Pack id, 87, 15, 45614531, 45614531], [Product Name, 101, 50, DONKEY 24-006607 SHWL WRAP CARD, DONKEY 24-006607 SHWL WRAP CARD]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',4()')
click('Right')
select('Table', '10', commonBits.fl('Data') + ',2')
select('Table', '9045', commonBits.fl('Data') + ',3')
select('Table', '2', commonBits.fl('Data') + ',4')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(5076)')
click('Right')
click('Left')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5043, 5043], [Pack Quantity 1, 7, 8, 10, 00000010], [DC Number 2, 15, 4, 9045, 9045], [Pack Quantity 2, 19, 8, 2, 00000002], [DC Number 4, 39, 4, 5076, 5076], [Pack Quantity 4, 43, 8, 1, 00000001], [DC Number 5, 51, 4, 5079, 5079], [Pack Quantity 5, 55, 8, 1, 00000001], [DC Number 6, 63, 4, 5151, 5151], [Pack Quantity 6, 67, 8, 1, 00000001], [DC Number 7, 75, 4, 5072, 5072], [Pack Quantity 7, 79, 8, 1, 00000001], [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]]'
)
click('Right')
select('Table', '14.0000', commonBits.fl('Data') + ',1')
select('Table', 'cell:' + commonBits.fl('Data') + ',2(148.3200)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 14.0000, 000140000], [Pack Cost, 12, 13, 148.3200, 0000001483200], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 5614944, 05614944], [pmg dtl tech key, 72, 15, 2075360, 2075360], [Case Pack id, 87, 15, 5614944, 5614944], [Product Name, 101, 50, MILK 24-006607 SHWL WRAP CARD, MILK 24-006607 SHWL WRAP CARD]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',2(148.3200)')
click('Right')
select('Table', '11', commonBits.fl('Data') + ',2')
select('Table', 'cell:' + commonBits.fl('Data') + ',4(1)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5045, 5045], [Pack Quantity 1, 7, 8, 11, 00000011], [DC Number 2, 15, 4, 5076, 5076], [Pack Quantity 2, 19, 8, 1, 00000001], [DC Number 4, 39, 4, 3331, 3331], [Pack Quantity 4, 43, 8, 49440001, 49440001], [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') + ',4(1)')
click('Right')
select('Table', '8.0000', commonBits.fl('Data') + ',1')
##select('Table', 'cell:' + commonBits.fl('Data') + ',4()')
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, 55615071, 55615071], [pmg dtl tech key, 72, 15, 2075361, 2075361], [Case Pack id, 87, 15, 55615071, 55615071], [Product Name, 101, 50, M.ROSE 24-006607 SHWL WRAP CARD, M.ROSE 24-006607 SHWL WRAP CARD]]'
)
select('Table', '48.3200', commonBits.fl('Data') + ',2')
select('Table', '48.3200', commonBits.fl('Data') + ',2')
##select('Table', '48.3200', 'Data,2')
select('Table', 'cell:' + commonBits.fl('Data') + ',4()')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, D1, D1], [Pack Qty, 3, 9, 8.0000, 000080000], [Pack Cost, 12, 13, 48.3200, 0000000483200], [APN, 25, 13, 0, 0000000000000], [Filler, 38, 1, , ], [Product, 39, 8, 55615071, 55615071], [pmg dtl tech key, 72, 15, 2075361, 2075361], [Case Pack id, 87, 15, 55615071, 55615071], [Product Name, 101, 50, M.ROSE 24-006607 SHWL WRAP CARD, M.ROSE 24-006607 SHWL WRAP CARD]]'
)
select('Table', 'cell:' + commonBits.fl('Data') + ',4()')
click('Right')
select('Table', '6', commonBits.fl('Data') + ',2')
select('Table', '51', commonBits.fl('Data') + ',4')
select('Table', 'cell:' + commonBits.fl('Data') + ',5(3331)')
assert_p(
'Table', 'Content',
'[[Record Type, 1, 2, S1, S1], [DC Number 1, 3, 4, 5036, 5036], [Pack Quantity 1, 7, 8, 6, 00000006], [DC Number 2, 15, 4, 5043, 5043], [Pack Quantity 2, 19, 8, 51, 00000051], [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') + ',5(3331)')
# if commonBits.isVersion80():
# select_menu('Edit>>Compare with Disk')
# else:
commonBits.selectOldFilemenu(select_menu, 'Utilities',
'Compare with Disk')
## select('Table1', 'cell:' + commonBits.fl('Data') + ',5(3331)')
assert_p('Table', 'Enabled', 'true')
assert_p(
'Table', 'Content',
'[[, Old, 2, D1, 7.0000, 0.0002, 2222500000000, , 43314531, 2075359, 45614531, DONKEY 24-006607 SHWL WRAP CARD, , , , , , , , , , ], [, New, 2, , 17.0000, 0.0102, , , , , , , , , , , , , , , , ], [, Old, 3, S1, 5043, 1, 5045, 1, 5076, 1, 5079, 1, 5151, 1, 5072, 1, , 0, , 0, , 0], [, New, 3, , , 10, 9045, 2, , , , , , , , , , , , , , ], [, Old, 4, D1, 4.0000, 148.3200, 0, , 5614944, 2075360, 5614944, MILK 24-006607 SHWL WRAP CARD, , , , , , , , , , ], [, New, 4, , 14.0000, , , , , , , , , , , , , , , , , ], [, Old, 5, S1, 5045, 1, 5076, 1, 3331, 49440001, , 0, , 0, , 0, , 0, , 0, , 0], [, New, 5, , , 11, , , , , , , , , , , , , , , , ], [, Old, 6, D1, 48.0000, 148.3200, 0, , 55615071, 2075361, 55615071, M.ROSE 24-006607 SHWL WRAP CARD, , , , , , , , , , ], [, New, 6, , 8.0000, 48.3200, , , , , , , , , , , , , , , , ], [, Old, 7, S1, 5036, 3, 5043, 5, 3331, 50710003, 5065, 4, 5069, 4, 5076, 4, 5079, 2, 5094, 4, 5128, 3], [, New, 7, , , 6, , 51, , , , , , , , , , , , , , ]]'
)
if commonBits.isNimbusLook():
assert_p('Table', 'Foreground', '[r=35,g=35,b=36]')
else:
assert_p('Table', 'Foreground', '[r=51,g=51,b=51]')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
# select('Table', 'cell:' + commonBits.fl('Data') + ',5(3331)')
## select('Table', 'cell:' + commonBits.fl('Data') + ',5(3331)')
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Record:'))
select('Table', 'cell:' + commonBits.fl('Data') + ',5(3331)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select('Table', 'cell:3 - 4|DC Number 1,0(4534)')
select('Table', 'cell:3 - 4|DC Number 1,0(4534)')
select_menu(
commonBits.fl('Window') + '>>Ams_PODownload_20041231.txt>>' +
commonBits.fl('Table:'))
select('Table', 'cell:3 - 4|DC Number 1,0(4534)')
if commonBits.isVersion81():
click('Export')
else:
click('SaveAs')
select('FileChooser',
commonBits.sampleDir() + 'Ams_PODownload_20041231_Compare.txt')
click(commonBits.fl('Save File'))
select('Table', 'cell:3 - 4|DC Number 1,0(4534)')
select('Table', 'cell:3 - 4|DC Number 1,0(4534)')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'DTAR1000_Store_file_std.bin')
click(commonBits.fl('Layout Wizard'))
click('Right')
select('TabbedPane', '')
assert_p('TextField1', 'Text', 'cp037')
if commonBits.isVersion80():
assert_p('TextField', 'Text', '')
else:
assert_p('TextField', 'Text', '100')
## assert_p('EditorPane', 'Text', '''<html>
## <head>
##
## </head>
## <body>
## <h3>
## File Structure
## </h3>
## <p>
## This screen lets you select the File structure.<br>For Standard Windows
## / Unix files use <b>Text IO</b>.<br>For Fixed width files, You can click
## on the Start of the second record to set the length.
## </p>
## </body>
##</html>
##''')
# assert_p('EditorPane', 'Text', '''<html>
# <head>
#
# </head>
# <body>
# ''' + commonBits.fl('''<h3>
# File Structure
# </h3>
# <p>
# This screen lets you select the File structure.<br>For Standard Windows
# / Unix files use <b>Text IO</b>.<br>For Fixed width files, You can click
# on the Start of the second record to set the length.''') + '''
# </p>
# </body>
#</html>
#''')
click('Right')
select('TabbedPane', '')
if commonBits.isNimbusLook():
assert_p('Table', 'Background', 'DerivedColor(color=255,255,255 parent=nimbusLightBackground offsets=0.0,0.0,0.0,0 pColor=255,255,255')
else:
assert_p('Table', 'Background', '[r=255,g=255,b=255]')
click('Right')
select('TabbedPane', '')
assert_p('Table', 'Content', '[[, 1, 2, 35, 0, true], [, 3, 2, 35, 0, true], [, 5, 2, 0, 0, true], [, 7, 48, 0, 0, true], [, 55, 6, 0, 0, true]]')
assert_p('Table1', 'Content', '[[1, 20, V , Geelong , NYNNNN], [2, 40, Q , Coffs Harbour , NYNNNN], [3, 40, Q , Mackay , NYNNNN], [4, 20, V , Ballarat , NYNNNN], [5, 20, V , Albury , NYNNNN], [6, 20, V , Wodonga , NYNNNN], [7, 20, V , Shepparton , NYNNNN], [8, 20, V , Bendigo , NYNNNN], [9, 50, S , Centrepoint , NYNNNN], [10, 40, Q , Earlville , NYNNNN], [11, 10, N , Cessnock , NYNNNN], [12, 20, V , Ringwood , NYNNNN], [15, 10, N , Bankstown , NYNNNN], [16, 10, N , Glendale , NYNNNN], [19, 10, N , Penrith , NYNNNN], [20, 40, Q , Indooroopilly , NYNNNN], [21, 50, S , Tea Tree Plaza , NYNNNN], [23, 20, V , Warnambool , NYNNNN], [24, 50, S , Newton , NYNNNN], [25, 50, S , Fulham Gardens , NYNNNN], [26, 50, S , Edwardstown , NYNNNN], [27, 40, Q , Runaway Bay , NYNNNN], [28, 20, V , Launceston , NYNNNN], [30, 20, V , Epping , NYNNNN], [32, 20, V , Camberwell , NYNNNN], [33, 10, Y , Blacktown (Closed) , NYNNNN], [35, 10, N , Rockdale , NYNNNN], [36, 60, W , Fremantle , NYNNNN], [21, 10, N , Miranda , NYNNNN], [38, 40, Q , Maroochydore , NYNNNN], [39, 20, V , Colac , NYNNNN], [40, 40, Q , Tweed Heads , NYNNNN], [42, 20, V , Reservoir , NYNNNN], [43, 60, W , Morley , NYNNNN], [44, 50, S , Mt Gambier , NYNNNN], [45, 60, W , Carousel , NYNNNN], [46, 10, N , Dubbo , NYNNNN], [47, 50, S , Sefton Park , NYNNNN], [48, 40, Q , Bundaberg , NYNNNN], [49, 40, Q , Rockhampton , NYNNNN], [52, 10, N , Eastwood , NYNNNN], [54, 20, V , Highpoint City , NYNNNN], [55, 10, N , Leichhardt , NYNNNN], [57, 60, W , Victoria Park , NYNNNN], [58, 20, V , Knox City , NYNNNN], [59, 40, Q , Buranda , NYNNNN], [60, 10, N , St Marys , NYNNNN], [61, 20, V , Waverley Gardens , NYNNNN], [62, 40, Q , Castletown , NYNNNN], [64, 20, V , Hoppers Crossing , NYNNNN], [65, 60, W , Innaloo , NYNNNN], [67, 20, V , Morwell Mid Valley , NYNNNN], [68, 40, Q , Mt Gravatt , NYNNNN], [69, 60, W , Midland , NYNNNN], [70, 10, N , Bass Hill , NYNNNN], [72, 60, W , Geraldton , NYNNNN], [73, 40, Q , Southport , NYNNNN], [74, 10, N , Campbelltown , NYNNNN], [75, 20, V , Sale , NYNNNN], [76, 60, W , Bull Creek , NYNNNN]]')
select('Table', 'store', commonBits.fl('Field Name') + ',0')
select('Table', 'region', commonBits.fl('Field Name') + ',1')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',1()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',1')
select('Table', 'StateChar', commonBits.fl('Field Name') + ',2')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',2()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',2')
select('Table', 'name', commonBits.fl('Field Name') + ',3')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',3()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',3')
select('Table', 'flags', commonBits.fl('Field Name') + ',4')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',1(region)')
assert_p('Table', 'Content', '[[store, 1, 2, 35, 0, true], [region, 3, 2, 35, 0, true], [StateChar, 5, 2, 0, 0, true], [name, 7, 48, 0, 0, true], [flags, 55, 6, 0, 0, true]]')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',1(region)')
assert_p('Table1', 'Content', '[[1, 20, V , Geelong , NYNNNN], [2, 40, Q , Coffs Harbour , NYNNNN], [3, 40, Q , Mackay , NYNNNN], [4, 20, V , Ballarat , NYNNNN], [5, 20, V , Albury , NYNNNN], [6, 20, V , Wodonga , NYNNNN], [7, 20, V , Shepparton , NYNNNN], [8, 20, V , Bendigo , NYNNNN], [9, 50, S , Centrepoint , NYNNNN], [10, 40, Q , Earlville , NYNNNN], [11, 10, N , Cessnock , NYNNNN], [12, 20, V , Ringwood , NYNNNN], [15, 10, N , Bankstown , NYNNNN], [16, 10, N , Glendale , NYNNNN], [19, 10, N , Penrith , NYNNNN], [20, 40, Q , Indooroopilly , NYNNNN], [21, 50, S , Tea Tree Plaza , NYNNNN], [23, 20, V , Warnambool , NYNNNN], [24, 50, S , Newton , NYNNNN], [25, 50, S , Fulham Gardens , NYNNNN], [26, 50, S , Edwardstown , NYNNNN], [27, 40, Q , Runaway Bay , NYNNNN], [28, 20, V , Launceston , NYNNNN], [30, 20, V , Epping , NYNNNN], [32, 20, V , Camberwell , NYNNNN], [33, 10, Y , Blacktown (Closed) , NYNNNN], [35, 10, N , Rockdale , NYNNNN], [36, 60, W , Fremantle , NYNNNN], [21, 10, N , Miranda , NYNNNN], [38, 40, Q , Maroochydore , NYNNNN], [39, 20, V , Colac , NYNNNN], [40, 40, Q , Tweed Heads , NYNNNN], [42, 20, V , Reservoir , NYNNNN], [43, 60, W , Morley , NYNNNN], [44, 50, S , Mt Gambier , NYNNNN], [45, 60, W , Carousel , NYNNNN], [46, 10, N , Dubbo , NYNNNN], [47, 50, S , Sefton Park , NYNNNN], [48, 40, Q , Bundaberg , NYNNNN], [49, 40, Q , Rockhampton , NYNNNN], [52, 10, N , Eastwood , NYNNNN], [54, 20, V , Highpoint City , NYNNNN], [55, 10, N , Leichhardt , NYNNNN], [57, 60, W , Victoria Park , NYNNNN], [58, 20, V , Knox City , NYNNNN], [59, 40, Q , Buranda , NYNNNN], [60, 10, N , St Marys , NYNNNN], [61, 20, V , Waverley Gardens , NYNNNN], [62, 40, Q , Castletown , NYNNNN], [64, 20, V , Hoppers Crossing , NYNNNN], [65, 60, W , Innaloo , NYNNNN], [67, 20, V , Morwell Mid Valley , NYNNNN], [68, 40, Q , Mt Gravatt , NYNNNN], [69, 60, W , Midland , NYNNNN], [70, 10, N , Bass Hill , NYNNNN], [72, 60, W , Geraldton , NYNNNN], [73, 40, Q , Southport , NYNNNN], [74, 10, N , Campbelltown , NYNNNN], [75, 20, V , Sale , NYNNNN], [76, 60, W , Bull Creek , NYNNNN]]')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',1(region)')
click('Right')
select('TabbedPane', '')
select('TextField', 'Wizard_DTAR1000')
click('Right')
select('Table', 'rows:[2,3,4,5,6,7,8,9,10],columns:[5 - 2|StateChar]')
select_menu(commonBits.fl('View') + '>>' + commonBits.fl('Table View #{Selected Records#}'))
# select('Table2', 'rows:[2,3,4,5,6,7,8,9,10],columns:[5 - 2|StateChar]')
assert_p('Table', 'Content', '[[3, 40, Q, Mackay, NYNNNN], [4, 20, V, Ballarat, NYNNNN], [5, 20, V, Albury, NYNNNN], [6, 20, V, Wodonga, NYNNNN], [7, 20, V, Shepparton, NYNNNN], [8, 20, V, Bendigo, NYNNNN], [9, 50, S, Centrepoint, NYNNNN], [10, 40, Q, Earlville, NYNNNN], [11, 10, N, Cessnock, NYNNNN]]')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
# select('Table', 'rows:[2,3,4,5,6,7,8,9,10],columns:[5 - 2|StateChar]')
# select('Table', 'rows:[2,3,4,5,6,7,8,9,10],columns:[5 - 2|StateChar]')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Open')
## select('ComboBox1', 'Mainframe')
select('ComboBox2', 'DTAR1000 VB')
click(commonBits.fl('Edit') + '1')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(commonBits.fl('Record Layouts') + '>>' + commonBits.fl('Edit Layout'))
select('TextField', 'Wizard_DTAR1000')
select('TextField1', '%')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Fields')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Fields')
##click('Delete3')
commonBits.delete3(click)
if window( commonBits.fl('Delete: Wizard_DTAR1000')):
click('Yes')
close()
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Fields')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Fields')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
if window('Wizard - Generate Copybooks'):
select('FileChooser',
commonBits.sampleDir() + 'Ams_PODownload_20050101.txt')
## click('Create Layout Wizard')
select('Multiple Records #{fixed length#}', 'true')
click('Right')
select('TabbedPane', '')
## assert_p('EditorPane', 'Text', '''<html>
## <head>
##
## </head>
## <body>
## This screen will display the first 60 lines of the file.<br>Indicate the <i>start</i>
## of the <b>Record-Type field</b> by clicking on the starting column<br>Then
## click on the start of the Next Field.<br>To remove a position click on it
## again.
## </body>
##</html>
##''')
## assert_p('EditorPane', 'Text','''<html>
## <head>
##
## </head>
## <body>
## ''' + commonBits.fl('''This screen will display the first 60 lines of the file.<br>Indicate the <i>start</i>
## of the <b>Record-Type field</b> by clicking on the starting column<br>Then
## click on the start of the Next Field.<br>To remove a position click on it
## again.
##''') + '''
## </body>
##</html>
##''' )
assert_p(
'EditorPane', 'Text', '''<html>
<head>
</head>
<body>
''' + commonBits.
fl('''This screen will display the first 60 lines of the file.<br>Indicate the <i>start</i>
of the <b>Record-Type field</b> by clicking on the starting column<br>Then
click on the start of the Next Field.<br>To remove a position click on it
again.''') + '''
</body>
</html>
''')
# select('TextField1', '01')
# select('TextField2', '01')
select('Table', '1', commonBits.fl('Start') + ',0')
select('Table', '1', commonBits.fl('Length') + ',0')
if commonBits.isNimbusLook():
assert_p(
'Table', 'Background',
'DerivedColor(color=255,255,255 parent=nimbusLightBackground offsets=0.0,0.0,0.0,0 pColor=255,255,255'
)
else:
assert_p('Table', 'Background', '[r=255,g=255,b=255]')
click('Right')
select('TabbedPane', '')
keystroke('Right', 'Ctrl+F6')
##select_menu('Window>>File Wizard')
if commonBits.isVersion80():
assert_p(
'Table', 'Content',
'[[H, , false, true], [D, , false, true], [S, , false, true]]')
else:
assert_p('Table', 'Content', '[[H, ], [D, ], [S, ]]')
select('Table', 'Header', commonBits.fl('Record Name') + ',0')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',0()')
keystroke('Table', 'Down', commonBits.fl('Record Name') + ',0')
select('Table', 'Detail', commonBits.fl('Record Name') + ',1')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',1()')
keystroke('Table', 'Down', commonBits.fl('Record Name') + ',1')
select('Table', 'Store', commonBits.fl('Record Name') + ',2')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',2()')
keystroke('Table', 'Up', commonBits.fl('Record Name') + ',2')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',1(Detail)')
if commonBits.isVersion80():
assert_p(
'Table', 'Content',
'[[H, Header, false, true], [D, Detail, false, true], [S, Store, false, true]]'
)
else:
assert_p('Table', 'Content',
'[[H, Header], [D, Detail], [S, Store]]')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',1(Detail)')
click('Right')
select('TabbedPane', '')
if commonBits.isNimbusLook():
assert_p(
'Table', 'Background',
'DerivedColor(color=255,255,255 parent=nimbusLightBackground offsets=0.0,0.0,0.0,0 pColor=255,255,255'
)
else:
assert_p('Table', 'Background', '[r=255,g=255,b=255]')
click('Right')
## assert_p('TextArea', 'Text', commonBits.fl('You must define the Fields all Records. Please update - Detail'))
assert_p(
'TextArea', 'Text',
commonBits.
fl('You must define the Fields for all Records. Please update - Detail'
))
if commonBits.isNimbusLook():
assert_p(
'Table', 'Background',
'DerivedColor(color=255,255,255 parent=nimbusLightBackground offsets=0.0,0.0,0.0,0 pColor=255,255,255'
)
else:
assert_p('Table', 'Background', '[r=255,g=255,b=255]')
select('ComboBox', 'Store')
assert_p('Table', 'Text', 'S', 'A,1')
if commonBits.isNimbusLook():
assert_p(
'Table', 'Background',
'DerivedColor(color=255,255,255 parent=nimbusLightBackground offsets=0.0,0.0,0.0,0 pColor=255,255,255'
)
else:
assert_p('Table', 'Background', '[r=255,g=255,b=255]')
click('Right')
select('TabbedPane', '')
select('Table', 'f1', commonBits.fl('Field Name') + ',1')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',1()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',1')
select('Table', 'f2', commonBits.fl('Field Name') + ',2')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',2()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',2')
select('Table', 'f3', commonBits.fl('Field Name') + ',3')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',3()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',3')
select('Table', 'h4', commonBits.fl('Field Name') + ',4')
select('Table', 'h3', commonBits.fl('Field Name') + ',3')
select('Table', 'h2', commonBits.fl('Field Name') + ',2')
select('Table', 'h1', commonBits.fl('Field Name') + ',1')
select('Table', 'h5', commonBits.fl('Field Name') + ',5')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',5()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',5')
select('Table', 'h6', commonBits.fl('Field Name') + ',6')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',6()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',6')
select('Table', 'h7', commonBits.fl('Field Name') + ',7')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',7()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',7')
select('Table', 'h8', commonBits.fl('Field Name') + ',8')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',8()')
select('Table1', 'cell:h1,1(145358)')
if commonBits.isVersion80():
assert_p(
'Table1', 'Content',
'[[H, 145357, 4338, 233863, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75966, , OPTIONS PLCFT], [H, 145358, 4338, 233872, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75965, , OPTIONS PLCFT], [H, 145359, 4468, 255906, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75966, , OPTIONS PLCFT], [H, 145360, 4448, 290908, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75967, , OPTIONS PLCFT], [H, 145361, 4228, 292210, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75965, , OPTIONS PLCFT], [H, 145362, 5220, 211984, 40929, , 0, , 200, , 5, 1, 3, 5, 1, 75965, , LADIES KNICFT], [H, 145363, 5110, 211985, 40929, , 0, , 200, , 5, 1, 3, 5, 1, 75966, , LADIES KNICFT], [H, 145364, 5110, 211987, 40929, , 0, , 200, , 5, 1, 3, 5, 1, 65967, , LADIES KNICFT], [H, 145365, 13112, 211549, 41005, , 0, , 220, , 5, 1, 3, 5, 1, 85966, , LADIES KNICFT], [H, 145366, 13312, 211555, 41005, , 0, , 220, , 5, 1, 3, 5, 1, 75967, , LADIES KNICFT], [H, 145367, 12212, 222556, 41005, , 0, , 220, , 5, 1, 3, 5, 1, 75965, , LADIES KNICFT], [H, 145368, 1312, 211617, 41005, , 0, , 220, , 5, 1, 3, 5, 1, 175966, , LADIES KNICFT]]'
)
else:
assert_p(
'Table1', 'Content',
'[[H, 145357, 4338, 233863, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75966, , OPTIONS, PLCFT], [H, 145358, 4338, 233872, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75965, , OPTIONS, PLCFT], [H, 145359, 4468, 255906, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75966, , OPTIONS, PLCFT], [H, 145360, 4448, 290908, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75967, , OPTIONS, PLCFT], [H, 145361, 4228, 292210, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75965, , OPTIONS, PLCFT], [H, 145362, 5220, 211984, 4, 929, , 0, , 200, , 5, 1, 3, 5, 1, 75965, , LADIES , KNICFT], [H, 145363, 5110, 211985, 4, 929, , 0, , 200, , 5, 1, 3, 5, 1, 75966, , LADIES , KNICFT], [H, 145364, 5110, 211987, 4, 929, , 0, , 200, , 5, 1, 3, 5, 1, 65967, , LADIES , KNICFT], [H, 145365, 13112, 211549, 4, 1005, , 0, , 220, , 5, 1, 3, 5, 1, 85966, , LADIES , KNICFT], [H, 145366, 13312, 211555, 4, 1005, , 0, , 220, , 5, 1, 3, 5, 1, 75967, , LADIES , KNICFT], [H, 145367, 12212, 222556, 4, 1005, , 0, , 220, , 5, 1, 3, 5, 1, 75965, , LADIES , KNICFT], [H, 145368, 1312, 211617, 4, 1005, , 0, , 220, , 5, 1, 3, 5, 1, 175966, , LADIES , KNICFT]]'
)
select('Table1', 'cell:h1,1(145358)')
select('ComboBox', 'Detail')
select('Table', 'd2', commonBits.fl('Field Name') + ',2')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',2()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',2')
select('Table', 'd3', commonBits.fl('Field Name') + ',3')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',3()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',3')
select('Table', 'd4', commonBits.fl('Field Name') + ',4')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',4()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',4')
select('Table', 'd5', commonBits.fl('Field Name') + ',5')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',5()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',5')
select('Table', 'd6', commonBits.fl('Field Name') + ',6')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',6()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',6')
select('Table', 'd7', commonBits.fl('Field Name') + ',7')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',7()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',7')
select('Table', 'd8', commonBits.fl('Field Name') + ',8')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',8()')
select('Table1', 'cell:d2,1(14)')
if commonBits.isVersion80():
assert_p(
'Table1', 'Content',
'[[D, 1, 44, 11840, 0, , 45872078, 4544, 44, , 2117093, , 45872078, , MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGAN], [D, 1, 14, 11984, 0, , 43372078, 4544, 14, , 2117152, , 45872078, , MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGAN], [D, 1, 29, 10120, 0, , 45874751, 4090, 29, , 2117337, , 45872078, , MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 14, 0, 29440800000000, , 45874751, 4090, 14, , 2117347, , 35874751, , MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 12, 10256, 0, , 35874751, 4090, 12, , 2117354, , 35874751, , MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 11, 5848, 0, , 31191697, 2726, 11, , 2327928, , 35891697, , SKY BLUE SKP02 L/WEIGHT PONCHO ], [D, 1, 11, 5848, 0, , 33391826, 2726, 11, , 2327931, , 35891826, , DUSTY PINK SKP02 L/WEIGHT PONCHO ], [D, 1, 28, 3356, 0, , 31191697, 2726, 28, , 2327933, , 35891697, , SKY BLUE SKP02 L/WEIGHT PONCHO ], [D, 1, 28, 3356, 0, , 31191826, 2726, 28, , 2327936, , 35891826, , DUSTY PINK SKP02 L/WEIGHT PONCHO ], [D, 1, 15, 3356, 0, , 31191697, 2726, 15, , 2327982, , 35891697, , SKY BLUE SKP02 L/WEIGHT PONCHO ], [D, 1, 15, 3356, 0, , 35221826, 2726, 15, , 2327985, , 35891826, , DUSTY PINK SKP02 L/WEIGHT PONCHO ], [D, 1, 123, 6723, 0, , 35116979, 2272, 123, , 2098136, , 35926979, , SA13 CHOC MUSTANG PRT RAGLAN SWEAT ], [D, 1, 133, 6723, 0, , 35117204, 2272, 133, , 2098137, , 35927204, , SA13 PALE BLUE MP RAGLEN SWEAT ], [D, 1, 81, 6723, 0, , 31127419, 2272, 81, , 2098139, , 35927419, , SA13 PALE PINK MP PRT RAGLAN SWEAT ], [D, 1, 49, 6723, 0, , 35333979, 2272, 49, , 2098158, , 35926979, , SA13 CHOC MUSTANG PRT RAGLAN SWEAT ], [D, 1, 49, 6723, 0, , 32227204, 2272, 49, , 2098159, , 35927204, , SA13 PALE BLUE MP RAGLEN SWEAT ], [D, 1, 27, 6723, 0, , 32227419, 2272, 27, , 2098160, , 35927419, , SA13 PALE PINK MP PRT RAGLAN SWEAT ], [D, 1, 24, 6183, 0, , 33336979, 2272, 24, , 2098161, , 35926979, , SA13 CHOC MUSTANG PRT RAGLAN SWEAT ], [D, 1, 24, 6183, 0, , 30027204, 2272, 24, , 2098165, , 35927204, , SA13 PALE BLUE MP RAGLEN SWEAT ], [D, 1, 14, 6183, 0, , 35007419, 2272, 14, , 2098167, , 35927419, , SA13 PALE PINK MP PRT RAGLAN SWEAT ], [D, 1, 109, 11106, 0, , 31129413, 3636, 109, , 2098293, , 35929413, , S4547 PALE BLUE INDIAN PRINT JACKET ], [D, 1, 97, 11106, 0, , 31129710, 3636, 97, , 2098297, , 35929710, , S4547 PALE PINK EAGLE PRINT JACKET ]]'
)
else:
assert_p(
'Table1', 'Content',
'[[D, 1, 44, 11840, 0, , 45872078, 4544, 44, , 2, 117093, , 45872078, , MT, H5, 033H DUSTY , PINK L/S FANCY CREW C\'MERE CARDIGAN], [D, 1, 14, 11984, 0, , 43372078, 4544, 14, , 2, 117152, , 45872078, , MT, H5, 033H DUSTY , PINK L/S FANCY CREW C\'MERE CARDIGAN], [D, 1, 29, 10120, 0, , 45874751, 4090, 29, , 2, 117337, , 45872078, , MT, H5, 030H BLK L/, S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 14, 0, 29440800000000, , 45874751, 4090, 14, , 2, 117347, , 35874751, , MT, H5, 030H BLK L/, S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 12, 10256, 0, , 35874751, 4090, 12, , 2, 117354, , 35874751, , MT, H5, 030H BLK L/, S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 11, 5848, 0, , 31191697, 2726, 11, , 2, 327928, , 35891697, , SK, Y, BLUE SKP02 , L/WEIGHT PONCHO ], [D, 1, 11, 5848, 0, , 33391826, 2726, 11, , 2, 327931, , 35891826, , DU, ST, Y PINK SKP0, 2 L/WEIGHT PONCHO ], [D, 1, 28, 3356, 0, , 31191697, 2726, 28, , 2, 327933, , 35891697, , SK, Y, BLUE SKP02 , L/WEIGHT PONCHO ], [D, 1, 28, 3356, 0, , 31191826, 2726, 28, , 2, 327936, , 35891826, , DU, ST, Y PINK SKP0, 2 L/WEIGHT PONCHO ], [D, 1, 15, 3356, 0, , 31191697, 2726, 15, , 2, 327982, , 35891697, , SK, Y, BLUE SKP02 , L/WEIGHT PONCHO ], [D, 1, 15, 3356, 0, , 35221826, 2726, 15, , 2, 327985, , 35891826, , DU, ST, Y PINK SKP0, 2 L/WEIGHT PONCHO ], [D, 1, 123, 6723, 0, , 35116979, 2272, 123, , 2, 98136, , 35926979, , SA, 13, CHOC MUSTA, NG PRT RAGLAN SWEAT ], [D, 1, 133, 6723, 0, , 35117204, 2272, 133, , 2, 98137, , 35927204, , SA, 13, PALE BLUE , MP RAGLEN SWEAT ], [D, 1, 81, 6723, 0, , 31127419, 2272, 81, , 2, 98139, , 35927419, , SA, 13, PALE PINK , MP PRT RAGLAN SWEAT ], [D, 1, 49, 6723, 0, , 35333979, 2272, 49, , 2, 98158, , 35926979, , SA, 13, CHOC MUSTA, NG PRT RAGLAN SWEAT ], [D, 1, 49, 6723, 0, , 32227204, 2272, 49, , 2, 98159, , 35927204, , SA, 13, PALE BLUE , MP RAGLEN SWEAT ], [D, 1, 27, 6723, 0, , 32227419, 2272, 27, , 2, 98160, , 35927419, , SA, 13, PALE PINK , MP PRT RAGLAN SWEAT ], [D, 1, 24, 6183, 0, , 33336979, 2272, 24, , 2, 98161, , 35926979, , SA, 13, CHOC MUSTA, NG PRT RAGLAN SWEAT ], [D, 1, 24, 6183, 0, , 30027204, 2272, 24, , 2, 98165, , 35927204, , SA, 13, PALE BLUE , MP RAGLEN SWEAT ], [D, 1, 14, 6183, 0, , 35007419, 2272, 14, , 2, 98167, , 35927419, , SA, 13, PALE PINK , MP PRT RAGLAN SWEAT ], [D, 1, 109, 11106, 0, , 31129413, 3636, 109, , 2, 98293, , 35929413, , S4, 54, 7 PALE BLUE, INDIAN PRINT JACKET ], [D, 1, 97, 11106, 0, , 31129710, 3636, 97, , 2, 98297, , 35929710, , S4, 54, 7 PALE PINK, EAGLE PRINT JACKET ]]'
)
select('Table1', 'cell:d2,1(14)')
click('Right')
assert_p(
'TextArea', 'Text',
commonBits.
fl('You must define the field Names in all Records, please update: Store'
))
select('Table', 's2', commonBits.fl('Field Name') + ',2')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',2()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',2')
select('Table', 's3', commonBits.fl('Field Name') + ',3')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',3()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',3')
select('Table', 's4', commonBits.fl('Field Name') + ',4')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',4()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',4')
select('Table', 's5', commonBits.fl('Field Name') + ',5')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',5()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',5')
select('Table', 's6', commonBits.fl('Field Name') + ',6')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',6()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',6')
select('Table', 's7', commonBits.fl('Field Name') + ',7')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',7()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',7')
select('Table', 's8', commonBits.fl('Field Name') + ',8')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',8()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',8')
select('Table', 's9', commonBits.fl('Field Name') + ',9')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',9()')
keystroke('Table', 'Down', commonBits.fl('Field Name') + ',9')
select('Table', 's10', commonBits.fl('Field Name') + ',10')
select('Table', 'cell:' + commonBits.fl('Field Name') + ',10()')
select('Table1', 'cell:B,2(15)')
if commonBits.isVersion80():
assert_p(
'Table1', 'Content',
'[[S, 15015, 15019, 35033, 13337, 20780001, 5037, 1, 5052, 1, 5055, 1, 5060, 2, 5070, 1, 5074, 1], [S, 15078, 15081, 15085, 15090, 1, 5091, 1, 5093, 1, 5095, 1, 5129, 1, 5144, 1, 5165, 1], [S, 15303, 15169, 15170, 15171, 1, 5177, 1, 5016, 1, 5089, 2, 5136, 1, 5011, 1, 5046, 1], [S, 15145, 15096, 25154, 15162, 1, 5163, 1, 5164, 1, 5192, 1, 5150, 1, 5175, 1, , 0], [S, 15036, 15043, 15045, 15057, 1, 5065, 1, 5069, 1, 5076, 1, 5079, 1, 5094, 1, 5128, 1], [S, 15151, 15180, 15072, 15173, 1, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15015, 15019, 25037, 23533, 47510001, 5070, 1, 5078, 1, 5093, 1, 5095, 1, 5129, 1, 5144, 1], [S, 15165, 15170, 15171, 15016, 2, 5089, 2, 5136, 1, 5011, 1, 5046, 1, 5096, 1, 5154, 1], [S, 15162, 15163, 15164, 15192, 1, 5175, 1, , 0, , 0, , 0, , 0, , 0], [S, 15083, 15133, 15155, 13584, 47510001, 5166, 1, 5167, 1, 5049, 1, 5139, 1, 5002, 1, 5027, 1], [S, 15038, 15140, 15174, 15184, 1, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15036, 15043, 15045, 13533, 47510001, 5069, 1, 5076, 1, 5094, 1, 5128, 1, 5151, 1, 5180, 1], [S, 15072, 15173, 1, 0, 0, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15036, 15043, 15045, 15057, 1, 5065, 1, 5069, 1, 5076, 1, 5094, 1, 5128, 1, 5151, 1], [S, 15180, 1, 0, 0, 0, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15036, 15043, 15045, 15057, 1, 5065, 1, 5069, 1, 5076, 1, 5094, 1, 5128, 1, 5151, 1], [S, 15180, 1, 0, 0, 0, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15015, 15019, 15033, 15037, 1, 5060, 1, 5074, 1, 5078, 1, 5085, 1, 5091, 1, 5093, 1], [S, 15095, 15129, 15144, 15169, 1, 5170, 1, 5171, 1, 5177, 1, 5016, 1, 5089, 1, 5136, 1], [S, 15046, 15145, 15096, 15154, 1, 5162, 1, 5164, 1, 5192, 1, 5175, 1, , 0, , 0], [S, 15015, 15019, 15033, 15037, 1, 5060, 1, 5074, 1, 5078, 1, 5085, 1, 5091, 1, 5093, 1], [S, 15095, 15129, 15144, 15169, 1, 5170, 1, 5171, 1, 5177, 1, 5016, 1, 5089, 1, 5136, 1], [S, 15046, 15145, 15096, 15154, 1, 5162, 1, 5164, 1, 5192, 1, 5175, 1, , 0, , 0], [S, 15040, 15020, 15083, 15133, 1, 5135, 1, 5155, 1, 5166, 1, 5139, 1, 5002, 1, 5027, 1], [S, 15038, 15126, 15140, 15174, 1, 5184, 1, , 0, , 0, , 0, , 0, , 0], [S, 15040, 15020, 15083, 15133, 1, 5135, 1, 5155, 1, 5166, 1, 5139, 1, 5002, 1, 5027, 1], [S, 15038, 15126, 15140, 15174, 1, 5184, 1, , 0, , 0, , 0, , 0, , 0], [S, 15015, 25019, 65033, 25035, 2, 5037, 6, 5052, 2, 5055, 2, 5060, 2, 5070, 1, 5074, 6], [S, 15078, 65081, 15085, 45090, 2, 5091, 5, 5093, 3, 5095, 3, 5129, 6, 5144, 3, 5165, 1], [S, 15303, 15169, 45170, 25171, 2, 5177, 5, 5178, 3, 5016, 2, 5089, 3, 5136, 1, 5011, 1], [S, 15046, 35145, 45096, 65154, 5, 5162, 5, 5163, 3, 5164, 2, 5192, 2, 5150, 2, 5175, 2], [S, 15015, 25019, 75033, 25035, 2, 5037, 6, 5052, 2, 5055, 2, 5060, 2, 5070, 2, 5074, 6], [S, 15078, 75081, 25085, 45090, 2, 5091, 6, 5093, 3, 5095, 3, 5129, 6, 5144, 3, 5165, 2], [S, 15303, 25169, 45170, 25171, 2, 5177, 6, 5178, 3, 5016, 2, 5089, 3, 5136, 2, 5011, 2], [S, 15046, 35145, 45096, 65154, 5, 5162, 5, 5163, 3, 5164, 2, 5192, 2, 5150, 2, 5175, 2], [S, 15019, 55037, 55074, 55078, 5, 5085, 4, 5091, 5, 5093, 3, 5095, 3, 5129, 5, 5144, 3], [S, 15169, 35177, 65178, 35089, 3, 5046, 3, 5145, 4, 5096, 5, 5154, 4, 5162, 4, 5163, 3], [S, 15040, 25020, 25059, 15068, 1, 5083, 1, 5084, 2, 5133, 2, 5135, 2, 5155, 2, 5156, 2], [S, 15166, 35167, 25048, 25049, 2, 5139, 2, 5143, 2, 5003, 2, 5002, 2, 5027, 2, 5038, 2], [S, 15073, 25126, 25140, 25174, 3, 5184, 2, , 0, , 0, , 0, , 0, , 0], [S, 15040, 25020, 25059, 15068, 1, 5083, 1, 5084, 2, 5133, 2, 5135, 2, 5155, 2, 5156, 2], [S, 15166, 25167, 25048, 15049, 1, 5139, 2, 5143, 2, 5003, 2, 5010, 1, 5062, 1, 5138, 1], [S, 15141, 15002, 25027, 25038, 2, 5073, 2, 5126, 2, 5140, 2, 5174, 2, 5184, 2, , 0], [S, 15040, 15020, 15068, 15083, 1, 5084, 1, 5133, 1, 5135, 1, 5155, 1, 5156, 1, 5166, 2], [S, 15167, 15048, 15049, 15139, 1, 5143, 1, 5002, 1, 5027, 2, 5038, 2, 5073, 1, 5126, 1], [S, 15140, 15174, 25184, 1, 0, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15036, 25043, 35045, 25057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [S, 15151, 25180, 15072, 15173, 1, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15036, 15043, 25045, 25057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [S, 15151, 25180, 25072, 15173, 2, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15043, 25045, 25065, 15076, 2, 5128, 2, 5151, 2, 5180, 1, 5072, 1, 5173, 1, , 0], [S, 15015, 25019, 45033, 25035, 2, 5037, 4, 5052, 2, 5055, 2, 5060, 2, 5070, 2, 5074, 3], [S, 15078, 45081, 25085, 35090, 2, 5091, 4, 5093, 3, 5095, 4, 5129, 4, 5144, 4, 5165, 2], [S, 15303, 25169, 25170, 25171, 2, 5177, 4, 5016, 4, 5089, 3, 5136, 2, 5011, 3, 5046, 2], [S, 15145, 35096, 45154, 45162, 4, 5163, 3, 5164, 2, 5192, 2, 5150, 2, 5175, 2, , 0], [S, 15015, 25019, 55033, 25037, 5, 5060, 2, 5070, 1, 5074, 3, 5078, 5, 5085, 2, 5090, 2], [S, 15091, 55093, 25095, 35129, 6, 5144, 5, 5165, 2, 5169, 2, 5170, 2, 5171, 2, 5177, 5], [S, 15178, 25016, 45089, 25136, 2, 5011, 2, 5046, 2, 5145, 2, 5096, 5, 5154, 3, 5162, 3], [S, 15163, 25164, 25192, 25175, 1, , 0, , 0, , 0, , 0, , 0, , 0]]'
)
else:
assert_p(
'Table1', 'Content',
'[[S, 15, 15, 15, 19, 35, 33, 13337, 207800015037, 15052, 15055, 15060, 25070, 15074, 1], [S, 15, 78, 15, 81, 15, 85, 15090, 15091, 15093, 15095, 15129, 15144, 15165, 1], [S, 15, 303, 15, 169, 15, 170, 15171, 15177, 15016, 15089, 25136, 15011, 15046, 1], [S, 15, 145, 15, 96, 25, 154, 15162, 15163, 15164, 15192, 15150, 15175, 1, 0], [S, 15, 36, 15, 43, 15, 45, 15057, 15065, 15069, 15076, 15079, 15094, 15128, 1], [S, 15, 151, 15, 180, 15, 72, 15173, 1, 0, 0, 0, 0, 0, 0], [S, 15, 15, 15, 19, 25, 37, 23533, 475100015070, 15078, 15093, 15095, 15129, 15144, 1], [S, 15, 165, 15, 170, 15, 171, 15016, 25089, 25136, 15011, 15046, 15096, 15154, 1], [S, 15, 162, 15, 163, 15, 164, 15192, 15175, 1, 0, 0, 0, 0, 0], [S, 15, 83, 15, 133, 15, 155, 13584, 475100015166, 15167, 15049, 15139, 15002, 15027, 1], [S, 15, 38, 15, 140, 15, 174, 15184, 1, 0, 0, 0, 0, 0, 0], [S, 15, 36, 15, 43, 15, 45, 13533, 475100015069, 15076, 15094, 15128, 15151, 15180, 1], [S, 15, 72, 15, 173, 1, , 0, 0, 0, 0, 0, 0, 0, 0], [S, 15, 36, 15, 43, 15, 45, 15057, 15065, 15069, 15076, 15094, 15128, 15151, 1], [S, 15, 180, 1, , 0, , 0, 0, 0, 0, 0, 0, 0, 0], [S, 15, 36, 15, 43, 15, 45, 15057, 15065, 15069, 15076, 15094, 15128, 15151, 1], [S, 15, 180, 1, , 0, , 0, 0, 0, 0, 0, 0, 0, 0], [S, 15, 15, 15, 19, 15, 33, 15037, 15060, 15074, 15078, 15085, 15091, 15093, 1], [S, 15, 95, 15, 129, 15, 144, 15169, 15170, 15171, 15177, 15016, 15089, 15136, 1], [S, 15, 46, 15, 145, 15, 96, 15154, 15162, 15164, 15192, 15175, 1, 0, 0], [S, 15, 15, 15, 19, 15, 33, 15037, 15060, 15074, 15078, 15085, 15091, 15093, 1], [S, 15, 95, 15, 129, 15, 144, 15169, 15170, 15171, 15177, 15016, 15089, 15136, 1], [S, 15, 46, 15, 145, 15, 96, 15154, 15162, 15164, 15192, 15175, 1, 0, 0], [S, 15, 40, 15, 20, 15, 83, 15133, 15135, 15155, 15166, 15139, 15002, 15027, 1], [S, 15, 38, 15, 126, 15, 140, 15174, 15184, 1, 0, 0, 0, 0, 0], [S, 15, 40, 15, 20, 15, 83, 15133, 15135, 15155, 15166, 15139, 15002, 15027, 1], [S, 15, 38, 15, 126, 15, 140, 15174, 15184, 1, 0, 0, 0, 0, 0], [S, 15, 15, 25, 19, 65, 33, 25035, 25037, 65052, 25055, 25060, 25070, 15074, 6], [S, 15, 78, 65, 81, 15, 85, 45090, 25091, 55093, 35095, 35129, 65144, 35165, 1], [S, 15, 303, 15, 169, 45, 170, 25171, 25177, 55178, 35016, 25089, 35136, 15011, 1], [S, 15, 46, 35, 145, 45, 96, 65154, 55162, 55163, 35164, 25192, 25150, 25175, 2], [S, 15, 15, 25, 19, 75, 33, 25035, 25037, 65052, 25055, 25060, 25070, 25074, 6], [S, 15, 78, 75, 81, 25, 85, 45090, 25091, 65093, 35095, 35129, 65144, 35165, 2], [S, 15, 303, 25, 169, 45, 170, 25171, 25177, 65178, 35016, 25089, 35136, 25011, 2], [S, 15, 46, 35, 145, 45, 96, 65154, 55162, 55163, 35164, 25192, 25150, 25175, 2], [S, 15, 19, 55, 37, 55, 74, 55078, 55085, 45091, 55093, 35095, 35129, 55144, 3], [S, 15, 169, 35, 177, 65, 178, 35089, 35046, 35145, 45096, 55154, 45162, 45163, 3], [S, 15, 40, 25, 20, 25, 59, 15068, 15083, 15084, 25133, 25135, 25155, 25156, 2], [S, 15, 166, 35, 167, 25, 48, 25049, 25139, 25143, 25003, 25002, 25027, 25038, 2], [S, 15, 73, 25, 126, 25, 140, 25174, 35184, 2, 0, 0, 0, 0, 0], [S, 15, 40, 25, 20, 25, 59, 15068, 15083, 15084, 25133, 25135, 25155, 25156, 2], [S, 15, 166, 25, 167, 25, 48, 15049, 15139, 25143, 25003, 25010, 15062, 15138, 1], [S, 15, 141, 15, 2, 25, 27, 25038, 25073, 25126, 25140, 25174, 25184, 2, 0], [S, 15, 40, 15, 20, 15, 68, 15083, 15084, 15133, 15135, 15155, 15156, 15166, 2], [S, 15, 167, 15, 48, 15, 49, 15139, 15143, 15002, 15027, 25038, 25073, 15126, 1], [S, 15, 140, 15, 174, 25, 184, 1, 0, 0, 0, 0, 0, 0, 0], [S, 15, 36, 25, 43, 35, 45, 25057, 15065, 25069, 25076, 25079, 15094, 25128, 2], [S, 15, 151, 25, 180, 15, 72, 15173, 1, 0, 0, 0, 0, 0, 0], [S, 15, 36, 15, 43, 25, 45, 25057, 15065, 25069, 25076, 25079, 15094, 25128, 2], [S, 15, 151, 25, 180, 25, 72, 15173, 2, 0, 0, 0, 0, 0, 0], [S, 15, 43, 25, 45, 25, 65, 15076, 25128, 25151, 25180, 15072, 15173, 1, 0], [S, 15, 15, 25, 19, 45, 33, 25035, 25037, 45052, 25055, 25060, 25070, 25074, 3], [S, 15, 78, 45, 81, 25, 85, 35090, 25091, 45093, 35095, 45129, 45144, 45165, 2], [S, 15, 303, 25, 169, 25, 170, 25171, 25177, 45016, 45089, 35136, 25011, 35046, 2], [S, 15, 145, 35, 96, 45, 154, 45162, 45163, 35164, 25192, 25150, 25175, 2, 0], [S, 15, 15, 25, 19, 55, 33, 25037, 55060, 25070, 15074, 35078, 55085, 25090, 2], [S, 15, 91, 55, 93, 25, 95, 35129, 65144, 55165, 25169, 25170, 25171, 25177, 5], [S, 15, 178, 25, 16, 45, 89, 25136, 25011, 25046, 25145, 25096, 55154, 35162, 3], [S, 15, 163, 25, 164, 25, 192, 25175, 1, 0, 0, 0, 0, 0, 0]]'
)
assert_p(
'Table1', 'Content',
'[[S, 15, 15, 15, 19, 35, 33, 13337, 207800015037, 15052, 15055, 15060, 25070, 15074, 1], [S, 15, 78, 15, 81, 15, 85, 15090, 15091, 15093, 15095, 15129, 15144, 15165, 1], [S, 15, 303, 15, 169, 15, 170, 15171, 15177, 15016, 15089, 25136, 15011, 15046, 1], [S, 15, 145, 15, 96, 25, 154, 15162, 15163, 15164, 15192, 15150, 15175, 1, 0], [S, 15, 36, 15, 43, 15, 45, 15057, 15065, 15069, 15076, 15079, 15094, 15128, 1], [S, 15, 151, 15, 180, 15, 72, 15173, 1, 0, 0, 0, 0, 0, 0], [S, 15, 15, 15, 19, 25, 37, 23533, 475100015070, 15078, 15093, 15095, 15129, 15144, 1], [S, 15, 165, 15, 170, 15, 171, 15016, 25089, 25136, 15011, 15046, 15096, 15154, 1], [S, 15, 162, 15, 163, 15, 164, 15192, 15175, 1, 0, 0, 0, 0, 0], [S, 15, 83, 15, 133, 15, 155, 13584, 475100015166, 15167, 15049, 15139, 15002, 15027, 1], [S, 15, 38, 15, 140, 15, 174, 15184, 1, 0, 0, 0, 0, 0, 0], [S, 15, 36, 15, 43, 15, 45, 13533, 475100015069, 15076, 15094, 15128, 15151, 15180, 1], [S, 15, 72, 15, 173, 1, , 0, 0, 0, 0, 0, 0, 0, 0], [S, 15, 36, 15, 43, 15, 45, 15057, 15065, 15069, 15076, 15094, 15128, 15151, 1], [S, 15, 180, 1, , 0, , 0, 0, 0, 0, 0, 0, 0, 0], [S, 15, 36, 15, 43, 15, 45, 15057, 15065, 15069, 15076, 15094, 15128, 15151, 1], [S, 15, 180, 1, , 0, , 0, 0, 0, 0, 0, 0, 0, 0], [S, 15, 15, 15, 19, 15, 33, 15037, 15060, 15074, 15078, 15085, 15091, 15093, 1], [S, 15, 95, 15, 129, 15, 144, 15169, 15170, 15171, 15177, 15016, 15089, 15136, 1], [S, 15, 46, 15, 145, 15, 96, 15154, 15162, 15164, 15192, 15175, 1, 0, 0], [S, 15, 15, 15, 19, 15, 33, 15037, 15060, 15074, 15078, 15085, 15091, 15093, 1], [S, 15, 95, 15, 129, 15, 144, 15169, 15170, 15171, 15177, 15016, 15089, 15136, 1], [S, 15, 46, 15, 145, 15, 96, 15154, 15162, 15164, 15192, 15175, 1, 0, 0], [S, 15, 40, 15, 20, 15, 83, 15133, 15135, 15155, 15166, 15139, 15002, 15027, 1], [S, 15, 38, 15, 126, 15, 140, 15174, 15184, 1, 0, 0, 0, 0, 0], [S, 15, 40, 15, 20, 15, 83, 15133, 15135, 15155, 15166, 15139, 15002, 15027, 1], [S, 15, 38, 15, 126, 15, 140, 15174, 15184, 1, 0, 0, 0, 0, 0], [S, 15, 15, 25, 19, 65, 33, 25035, 25037, 65052, 25055, 25060, 25070, 15074, 6], [S, 15, 78, 65, 81, 15, 85, 45090, 25091, 55093, 35095, 35129, 65144, 35165, 1], [S, 15, 303, 15, 169, 45, 170, 25171, 25177, 55178, 35016, 25089, 35136, 15011, 1], [S, 15, 46, 35, 145, 45, 96, 65154, 55162, 55163, 35164, 25192, 25150, 25175, 2], [S, 15, 15, 25, 19, 75, 33, 25035, 25037, 65052, 25055, 25060, 25070, 25074, 6], [S, 15, 78, 75, 81, 25, 85, 45090, 25091, 65093, 35095, 35129, 65144, 35165, 2], [S, 15, 303, 25, 169, 45, 170, 25171, 25177, 65178, 35016, 25089, 35136, 25011, 2], [S, 15, 46, 35, 145, 45, 96, 65154, 55162, 55163, 35164, 25192, 25150, 25175, 2], [S, 15, 19, 55, 37, 55, 74, 55078, 55085, 45091, 55093, 35095, 35129, 55144, 3], [S, 15, 169, 35, 177, 65, 178, 35089, 35046, 35145, 45096, 55154, 45162, 45163, 3], [S, 15, 40, 25, 20, 25, 59, 15068, 15083, 15084, 25133, 25135, 25155, 25156, 2], [S, 15, 166, 35, 167, 25, 48, 25049, 25139, 25143, 25003, 25002, 25027, 25038, 2], [S, 15, 73, 25, 126, 25, 140, 25174, 35184, 2, 0, 0, 0, 0, 0], [S, 15, 40, 25, 20, 25, 59, 15068, 15083, 15084, 25133, 25135, 25155, 25156, 2], [S, 15, 166, 25, 167, 25, 48, 15049, 15139, 25143, 25003, 25010, 15062, 15138, 1], [S, 15, 141, 15, 2, 25, 27, 25038, 25073, 25126, 25140, 25174, 25184, 2, 0], [S, 15, 40, 15, 20, 15, 68, 15083, 15084, 15133, 15135, 15155, 15156, 15166, 2], [S, 15, 167, 15, 48, 15, 49, 15139, 15143, 15002, 15027, 25038, 25073, 15126, 1], [S, 15, 140, 15, 174, 25, 184, 1, 0, 0, 0, 0, 0, 0, 0], [S, 15, 36, 25, 43, 35, 45, 25057, 15065, 25069, 25076, 25079, 15094, 25128, 2], [S, 15, 151, 25, 180, 15, 72, 15173, 1, 0, 0, 0, 0, 0, 0], [S, 15, 36, 15, 43, 25, 45, 25057, 15065, 25069, 25076, 25079, 15094, 25128, 2], [S, 15, 151, 25, 180, 25, 72, 15173, 2, 0, 0, 0, 0, 0, 0], [S, 15, 43, 25, 45, 25, 65, 15076, 25128, 25151, 25180, 15072, 15173, 1, 0], [S, 15, 15, 25, 19, 45, 33, 25035, 25037, 45052, 25055, 25060, 25070, 25074, 3], [S, 15, 78, 45, 81, 25, 85, 35090, 25091, 45093, 35095, 45129, 45144, 45165, 2], [S, 15, 303, 25, 169, 25, 170, 25171, 25177, 45016, 45089, 35136, 25011, 35046, 2], [S, 15, 145, 35, 96, 45, 154, 45162, 45163, 35164, 25192, 25150, 25175, 2, 0], [S, 15, 15, 25, 19, 55, 33, 25037, 55060, 25070, 15074, 35078, 55085, 25090, 2], [S, 15, 91, 55, 93, 25, 95, 35129, 65144, 55165, 25169, 25170, 25171, 25177, 5], [S, 15, 178, 25, 16, 45, 89, 25136, 25011, 25046, 25145, 25096, 55154, 35162, 3], [S, 15, 163, 25, 164, 25, 192, 25175, 1, 0, 0, 0, 0, 0, 0]]'
)
select('Table1', 'cell:B,2(15)')
click('Right')
select('TabbedPane', '')
select('TextField', 'Wizard_AmsPo')
click('Right')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
# click('MetalInternalFrameTitlePane', 674, 1)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_03'
if window('Record Editor'):
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare Menu')
click('*2')
select('FileChooser',
commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
commonBits.setRecordLayout(select, 'ams PO Download')
click('Right')
select('TabbedPane', '')
select('FileChooser',
commonBits.sampleDir() + 'xmlAms_PODownload_20041231.txt.xml')
click('Right')
select('TabbedPane', '')
select('Table', 'cell:Equivalent Record,0(-1)')
select('Table', 'ams_PO_Download__Detail', 'Equivalent Record,0')
select('Table', 'ams_PO_Download__Header', 'Equivalent Record,1')
select('Table', 'ams_PO_Download__Allocation', 'Equivalent Record,2')
select('Table', 'cell:Equivalent Record,0(3)')
select('Table1', 'cell:Equivalent Field,0()')
select('Table', 'cell:Equivalent Record,0(3)')
select('Table1', 'Record_Type', 'Equivalent Field,0')
select('Table1', 'Pack_Qty', 'Equivalent Field,1')
select('Table1', 'Pack_Cost', 'Equivalent Field,2')
select('Table1', 'APN', 'Equivalent Field,3')
select('Table1', 'cell:Equivalent Field,5()')
# click('ScrollPane$ScrollBar', 6, 40)
if commonBits.isNimbusLook():
select('Table1', ' ', 'Equivalent Field,5')
else:
select('Table1', '', 'Equivalent Field,5')
# select('Table1', '')
select('Table', 'cell:Record,1(ams PO Download: Header)')
select('Table1', 'cell:Equivalent Field,0()')
select('Table', 'cell:Record,1(ams PO Download: Header)')
select('Table1', 'Record_Type', 'Equivalent Field,0')
select('Table1', 'Sequence_Number', 'Equivalent Field,1')
select('Table1', 'Vendor', 'Equivalent Field,2')
select('Table1', 'PO', 'Equivalent Field,3')
select('Table1', 'cell:Field,2(Vendor)')
select('Table1', 'cell:Equivalent Field,1(Pack Qty)')
select('Table1', 'cell:Field,2(Vendor)')
select('Table1', 'cell:Equivalent Field,2(Pack Qty)')
## assert_p('Table1', 'Content', '[[Record Type, Record_Type], [Sequence Number, Sequence_Number], [Vendor, Vendor], [PO, PO], [Entry Date, ], [Filler, ], [beg01 code, ], [beg02 code, ], [Department, ], [Expected Reciept Date, ], [Cancel by date, ], [EDI Type, ], [Add Date, ], [Filler, ], [Department Name, ], [Prcoess Type, ], [Order Type, ]]')
## assert_p('Table1', 'Content', '[[Record Type, Record_Type], [Sequence Number, Sequence_Number], [Vendor, Vendor], [PO, PO], [Entry Date, Entry_Date], [Filler, ], [beg01 code, beg01_code], [beg02 code, ], [Department, Department], [Expected Reciept Date, Expected_Reciept_Date], [Cancel by date, Cancel_by_date], [EDI Type, EDI_Type], [Add Date, ], [Filler, ], [Department Name, Department_Name], [Prcoess Type, Prcoess_Type], [Order Type, Order_Type]]')
## assert_p('Table1', 'Content', '[[Record Type, Record_Type], [Sequence Number, Sequence_Number], [Vendor, Vendor], [PO, PO], [Entry Date, ], [Filler, ], [beg01 code, ], [beg02 code, ], [Department, ], [Expected Reciept Date, ], [Cancel by date, ], [EDI Type, ], [Add Date, ], [Filler, ], [Department Name, ], [Prcoess Type, ], [Order Type, ]]')
assert_p(
'Table1', 'Content',
'[[Record Type, Record_Type], [Sequence Number, ], [Vendor, ], [PO, PO], [Entry Date, Entry_Date], [Filler, ], [beg01 code, beg01_code], [beg02 code, ], [Department, Department], [Expected Reciept Date, Expected_Reciept_Date], [Cancel by date, Cancel_by_date], [EDI Type, EDI_Type], [Add Date, ], [Filler, ], [Department Name, Department_Name], [Prcoess Type, Prcoess_Type], [Order Type, Order_Type]]'
)
# select('Table1', '')
select('Table', 'cell:Record,2(ams PO Download: Allocation)')
## assert_p('Table', 'Content', '[[ams PO Download: Detail, 3], [ams PO Download: Header, 2], [ams PO Download: Allocation, 4]]')
assert_p(
'Table', 'Content',
'[[ams PO Download: Detail, ams_PO_Download__Detail], [ams PO Download: Header, ams_PO_Download__Header], [ams PO Download: Allocation, ams_PO_Download__Allocation]]'
)
select('Table', 'cell:Record,2(ams PO Download: Allocation)')
select('Table1', 'cell:Equivalent Field,0()')
select('Table', 'cell:Record,2(ams PO Download: Allocation)')
select('Table1', 'Record_Type', 'Equivalent Field,0')
select('Table1', 'DC_Number_1', 'Equivalent Field,1')
select('Table1', 'Pack_Quantity_1', 'Equivalent Field,2')
select('Table1', 'DC_Number_2', 'Equivalent Field,3')
select('Table1', 'Pack_Quantity_2', 'Equivalent Field,4')
select('Table1', 'cell:Field,3(DC Number 2)')
## assert_p('Table1', 'Content', '[[Record Type, Record_Type], [DC Number 1, DC_Number_1], [Pack Quantity 1, Pack_Quantity_1], [DC Number 2, DC_Number_2], [Pack Quantity 2, Pack_Quantity_2], [DC Number 4, ], [Pack Quantity 4, ], [DC Number 5, ], [Pack Quantity 5, ], [DC Number 6, ], [Pack Quantity 6, ], [DC Number 7, ], [Pack Quantity 7, ], [DC Number 8, ], [Pack Quantity 8, ], [DC Number 9, ], [Pack Quantity 9, ], [DC Number 10, ], [Pack Quantity 10, ]]')
assert_p(
'Table1', 'Content',
'[[Record Type, Record_Type], [DC Number 1, DC_Number_1], [Pack Quantity 1, Pack_Quantity_1], [DC Number 2, DC_Number_2], [Pack Quantity 2, Pack_Quantity_2], [DC Number 4, DC_Number_4], [Pack Quantity 4, Pack_Quantity_4], [DC Number 5, DC_Number_5], [Pack Quantity 5, Pack_Quantity_5], [DC Number 6, DC_Number_6], [Pack Quantity 6, Pack_Quantity_6], [DC Number 7, DC_Number_7], [Pack Quantity 7, Pack_Quantity_7], [DC Number 8, DC_Number_8], [Pack Quantity 8, Pack_Quantity_8], [DC Number 9, DC_Number_9], [Pack Quantity 9, Pack_Quantity_9], [DC Number 10, DC_Number_10], [Pack Quantity 10, Pack_Quantity_10]]'
)
select('Table1', 'cell:Field,3(DC Number 2)')
click('Right')
select('TabbedPane', '')
click('Compare')
select('Table', 'cell:Pack Qty,0(5043)')
assert_p('Table', 'Text', '5043', 'Pack Qty,0')
select('Table', 'cell:Pack Qty,2(4.0000)')
## assert_p('Table', 'Content', '[[, Old, 3, S1, 5043, 1, 5045, 1], [, New, 3, , , , , 11], [, Old, 4, D1, 4.0000, 148.3200, 0, 5614944], [, New, 4, , , , 111, ]]')
## assert_p('Table', 'Content', '[[, Old, 3, S1, 5043, 1, 5045, 1], [, New, 3, , , , , 11], [, Old, 4, D1, 4.0000, 148.3200, 0, ], [, New, 4, , , , 111, ]]')
## assert_p('Table', 'Content', '[[, Old, 3, S1, 5043, 1, 5045, 1], [, New, 3, , , , , 11], [, Old, 4, D1, 4.0000, 148.3200, 0, ], [, New, 4, , , , 111, ], [, Old, 12, D1, 16.0000, 6228148.3200, 2222, ], [, New, 12, , , 62281483200, , ]]')
assert_p(
'Table', 'Content',
'[[, Old, 3, S1, 5043, 1, 5045, 1, 5076, 1, 5079, 1, 5151, 1, 5072, 1, , 0, , 0, , 0], [, New, 3, , , , , 11, , 12, , , , , , , , , , , , ], [, Old, 4, D1, 4.0000, 148.3200, 0, 2075360, 5614944, MILK 24-006607 SHWL WRAP CARD, , , , , , , , , , , , ], [, New, 4, , , , 111, , , , , , , , , , , , , , , ], [, Old, 5, S1, 5045, 1, 5076, 1, 3331, 49440001, , 0, , 0, , 0, , 0, , 0, , 0], [, New, 5, , , , , , , , , 22, , 33, , , , , , , , ], [, Old, 12, D1, 16.0000, 6228148.3200, 2222, 2075348, 5614531, DONKEY 24-006607 SHWL WRAP CARD, , , , , , , , , , , , ], [, New, 12, , , 62281483200, , , , , , , , , , , , , , , , ]]'
)
select('Table', 'cell:Pack Qty,2(4.0000)')
click('All Included Lines')
select('Table', 'cell:Pack Qty,2(7.0000)')
assert_p('Table', 'Text', '7.0000', 'Pack Qty,2')
select('Table', 'cell:Pack Qty,2(7.0000)')
assert_p('Table', 'RowCount', '140')
select('Table', 'cell:Pack Qty,10(48.0000)')
assert_p('Table', 'Text', 'cell:Pack Qty,10(48.0000)')
select('Table', 'cell:Pack Qty,10(48.0000)')
click('ScrollPane$ScrollBar', 3, 124)
## select('Table', 'cell:Product,6(5614944)')
## assert_p('Table', 'Text', '1', 'Product,8')
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
if window('Record Editor'):
commonBits.selectOldFilemenu(select_menu, 'Utilities', 'Compare Menu')
click('*2')
select('FileChooser',
commonBits.sampleDir() + 'Ams_PODownload_20041231.txt')
click('Right')
select('TabbedPane', '')
select('FileChooser',
commonBits.sampleDir() + 'Ams_PODownload_20041231_Compare.txt')
click('Right')
select('TabbedPane', '')
click('Right')
select('TabbedPane', '')
click('Compare')
assert_p(
'Table', 'Content',
'[[, Old, 2, D1, 7.0000, 0.0002, 2222500000000, , 43314531, 2075359, 45614531, DONKEY 24-006607 SHWL WRAP CARD, , , , , , , , , , ], [, New, 2, , 17.0000, 0.0102, , , , , , , , , , , , , , , , ], [, Old, 3, S1, 5043, 1, 5045, 1, 5076, 1, 5079, 1, 5151, 1, 5072, 1, , 0, , 0, , 0], [, New, 3, , , 10, 9045, 2, , , , , , , , , , , , , , ], [, Old, 4, D1, 4.0000, 148.3200, 0, , 5614944, 2075360, 5614944, MILK 24-006607 SHWL WRAP CARD, , , , , , , , , , ], [, New, 4, , 14.0000, , , , , , , , , , , , , , , , , ], [, Old, 5, S1, 5045, 1, 5076, 1, 3331, 49440001, , 0, , 0, , 0, , 0, , 0, , 0], [, New, 5, , , 11, , , , , , , , , , , , , , , , ], [, Old, 6, D1, 48.0000, 148.3200, 0, , 55615071, 2075361, 55615071, M.ROSE 24-006607 SHWL WRAP CARD, , , , , , , , , , ], [, New, 6, , 8.0000, 48.3200, , , , , , , , , , , , , , , , ], [, Old, 7, S1, 5036, 3, 5043, 5, 3331, 50710003, 5065, 4, 5069, 4, 5076, 4, 5079, 2, 5094, 4, 5128, 3], [, New, 7, , , 6, , 51, , , , , , , , , , , , , , ]]'
)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Left')
select('TabbedPane', '')
select('Table', 'cell:Equivalent Record,0(ams PO Download: Detail)')
select('Table', ' ', 'Equivalent Record,0')
select('Table', 'cell:Equivalent Record,0( )')
select('Table1', 'cell:Field,1(Pack Qty)')
assert_p(
'Table', 'Content',
'[[ams PO Download: Detail, ], [ams PO Download: Header, ams PO Download: Header], [ams PO Download: Allocation, ams PO Download: Allocation]]'
)
select('Table1', 'cell:Field,1(Pack Qty)')
click('Right')
select('TabbedPane', '')
click('Compare')
assert_p(
'Table', 'Content',
'[[, Old, 2, S1, 5043, 1, 5045, 1, 5076, 1, 5079, 1, 5151, 1, 5072, 1, , 0, , 0, , 0], [, New, 2, , , 10, 9045, 2, , , , , , , , , , , , , , ], [, Old, 3, S1, 5045, 1, 5076, 1, 3331, 49440001, , 0, , 0, , 0, , 0, , 0, , 0], [, New, 3, , , 11, , , , , , , , , , , , , , , , ], [, Old, 4, S1, 5036, 3, 5043, 5, 3331, 50710003, 5065, 4, 5069, 4, 5076, 4, 5079, 2, 5094, 4, 5128, 3], [, New, 4, , , 6, , 51, , , , , , , , , , , , , , ]]'
)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Left')
select('TabbedPane', '')
assert_p(
'Table1', 'Content',
'[[Record Type, ], [Pack Qty, ], [Pack Cost, ], [APN, ], [Filler, ], [Product, ], [pmg dtl tech key, ], [Case Pack id, ], [Product Name, ]]'
)
select('Table', 'cell:Equivalent Record,0( )')
select('Table', 'ams PO Download: Detail', 'Equivalent Record,0')
select('Table', 'cell:Equivalent Record,0(ams PO Download: Detail)')
assert_p(
'Table1', 'Content',
'[[Record Type, Record Type], [Pack Qty, Pack Qty], [Pack Cost, Pack Cost], [APN, APN], [Filler, Filler], [Product, Product], [pmg dtl tech key, pmg dtl tech key], [Case Pack id, Case Pack id], [Product Name, Product Name]]'
)
select('Table', 'cell:Equivalent Record,0(ams PO Download: Detail)')
select('Table1', 'cell:Equivalent Field,1(Pack Qty)')
select('Table', 'cell:Equivalent Record,0(ams PO Download: Detail)')
select('Table1', 'cell:Equivalent Field,1(Pack Qty)')
## click('ScrollPane$ScrollBar', 8, 51)
if commonBits.isNimbusLook():
select('Table1', ' ', 'Equivalent Field,2')
select('Table1', ' ', 'Equivalent Field,3')
else:
select('Table1', 'cell:Equivalent Field,2(Pack Qty)')
select('Table1', '', 'Equivalent Field,2')
select('Table1', 'cell:Field,4(Filler)')
## select('Table1', '', 'Equivalent Field,2')
## select('Table1', 'cell:Field,4(Filler)')
## select('Table1', '', 'Equivalent Field,2')
## select('Table1', '', 'Equivalent Field,2')
select('Table1', 'cell:Field,0(Record Type)')
assert_p(
'Table1', 'Content',
'[[Record Type, Record Type], [Pack Qty, ], [Pack Cost, ], [APN, APN], [Filler, Filler], [Product, Product], [pmg dtl tech key, pmg dtl tech key], [Case Pack id, Case Pack id], [Product Name, Product Name]]'
)
select('Table1', 'cell:Field,0(Record Type)')
click('Right')
select('TabbedPane', '')
click('Compare')
assert_p(
'Table', 'Content',
'[[, Old, 3, S1, 5043, 1, 5045, 1, 5076, 1, 5079, 1, 5151, 1, 5072, 1, , 0, , 0, , 0], [, New, 3, , , 10, 9045, 2, , , , , , , , , , , , , , ], [, Old, 5, S1, 5045, 1, 5076, 1, 3331, 49440001, , 0, , 0, , 0, , 0, , 0, , 0], [, New, 5, , , 11, , , , , , , , , , , , , , , , ], [, Old, 7, S1, 5036, 3, 5043, 5, 3331, 50710003, 5065, 4, 5069, 4, 5076, 4, 5079, 2, 5094, 4, 5128, 3], [, New, 7, , , 6, , 51, , , , , , , , , , , , , , ]]'
)
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Left')
select('TabbedPane', '')
select('Table', 'cell:Record,2(ams PO Download: Allocation)')
select('Table1', 'cell:Equivalent Field,2()')
select('Table1', 'Pack Quantity 1', 'Equivalent Field,2')
## select('Table1', '')
select('Table', 'cell:Record,2(ams PO Download: Allocation)')
select('Table1', 'cell:Equivalent Field,1(DC Number 1)')
select('Table', 'cell:Record,2(ams PO Download: Allocation)')
if commonBits.isNimbusLook():
select('Table1', ' ', 'Equivalent Field,1')
select('Table1', ' ', 'Equivalent Field,2')
else:
select('Table1', '', 'Equivalent Field,1')
select('Table1', '', 'Equivalent Field,2')
select('Table1', 'cell:Field,3(DC Number 2)')
assert_p(
'Table1', 'Content',
'[[Record Type, Record Type], [DC Number 1, ], [Pack Quantity 1, ], [DC Number 2, DC Number 2], [Pack Quantity 2, Pack Quantity 2], [DC Number 4, DC Number 4], [Pack Quantity 4, Pack Quantity 4], [DC Number 5, DC Number 5], [Pack Quantity 5, Pack Quantity 5], [DC Number 6, DC Number 6], [Pack Quantity 6, Pack Quantity 6], [DC Number 7, DC Number 7], [Pack Quantity 7, Pack Quantity 7], [DC Number 8, DC Number 8], [Pack Quantity 8, Pack Quantity 8], [DC Number 9, DC Number 9], [Pack Quantity 9, Pack Quantity 9], [DC Number 10, DC Number 10], [Pack Quantity 10, Pack Quantity 10]]'
)
select('Table1', 'cell:Field,3(DC Number 2)')
assert_p(
'Table', 'Content',
'[[ams PO Download: Detail, ams PO Download: Detail], [ams PO Download: Header, ams PO Download: Header], [ams PO Download: Allocation, ams PO Download: Allocation]]'
)
select('Table1', 'cell:Field,3(DC Number 2)')
select('Table', 'cell:Equivalent Record,0(ams PO Download: Detail)')
# select('Table1', 'Pack Qty', 'Equivalent Field,1')
select('Table1', 'Pack Cost', 'Equivalent Field,2')
click('Right')
select('TabbedPane', '')
click('Compare')
## assert_p('Table', 'Content', '[[, Old, 2, D1, 0.0002, 2222500000000, , 43314531, 2075359, 45614531, DONKEY 24-006607 SHWL WRAP CARD, , , , , , , , , ], [, New, 2, , 0.0102, , , , , , , , , , , , , , , ], [, Old, 3, S1, 5045, 1, 5076, 1, 5079, 1, 5151, 1, 5072, 1, , 0, , 0, , 0], [, New, 3, , 9045, 2, , , , , , , , , , , , , , ], [, Old, 6, D1, 148.3200, 0, , 55615071, 2075361, 55615071, M.ROSE 24-006607 SHWL WRAP CARD, , , , , , , , , ], [, New, 6, , 48.3200, , , , , , , , , , , , , , , ], [, Old, 7, S1, 5043, 5, 3331, 50710003, 5065, 4, 5069, 4, 5076, 4, 5079, 2, 5094, 4, 5128, 3], [, New, 7, , , 51, , , , , , , , , , , , , , ]]')
assert_p(
'Table', 'Content',
'[[, Old, 2, D1, 0.0002, 2222500000000, , 43314531, 2075359, 45614531, DONKEY 24-006607 SHWL WRAP CARD, , , , , , , , , ], [, New, 2, , 0.0102, , , , , , , , , , , , , , , ], [, Old, 3, S1, 5045, 1, 5076, 1, 5079, 1, 5151, 1, 5072, 1, , 0, , 0, , 0], [, New, 3, , 9045, 2, , , , , , , , , , , , , , ], [, Old, 6, D1, 148.3200, 0, , 55615071, 2075361, 55615071, M.ROSE 24-006607 SHWL WRAP CARD, , , , , , , , , ], [, New, 6, , 48.3200, , , , , , , , , , , , , , , ], [, Old, 7, S1, 5043, 5, 3331, 50710003, 5065, 4, 5069, 4, 5076, 4, 5079, 2, 5094, 4, 5128, 3], [, New, 7, , , 51, , , , , , , , , , , , , , ]]'
)
close()
def test():
from Modules import commonBits
java_recorded_version = '1.6.0_17'
#
# Sript does not work yet !!!
#
if window('Record Editor'):
select('FileChooser', commonBits.sampleDir() + 'Ams_PODownload_20050101.txt')
click(commonBits.fl('Layout Wizard'))
select('Multiple Records #{fixed length#}', 'true')
click('Right')
select('TabbedPane', '')
# select('Table', '')
select('TextField1', '01')
select('TextField2', '1')
click('Right')
select('TabbedPane', '')
select('Table', 'header', commonBits.fl('Record Name') + ',0')
select('Table', 'detail', commonBits.fl('Record Name') + ',1')
select('Table', 'store', commonBits.fl('Record Name') + ',2')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',0(header)')
if commonBits.isVersion80():
assert_p('Table', 'Content', '[[H, header, false, true], [D, detail, false, true], [S, store, false, true]]')
else:
assert_p('Table', 'Content', '[[H, header], [D, detail], [S, store]]')
select('Table', 'cell:' + commonBits.fl('Record Name') + ',0(header)')
click('Right')
select('TabbedPane', '')
if commonBits.isNimbusLook():
assert_p('Table', 'Background', 'DerivedColor(color=255,255,255 parent=nimbusLightBackground offsets=0.0,0.0,0.0,0 pColor=255,255,255')
else:
assert_p('Table', 'Background', '[r=255,g=255,b=255]')
click('Right')
assert_p('TextArea', 'Text', commonBits.fl('You must define the Fields for all Records. Please update - detail')
)
select('ComboBox', 'store')
rightclick('Table', 'D,0')
rightclick('Table', 'P,0')
rightclick('Table', 'AB,0')
# select('Table', 'cell:' + commonBits.fl('Start') + ',0(1)')
# rightclick('Table', commonBits.fl('Field Name') + ',1')
# select_menu(commonBits.fl('Generate Field Names'))
click('Right')
select('TabbedPane', '')
select('Table', 'cell:' + commonBits.fl('Start') + ',0(1)')
rightclick('Table', commonBits.fl('Field Name') + ',1')
select_menu(commonBits.fl('Generate Field Names'))
select('ComboBox', 'detail')
if commonBits.isVersion80():
assert_p('Table1', 'Content', '[[D, 1, 44, 11840, 0, , 45872078, 4544, 44, , 2117093, , 45872078, , MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGAN], [D, 1, 14, 11984, 0, , 43372078, 4544, 14, , 2117152, , 45872078, , MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGAN], [D, 1, 29, 10120, 0, , 45874751, 4090, 29, , 2117337, , 45872078, , MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 14, 0, 29440800000000, , 45874751, 4090, 14, , 2117347, , 35874751, , MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 12, 10256, 0, , 35874751, 4090, 12, , 2117354, , 35874751, , MTH5030H BLK L/S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 11, 5848, 0, , 31191697, 2726, 11, , 2327928, , 35891697, , SKY BLUE SKP02 L/WEIGHT PONCHO ], [D, 1, 11, 5848, 0, , 33391826, 2726, 11, , 2327931, , 35891826, , DUSTY PINK SKP02 L/WEIGHT PONCHO ], [D, 1, 28, 3356, 0, , 31191697, 2726, 28, , 2327933, , 35891697, , SKY BLUE SKP02 L/WEIGHT PONCHO ], [D, 1, 28, 3356, 0, , 31191826, 2726, 28, , 2327936, , 35891826, , DUSTY PINK SKP02 L/WEIGHT PONCHO ], [D, 1, 15, 3356, 0, , 31191697, 2726, 15, , 2327982, , 35891697, , SKY BLUE SKP02 L/WEIGHT PONCHO ], [D, 1, 15, 3356, 0, , 35221826, 2726, 15, , 2327985, , 35891826, , DUSTY PINK SKP02 L/WEIGHT PONCHO ], [D, 1, 123, 6723, 0, , 35116979, 2272, 123, , 2098136, , 35926979, , SA13 CHOC MUSTANG PRT RAGLAN SWEAT ], [D, 1, 133, 6723, 0, , 35117204, 2272, 133, , 2098137, , 35927204, , SA13 PALE BLUE MP RAGLEN SWEAT ], [D, 1, 81, 6723, 0, , 31127419, 2272, 81, , 2098139, , 35927419, , SA13 PALE PINK MP PRT RAGLAN SWEAT ], [D, 1, 49, 6723, 0, , 35333979, 2272, 49, , 2098158, , 35926979, , SA13 CHOC MUSTANG PRT RAGLAN SWEAT ], [D, 1, 49, 6723, 0, , 32227204, 2272, 49, , 2098159, , 35927204, , SA13 PALE BLUE MP RAGLEN SWEAT ], [D, 1, 27, 6723, 0, , 32227419, 2272, 27, , 2098160, , 35927419, , SA13 PALE PINK MP PRT RAGLAN SWEAT ], [D, 1, 24, 6183, 0, , 33336979, 2272, 24, , 2098161, , 35926979, , SA13 CHOC MUSTANG PRT RAGLAN SWEAT ], [D, 1, 24, 6183, 0, , 30027204, 2272, 24, , 2098165, , 35927204, , SA13 PALE BLUE MP RAGLEN SWEAT ], [D, 1, 14, 6183, 0, , 35007419, 2272, 14, , 2098167, , 35927419, , SA13 PALE PINK MP PRT RAGLAN SWEAT ], [D, 1, 109, 11106, 0, , 31129413, 3636, 109, , 2098293, , 35929413, , S4547 PALE BLUE INDIAN PRINT JACKET ], [D, 1, 97, 11106, 0, , 31129710, 3636, 97, , 2098297, , 35929710, , S4547 PALE PINK EAGLE PRINT JACKET ]]')
else:
assert_p('Table1', 'Content', '[[D, 1, 44, 11840, 0, , 45872078, 4544, 44, , 2, 117093, , 45872078, , MT, H5, 033H DUSTY , PINK L/S FANCY CREW C\'MERE CARDIGAN], [D, 1, 14, 11984, 0, , 43372078, 4544, 14, , 2, 117152, , 45872078, , MT, H5, 033H DUSTY , PINK L/S FANCY CREW C\'MERE CARDIGAN], [D, 1, 29, 10120, 0, , 45874751, 4090, 29, , 2, 117337, , 45872078, , MT, H5, 030H BLK L/, S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 14, 0, 29440800000000, , 45874751, 4090, 14, , 2, 117347, , 35874751, , MT, H5, 030H BLK L/, S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 12, 10256, 0, , 35874751, 4090, 12, , 2, 117354, , 35874751, , MT, H5, 030H BLK L/, S VLVT RIBBON SCOOP C\'MERE W/BROOCH], [D, 1, 11, 5848, 0, , 31191697, 2726, 11, , 2, 327928, , 35891697, , SK, Y, BLUE SKP02 , L/WEIGHT PONCHO ], [D, 1, 11, 5848, 0, , 33391826, 2726, 11, , 2, 327931, , 35891826, , DU, ST, Y PINK SKP0, 2 L/WEIGHT PONCHO ], [D, 1, 28, 3356, 0, , 31191697, 2726, 28, , 2, 327933, , 35891697, , SK, Y, BLUE SKP02 , L/WEIGHT PONCHO ], [D, 1, 28, 3356, 0, , 31191826, 2726, 28, , 2, 327936, , 35891826, , DU, ST, Y PINK SKP0, 2 L/WEIGHT PONCHO ], [D, 1, 15, 3356, 0, , 31191697, 2726, 15, , 2, 327982, , 35891697, , SK, Y, BLUE SKP02 , L/WEIGHT PONCHO ], [D, 1, 15, 3356, 0, , 35221826, 2726, 15, , 2, 327985, , 35891826, , DU, ST, Y PINK SKP0, 2 L/WEIGHT PONCHO ], [D, 1, 123, 6723, 0, , 35116979, 2272, 123, , 2, 98136, , 35926979, , SA, 13, CHOC MUSTA, NG PRT RAGLAN SWEAT ], [D, 1, 133, 6723, 0, , 35117204, 2272, 133, , 2, 98137, , 35927204, , SA, 13, PALE BLUE , MP RAGLEN SWEAT ], [D, 1, 81, 6723, 0, , 31127419, 2272, 81, , 2, 98139, , 35927419, , SA, 13, PALE PINK , MP PRT RAGLAN SWEAT ], [D, 1, 49, 6723, 0, , 35333979, 2272, 49, , 2, 98158, , 35926979, , SA, 13, CHOC MUSTA, NG PRT RAGLAN SWEAT ], [D, 1, 49, 6723, 0, , 32227204, 2272, 49, , 2, 98159, , 35927204, , SA, 13, PALE BLUE , MP RAGLEN SWEAT ], [D, 1, 27, 6723, 0, , 32227419, 2272, 27, , 2, 98160, , 35927419, , SA, 13, PALE PINK , MP PRT RAGLAN SWEAT ], [D, 1, 24, 6183, 0, , 33336979, 2272, 24, , 2, 98161, , 35926979, , SA, 13, CHOC MUSTA, NG PRT RAGLAN SWEAT ], [D, 1, 24, 6183, 0, , 30027204, 2272, 24, , 2, 98165, , 35927204, , SA, 13, PALE BLUE , MP RAGLEN SWEAT ], [D, 1, 14, 6183, 0, , 35007419, 2272, 14, , 2, 98167, , 35927419, , SA, 13, PALE PINK , MP PRT RAGLAN SWEAT ], [D, 1, 109, 11106, 0, , 31129413, 3636, 109, , 2, 98293, , 35929413, , S4, 54, 7 PALE BLUE, INDIAN PRINT JACKET ], [D, 1, 97, 11106, 0, , 31129710, 3636, 97, , 2, 98297, , 35929710, , S4, 54, 7 PALE PINK, EAGLE PRINT JACKET ]]')
select('Table', 'cell:' + commonBits.fl('Start') + ',0(1)')
rightclick('Table', commonBits.fl('Field Name') + ',1')
select_menu(commonBits.fl('Generate Field Names'))
assert_p('Table', 'Text', '')
assert_p('Table1', 'Text', '')
select('ComboBox', 'header')
assert_p('Table', 'Text', '')
if commonBits.isVersion80():
assert_p('Table1', 'Content', '[[H, 145357, 4338, 233863, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75966, , OPTIONS PLCFT], [H, 145358, 4338, 233872, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75965, , OPTIONS PLCFT], [H, 145359, 4468, 255906, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75966, , OPTIONS PLCFT], [H, 145360, 4448, 290908, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75967, , OPTIONS PLCFT], [H, 145361, 4228, 292210, 40929, , 0, , 290, , 5, 1, 3, 5, 1, 75965, , OPTIONS PLCFT], [H, 145362, 5220, 211984, 40929, , 0, , 200, , 5, 1, 3, 5, 1, 75965, , LADIES KNICFT], [H, 145363, 5110, 211985, 40929, , 0, , 200, , 5, 1, 3, 5, 1, 75966, , LADIES KNICFT], [H, 145364, 5110, 211987, 40929, , 0, , 200, , 5, 1, 3, 5, 1, 65967, , LADIES KNICFT], [H, 145365, 13112, 211549, 41005, , 0, , 220, , 5, 1, 3, 5, 1, 85966, , LADIES KNICFT], [H, 145366, 13312, 211555, 41005, , 0, , 220, , 5, 1, 3, 5, 1, 75967, , LADIES KNICFT], [H, 145367, 12212, 222556, 41005, , 0, , 220, , 5, 1, 3, 5, 1, 75965, , LADIES KNICFT], [H, 145368, 1312, 211617, 41005, , 0, , 220, , 5, 1, 3, 5, 1, 175966, , LADIES KNICFT]]')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, 0, 0, true], [H1, 2, 6, 6, 0, true], [H2, 8, 10, 6, 0, true], [H3, 18, 12, 6, 0, true], [H4, 30, 6, 6, 0, true], [H5, 36, 8, 0, 0, true], [H6, 44, 2, 6, 0, true], [H7, 46, 2, 0, 0, true], [H8, 48, 3, 6, 0, true], [H9, 51, 1, 0, 0, true], [H10, 52, 2, 6, 0, true], [H11, 54, 2, 6, 0, true], [H12, 56, 2, 6, 0, true], [H13, 58, 2, 6, 0, true], [H14, 60, 2, 6, 0, true], [H15, 62, 6, 6, 0, true], [H16, 68, 8, 0, 0, true], [H17, 76, 13, 0, 0, true]]')
else:
assert_p('Table1', 'Content', '[[H, 145357, 4338, 233863, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75966, , OPTIONS, PLCFT], [H, 145358, 4338, 233872, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75965, , OPTIONS, PLCFT], [H, 145359, 4468, 255906, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75966, , OPTIONS, PLCFT], [H, 145360, 4448, 290908, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75967, , OPTIONS, PLCFT], [H, 145361, 4228, 292210, 4, 929, , 0, , 290, , 5, 1, 3, 5, 1, 75965, , OPTIONS, PLCFT], [H, 145362, 5220, 211984, 4, 929, , 0, , 200, , 5, 1, 3, 5, 1, 75965, , LADIES , KNICFT], [H, 145363, 5110, 211985, 4, 929, , 0, , 200, , 5, 1, 3, 5, 1, 75966, , LADIES , KNICFT], [H, 145364, 5110, 211987, 4, 929, , 0, , 200, , 5, 1, 3, 5, 1, 65967, , LADIES , KNICFT], [H, 145365, 13112, 211549, 4, 1005, , 0, , 220, , 5, 1, 3, 5, 1, 85966, , LADIES , KNICFT], [H, 145366, 13312, 211555, 4, 1005, , 0, , 220, , 5, 1, 3, 5, 1, 75967, , LADIES , KNICFT], [H, 145367, 12212, 222556, 4, 1005, , 0, , 220, , 5, 1, 3, 5, 1, 75965, , LADIES , KNICFT], [H, 145368, 1312, 211617, 4, 1005, , 0, , 220, , 5, 1, 3, 5, 1, 175966, , LADIES , KNICFT]]')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, 0, 0, true], [H1, 2, 6, 6, 0, true], [H2, 8, 10, 6, 0, true], [H3, 18, 12, 6, 0, true], [H4, 30, 2, 6, 0, true], [H5, 32, 4, 6, 0, true], [H6, 36, 8, 0, 0, true], [H7, 44, 2, 6, 0, true], [H8, 46, 2, 0, 0, true], [H9, 48, 3, 6, 0, true], [H10, 51, 1, 0, 0, true], [H11, 52, 2, 6, 0, true], [H12, 54, 2, 6, 0, true], [H13, 56, 2, 6, 0, true], [H14, 58, 2, 6, 0, true], [H15, 60, 2, 6, 0, true], [H16, 62, 6, 6, 0, true], [H17, 68, 8, 0, 0, true], [H18, 76, 7, 0, 0, true], [H19, 83, 6, 0, 0, true]]')
assert_p('TextArea', 'Text', commonBits.fl('You must define the Fields for all Records. Please update - detail')
)
click('Right')
assert_p('TextArea', 'Text', commonBits.fl('You must define the field Names in all Records, please update: store')
)
if commonBits.isVersion80():
assert_p('Table1', 'Content', '[[S, 15, 015, 15, 019, 35, 033, 13337, 20780001, 5037, 1, 5052, 1, 5055, 1, 5060, 2, 5070, 1, 5074, 1], [S, 15, 078, 15, 081, 15, 085, 15090, 1, 5091, 1, 5093, 1, 5095, 1, 5129, 1, 5144, 1, 5165, 1], [S, 15, 303, 15, 169, 15, 170, 15171, 1, 5177, 1, 5016, 1, 5089, 2, 5136, 1, 5011, 1, 5046, 1], [S, 15, 145, 15, 096, 25, 154, 15162, 1, 5163, 1, 5164, 1, 5192, 1, 5150, 1, 5175, 1, , 0], [S, 15, 036, 15, 043, 15, 045, 15057, 1, 5065, 1, 5069, 1, 5076, 1, 5079, 1, 5094, 1, 5128, 1], [S, 15, 151, 15, 180, 15, 072, 15173, 1, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15, 015, 15, 019, 25, 037, 23533, 47510001, 5070, 1, 5078, 1, 5093, 1, 5095, 1, 5129, 1, 5144, 1], [S, 15, 165, 15, 170, 15, 171, 15016, 2, 5089, 2, 5136, 1, 5011, 1, 5046, 1, 5096, 1, 5154, 1], [S, 15, 162, 15, 163, 15, 164, 15192, 1, 5175, 1, , 0, , 0, , 0, , 0, , 0], [S, 15, 083, 15, 133, 15, 155, 13584, 47510001, 5166, 1, 5167, 1, 5049, 1, 5139, 1, 5002, 1, 5027, 1], [S, 15, 038, 15, 140, 15, 174, 15184, 1, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15, 036, 15, 043, 15, 045, 13533, 47510001, 5069, 1, 5076, 1, 5094, 1, 5128, 1, 5151, 1, 5180, 1], [S, 15, 072, 15, 173, 1, , 0, 0, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15, 036, 15, 043, 15, 045, 15057, 1, 5065, 1, 5069, 1, 5076, 1, 5094, 1, 5128, 1, 5151, 1], [S, 15, 180, 1, , 0, , 0, 0, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15, 036, 15, 043, 15, 045, 15057, 1, 5065, 1, 5069, 1, 5076, 1, 5094, 1, 5128, 1, 5151, 1], [S, 15, 180, 1, , 0, , 0, 0, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15, 015, 15, 019, 15, 033, 15037, 1, 5060, 1, 5074, 1, 5078, 1, 5085, 1, 5091, 1, 5093, 1], [S, 15, 095, 15, 129, 15, 144, 15169, 1, 5170, 1, 5171, 1, 5177, 1, 5016, 1, 5089, 1, 5136, 1], [S, 15, 046, 15, 145, 15, 096, 15154, 1, 5162, 1, 5164, 1, 5192, 1, 5175, 1, , 0, , 0], [S, 15, 015, 15, 019, 15, 033, 15037, 1, 5060, 1, 5074, 1, 5078, 1, 5085, 1, 5091, 1, 5093, 1], [S, 15, 095, 15, 129, 15, 144, 15169, 1, 5170, 1, 5171, 1, 5177, 1, 5016, 1, 5089, 1, 5136, 1], [S, 15, 046, 15, 145, 15, 096, 15154, 1, 5162, 1, 5164, 1, 5192, 1, 5175, 1, , 0, , 0], [S, 15, 040, 15, 020, 15, 083, 15133, 1, 5135, 1, 5155, 1, 5166, 1, 5139, 1, 5002, 1, 5027, 1], [S, 15, 038, 15, 126, 15, 140, 15174, 1, 5184, 1, , 0, , 0, , 0, , 0, , 0], [S, 15, 040, 15, 020, 15, 083, 15133, 1, 5135, 1, 5155, 1, 5166, 1, 5139, 1, 5002, 1, 5027, 1], [S, 15, 038, 15, 126, 15, 140, 15174, 1, 5184, 1, , 0, , 0, , 0, , 0, , 0], [S, 15, 015, 25, 019, 65, 033, 25035, 2, 5037, 6, 5052, 2, 5055, 2, 5060, 2, 5070, 1, 5074, 6], [S, 15, 078, 65, 081, 15, 085, 45090, 2, 5091, 5, 5093, 3, 5095, 3, 5129, 6, 5144, 3, 5165, 1], [S, 15, 303, 15, 169, 45, 170, 25171, 2, 5177, 5, 5178, 3, 5016, 2, 5089, 3, 5136, 1, 5011, 1], [S, 15, 046, 35, 145, 45, 096, 65154, 5, 5162, 5, 5163, 3, 5164, 2, 5192, 2, 5150, 2, 5175, 2], [S, 15, 015, 25, 019, 75, 033, 25035, 2, 5037, 6, 5052, 2, 5055, 2, 5060, 2, 5070, 2, 5074, 6], [S, 15, 078, 75, 081, 25, 085, 45090, 2, 5091, 6, 5093, 3, 5095, 3, 5129, 6, 5144, 3, 5165, 2], [S, 15, 303, 25, 169, 45, 170, 25171, 2, 5177, 6, 5178, 3, 5016, 2, 5089, 3, 5136, 2, 5011, 2], [S, 15, 046, 35, 145, 45, 096, 65154, 5, 5162, 5, 5163, 3, 5164, 2, 5192, 2, 5150, 2, 5175, 2], [S, 15, 019, 55, 037, 55, 074, 55078, 5, 5085, 4, 5091, 5, 5093, 3, 5095, 3, 5129, 5, 5144, 3], [S, 15, 169, 35, 177, 65, 178, 35089, 3, 5046, 3, 5145, 4, 5096, 5, 5154, 4, 5162, 4, 5163, 3], [S, 15, 040, 25, 020, 25, 059, 15068, 1, 5083, 1, 5084, 2, 5133, 2, 5135, 2, 5155, 2, 5156, 2], [S, 15, 166, 35, 167, 25, 048, 25049, 2, 5139, 2, 5143, 2, 5003, 2, 5002, 2, 5027, 2, 5038, 2], [S, 15, 073, 25, 126, 25, 140, 25174, 3, 5184, 2, , 0, , 0, , 0, , 0, , 0], [S, 15, 040, 25, 020, 25, 059, 15068, 1, 5083, 1, 5084, 2, 5133, 2, 5135, 2, 5155, 2, 5156, 2], [S, 15, 166, 25, 167, 25, 048, 15049, 1, 5139, 2, 5143, 2, 5003, 2, 5010, 1, 5062, 1, 5138, 1], [S, 15, 141, 15, 002, 25, 027, 25038, 2, 5073, 2, 5126, 2, 5140, 2, 5174, 2, 5184, 2, , 0], [S, 15, 040, 15, 020, 15, 068, 15083, 1, 5084, 1, 5133, 1, 5135, 1, 5155, 1, 5156, 1, 5166, 2], [S, 15, 167, 15, 048, 15, 049, 15139, 1, 5143, 1, 5002, 1, 5027, 2, 5038, 2, 5073, 1, 5126, 1], [S, 15, 140, 15, 174, 25, 184, 1, 0, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15, 036, 25, 043, 35, 045, 25057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [S, 15, 151, 25, 180, 15, 072, 15173, 1, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15, 036, 15, 043, 25, 045, 25057, 1, 5065, 2, 5069, 2, 5076, 2, 5079, 1, 5094, 2, 5128, 2], [S, 15, 151, 25, 180, 25, 072, 15173, 2, , 0, , 0, , 0, , 0, , 0, , 0], [S, 15, 043, 25, 045, 25, 065, 15076, 2, 5128, 2, 5151, 2, 5180, 1, 5072, 1, 5173, 1, , 0], [S, 15, 015, 25, 019, 45, 033, 25035, 2, 5037, 4, 5052, 2, 5055, 2, 5060, 2, 5070, 2, 5074, 3], [S, 15, 078, 45, 081, 25, 085, 35090, 2, 5091, 4, 5093, 3, 5095, 4, 5129, 4, 5144, 4, 5165, 2], [S, 15, 303, 25, 169, 25, 170, 25171, 2, 5177, 4, 5016, 4, 5089, 3, 5136, 2, 5011, 3, 5046, 2], [S, 15, 145, 35, 096, 45, 154, 45162, 4, 5163, 3, 5164, 2, 5192, 2, 5150, 2, 5175, 2, , 0], [S, 15, 015, 25, 019, 55, 033, 25037, 5, 5060, 2, 5070, 1, 5074, 3, 5078, 5, 5085, 2, 5090, 2], [S, 15, 091, 55, 093, 25, 095, 35129, 6, 5144, 5, 5165, 2, 5169, 2, 5170, 2, 5171, 2, 5177, 5], [S, 15, 178, 25, 016, 45, 089, 25136, 2, 5011, 2, 5046, 2, 5145, 2, 5096, 5, 5154, 3, 5162, 3], [S, 15, 163, 25, 164, 25, 192, 25175, 1, , 0, , 0, , 0, , 0, , 0, , 0]]')
select('Table', 'cell:' + commonBits.fl('Start') + ',2(7)')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, 0, 0, true], [, 2, 2, 6, 0, true], [, 4, 3, 0, 0, true], [, 7, 9, 6, 0, true], [, 16, 3, 0, 0, true], [, 19, 9, 6, 0, true], [, 28, 3, 0, 0, true], [, 31, 12, 6, 0, true], [, 43, 8, 6, 0, true], [, 51, 4, 0, 0, true], [, 55, 8, 6, 0, true], [, 63, 4, 0, 0, true], [, 67, 8, 6, 0, true], [, 75, 4, 0, 0, true], [, 79, 8, 6, 0, true], [, 87, 4, 0, 0, true], [, 91, 8, 6, 0, true], [, 99, 4, 0, 0, true], [, 103, 8, 6, 0, true], [, 111, 4, 0, 0, true], [, 115, 8, 6, 0, true]]')
else:
assert_p('Table1', 'Content', '[[S, 15015, 15019, 35033, 13337, 207800015037, 15052, 15055, 15060, 25070, 15074, 1], [S, 15078, 15081, 15085, 15090, 15091, 15093, 15095, 15129, 15144, 15165, 1], [S, 15303, 15169, 15170, 15171, 15177, 15016, 15089, 25136, 15011, 15046, 1], [S, 15145, 15096, 25154, 15162, 15163, 15164, 15192, 15150, 15175, 1, 0], [S, 15036, 15043, 15045, 15057, 15065, 15069, 15076, 15079, 15094, 15128, 1], [S, 15151, 15180, 15072, 15173, 1, 0, 0, 0, 0, 0, 0], [S, 15015, 15019, 25037, 23533, 475100015070, 15078, 15093, 15095, 15129, 15144, 1], [S, 15165, 15170, 15171, 15016, 25089, 25136, 15011, 15046, 15096, 15154, 1], [S, 15162, 15163, 15164, 15192, 15175, 1, 0, 0, 0, 0, 0], [S, 15083, 15133, 15155, 13584, 475100015166, 15167, 15049, 15139, 15002, 15027, 1], [S, 15038, 15140, 15174, 15184, 1, 0, 0, 0, 0, 0, 0], [S, 15036, 15043, 15045, 13533, 475100015069, 15076, 15094, 15128, 15151, 15180, 1], [S, 15072, 15173, 1, 0, 0, 0, 0, 0, 0, 0, 0], [S, 15036, 15043, 15045, 15057, 15065, 15069, 15076, 15094, 15128, 15151, 1], [S, 15180, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0], [S, 15036, 15043, 15045, 15057, 15065, 15069, 15076, 15094, 15128, 15151, 1], [S, 15180, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0], [S, 15015, 15019, 15033, 15037, 15060, 15074, 15078, 15085, 15091, 15093, 1], [S, 15095, 15129, 15144, 15169, 15170, 15171, 15177, 15016, 15089, 15136, 1], [S, 15046, 15145, 15096, 15154, 15162, 15164, 15192, 15175, 1, 0, 0], [S, 15015, 15019, 15033, 15037, 15060, 15074, 15078, 15085, 15091, 15093, 1], [S, 15095, 15129, 15144, 15169, 15170, 15171, 15177, 15016, 15089, 15136, 1], [S, 15046, 15145, 15096, 15154, 15162, 15164, 15192, 15175, 1, 0, 0], [S, 15040, 15020, 15083, 15133, 15135, 15155, 15166, 15139, 15002, 15027, 1], [S, 15038, 15126, 15140, 15174, 15184, 1, 0, 0, 0, 0, 0], [S, 15040, 15020, 15083, 15133, 15135, 15155, 15166, 15139, 15002, 15027, 1], [S, 15038, 15126, 15140, 15174, 15184, 1, 0, 0, 0, 0, 0], [S, 15015, 25019, 65033, 25035, 25037, 65052, 25055, 25060, 25070, 15074, 6], [S, 15078, 65081, 15085, 45090, 25091, 55093, 35095, 35129, 65144, 35165, 1], [S, 15303, 15169, 45170, 25171, 25177, 55178, 35016, 25089, 35136, 15011, 1], [S, 15046, 35145, 45096, 65154, 55162, 55163, 35164, 25192, 25150, 25175, 2], [S, 15015, 25019, 75033, 25035, 25037, 65052, 25055, 25060, 25070, 25074, 6], [S, 15078, 75081, 25085, 45090, 25091, 65093, 35095, 35129, 65144, 35165, 2], [S, 15303, 25169, 45170, 25171, 25177, 65178, 35016, 25089, 35136, 25011, 2], [S, 15046, 35145, 45096, 65154, 55162, 55163, 35164, 25192, 25150, 25175, 2], [S, 15019, 55037, 55074, 55078, 55085, 45091, 55093, 35095, 35129, 55144, 3], [S, 15169, 35177, 65178, 35089, 35046, 35145, 45096, 55154, 45162, 45163, 3], [S, 15040, 25020, 25059, 15068, 15083, 15084, 25133, 25135, 25155, 25156, 2], [S, 15166, 35167, 25048, 25049, 25139, 25143, 25003, 25002, 25027, 25038, 2], [S, 15073, 25126, 25140, 25174, 35184, 2, 0, 0, 0, 0, 0], [S, 15040, 25020, 25059, 15068, 15083, 15084, 25133, 25135, 25155, 25156, 2], [S, 15166, 25167, 25048, 15049, 15139, 25143, 25003, 25010, 15062, 15138, 1], [S, 15141, 15002, 25027, 25038, 25073, 25126, 25140, 25174, 25184, 2, 0], [S, 15040, 15020, 15068, 15083, 15084, 15133, 15135, 15155, 15156, 15166, 2], [S, 15167, 15048, 15049, 15139, 15143, 15002, 15027, 25038, 25073, 15126, 1], [S, 15140, 15174, 25184, 1, 0, 0, 0, 0, 0, 0, 0], [S, 15036, 25043, 35045, 25057, 15065, 25069, 25076, 25079, 15094, 25128, 2], [S, 15151, 25180, 15072, 15173, 1, 0, 0, 0, 0, 0, 0], [S, 15036, 15043, 25045, 25057, 15065, 25069, 25076, 25079, 15094, 25128, 2], [S, 15151, 25180, 25072, 15173, 2, 0, 0, 0, 0, 0, 0], [S, 15043, 25045, 25065, 15076, 25128, 25151, 25180, 15072, 15173, 1, 0], [S, 15015, 25019, 45033, 25035, 25037, 45052, 25055, 25060, 25070, 25074, 3], [S, 15078, 45081, 25085, 35090, 25091, 45093, 35095, 45129, 45144, 45165, 2], [S, 15303, 25169, 25170, 25171, 25177, 45016, 45089, 35136, 25011, 35046, 2], [S, 15145, 35096, 45154, 45162, 45163, 35164, 25192, 25150, 25175, 2, 0], [S, 15015, 25019, 55033, 25037, 55060, 25070, 15074, 35078, 55085, 25090, 2], [S, 15091, 55093, 25095, 35129, 65144, 55165, 25169, 25170, 25171, 25177, 5], [S, 15178, 25016, 45089, 25136, 25011, 25046, 25145, 25096, 55154, 35162, 3], [S, 15163, 25164, 25192, 25175, 1, 0, 0, 0, 0, 0, 0]]')
select('Table', 'cell:' + commonBits.fl('Start') + ',2(7)')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, 0, 0, true], [, 2, 5, 6, 0, true], [, 7, 12, 6, 0, true], [, 19, 12, 6, 0, true], [, 31, 12, 6, 0, true], [, 43, 12, 6, 0, true], [, 55, 12, 6, 0, true], [, 67, 12, 6, 0, true], [, 79, 12, 6, 0, true], [, 91, 12, 6, 0, true], [, 103, 12, 6, 0, true], [, 115, 8, 6, 0, true]]')
# select('Table', '')
rightclick('Table', commonBits.fl('Field Name') + ',1')
select_menu(commonBits.fl('Generate Field Names'))
if commonBits.isVersion80():
assert_p('Table', 'Content', '[[Record_Type, 1, 1, 0, 0, true], [S1, 2, 2, 6, 0, true], [S2, 4, 3, 0, 0, true], [S3, 7, 9, 6, 0, true], [S4, 16, 3, 0, 0, true], [S5, 19, 9, 6, 0, true], [S6, 28, 3, 0, 0, true], [S7, 31, 12, 6, 0, true], [S8, 43, 8, 6, 0, true], [S9, 51, 4, 0, 0, true], [S10, 55, 8, 6, 0, true], [S11, 63, 4, 0, 0, true], [S12, 67, 8, 6, 0, true], [S13, 75, 4, 0, 0, true], [S14, 79, 8, 6, 0, true], [S15, 87, 4, 0, 0, true], [S16, 91, 8, 6, 0, true], [S17, 99, 4, 0, 0, true], [S18, 103, 8, 6, 0, true], [S19, 111, 4, 0, 0, true], [S20, 115, 8, 6, 0, true]]')
else:
assert_p('Table', 'Content', '[[Record_Type, 1, 1, 0, 0, true], [S1, 2, 5, 6, 0, true], [S2, 7, 12, 6, 0, true], [S3, 19, 12, 6, 0, true], [S4, 31, 12, 6, 0, true], [S5, 43, 12, 6, 0, true], [S6, 55, 12, 6, 0, true], [S7, 67, 12, 6, 0, true], [S8, 79, 12, 6, 0, true], [S9, 91, 12, 6, 0, true], [S10, 103, 12, 6, 0, true], [S11, 115, 8, 6, 0, true]]')
click('Right')
select('TabbedPane', '')
click('Pnl7SaveDbLayout', 264, 53)
select('TextField', 'Wizard_xAmsPO')
click('Right')
if commonBits.isVersion80():
select('Table', 'cell:2 - 2|S1,0(14)')
else:
select('Table', 'cell:2 - 5|S1,0(14535)')
rightclick('Table', '1 - 1|Record_Type,0')
## select('Table', 'cell:2 - 5|S1,0(14535)')
select_menu(commonBits.fl('Edit Record'))
## select('Table1', 'cell:2 - 5|S1,0(14535)')
if commonBits.isVersion80():
assert_p('Table', 'Content', '[[Record_Type, 1, 1, H, H], [H1, 2, 6, 145357, 145357], [H2, 8, 10, 4338, 0000004338], [H3, 18, 12, 233863, 000000233863], [H4, 30, 6, 40929, 040929], [H5, 36, 8, , ], [H6, 44, 2, 0, 00], [H7, 46, 2, , ], [H8, 48, 3, 290, 290], [H9, 51, 1, , ], [H10, 52, 2, 5, 05], [H11, 54, 2, 1, 01], [H12, 56, 2, 3, 03], [H13, 58, 2, 5, 05], [H14, 60, 2, 1, 01], [H15, 62, 6, 75966, 075966], [H16, 68, 8, , ], [H17, 76, 13, OPTIONS PLCFT, OPTIONS PLCFT]]')
click('Right')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, D, D], [D1, 2, 1, 1, 1], [D2, 3, 5, 44, 00044], [D3, 8, 15, 11840, 000000000011840], [D4, 23, 15, 0, 000000000000000], [D5, 38, 1, , ], [D6, 39, 8, 45872078, 45872078], [D7, 47, 11, 4544, 00000004544], [D8, 58, 7, 44, 0000044], [D9, 65, 7, , ], [D10, 72, 7, 2117093, 2117093], [D11, 79, 8, , ], [D12, 87, 8, 45872078, 45872078], [D13, 95, 7, , ], [D14, 102, 50, MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGAN, MTH5033H DUSTY PINK L/S FANCY CREW C\'MERE CARDIGAN]]')
click('Right')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, S, S], [S1, 2, 2, 15, 15], [S2, 4, 3, 015, 015], [S3, 7, 9, 15, 000000015], [S4, 16, 3, 019, 019], [S5, 19, 9, 35, 000000035], [S6, 28, 3, 033, 033], [S7, 31, 12, 13337, 000000013337], [S8, 43, 8, 20780001, 20780001], [S9, 51, 4, 5037, 5037], [S10, 55, 8, 1, 00000001], [S11, 63, 4, 5052, 5052], [S12, 67, 8, 1, 00000001], [S13, 75, 4, 5055, 5055], [S14, 79, 8, 1, 00000001], [S15, 87, 4, 5060, 5060], [S16, 91, 8, 2, 00000002], [S17, 99, 4, 5070, 5070], [S18, 103, 8, 1, 00000001], [S19, 111, 4, 5074, 5074], [S20, 115, 8, 1, 00000001]]')
click('Right')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, S, S], [S1, 2, 2, 15, 15], [S2, 4, 3, 078, 078], [S3, 7, 9, 15, 000000015], [S4, 16, 3, 081, 081], [S5, 19, 9, 15, 000000015], [S6, 28, 3, 085, 085], [S7, 31, 12, 15090, 000000015090], [S8, 43, 8, 1, 00000001], [S9, 51, 4, 5091, 5091], [S10, 55, 8, 1, 00000001], [S11, 63, 4, 5093, 5093], [S12, 67, 8, 1, 00000001], [S13, 75, 4, 5095, 5095], [S14, 79, 8, 1, 00000001], [S15, 87, 4, 5129, 5129], [S16, 91, 8, 1, 00000001], [S17, 99, 4, 5144, 5144], [S18, 103, 8, 1, 00000001], [S19, 111, 4, 5165, 5165], [S20, 115, 8, 1, 00000001]]')
else:
assert_p('Table', 'Content', '[[Record_Type, 1, 1, H, H], [H1, 2, 6, 145357, 145357], [H2, 8, 10, 4338, 0000004338], [H3, 18, 12, 233863, 000000233863], [H4, 30, 2, 4, 04], [H5, 32, 4, 929, 0929], [H6, 36, 8, , ], [H7, 44, 2, 0, 00], [H8, 46, 2, , ], [H9, 48, 3, 290, 290], [H10, 51, 1, , ], [H11, 52, 2, 5, 05], [H12, 54, 2, 1, 01], [H13, 56, 2, 3, 03], [H14, 58, 2, 5, 05], [H15, 60, 2, 1, 01], [H16, 62, 6, 75966, 075966], [H17, 68, 8, , ], [H18, 76, 7, OPTIONS, OPTIONS], [H19, 83, 6, PLCFT, PLCFT]]')
click('Right')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, D, D], [D1, 2, 1, 1, 1], [D2, 3, 5, 44, 00044], [D3, 8, 15, 11840, 000000000011840], [D4, 23, 15, 0, 000000000000000], [D5, 38, 1, , ], [D6, 39, 8, 45872078, 45872078], [D7, 47, 11, 4544, 00000004544], [D8, 58, 7, 44, 0000044], [D9, 65, 7, , ], [D10, 72, 1, 2, 2], [D11, 73, 6, 117093, 117093], [D12, 79, 8, , ], [D13, 87, 8, 45872078, 45872078], [D14, 95, 7, , ], [D15, 102, 2, MT, MT], [D16, 104, 2, H5, H5], [D17, 106, 11, 033H DUSTY, 033H DUSTY], [D18, 117, 35, PINK L/S FANCY CREW C\'MERE CARDIGAN, PINK L/S FANCY CREW C\'MERE CARDIGAN]]')
click('Right')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, S, S], [S1, 2, 5, 15015, 15015], [S2, 7, 12, 15019, 000000015019], [S3, 19, 12, 35033, 000000035033], [S4, 31, 12, 13337, 000000013337], [S5, 43, 12, 207800015037, 207800015037], [S6, 55, 12, 15052, 000000015052], [S7, 67, 12, 15055, 000000015055], [S8, 79, 12, 15060, 000000015060], [S9, 91, 12, 25070, 000000025070], [S10, 103, 12, 15074, 000000015074], [S11, 115, 8, 1, 00000001]]')
click('Right')
assert_p('Table', 'Content', '[[Record_Type, 1, 1, S, S], [S1, 2, 5, 15078, 15078], [S2, 7, 12, 15081, 000000015081], [S3, 19, 12, 15085, 000000015085], [S4, 31, 12, 15090, 000000015090], [S5, 43, 12, 15091, 000000015091], [S6, 55, 12, 15093, 000000015093], [S7, 67, 12, 15095, 000000015095], [S8, 79, 12, 15129, 000000015129], [S9, 91, 12, 15144, 000000015144], [S10, 103, 12, 15165, 000000015165], [S11, 115, 8, 1, 00000001]]')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
if commonBits.isVersion80():
select('Table', 'cell:2 - 2|S1,0(14)')
else:
select('Table', 'cell:2 - 5|S1,0(14535)')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
click('Open')
select('ComboBox1', 'Ams')
click(commonBits.fl('Edit') + '1')
commonBits.closeWindow(click)
##click('BasicInternalFrameTitlePane$NoFocusButton2')
select_menu(commonBits.fl('Record Layouts') + '>>' + commonBits.fl('Edit Layout'))
select('TextField', 'Wizard_xAmsPO')
select('TextField1', '%')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Extras')
##select('TabbedPane', 'Child Records')
select('ChildRecordsJTbl', 'cell:' + commonBits.fl('Field') + ',0(Record_Type)')
assert_p('ChildRecordsJTbl', 'Text', 'Record_Type', commonBits.fl('Field') + ',0')
select('ChildRecordsJTbl', 'cell:' + commonBits.fl('Field Value') + ',0(H)')
assert_p('ChildRecordsJTbl', 'Text', 'H', commonBits.fl('Field Value') + ',0')
select('ChildRecordsJTbl', 'cell:' + commonBits.fl('Field Value') + ',1(D)')
assert_p('ChildRecordsJTbl', 'Text', 'D', commonBits.fl('Field Value') + ',1')
select('ChildRecordsJTbl', 'cell:' + commonBits.fl('Field Value') + ',2(S)')
assert_p('ChildRecordsJTbl', 'Text', 'S', commonBits.fl('Field Value') + ',2')
select('ChildRecordsJTbl', 'cell:' + commonBits.fl('Field') + ',2(Record_Type)')
assert_p('ChildRecordsJTbl', 'Text', 'Record_Type', commonBits.fl('Field') + ',2')
select('ChildRecordsJTbl', 'cell:' + commonBits.fl('Field') + ',2(Record_Type)')
##click('Delete3')
commonBits.delete3(click)
if window(commonBits.fl('Delete: Wizard_xAmsPO')):
click('Yes')
close()
# select('TabbedPane', 'Extras')
# select('TabbedPane', 'Extras')
# select('TabbedPane', 'Fields')
# select('TabbedPane', 'Extras')
# select('TabbedPane', 'Extras')
# select('TabbedPane', 'Fields')