Auto Generate html document with info from excel dokument?

Discussion in 'XML & RSS' started by Klausize, Jul 23, 2012.

0
  1. #1
    Hello,

    I need to generate about 1500 html documents with informations from an excel document. In the excel doc there will be these information: Name, club, url, image url and a piece of text which is the same on all players.

    Lets make an example:

    Name: John Doe
    Club: Big Bears
    Url: Johndoe.html
    Image-url: johndoe.jpeg
    Text: I voted in the big competition!

    So the url and image will just be the players name. I have highlighted some of the code, where the information about the player from the excel document sould be.

    Take this document as an example:

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html xmlns="http://www.w3.org/1999/xhtml"

	  xmlns:og="http://ogp.me/ns#"

	  xmlns:fb="http://www.facebook.com/2008/fbml">

	<head>

		<meta content="type=text/html; charset=utf-8" http-equiv="Content-Type" />

		<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>

		<script type="text/javascript">

			$(document).ready(function(){

				$.ajax({

				  type: 'GET',

				  url:  'http://developers.facebook.com/tools/debug/og/object?q=http://xxxx.com/fileadmin/[B]url[/B].html&format=json',

				  dataType: 'jsonp'

				});

			});

		</script>

		<meta property="og:type" content="article" />

		<meta property="og:title" content="[B]Name[/B]" />

		<meta property="og:url" content="http://xxxx.com/fileadmin/[B]url[/B].html" />

		<meta property="og:image" content="http://xxxx.com/media/[B]image[/B].jpg" />

		<meta property="og:description" content="[B]Text[/B]" />

		

	</head>

	<body>

					<script type="text/javascript">

					window.location = 'http://www.facebook.com/[B]url which is the same on all pages eg. facebook.com/cocacola[/B]';

			</script>

			</body>

</html>
    Code (markup):
    Is there a friendly person, who could help me here? :)
     
    Klausize, Jul 23, 2012 IP
  2. pindot

    pindot Active Member

    Messages:
    248
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    73
    #2
    excel has Save As WebPage feature, why don't you take advantage of that?
     
    pindot, Jul 23, 2012 IP
  3. extraspecial

    extraspecial Member

    Messages:
    788
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    45
    #3
    I can help you with this project, I have created some HTML generators for my projects in past...

    But this will take time so I will need a payment.

     
    extraspecial, Jul 23, 2012 IP
  4. Michael Baptiste

    Michael Baptiste Banned

    Messages:
    109
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The best thing you can do is outsource the work on a free forum like
    craigslist.com. Go there and post this job in a country where the work
    can be done for a cheap price.
     
    Michael Baptiste, Jul 23, 2012 IP
  5. Klausize

    Klausize Peon

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5

    How should that help me auto generate 1500 pages?
    Excuse me if i'm wrong, but as I see that function, it just saves the data in the excel doc in one html page?

    Thanks for the answer. :)
     
    Klausize, Jul 25, 2012 IP