csv_editor-1.json

{"applicationInfo":{"name":"csv_editor","createAt":1668760857793,"createBy":"6376005ec4ff4a064d6f77ca","applicationId":"63774519c4ff4a064d6f7e22","applicationType":2},"applicationDSL":{"ui":{"compType":"module","comp":{"io":{"inputs":[{"name":"path","description":"","type":"string","defaultValue":{"compType":"string","comp":"serverfile.csv"},"test":{"compType":"string","comp":""}},{"name":"root","description":"","type":"string","defaultValue":{"compType":"string","comp":"http://myserver"},"test":{"compType":"string","comp":""}}],"outputs":[]},"methods":[],"events":{"list":[],"enableEventTestMessage":true},"autoScaleCompHeight":false,"container":{"layout":{"20e975bf":{"i":"20e975bf","h":5,"w":3,"x":0,"y":0},"dd2fb0ec":{"i":"dd2fb0ec","h":5,"w":5,"x":3,"y":0},"bebb3770":{"i":"bebb3770","h":5,"w":4,"x":17,"y":0},"71eb6d54":{"i":"71eb6d54","h":87,"w":21,"delayCollision":true,"x":0,"y":6}},"items":{"20e975bf":{"compType":"button","comp":{"text":"Save","type":"","onEvent":[],"disabled":"","loading":"","form":"","prefixIcon":"","suffixIcon":"","style":{"background":"","border":"","radius":"","text":""},"hidden":""},"name":"btnSave"},"dd2fb0ec":{"compType":"file","comp":{"text":"Upload file","uploadType":"single","fileType":"","showUploadList":false,"disabled":"","onEvent":[{"name":"change","handler":{"compType":"executeQuery","comp":{"queryName":"uploadFileQuery"},"condition":"","slowdown":"debounce","delay":""}},{"name":"change","handler":{"compType":"executeQuery","comp":{"queryName":"reloadTable"},"condition":"","slowdown":"debounce","delay":""}}],"style":{"background":"","border":"","radius":"","text":"","accent":""},"minSize":"","maxSize":"100MB","maxFiles":"","formDataKey":"","hidden":""},"name":"uploadFile"},"bebb3770":{"compType":"button","comp":{"text":"Refresh from server","type":"","onEvent":[{"name":"click","handler":{"compType":"executeQuery","comp":{"queryName":"reloadTable"},"condition":"","slowdown":"debounce","delay":""}}],"disabled":"","loading":"","form":"","prefixIcon":"","suffixIcon":"","style":{"background":"","border":"","radius":"","text":""},"hidden":""},"name":"btnRefresh"},"71eb6d54":{"compType":"tabbedContainer","comp":{"tabs":{"manual":[{"id":0,"label":"Table view","key":"table_view","hidden":""},{"id":1,"label":"Raw view","key":"raw_view","hidden":""}]},"selectedTabKey":"table_view","containers":{"0":{"layout":{"9854ce94":{"i":"9854ce94","h":75,"w":24,"x":0,"y":0}},"items":{"9854ce94":{"compType":"table","comp":{"hideBordered":false,"hideHeader":false,"data":"{{csvData.value}}","columns":[{"title":"_index","isCustom":false,"dataIndex":"_index","hide":true,"sortable":false,"width":-1,"autoWidth":"auto","render":{"compType":"text","comp":{"text":"{{currentCell}}"}},"align":"left","fixed":"close"},{"title":"","isCustom":true,"dataIndex":"101155a5","hide":false,"sortable":false,"width":152.00003051757812,"autoWidth":"fixed","render":{"compType":"button","comp":{"text":"Edit","buttonType":"default","onClick":{"compType":"executeComp","comp":{"name":"tableEditorModal","methodName":"openModal","params":[]},"condition":"","slowdown":"debounce","delay":""},"loading":"","disabled":""}},"align":"left","fixed":"close"},{"title":"parameter","isCustom":false,"dataIndex":"parameter","hide":false,"sortable":false,"width":-1,"autoWidth":"auto","render":{"compType":"text","comp":{"text":"{{currentCell}}"}},"align":"left","fixed":"close"},{"title":"address","isCustom":false,"dataIndex":"address","hide":false,"sortable":false,"width":-1,"autoWidth":"auto","render":{"compType":"text","comp":{"text":"{{currentCell}}"}},"align":"left","fixed":"close"},{"title":"type","isCustom":false,"dataIndex":"type","hide":false,"sortable":false,"width":-1,"autoWidth":"auto","render":{"compType":"text","comp":{"text":"{{currentCell}}"}},"align":"left","fixed":"close"},{"title":"size","isCustom":false,"dataIndex":"size","hide":false,"sortable":false,"width":-1,"autoWidth":"auto","render":{"compType":"text","comp":{"text":"{{currentCell}}"}},"align":"left","fixed":"close"},{"title":"unit","isCustom":false,"dataIndex":"unit","hide":false,"sortable":false,"width":-1,"autoWidth":"auto","render":{"compType":"text","comp":{"text":"{{currentCell}}"}},"align":"left","fixed":"close"},{"title":"description","isCustom":false,"dataIndex":"description","hide":false,"sortable":false,"width":-1,"autoWidth":"auto","render":{"compType":"text","comp":{"text":"{{currentCell}}"}},"align":"left","fixed":"close"}],"size":"small","selection":{"mode":"single"},"pagination":{"showQuickJumper":false,"showSizeChanger":false,"hideOnSinglePage":false,"changeablePageSize":"","pageSize":"10","total":"","pageSizeOptions":"[5, 10, 20, 50]"},"sort":[],"toolbar":{"showRefresh":true,"showDownload":true,"showFilter":true,"columnSetting":true,"searchText":""},"style":{"background":"","border":"","radius":"","cellText":"","selectedRowBackground":"","hoverRowBackground":"","alternateBackground":"","headerBackground":"","headerText":"","toolbarBackground":"","toolbarText":""},"viewModeResizable":false,"onEvent":[],"loading":"","rowColor":{"color":""},"hidden":""},"name":"dataTable"}}},"1":{"layout":{"3d9b2ad5":{"i":"3d9b2ad5","h":38,"w":24,"x":0,"y":0}},"items":{"3d9b2ad5":{"compType":"textArea","comp":{"value":"{{readFile.data}}","disabled":"","label":{"text":"{{path.value}}","tooltip":"","hidden":false,"width":"33","widthUnit":"%","position":"column","align":"left"},"placeholder":"","onEvent":[{"name":"change","handler":{"compType":"executeQuery","comp":{"queryName":"readFile"},"condition":"","slowdown":"debounce","delay":""}}],"readOnly":false,"required":false,"minLength":"","maxLength":"","validationType":"Text","regex":"","customRule":"","formDataKey":"","allowClear":false,"autoHeight":"fixed","style":{"label":"","background":"","border":"","radius":"","text":"","accent":"","validate":""},"hidden":""},"name":"file_content"}}}},"autoHeight":"auto","onEvent":[],"style":{"background":"","border":"","radius":"","headerBackground":"","tabText":"","accent":""},"hidden":""},"name":"a"}}},"containerSize":{"height":112,"width":24},"containerRowCount":0,"hidden":""}},"queries":[{"compType":"restApi","comp":{"bodyType":"none","body":"","httpMethod":"GET","path":"{{root.value}}/{{path.value}}","headers":[{"key":"","value":""}],"params":[{"key":"","value":""}],"bodyFormData":[{"key":"","value":"","type":"text"}]},"id":"eszkvm00xiu5g5kjhejm6c72","name":"readFile","order":1668761618469,"datasourceId":"6376005fc4ff4a064d6f77cc","triggerType":"automatic","onEvent":[],"notification":{"showSuccess":true,"success":{"text":""},"showFail":true,"fail":[{"text":"","condition":""}],"duration":""},"timeout":"","confirmationModal":{"showConfirmationModal":false,"confirmationMessage":""},"periodic":false,"periodicTime":""},{"compType":"restApi","comp":{"bodyType":"text/plain","body":"{{toCsv.value}}","httpMethod":"PUT","path":"{{root.value}}/{{path.value}}","headers":[{"key":"Content-Type","value":"text/plain"},{"key":"","value":""}],"params":[{"key":"","value":""}],"bodyFormData":[{"key":"","value":"","type":"text"}]},"id":"wfr96wp1h98f2n6ichzn6oy8","name":"writeFile","order":1668761663460,"datasourceId":"6376005fc4ff4a064d6f77cc","triggerType":"manual","onEvent":[],"notification":{"showSuccess":true,"success":{"text":""},"showFail":true,"fail":[{"text":"","condition":""}],"duration":""},"timeout":"","confirmationModal":{"showConfirmationModal":false,"confirmationMessage":""},"periodic":false,"periodicTime":""},{"compType":"restApi","comp":{"bodyType":"text/plain","body":"{{atob(uploadFile.value[0])}}","httpMethod":"PUT","path":"{{root.value}}/{{path.value}}","headers":[{"key":"Content-Type","value":"text/plain"},{"key":"","value":""}],"params":[{"key":"","value":""}],"bodyFormData":[{"key":"","value":"","type":"text"}]},"id":"gi3j1d1gjsfr1a8zsinfjet2","name":"uploadFileQuery","order":1668761812782,"datasourceId":"6376005fc4ff4a064d6f77cc","triggerType":"manual","onEvent":[],"notification":{"showSuccess":true,"success":{"text":""},"showFail":true,"fail":[{"text":"","condition":""}],"duration":""},"timeout":"","confirmationModal":{"showConfirmationModal":false,"confirmationMessage":""},"periodic":false,"periodicTime":""},{"compType":"js","comp":{"script":"let data = JSON.parse(JSON.stringify(csvData.value));\nlet index = dataTable.selectedRow[\"_index\"];\nlet entry = JSON.parse(JSON.stringify(tableEditor.data));\ndata[index] = entry;\ncsvData.setValue(data);\ntableEditorModal.closeModal();"},"id":"21b35zc485k5yh2r4xxgz3ky","name":"updateRow","order":1668772460982,"datasourceId":"","triggerType":"manual","onEvent":[],"notification":{"showSuccess":true,"success":{"text":""},"showFail":true,"fail":[{"text":"","condition":""}],"duration":""},"timeout":"","confirmationModal":{"showConfirmationModal":false,"confirmationMessage":""},"periodic":false,"periodicTime":""},{"compType":"js","comp":{"script":"readFile.run()\ncsvData.setValue(parseCsv.value);\n"},"id":"m2teiacli5jq2lxoewvncb46","name":"reloadTable","order":1668779973648,"datasourceId":"","triggerType":"manual","onEvent":[],"notification":{"showSuccess":true,"success":{"text":""},"showFail":true,"fail":[{"text":"","condition":""}],"duration":""},"timeout":"","confirmationModal":{"showConfirmationModal":false,"confirmationMessage":""},"periodic":false,"periodicTime":""}],"tempStates":[{"name":"csvData","order":1668762422938,"value":"{{parseCsv.value}}"}],"transformers":[{"name":"parseCsv","order":1668761840101,"script":"return Papa.parse(file_content.value, {header: true}).data.map(\n  (row, index) => {\n    row[\"_index\"] = index; \n    return row;\n  })"},{"name":"autoSchema","order":1668778721939,"script":"let properties = {};\nfor(let key of Object.keys(dataTable.selectedRow)) {\n  properties[key] = {type: 'string'}\n}\n\nlet schema = {\n  type: 'object',\n  properties: properties\n}\n\nreturn schema"},{"name":"toCsv","order":1668779878623,"script":"return Papa.unparse(csvData.value)"}],"hooks":[{"compType":"urlParams","comp":{},"name":"url"},{"compType":"momentJsLib","comp":{},"name":"moment"},{"compType":"lodashJsLib","comp":{},"name":"_"},{"compType":"utils","comp":{},"name":"utils"},{"compType":"message","comp":{},"name":"message"},{"compType":"localStorage","comp":{},"name":"localStorage"},{"compType":"currentUser","comp":{},"name":"currentUser"},{"compType":"modal","comp":{"visible":"","onEvent":[],"width":"339.816650390625","height":"","autoHeight":"auto","style":{"background":"","border":"","radius":""},"container":{"layout":{"c527cf84":{"i":"c527cf84","h":45,"w":23,"x":0,"y":1}},"items":{"c527cf84":{"compType":"jsonSchemaForm","comp":{"resetAfterSubmit":false,"schema":"{{autoSchema.value}}","uiSchema":"","data":"{{dataTable.selectedRow}}","onEvent":[{"name":"submit","handler":{"compType":"executeQuery","comp":{"queryName":"updateRow"},"condition":"","slowdown":"debounce","delay":""}}],"style":{"background":"","border":"","radius":""},"hidden":""},"name":"tableEditor"}}},"hidden":""},"name":"tableEditorModal"}],"settings":{"maxWidth":{"dropdown":"1920","input":""},"themeId":"default"},"preload":{"libs":["https://cdnjs.cloudflare.com/ajax/libs/PapaParse/5.3.2/papaparse.min.js"],"script":"","css":""}}}