# Manage Data in XML

### Import Certification Body Data from XML file <a href="#adding-certification-data-from-excel-file" id="adding-certification-data-from-excel-file"></a>

{% hint style="info" %}
**NOTE:** Adding Certification Body via XML is recommended for bulk data import. If you want to update a single record or records not more than 10 certificates we recommend you use the Manual Data Entry. \
\
**Prerequisites:**

* Clean and format data according to the IAF CertSearch data structure. &#x20;
  {% endhint %}

**To update the Certification Body via Excel**

1. In the Certification Body Excel XML file, enter the data into their corresponding fields.

<details>

<summary>CB Data XML Fields</summary>

```
<?xml version="1.0" encoding="UTF-8"?>
<ab_cbs>
	<certification_body>
		<certification_body_identity_number>cbin-01</certification_body_identity_number>
		<certification_body_name>Bear Certify</certification_body_name>
		<certification_body_acronym>BC</certification_body_acronym>
		<website></website>
		<country>Philippines</country>
		<description></description>
		<accreditation_status>Active</accreditation_status>
		<public_email_address></public_email_address>
		<public_phone_number></public_phone_number>
		<public_fax_number></public_fax_number>
		<key_locations>
			<key_location>
				<key_location_id>A</key_location_id>
				<office_type>Branch</office_type>
				<street>Orange</street>
				<city>New York</city>
				<state></state>
				<country>United States</country>
				<zip_code></zip_code>
			</key_location>
		</key_locations>
		<standard_and_schemes>
			<standard_and_scheme>
				<scope_type>Management System</scope_type>
				<scheme_name>Quality Management Systems Scheme</scheme_name>
				<standard_code>ISO 9001</standard_code>
				<first_issue_date></first_issue_date>
				<issue_date>20230101</issue_date>
				<expiry_date></expiry_date>
				<standard_status></standard_status>
				<key_locations>A</key_locations>
			</standard_and_scheme>
		</standard_and_schemes>
		<technical_sectors>
			<technical_sector>
				<scope_type>Management System</scope_type>
				<scheme_name>Quality Management Systems Scheme</scheme_name>
				<standard_code>ISO 9001</standard_code>
				<sector_title>TickIT Plus</sector_title>
				<sector_code>IAF33</sector_code>
				<sector_accreditation_status>Active</sector_accreditation_status>
				<suspended_withdrawn_date><suspended_withdrawn_date/>
				<full_limited></full_limited>
				<extent_of_scope><extent_of_scope/>
			</technical_sector>
		</technical_sectors>
		<certification_body_countries>
			<certification_body_country>
				<country></country>
				<economy_accreditation_status></economy_accreditation_status>
				<suspended_withdrawn_date><suspended_withdrawn_date/>
				<scheme_name></scheme_name>
				<standard_code></standard_code>
			</certification_body_country>
		</certification_body_countries>
	</certification_body>
</ab_cbs>
```

</details>

**Tips:** Ensure that the Certification Body Identity Number and the Certification Body Name match with the existing Certification Body record.

2. Once completed, go to the IAF CertSearch Data Import page
3. Choose how you would like to import your data
   1. **File Upload** - [Learn how to import data through File Upload​](https://support.iafcertsearch.org/accreditation-bodies/data-management/import-certification/data-import-methods/file-upload)
   2. **FTP** [Learn how to import data through FTP​](https://support.iafcertsearch.org/accreditation-bodies/data-management/import-certification/data-import-methods/ftp)
4. Once selected, click the **Continue** button (the system will initiate file and data processing)
5. If all the files and data are valid, the certificate will be successfully added to the existing Certified Entity record.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.iafcertsearch.org/accreditation-bodies/data-management/import-certification-body/certification-body-templates/manage-data-in-xml.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.