DVLA vehicle lists - access on-line - problems

Having problems with RSS? Outlook? Windows?

Moderators: scimjim, philhoward, Lukeyboy46, erikscimitardemon, Roger Pennington, Terry Rickard

Post Reply
drcdb15
RSSOC Member
Posts: 316
Joined: Tue Jun 29, 2010 10:28 am
Location: Sussex & Worcestershire
Has thanked: 1 time
Been thanked: 4 times

DVLA vehicle lists - access on-line - problems

Post by drcdb15 » Sun Aug 06, 2017 3:08 pm

Is anyone else having problems getting into the latest (July 2017) DVLA vehicle tables? They download OK, I've updated Open Office to the latest version, 4.1.3, but whatever I do to try to open the files (.ODS, or .ODS# - what's with the # ??) the screen goes completely grey and hangs. Has DVLA locked them down ? (seems a bit pointless publishing them if we're not allowed in!). Any tips welcomed, Thanks.


Chris
MB61; formerly 1978 SE6A 3.5 V8; 1986 SE6B 2.9 EFi.

User avatar
scimjim
RSSOC Member
Posts: 33190
Joined: Sun Oct 01, 2006 10:08 pm
Location: Gloucester
Has thanked: 99 times
Been thanked: 604 times

DVLA vehicle lists - access on-line - problems

Post by scimjim » Sun Aug 06, 2017 3:41 pm

Stick a link up and we can try?


Jim King

Current: SE5 (8Ball), 1600 SS1 (G97), 2.5TD SE5a (diesel 5a), 6 x random other SS1s.
Previous: SE5, 3 x SE5a, 2 x SE6a, 3 x SE6b, GTC, 2.9i GTC, 3 x 1600 SS1, 1300 SS1, Mk1 Ti Sabre, Mk1.5 CVH Sabre
Chief mechanic for: SE6a (Katrina), 1400EFi SS1 (Grawpy), Sabre/MX5 auto (The Flying Broomstick), 1400 K series SS1 (Megan3), TI SS1 (snotty), 1300 SS1 (Number One) & Sarah's coupe.
CURE THE FAULT - NOT THE SYMPTOMS

drcdb15
RSSOC Member
Posts: 316
Joined: Tue Jun 29, 2010 10:28 am
Location: Sussex & Worcestershire
Has thanked: 1 time
Been thanked: 4 times

DVLA vehicle lists - access on-line - problems

Post by drcdb15 » Sun Aug 06, 2017 4:09 pm

Here's the page I was starting at:

https://www.gov.uk/government/statistic ... cles-veh01

and tables VEH0120 and 0121 were obviously of most interest.


Chris
MB61; formerly 1978 SE6A 3.5 V8; 1986 SE6B 2.9 EFi.

User avatar
Old and Slow
RSSOC Member
Posts: 539
Joined: Tue Jan 20, 2015 6:37 pm
Location: East Berks
Has thanked: 2 times
Been thanked: 22 times

DVLA vehicle lists - access on-line - problems

Post by Old and Slow » Sun Aug 06, 2017 4:47 pm

Just logged into the link, the first (23.9k, i.e. small size) Table opens OK in Excel (Windows 10 asked me which app to use).
Perhaps the problem is with the file size, VEH0120 is over 16Mb
The hash might mean you need to use XSLX to open it?


Philip Needham
Ashley-bodied TR3; '54 Ford Consul; '55 AC 2-Litre Saloon;'65 850 Mini; '70 Ford Zodiac MkIV; XR3i
'81 911SC Targa, '64 Sabre Six

drcdb15
RSSOC Member
Posts: 316
Joined: Tue Jun 29, 2010 10:28 am
Location: Sussex & Worcestershire
Has thanked: 1 time
Been thanked: 4 times

DVLA vehicle lists - access on-line - problems

Post by drcdb15 » Sun Aug 06, 2017 5:18 pm

Old and Slow wrote:
Sun Aug 06, 2017 4:47 pm
Perhaps the problem is with the file size, VEH0120 is over 16Mb
Thanks for that. Started some systematic tests and like you, the smallest file ran fine. Worked my way up, and 0120 finally opened up after about 3.5 minutes. But previously I let it run for 10 minutes and it was still hanging, so maybe the very large file size is prone to a sod factor somewhere. Also, the time to open seems to vary between opening from downloaded copy on local hard drive, vs download and open on the fly. Oddly that latter seems faster than opening from the local (SSD)rive. Go figure!

Thanks all for your help.


Chris
MB61; formerly 1978 SE6A 3.5 V8; 1986 SE6B 2.9 EFi.

User avatar
scimjim
RSSOC Member
Posts: 33190
Joined: Sun Oct 01, 2006 10:08 pm
Location: Gloucester
Has thanked: 99 times
Been thanked: 604 times

DVLA vehicle lists - access on-line - problems

Post by scimjim » Sun Aug 06, 2017 5:21 pm

