...
On This Page
| Table of Contents |
|---|
Overview
Link detection scans files and identifies any links in the files. This option is enabled when setting can be turned on when defining the behaviors for the job during job creation. It will run for both simulation and transfer jobs. The Job reports will display link information when available for the job.
...
| Info |
|---|
Link detection only scans the latest version of each file and reports the links detected. It does not scan previous versions. |
Supported File Types
Link detection currently only identifies links in files with the following extensions:
DOCX (available in Microsoft Word 2007 and newer)
PPTX (available in Microsoft PowerPoint 2007 and newer)
XLSX (available in Microsoft Excel 2007 and newer).
Supported Links
Hyperlinks: These are links to websites or documents. Hyperlinks can be http/https/ftp/ftps URLs or links to files.
In Microsoft Word, Excel, and PowerPoint files, these links are created using the Link option on the Insert tab or by right-clicking on selected text/cell and selecting Link from the shortcut menu.References to other Excel spreadsheets: In Microsoft Excel files, these are links to cells in other Microsoft Excel files. These links are made by creating a formula that references a cell or range of cells in another Microsoft Excel file. The cells are formatted similar to the following examples:
=[AnotherSpreadsheet.xlsx]SheetName!A1='C:\Absolute\Path\To\[AnotherSpreadsheet.xlsx]SheetName'!B1
Links documents/object: In Microsoft PowerPoint files, this is content that has been imported into the presentation. This content is imported using the Object option on the Insert tab or using the Paste Special option to insert a link to a Microsoft Word Document Object.
Unsupported links
Unformatted links: DryvIQ will not count unformatted links (URLs that are added as plain text in the document).
IncludeText fields: In Microsoft Word files, link detection does not support links added through IncludeText fields using the Insert Quick Parts option.
| Info |
|---|
Job filter exclusions take precedence over Link Detection. Therefore, if a job filter exclusion is set to ignore DOCX, PPTX, or XLSX files, Link Detection will also ignore these files. |
Enabling Link Detection in the UI
Link Detection is available as one of the Behavior options when creating a job. This feature is disabled by default. Select the Allow link detection on supported files toggle to enable the feature.
...
Viewing Link Information
When enabled, link detection will identify the links in files and make the information available for review on the individual Job reports and the roll-up reports. Information is available on the Content Insights, Items, and Log pages.
| Info |
|---|
It is important to note that link counts for spreadsheets will not always match depending on how the link was added to a cell. If the links are added to multiple cells at the same time, DryvIQ reads the link as one link shared across cells. In this instance, all shared links count as one link. If the links are added to multiple cells separately (one cell at a time), DryvIQ counts each cell as separate. In this instance, each link is counted individually. |
Content Insights
The Content insights page will include the link detection results. The information can be found in the Number of links detected chart (under the Content analysis). This chart lists the files with links and the number of links detected in each file.
...
Field | Description |
|---|---|
source_id | The ID assigned to the file on the source platform |
source_name | The filename on the source platform. The source and destination file names may not match if DryvIQ needed to sanitize the the filename due to character or length restrictions for the destination platform. |
source_path | The path where the file is located on the source platform. |
destination_id | The ID assigned to the file on the destination platform |
destination_name | The filename on the destination platform. The source and destination file names may not match if DryvIQ needed to sanitize the the filename due to character or length restrictions for the destination platform. |
destination_path | The path where the file is located on the destination platform. |
link | The URL for the link detected. |
count | The number of times the link was found in the file. Link counts for spreadsheets will not always match depending on how the link was added to a cell. If the links are added to multiple cells at the same time, DryvIQ reads the link as one link shared across cells. In this instance, all shared links count as one link. If the links are added to multiple cells separately (one cell at a time), DryvIQ counts each cell as separate. In this instance, each link is counted individually. |
Items
In addition, the Items page has additional options to allow you to view link information. You can filter the Items page to show just items that have links by selecting Feature as the filter and then selecting Files with Links as the value for the filter. The page will display only files that have links.
...
You can also set a column on the Items page to display the number of links detected in each file. Select the arrow next to the column heading and select Number of links from the list that appears. The selected column will now display the link count for each file. A dash (-) will appear in this column if no links were found in the file.
...
Log
An entry will be added to the audit log for each file scanned for link detection. The activity will be flagged as “Informational activity,” and the details for the file will read, “The ‘Link detection’ extension analyzed the content of the file.”
...
REST API
Enabling Link Detection Through the API
When creating the job through the REST API, you can enable Link Detection in the transfer block by sending “link_detection” set to “true.”
...
POST {{url}}v1/jobs
...
| Code Block |
|---|
{
"name":"Job Name",
"kind": "transfer",
"transfer": {
"transfer_type": "copy",
"link_detection": "true",
"source": {
"connection": { "id": "source_connection_id" },
"target": {
"path": "source_connection_path"
}
},
"destination": {
"connection": { "id": "destination_connection_id" },
"target": {
"path": "destination_connection_path"
}
}
}
} |
Export Link Detection Report for a Specific Job
The code below will export the link detection report for a specified job (if the job has any embedded links). The report will be exported to a CSV file.
| Code Block |
|---|
GET {{url}}v1/transfers/{job}/links.csv |
You can specify multiple jobs by separating the job IDs with commas.
| Code Block |
|---|
GET {{url}}v1/transfers/jobs=jobID1, JobID2, JobID3/links.csv |
Export Link Detection Report for All Jobs
The code below exports the link detection report for all jobs (if the jobs has any embedded links). The report will be exported to a CSV file.
| Code Block |
|---|
GET {{url}}v1/transfers/links.csv |