Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit87aaf9a

Browse files
author
A. Apesteguia
committed
Major update
1 parentf405b34 commit87aaf9a

File tree

7 files changed

+120
-98
lines changed

7 files changed

+120
-98
lines changed

‎README.md‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,8 @@
33
* Uses the traditional methodology to generate the xml (without a library), through
44
of nodes and tree structure.
55
* Can read ANY CSV File
6-
6+
* Args are: Input file, output file, element node name and optionally, if you add -s program will read the csv
7+
as semicolon-separated values instead of comma-separated values.
78
##Project test
89

910
###CSV Input File

‎examples/Grades.xml‎

Lines changed: 34 additions & 34 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
22
<root>
3-
<elements>
4-
<element>
3+
<Jhonnys>
4+
<Jhonny>
55
<Lastname>Alfalfa</Lastname>
66
<Firstname>Aloysius</Firstname>
77
<SSN>123-45-6789</SSN>
@@ -11,8 +11,8 @@
1111
<Test4>83.0</Test4>
1212
<Final>49.0</Final>
1313
<Grades>D-</Grades>
14-
</element>
15-
<element>
14+
</Jhonny>
15+
<Jhonny>
1616
<Lastname>Alfred</Lastname>
1717
<Firstname>University</Firstname>
1818
<SSN>123-12-1234</SSN>
@@ -22,8 +22,8 @@
2222
<Test4>97.0</Test4>
2323
<Final>48.0</Final>
2424
<Grades>D+</Grades>
25-
</element>
26-
<element>
25+
</Jhonny>
26+
<Jhonny>
2727
<Lastname>Gerty</Lastname>
2828
<Firstname>Gramma</Firstname>
2929
<SSN>567-89-0123</SSN>
@@ -33,8 +33,8 @@
3333
<Test4>40.0</Test4>
3434
<Final>44.0</Final>
3535
<Grades>C</Grades>
36-
</element>
37-
<element>
36+
</Jhonny>
37+
<Jhonny>
3838
<Lastname>Android</Lastname>
3939
<Firstname>Electric</Firstname>
4040
<SSN>087-65-4321</SSN>
@@ -44,8 +44,8 @@
4444
<Test4>45.0</Test4>
4545
<Final>47.0</Final>
4646
<Grades>B-</Grades>
47-
</element>
48-
<element>
47+
</Jhonny>
48+
<Jhonny>
4949
<Lastname>Bumpkin</Lastname>
5050
<Firstname>Fred</Firstname>
5151
<SSN>456-78-9012</SSN>
@@ -55,8 +55,8 @@
5555
<Test4>77.0</Test4>
5656
<Final>45.0</Final>
5757
<Grades>A-</Grades>
58-
</element>
59-
<element>
58+
</Jhonny>
59+
<Jhonny>
6060
<Lastname>Rubble</Lastname>
6161
<Firstname>Betty</Firstname>
6262
<SSN>234-56-7890</SSN>
@@ -66,8 +66,8 @@
6666
<Test4>90.0</Test4>
6767
<Final>46.0</Final>
6868
<Grades>C-</Grades>
69-
</element>
70-
<element>
69+
</Jhonny>
70+
<Jhonny>
7171
<Lastname>Noshow</Lastname>
7272
<Firstname>Cecil</Firstname>
7373
<SSN>345-67-8901</SSN>
@@ -77,8 +77,8 @@
7777
<Test4>4.0</Test4>
7878
<Final>43.0</Final>
7979
<Grades>F</Grades>
80-
</element>
81-
<element>
80+
</Jhonny>
81+
<Jhonny>
8282
<Lastname>Buff</Lastname>
8383
<Firstname>Bif</Firstname>
8484
<SSN>632-79-9939</SSN>
@@ -88,8 +88,8 @@
8888
<Test4>40.0</Test4>
8989
<Final>50.0</Final>
9090
<Grades>B+</Grades>
91-
</element>
92-
<element>
91+
</Jhonny>
92+
<Jhonny>
9393
<Lastname>Airpump</Lastname>
9494
<Firstname>Andrew</Firstname>
9595
<SSN>223-45-6789</SSN>
@@ -98,8 +98,8 @@
9898
<Test3>100.0</Test3>
9999
<Test4>83.0</Test4>
100100
<Final>A</Final>
101-
</element>
102-
<element>
101+
</Jhonny>
102+
<Jhonny>
103103
<Lastname>Backus</Lastname>
104104
<Firstname>Jim</Firstname>
105105
<SSN>143-12-1234</SSN>
@@ -109,8 +109,8 @@
109109
<Test4>96.0</Test4>
110110
<Final>97.0</Final>
111111
<Grades>A+</Grades>
112-
</element>
113-
<element>
112+
</Jhonny>
113+
<Jhonny>
114114
<Lastname>Carnivore</Lastname>
115115
<Firstname>Art</Firstname>
116116
<SSN>565-89-0123</SSN>
@@ -120,8 +120,8 @@
120120
<Test4>60.0</Test4>
121121
<Final>40.0</Final>
122122
<Grades>D+</Grades>
123-
</element>
124-
<element>
123+
</Jhonny>
124+
<Jhonny>
125125
<Lastname>Dandy</Lastname>
126126
<Firstname>Jim</Firstname>
127127
<SSN>087-75-4321</SSN>
@@ -131,8 +131,8 @@
131131
<Test4>36.0</Test4>
132132
<Final>45.0</Final>
133133
<Grades>C+</Grades>
134-
</element>
135-
<element>
134+
</Jhonny>
135+
<Jhonny>
136136
<Lastname>Elephant</Lastname>
137137
<Firstname>Ima</Firstname>
138138
<SSN>456-71-9012</SSN>
@@ -142,8 +142,8 @@
142142
<Test4>88.0</Test4>
143143
<Final>77.0</Final>
144144
<Grades>B-</Grades>
145-
</element>
146-
<element>
145+
</Jhonny>
146+
<Jhonny>
147147
<Lastname>Franklin</Lastname>
148148
<Firstname>Benny</Firstname>
149149
<SSN>234-56-2890</SSN>
@@ -153,8 +153,8 @@
153153
<Test4>80.0</Test4>
154154
<Final>90.0</Final>
155155
<Grades>B-</Grades>
156-
</element>
157-
<element>
156+
</Jhonny>
157+
<Jhonny>
158158
<Lastname>George</Lastname>
159159
<Firstname>Boy</Firstname>
160160
<SSN>345-67-3901</SSN>
@@ -164,8 +164,8 @@
164164
<Test4>-1.0</Test4>
165165
<Final>4.0</Final>
166166
<Grades>B</Grades>
167-
</element>
168-
<element>
167+
</Jhonny>
168+
<Jhonny>
169169
<Lastname>Heffalump</Lastname>
170170
<Firstname>Harvey</Firstname>
171171
<SSN>632-79-9439</SSN>
@@ -175,6 +175,6 @@
175175
<Test4>30.0</Test4>
176176
<Final>40.0</Final>
177177
<Grades>C</Grades>
178-
</element>
179-
</elements>
178+
</Jhonny>
179+
</Jhonnys>
180180
</root>

