1. Configuring Applications
  2. Details and Examples: Property File Fields Data Set

Details and Examples: Property File Fields Data Set

Daily Extract supports export of the contents of the file properties (images, files in pdf-format.) available in the application by the end of the extraction period.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.

Property File Fields are exported in the Daily Extract file for which 'Property File Fields' is selected as the entity. The only property file field available in Oracle Field Service is 'property_file'.

Note: You can't edit the field name for this entity.

This table provides the label and description for those fields that can be configured:

Field Label Description

File Property

property_file.property_file

If configured file properties available in the system by the end of the extraction period can be stored.

  • Changes: It is possible to configure specific set of file properties for the Property File Fields data set. Only those properties that are configured on the Daily extract screen in Manage will be extracted by the end of extraction period. If the File property field is configured on the screen, all product file fields and custom file properties available in the system will be automatically added to the daily extraction regardless of configurations that are done for the Property File Fields data set.

  • Custom Properties: Any custom file property (except inventory file properties) can be configured and extracted for the Property File Fields data set.

File properties are exported in their original format or added to the archive, if archives are used. File properties are exported under names created according to the following pattern:

companyName_propertyID_entityID_filename

where:

  • companyName is the name of the company in Oracle Field Service

  • propertyID is the numeric ID of the file property in Oracle Field Service

  • entityID is the numeric ID of the entity (activity, inventory, resource, support request) to which the file property is attached. The 'entityID' is obtained from the corresponding tables in the database.

  • filename is the name of the file attached to the file property

For example, image file 06082013036.png attached to file property with ID 563 being a property of activity 23244105 in company Sunrise will be exported under the following name:

sunrise_563_23244105_06082013036.png