Just quick question to see if anyone has done anything along these lines.
Know we have import export database tools but think we should come up with a good way to ‘push’ an update into a live system Covering products and automation and everything excluding sales.
Although as a reseller and multi site manager probably also users and most entities.
If not I will look into building some form of script for a direct SQL import.
It needs to be complete is no issues like the display state formats being missed at one point a while back.
Although guess this is likely to be site specific on what to I write and what to miss as it clearly won’t be all but sales.
We are undoubtably going to see from different perspectives but my consern is overwriting in intarity.
My stock setup might be tweaked and improved and have rules etc renamed and reorganised making import/export hard as its maintaining multiple systems.
I am thinking broader as a reseller type perspective that an update is cleaner as something more like a restore backup for all automation etc and not a patch on a specific feature.
Also with a complex setup ensuring selected exports will carry full update obviously becomes more tricky. For making config tasks to ‘install’ a setup/Configeration it’s ideal but as an update took it seems clumsy - unless I’ve missed a topic…
I can most likely work out scripts to do it given some time to play around but was mainly looking to see if anyone else has attempted or made a start on anything similar. Maybe even drum up enough interest that emre might take interest
Also great for self development with testing machine at home.
Take a backup, restore at home, make updates to automation etc, backup take back in and import all updates without overriding sales data for example.
I was working on something similar. Currently I’ve automated backups of user database once a week located on system, and I access system remotely(if remote access was available) to do updates. Once finished, I leave a note for them noting all changes that have been made and then that’s it.
Most clients I deal with prefer if they can do updates on the go without downtime on main system during operating hours, in which i usually recommend to them to have a mini pc or office laptop or something that he can install samba on, and configure it to samba database located on main system, then they can remote into that at anytime to make desired changes.
The only thing that I would really be interested in seeing been done, is having some sort of script or pushed update feature. Similar to almost any application including windows software checks for updates, if found notifies admin an update is found with option to cancel or download and install button. I think as more updates come out, having to manually download them, then reinstall them on each system(from Reseller Perspective) becomes a daunting and time consuming task.
That probably could be doable using scripts to a MySQL database where you could set version numbers available to update.
Get restore could maybe be execute command or script to download fine or use something like drop box folder and use your update web database for file name.
Did we have a backup/restore action already?
But from sounds of it you manually doing update changes?
Or are you using backup/restore out of hours?
I usually do all changes out of working hours. It is much safer as it means the system is not getting used and therefore if changes are made, it has a higher chance of not breaking anything.
Module updates such as adding actions, rules, auto commands or doing things that require internal attention to flow, that I usually do tests on my system, once all tests are done and it’s ready to deploy, I use the export feature to link all the actions and rules, then upload that file onto client system, use import feature, and test to ensure its all working and that’s it!
But even then, it’s always done outside of working hours.
