-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathorganizeGooglePhotosInDrive.gs
More file actions
74 lines (59 loc) · 1.98 KB
/
organizeGooglePhotosInDrive.gs
File metadata and controls
74 lines (59 loc) · 1.98 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
var s_props = PropertiesService.getScriptProperties();
var photos_folder_id = s_props.getProperty('photos_folder_id') // You can do this other ways, but I prefer this.
function manageRootFiles() {
var root_files = DriveApp.getFolderById(photos_folder_id).getFiles();
while (root_files.hasNext()) {
var file = root_files.next();
var created_on_data = getCreatedOnData(file.getId());
var dest_folder_id = createFolderStructureByDate(created_on_data);
moveFileToAnotherFolder(file.getId(),dest_folder_id);
}
}
function getCreatedOnData(fileId) {
var created_on_timestamp = DriveApp.getFileById(fileId).getDateCreated();
var date = new Date(created_on_timestamp);
var months_enum = {
0: 'JAN',
1: 'FEB',
2: 'MAR',
3: 'APR',
4: 'MAY',
5: 'JUN',
6: 'JUL',
7: 'AUG',
8: 'SEP',
9: 'OCT',
10: 'NOV',
11: 'DEC',
};
var date_data = {
'year': date.getYear(),
'month': months_enum[date.getMonth()],
'date': date.getDate()
}
return date_data;
}
function createFolderStructureByDate(date_data) {
var date = date_data.date;
var month = date_data.month;
var year = date_data.year;
var temp_folder_id = photos_folder_id;
for (key in date_data) {
temp_folder_id = ensureFolderExists(date_data[key],temp_folder_id);
}
return temp_folder_id;
}
// Move file to another Google Drive Folder
function moveFileToAnotherFolder(fileId, targetFolderId) {
var photos_folder = DriveApp.getFolderById(photos_folder_id);
var dest_folder = DriveApp.getFolderById(targetFolderId);
var file = DriveApp.getFileById(fileId);
dest_folder.addFile(file);
photos_folder.removeFile(file)
}
function ensureFolderExists(sub_folder_name, parent_folder_id) {
var matchingChildren = DriveApp.getFolderById(parent_folder_id).getFoldersByName(sub_folder_name);
if (matchingChildren.hasNext()) {
return matchingChildren.next().getId();
} else {return DriveApp.getFolderById(parent_folder_id).createFolder(sub_folder_name).getId()};
}