CSV Email Format

A restricted format for use with specialised non windows applications.

Header. The first 2 lines of the file:

"# Order No, xxxxxxxx,  Date, dd/mm/yyyy,  Company, xxxxxxxxxxxxx"

"# Del Date, " xxxxxxxx,  Job Address, xxxxxxxxxxxxxxxxxxxxxxx

for each item in the order:

,[not used],[Item Code],[Description],[Quantity],[Units],[Unit Price],[Price]

Notes

Alpha fields may be enclosed in quotes "……."

If there is a workup, it is appended to the description between square brackets.

Multi-line descriptions or workups have linefeeds replaced with "[LF]"

[Item Code] is user-selectable between internal code, suppliers code or a combination of both

example

"# Order No, 1000/001.2,  Date, 25/12/2003,  Company, Beta Builders"

"# Del Date, ASAP,  Job Address, Lot 99 Smith st[LF]Jonestown

, ,001,Gizmos,3,each,1.5,4.5

, ,Pine9035,90x35 pine:[3/2.4 2/3.0],13.2,lin m,2,26.4