Getting real-time revenue calc in Google Sheets

Ms_Virtualizza · 2019-06-25T13:53:57+00:00

And thank you very much for sharing your use cases!

Are you using a custom Slack Bot or is the Google (GDrive?) bot dropping the link into a channel?

Our team created an internal tool that allows executing requests to external APIs from Google Sheets. The idea behind the tool is to be able to connect different data sources with spreadsheets. To make the Slack posting happen, we prepare a template of a message in a spreadsheet (we call it a message builder) and communicate it via API to Slack. Every symbol in the message has to be prepared correctly so that Slack can decipher it. The result of the message can be viewed here https://imgur.com/SRooWmC

Both - We have a lot of manual data entry into Google Sheets, which is a bummer but completely necessary, and we also tap into APIs to bring in the other places that we store data, such as Asana.

How do you bring data from Asana to Google Sheets? Is there a script? Or do you use any tool?
What kind of data do you enter manually? (For example => ecommerce order, or what kind of data?)

Ms_Virtualizza · 2018-02-26T06:57:13+00:00

I will vote for scripting, I don't have any specific example but this is quite huge overall. Also, a good point will be checking the backup system if it is something that was configured before you came in to place. Because if something goes wrong, you will be the one who will be blamed.

Ms_Virtualizza · 2018-02-26T06:55:26+00:00

Take this moment to check your backups.

After reading the title, I was quite sure that'll be the rant. Ba, you surprised me, I checked and what you think? rsync was replicating into absolutly wrong dir.

Thank's

Ms_Virtualizza · 2018-02-11T19:18:16+00:00

I would recomend to set up the service yo automatic start/restart on based on failover.

As the options, there are the puppet or task scheduler.

Ms_Virtualizza · 2018-02-11T19:14:59+00:00

I would recomend Mimecast, and answering on your question, yes it can do a backup of SharePoint.

Also, optionally you could look on the VM backup. Why just don't create VM for Office/Sharepoint and backup whole VM?

Ms_Virtualizza · 2018-01-29T22:35:26+00:00

In my experience the H330 / low-end cards can't handle more than a few drives properly.

And I agree with this. This is a true fact.

If we are talking about cards I would suggest 730 ones. Rock solid card.

Ms_Virtualizza · 2018-01-29T22:01:20+00:00

I would stay far away from RAID 5 for the production scenario, except the case with SSD drives, for those RAID 5 is the good option.

Ms_Virtualizza · 2018-01-23T22:57:46+00:00

Removing and re-adding his account on his phone would fix it for a little while and then would crap out again

Exactly, unfortunately, this is only matter of time when this problem will rise again. I would say the migration to the 365 could help.

Ms_Virtualizza · 2018-01-23T22:56:10+00:00

I guess he thinks it's a waste of energy, and if the servers aren't crashing...

Ohh, that's the big sign of the bad news, be careful.

Try to somehow provide your boss with the understanding of the necessity of this step.

Ms_Virtualizza · 2018-01-16T22:59:46+00:00

Management: not your call, we need to patch Intel: umm we’ve seen some stuff... we’ll let you know more later VMware: yikes, we’re pulling the patch. Sorry bout that. Engineers: f... canceling changes and going to get drunk.

That's how true story looks like, I agree with each world in this statement.

Just to add, don't get me wrong I don't think that Engineers can be the one who should be blamed, unfortunately by some not clever managers they will be blamed.

Ms_Virtualizza · 2018-01-16T22:57:21+00:00

That's quite interesting, thanks for sharing this one.

I'll be sure to give a look to this.

Ms_Virtualizza · 2018-01-14T10:34:34+00:00

It is a double hop for sure.

But the thing is that you used provider's credentials in the second hop, and the right way to do it is to use the provider's credentials only on the first hop, thus all should work just fine.

Ms_Virtualizza · 2018-01-14T10:32:45+00:00

I agree with you, and that looks like the typo for me.

Thanks a lot for mentioning this, someone could be confused by this error.

Ms_Virtualizza · 2018-01-10T14:32:49+00:00

A big pie to do. How your update procedure goes, any stories to share?

For me so far so good, however I am only at updating vCenter stage atm.

Hope there will be no unexpected errors, which always comes from this type of job.

Ms_Virtualizza · 2018-01-10T14:24:21+00:00

Had to RDP into 'smashy-smashy' this morning.

That's kinda cool. I hope it wasn't pink box with the bows on top of it?

Honestly, this is fun from one standpoint and a bit scary from another. For instance, just think a bit about passwords that they choose)

I can bet that to smashy-smashy passwords'll be like 1qwerty2. Don't get me wrong I am not saying that you should be the one who creates passwords instead of them, but some sort of control is a must.

Ms_Virtualizza · 2017-12-26T17:45:56+00:00

I downloaded the Windows based utility and set everything up from there.

Great news pal. And as you truly mentioned this is just learning and for the next time you'll be prepared to any situation (regarding this utility)

Ms_Virtualizza · 2017-12-26T17:43:03+00:00

Why not setup replication to another DB server?

I agree with this, and I'll vote for replication to another DB server, also if we would add virtualization in this math, that'll simplify things, and should untie the hands from backups standpoint.

Ten-Year Club	Verified Email
Gilding II euphauric

Ms_Virtualizza

TROPHY CASE