|Home Page||Screenshots||Purchase Info||Installation||Support|
Click on a question to display support information! Click it again to hide the information.
You can add a typical data-type attribute declaration to your elements during the creation of your configuration file within the Expert Configuration Dialog. Simply type your attribute name=value pair after your element name. Remember to surround the value in quotes. Later, during the configuration process, you will need to add a namespace declaration to your root element declaration.
A namespace declaration and a data-type attribute declaration are shown here...
See the Expert Tutorial from the My CSV to XML Converter Help Menu for additional instructions and view the finance.xml file to see a working example.
When properly unzipped, there will be a few sub-directories that are visible when you expand the C:\csv2 directory you created when before downloadiing the zipped program files.
Sometimes, itis not clear how your unzip program will create the file hierarchy as it unzips the program files. Some programs will unzip the files into your target directory. Other unzip programs will create a second directory named csv2 and copy the files into that new directory. This will cause program startup problems.
If this occurs, the easiest solution is to select and cut all the program files in the second csv2 directory and paste them into the original csv2 directory you were asked to create before downloading the zipped program files. You can then delete the empty second csv directory.
A proper installation of Java on your computer should set your PATH variable correctly. If your Java installation did not properly set your path information, a SET PATH= line must be added to the csv-xml-converter.bat file and must be set to the folder that contains the javaw.exe file. If you are using Windows, search your hard drive for the file named javaw.exe, the search results will display the path to the folder containing this file. This is the path you need. A typical typical path looks like this:
and therefore the set path line would look like this:
SET PATH=C:/Program Files/Java/jre1.5.0_02/bin
The SET CLASSPATH= must be set to the folder that contains your unzipped files. If you have unzipped your files into the C:\csv2 folder as recommended you should not need to modify this line, and the line should look like this:
SET CLASSPATH=C:\csv2 (this is not the letter L, but instead the number one)
NOTE: When setting paths in the csv-xml-converter.bat file, you may use either forward slashes or backward slashes to separate directories on a Windows machine.
This is likely due to installing the My CSV to XML Converter into a folder other than the recommended folder. Simply locate the setting.properties file in the setup directory and open it with a text editor. Change the right-side of the installationPath= line so it contains the path to the folder where you have installed your program files.
Alternatively, read the instructions on unzipping difficulties.
NOTE: You must use forward slashes (not backslashes) to separate folders in you path while in the settings.properties file!
A successful conversion will result in the words "XML file is ready!" appearing in red text at the bottom of the GUI interface. When this does not occur, it generally signals an error in the configuration file syntax or a problem in the .csv file itself. Try these tips below.
When creating a .csv file from some spreadsheet programs, empty cells in either the first or last columns of data disrupt the creation of commas needed to separate fields. If you have empty cells in these columns, use the find/replace function to search for these empty cells and fill them with a space (or some other text). Then save your file as a .csv file and try again.
It is also common for data in a comma-separated-value file to inproperly include commas. For example, if a field includes both city and state, the two pieces of data will often be separated by a comma. This will cause a problem as the program expects that commas will only be used to separate fields of data, unless the comma is contained within a pair of double-quotes..
Other characters to avoid in your data are shown below. In general, avoid unusual characters in your data whenever possible.& < > \ ' ~ `Finally, review the configuration file to assure that all parameters are set correctly. Sometimes with complicated configuration files, this can be tricky. Consider making a very simple configuration file and then an xml conversion to test the .csv file for correctness. If a simple transform works correctly, your csv file is fine.
If you need to open the settings.properties file, you can do so by using a text editor. For example, if you are using Windows, open the Notepad program. This can generally be found on your Start menu, under Programs and then perhaps Accessories (this depends on what version of Windows you are using).
Once Notepad is running, click File and then click Open. This should open a dialog box. Look for a "drop-down" box near the bottom labeled Files of type:" and click on the arrow. Select All Files. Then, using the drop-down box near the top labeled Look in:, locate the directory in which My CSV to XML Converter is installed. Locate the setup directory and then double-click on the setting.properties file to open it.
The need for modifying the settings.properties file occurs when the My CSV to XML Program is installed in a directory other than the intended directory. This sometimes occurs when the unzip program creates a second csv2 directory under the csv2 directory we recommend that you create before downloading our program.
No problem! Look for the directory named backup in your installation folder. It contains backups of all the set up files as well as other sample sets of csv/xml/cfg files you may want to explore.
Yes, but you should only do this if you are familar with file path terminology.
Unzip the program files into any existing directory. Then, read the installation.txt file in the help directory for instructions on modifying the batch and properties files to reflect your installation directory.
My CSV to XML Converter does not make any changes to your registry or install any dynamic libraries onto your computer. To uninstall, simply delete the directory you created at the time of installation.
This depends on what type of driver you have installed on your computer. Installation of a Type IV driver allows both remote and local database access. You can learn more about JDBC Drivers at JDBC-Tutorials Types of Driver page.
This depends on what type of driver you have installed on your computer. Installation of a Type IV driver allows both remote and local database access. Type IV driver's are specific for each brand of database so you should download the driver with the database program.
Complex conversions require that you understand the how to designate the parameters for each of your XML elements or attributes. Doing this one element at a time is not hard once you understand the terminology explained in the tutorials. However, you may find our Complex Sample Instructions helpful. Some practice is necessary for sure, but start simple and work your way up and you will be successful.
My CSV to XML Converter has been tested on a modest 1.6 GHz Window XP computer with Java 1.4 using CSV files sizes as large as 3 Megs. A typical file of this size can easily have nearly 1/2 million cells of data, and may bog down your browser but not the My CSV To XML Converter program!
My CSV to XML Converter support is available via email at firstname.lastname@example.org. Please let us know of any difficulties you have with installation or program performance. We will work to resolve these difficulties quickly.
General questions and suggestions are welcome at email@example.com.
Back to the top
Click here to return to My CSV to XML Converter home page...