FW: iCal2Plings and csv2Plings

[Ian Wiebkin]

Hi David,

 

Do you know how many LAs are using the input API to load data and how many are using spreadsheets and ical files?

 

Regards,

 

Ian Wiebkin

Technical Manager

Looking Local (formerly DigiTV)

Owned and managed by Kirklees Council

 

Tel: 020 8301 2516

Mob: 07981 520981

Skype: ianwiebkin

 

website: lookinglocal.gov.uk/site    

tv preview: lookinglocal.gov.uk/lookinglocal    

Helpdesk: 0845 4348540

help...@digitv.gov.uk  

 

 

-----Original Message-----
From: Ian Wiebkin
Sent: 30 July 2009 11:26
To: Ian Wiebkin
Subject: FW: iCal2Plings and csv2Plings

 

 

-------------------------------------------

From: pli...@googlegroups.com on behalf of David Carpenter[SMTP:DA...@SUBSTANCE.COOP]

Sent: 30 July 2009 11:25:51

To: Plings Developer Support

Subject: iCal2Plings and csv2Plings

Auto forwarded by a Rule

 

 

During the recent rush to get lots of local authority data into the

live Plings system, we need to do some work with spreadsheets and ical

files containing data that needed converting.

 

We've published the scripts we use to do this, (and a template

spreadsheet we used to help people gather data) on the wiki.

 

There are plenty of issues raised about gathering, manipulating and

transferring this data around, and really we'd like to see most of

this disappear as data gathering becomes more sophisticated, BUT if

you are faced with data in spreadsheets where you are, or you do have

ical data, then these scripts may be of use to get started.

 

(We know with ical data that we definitely do not get all the fields

we'd like to see in Plings, so you might use this to do a partial

import, where users then add the missing detail - we wouldn't

necessarily expect a direct import from ical to be of great data

quality)

 

Anyway, the scripts are here:

(under Code Snippets) http://www.plings.info/wiki/index.php/ICal2Plings

 

(under Development Tools) http://www.plings.info/wiki/index.php/CSV2Plings

 

We'd be interested to know if these are of use to people.

 

Cheers

David

 

[Neil Watson]

Hi Ian,

All the data has gone in via the API as we used scripts to convert the data that was supplied to us by LA's who weren't able to set up an automated feed in time for the beginning of July. Eight managed to set up a data feeds and twelve worked intensively with us over the 6-8 weeks from late May to early July to collect the information in the required formats for the data conversion.

These twelve LA's now have the web based input tool so their data can be managed and added to until such a time as the automated feed is set up.

Neil 

--
Neil Watson
07816 983400


substance.

3rd Floor
Fourways House
57 Hilton St
Manchester
M1 2EJ  
United Kingdom
0161 2445418
www.substance.coop