Local XML file downloaded from https site wont import

[Cabinetman]

Frustrated !!

 

I'm downloading an XML feed submission results file from Amazon using Scriptmaster (since the site now uses https for MWS) and saving the file to the local drive. I'm then attempting to import the saved XML file using an stylesheet on my site.

 

I was able to do this initially but now I keep getting the same error :

"An exception occurred! Type:RunTimeException, Message: The primary document entity could not be opened. Id=C:........"

 

I can't figure out what changed or why the problem.

 

Any ideas or comments are appreciated .........

 

Sample XML

<?xml version="1.0" encoding="UTF-8"?>
<AmazonEnvelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="amzn-envelope.xsd">
    <Header>
        <DocumentVersion>3.00</DocumentVersion>
        <MerchantIdentifier>M_IDENTIFIER</MerchantIdentifier>
    </Header>
    <MessageType>ProcessingReport</MessageType>
    <Message>
        <MessageID>1</MessageID>
        <ProcessingReport>
            <ProcessingReportType>Relationship</ProcessingReportType>
            <DocumentTransactionID>6781234567</DocumentTransactionID>
            <Summary MarketplaceName="Amazon.com">
            <StatusCode>Complete</StatusCode>
            <ProcessingSummary>
                <MessagesProcessed>3</MessagesProcessed>
                <MessagesSuccessful>3</MessagesSuccessful>
                <MessagesWithError>0</MessagesWithError>
                <MessagesWithWarning>0</MessagesWithWarning>
            </ProcessingSummary>
            </Summary>
        </ProcessingReport>
    </Message>
</AmazonEnvelope>
 

 

 

 

 

[Wim Decorte]

At the end of that error message there seems to be a reference to something on the C drive...  What's that?  Can you post the full error?

[Cabinetman]

It's the path to the file as saved on my drive ..... presumably.

 

I can't view the entire thing but the first part is correct as far as I can read ............. C:UsersRobDesktop......

 

And just to add .....

I know that FM 10 wont import from https sites so I'm wondering if that can in any way affect even a saved file.

[Wim Decorte]

Do you still have a file from when it used to work to try again?  If it still works, compare the XML structure, check the encoding on the downloaded file...

[Cabinetman]

No I don't .... it was overwritten.

 

It's been a bit but I think initially I may have done a copy paste and saved as the file to run tests on for import ... when it worked. I've done so much I just can't recall.

 

What I do know now is that I'm downloading a results file from Amazon but can't import it due to the error.

 

BTW - This is really aggregating !! I had no issues while writing the xsl for it, which took a bit of trial and error, on the importing !!

[Wim Decorte]

I'm guessing that it is not recognized as a valid XML file which is why I asked about the encoding.  Try what you did before with copy/paste and manually saving the file, see how that file is encoded vs. the one that gets downloaded.

[Cabinetman]

Well I'm losing it ............ A different feed submission report downloaded the exact same way is importable but no records show now when attempted. I'm lost.

 

I'm attaching the 2 files and the xsl ...........

VariationsSubmissionResults.zip

[Karsten Wolf]

  On 3/22/2013 at 2:10 AM, Cabinetman said:

Well I'm losing it ............ A different feed submission report downloaded the exact same way is importable but no records show now when attempted. I'm lost.

 

I'm attaching the 2 files and the xsl ...........

 

The xsl won't work with the provided XMLs. It's referencing "Result" in

 

 

 

<xsl:for-each select="AmazonEnvelope/Message/ProcessingReport/Result">


 

 

which does not exist.