Really great stuff! Keep up the good work! It made learning the whole XML Parser thing much easier.

ajaypatelaj wrote:Can you please explain me.. i am beginner

songotho wrote:Hi,
U try to not connect with your MySQL database and you will know what is the right direction^^.
Alex

The first, when you run the application, the SqLite database will be created also the table is the same on Android phone but will have not any data in tables.
Second, because your phone have connect with MySQL database so the data will be transferred to SQLite database. The theory will be liked this, I don't know what your program is. But I think that you can try to not connect your phone to MySQL database and you can see the results.

Alex

can any one help me.. why i am getting error... " THe application pasexml stopped unexpectedly " ...??

i write same above 3 file....

Hay plusminus.. thanks for this amazing tutorial....

can you please post importing data in sqlite from xml.... it will really help full all guys to build web service .. and all that type App .... Thanks... will eagerly wait for this tut ...

ajaypatelaj wrote:Hay plusminus.. thanks for this amazing tutorial....

can you please post importing data in sqlite from xml.... it will really help full all guys to build web service .. and all that type App .... Thanks... will eagerly wait for this tut ...

Hi men,

I think that if you want to import data in sqlite from xml that mean you are parsing xml and then you insert in ur sqlite.
You can try to do the tut first and then every can comments as well as modify for you.
Regard,
Alex

good morning ,

I used the idea of Parsing XML from the Net - Using the SAXParser with successful but i want to parser a file xml External( in web server) contains a spinner in my project android.plz help me.
thnx

Hey good evening guys,
I have got a question. Say for example I have this URL:http://spark.tp.edu.sg/dmr/mobileapp/databases.xml. And I want to extract data from it and the place the data into arrays and display in listview? How should I go about doing it? And also I realise that there are repeated tags in the xml. How can I choose what I want to retrieve and display it? I really need the help...

Hi Plusminus,

Sorry if this has been answered before but i couldn't find an answer, I am trying to read an XML file with reoccurring tags. I want only 4 values from the first and second set of tags. Here is the XML file:


I only want the temp, wind, condition values from the current day and the next day, here is my handler class

Hello plusminus, nice tutorial.

If i want to load the xml from assets folder, how can i load this?

I've tryed :

URL url = new URL("file:///android_asset/example.xml");


but it doesn't work.

The solution to local xml is:

xr.parse(new InputSource(getResources().getAssets().open("example.xml")));

Thanks

Menor wrote:The solution to local xml is:

xr.parse(new InputSource(getResources().getAssets().open("example.xml")));

Thanks

Any idea how to get values from an xml file like this:


I want to get values from only the middle set of tags

Any idea how to get values from an xml file like this:

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using xml Syntax Highlighting

1.  
2. <current_conditions>
3. <condition data="Clear"/>
4. <temp_f data="61"/>
5. <temp_c data="16"/>
6. <humidity data="Humidity: 68%"/>
7. <icon data="/ig/images/weather/sunny.gif"/>
8. <wind_condition data="Wind: E at 13 mph"/>
9. </current_conditions>
10. ---------------------------------------------------
11. <forecast_conditions>
12. <day_of_week data="Tue"/>
13. <low data="39"/>
14. <high data="62"/>
15. <icon data="/ig/images/weather/mostly_sunny.gif"/>
16. <condition data="Mostly Sunny"/>
17. </forecast_conditions>
18. -----------------------------------------------------
19. <forecast_conditions>
20. <day_of_week data="Wed"/>
21. <low data="37"/>
22. <high data="59"/>
23. <icon data="/ig/images/weather/sunny.gif"/>
24. <condition data="Clear"/>
25. </forecast_conditions>
26.  

Parsed in 0.004 seconds, using GeSHi 1.0.8.4

I want to get values from only the middle set of tags

U can add the condition when u parse ur xml file like data = Tue.
Regard,
Alex

amanni82 wrote:

Menor wrote:The solution to local xml is:

xr.parse(new InputSource(getResources().getAssets().open("example.xml")));

Thanks

