Alpha Video Training
Results 1 to 26 of 26

Thread: Here is an Example, Google Maps, Images, GridLinker, Download

  1. #1
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,557

    Default Here is an Example, Google Maps, Images, GridLinker, Download

    I'll leave it up for 12 hours.

    http://mail.dpmail.com.au:8001/media/login_me.a5w

    Login: alpha
    Password: developer

    Hope this helps people see what is possible using the basic functions of Alpha, the data entry section is similar.

    Peter

  2. #2
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,557

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Login now turned off.

    Out of interest many people logged in to the site, no one bothered to comment, good, bad or even just a thank you for sharing.

  3. #3
    Member
    Real Name
    Charlain Fondren
    Join Date
    Oct 2002
    Posts
    345

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    I would've liked to have seen the application, but didn't see your post until now, and it's too late. I'm particularly interested in seeing how you used Google maps. Any chance you'll open it back up for viewing?

  4. #4
    Member RJGowan's Avatar
    Real Name
    Robert Gowan
    Join Date
    Apr 2000
    Location
    Aylmer, QC
    Posts
    236

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Quote Originally Posted by peteconway View Post
    Login now turned off.

    Out of interest many people logged in to the site, no one bothered to comment, good, bad or even just a thank you for sharing.
    I just saw this now and would have liked to see the application, too.
    Maybe those who saw and left also read the message that said it would be up for 12 hours and thought they had lots of time, not 8 minutes, to comment ????

  5. #5
    Member RJGowan's Avatar
    Real Name
    Robert Gowan
    Join Date
    Apr 2000
    Location
    Aylmer, QC
    Posts
    236

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Quote Originally Posted by RJGowan View Post
    I just saw this now and would have liked to see the application, too.
    Maybe those who saw and left also read the message that said it would be up for 12 hours and thought they had lots of time, not 8 minutes, to comment ????
    Sorry Pete, I read wrong - I now see it was 12 hours and 8 min.

  6. #6
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Peter,

    You seem to forget that when you first posted this it was 3:10 AM here where I live (actually was asleep then--go figure! :) ). And 12 hours later it was 3 in the afternoon and I was not done working for the day yet... although I sure wish I was as it was a beautiful day that I missed out on.

    I do agree that anyone who visited the site should have done as requested and leave a comment or at least acknowledged your efforts....and helping people can be a fairly thankless job at times but you do have to know that most of us here do appreciate everyone's efforts at doing so even though at times the thank yous are not given as they should be.

    You can put me on the list as one who would have liked to have visited your site to see an Alpha Web application in action.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  7. #7
    "Certified" Alphaholic mmaisterrena's Avatar
    Real Name
    Mauricio Maisterrena
    Join Date
    Nov 2006
    Location
    Torreon, Mexico
    Posts
    1,435

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    too bad now the user is blocked
    I was asleep too, im on mexico city time

  8. #8
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,827

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Peter, if it is any consolation, I've had my web demo up since 2004 and probably one out of a thousand visitors make any comments. No one has ever clicked the Email the Webmaster on the site in three years. But I'm also a guilty party on your application, sorry.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  9. #9
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,557

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    http://mail.dpmail.com.au:8001/media/login_me.a5w

    Login: alpha
    Password: developer

    Sorry everyone, forgot the world does not revolve around Australia, I was also feeling like crap the other day.

    Have a look, let me know about the speed.

    Cheers,

    Peter

  10. #10
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Peter,

    Thanks for putting the site back up.

    The speed is as good as most sites I visit--not instantaneous but rare to find a site that is...and the slight wait period of loading is not to the point of being irritating at all.

    Here are some things I noticed that you may or may not be aware of:

    You have on your media details page a small note to close the page on exit. It would be a bit more intuitive to have a button that maybe said "Back to Main Menu" or something similar--I was hesitant to close it until I made sure that the main page was in a separate window...but then this may just be me!

    I also noticed that when a search of various things came up with nothing all that was seen was a blank page just like when a page has not quite finished loading....so sat there until I was fairly certain it was not going to find anything! :) Am wondering if a notice of some kind could be used to indicate a null search for user friendliness.

    On the Media Details page I noticed some numbers in the left margin of the Primary Contacts area slightly greyed out.???

    All-in-all a very respectable site.

    Now had better be off to work!
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  11. #11
    VAR Pat Bremkamp's Avatar
    Real Name
    Pat Bremkamp
    Join Date
    Apr 2000
    Location
    Oregon, USA
    Posts
    2,595

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Peter,

    You have built a very nice site. Easy to use with a minimum of learning needed. I like the way you navigate through the site and only show what's necessary at each step.

    I had seen a post earlier about google maps, but hadn't considered the possibilities. Now that I've seen what you've done, I can think of all kinds of ways to use this in some of my work. I may be back to ask how you did that!

    Thank you for sharing that with us.

    Pat

  12. #12
    Member
    Real Name
    Charlain Fondren
    Join Date
    Oct 2002
    Posts
    345

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Peter,

    Thanks for re-opening your database! Nice site - very easy to understand and navigate. There were no speed issues for me.

    Linking to Google Maps is something I'd really like to include in the database I'm currently working on. I've read online that it's not as easy to link to a Google map as it is to one on Mapquest or Yahoo. Any tips on linking up to Google that you'd like to share?

    Thanks again for letting me have a look at your work!

    Charlain

  13. #13
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,629

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    The site is reasonably fast. I don't think it is any slower, than say, Dell, when ordering a new machine and searching options, etc. Some of the lookups (or all of them) open up slightly too small - I'm using FireFox. Also, some lookups (like the one for magazines) don't give you a sense of how many entries there are. Personally, i prefer the navigatior with the the page # total - e.g. [2 of 17]. This gives the user a sense of what they're up against. Useful for the random searcher, I think. Over all, nice job.

  14. #14
    VAR John Oesterle's Avatar
    Real Name
    John Oesterle
    Join Date
    Apr 2000
    Location
    Midwest
    Posts
    236

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    I thought the speed was quite acceptable...not a distraction like many sites offer. Google Maps is a great feature.

    I initially logged on using Firefox and found that there were several object placement/layout problems. For example,

    - text for your Nav bar on button 4 ran off the bar
    - text for other buttons exceeded the button width
    - multiple problems on your "Media Entry Details" page to the extent I couldn't easy understand the layout.

    No problems that I saw with Explorer 6 or 7. Nice site. Easily navigated. Thanks for the look!

    - John O
    ToolBytes LLC

  15. #15
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,557

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Many thanks to everyone, I'll take all the contructive advice on board.

    With FireFox, well that's an Alpha problem, I had to choose not to compromise my application, I just deliver it using stock tandard functions And if FireFox does not do it the same as Explorer then Alpha needs to fix it.

    There is no magic in the maps just a bit of later thinking.

    In the grid create a calculated field to do the job, then link to it.

    Code:
    Search_all   = if(AKA<>"",ALLTRIM(Name)+" ("+ALLTRIM(Aka)+")",Name)
    Full_Address = ALLTRIM(Address1)+" "+ALLTRIM(Address2)+" "+ALLTRIM(Suburb)+" "+ALLTRIM(State)+" "+ALLTRIM(Postcode)+IF(Phone_Main<>""," Tel:"+Phone_Main,"")+IF(Fax_Main<>""," Fax:"+Fax_Main,"")
    Google_Map   = "http://maps.google.com/maps?f=q&hl=en&q="+URLENCODE(ALLTRIM(Address2)+"+"+ALLTRIM(Suburb)+"+"+ALLTRIM(State)+"+"+ALLTRIM(Postcode)+"+"+"Australia")
    Google_image = "http://maps.google.com/maps?f=q&hl=en&q="+URLENCODE(ALLTRIM(Address2)+"+"+ALLTRIM(Suburb)+"+"+ALLTRIM(State)+"+"+ALLTRIM(Postcode)+"+"+"Australia")+"&spn=0.01421,0.027122&t=h&om=1&iwloc=addr"
    Google       = IF(Suburb<>"","Map","")
    Hybrid_map   = IF(ALLTRIM(media_header->Suburb)="","","Hybrid")
    I use the Google and Hybrid_map strings to display what the user will click on, if there is no map, then the string is blank, so nothing to click.

    Again, thanks everyone.

  16. #16
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,557

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    As I'm now fixing stuff the login is now off again.
    Cheers..

  17. #17
    Member René Stout's Avatar
    Real Name
    René Stout
    Join Date
    Oct 2003
    Location
    Tiendeveen, The Netherlands, Europe
    Posts
    529

    Default And for the dutch...

    I use the map feature in a dutch database. It is accessable without loggin in. Just give it a try.

    http://hofsvr07.hofstee.nl/nvst/webf...Ledenlijst.a5w

    Take a look at the code in the browser. It contains the dutch coding:
    Code:
    http://maps.google.nl/maps?f=q&hl=nl&q=Costa%20Ricastraat%2061,2408%20MJ,Alphen%20a/d%20Rijn,NL
    or:
    url: http://maps.google.nl/maps?
    language: f=q&hl=nl&q=
    address: Costa%20Ricastraat%2061,
    zip: 2408%20MJ,
    Town: Alphen%20a/d%20Rijn,
    Country: NL

    url, language and country are <hard quoted>, the other data are fields.
    René
    Windows 7, V11

  18. #18
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,557

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Works, well - well done. My clients think it's great.

  19. #19
    Member
    Real Name
    Gordon MacCarthy
    Join Date
    Jun 2007
    Posts
    50

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Hi Peter,

    Can you make that example available again. The login name and password is no longer valid. Thanks.

    Gordon MacCarthy
    Sarasota, FL

  20. #20
    Member jweasl's Avatar
    Real Name
    Jeremy Wessels
    Join Date
    Mar 2007
    Posts
    28

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Quote Originally Posted by GordonMac View Post
    Hi Peter,

    Can you make that example available again. The login name and password is no longer valid. Thanks.

    Gordon MacCarthy
    Sarasota, FL
    I am very interested in seeing this as well :-D

  21. #21
    Member EricN's Avatar
    Real Name
    Eric
    Join Date
    May 2007
    Location
    Minnesota
    Posts
    553

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    I'm attempting to create a link using the calculated area of grid component. This would be similar to Pete's above except I want to use Mapquest.

    I copied the http line from Mapquest's site...
    http://www.mapquest.com/maps/map.adp...St&city=Denver &state=CO&zipcode=80202&country=US&cid=lfmaplink

    Used the example from the help...
    urlencode("http://zip4.usps.com/zip4/welcome.jsp?address1=3350 e marconi ave") + "&" urlencode("address2=Apt 2") + "&" + urlencode("city=Phoenix") + "&" + urlencode("state=Arizona")

    but can't get it to work.

    This is what I currently have in the grid's calculated area
    Mapquest = urlencode("http://www.mapquest.com/maps/map.adp?address=Site_address") + "&" urlencode("city=Site_city") + "&" + urlencode("state=Site_state") + "&" + urlencode("Zip=Site_zip")

    I get the "extra characters at end of expression" warning. I've also tried many different variations but cant find a solution. The fields: Site_Address, Site_City, Site_state, & Site_zip are not being filled with any current values from the grid.

    I can get a link to Mapquest to work using a current field within the grid and making it into a link but I hope to use the calculated method instead.

    I'm sure it is just my syntax.

    Any help much appreciated.
    Eric

    Alpha Five Websites
    longlivepuppies.com
    socialservicenetwork.com
    -------------------------------------------------
    socialservicenetwork.org

  22. #22
    Member
    Real Name
    Joe Madre
    Join Date
    Apr 2006
    Posts
    49

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    You are urlencode()ing too much. That function encodes all characters that have a special meaning in a URL so they can be sent as strings safely. By encoding as much as you are, you are breaking the URL. You should just encode the values that come out of your database, since you can't guarantee that they will not have any of the characters that have special meaning in a URL*.

    Basically, what you want is this:

    Code:
    "http://www.mapquest.com/maps/map.adp?address=" + urlencode(Site_addres") + "&city=" + urlencode("Site_city") + "&state=" + urlencode("Site_state") + "&Zip=" + urlencode("Site_zip")
    * If you can somehow guarantee this through input validation, you can go without urlencode() for anything. But it is still safer to use it.

  23. #23
    Member EricN's Avatar
    Real Name
    Eric
    Join Date
    May 2007
    Location
    Minnesota
    Posts
    553

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Thanks Joe but this is what I get in my URL
    "http://www.mapquest.com/maps/map.adp?address=Site%5Faddress&city=Site%5Fcity&state=Site%5Fstate&Zip=Site%5Fzip"

    It is not picking up the values from the grid and placing the values in the Site_... fields.

    UPDATE
    ***************************************
    This works!
    Mapquest = "http://www.mapquest.com/maps/map.adp?address="+urlencode(Site_address)+"&city="+urlencode(Site_city)+"&state="+urlencode(Site_state)+"&Zip="+urlencode(Site_zip)

    Thank you Joe for steering me in the right direction!!
    Last edited by EricN; 01-31-2008 at 01:37 PM.
    Eric

    Alpha Five Websites
    longlivepuppies.com
    socialservicenetwork.com
    -------------------------------------------------
    socialservicenetwork.org

  24. #24
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,827

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    There is nothing in the string that needs urlencode() at all, leave it out. Glad you got it working, I was going to point to an article on my website titled "Alpha Five Web Application Server - programming examples" which has example code.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  25. #25
    Member
    Real Name
    Joe Madre
    Join Date
    Apr 2006
    Posts
    49

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    Eric: Sorry for the confusion, I had left those extra quotes in there by mistake.

    Steve: I've seen addresses entered as "East 123rd & Main". Spaces need to be encoded, though most browsers will fix them up for you if you forget. But the & has special meaning in a URL and will totally break the address you are sending to MapQuest or any other server. That's why I would rather be safe than sorry and encode everything unless I can somehow guarantee 100% that all elements of the address will always be safe in a URL. And even then, it is easy and harmless to encode the data as long as you are encoding properly so I'd still probably do it.

  26. #26
    Member
    Real Name
    Angelo Marcelo
    Join Date
    Mar 2010
    Posts
    27

    Default Re: Here is an Example, Google Maps, Images, GridLinker, Download

    I can't seem to log in to the site Pete.

    I'm getting "Invalid user name or password."

    i tried copy and paste and still no luck. is it still up?

Similar Threads

  1. Creating the live Google Maps and UPS tracking example
    By Richard Rabins in forum Announcements
    Replies: 0
    Last Post: 02-15-2007, 03:51 PM
  2. Google Maps and UPS in Alpha Five v8
    By Richard Rabins in forum Announcements
    Replies: 0
    Last Post: 01-26-2007, 03:08 PM
  3. Maps
    By Lanny Tonning in forum Alpha Five Version 7
    Replies: 4
    Last Post: 08-17-2006, 01:43 PM
  4. Google Example
    By jkukuda in forum Alpha Five Version 6
    Replies: 6
    Last Post: 04-18-2005, 07:59 AM
  5. Topic Maps - Anyone Using Or Planning To ?
    By acant05 in forum Alpha Five Version 5
    Replies: 4
    Last Post: 03-12-2003, 04:31 AM

Bookmarks

Posting Permissions

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