Java code to genarate xml ,for uncontinuous data....

Hi All,

I am geting data from database as

Year Month Series name Values
2008 7 CARDIAC 100
2008 7 DU- IT 100
2008 7 MULTIVENDOR 100
2008 8 CARDIAC 100
2008 8 DU- IT 67
2008 8 P-TECH 100
2008 9 CARDIAC 100
2008 9 DU- IT 67
2008 9 NETWORKING 0
2008 9 P-TECH 100
2008 10 CARDIAC 100
2008 10 DU- IT 100
2008 10 MULTIVENDOR 100
2008 10 NETWORKING 50
2008 10 P-TECH 100
2008 11 CARDIAC 100
2008 11 DU- IT 100
2008 11 MULTIVENDOR 100
2008 12 CARDIAC 67
2008 12 DU- IT 100
2008 12 MULTIVENDOR 50
2008 12 P-TECH 100
2009 3 CARDIAC 100
2009 3 DU- IT 100
2009 3 MULTIVENDOR 100
2009 3 NETWORKING -100
2009 3 P-TECH 100
2009 6 CARDIAC 50
2009 6 DU- IT 100
2009 6 MULTIVENDOR 100
now i have to generate xml,for preparing fusion cahrt.because fusion chart accepts data in xml format.

I am getting xml file like this.

<chart connectNullData='1' labelDisplay='Rotate' slantLabels='1' baseFont='Ge Inspira' useRoundEdges='1' legendPosition='RIGHT' imageSave='1' link='javaScript:onClick()' yAxisName='Values' legendBorderAlpha='0' shownames='1' showvalues='0' ><categories><category label='Jul-2008'/><category label='Aug-2008'/><category label='Sep-2008'/><category label='Oct-2008'/><category label='Nov-2008'/><category label='Dec-2008'/><category label='Mar-2009'/><category label='Jun-2009'/></categories><dataset seriesName='P-TECH'><set value='0.0'/><set value='100.0'/><set value='100.0'/></dataset><dataset seriesName='CARDIAC'><set value='100.0'/><set value='0.0'/><set value='75.0'/><set value='0.0'/><set value='100.0'/><set value='100.0'/><set value='33.0'/></dataset><dataset seriesName='MULTIVENDOR'><set value='0.0'/><set value='0.0'/><set value='100.0'/><set value='75.0'/><set value='100.0'/><set value='50.0'/></dataset><dataset seriesName='NETWORKING'><set value='0.0'/><set value='100.0'/><set value='100.0'/></dataset><dataset seriesName='DU- IT'><set value='100.0'/><set value='100.0'/><set value='100.0'/><set value='75.0'/><set value='100.0'/><set value='100.0'/><set value='50.0'/><set value='100.0'/></dataset></chart>I am trying to plot msline chart using msline.swf file in jsp.

but my problem is

i have several months as categorie labels.

in database for dataset p-tech,i have values according to month dec-2008,mar-2009,apr-2009.

but it is ploating on jul-2008,aug-2008,sep-2008 respectivley.

The reason is.....

Just to reiterate, i am passing category labels as follows:

<category label='Jul-2008'/>
<category label='Aug-2008'/>
<category label='Sep-2008'/>
<category label='Oct-2008'/>
<category label='Nov-2008'/>
<category label='Dec-2008'/>
<category label='Mar-2009'/>
<category label='Jun-2009'/>

Now, for example, when i am passing the data values for the series "P-Tech", i m passing the set values, which, i assume are to correspond to the categories of Dec, Mar and Jun, is as follows:

<set value='0.0'/>
<set value='100.0'/>
<set value='100.0'/>

Here, what is happening is that the <set> elements given as input are three in number and thereby they are corresponding to the first three categories in the category list which are that of Jul, Aug and Sep.

Here, we need to pass empty <set> elements so that the values, say in the "P-Tech" series, refer/correspond to the correct category label.

Foe example:

<chart ....... >
<categories>
<category label='Jul-2008'/>
<category label='Aug-2008'/>
<category label='Sep-2008'/>
<category label='Oct-2008'/>
<category label='Nov-2008'/>
<category label='Dec-2008'/>
<category label='Mar-2009'/>
<category label='Jun-2009'/>
</categories>
<dataset seriesName='P-TECH'>
<set />
<set />
<set />
<set />
<set />
<set value='0.0'/>
<set value='100.0'/>
<set value='100.0'/>
</dataset>
..
..
..
<chart/>

How to create empty set tags at coresponding positions.
I have each column values in one bean with database order.

Let me know any suggestions to do this.

