Skip to main content
Dani Szwarc
Dani Szwarc
Inspiring
July 4, 2019
Answered

CFFTP, xmlParse() and "Content Is Not Allowed In Prolog"

  • July 4, 2019
  • 1 reply
  • 767 views

Hello community, first of all, for all of you in US, happy 4th of July!

I am having an issue I need some help with: I need to connect to an sFTP server, retrieve the list of XML files (files will be placed there for CF to do something with them) and then loop through the contents of these XML files and insert the values into a database.

This is what I do: I open the connection and ask for the list of files using CFFTP. That works perfectly. Now, when I use xmlParse() to retrieve the XML content, when the file is in this sFTP server, I get the error "Content Is Not Allowed In Prolog". If the same file I place it on my own website for testing, then contents are shown without any issue.

From the image, is line 30 where I tell CF where the file is located.

I have tried BenNadel​'s post about this issue (Content Is Not Allowed In Prolog - ColdFusion XML And The Byte-Order-Mark (BOM) ) but didn't work. Using this suggestion the error says "Premature End of File".

The XML file I am testing with is the same in both locations.

Any help will be highly appreciated.

This topic has been closed for replies.
Correct answer Dave Watts

I'm pretty sure that CFFTP doesn't let you remotely read files. It lets you fetch the files to your own server, where you can do what you like with them. So you'll need to fetch all of the files to your local server, then loop over the directory where you put them to read the files with xmlParse. If the files have a valid HTTP path on the remote server, then you could dispense with CFFTP entirely and fetch them via HTTP instead.

Dave Watts, Eidolon LLC

1 reply

D
Dave WattsCorrect answer
Community Expert
July 4, 2019

I'm pretty sure that CFFTP doesn't let you remotely read files. It lets you fetch the files to your own server, where you can do what you like with them. So you'll need to fetch all of the files to your local server, then loop over the directory where you put them to read the files with xmlParse. If the files have a valid HTTP path on the remote server, then you could dispense with CFFTP entirely and fetch them via HTTP instead.

Dave Watts, Eidolon LLC

Dave Watts, Eidolon LLC
    Dani Szwarc
    Dani SzwarcAuthor
    Inspiring
    July 4, 2019

    Thank you Dave for you reply. Not able to connect now for some reason but will try your recommendation.

    I appreciate your time to answer.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices