Java - RSS Blogger importer
$10-120 USD
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
Project ID: #10839682
About the project
Awarded to:
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
6 freelancers are bidding on average $95 for this job
Dear Sir, I am TOP RANKED programmer with 10 years of experience. I am interested in your project. Please award me project.
i have the solid expertise knowledge in java and j2ee application developement.i am a hardworking person.
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