Any idea how to get values from an xml file like this:

Syntax: [ Download ] [ Hide ]

Syntax: [ Download ] [ Show ]

Using xml Syntax Highlighting

1.  
2. <current_conditions>
3. <condition data="Clear"/>
4. <temp_f data="61"/>
5. <temp_c data="16"/>
6. <humidity data="Humidity: 68%"/>
7. <icon data="/ig/images/weather/sunny.gif"/>
8. <wind_condition data="Wind: E at 13 mph"/>
9. </current_conditions>
10. ---------------------------------------------------
11. <forecast_conditions>
12. <day_of_week data="Tue"/>
13. <low data="39"/>
14. <high data="62"/>
15. <icon data="/ig/images/weather/mostly_sunny.gif"/>
16. <condition data="Mostly Sunny"/>
17. </forecast_conditions>
18. -----------------------------------------------------
19. <forecast_conditions>
20. <day_of_week data="Wed"/>
21. <low data="37"/>
22. <high data="59"/>
23. <icon data="/ig/images/weather/sunny.gif"/>
24. <condition data="Clear"/>
25. </forecast_conditions>
26.  

Parsed in 0.004 seconds, using GeSHi 1.0.8.4

I want to get values from only the middle set of tags

Hello

You can get these values...

If i want to get the condition atributes, check your sequence of if and else on "public void startElement" method. Take a look an example:

Code: Select all

if (localName.equals("condition")) {
            String conditionData = atts.getValue("data"));
}


after this, the string "conditionData" will have the value "Clear"...

You'll always get the attributes from the startElement method.
To get the value between the tags (<tag>THIS_VALUE</tag>), you'll need to implement it on the "characters(char ch[], int start, int length)" method...

Hey Menor,
Would it be possible if you explain more? Or show an example code on getting the value between the tags based on their attribute values? I'm stuck at trying to extract the values based on the attribute value.
Thanks,
Joel

ancientgeek wrote:Hey Menor,
Would it be possible if you explain more? Or show an example code on getting the value between the tags based on their attribute values? I'm stuck at trying to extract the values based on the attribute value.
Thanks,
Joel

I'll show you an example.

The xml that i want to red is:




My handler class:

Code: Select all

package mypackage;

import java.util.ArrayList;

import org.xml.sax.Attributes;
import org.xml.sax.SAXException;
import org.xml.sax.helpers.DefaultHandler;

import mypackage.FairBooth;
import mypackage.FairDataManager;
import mypackage.FairTopic;

public class FairListHandler extends DefaultHandler {

   private boolean in_fairs = false;
   private boolean in_fair = false;
   private boolean in_name = false;
   private boolean in_date = false;
   private boolean in_active = false;
   private boolean in_activeimage = false;
   private boolean in_inactiveimage = false;
   private boolean in_map = false;
   private boolean in_info = false;
   private boolean in_booths = false;
   private boolean in_booth = false;
   private boolean in_topics = false;
   private boolean in_topic = false;

        // here is put all fairs. when the first fair (on this example, we have just one fair on xml, but if there are many, this code also will work
       
        // My data structure to put data
        private ArrayList<FairDataManager> array = new ArrayList<FairDataManager>();
        private FairDataManager parsedData = new FairDataManager();
   private FairBooth fairBooth = new FairBooth();
   private FairTopic fairTopic = new FairTopic();


   public ArrayList getParsedData() {
      return this.array;
   }

   @Override
   public void startDocument() throws SAXException {
      this.parsedData = new FairDataManager();
   }

   @Override
   public void endDocument() throws SAXException {
      // Nothing to do
   }


