What is the required format of data in the CSV (Comma Separated Value) file in which metadata is to be stored?
• The first row of the CSV file should contain the Field Names as headers separated by comma (,). • The first field should be named as Path. Path field should be followed by other field names separated by comma, in whose names the document properties will be created in the SPS. • The first field named Path is mandatory. This field will not be carried forward as a metadata into SharePoint Server. • The first column of all the rows should contain the path of the file e.g., C:\Documentation\Brochures.doc (or) \\FileServer\Documentation\Brochures.doc. • Each field should be enclosed within double quotes (“”). • The Year, Month and Day parts in a date field is required to be within double quotes and separated by a slash (/) only e.g., “11/23/2000”. • For local/mapped drives used as source, ensure the ‘Path’ field has the corresponding local/mapped drive path (e.g., Z:\Projects\Brochures.doc). • When network shares are used as source, ensure the ‘Path’ field has the corresponding UNC path (e