BGUK Create Table Gaev Keeka 2.0 Create neoTable from JSON file Desktop False 800 600 False False False WebApp False en [AndroidOS,iOS,WindowsPhoneOS] normal True True False True True False False True False False TopCenterApp 20px 325px 762px 268px 22px 103px 758px 213px [FileContent] 23px 9px 186px 35px Fetch Data From File ... feedback that command is being initiated SetVar [FeedbackMessage] "Starting LoadJSON for [FileToFetch]" ... fetch content of file containing an array of json objects LoadJSON "[FileToFetch]" [FileContent] ... feedback that command is completed SetVar [FeedbackMessage] "LoadJSON for [FileToFetch] has ended." ... get array length ArrayLen [FileContent] [FileContentLen] ... feedback array length SetVar [FeedbackMessage] "Fetched data from [FileToFetch] has [FileContentLen] array items" 22px 54px 756px 43px [FeedbackMessage] 214px 9px 186px 35px Show in neoTable Format ... Reset any previous column definitions neoTableResetColumns "neoTableContainer" ... setup columns; IMPORTANT: column numbers MUST start at 1 neoTableSetColumn "neoTableContainer" 1 "id" "Id" "" false false false "" neoTableSetColumn "neoTableContainer" 2 "fname" "First Name" "" false false false "" neoTableSetColumn "neoTableContainer" 3 "lname" "Last Name" "" false false false "" neoTableSetColumn "neoTableContainer" 4 "email" "Email Address" "" false false false "" neoTableSetColumn "neoTableContainer" 5 "gender" "Gender" "" false false false "" neoTableSetColumn "neoTableContainer" 6 "ip_address" "IP Address" "" false false false "" ... define user permissions neoTableInitTable "neoTableContainer" "" 0 "Table" false false false false false "" ... load Data neoTableLoadData "neoTableContainer" [FileContent] ... feedback that actions complete SetVar [FeedbackMessage] "Content from [FileToFetch] has been loaded as neoTable" 22px 103px 750px 480px [loadedJSON] 170px 52px 98px 35px Load JSON SetVar [loadedJSON] "Starting LoadJSON for [FileToFetch]" LoadJSON "[FileToFetch]" [loadedJSON] ArrayLen [loadedJSON] [loadedJSONArrayLen] AlertBox "Array Length" "[loadedJSONArrayLen]" "" 652px 54px 119px 35px Go to Page2 GotoPage "Page2" <left>26px</left> <top>13px</top> <width>748px</width> <height>34px</height> <variable>[FileToFetch]</variable> <init_value>http://visualneo.com/filedownloads/multirecord.json</init_value> 26px 52px 100px 35px OpenURL SetVar [loadedJSON] "Starting OpenURL for [FileToFetch]" OpenURL "[FileToFetch]" 324px 52px 144px 36px Show JSON Strings ... [lastItem] is length -1 (array item numbers are zero based) SetVar [lastItem] [loadedJSONArrayLen]-1 Loop 0 [lastItem] [thisItem] ... extract json object items SetVar [thisJSONItem] "[loadedJSON([thisItem])]" AlertBox "JSON Item [thisItem]" "fname = [thisJSONItem('fname')]<br/>lname =[thisJSONItem('lname')]" "" EndLoop 16px 60px 762px 401px 152px 14px 128px 32px Create Table ... Reset any previous column definitions neoTableResetColumns "BasicTableContainer" ... setup columns; IMPORTANT: column numbers MUST start at 1 neoTableSetColumn "BasicTableContainer" 1 "id" "Id" "" false false false "" neoTableSetColumn "BasicTableContainer" 2 "fname" "First Name" "" false false false "" neoTableSetColumn "BasicTableContainer" 3 "lname" "Last Name" "" false false false "" neoTableSetColumn "BasicTableContainer" 4 "email" "Email Address" "" false false false "" neoTableSetColumn "BasicTableContainer" 5 "gender" "Gender" "" false false false "" neoTableSetColumn "BasicTableContainer" 6 "ip_address" "IP Address" "" false false false "" ... define user permissions neoTableInitTable "BasicTableContainer" "" 0 "Table" false false false false false "" ... load Data neoTableLoadData "BasicTableContainer" [mydata] 18px 14px 130px 32px Create mydata CreateEmptyArray [mydata] Loop 0 [lastItem] [thisItem] SetVar [thisJSONItem] "[loadedJSON([thisItem])]" ArrayAddItem [mydata] [thisJSONItem] EndLoop ArrayLen [mydata] [mydataLen] AlertBox "mydata" "has [mydataLen] rows of data" "" 656px 15px 119px 35px Go to Page1 GotoPage "Page1" 0px 0px 800px 600px False