   @Override
   public void startElement(String namespaceURI, String localName,
         String qName, Attributes atts) throws SAXException {
      if (localName.equals("fairs")) {
         this.in_fairs = true;
      } else if (localName.equals("fair")) {
         this.in_fair = true;
      } else if (localName.equals("name")) {
         this.in_name = true;
      } else if (localName.equals("date")) {
         this.in_date = true;
      } else if (localName.equals("active")) {
         this.in_active = true;
      } else if (localName.equals("active_image")) {
         this.in_activeimage = true;
      } else if (localName.equals("inactive_image")) {
         this.in_inactiveimage = true;
      } else if (localName.equals("map")) {
         this.in_map = true;
      } else if (localName.equals("info")) {
         this.in_info = true;
      } else if (localName.equals("booths")) {
         this.in_booths = true;
      } else if (localName.equals("booth")) {
         this.in_booth = true;
         fairBooth = new FairBooth();
                        // here i get the attributes values from <booth> tag
         fairBooth.setBoothName(atts.getValue("name"));
         fairBooth.setBoothPath(atts.getValue("target"));
      } else if (localName.equals("topics")) {
         this.in_topics = true;
      } else if (localName.equals("topic")) {
         this.in_topic = true;
         fairTopic = new FairTopic();
         fairTopic.setTopicName(atts.getValue("name"));

      }
   }

   @Override
   public void endElement(String namespaceURI, String localName, String qName)
         throws SAXException {
      if (localName.equals("fairs")) {
         this.in_fairs = false;
      } else if (localName.equals("fair")) {
         this.in_fair = false;
                        //when the fair ends, add the fair on fair array
         array.add(parsedData);
         parsedData = new FairDataManager();
         fairBooth = new FairBooth();
         fairTopic = new FairTopic();
      } else if (localName.equals("name")) {
         this.in_name = false;
      } else if (localName.equals("date")) {
         this.in_date = false;
      } else if (localName.equals("active")) {
         this.in_active = false;
      } else if (localName.equals("active_image")) {
         this.in_activeimage = false;
      } else if (localName.equals("inactive_image")) {
         this.in_inactiveimage = false;
      } else if (localName.equals("map")) {
         this.in_map = false;
      } else if (localName.equals("info")) {
         this.in_info = false;
      } else if (localName.equals("booths")) {
         this.in_booths = false;
      } else if (localName.equals("booth")) {
         this.in_booth = false;
      } else if (localName.equals("topics")) {
         this.in_topics = false;
                        // when topics ends, add the booth on fair
         parsedData.addBooth(fairBooth);
         fairBooth = new FairBooth();

      } else if (localName.equals("topic")) {
         this.in_topic = false;
                        // when the topic ends, add topic on booth
         fairBooth.addTopic(fairTopic);
         fairTopic = new FairTopic();

      }
   }

   @Override
   public void characters(char ch[], int start, int length) {
      if (this.in_name) {
                       // here i get the value between the tag <name>THIS_VALUE</name>
         parsedData.setName(new String(ch, start, length));
      }
      if (this.in_date) {
                         // here i get the value between the tag <date>THIS_VALUE</date>
         parsedData.setDate(new String(ch, start, length));
      }
      if (this.in_active) {
                        // here i get the value between the tag <active>THIS_VALUE</active>
         String active = new String(ch, start, length);
         if (active.equals("true")) {
            parsedData.setActive(true);
         } else {
            parsedData.setActive(false);
         }
      }
      if (this.in_activeimage) {
                         // here i get the value between the tag <active_image>THIS_VALUE</active_image>
         parsedData.setActiveImage(new String(ch, start, length));
      }
      if (this.in_inactiveimage) {
                        // here i get the value between the tag <inactive_image>THIS_VALUE</inactive_image>
         parsedData.setInactiveImage(new String(ch, start, length));
      }
      if (this.in_map) {
                        // here i get the value between the tag <map>THIS_VALUE</map>
         parsedData.setMapUrl(new String(ch, start, length));
      }
      if (this.in_info) {
         // here i get the value between the tag <info>THIS_VALUE</info>
                        parsedData.setInfoUrl(new String(ch, start, length));
      }
      if (this.in_topic) {
         // here i get the value between the tag <topic>THIS_VALUE</topic>
                        fairTopic.setTopicPath(new String(ch, start, length));
      }

   }
}



I hope that this example help you...

if you still have questions, ask me.