Yep, all opened okay except 0120. I pressed cancel after a minute of trying to load (didn't download to my iPad, just opened the zip file) - and it opened (presumably incomplete).


Jim King

Current: SE5 (8Ball), 1600 SS1 (G97), 2.5TD SE5a (diesel 5a), 6 x random other SS1s.
Previous: SE5, 3 x SE5a, 2 x SE6a, 3 x SE6b, GTC, 2.9i GTC, 3 x 1600 SS1, 1300 SS1, Mk1 Ti Sabre, Mk1.5 CVH Sabre
Chief mechanic for: SE6a (Katrina), 1400EFi SS1 (Grawpy), Sabre/MX5 auto (The Flying Broomstick), 1400 K series SS1 (Megan3), TI SS1 (snotty), 1300 SS1 (Number One) & Sarah's coupe.
CURE THE FAULT - NOT THE SYMPTOMS

User avatar
Roger Pennington
RSSOC Member
Posts: 18609
Joined: Tue Aug 29, 2006 9:43 pm
Has thanked: 83 times
Been thanked: 386 times

DVLA vehicle lists - access on-line - problems

Post by Roger Pennington » Sun Aug 06, 2017 5:57 pm

I've just downloaded both 120 and 121 absolutely fine, so I suspect it's simply a broadband speed issue, as they are big files.

Looking at the contents, it looks essentially like the base data that drives the tables on the "How Many Left?" website, which may which may be more easily digestible if you're looking for a specific car make/model?


....Roger

RSSOC member (since 1982)
- - - - - - - - - - - - - - - - -
Image

"Condition can be bought at any time; Originality, once lost, is gone forever" - Doug Nye

drcdb15
RSSOC Member
Posts: 316
Joined: Tue Jun 29, 2010 10:28 am
Location: Sussex & Worcestershire
Has thanked: 1 time
Been thanked: 4 times

DVLA vehicle lists - access on-line - problems

Post by drcdb15 » Sun Aug 06, 2017 6:10 pm

It was all a bit of fun, really. I wanted to know DVLA's 'official' take on how many Websters are out there. I discovered that of my MB61, the Webster and a Fiat based CC Zero (where the maker is in fact still in business and still making cars, though not Fiat-based) not a single one is listed either as licensed (which 2 of them are) or on SORN (1). I also found that pretty much every make and model that's shown under 'Cars' is also listed under 'others', along with tractors and HGVs... And some Reliant-linked microcars such as Aixam are also listed under motorcycles....

A classic demonstration of GIGO, I presume.

It's so good to know that our taxes are being spent in compiling such authoritative and reliable statistics upon which we can all depend with complete confidence... but I am left wondering how, when my cars seem completely absent from their records, DVLA never seems to have any trouble reminding me when they want some of my hard-earned :?


Chris
MB61; formerly 1978 SE6A 3.5 V8; 1986 SE6B 2.9 EFi.

User avatar
Old and Slow
RSSOC Member
Posts: 539
Joined: Tue Jan 20, 2015 6:37 pm
Location: East Berks
Has thanked: 2 times
Been thanked: 22 times

DVLA vehicle lists - access on-line - problems

Post by Old and Slow » Sun Aug 06, 2017 8:29 pm

Hi Chris,
If you've been following the FBHVC News in Slice, then you will probably already be aware that the DVLA database has serious problems with the fields holding Manufacturers data. If the Manufacturer hasn't entered a code, then Box 1 and Box 2 (Make and Model) can be wrong (and now, apparently, can't be entered manually), screwing up any search capability on these fields. Older cars won't have a Manufacturers code, so the database will be hit and miss. However, the other stuff - date tax is due, MOT and Insurance status etc can all be accessed by the powers-that-be (which is probably why they aren't bothered about sorting out the Make & Model data, as it doesn't stop them doing their job).
Badly designed database as well as GIGO, I think.


Philip Needham
Ashley-bodied TR3; '54 Ford Consul; '55 AC 2-Litre Saloon;'65 850 Mini; '70 Ford Zodiac MkIV; XR3i
'81 911SC Targa, '64 Sabre Six

User avatar
scimjim
RSSOC Member
Posts: 33190
Joined: Sun Oct 01, 2006 10:08 pm
Location: Gloucester
Has thanked: 99 times
Been thanked: 604 times

DVLA vehicle lists - access on-line - problems

Post by scimjim » Sun Aug 06, 2017 8:50 pm

I have some sympathy (I'm not a civil servant but I consult for a branch of the civil service). We're asking for information that was manually copied from parchment at a time when there was no FOI act and no inkling that they'd ever need to give the man on the street this level of information. The public demands the cheapest bidder on one hand and then complains bitterly when it doesn't work properly :D


Jim King

Current: SE5 (8Ball), 1600 SS1 (G97), 2.5TD SE5a (diesel 5a), 6 x random other SS1s.
Previous: SE5, 3 x SE5a, 2 x SE6a, 3 x SE6b, GTC, 2.9i GTC, 3 x 1600 SS1, 1300 SS1, Mk1 Ti Sabre, Mk1.5 CVH Sabre
Chief mechanic for: SE6a (Katrina), 1400EFi SS1 (Grawpy), Sabre/MX5 auto (The Flying Broomstick), 1400 K series SS1 (Megan3), TI SS1 (snotty), 1300 SS1 (Number One) & Sarah's coupe.
CURE THE FAULT - NOT THE SYMPTOMS

drcdb15
RSSOC Member
Posts: 316
Joined: Tue Jun 29, 2010 10:28 am
Location: Sussex & Worcestershire
Has thanked: 1 time
Been thanked: 4 times

DVLA vehicle lists - access on-line - problems

Post by drcdb15 » Sun Aug 06, 2017 9:10 pm

scimjim wrote:
Sun Aug 06, 2017 8:50 pm
The public demands the cheapest bidder on one hand and then complains bitterly when it doesn't work properly :D
There was actually a tiny little bit of my tongue lodged firmly in my cheek in my words :lol: I have actually spent some years inside the public sector and at the public/private interface, so although essentially a private sector person I do appreciate the very different ethos (and constraints) of the 'dark' side. With the bulk of my family being life-long public sector staff (civil service, teachers, one even in the Inland Revenue!) I was obviously a genetic mutation by going into engineering sales and marketing, but they had their revenge years later when I was TUPE'd back into their clutches. Is there NO escape ??? :roll:


Chris
MB61; formerly 1978 SE6A 3.5 V8; 1986 SE6B 2.9 EFi.

Post Reply

Return to “Computer Problems and Solutions”