Java - RSS Blogger importer

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

The project: Create a standalone Java project (J2SE) that can read an exported XML/RSS from Blogger and generates a database with the content according to spec below.

What to import?

You must export a [url removed, login to view] content with entire content (attached full sample) acoording to google spec: [url removed, login to view]

Steps:

1) Parse the XML

2) Read every "entry" tag - for each, read the

2.1) id, title, content, [url removed, login to view]

3) Parse the CONTENT and look for the first <img> tag. Get the HREF of the IMG and DOWNLOAD the image for local folder. You need to save the local path after. If the HREF is broke you are supposed to get the next <img> and try to download.

4) Create a database with a table called GAZ_MATERIA

5) Create these columns:

ID - AUTO INCREMENT

TITLE - Title of the post

CONTENT - The html content of the post

IMAGE - The first image local path downloaded from the post, if exists

AUTHOR NAME - Name of the author of the post

PUBLISHED- Timestamp of published date

UPDATED - Timestamp of published date

BLOGID - ID of the entry

URL - TEXT column with the XML you imported

EXAMPLE OF AN ENTRY STRUCTURE INSIDE XML:

<entry>

<id>{BLOGID}</id>

<published>2011-04-10T17:27:30.810-03:00</published>

<updated>2011-04-10T17:27:30.810-03:00</updated>

<category scheme="[url removed, login to view]" term="[url removed, login to view]"/>

<title type="text">Thanks for posting, I like this blog!</title>

<content type="html">Here goes the HTML content of the post</content>

<link rel="edit" type="application/atom+xml" href="[url removed, login to view]"/>

<link rel="self" type="application/atom+xml" href="[url removed, login to view]"/>

<link rel="alternate" type="text/html" href="[url removed, login to view]" title=""/>

<author>

<name>ponoloot</name>

<uri>[url removed, login to view]</uri>

<email>email of the user</email>

<gd:image rel="[url removed, login to view]" width="16" height="16" src="//[url removed, login to view]"/>

</author>

<thr:in-reply-to href="[url removed, login to view]" ref="tag:[url removed, login to view],1999:blog-2656233329275737581.post-2182545856659309765" source="[url removed, login to view]" type="text/html"/>

<gd:extendedProperty name="[url removed, login to view]" value="pid-381226402"/>

<gd:extendedProperty name="[url removed, login to view]" value="10 de abril de 2011 17:27"/>

</entry>

Other info:
- It's required to be written in Java 7 or less - you can work with commons jakarta libs if needs
- It's required to work with MYSQL database
- You don't need to work with hibernate or other persistence framework - Insert the data inside database with single JDBC connections

What to deliver
- The working source code
- The DDL of the table you created

Java MySQL

Project ID: #10839682

About the project

6 proposals Remote project Active 7 years ago

Awarded to:

sudarshanz

Hello, I am an experienced Java Programmer with over 5 years of experience and have done Exactly same thing before. It is a quick task for me. Please contact as early as possible so that we can start it early and fi More

$88 USD in 1 day
(8 Reviews)
2.8

6 freelancers are bidding on average $95 for this job

eperfections

Dear Sir, I am TOP RANKED programmer with 10 years of experience. I am interested in your project. Please award me project.

$133 USD in 3 days
(479 Reviews)
7.5
yakubpune

WISHING YOU PEACE IN YOUR LIFE. I have more than 8 years of experience in JAVA. The breakup of experience as per best of my knowledge Spring2.x - 4.x : 2year 1 months Hibernate 3.x - 4.x : 2 years 4 months St More

$111 USD in 7 days
(2 Reviews)
2.5
jkacharya5087

i have the solid expertise knowledge in java and j2ee application developement.i am a hardworking person.

$72 USD in 1 day
(0 Reviews)
0.0
faseemmohammed

I have already did same project for a different client in our office privately which is passing given xml files both in pure Java as well as using spring framework I'm sure that I can help you very well to complete thi More

$55 USD in 1 day
(0 Reviews)
0.0
hajashareefbe

A proposal has not yet been provided

$77 USD in 6 days
(0 Reviews)
0.0