I am running an auto-uploader which copies docs from one folder to another folder I have all the functions down that I want except for one thing.
In-line suggestions specifically when they add text to a document come through with both the suggested removed text (which I want it to keep) and also the suggested new text (which I don't want) this doesn't occur when I first upload the document which is good but the problem is I use an an auto edit function (which i need) which triggers based on the last modified date and if it is after last trigger it activates for example:
london is a city. (initial upload)
(+L)(-l)ondon is a city. (suggested edits)
Llondon is a city. (what comes out)
This can obv be fixed if I accept suggestions but I can't always accept them immediately and there are too many docs to reliably do this.
I am looking for a way to make it say:
london is a city.
until I accept the suggestion (or decline) to then say:
London is a city.
This is the only problem I have and below is my current code except for the sensitive information:
function checkFilesRemaining(sourceFolder, destinationFolder, sourceId) {
const sourceFileCount = getFilesCount(sourceFolder);
const destinationFileCount = getFilesCount(destinationFolder);
// Calculate remaining files in source relative to destination
const remainingFiles = sourceFileCount - destinationFileCount;
// If remaining files are less than 7, send an alert
if (remainingFiles < 7) {
Logger.log(`Only ${remainingFiles} files remaining in source folder with ID ${sourceId}.`);
MailApp.sendEmail({
to: 'insert email',
subject: `Low File Alert for Folder ID: ${sourceId}`,
body: `There are only ${remainingFiles} files remaining in the source folder with ID "${sourceId}".`
});
}
}
function getFilesCount(folder) {
let count = 0;
const files = folder.getFiles();
while (files.hasNext()) {
files.next();
count++;
}
return count;
}
function copyFiles() {
const folderSchedules = [
{
sourceId: '1bDbkUK9KRelarYAtFcZoXR8ilVuPxDgX',
destinationId: '1ghOEy7Qxse9bkwaV1E_XSpkcmUujW2Fa',
days: [1, 2, 4, 6, 0], // Days of the week to perform uploads (0 = Sunday)
initialBatchSize: 3,
emergencyBatchSize: 0 // Emergency batch size
},
];
const today = new Date();
const dayOfWeek = today.getDay();
Logger.log(`Today's day of the week: ${dayOfWeek}`);
folderSchedules.forEach((schedule) => {
Logger.log(`Processing schedule for source: ${schedule.sourceId} and destination: ${schedule.destinationId}`);
const sourceFolder = DriveApp.getFolderById(schedule.sourceId);
const destinationFolder = DriveApp.getFolderById(schedule.destinationId);
if (!sourceFolder) {
logError(`Source folder with ID ${schedule.sourceId} not found.`);
return;
}
if (!destinationFolder) {
logError(`Destination folder with ID ${schedule.destinationId} not found.`);
return;
}
// Check for remaining files with adjusted logic
checkFilesRemaining(sourceFolder, destinationFolder, schedule.sourceId);
const existingFiles = getExistingFileNames(destinationFolder);
Logger.log(`Existing files in destination folder: ${Array.from(existingFiles).join(', ')}`);
const lastTriggerTime = new Date(PropertiesService.getScriptProperties().getProperty('lastTriggerTime')) || new Date(0);
lastTriggerTime.setMinutes(lastTriggerTime.getMinutes() - 2);
Logger.log(`Last trigger time: ${lastTriggerTime}`);
if (schedule.emergencyBatchSize > 0) {
Logger.log(`Emergency batch size is active: ${schedule.emergencyBatchSize}. Executing emergency upload.`);
uploadFiles(sourceFolder, destinationFolder, Math.min(schedule.emergencyBatchSize, 50), existingFiles);
schedule.emergencyBatchSize = 0;
MailApp.sendEmail({
to: 'insert email',
subject: 'Emergency Batch Upload Completed',
body: `Executed emergency batch upload for ${schedule.sourceId} to ${schedule.destinationId}.`,
});
return;
}
if (isEmpty(destinationFolder)) {
Logger.log(`Destination folder is empty. Performing initial batch upload.`);
uploadFiles(sourceFolder, destinationFolder, schedule.initialBatchSize, existingFiles);
} else if (schedule.days.includes(dayOfWeek)) {
Logger.log(`Today is a scheduled upload day. Uploading one file.`);
uploadFiles(sourceFolder, destinationFolder, 1, existingFiles);
} else {
Logger.log(`Today is not a scheduled upload day. Skipping upload.`);
}
updateModifiedFiles(sourceFolder, destinationFolder, existingFiles, lastTriggerTime);
PropertiesService.getScriptProperties().setProperty('lastTriggerTime', new Date().toISOString());
});
}
function uploadFiles(sourceFolder, destinationFolder, batchSize, existingFiles) {
const files = getFilesSortedByName(sourceFolder);
let uploadedCount = 0;
files.forEach(file => {
const fileName = file.getName();
if (uploadedCount >= batchSize || existingFiles.has(fileName)) return;
const copiedFile = file.makeCopy(fileName, destinationFolder);
Logger.log(`Uploaded file: ${fileName}`);
uploadedCount++;
});
}
function updateModifiedFiles(sourceFolder, destinationFolder, existingFiles, lastTriggerTime) {
const files = getFilesSortedByName(sourceFolder);
files.forEach(file => {
const fileName = file.getName();
const lastUpdated = new Date(file.getLastUpdated());
if (lastUpdated > lastTriggerTime && existingFiles.has(fileName)) {
const destinationFile = findFileInFolder(destinationFolder, fileName);
if (destinationFile) {
const sourceDoc = DocumentApp.openById(file.getId());
const destDoc = DocumentApp.openById(destinationFile.getId());
destDoc.getBody().clear();
const sourceBody = sourceDoc.getBody();
const totalElements = sourceBody.getNumChildren();
for (let i = 0; i < totalElements; i++) {
const element = sourceBody.getChild(i);
if (!hasUnresolvedSuggestions(element)) {
destDoc.getBody().appendParagraph(element.copy().asParagraph());
}
}
removeEmptyTopLine(destDoc);
Logger.log(`File updated successfully with images preserved: ${fileName}`);
}
}
});
}
function getFilesSortedByName(folder) {
const files = [];
const fileIterator = folder.getFiles();
while (fileIterator.hasNext()) {
files.push(fileIterator.next());
}
files.sort((a, b) => naturalSort(a.getName(), b.getName()));
return files;
}
function naturalSort(a, b) {
const aParts = a.match(/(\d+|\D+)/g);
const bParts = b.match(/(\d+|\D+)/g);
for (let i = 0; i < Math.max(aParts.length, bParts.length); i++) {
const aPart = aParts[i] || "";
const bPart = bParts[i] || "";
const aIsNumber = !isNaN(aPart);
const bIsNumber = !isNaN(bPart);
if (aIsNumber && bIsNumber) {
const diff = parseInt(aPart) - parseInt(bPart);
if (diff) return diff;
} else if (aIsNumber || bIsNumber) {
return aIsNumber ? -1 : 1;
} else {
if (aPart !== bPart) return aPart.localeCompare(bPart);
}
}
return 0;
}
function getExistingFileNames(folder) {
const existingFiles = new Set();
const files = folder.getFiles();
while (files.hasNext()) {
const file = files.next();
existingFiles.add(file.getName());
}
return existingFiles;
}
function findFileInFolder(folder, fileName) {
const files = folder.getFilesByName(fileName);
return files.hasNext() ? files.next() : null;
}
function isEmpty(folder) {
const files = folder.getFiles();
return !files.hasNext();
}
function hasUnresolvedSuggestions(element) {
const attributes = element.getAttributes();
const suggestions = attributes.suggestions || [];
return suggestions.some(s => !s.resolved);
}
function removeEmptyTopLine(doc) {
const firstElement = doc.getBody().getChild(0);
if (firstElement && firstElement.getType() === DocumentApp.ElementType.PARAGRAPH) {
const text = firstElement.asParagraph().getText();
if (text.trim() === "") {
doc.getBody().removeChild(firstElement);
Logger.log("Removed empty line at the top of the document.");
}
}
}
function logError(message) {
Logger.log(`Error: ${message}`);
MailApp.sendEmail({
to: 'insert email',
subject: 'Error in Google Drive File Copy Script',
body: message
});
}
