How to extract file metadata

The Scheduler Metadata section enables to configure extraction of metadata of the uploaded files. The template is selected and the tags in the template are mapped to the parts of sample file name / folder name in the uploaded file path for extraction. Once extracted, you can also set rules for the extracted tags.

To extract file metadata, follow these steps:

1.In theData Scheduler screen, go to the Scheduler Metadata tab. The Scheduler Metadata tab appears as shown in the figure:

FIGURE: Scheduler Metadata Tab

2.Click to enable Enable Scheduler Metadata option. The following fields appear:

3.In the Template Master field, select the template. Tags from the selected template appears under TagName

4.In theDelimiter field, select an appropriate delimiter to split the file metadata.

In the Template Master field, select the template. Tags from the selected template appears under TagName

FIGURE: View Edit Scheduler Screen Activated Task Tab

5.In theSample Filename field, type a sample file name. Using the sample filename the metadata are tagged. For example, in the following sample filename, the parts of the file name are mapped to the tags as follows:

Sample filename: E6345-2022-1.pdf.

File MetadataTags mapped
E6345BatchName
pdfDataType

In the TagName field, tags from the selected templates appears. Select a tag, mention where to extract values for the tag, map with the sample filename metadata.

1.1 Extract Product Name

To extract Product Name, follow these steps:

1.In the TagName field, select ProductName. Product Name / Method Nameis extracted from the folder name of the Source Path that is mentioned in the File Settings tab.

2.For the ProductName tag, In the Extract From field, click to select Folder option to extract name from the folde

3.In the Metadata field, type 0 to extract the name from the parent folder.

To extract the product name / method name from the source path, type 0 to extract the parent folder name, type -1 to extract the grandparent folder name. And to get sub folder name, mention 1, 2, 3 etc.

For example, in the source path "D:\Anwar\01_Current working\Schedule path\BRABENDER-LABSOLDATA\Analysis"

If you specify 0 inthe Metadata field, Analysis is extracted.

If you specify 1 the Metadata field, BRABENDER-LABSOLDATA is extracted.

1.2 Extract BatchNumber

To extract BatchNumber, follow these steps:

1.In the TagName field, select BatchNumber.

2.For the BatchNumber tag, In the Extract From field, click to select Filenameoption.

3.In theMetadata field, click , select E6345 and then click Submit as shown in the figure:

FIGURE: Extracting BatchNumber

1.3 Extract DataType

To extract BatchNumber, follow these steps:

1.In the TagName field, select DataType.

2.In the TagName field, select DataType.

1.In the TagName field, select DataType.

3.In theMetadata field, click , select E6345 and then click Submit as shown in the figure:

FIGURE: Extracting DataType

1.4 Set rules to the extracted metadata

You can set rules to the extracted metadata. For example, for the DataType tag, the .vsu and .pdf values are extracted. Let's set following rules to the DataType tag.

  • If the extracted file extension is .vsu then the metadata should be rawdata.
  • If the extracted file extension is .pdf then the meta data should bereport.

1.In the Scheduler Metadata tab, under Rule, in the rulename field, select the tag for which you want to set the rule

2.In the TagName field, select the tag to set the rule.

3.In the Relational Operator field select the operator.

4.In the Field Value field, type the file extension that is extracted. For example, .vsu

5.In the Metadata field, type rawdata and then click Add as shown in the figure:

FIGURE: Setting Rule for the Extracted Metadatae

Same way, you can add rule for the .pdf extension. Once added, the added rules appears as shown in the figure:

FIGURE: Rules Set

6.Activate the scheduler.

7.In the

Server Data

tab, select the folder and select the file uploaded. In the Tags & Parsed Data tab you can see the metadata of the file as set in the rule section.

8.If the extracted file extension is.pdf, then the value appears as Report as shown in the figure:

FIGURE: Data Explorer - Tags & Parsed Data Tab Rule Applied t

  • Here the Product_Name is extracted from the parent folder name.
  • Batch_Number is extracted from the sample file name
  • The Data_Type is extracted from the filename extension.

1.5 Rule applied:

  • If the extracted file extension is .vsu then the metadata is rawdata.
  • If the extracted file extension is .pdf then the meta data is report.

Previous article

edit schedules

Next article

Download Scheduler

Still need help?

Our team of experts are available and just a click away

Submit Ticket