1. combine several JSON tags into HTML for the "INFO". For the "INFO" the following HTML should be pulled and outputted into the column for INFO.
2. Generate a script for the above and also convert the bottom JSON file into the attached excel file matching the fields.
So in the INFO cells will display the following HTML .....
<p>{{INFO}}</p>
<p>Rating : {{RATING}}</p>
<p>Distance : {{DISTANCE}}</p>
<p>Walk : {{WALK}}</p>
<p>Easy to find? : {{EASYTOFIND}}</p>
<p>Public : {{PUBLICACCESS}}</p>
<p>Access : {{SPECIAACCESS}}</p>
<p>Wave quality: {{WAVEQUALITY}}</p>
<p>Surfer : {{EXPERIENCE}}</p>
<p>Wave and swell frequncey : {{WAVEFREQUENCY}}</p>
<p>Wave type : {{WAVETYPE}}</p>
<p>Swell Direction : {{WAVEDIRECTION}}</p>
<p>Bottom : {{BOTTOM}}</p>
<p>Power : {{POWER}}</p>
<p>Normal length : {{NORMALLENGTH}}</p>
<p>Good day : {{GOODDAYLENGTH}}</p>
<p>Good swell direction : {{GOODSWELLDIRECTION}}</p>
<p>Good wind direction : {{GOODWINDDIRECTION}}</p>
<p>Swell size : {{SWELLSIZE}}</p>
<p>Good tide : {{BESTTIDEPOSITION}} {{BESTTIDEMOVEMENT}}</p>
<p>Crowds on the weekday are {{WEEKDAYCROWD}} and the weekend {{WEEKENDCROWDS}}!</p>
<p>Look out for {{DANGERS}}</p>
This is the JSON file displaying the source data....
[
{
"STATE":"null",
"ADDRESS":"null",
"CITY":"null",
"ZIPCODE":"null",
"PHONE":"null",
"WEBSITE URL":"null",
"IMAGE URL":"null",
"ICONURL":[login to view URL]",
"FEATURED":"FALSE",
"PK":214,
"NAME":"19Th Hole",
"STATE":"South Island",
"CATEGORIES":"City",
"RATING":"2",
"LATITUDE":"null",
"LONGITUDE":"null",
"DISTANCE":"Day trip",
"WALK":"Instant access (< 5min)",
"EASYTOFIND":"OK",
"PUBLICACCESS":"PUBLICACCESS",
"SPECIALACCESS":"Don't know",
"WAVEQUALITY":"Normal",
"EXPERIENCE":"All surfers",
"WAVEFREQUENCY":"Sometimes break",
"WAVETYPE":"Reef-rocky",
"WAVEDIRECTION":"null",
"BOTTOM":"Sandy with rock",
"POWER":"Powerless",
"NORMAL LENGTH":"Short (< 50m)",
"GOODDAYLENGTH":"Normal (50 to 150m)",
"GOODSWELLDIRECTION":"East, NorthEast",
"GOOD WIND DIRECTION":"SouthEast, East",
"SWELLSIZE":"Starts working at Less than 1m / 3ft and holds up to 2m+ / 6ft+",
"BESTTIDEPOSITION":"Mid and high tide",
"BEST TIDE MOVEMENT":"null",
"WEEKDAY CROWD":"Empty",
"WEEKEND CROWDS":"Empty",
"DANGERS":"Rips / undertow",
"INFO":"Some text."
}
}
i can give u simple application which will take the input of json file and give you output in excel file in few seconds. You can use this application even in future yourself.
Thanks
Hi I'm interested of your project . Important I can make your data save in csv file and you can easy open that file in excel(that is better because no need using Excel library). For this project I will use html, javascript and php(this is server languange- to use on your local computer you must have localhost). Please contact me.
Hi,
I have loads of Javascript\HTML experience as well as Excel, PHP, Python and a few less useful things. Not sure what language you're after the script in but I can do it a few ways for you, just let me know what you need.
Thanks,
Craig
1、After you awarded the project to me, I can provide the demo(just picture) to display the progress of the project from own websites every day,so that you can feel free to comment on modifications to achieve satisfactory results.
2、After your payed the Milestone, I would show you the demo that can use.