xml implementation martin boerma food and consumer product safety authority - nl seoul – june 8th...

21
XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

Upload: lily-mclaughlin

Post on 27-Mar-2015

212 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

XML implementation

Martin BoermaFood and Consumer Product Safety Authority - NL

Seoul – June 8th 2011

Page 2: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

Content

• Implementation UN-CEFACT standard

• Reference data• Mapping plant health data• Challenges• Conclusions

Page 3: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Implementation UN-CEFACT standardPlant Health certificate• Import regulation• ISPM 12• Guidelines of importcountry

UN-CEFACT standard• XML-schema• Code-lists

Page 4: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Reference dataPlant Health certificate (i.e. European Union)• Import regulation

Page 5: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Reference dataPlant Health certificate (i.e. European Union)• Import regulation

Page 6: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Reference dataPlant Health certificate (i.e. European Union)• Import regulation

- guideline

Page 7: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Reference dataPlant Health certificate (i.e. European Union)

ISPM 12PHYTOSANITARY CERTIFICATES

Page 8: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Reference dataUN-CEFACT standardInternet address: http://www.unece.org/cefact/xml_schemas/index.htm#2009B

Page 9: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Reference dataUN-CEFACT dash board (confluence)Internet address: http://www1.unece.org/cefact/platform/display/TBG/TBG18

- UNCEFACT_ECERT_ImplementationGuide_Draftv1 0 GUIDE.doc- PhytoSanitary E-cert XMLDatamap v4 GUIDE.xls- Sanitary Certificate E-cert XML Data Mapping v7 GUIDE.xls

Page 10: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Reference dataUN-CEFACT instruction- PhytoSanitary E-cert XMLDatamap v4 GUIDE.xls

Page 11: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Mapping plant health data

Start:• Example: details of a consignment• Guide: PhytoSanitary E-cert XMLDatamap v4 GUIDE.xls• Schema: SPSCertificate_4p0.xsd

Result:• XML

Difficult to complete XML due to a lot of new information elements

Page 12: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Mapping plant health data

Second start:• Example: details of a plant health certificate• Guide: PhytoSanitary E-cert XMLDatamap v4 GUIDE.xls• Schema: SPSCertificate_4p0.xsd

Result:• XML

Only elements which were mentioned on plant health certificate were included.

Page 13: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Mapping plant health dataExample

Page 14: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Mapping plant health dataExample: consignee

Page 15: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Mapping plant health dataExample: point of entry

Page 16: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Mapping plant health dataExample: name of product

Page 17: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Mapping plant health dataExample: treatment

Page 18: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

ChallengesXML in respect to UN-CEFACT Standard• Well formed• Valid

XML-elements• Deletion of unused items does not effect validation to standard• Mandatory code-list should be used

Paper documents• XML• Template• Create a paper Plant Health document

(i.e. re-export needs a official copy of XML)

Page 19: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

ChallengesPaper documentsXML

Template Official copy in paper format

Page 20: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

ConclusionsUse Plant Health certificate for mapping information

Differ between validation of • UN-CEFACT Standard• ISPM 12 standard• Document control (Plant Health regulation import country)

UN-CEFACT Standard is there to support certification like the paper Plant Health certificate

Fall back option official paper copy (use of IPPC-template)• Emergency• Re-export

Page 21: XML implementation Martin Boerma Food and Consumer Product Safety Authority - NL Seoul – June 8th 2011

IPPC WG E-certification - XML NL | Jun 8th 2011

Thank you