Alafile out - overwrites target file

[alasql]

Alafile out - overwrites target file

[hamild]

Thank you. I have used the second technique a few times in the past and it works fine so I might just push on with that option for now... regards Donald Hamilton Technology Support Services Tel : [phone] Int : 37-273774 Internet: [email protected] From: Mathias Rangel Wulff <[email protected]> To: AlaSQL/node-red-contrib-alasql <[email protected]> Cc: hamild <[email protected]>, Author <[email protected]> Date: 13/09/2017 13:52 Subject: Re: [AlaSQL/node-red-contrib-alasql] Alafile out - overwrites target file (#12) What you can do is to read the file and merge the results and rewrite to the file OR Add data to a table in mem (a normal alasql table) and export to file every time you update it. Technically you risk to lose data if node is turned off at the wrong time. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread. Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU

[mathiasrw]

AlaSQL can not add to a file - only replace it

[hamild]

So ... somehow I need to collect my records into a single "unit" before invoking Alafile?
Or maybe I should used AlaSQL and write an SQL procedure to save all the records to the spreadsheet?
I tried saving to MongoDB ... which works but I am having trauma getting the data back out to merge with operational data for each machine. The idea is that eventually, we would put the operational data on a map... I guess I could simply get the geo coordinates for each operational record but that seems a little wasteful - I thought it would be better to have a reference source (Inventory) with the positional data..

[mathiasrw]

What you can do is to read the file and merge the results and rewrite to the file. This kind of sucks.

I suggest you add data to a table in mem (a normal alasql table) and export to file every time you update it.

Please note any data im mem will be lost when node is restarted