Thanks,
Anila....

Hi Honey gonugunta. Welcome to javaranch. Your question was difficult to follow. Please post XML / code in code tags. They will be easier to understand

So what you are asking is - 'How do I generate empty elements in a XML ?'. There are ways to do it based on the API that you use. Which one are you using to generate the XML ?

Hi Deepak,

Thanks for your reply.
Here i am not generating xml by using any parsers,apis.
I am just forming the data as xml nodes which has to pass to fussion charts.

From database i was getting data like this,which has below.

Year Month Series name Values 2008 7 CARDIAC 100 2008 7 DU- IT 100 2008 7 MULTIVENDOR 100 2008 8 CARDIAC 100 2008 8 DU- IT 67 2008 8 P-TECH 100 2008 9 CARDIAC 100 2008 9 DU- IT 67 2008 9 NETWORKING 0 2008 9 P-TECH 100 2008 10 CARDIAC 100 2008 10 DU- IT 100 2008 10 MULTIVENDOR 100 2008 10 NETWORKING 50 2008 10 P-TECH 100 2008 11 CARDIAC 100 2008 11 DU- IT 100 2008 11 MULTIVENDOR 100 2008 12 CARDIAC 67 2008 12 DU- IT 100 2008 12 MULTIVENDOR 50 2008 12 P-TECH 100 2009 3 CARDIAC 100 2009 3 DU- IT 100 2009 3 MULTIVENDOR 100 2009 3 NETWORKING -100 2009 3 P-TECH 100 2009 6 CARDIAC 50 2009 6 DU- IT 100 2009 6 MULTIVENDOR 100


I am trying to plot msline chart using msline.swf file in jsp.
I am storing each column in one bean whch are coming from database.
After tat i m using prepareList(vB_CL_Cust_NPS.getYr4_data(),nps_mn1,vB_CL_Cust_NPS.getSegment4_data(),vB_CL_Cust_NPS.getNps4_data()) whch accepts 4 columns as beans from dtabase.

prepareList() cretas one list object with data whch are passed to that method.
After that i am using readData(List list),whch accepts above list as parameter.

