1. Before adding data from a spreadsheet such as Microsoft Excel you must first save your data as a CSV file (Comma Separated Values). This is a text format where the values in the cells of your spreadsheet are separated by commas.
2. Go to the Silva Management area and create a CSV Source via the select list.
Note: if you do not see Silva CSV Source in the list ask your web host to install the Silva External Sources product into the Products area of Zope.
3. Fill in the id and title and the "character coding" for your CSV file. If you're not sure what the coding is, leave it as the default 'latin1'. If your text has accented characters and they don't display correctly in “public preview...”, try one of the other encodings. If your encoding doesn't appear in the select list – say your content is in Chinese – you can type it into the designation field. Then click save.
If you click on save and edit you will be taken to an area with four more forms. This is useful because you can give a description of your uploaded data or you can upload here if the data needs updating or if you simply wish to check the uploaded code.
Congratulations, you now have imported your spreadsheet data.
4. In the Silva Management Area an Author can now access this asset and place it inside a document. In the Forms Editor add an element to the document, and select an “external source” from the list.
5. In the edit form, select the asset from the drop down list and click update.
6. You are then given some more options. You can choose a table style from the drop down list. Also you can enter the batch size. The batch size enables you to split up a large file into a number of pages. If you want 25 items per page you would put 25 in the batch size form.
7. To view the data click on public preview....
8. Publish the document.
Changes to the data of the CSVSource are done by uploading a new set of data or editing the raw data via the edit screen. A re-publication of the document is not necessary.
The table layout is the standard table layout Silva uses for its tables. But there is, as always, the possibility to modify the page template which creates the html table.
© Copyright 2002-2004 Infrae.
All rights reserved. 
