2 Replies Latest reply on Feb 5, 2014 9:30 PM by Tim Webb

    XML Files won't import

    John Tonks

      Hi all

       

      I have a large number of CAL files to manage in ePDM for which  the data is contained in an Access database.

       

      My thought was to use Access and a bit of VBA code to create xml files and to import the data via the XML Import facility of ePDM.

       

      My trouble is I can't get the system to read the XML file.

       

      I have set the Import Rule to look in a folder on my C drive and a folder in the Vault but that seems to make no difference.

       

      I have structured a test XML file (see attachment and image below) as per the example in the admin guide and just replaced their variables with mine.

       

      Can any one see anything obviously wrong with this code?

      Can anyone give me some hints on how to trouble shoot this.  Is there a way to verify that the database server can see folder where the xml file is and that it is trying to read the file?

       

      The variable that I am using to match the file is "File Name" and I have a test file with this variable on a datacard.  The variables that I am trying to update are "Code No" and "Description Line 1".

      xml capture.JPG

      I did contact our local reseller for some help however they said it was a custom programming issue and wanted $2k per day to solve it.  If I can get the system to read the import file than this cost will be avoided.

       

       

      Thanks in anticipation

       

      John

      Ballarat, Australia

        • Re: XML Files won't import
          Tim Webb

          Run the import on the archive server not on a client computer. Also make sure the variables you want to import are "mapped" to custom properties and that they do exist on the data card for the files you are updating

           

          This will get you started. I've recently debugged this thoroughly with solid works and have been developing an XML connector for ERP import.

           

          I can also consult at a much more competitive rate

           

          Hope this helps

          Tim CEPA

          www.equivaq.com

          • Re: XML Files won't import
            Tim Webb

            John,

             

            By the way, I am unable to see the image on your post. I am doing some development tonight working late in the office for the next 3 hours so go to my site & get my contact info. I'm sure we can get you going quickly at no charge.

             

            Tim CEPA

            http://www.equivaq.com