+ Reply to Thread
Results 1 to 10 of 10

Thread: Database via clickable picture!!

  1. Link to Post #1
    UK Avalon Member Ammit's Avatar
    Join Date
    7th July 2010
    Location
    Weymouth, Dorset, UK
    Language
    Poor english
    Age
    60
    Posts
    1,154
    Thanks
    1,674
    Thanked 2,972 times in 737 posts

    Default Database via clickable picture!!

    Hi all

    A shot in the dark here.
    I am looking for a program that uses a main picture which you can click on individual parts to access a database for part numbers etc.

    Any ideas appreciated

    Thanks
    Love. peace and Blessings to you all.

  2. Link to Post #2
    Ecuador Honored, Retired Member. Warren passed on 2 July, 2020.
    Join Date
    28th March 2014
    Location
    Cuenca, Ecuador
    Age
    80
    Posts
    953
    Thanks
    5,175
    Thanked 5,540 times in 864 posts

    Default Re: Database via clickable picture!!

    Ammit, you are looking for image mapping technique. Here is one of very many sources. stackoverflow.com/.../what-is-the-best-tool-to-create-an-image-map

  3. The Following User Says Thank You to wnlight For This Post:

    Ammit (1st August 2014)

  4. Link to Post #3
    UK Avalon Member Ammit's Avatar
    Join Date
    7th July 2010
    Location
    Weymouth, Dorset, UK
    Language
    Poor english
    Age
    60
    Posts
    1,154
    Thanks
    1,674
    Thanked 2,972 times in 737 posts

    Default Re: Database via clickable picture!!

    Thanks WNLight.

    I do not want to use the picture for html mapping though. It is probably a big ask but for E.G. I would like a picture of a car with a map so as i click on various parts then it can jump to a txt list or word document on my pc containing part number, supplier, cost etc.

    Thanks
    Love. peace and Blessings to you all.

  5. Link to Post #4
    Avalon Member Operator's Avatar
    Join Date
    24th March 2010
    Location
    Caribbean
    Posts
    2,729
    Thanks
    7,575
    Thanked 9,670 times in 1,986 posts

    Default Re: Database via clickable picture!!

    Quote Posted by wnlight (here)
    Ammit, you are looking for image mapping technique. Here is one of very many sources. stackoverflow.com/.../what-is-the-best-tool-to-create-an-image-map
    Your post does not contain the live url unfortunately:
    http://stackoverflow.com/questions/8...e-an-image-map

    By the way there are several image mapping techniques in html which in combination with php
    can of course access a mysql or postgres database. The advantage I see is that it is immediately
    available on the internet. Using e.g. an image as submit button will result in getting the x and y
    coordinates where you clicked the image. But there are more sophisticated techniques also.

  6. The Following User Says Thank You to Operator For This Post:

    Ammit (1st August 2014)

  7. Link to Post #5
    UK Avalon Member Ammit's Avatar
    Join Date
    7th July 2010
    Location
    Weymouth, Dorset, UK
    Language
    Poor english
    Age
    60
    Posts
    1,154
    Thanks
    1,674
    Thanked 2,972 times in 737 posts

    Default Re: Database via clickable picture!!

    All I can find so far is html based for the net, not actual program based.....
    Love. peace and Blessings to you all.

  8. Link to Post #6
    Ecuador Honored, Retired Member. Warren passed on 2 July, 2020.
    Join Date
    28th March 2014
    Location
    Cuenca, Ecuador
    Age
    80
    Posts
    953
    Thanks
    5,175
    Thanked 5,540 times in 864 posts

    Default Re: Database via clickable picture!!

    Ammit, The history of image mapping is closely entwined with HTML and the Web. I did spend some fifteen minutes looking in vain for what you ask. If I find anything useful for you, I'll send it to you. What coding platform(s) do you use?

  9. The Following User Says Thank You to wnlight For This Post:

    Ammit (2nd August 2014)

  10. Link to Post #7
    UK Avalon Member Ammit's Avatar
    Join Date
    7th July 2010
    Location
    Weymouth, Dorset, UK
    Language
    Poor english
    Age
    60
    Posts
    1,154
    Thanks
    1,674
    Thanked 2,972 times in 737 posts

    Default Re: Database via clickable picture!!

    Hi WNLight

    Erm platform?? Not sure what you mean here my friend, win 7 and Firefox??
    Love. peace and Blessings to you all.

  11. Link to Post #8
    United States Avalon Member Shamz's Avatar
    Join Date
    19th August 2011
    Location
    Cary, NC, USA
    Posts
    186
    Thanks
    1,639
    Thanked 855 times in 167 posts

    Default Re: Database via clickable picture!!

    Hello All !

    I think what Ammit is asking -- he has files on his local computer - he wants to link them with some picture - like he mentioned - on a picture of car - when he clicks on some part - say Tires - it should open corresponding text/xls/word doc - which has details about the tires or part he clicked on.

    Ammit - that sounds like a custom solution - and its very much doable but can't think of any ready made software available - will let you know if I find something
    ~~ Much Love
    In Lak'ech Ala K'in ( I am You and You are me )

  12. The Following 3 Users Say Thank You to Shamz For This Post:

    Ammit (2nd August 2014), Operator (2nd August 2014), wnlight (3rd August 2014)

  13. Link to Post #9
    UK Avalon Member Mike Gorman's Avatar
    Join Date
    31st May 2010
    Location
    Perth, Western Australia
    Language
    English
    Age
    65
    Posts
    1,872
    Thanks
    5,839
    Thanked 14,054 times in 1,753 posts

    Default Re: Database via clickable picture!!

    You should be able to set that up with Word, using visual Basic - or even a PDF with links - PDF's are sometimes called searchable data bases
    Have the picture loaded with VB embedded links to your text - OLE object linked embedment

  14. The Following 2 Users Say Thank You to Mike Gorman For This Post:

    Ammit (2nd August 2014), wnlight (3rd August 2014)

  15. Link to Post #10
    Ecuador Honored, Retired Member. Warren passed on 2 July, 2020.
    Join Date
    28th March 2014
    Location
    Cuenca, Ecuador
    Age
    80
    Posts
    953
    Thanks
    5,175
    Thanked 5,540 times in 864 posts

    Default Re: Database via clickable picture!!

    Yes, Ammit, conceivably, you could find an app already written that does what you wish. I truly wish you the best in finding it. Only read the following if you decide to roll your own.

    By platform, I mean what type of hardware being PC, Mac, Android, etc and what coding language being visual Basic, PHP, Pearl, javascript, C#, etc. You could use visual Basic, or PHP or Pearl to write a native app (no HTML, no WEB) to link from clicks on areas of an image to different other images. If you were to desire platform independence, you would be limited to javascript or Web-type non-native apps.

    My immediate assumption reading your original post was that you would write an app (or pay someone else to write it). You will be really lucky to find it already available. I used to do that stuff and specialised in database apps so i don’t mind giving you some advice. I retired eight years ago so am not interested in coding for hire, so my advice is unbiased.

    BTW, what is wrong with an HTML-based web-type app that runs on your PC? I have two such apps that run on my Mac, but are totally platform independent. One uses a json file database. There are free apps out there that will build your image mapping file to link to local web pages that can display whatever you wish from either static or dynamic database.
    Last edited by wnlight; 3rd August 2014 at 03:21.

  16. The Following User Says Thank You to wnlight For This Post:

    Ammit (3rd August 2014)

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts