Page MenuHomePhabricator

Set up / identify Salesforce database for takedown tools
Open, Stalled, NormalPublic13 Story Points

Description

For the CP and DMCA takedown tools (T167187) we want to log takedown requests in an WMF Salesforce database (in addition to submitting the data to the appropriate third-party organizations.)

This data is currently being stored to Sugar CRM. No changes to the database structure have been requested, so the schema should be identical to the old tool.

If SuSa already has a Salesforce DB for this, then we should use it. If not, then either SuSa needs to create it or give @dbarratt credentials to create one.

@Jalexander will probably know best, so initiatively assigning to him.

Event Timeline

TBolliger created this task.Jul 3 2017, 3:09 PM
Jalexander changed the task status from Open to Stalled.Jul 3 2017, 5:26 PM

This is going to be slightly stalled for a short time, the salesforce instance is still having it's final setup because we've been transferring over all of our data from Sugar. It should be done and available to be dealt with later this week. I'll see if I can scrounge up documentation to help in the meanwhile too :)

Should we write to Sugar until the Salesforce DB is ready?

Should we write to Sugar until the Salesforce DB is ready?

For testing purposes, I'd say just log it to a local file or something. There's other parts to be built so I don't believe this is a blocker for the tool. @dbaratt can correct me if I'm wrong here.

@Niharika correct, not a blocker. Just wanted to get the ball rolling on it. :) The data is being stored in a local SQL anyways.

TBolliger renamed this task from Set up / identicy Salesforce database for takedown tools to Set up / identify Salesforce database for takedown tools.Jul 5 2017, 11:28 PM

@Jalexander: Any update on this?

James will get David credentials (likely shared credentials) for Salesforce to create the database.

Restricted Application added a subscriber: MGChecker. · View Herald TranscriptMar 22 2018, 3:08 AM
TBolliger removed Jalexander as the assignee of this task.Jan 30 2019, 9:34 PM
TBolliger removed a project: Anti-Harassment.
jrbs added a subscriber: jrbs.Mar 15 2019, 9:50 PM

Is this still stalled? Salesforce is up and running now.

Is this still stalled? Salesforce is up and running now.

I think the idea was to have the data posted to Salesforce when entered into the takedown tools. Is that still needed / wanted?

jrbs added a subscriber: JanWMF.Apr 2 2019, 8:39 PM

Is this still stalled? Salesforce is up and running now.

I think the idea was to have the data posted to Salesforce when entered into the takedown tools. Is that still needed / wanted?

I believe so ... I'm not super familiar with what the plans were. Maybe @JanWMF has an idea?

Thank you both. Yes, this is still desirable because both Legal and Trust and Safety will continue to use SalesForce for such purposes as we go into the organization's medium-term plan. So the use case remains stable and its volume is growing.