The Jensen Owners' Club A technical and discussion forum for all Jensen enthusiasts It is currently Sun Sep 22, 2019 6:08 am

General Discussion

Software for cataloguing?

You can discuss anything here, Jensen related or not. Technical discussions / questions may be moved to the correct Forum.

by Martin B » Fri Aug 09, 2019 5:44 pm

I have two Jensen Interceptors, one being a half stripped donor car. Are there any members who have come across software that could be used to catalog parts from the donor car using photographs and a narrative. I could number photographs and then have a spreadsheet with numbered description. Would be good to capture all on one document. Any suggestions warmly welcome.
Martin Bohling
1972 Jade Blue Interceptor MK3 37,000 miles
Martin B
 
Posts: 12
Joined: Tue Jul 02, 2019 9:07 am
Location: West Sussex

by colin7673 » Sat Aug 10, 2019 4:51 am

The person you need to talk to is Derek Chapman, you can find him on Facebook now days as he done this sort of thing for the P66. He might be able to advise you.
Only working half a day now.
Classic Carshow App.
http://www.jensensontour.org
Life. Driving a Jensen
colin7673
now normal...
 
Posts: 3560
Joined: Tue Jan 10, 2006 11:54 am
Location: Spalding Lincolnshire

by Martin B » Sat Aug 10, 2019 8:45 am

Thank You
Martin Bohling
1972 Jade Blue Interceptor MK3 37,000 miles
Martin B
 
Posts: 12
Joined: Tue Jul 02, 2019 9:07 am
Location: West Sussex

by John Staddon » Sat Aug 10, 2019 3:33 pm

You could do it in Excel and link the photos from another folder. You can insert a photo, but you soon end up with a massive Excel file if each photo is several mb, or you can link the photo so that it appears in Excel but is actually filed elsewhere, the only drawback with linking photos is the Excel file and photos must be on the same PC, laptop or whatever and as soon as you export the Excel file to somewhere else, from PC to laptop or send to someone else, you lose the link and therefore the photos.

John
Early Interceptor INT885347
C-V8 Mk111 112/2334
John Staddon
JOC C-V8 Registrar
 
Posts: 1715
Joined: Fri Nov 04, 2005 1:48 pm

by Martin B » Sat Aug 17, 2019 3:21 pm

Thanks John. I did think of Excell, but like you thought the file would get too large. I like the idea of the link although as you say limited as to its use.
Martin Bohling
1972 Jade Blue Interceptor MK3 37,000 miles
Martin B
 
Posts: 12
Joined: Tue Jul 02, 2019 9:07 am
Location: West Sussex

by Chris_R » Sat Aug 17, 2019 3:32 pm

Isn't there a way in Excel of linking to an external file in the same folder that instead of when moving the Excel file to another computer you move the whole folder and so the links stay valid.
Chris
JOC Member 6116
--------------------------------------------------
User avatar
Chris_R
JOC General Secretary
 
Posts: 5267
Joined: Sun Feb 10, 2008 9:19 am
Location: South West London

by VFK44 » Sat Aug 17, 2019 7:51 pm

Excel was my solution for keeping track of parts. I also have a folder containing the pictures. As it is on an external USB drive it can be used on another PC, providing you use the same drive name. I have also found a way to have a small thumbnail picture show on mouseover of the link, without necessarily opening the bigger picture. All quite time consuming to set up but works really well. When I get back home in a week I can send you an example file.
"Just because Science doesn't 'know everything', doesn't mean you can fill in the blanks with whatever fairy story most appeals to you" Dara O'Briain
User avatar
VFK44
Co-Administrator
 
Posts: 7280
Joined: Wed Jan 10, 2007 10:04 pm
Location: Epping Essex UK

by Richie » Sat Aug 17, 2019 11:04 pm

If any pictures are backed up to, for example, a personal Google pictures account, could the web link properties of the pictures be used in an excel file?
The pictures are then stored on your own on line Google account, not on a hard drive..?
User avatar
Richie
V8 Lover
 
Posts: 4024
Joined: Mon Oct 24, 2005 8:08 am
Location: Near Cardiff


Return to General Discussion