Hi everyone,
I’m trying to export Assets record data from SunSystems Cloud using Transfer Desk, and my goal is to produce a properly formatted CSV file.
I’ve already tried creating both a Transformation (TML) and a Format (FSD) — following the Delimited data format documentation — but the exported file still only contains one record, even though the source XML includes multiple <Asset> entries.
I’ve checked:
- The Format (FSD)
Data record has max-occur="0" - Field mappings are using relative paths (e.g.,
Asset Code, Description, etc.)
Has anyone successfully exported multiple asset records from SSC （Fixed Asset module） into a CSV file via Transfer Desk?
I’d appreciate if someone could share an example FSD/TML setup or confirm the correct configuration.
Thanks in advance!
Format Designer | <?xml version="1.0" encoding="UTF-8" standalone="no"?><schema xmlns="http://www.systemsunion.com/2001/TD/SSTransform/fsd/" version="1.0">
<sequence min-occur="0" name="FMT_FA_EX_CSV">
<record min-occur="1" name="Header" output="no" record-sep="\r\n">
<field default-value="AssetCode" field-sep="," name="AssetCode" output="no"/>
</record>
<record max-occur="0" min-occur="0" name="Data" record-sep="\r\n">
<field field-sep="," name="AssetCode"/>
</record>
</sequence>
</schema>
|
|---|
Transformation | <?xml version="1.0" encoding="utf-8" standalone="no"?><transformation output-encoding="UTF-8">
<map>
<target>FMT_FA_EX_CSV/Data/AssetCode</target>
<source>SSC/Payload/Asset/AssetCode</source>
</map>
</transformation>
|
