|
Экспорт в xml по шаблону
|
|||
---|---|---|---|
#18+
Здравствуйте! Появилась необходимость экспорта данных из Access в xml. Только файл xml определенного шаблона, который понимает определенное прога. Вот пример шаблона <soapenv:Envelope xmlns:inc=" http://www.w3.org/2004/08/xop/include" xmlns:mes=" http://roskazna.ru/gisgmp/xsd/116/Message" xmlns:mes1=" http://roskazna.ru/gisgmp/xsd/116/MessageData" xmlns:rev=" http://smev.gosuslugi.ru/rev120315" xmlns:smev=" http://roskazna.ru/gisgmp/02000000/SmevGISGMPService/" xmlns:soapenv=" http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsse=" http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu=" http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:xd=" http://www.w3.org/2000/09/xmldsig#"> <soapenv:Body wsu:Id="body"> <smev:GISGMPTransferMsg> <rev:Message> <rev:Sender> <rev:Code>RKZN01001</rev:Code> <rev:Name>Казначейство России</rev:Name> </rev:Sender> <rev:Recipient> <rev:Code>RKZN01001</rev:Code> <rev:Name>Казначейство России</rev:Name> </rev:Recipient> <rev:ServiceName>GISGMP</rev:ServiceName> <rev:TypeCode>GFNC</rev:TypeCode> <rev:Status>REQUEST</rev:Status> <rev:Date>2014-10-14T09:30:47.0Z</rev:Date> <rev:ExchangeType>6</rev:ExchangeType> </rev:Message> <rev:MessageData> <rev:AppData xmlns:gisgmp=" http://roskazna.ru/gisgmp/xsd/116/Message" xmlns:msgd=" http://roskazna.ru/gisgmp/xsd/116/MessageData" xmlns:pdr=" http://roskazna.ru/gisgmp/xsd/116/PGU_DataRequest" xmlns:smev=" http://smev.gosuslugi.ru/rev120315" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"> <gisgmp:RequestMessage Id="ID_1" senderIdentifier="0000a1" timestamp="2001-12-17T09:30:47.0Z"> <msgd:ImportRequest xmlns:pir=" http://roskazna.ru/gisgmp/xsd/116/PGU_ImportRequest"> <pir:Package> <pir:Document originatorID="0000a1"> <chg:Charge xmlns:pir=" http://roskazna.ru/gisgmp/xsd/116/PGU_ImportRequest" xmlns:gisgmp=" http://roskazna.ru/gisgmp/xsd/116/Message" xmlns:msgd=" http://roskazna.ru/gisgmp/xsd/116/MessageData" xmlns:pdr=" http://roskazna.ru/gisgmp/xsd/116/PGU_DataRequest" xmlns:smev=" http://smev.gosuslugi.ru/rev120315" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenv=" http://schemas.xmlsoap.org/soap/envelope/" xmlns:ds=" http://www.w3.org/2000/09/xmldsig#" xmlns:inc=" http://www.w3.org/2004/08/xop/include" xmlns:mes=" http://roskazna.ru/gisgmp/xsd/116/Message" xmlns:mes1=" http://roskazna.ru/gisgmp/xsd/116/MessageData" xmlns:rev=" http://smev.gosuslugi.ru/rev120315" xmlns:wsse=" http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu=" http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:xd=" http://www.w3.org/2000/09/xmldsig#" xmlns:soapenv1=" http://schemas.xmlsoap.org/soap/envelope/" xmlns:bdi=" http://roskazna.ru/gisgmp/xsd/116/BudgetIndex" xmlns:chg=" http://roskazna.ru/gisgmp/xsd/116/Charge" xmlns:com=" http://roskazna.ru/gisgmp/xsd/116/Common" xmlns:org=" http://roskazna.ru/gisgmp/xsd/116/Organization" Id="ID_0057" billDate="2014-10-14T09:30:47.0Z" supplierBillID="0000016101005733301039993"> <chg:SupplierOrgInfo> <org:Name>Администратор начислений тест</org:Name> <org:INN>5678901231</org:INN> <org:KPP>567890121</org:KPP> <org:Account> <org:AccountNumber>40602810000380000020</org:AccountNumber> <org:Bank> <org:BIK>044523331</org:BIK> </org:Bank> </org:Account> </chg:SupplierOrgInfo> <chg:BillFor>Штраф</chg:BillFor> <chg:TotalAmount>10000</chg:TotalAmount> <com:ChangeStatus meaning="1"/> <chg:KBK>15651111111111111113</chg:KBK> <chg:OKTMO>12345673</chg:OKTMO> <chg:BudgetIndex> <bdi:Status>01</bdi:Status> <bdi:Purpose>0</bdi:Purpose> <bdi:TaxPeriod>0</bdi:TaxPeriod> <bdi:TaxDocNumber>12345</bdi:TaxDocNumber> <bdi:TaxDocDate>0</bdi:TaxDocDate> <bdi:PaymentType>0</bdi:PaymentType> </chg:BudgetIndex> <chg:AltPayerIdentifier>0100000000023456789999643</chg:AltPayerIdentifier> <chg:TreasureBranch>УФК по г. Москва</chg:TreasureBranch> <Signature xmlns=" http://www.w3.org/2000/09/xmldsig#" Id="ID_0057-signature"> <SignedInfo> <CanonicalizationMethod Algorithm=" http://www.w3.org/2001/10/xml-exc-c14n#"/> <SignatureMethod Algorithm=" http://www.w3.org/2001/04/xmldsig-more#gostr34102001-gostr3411"/> <Reference URI="#ID_0057"> <Transforms> <Transform Algorithm=" http://www.w3.org/2000/09/xmldsig#enveloped-signature"/> <Transform Algorithm=" http://www.w3.org/2001/10/xml-exc-c14n#"/> </Transforms> <DigestMethod Algorithm=" http://www.w3.org/2001/04/xmldsig-more#gostr3411"/> <DigestValue>5sC4EjjCXITSl78pBPFcf2FrQarJB0fVgOxy4QBXxx4=</DigestValue> </Reference> </SignedInfo> <SignatureValue>G+9R5gDymxVVypCANNxcBf8SI/5awiWON5FLcWKtEDlycPpJAucFA32qtLlr+kerrQazkYhz2pqaESpyHF6lAw==</SignatureValue> <KeyInfo> <X509Data> <X509Certificate>MIIHvTCCB2ygAwIBAgIKdElm8QACAACrojAIBgYqhQMCAgMwggEwMRgwFgYFKoUDZAESDTExMTc3NDYyMTc5OTUxGjAYBggqhQMDgQMBARIMMDA3NzA2NzUyOTI5MSMwIQYDVQQJDBrQltC40YLQvdCw0Y8g0YPQu9C40YbQsCAxNjEcMBoGCSqGSIb3DQEJARYNbWFpbEB1Y212ZC5ydTELMAkGA1UEBhMCUlUxGzAZBgNVBAgMEjc3INCzLtCc0L7RgdC60LLQsDEVMBMGA1UEBwwM0JzQvtGB0LrQstCwMTIwMAYDVQQKDCnQpNCa0KMgItCT0KbQodC40JfQmCDQnNCS0JQg0KDQvtGB0YHQuNC4IjEdMBsGA1UECwwU0J7QntCa0KHQuNCa0JjQnNCi0KExITAfBgNVBAMMGNCj0KYg0JzQktCUINCg0L7RgdGB0LjQuDAeFw0xNTA4MjYxMjM4MDBaFw0xNjExMjYxMjUzMDBaMIIBHjEYMBYGBSqFA2QBEg0xMDM3NzAwMDI5NjIwMRowGAYIKoUDA4EDAQESDDAwNzcwNjA3NDczNzEgMB4GCSqGSIb3DQEJARYRbGVzbmlrb3ZAZ2liZGQucnUxCzAJBgNVBAYTAlJVMSEwHwYDVQQIHhgANwA3ACAEMwAuACAEHAQ+BEEEOgQyBDAxFTATBgNVBAceDAQcBD4EQQQ6BDIEMDEdMBsGA1UECh4UBBwEEgQUACAEIAQ+BEEEQQQ4BDgxJTAjBgNVBAseHAA5ACAEPgRCBDQENQQ7ACAEEwQjBB4EEQQUBBQxNzA1BgNVBAMeLgQkBBgEIQAgBBMEGAQRBBQEFAAgACIEEAQ0BDwEPwRABDAEOgRCBDgEOgQwACIwYzAcBgYqhQMCAhMwEgYHKoUDAgIkAAYHKoUDAgIeAQNDAARAS8pELLqOpBHWtBof+1/QbVIln72inDxYm8525+N/NrxhxNMjff9j58v/6mweVR88armYn6MaB5AJ0Wn0PgRt36OCBHIwggRuMA4GA1UdDwEB/wQEAwIE8DAmBgNVHSUEHzAdBggrBgEFBQcDBAYHKoUDAgIiBgYIKwYBBQUHAwIwHQYDVR0OBBYEFHpm9t7FAzHwQmOAoOpYKVrnOxlrMIIBcQYDVR0jBIIBaDCCAWSAFDU6ZTbjMUnpcJ7wYUJ9cA83im9AoYIBOKSCATQwggEwMRgwFgYFKoUDZAESDTExMTc3NDYyMTc5OTUxGjAYBggqhQMDgQMBARIMMDA3NzA2NzUyOTI5MSMwIQYDVQQJDBrQltC40YLQvdCw0Y8g0YPQu9C40YbQsCAxNjEcMBoGCSqGSIb3DQEJARYNbWFpbEB1Y212ZC5ydTELMAkGA1UEBhMCUlUxGzAZBgNVBAgMEjc3INCzLtCc0L7RgdC60LLQsDEVMBMGA1UEBwwM0JzQvtGB0LrQstCwMTIwMAYDVQQKDCnQpNCa0KMgItCT0KbQodC40JfQmCDQnNCS0JQg0KDQvtGB0YHQuNC4IjEdMBsGA1UECwwU0J7QntCa0KHQuNCa0JjQnNCi0KExITAfBgNVBAMMGNCj0KYg0JzQktCUINCg0L7RgdGB0LjQuIIQDo7FE3v5nLFBgHufg8NDXzCB7AYDVR0fBIHkMIHhMEqgSKBGhkRodHRwOi8vd3d3LnVjbXZkLnJ1L2NybC8zNTNBNjUzNkUzMzE0OUU5NzA5RUYwNjE0MjdENzAwRjM3OEE2RjQwLmNybDBIoEagRIZCaHR0cDovL2NkcC5tdmQucnUvY3JsLzM1M0E2NTM2RTMzMTQ5RTk3MDlFRjA2MTQyN0Q3MDBGMzc4QTZGNDAuY3JsMEmgR6BFhkNodHRwOi8vY2RwMi5tdmQucnUvY3JsLzM1M0E2NTM2RTMzMTQ5RTk3MDlFRjA2MTQyN0Q3MDBGMzc4QTZGNDAuY3JsMD8GCCsGAQUFBwEBBDMwMTAvBggrBgEFBQcwAoYjaHR0cDovL3d3dy51Y212ZC5ydS9jZXJ0L3VjX212ZC5jcnQwNgYFKoUDZG8ELQwrItCa0YDQuNC/0YLQvtCf0YDQviBDU1AiICjQstC10YDRgdC40Y8gMy42KTArBgNVHRAEJDAigA8yMDE1MDgyNjEyMzgwMFqBDzIwMTYxMTI2MTIzODAwWjAdBgNVHSAEFjAUMAgGBiqFA2RxATAIBgYqhQNkcQIwgesGBSqFA2RwBIHhMIHeDCsi0JrRgNC40L/RgtC+0J/RgNC+IENTUCIgKNCy0LXRgNGB0LjRjyAzLjYpDFMi0KPQtNC+0YHRgtC+0LLQtdGA0Y/RjtGJ0LjQuSDRhtC10L3RgtGAICLQmtGA0LjQv9GC0L7Qn9GA0L4g0KPQpiIg0LLQtdGA0YHQuNC4IDEuNQwt0KHQpC8xMjQtMjIzOCDQvtGCIDA0INC+0LrRgtGP0LHRgNGPIDIwMTMg0LMuDCvQodCkLzEyOC0yMzUxINC+0YIgMTUg0LDQv9GA0LXQu9GPIDIwMTQg0LMuMAgGBiqFAwICAwNBAAoGprgiVLghTeR95YY7DbLuuasvGarGcwhqSdbqonzt5JCZcvwT/CzwiWpccNlJk7u9focThUocaVIm7AXhhek=</X509Certificate> </X509Data> </KeyInfo> </Signature> </chg:Charge> </pir:Document> </pir:Package> </msgd:ImportRequest> </gisgmp:RequestMessage> </rev:AppData> </rev:MessageData> </smev:GISGMPTransferMsg> </soapenv:Body> </soapenv:Envelope> ... |
|||
:
Нравится:
Не нравится:
|
|||
28.06.2017, 10:37 |
|
|
start [/forum/topic.php?fid=45&gotonew=1&tid=1612308]: |
0ms |
get settings: |
10ms |
get forum list: |
16ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
44ms |
get topic data: |
14ms |
get first new msg: |
8ms |
get forum data: |
3ms |
get page messages: |
43ms |
get tp. blocked users: |
2ms |
others: | 21ms |
total: | 167ms |
0 / 0 |