Error: FileID does not match in the FileHeader

[TR]

Hello Fellow Alteryxers,

I've created multiple .yxdb's using the Download Tool. The content is page html from multiple pages (for this exercise 4 pages, each representing a state). The Output is 'To a File' using 'Filename from a Field' (the path and filename.yxdb is included in the field). When I add the .yxdb's to an empty workflow I see the following.

Thanks for your suggestions in advance!

Todd

DownloadData saved to .yxdb (1 of 4 .yxdb's in export)

Download Tool details.

Files (with differing sizes) shown in MS Explorer.

Screenshot of all 4 .yxdbs (unable to view contents)

[BenMoss]

The reason for this is when you download data is is given a form. Usually .csv, .xml or .json.

You must use the same suffix as the expected type.

I only know this because I had this exact issue the other day!

Ben

[TR]

Hey thanks Ben, if you were downloading html what type were you defining it to save as? Remember, I'm defining the filename so I have to set it in the Formula Tool. I've been trying different formats but haven't figured out which is correct.

[BenMoss · Accepted solution]

Have you tried .html?

You can then import it as an undelimited .csv file and work with accordingly.

Alternatively download it to a temp file and see if that automatically detects the type.

Ben

[TR]

Ahhh, I recall using that method. So I was able to change it to .xml and decided to go with your suggestion of using .html. The tool that helps all of this work is the Dynamic Input Tool. Once the .html files are created for each page I then use the Dynamic Input Tool to select them using *.html. When the "Resolve File Type" popup opens I select the following: 

The key is using these settings.

Thanks @BenMoss for knocking off some rust, and hopefully this helps someone in the future,

Todd