Check list for creating layer with PorPOISe

[Paul Lewis]

I use this every time I create a layer; you won't beleive how much it
speeds up your development.
Hope you find it useful too.


Steps to create a layer using PorPOISe, MySQL and phpMyAdmin

Time to complete < 1 hour

Design & copy

1. Write copy for the short and detailed descriptions
2. Define tags
3. Design icons for: layar icon, banner icon, focus, inner, middle,
outer

Create the layer

1. Login to http://dev.layar.com/publishing/
2. Create a layer
3. Set up layer details and Save

Create the database

1. Go to website URL
2. Click on MySQL Databases
3. Create DB
4. Add user to DB

Create the database tables

1. Go to website URL
2. Click on phpMyAdmin
3. Select the new DB
4. Click on the SQL tab
5. Open file - porpoise\database.sql
6. Run SQL command to create tables
7. Make sure you have five tables

Edit the porpoise config file

1. Open config.xml
2. Create new layar node
3. Change name to layer name
4. Update source and user details (DB name, user and password)
5. Upload file to server URL

Online assets (audio/video/3D/2D)

1. Create assets directory in URL
2. Upload assets

Create POI entries

1. Login to http://URL/porpoise/web/dashboard/
2. New layer should be in list – check and upload config.xml if
missing
3. Create new POI
4. Use Google Earth to get accurate Lat/Long values
5. Set up Actions

Test

1. Go to http://dev.layar.com/api20test/layarTestPage/
2. Enter Dev ID, Dev Key and layer name
3. Click ‘Load layer!’
4. Set location on map
5. Click ‘Load POIs’
6. Response should be valid JSON with POI list on right


If above sequence above shows no errors, test on device.

[rv pellarin]

Hi paul, thx for this sexy checklist :)
How would you add/managed checkbox filters in all that?

Rv

[Paul Lewis]

The checklist is for the basic SQLPOIConnector, if you're adding
filters you'll need some PHP skills.

There's a very good example on http://code.google.com/p/porpoise/wiki/Filters

For filters - add these extra actions under the 'Edit the porpoise
config file' heading

1. Add the new SQLPOIConnector class to the XML
2. Reference to it in the new layer description - when you add the DB
name, user and password (the Wiki explains how)
3. upload the new PHP class file to your http://URL/porpoise/ setup

Paul

[Jens de Smit]

Hi Paul,

Thanks indeed for this nice checklist. It helps you launch layers and
also shows how simple layer development with PorPOISe can be :)

Do you mind if I adapt your list into a Wiki article on the project
page?

Regards,

Jens

[Paul Lewis]

Hi Jens,

Great idea! Feel free to use as you need.

Regards,

Paul

[jsmummert]

Hi all, coming back to PorPOISe after a long absence. Is Paul's excellent checklist still accurate?

Thanks

Jeff