when using the new CSVWrite function, and arrayOf ...
# adober
raymondcamden
05/13/2025, 3:46 PMwhen using the new CSVWrite function, and arrayOf Structs, there appears to be no way to associate a struct key with a header. So for example, if my headers are ["Name","Age"] and i have an array of structs that have a Name and Age value, CF doesn't properly put the right data under the right header
raymondcamden
05/13/2025, 4:12 PMan ordered struct seems to help
raymondcamden
05/13/2025, 4:20 PMexcept - crap - it doesnt 😕
raymondcamden
05/13/2025, 4:25 PMso here's the issue from what i can tell. when i read in a csv file as an array of structs, append a new ordered array, and save - the NEW record works perfectly but the old records are randomly placed 😕
raymondcamden
05/13/2025, 4:34 PMyeah, i can reproduce this
raymondcamden
05/13/2025, 4:38 PMmaybe 😉 need to eat and reconsider
n
Nikhil Dubey
05/14/2025, 4:24 AMcan you provide a test case and sample output for this?
âž• 1
b
BK BK
05/14/2025, 10:44 AMHere is a test case:
<!--- ******* Beginning of code ******* ---><cfset data=[{header1:"Position", header2:"Team Name", header3:"League Points"}, {data1:"1st", data2:"Sporting Club", data3:"97"}, {data1:"2nd", data2:"The Lions", data3:"86"}]><cfset csvWrite(data,"arrayofstruct",expandpath("testcsvWrite.csv"))>Done: CSV file written to current directory.<!--- ******* End of code ******* --->