CLI tool to transfer system data between environments

Updated version 0.3, built for Sugar 7.9 and above

Wow, thank you Enrico Simonetti.

I thought of writing the same feature last week but glad to know it's already available. Very useful for quick deployment.

Thanks hats,

Glad to see you find SystemData useful! Let me know how it goes!

Hi Enrico Simonetti,

I used this tool multiple times in my dev environment and recently used it for production deployment as well. Worked very well. Couple of issues so far related to Users and Reports import.

1. While importing Users, it threw warning that SNIPuser already exists. I believe it should update the user if already exists. Please correct me if I understood it wrongly.

2. While importing Reports, it threw error that report could not be saved due to missing teams. But I had already imported teams, users and their memberships in proper order.

Please let me know if you have some idea on this, meanwhile I will also dig into it.

Thank you once again as it saves a lot of time and even an admin can do this without getting into much detail.

Regards.

Hats

Hi hats,

That's great!

Are you actually using the tool to export data from a system and then into another system without manual intervention? Or are you manipulating the JSON files and/or the database?

Quick pointers to help you investigate:

1. Does the SNIPuser's id on the database match the id on the json file? Maybe you have duplicate usernames with different ids? Records are only updated by their id with this tool. What is the message you see?
2. Maybe an exported Report includes a Team that is not present on your team export? Have a look

Cheers

Thanks for the quick response Enrico Simonetti.

Yes, I am using this tool to import data from UAT system to Production system without any manual intervention with standard users, teams and roles already present on the production system.

1. Regarding duplicate user error, you are right. Production system already had this user entry with different ID and hence got an error.

2. I exported these reports from UAT and imported into production with all the required teams, users and roles imported earlier with success. I will have another look into this.

Just thought of sharing it here. Thank you.

Regards.

Hats

Hi, 

Thanks for the tool. It seems to work great in most cases but I've started getting issues with posting roles. Seems to be getting a forbidden error and I cant work out why its happening. Any ideas?

Hi sonesay inthavong,

Thanks for reaching out and for the great comments about the tool.

I would highly recommend to remove the left hand side of the screenshot as it might contain on the payload sensitive information.

Have a look if it might be a token problem. There might be a glitch on the custom code that does not retry automatically if the token failed, by regenerating a new token.

You could also try with the same payload via command line and see if that works successfully or not.

Let me know how that goes, and please do create an issue on the repository if it is indeed a bug, and feel free to provide contributions as well!

Thanks!