moqui/moqui-framework

EntityDataLoader only works with CSV if the location ends with ".csv"

Opened this issue · 0 comments

The trailing '#extension.csv' is a hack, to get around the loadSingleFile extension checking logic. In an ideal situation, the resource facade would return a tuple, the contentType+inputstream of the target.

In the following url, key is the random sheet identifier, and gid is the sub-tab(default of 0 for the first tab that is created).

I don't have a patch at this time, as a proper fix would probably be quite a bit of code.

            <script><![CDATA[
                loader = ec.entity.makeDataLoader()
                loader.csvEntityName(serviceName)
                loader.location("https://docs.google.com/spreadsheets/d/${key}/export?format=csv&gid=${gid}#extension.csv")
                loader.load()
            ]]></script>