| | 447 | The S3XML importer can represent uploaded single-sheet CSV files in a very simple XML format, whereby it becomes available for transformation into S3XML and import into Sahana-Eden. |
| | 448 | |
| | 449 | The CSV must use comma , as separator, and double quotation marks " to quote strings. The first row in the CSV file is used as column headers, all other rows represent the records: |
| | 450 | |
| | 451 | {{{ |
| | 452 | First Name,Last Name,Email |
| | 453 | "Manfred","Breitklopper","manfred@example.com" |
| | 454 | }}} |
| | 455 | |
| | 456 | When uploading such a file using the '''.s3csv''' format extension, this gets converted by the interface into XML: |
| | 457 | |
| | 458 | {{{ |
| | 459 | <table> |
| | 460 | <row> |
| | 461 | <col field="First Name">Manfred</col> |
| | 462 | <col field="Last Name">Breitklopper</col> |
| | 463 | <col field="Email">manfred@example.com</col> |
| | 464 | </row> |
| | 465 | </table> |
| | 466 | }}} |
| | 467 | |
| | 468 | ...which can then be transformed for import using the normal on-the-fly transformation method. |
