Results 1 to 5 of 5
  1. #1
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Invoices in XML Form (2003)

    Have you tried Excel? Of all the Office applications, it seems most likely to be able to parse the document.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Invoices in XML Form (2003)

    I have downloaded invoices in XML form from a web trader portal, I attach an example invoice and the associated dtd, is there any way to see it from within the office suite?
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Invoices in XML Form (2003)

    Hi Jefferson, I can import the xml file into Access but the following, very important, bit of info, gets left out:
    <odn num="508001475889"> which is the invoice number. Do you know how to get that into Access as well?
    I've also right-clicked the xml file and selected Open With and then selected XML Editor but I get the following message:
    <!DOCTYPE edi_l SYSTEM "insert the local path of the DTD file">
    How do you insert the local path of the DTD file?

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Invoices in XML Form (2003)

    <hr>Hi Jefferson, I can import the xml file into Access but the following, very important, bit of info, gets left out:
    <odn num="508001475889"> which is the invoice number. Do you know how to get that into Access as well?<hr>
    No, I suspect Access is not the best tool for XML files that have more than one "table."

    <hr>I've also right-clicked the xml file and selected Open With and then selected XML Editor but I get the following message:
    <!DOCTYPE edi_l SYSTEM "insert the local path of the DTD file">
    How do you insert the local path of the DTD file?<hr>
    <code><!DOCTYPE edi_l SYSTEM "inserire il percorso locale della DTD"> </code> is the second line in the XML file itself.

    Apparently you need to save the .dtd file to a convenient folder on your PC and replace the "quoted_portion" with the "path_to_file" for that location.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Invoices in XML Form (2003)

    <hr>No, I suspect Access is not the best tool for XML files that have more than one "table."<hr>
    Thank you Jefferson, so what tool do you suggest we should adopt to get hold of that missing bit? We only have Office installed on our pc's. The invoice emitter used to send us Excel files containing all the invoices data up to December 2007 but those have been superseded by these xml files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •