Views: 3<\/p>
\u524d\u56de\u306e \u8a18\u4e8b<\/a> \u3067\u306f\uff0c\u65e5\u672c\u7248\u30b3\u30a2\u30a4\u30f3\u30dc\u30a4\u30b9\u3092\u69cb\u9020\u5316CSV\u3068\u3057\u3066\u8868\u73fe\u3057\uff0cJP PINT UBL\u3068\u306e\u5bfe\u5fdc\u3092 SemanticPath \u3068 XPath \u306e\u69cb\u6587\u7d50\u5408\u8868\u3068\u3057\u3066\u6574\u7406\u3057\u305f\u3002<\/p>\n<\/div>\n \u672c\u7a3f\u3067\u306f\uff0c\u305d\u306e\u69cb\u6587\u7d50\u5408\u8868\u3092\u4f7f\u3063\u3066\uff0c\u69cb\u9020\u5316CSV\u3068JP PINT UBL XML\u3092\u76f8\u4e92\u5909\u63db\u3059\u308bPython\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u8003\u3048\u65b9\u3092\u7d39\u4ecb\u3059\u308b\u3002<\/p>\n<\/div>\n \u3053\u3053\u3067\u793a\u3059\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\uff0cJP PINT UBL\u306e\u5b8c\u5168\u306a\u5b9f\u88c5\u3067\u306f\u306a\u3044\u3002\u76ee\u7684\u306f\uff0c\u6b21\u306e\u70b9\u3092\u30a4\u30e1\u30fc\u30b8\u3068\u3057\u3066\u3064\u304b\u3080\u3053\u3068\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n CSV\u5074\u306e\u9805\u76ee\u3092 SemanticPath \u3067\u6307\u5b9a\u3059\u308b\u3002<\/p>\n<\/li>\n XML\u5074\u306e\u9805\u76ee\u3092 XPath \u3067\u6307\u5b9a\u3059\u308b\u3002<\/p>\n<\/li>\n \u69cb\u6587\u7d50\u5408\u8868\u3092 \u30d7\u30ed\u30b0\u30e9\u30e0\u672c\u4f53\u306f\uff0c\u69cb\u6587\u7d50\u5408\u8868\u3092\u8aad\u307f\u53d6\u308a\uff0cCSV\u304b\u3089XML\u3092\u751f\u6210\u3059\u308b\u3002<\/p>\n<\/li>\n \u9006\u65b9\u5411\u3067\u306f\uff0cXML\u304b\u3089XPath\u3067\u5024\u3092\u53d6\u5f97\u3057\uff0c\u69cb\u9020\u5316CSV\u306e\u884c\u3078\u5c55\u958b\u3059\u308b\u3002<\/p>\n<\/li>\n \u5bfe\u5fdc\u5148\u306e\u69cb\u6587\u304c\u5909\u308f\u3063\u3066\u3082\uff0c\u539f\u5247\u3068\u3057\u3066\u7d50\u5408\u5b9a\u7fa9CSV\u3092\u5909\u66f4\u3059\u308c\u3070\uff0c\u540c\u3058\u6c4e\u7528\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5229\u7528\u3067\u304d\u308b\u3002<\/p>\n<\/li>\n<\/ul>\n<\/div>\n \u3064\u307e\u308a\uff0c\u5909\u63db\u30ed\u30b8\u30c3\u30af\u3092\u30d7\u30ed\u30b0\u30e9\u30e0\u5185\u306b\u76f4\u63a5\u66f8\u304d\u8fbc\u3080\u306e\u3067\u306f\u306a\u304f\uff0c\u69cb\u6587\u7d50\u5408\u8868\u3068\u3057\u3066\u5916\u90e8\u5316\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n \u4eca\u56de\u306e\u30b5\u30f3\u30d7\u30eb syntax_binding_revised_package.zip<\/a> \u306f\uff0c\u6b21\u306e3\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3046\u3002<\/p>\n<\/div>\n \u65e5\u672c\u7248\u30b3\u30a2\u30a4\u30f3\u30dc\u30a4\u30b9\u3092\u8868\u3059\u69cb\u9020\u5316CSV\u3002<\/p>\n<\/td>\n<\/tr>\n \u69cb\u9020\u5316CSV\u5074\u306e SemanticPath \u3068\uff0cJP PINT UBL\u5074\u306e XPath \u3092\u5bfe\u5fdc\u4ed8\u3051\u308b\u69cb\u6587\u7d50\u5408\u8868\u3002<\/p>\n<\/td>\n<\/tr>\n \u69cb\u9020\u5316CSV\u3068\u69cb\u6587\u7d50\u5408\u8868CSV\u3092\u8aad\u307f\u8fbc\u307f\uff0cJP PINT UBL XML\u3092\u751f\u6210\u3057\uff0c\u3055\u3089\u306bXML\u304b\u3089\u69cb\u9020\u5316CSV\u3078\u623b\u3059\u30b5\u30f3\u30d7\u30eb\u30d7\u30ed\u30b0\u30e9\u30e0\u3002<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \u5b9f\u884c\u4f8b\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n \u3053\u306e\u5b9f\u884c\u306b\u3088\u308a\uff0c\u6b21\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u751f\u6210\u3055\u308c\u308b\u3002<\/p>\n<\/div>\n \u69cb\u9020\u5316CSV\u304b\u3089\u751f\u6210\u3057\u305fJP PINT UBL subset XML\u3002<\/p>\n<\/td>\n<\/tr>\n \u751f\u6210\u3057\u305fXML\u3092\u8aad\u307f\u623b\u3057\u3066\u518d\u69cb\u6210\u3057\u305f\u69cb\u9020\u5316CSV\u3002<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n \u672c\u7a3f\u3067\u306f\uff0c\u8acb\u6c42\u66f8\u69cb\u9020\u5316CSV\u3092\u4f8b\u306b\u3059\u308b\u3002<\/p>\n<\/div>\n \u3053\u306eCSV\u3067\u306f\uff0c\u8acb\u6c42\u66f8\u30d8\u30c3\u30c0\u30fc\uff0c\u58f2\u624b\uff0c\u8cb7\u624b\uff0c\u53c2\u7167\u6587\u66f8\uff0c\u652f\u6255\u60c5\u5831\uff0c\u7a0e\u7387\u5225\u5185\u8a33\uff0c\u8acb\u6c42\u660e\u7d30\u3092\uff0c1\u679a\u306eCSV\u306b\u683c\u7d0d\u3057\u3066\u3044\u308b\u3002<\/p>\n<\/div>\n \u91cd\u8981\u306a\u306e\u306f\uff0c \u4f8b\u3048\u3070\uff0c\u6b21\u306e\u884c\u306f\u58f2\u624b\u3092\u8868\u3059\u3002<\/p>\n<\/div>\n \u3053\u306e\u884c\u3067\u306f\uff0c \u69cb\u6587\u7d50\u5408\u8868\u306f\uff0c\u69cb\u9020\u5316CSV\u5074\u306e SemanticPath \u3068\uff0cJP PINT UBL\u5074\u306e XPath \u3092\u5bfe\u5fdc\u4ed8\u3051\u308b\u8868\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n \u4eca\u56de\u306e\u6539\u8a02\u3067\u306f\uff0c\u3053\u306e\u5bfe\u5fdc\u8868\u3092Python\u30b3\u30fc\u30c9\u4e2d\u306e \u4f8b\u3048\u3070\uff0c\u58f2\u624b\u540d\u79f0\u306f\u6b21\u306e\u3088\u3046\u306b\u6307\u5b9a\u3059\u308b\u3002<\/p>\n<\/div>\n \u3053\u308c\u306f\uff0c\u6b21\u306e\u610f\u5473\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n \u305d\u306e\u5024\u3092\uff0c\u6b21\u306eXPath\u3067\u6307\u5b9a\u3055\u308c\u308bXML\u8981\u7d20\u3078\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n<\/div>\n \u30d7\u30ed\u30b0\u30e9\u30e0\u306f\uff0cCSV\u5217\u540d\u3068XML\u8981\u7d20\u540d\u306e\u5bfe\u5fdc\u3092\u76f4\u63a5\u77e5\u3063\u3066\u3044\u308b\u306e\u3067\u306f\u306a\u3044\u3002\u5bfe\u5fdc\u95a2\u4fc2\u3092 \u30b5\u30f3\u30d7\u30eb\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\uff0c\u5927\u304d\u304f\u6b21\u306e\u51e6\u7406\u306b\u5206\u3051\u3089\u308c\u308b\u3002<\/p>\n<\/div>\n CSV\u8aad\u8fbc\u307f<\/p>\n<\/td>\n \u69cb\u6587\u7d50\u5408\u8868\u8aad\u8fbc\u307f<\/p>\n<\/td>\n SemanticPath\u8a55\u4fa1<\/p>\n<\/td>\n CSV\u884c\u30ea\u30b9\u30c8\u304b\u3089\uff0c\u6307\u5b9a\u3055\u308c\u305f SemanticPath \u306b\u5bfe\u5fdc\u3059\u308b\u5024\u3092\u53d6\u5f97\u3059\u308b\u3002<\/p>\n<\/td>\n<\/tr>\n XML\u751f\u6210<\/p>\n<\/td>\n XPath\u306b\u5f93\u3063\u3066XML\u8981\u7d20\u3092\u4f5c\u6210\u3057\uff0c\u53d6\u5f97\u3057\u305f\u5024\u3092\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n<\/td>\n<\/tr>\n XML\u8aad\u8fbc\u307f<\/p>\n<\/td>\n ElementTree\u3067XML\u3092\u8aad\u307f\u8fbc\u307f\uff0cXPath\u76f8\u5f53\u306e\u30d1\u30b9\u3067\u5024\u3092\u53d6\u5f97\u3059\u308b\u3002<\/p>\n<\/td>\n<\/tr>\n CSV\u751f\u6210<\/p>\n<\/td>\n XML\u304b\u3089\u53d6\u5f97\u3057\u305f\u5024\u3092\uff0c\u69cb\u9020\u5316CSV\u306e\u884c\u3068\u3057\u3066\u518d\u69cb\u6210\u3059\u308b\u3002<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \u672c\u7a3f\u3067\u306f\uff0cPython\u6a19\u6e96\u30e9\u30a4\u30d6\u30e9\u30ea\u306e \u69cb\u9020\u5316CSV\u306f\uff0cPython\u306e\u6a19\u6e96\u30e9\u30a4\u30d6\u30e9\u30ea 1\u884c\u304c1\u3064\u306e\u8f9e\u66f8\u306b\u306a\u308a\uff0cCSV\u306e\u5217\u540d\u3092\u30ad\u30fc\u3068\u3057\u3066\u5024\u3092\u53d6\u5f97\u3067\u304d\u308b\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n \u3053\u306e\u95a2\u6570\u306b\u3088\u308a\uff0c\u69cb\u6587\u7d50\u5408\u8868\u306f\u6b21\u306e\u3088\u3046\u306a\u30bf\u30d7\u30eb\u306e\u30ea\u30b9\u30c8\u306b\u306a\u308b\u3002<\/p>\n<\/div>\n \u3053\u3053\u3067\u91cd\u8981\u306a\u306e\u306f\uff0c\u5bfe\u5fdc\u95a2\u4fc2\u304c\u30d7\u30ed\u30b0\u30e9\u30e0\u5b9a\u6570\u3067\u306f\u306a\u304f\uff0c\u5916\u90e8\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u5dee\u3057\u66ff\u3048\u53ef\u80fd\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n \u672c\u7a3f\u306e\u30b5\u30f3\u30d7\u30eb\u3067\u306f\uff0c\u6b21\u306e2\u7a2e\u985e\u306eSemanticPath\u3060\u3051\u3092\u6271\u3046\u3002<\/p>\n<\/div>\n \u4f8b\u3048\u3070\uff0c\u8acb\u6c42\u66f8\u756a\u53f7\u306f\u6b21\u306e\u5f62\u5f0f\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n \u58f2\u624b\u540d\u79f0\u306f\u6b21\u306e\u5f62\u5f0f\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n \u3053\u308c\u3092\u51e6\u7406\u3059\u308b\u95a2\u6570\u306f\uff0c\u6b21\u306e\u3068\u304a\u308a\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n \u3053\u306e\u95a2\u6570\u306f\uff0c\u6c4e\u7528XPath\u3084\u6c4e\u7528JSONPath\u3092\u5b9f\u88c5\u3057\u3066\u3044\u308b\u308f\u3051\u3067\u306f\u306a\u3044\u3002\u69cb\u6587\u7d50\u5408\u8868\u3067\u5fc5\u8981\u3068\u306a\u308b\u6700\u5c0f\u9650\u306e SemanticPath subset \u3092\u5b9f\u88c5\u3057\u3066\u3044\u308b\u3002<\/p>\n<\/div>\n \u5b9f\u52d9\u4e0a\u3082\uff0c\u6700\u521d\u304b\u3089\u3059\u3079\u3066\u306e\u5f0f\u3092\u8a31\u5bb9\u3059\u308b\u3088\u308a\uff0c\u69cb\u6587\u7d50\u5408\u8868\u3067\u4f7f\u7528\u3067\u304d\u308b\u8a18\u6cd5\u3092\u9650\u5b9a\u3057\u305f\u65b9\u304c\u5b89\u5168\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n JP PINT UBL\u306fXML\u540d\u524d\u7a7a\u9593\u3092\u4f7f\u7528\u3059\u308b\u3002ElementTree\u3067\u540d\u524d\u7a7a\u9593\u4ed8\u304dXML\u3092\u6271\u3046\u305f\u3081\uff0c\u307e\u305a\u540d\u524d\u7a7a\u9593\u3092\u5b9a\u7fa9\u3059\u308b\u3002<\/p>\n<\/div>\n ElementTree\u3067\u306f\uff0c\u540d\u524d\u7a7a\u9593\u4ed8\u304d\u8981\u7d20\u3092\u6b21\u306e\u5f62\u5f0f\u3067\u6307\u5b9a\u3059\u308b\u3002<\/p>\n<\/div>\n \u4f8b\u3048\u3070\uff0c \u6bce\u56de\u3053\u306e\u6587\u5b57\u5217\u3092\u66f8\u304f\u306e\u306f\u7169\u96d1\u306a\u306e\u3067\uff0c\u63a5\u982d\u8f9e\u4ed8\u304d\u306e\u540d\u524d\u304b\u3089ElementTree\u7528\u306e\u540d\u524d\u3078\u5909\u63db\u3059\u308b\u95a2\u6570 \u69cb\u6587\u7d50\u5408\u8868\u306b\u306f\uff0c\u6b21\u306e\u3088\u3046\u306aXPath\u304c\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308b\u3002<\/p>\n<\/div>\n \u3053\u306e\u30d1\u30b9\u306b\u6cbf\u3063\u3066\uff0cInvoice\u306b\u8ffd\u52a0\u3059\u3079\u304d\u8981\u7d20\u3092\u9806\u756a\u306b\u4f5c\u6210\u3059\u308b\u3002<\/p>\n<\/div>\n \u4f8b\u3048\u3070\uff0c\u6b21\u306e\u547c\u3073\u51fa\u3057\u3092\u884c\u3046\u3002<\/p>\n<\/div>\n \u3053\u308c\u306b\u3088\u308a\uff0c\u6b21\u306e\u3088\u3046\u306aXML\u8981\u7d20\u304c\u751f\u6210\u3055\u308c\u308b\u3002<\/p>\n<\/div>\n CSV\u304b\u3089XML\u3078\u306e\u5909\u63db\u306f\uff0c\u5358\u7d14\u9805\u76ee\u306b\u3064\u3044\u3066\u306f\u6b21\u306e3\u6bb5\u968e\u3067\u51e6\u7406\u3067\u304d\u308b\u3002<\/p>\n<\/div>\n\n
bindings.csv<\/code> \u3068\u3057\u3066\u5916\u90e8\u5316\u3059\u308b\u3002<\/p>\n<\/li>\n2. \u30d5\u30a1\u30a4\u30eb\u69cb\u6210<\/h2>\n
\n
\n \n\u30d5\u30a1\u30a4\u30eb<\/th>\n \u5f79\u5272<\/th>\n<\/tr>\n<\/thead>\n \n \n invoice.csv<\/code><\/p>\n<\/td>\n\n \n \n bindings.csv<\/code><\/p>\n<\/td>\n\n \n \n syntax_binding.py<\/code><\/p>\n<\/td>\n\n python3 syntax_binding.py \\\r\n --input-csv invoice.csv \\\r\n --bindings-csv bindings.csv \\\r\n --xml-out invoice.xml \\\r\n --roundtrip-csv roundtrip.csv \\\r\n --print-xml<\/code><\/pre>\n<\/div>\n<\/div>\n\n
\n \n\u51fa\u529b\u30d5\u30a1\u30a4\u30eb<\/th>\n \u5185\u5bb9<\/th>\n<\/tr>\n<\/thead>\n \n \n invoice.xml<\/code><\/p>\n<\/td>\n\n \n \n roundtrip.csv<\/code><\/p>\n<\/td>\n\n 3. \u69cb\u9020\u5316CSV\u3068\u69cb\u6587\u7d50\u5408\u8868<\/h2>\n
3.1. \u69cb\u9020\u5316CSV\u306e\u4f8b<\/h3>\n
dInvoice,dInvoiceParty,dDocumentReference,dPayment,dTaxBreakdown,dInvoiceLine,invoiceNumber,issueDate,invoiceTypeCode,currencyCode,totalAmount,partyRole,partyName,partyTaxID,referenceType,referenceID,paymentDueDate,paymentMeansCode,paymentReference,taxCategoryCode,taxRate,taxableAmount,taxAmount,lineID,itemName,lineTaxCategoryCode,lineTaxRate,invoicedQuantity,unitCode,unitPriceAmount,lineExtensionAmount\r\n1,,,,,,INV-26-861,2026-06-20,380,JPY,16802,,,,,,,,,,,,,,,,,,,,\r\n1,1,,,,,,,,,,Seller,\u58f2\u624b\u682a\u5f0f\u4f1a\u793e,T1234567890123,,,,,,,,,,,,,,,,,\r\n1,2,,,,,,,,,,Buyer,\u8cb7\u624b\u682a\u5f0f\u4f1a\u793e,,,,,,,,,,,,,,,,,,\r\n1,,1,,,,,,,,,,,,Order,PO-2026-0001,,,,,,,,,,,,,,,\r\n1,,2,,,,,,,,,,,,Delivery,DN-2026-0001,,,,,,,,,,,,,,,\r\n1,,,1,,,,,,,,,,,,,2026-07-31,30,INV-2026-0001,,,,,,,,,,,,\r\n1,,,,1,,,,,,,,,,,,,,,S,10,12320,1232,,,,,,,,\r\n1,,,,1,,,,,,,,,,,,,,,AA,8,3010,240,,,,,,,,\r\n1,,,,,1,,,,,,,,,,,,,,,,,,INV-26-861-1,\u5546\u54c1A,S,10,10,EA,1000,10000\r\n1,,,,,2,,,,,,,,,,,,,,,,,,INV-26-861-2,\u5546\u54c1B,S,10,4,EA,580,2320\r\n1,,,,,3,,,,,,,,,,,,,,,,,,INV-26-861-3,\u98df\u54c1C,AA,8,7,EA,430,3010<\/code><\/pre>\n<\/div>\n<\/div>\ndInvoiceParty<\/code>\uff0cdDocumentReference<\/code>\uff0cdPayment<\/code>\uff0cdTaxBreakdown<\/code>\uff0cdInvoiceLine<\/code> \u306a\u3069\u306e\u5217\u3067\u3042\u308b\u3002\u3053\u308c\u3089\u306f\uff0c\u884c\u304c\u3069\u306e\u968e\u5c64\u53c8\u306f\u7e70\u8fd4\u3057\u69cb\u9020\u306b\u5c5e\u3059\u308b\u304b\u3092\u793a\u3059\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u5217\u3067\u3042\u308b\u3002<\/p>\n<\/div>\n1,1,,,,,,,,,,Seller,\u58f2\u624b\u682a\u5f0f\u4f1a\u793e,T1234567890123,,,,,,,,,,,,,,,,,<\/code><\/pre>\n<\/div>\n<\/div>\ndInvoiceParty<\/code> \u306b 1<\/code> \u304c\u5165\u308a\uff0cpartyRole<\/code> \u306b Seller<\/code> \u304c\u5165\u3063\u3066\u3044\u308b\u3002\u3057\u305f\u304c\u3063\u3066\uff0c\u3053\u306e\u884c\u306f\u300c\u8acb\u6c42\u66f8\u5f53\u4e8b\u8005\u306e\u3046\u3061\uff0c\u58f2\u624b\u3092\u8868\u3059\u884c\u300d\u3068\u89e3\u91c8\u3067\u304d\u308b\u3002<\/p>\n<\/div>\n<\/div>\n3.2. \u69cb\u6587\u7d50\u5408\u8868CSV<\/h3>\n
BINDINGS<\/code> \u30ea\u30b9\u30c8\u3067\u306f\u306a\u304f\uff0c\u6b21\u306e bindings.csv<\/code> \u3068\u3057\u3066\u5916\u90e8\u5316\u3057\u305f\u3002<\/p>\n<\/div>\nsemantic_path,xpath\r\n$.Invoice.invoiceNumber,\/Invoice\/cbc:ID\r\n$.Invoice.issueDate,\/Invoice\/cbc:IssueDate\r\n$.Invoice.invoiceTypeCode,\/Invoice\/cbc:InvoiceTypeCode\r\n$.Invoice.currencyCode,\/Invoice\/cbc:DocumentCurrencyCode\r\n$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyName,\/Invoice\/cac:AccountingSupplierParty\/cac:Party\/cac:PartyName\/cbc:Name\r\n$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyTaxID,\/Invoice\/cac:AccountingSupplierParty\/cac:Party\/cac:PartyTaxScheme\/cbc:CompanyID\r\n$.Invoice.dInvoiceParty[?@.partyRole=Buyer].partyName,\/Invoice\/cac:AccountingCustomerParty\/cac:Party\/cac:PartyName\/cbc:Name\r\n$.Invoice.dInvoiceParty[?@.partyRole=Buyer].partyTaxID,\/Invoice\/cac:AccountingCustomerParty\/cac:Party\/cac:PartyTaxScheme\/cbc:CompanyID\r\n$.Invoice.dDocumentReference[?@.referenceType=Order].referenceID,\/Invoice\/cac:OrderReference\/cbc:ID\r\n$.Invoice.dDocumentReference[?@.referenceType=Delivery].referenceID,\/Invoice\/cac:DespatchDocumentReference\/cbc:ID\r\n$.Invoice.paymentDueDate,\/Invoice\/cbc:DueDate\r\n$.Invoice.paymentReference,\/Invoice\/cac:PaymentMeans\/cbc:PaymentID<\/code><\/pre>\n<\/div>\n<\/div>\n$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyName<\/code><\/pre>\n<\/div>\n<\/div>\ndInvoiceParty \u306e\u884c\u306e\u3046\u3061\uff0c\r\npartyRole \u304c Seller \u3067\u3042\u308b\u884c\u3092\u9078\u629e\u3057\uff0c\r\n\u305d\u306e\u884c\u306e partyName \u3092\u53d6\u5f97\u3059\u308b\u3002<\/pre>\n<\/div>\n<\/div>\n
\/Invoice\/cac:AccountingSupplierParty\/cac:Party\/cac:PartyName\/cbc:Name<\/code><\/pre>\n<\/div>\n<\/div>\nbindings.csv<\/code> \u304b\u3089\u8aad\u307f\u8fbc\u307f\uff0cSemanticPath \u3068 XPath \u3092\u4f7f\u3063\u3066\u51e6\u7406\u3057\u3066\u3044\u308b\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n4. Python\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u5168\u4f53\u69cb\u6210<\/h2>\n
\n
\n \n\u51e6\u7406<\/th>\n \u5f79\u5272<\/th>\n<\/tr>\n<\/thead>\n \n \n \n invoice.csv<\/code> \u3092 csv.DictReader<\/code> \u3067\u884c\u30ea\u30b9\u30c8\u3068\u3057\u3066\u8aad\u307f\u8fbc\u3080\u3002<\/p>\n<\/td>\n<\/tr>\n\n \n \n bindings.csv<\/code> \u304b\u3089 SemanticPath \u3068 XPath \u306e\u5bfe\u5fdc\u3092\u8aad\u307f\u8fbc\u3080\u3002<\/p>\n<\/td>\n<\/tr>\n\n \n \n \n \n \n \n \n \n \n \n \n csv<\/code> \u3068 xml.etree.ElementTree<\/code> \u3092\u4f7f\u7528\u3059\u308b\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n5. CSV\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u3080<\/h2>\n
csv<\/code> \u3067\u8aad\u307f\u8fbc\u3080\u3002<\/p>\n<\/div>\nimport argparse\r\nimport csv\r\nimport io\r\nimport re\r\nimport sys\r\nimport xml.etree.ElementTree as ET\r\nfrom decimal import Decimal\r\nfrom pathlib import Path\r\ndef read_core_csv(text: str) -> list[dict[str, str]]:\r\n \"\"\"CSV\u6587\u5b57\u5217\u3092\u8f9e\u66f8\u884c\u306e\u30ea\u30b9\u30c8\u3068\u3057\u3066\u8aad\u307f\u8fbc\u3080\u3002\"\"\"\r\n return list(csv.DictReader(io.StringIO(text)))\r\n\r\n\r\ndef read_core_csv_file(path: str | Path, encoding: str = \"utf-8-sig\") -> list[dict[str, str]]:\r\n \"\"\"\u69cb\u9020\u5316CSV\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u3080\u3002Excel\u7531\u6765\u306eBOM\u3092\u8003\u616e\u3057\uff0c\u65e2\u5b9a\u3092utf-8-sig\u306b\u3059\u308b\u3002\"\"\"\r\n return read_core_csv(Path(path).read_text(encoding=encoding))<\/code><\/pre>\n<\/div>\n<\/div>\nread_core_csv_file()<\/code> \u306f\uff0cinvoice.csv<\/code> \u3092\u8aad\u307f\u8fbc\u307f\uff0c1\u884c\u30921\u3064\u306e\u8f9e\u66f8\u3068\u3057\u3066\u6271\u3048\u308b\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n<\/div>\n[\r\n {\r\n \"dInvoice\": \"1\",\r\n \"invoiceNumber\": \"INV-26-861\",\r\n \"issueDate\": \"2026-06-20\",\r\n },\r\n {\r\n \"dInvoice\": \"1\",\r\n \"dInvoiceParty\": \"1\",\r\n \"partyRole\": \"Seller\",\r\n \"partyName\": \"\u58f2\u624b\u682a\u5f0f\u4f1a\u793e\",\r\n \"partyTaxID\": \"T1234567890123\",\r\n },\r\n]<\/code><\/pre>\n<\/div>\n<\/div>\n6. \u69cb\u6587\u7d50\u5408\u8868CSV\u3092\u8aad\u307f\u8fbc\u3080<\/h2>\n
bindings.csv<\/code> \u306f\uff0csemantic_path<\/code> \u3068 xpath<\/code> \u306e2\u5217\u3092\u6301\u3064CSV\u3067\u3042\u308b\u3002<\/p>\n<\/div>\ndef read_bindings_csv(text: str) -> list[Binding]:\r\n \"\"\"semantic_path,xpath \u306e2\u5217\u3092\u6301\u3064\u69cb\u6587\u7d50\u5408\u8868CSV\u3092\u8aad\u307f\u8fbc\u3080\u3002\"\"\"\r\n bindings: list[Binding] = []\r\n\r\n reader = csv.DictReader(io.StringIO(text))\r\n if reader.fieldnames is None:\r\n raise ValueError(\"Binding CSV has no header\")\r\n\r\n # UTF-8 BOM\u5bfe\u7b56\u3002\r\n fieldnames = [name.lstrip(\"\\ufeff\") for name in reader.fieldnames]\r\n semantic_col = \"semantic_path\"\r\n xpath_col = \"xpath\"\r\n\r\n if semantic_col not in fieldnames or xpath_col not in fieldnames:\r\n raise ValueError(\"Binding CSV must have semantic_path and xpath columns\")\r\n\r\n for line_no, row in enumerate(reader, start=2):\r\n normalized = {k.lstrip(\"\\ufeff\"): (v or \"\").strip() for k, v in row.items()}\r\n semantic_path = normalized.get(semantic_col, \"\")\r\n xpath = normalized.get(xpath_col, \"\")\r\n\r\n if not semantic_path and not xpath:\r\n continue\r\n if not semantic_path or not xpath:\r\n raise ValueError(f\"Incomplete binding at line {line_no}: {row!r}\")\r\n if not xpath.startswith(\"\/Invoice\/\") and xpath != \"\/Invoice\":\r\n raise ValueError(f\"XPath must start with \/Invoice at line {line_no}: {xpath!r}\")\r\n\r\n bindings.append((semantic_path, xpath))\r\n\r\n return bindings\r\n\r\n\r\ndef read_bindings_csv_file(path: str | Path, encoding: str = \"utf-8-sig\") -> list[Binding]:\r\n return read_bindings_csv(Path(path).read_text(encoding=encoding))<\/code><\/pre>\n<\/div>\n<\/div>\n[\r\n (\"$.Invoice.invoiceNumber\", \"\/Invoice\/cbc:ID\"),\r\n (\"$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyName\",\r\n \"\/Invoice\/cac:AccountingSupplierParty\/cac:Party\/cac:PartyName\/cbc:Name\"),\r\n]<\/code><\/pre>\n<\/div>\n<\/div>\n7. SemanticPath\u3067\u5024\u3092\u53d6\u5f97\u3059\u308b<\/h2>\n
$.Invoice.field\r\n$.Invoice.dimension[?@.filterField=filterValue].field<\/code><\/pre>\n<\/div>\n<\/div>\n$.Invoice.invoiceNumber<\/code><\/pre>\n<\/div>\n<\/div>\n$.Invoice.dInvoiceParty[?@.partyRole=Seller].partyName<\/code><\/pre>\n<\/div>\n<\/div>\ndef rows_by_dimension(\r\n rows: list[dict[str, str]],\r\n dimension: str,\r\n d_invoice: str = \"1\",\r\n) -> list[dict[str, str]]:\r\n return [r for r in rows if r.get(\"dInvoice\") == d_invoice and r.get(dimension)]\r\n\r\n\r\ndef first_value(\r\n rows: list[dict[str, str]],\r\n column: str,\r\n d_invoice: str = \"1\",\r\n) -> str:\r\n for row in rows:\r\n if row.get(\"dInvoice\") == d_invoice and row.get(column):\r\n return row[column]\r\n return \"\"\r\n\r\n\r\ndef query_semantic_path(\r\n rows: list[dict[str, str]],\r\n path: str,\r\n d_invoice: str = \"1\",\r\n) -> str:\r\n \"\"\"\r\n \u3053\u306e\u30b5\u30f3\u30d7\u30eb\u3067\u6271\u3046 SemanticPath subset:\r\n $.Invoice.field\r\n $.Invoice.dimension[?@.filterField=\"filterValue\"].field\r\n $.Invoice.dimension[?@.filterField=filterValue].field\r\n \"\"\"\r\n\r\n m = re.fullmatch(r\"\\$\\.Invoice\\.([A-Za-z_][A-Za-z0-9_]*)\", path)\r\n if m:\r\n return first_value(rows, m.group(1), d_invoice)\r\n\r\n m = re.fullmatch(\r\n r\"\\$\\.Invoice\\.([A-Za-z_][A-Za-z0-9_]*)\"\r\n r\"\\[\\?@\\.([A-Za-z_][A-Za-z0-9_]*)=(?:\\\"([^\\\"]+)\\\"|([^\\]]+))\\]\"\r\n r\"\\.([A-Za-z_][A-Za-z0-9_]*)\",\r\n path,\r\n )\r\n if m:\r\n dimension, filter_field, quoted_value, bare_value, target_field = m.groups()\r\n filter_value = quoted_value if quoted_value is not None else bare_value\r\n\r\n for row in rows_by_dimension(rows, dimension, d_invoice):\r\n if row.get(filter_field) == filter_value:\r\n return row.get(target_field, \"\")\r\n\r\n return \"\"\r\n\r\n raise ValueError(f\"Unsupported SemanticPath: {path}\")<\/code><\/pre>\n<\/div>\n<\/div>\n8. ElementTree\u3067XML\u3092\u6271\u3046<\/h2>\n
UBL_NS = \"urn:oasis:names:specification:ubl:schema:xsd:Invoice-2\"\r\nCBC_NS = \"urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2\"\r\nCAC_NS = \"urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2\"\r\n\r\nNS = {\r\n \"\": UBL_NS,\r\n \"cbc\": CBC_NS,\r\n \"cac\": CAC_NS,\r\n}\r\n\r\nfor prefix, uri in NS.items():\r\n ET.register_namespace(prefix, uri)\r\n\r\n\r\ndef qname(name: str) -> str:\r\n if \":\" in name:\r\n prefix, local = name.split(\":\", 1)\r\n return f\"{{{NS[prefix]}}}{local}\"\r\n return f\"{{{UBL_NS}}}{name}\"<\/code><\/pre>\n<\/div>\n<\/div>\n{\u540d\u524d\u7a7a\u9593URI}\u30ed\u30fc\u30ab\u30eb\u540d<\/code><\/pre>\n<\/div>\n<\/div>\ncbc:ID<\/code> \u306f\u5185\u90e8\u7684\u306b\u306f\u6b21\u306e\u540d\u524d\u306b\u306a\u308b\u3002<\/p>\n<\/div>\n{urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2}ID<\/code><\/pre>\n<\/div>\n<\/div>\nqname()<\/code> \u3092\u7528\u610f\u3057\u3066\u3044\u308b\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n9. XPath\u306b\u6cbf\u3063\u3066\u8981\u7d20\u3092\u751f\u6210\u3059\u308b<\/h2>\n
\/Invoice\/cac:AccountingSupplierParty\/cac:Party\/cac:PartyName\/cbc:Name<\/code><\/pre>\n<\/div>\n<\/div>\ndef normalize_xpath(xpath: str) -> str:\r\n xpath = xpath.strip()\r\n # \u7d50\u5408\u8868\u306e\u6b63\u898f\u8868\u8a18\u3067\u306f\uff0c\u9014\u4e2d\u7a7a\u767d\u3092\u8a31\u5bb9\u3057\u306a\u3044\u3002\r\n if re.search(r\"\\s\", xpath):\r\n raise ValueError(f\"XPath contains whitespace: {xpath!r}\")\r\n return xpath\r\n\r\n\r\ndef ensure_path(root: ET.Element, xpath: str) -> ET.Element:\r\n xpath = normalize_xpath(xpath)\r\n parts = [p for p in xpath.split(\"\/\") if p]\r\n\r\n if not parts or parts[0] != \"Invoice\":\r\n raise ValueError(f\"XPath must start with \/Invoice: {xpath}\")\r\n\r\n elem = root\r\n for part in parts[1:]:\r\n tag = qname(part)\r\n child = elem.find(tag)\r\n if child is None:\r\n child = ET.SubElement(elem, tag)\r\n elem = child\r\n\r\n return elem\r\n\r\n\r\ndef set_text(root: ET.Element, xpath: str, value: str | None) -> None:\r\n if value not in (None, \"\"):\r\n ensure_path(root, xpath).text = str(value)\r\n\r\n\r\ndef get_text(root: ET.Element, xpath: str) -> str:\r\n xpath = normalize_xpath(xpath)\r\n parts = [p for p in xpath.split(\"\/\") if p]\r\n\r\n if not parts or parts[0] != \"Invoice\":\r\n raise ValueError(f\"XPath must start with \/Invoice: {xpath}\")\r\n\r\n elem = root\r\n for part in parts[1:]:\r\n elem = elem.find(qname(part))\r\n if elem is None:\r\n return \"\"\r\n\r\n return elem.text or \"\"<\/code><\/pre>\n<\/div>\n<\/div>\nensure_path()<\/code> \u306f\uff0c\u6307\u5b9a\u3055\u308c\u305fXPath\u306e\u6700\u5f8c\u306e\u8981\u7d20\u3092\u8fd4\u3059\u3002<\/p>\n<\/div>\nelem = ensure_path(\r\n invoice,\r\n \"\/Invoice\/cac:AccountingSupplierParty\/cac:Party\/cac:PartyName\/cbc:Name\"\r\n)\r\nelem.text = \"\u58f2\u624b\u682a\u5f0f\u4f1a\u793e\"<\/code><\/pre>\n<\/div>\n<\/div>\n<cac:AccountingSupplierParty>\r\n <cac:Party>\r\n <cac:PartyName>\r\n <cbc:Name>\u58f2\u624b\u682a\u5f0f\u4f1a\u793e<\/cbc:Name>\r\n <\/cac:PartyName>\r\n <\/cac:Party>\r\n<\/cac:AccountingSupplierParty><\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n10. \u69cb\u6587\u7d50\u5408\u8868\u3092\u4f7f\u3063\u3066CSV\u304b\u3089XML\u3092\u4f5c\u308b<\/h2>\n
1. SemanticPath\u3067CSV\u304b\u3089\u5024\u3092\u53d6\u5f97\u3059\u308b\u3002\r\n2. XPath\u3067XML\u4e0a\u306e\u8a2d\u5b9a\u5148\u3092\u6c7a\u3081\u308b\u3002\r\n3. \u53d6\u5f97\u3057\u305f\u5024\u3092XML\u8981\u7d20\u306b\u8a2d\u5b9a\u3059\u308b\u3002<\/pre>\n<\/div>\n<\/div>\n