‎pom.xml‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -18,5 +18,11 @@
1818
<version>4.12</version>
1919
<scope>compile</scope>
2020
</dependency>
21+
<!-- https://mvnrepository.com/artifact/org.apache.commons/commons-lang3-->
22+
<dependency>
23+
<groupId>org.apache.commons</groupId>
24+
<artifactId>commons-lang3</artifactId>
25+
<version>3.11</version>
26+
</dependency>
2127
</dependencies>
2228
</project>
Lines changed: 38 additions & 32 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,6 @@
11
packagecom.codepressed.CSVtoXML;
22

3+
importorg.apache.commons.lang3.StringUtils;
34
importorg.w3c.dom.Document;
45
importjavax.xml.parsers.ParserConfigurationException;
56
importjavax.xml.transform.TransformerException;
@@ -9,48 +10,53 @@
910
publicclassMain {
1011
/**
1112
* Executes the CSV to XML conversion
13+
*
14+
* @param args Input file, output file, elements names and csv type.
1215
* @author Daniel Apesteguia Timoner
13-
* @param args Input file, output file and elements names.
1416
*/
15-
publicstaticvoidmain(String[]args){
17+
publicstaticvoidmain(String[]args){
1618
//Arg validator
17-
if(args.length ==0)
18-
{
19+
if (args.length ==0) {
1920
System.out.println("You didn't type any args.");
2021
System.exit(0);
2122
}
22-
try {
23+
//Vars Initialization
24+
StringcsvFile =args[0];
25+
StringxmlFile =args[1];
26+
StringelementName;
27+
StringcsvSplit =StringUtils.EMPTY;
2328

24-
//Vars Initialization
25-
StringcsvFile =args[0];
26-
StringxmlFile =args[1];
27-
StringelementName;
28-
try{
29-
elementName =args[2];}
30-
catch (ArrayIndexOutOfBoundsExceptione){
31-
System.out.println("You didn't especify any element so we will fix 'element' as parental node.");
32-
elementName ="element";
29+
try {
30+
elementName =args[2];
31+
}catch (ArrayIndexOutOfBoundsExceptione) {
32+
System.out.println("You didn't especify any element so we will fix 'element' as parental node.");
33+
elementName ="element";
3334
}
3435

36+
try {
37+
if (args[3] =="-s")
38+
csvSplit =";(?=([^\"]*\"[^\"]*\")*[^\"]*$)";
39+
}catch (ArrayIndexOutOfBoundsExceptione){
40+
csvSplit =",(?=([^\"]*\"[^\"]*\")*[^\"]*$)";
41+
}
3542

36-
//ArrayList of ArrayStrings Generation with CSV
37-
ArrayList<String[]>elements;
38-
elements =newReader().CSVtoArrayList(csvFile);
39-
40-
//XML Doc Generation with ArrayList
41-
DocumentxmlDoc;
42-
xmlDoc =newTabularToXMLConverter().docBuilder(elements,elementName);
43-
TabularToXMLConverter.transformDocToFile(xmlDoc,xmlFile);
43+
try {
44+
//ArrayList of ArrayStrings Generation with CSV
45+
ArrayList<String[]>elements;
46+
elements =newReader().CSVtoArrayList(csvFile,csvSplit);
4447

45-
}catch (IOExceptione) {
46-
e.printStackTrace();
47-
System.out.println("File wasn't found, error: "+e);
48-
}
49-
catch (TransformerExceptione){
50-
System.out.println("Transformer error: "+e);
51-
}
52-
catch (ParserConfigurationExceptione) {
53-
System.out.println("Configuration error: "+e);
54-
}
48+
//XML Doc Generation with ArrayList
49+
DocumentxmlDoc;
50+
xmlDoc =newXMLDoc().docBuilder(elements,elementName);
51+
XMLTransformer.transformDocToFile(xmlDoc,xmlFile);
52+
}catch (IOExceptione) {
53+
e.printStackTrace();
54+
System.out.println("File wasn't found, error: " +e);
55+
}catch (TransformerExceptione) {
56+
System.out.println("Transformer error: " +e);
57+
}catch (ParserConfigurationExceptione) {
58+
System.out.println("Configuration error: " +e);
59+
}
5560
}
5661
}
62+

‎src/main/java/com/codepressed/CSVtoXML/Reader.java‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -7,9 +7,8 @@
77
publicclassReader {
88

99
//ArrayList Generation ArrayStrings with the CSV Data
10-
publicArrayList<String[]>CSVtoArrayList(StringcsvFile)throwsIOException {
10+
publicArrayList<String[]>CSVtoArrayList(StringcsvFile,StringcsvSplit)throwsIOException {
1111
ArrayList<String[]>elements =newArrayList<String[]>();
12-
StringcsvSplit =",(?=([^\"]*\"[^\"]*\")*[^\"]*$)";
1312
BufferedReadercsvReader =null;
1413
Stringline;
1514

Original file line numberDiff line numberDiff line change
@@ -1,21 +1,16 @@
11
packagecom.codepressed.CSVtoXML;
22

3+
importorg.apache.commons.lang3.StringUtils;
34
importorg.w3c.dom.Document;
45
importorg.w3c.dom.Element;
56
importorg.w3c.dom.Text;
67

78
importjavax.xml.parsers.DocumentBuilder;
89
importjavax.xml.parsers.DocumentBuilderFactory;
910
importjavax.xml.parsers.ParserConfigurationException;
10-
importjavax.xml.transform.*;
11-
importjavax.xml.transform.dom.DOMSource;
12-
importjavax.xml.transform.stream.StreamResult;
13-
importjava.io.File;
14-
importjava.io.FileNotFoundException;
15-
importjava.io.FileOutputStream;
1611
importjava.util.ArrayList;
1712

18-
publicclassTabularToXMLConverter {
13+
publicclassXMLDoc {
1914

2015
//DOC Generation -> XML with ArrayList String elements
2116
publicDocumentdocBuilder(ArrayList<String[]>XMLelements,StringelementName)throwsParserConfigurationException {
@@ -31,17 +26,17 @@ public Document docBuilder(ArrayList<String[]> XMLelements, String elementName)
3126
ElementmainElement =xmlDoc.createElement(elementName+"s");
3227
rootElement.appendChild(mainElement);
3328

34-
booleanheaderDefined =false;//First while will be to define header
35-
String[]header =newString[XMLelements.size()];//Header initialization
29+
booleanheaderDefined =false;
30+
String[]header =newString[XMLelements.size()];
3631

3732
//DOC Generation -> XML Generation of every ELEMENT
38-
for (String[]node :XMLelements) {//FOR every ArrayString
33+
for (String[]node :XMLelements) {
3934
if (headerDefined) {
4035
ElementnodesElements =xmlDoc.createElement(elementName);
4136
mainElement.appendChild(nodesElements);
4237

4338
for (intj =0;j <node.length;j++) {
44-
node[j] =node[j].replaceAll("\"","").trim();
39+
node[j] =node[j].replaceAll("\"",StringUtils.EMPTY).trim();
4540
ElementnodesValues =xmlDoc.createElement(header[j]);
4641
nodesElements.appendChild(nodesValues);
4742
TextnodeTxt =xmlDoc.createTextNode(node[j]);
@@ -52,7 +47,7 @@ public Document docBuilder(ArrayList<String[]> XMLelements, String elementName)
5247
else {
5348
header =node;
5449
for (intj =0;j <node.length;j++) {
55-
header[j] =header[j].replaceAll("[^a-zA-Z0-9]","");
50+
header[j] =header[j].replaceAll("[^a-zA-Z0-9]",StringUtils.EMPTY);
5651
//Avoid a fullint
5752
try {
5853
Integer.parseInt(header[j]);
@@ -66,22 +61,5 @@ public Document docBuilder(ArrayList<String[]> XMLelements, String elementName)
6661
return (xmlDoc);
6762
}
6863

69-
//XML Generation -> Transform DOC Data to XML Format
70-
publicstaticvoidtransformDocToFile(DocumentxmlDoc,StringxmlFile)throwsTransformerException {
71-
TransformerFactoryxmlTransformerFactory =TransformerFactory.newInstance();
72-
TransformerxmlTransformer =xmlTransformerFactory.newTransformer();
73-
xmlTransformer.setOutputProperty(OutputKeys.INDENT,"yes");
74-
xmlTransformer.setOutputProperty(OutputKeys.METHOD,"xml");
75-
xmlTransformer.setOutputProperty(OutputKeys.ENCODING,"UTF-8");
76-
xmlTransformer.setOutputProperty("{http://xml.apache.org/xslt}indent-amount","4");
77-
FileOutputStreamoutputStream =null;
78-
try {
79-
outputStream =newFileOutputStream((newFile(xmlFile)));
80-
}catch (FileNotFoundExceptione) {
81-
e.printStackTrace();
82-
}
83-
xmlTransformer.transform(newDOMSource(xmlDoc),newStreamResult(outputStream));
84-
}
85-
8664
}
8765

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp