![Ranking tracking](https://cdn1.cdnme.se/5447227/9-3/15_64e61dfcddf2b36505b4c7c9.png)
For bigger fixes you should use the tools that you used to create the csv-file to begin with. You can easily fix small errors within the converter. Errors are also available in a log file ( Tools / Open log file). Errors (line and column) will also show in red color in the lower grid and by double clicking marked field you will see the details of the error. Error messages will show in a popup window. When you press the Validate Sourcedata button program checks that all mandatory information is in place, ISSN and ISBN numbers are formatted correctly and column datatype and field lengths match those in a XML (schema) specification.Ĭonverter can fix some common errors automatically and it will report all of the errors that need work form the operator. In this step lot of additional checks are performed to make sure data it is ready to be transformed into XML. Convert & Validate CSV sourcedataĪfter successful completion of step 1 the csv will be transformed into lower grid when you press the Convert CSV sourcedata btutton. If the program reports an error please refer to the Errors section at the end of this document. If csv file is valid and saved in UTF-8 format, there is a notification from the program and you can move into the next step. Otherwise converter will not work properly. It is important that columns are in the same order and named exactly the same as in template file. Select CSV file that is based on a example (eu_model.csv). When you start working with your own data start with small set of publications first so the amount of possible errors stays manageable.ĬSV to XML transformation happens in 6 steps 1.
![csv converter csv converter](https://cdn.ilovefreesoftware.com/wp-content/uploads/2017/05/DTM-text-to-JSON-converter-convert-CSV.png)
Example also contains couple of intentionally inserted faulty ISSN and ISBN codes so you can also test how to fix possible errors. It can also be used as a template to create your own CSV files. You can test the functionality of this converter using that example. Zip packet contains CSV to XML converter tool ( CSV2XMLConverter.exe) and under data directory one example CSV (eu_model.csv).
![Ranking tracking](https://cdn1.cdnme.se/5447227/9-3/15_64e61dfcddf2b36505b4c7c9.png)