This section should demonstrate several common tasks which can be done in XiMpLe with a minimal effort.
For more information please see the user's guide which is available in the section download.
Example 1. Copy texts from a simple xml table to Excel
Example 2. Adding new rows prepared in Excel to the XML table
Example 3. Copy a part of an xml document to some other place
Example 4. Manipulate data nested inside a structure
Example 5. Create a table from csv file
Example 6. Remove table rows matching some criteria
Example 7. Split a bigger xml file then join fragments together
5. Create a table from csv fileLet's have some csv file. Open it in some text editor (like notepad). We can open it in XiMpLe too. Of course we get an error message that the file is not well-formed xml file but we need only a text editor for now.
Copy the first row (headings) to the clipboard (Ctrl+C). Data in the csv are usually separated by a comma character so we have to set the separator in XiMpLe general setting (menu Settings/General...) for pasting (a separator can be set even to a string if necessary).
Now we need to create a new table in a destination xml file.
Before a new table is created we have to set parameters for this table: a name and a number of columns. If we have already copied headings from csv to clipboard we can see a hint in the top right corner how many columns we need for a new table.
A new table is created with two empty rows. The columns currently have some predefined column names.
A column headings can be overwritten by data stored in clipboard. Don't forget that not all characters are allowed for element names - not allowed characters are replaced by an underscore character.
Headings are set according the clipboard data.
Now we need to select csv data in a text editor and copy it to clipboard. Then we can paste them to the table. If the last row is selected data are appended at the end of the table.
Finally we select first two empty rows and delete them to complete our work.