Starting with version 14.02, SocrateCloud allows the users who own Google accounts to export reports to Google Drive.
Necessary Setup
The role associated to the user needs to have the Can Export checkbox selected.
The setup is done at user level.
Step 1 - Access Google Drive API
This is done in the Google Drive Setup window, found in System Admin -> General Rules -> Security.
In order to access the Google Drive API, fill in the Client ID and Client Secret fields with the data obtained from the API console:
The console can be accessed by using the link in the window. You need to be connected to a Google account.
A window will be displayed containing the You don't have any projects! message.
Click on the Create Project button and fill in the Project Name field in the new window, then press on Create.
You might be asked for a telephone number so you can receive a verification code.
Once the project has bee created, go to APIs & auth -> Credentials and press on the CREATE NEW CLIENT ID button.
Select the Installed application and Other checkboxes, then click on the Create Client ID button.
The data generated in the Client ID for web application section must be entered in the Client ID AND Client Secret fields.
Request the authorization code using the link in the window and enter it in the Authorization Code field.
Starting with v15.10, in addition to the standard Record attachment functionality, users will be able to attach files from Google Drive. The following settings are required:
the "Google Apps Setup" described above;
indicating the maximum attachment size for the roles used to connect to SocrateCloud, in the "Role" window.
When attaching the file, the "Google Drive" icon will be available in the "Attachment" window.
After this setup has been completed, the user can export the reports generated in Google Drive using the Save in Google Drive option available when generating the reports.
When exporting tables from SocrateCloud, we recommend you use the xls format.
Step2 - Activate API Services
Go to the API console and click on APIs & auth -> APIs. Select the Off button from the displayed list to activate the Drive API and Drive SDK.
Click on the Authorize button.You need to re-login into the system.