public Vector readData(List list){ Vector data = new Vector(); LinkedHashMap mapOfCategory = new LinkedHashMap(); List alRegionMonthValueList = new ArrayList(); Map mapOfBar = new HashMap(); Map mapOfDataSet = new HashMap(); for (int i =0; i< list.size(); i++){ Yr2_Mn2_Region_code2_Nps2 obj = (Yr2_Mn2_Region_code2_Nps2)list.get(i); String categoryLabel = obj.getMn2() + "-" + obj.getYr2(); mapOfCategory.put(categoryLabel, new Category(categoryLabel) ); String regionKey = obj.getRegion_code2(); DataSet objDataSet = new DataSet(regionKey ); if (mapOfDataSet.containsKey(regionKey )){ //System.out.println("*Yes" ); DataSet objDataSetAlreadyAdded = (DataSet)mapOfDataSet.get(regionKey); List setListAlreadyAdded = objDataSetAlreadyAdded.getListOfSet(); setListAlreadyAdded.add(obj.getNps2()); objDataSet.setListOfSet(setListAlreadyAdded); mapOfDataSet.put(regionKey,objDataSetAlreadyAdded); }else{ List setList = new ArrayList(); setList.add (obj.getNps2() ); objDataSet.setListOfSet(setList); mapOfDataSet.put( regionKey,objDataSet); //System.out.println("*else" ); } data.add( 0, [color=red]mapOfCategory[/color]); data.add( 1, [color=red]mapOfDataSet[/color]); return data; }

By iterating mapOfCategory, i am getting category lables.
and mapOfDataSet generates dataset with corresponding set values.

The above hashmaps passed to below methods to get categories and datasets wth set values.


public String prepareCategoriesXML(LinkedHashMap mapOfCategory){ StringBuffer buffer = new StringBuffer(); buffer.append(""); Set s=mapOfCategory.keySet(); Iterator it=s.iterator(); while(it.hasNext()) { String me =""+it.next(); Category objCategory =(Category)mapOfCategory.get(me); buffer.append("<category label='"+objCategory.getLabel()+"'/>"); System.out.println("Categeroies"+objCategory.getLabel());} return buffer.toString(); } public String prepareDatasetXML(Map mapOfDataSet){ StringBuffer buffer1 = new StringBuffer(); buffer1.append(""); Set s=mapOfDataSet.keySet(); Iterator it=s.iterator(); while(it.hasNext()) { String me =""+it.next(); DataSet objCategory =(DataSet)mapOfDataSet.get(me); System.out.println("inside while b4 buffer"+mapOfDataSet.get(me)); buffer1.append("<dataset seriesName='"+objCategory.getName()+"'>"); for(int i=0;i<objCategory.getListOfSet().size();i++){ buffer1.append("><set value='"+objCategory.getListOfSet().get(i)+"'/>"); } buffer1.append("</dataset>"); } System.out.println("buffer1...."+buffer1.toString()); return buffer1.toString(); }

I am calling all these methods from jsp as fallows ....
List list1 = getdata.prepareList(vB_CL_Cust_NPS.getYr4_data(),nps_mn1,vB_CL_Cust_NPS.getSegment4_data(),vB_CL_Cust_NPS.getNps4_data()); Vector data1= getdata.readData(list1); String str2= getdata.prepareCategoriesXML((LinkedHashMap)data1.get(0)); String str3=getdata.prepareDatasetXML((Map)data1.get(1)); String chartXML1 = "<chart connectNullData='1' labelDisplay='Rotate' slantLabels='1' baseFont='Ge Inspira' useRoundEdges='1' legendPosition='RIGHT' clickURL='j-download-DwnNPS-4' yAxisName='NPS' legendBorderAlpha='0' shownames='1' showvalues='0' >"; String chartCatge1 ="<categories>"+str2; String chartCat1=str3; /*for(int head1=0;head1<nps1.size();head1++) { chartCatge1 = chartCatge1 + "><category label='"+nps1.get(head1)+"'/>"; }*/ chartCatge1 = chartCatge1 +"</categories>"; String strXML1=chartXML1+chartCatge1+chartCat1+"</chart>"; System.out.println ("STRING XML :"+strXML1); //Create the chart - Column 3D Chart with data contained in strXML1 String chartCode1= createChart("design/js/FusionCharts/MSLine.swf","", strXML1,"nps2", 490, 200, false,true); System.out.println ("CHART CODE :"+chartCode1);


At last i have final xml string(strXML1) like this ...
<chart connectNullData='1' labelDisplay='Rotate' slantLabels='1' baseFont='Ge Inspira' useRoundEdges='1' legendPosition='RIGHT' imageSave='1' link='javaScriptnClick()' yAxisName='Values' legendBorderAlpha='0' shownames='1' showvalues='0' ><categories><category label='Jul-2008'/><category label='Aug-2008'/><category label='Sep-2008'/><category label='Oct-2008'/><category label='Nov-2008'/><category label='Dec-2008'/><category label='Mar-2009'/><category label='Jun-2009'/></categories><dataset seriesName='P-TECH'><set value='0.0'/><set value='100.0'/><set value='100.0'/></dataset><dataset seriesName='CARDIAC'><set value='100.0'/><set value='0.0'/><set value='75.0'/><set value='0.0'/><set value='100.0'/><set value='100.0'/><set value='33.0'/></dataset><dataset seriesName='MULTIVENDOR'><set value='0.0'/><set value='0.0'/><set value='100.0'/><set value='75.0'/><set value='100.0'/><set value='50.0'/></dataset><dataset seriesName='NETWORKING'><set value='0.0'/><set value='100.0'/><set value='100.0'/></dataset><dataset seriesName='DU- IT'><set value='100.0'/><set value='100.0'/><set value='100.0'/><set value='75.0'/><set value='100.0'/><set value='100.0'/><set value='50.0'/><set value='100.0'/></dataset></chart>



tats wat i am doing to get xml file.
i hope now you understood my problem.

Thanks,
Anila....

Im not sure I understand your problem but-

If I wanted to have an array of objects where the number of objects is required but not all would have data, I would.

1. Create array of the required size with empty objects
2. while reading the input data, set values into the appropriate objects (you will have to program setter methods)
3. rejoice, you are done

Bill

Hi,

Thanks for your reply.
here length was dynamic.
According to xml file,I have to create category lables with month and year combination.
After tat i need to create dataset on segment name(db column name),set tags with appropriate values.

But data is in permitation and combination,year month will repeat for individual segment.
One more is while ploating graph postion also problem.

For example 2009-july,CARDIAC doen nt have the value,then i have to create one empty set elemnet in tat postion.

Do not consider my earlier posted code.
Please sea the data coming from database,xml structure.

Due to tat suggest me wat could be the best way to do this.......

then i have to create one empty set elemnet in tat postion.

Isnt that what I just said? Start with empty objects for all positions and fill them as you parse the data.

Bill

Hi,

Thanks to reply.
Any sample code to do?