Re: [libreoffice-users] Re: Auto Filling Drop Down Boxes
Hi :) Thanks for those links. Some useful information that does indeed contradict what i have previously heard about Base. It makes me wonder about the accuracy of other information i have seen about Base in a variety of places. No, of course i am not going to name names or divulge sources after the way i have been treated. I will quietly ask a few people to see how the misunderstandings arose and see what they say about the links you just gave. More importantly it gives me enough confidence to try out Base myself at work to see if migration is possible after all. Given that this is the first good news i have had about Base i still wouldn't recommend it to other people but it's obviously worth testing if there is enough time. For myself i will make time to test it. Regards from Tom :) --- On Sat, 24/9/11, NoOp gl...@sbcglobal.net wrote: From: NoOp gl...@sbcglobal.net Subject: [libreoffice-users] Re: Auto Filling Drop Down Boxes To: users@global.libreoffice.org Date: Saturday, 24 September, 2011, 0:35 On 09/23/2011 06:55 AM, Tom Davies wrote: Hi :) Lol. Cor appears to be accusing me of being wrong but with no proof to support the accusation. The only link he did give appears to bolster my assertions. It appears to show a lot of work going into Calc and the other apps but none into Base. Of course it is pure geek and difficult to understand but the few i clicked seemed to mention something about Calc and one mentioned wizards. None mentioned Base. The other accusation Cor appears to make is that i have not provided the type of proof he wants, which is a bit hypocritical imo as there is no proof that my assertions were inaccurate or misleading at all. He provided you with a link to query the work being done in LO on Base: http://cgit.freedesktop.org/libreoffice/core/log/ Enter 'dbaccess in the search window you'll see the dev work on Base. That results in: http://cgit.freedesktop.org/libreoffice/core/log/?qt=grepq=dbaccess Another is: http://cgit.freedesktop.org/libreoffice/core/log/connectivity I'm not sure what others may be involved, but it is clear that there is development work on Base in LO. I do know 1 person that has been trying to work on Base and a few people tell me there is another one but the work is not easy. And that person is? It seems to me that there are several people working on Base. Disclaimer: I've just learned about http://cgit.freedesktop.org/libreoffice/core/log/ as well and am still working my way through it. However your continued FUD regarding Base advising new users on this list to stick to Access et al seems to be just that: FUD. Before you continue posting the like, how about actually trying to find out the facts? None of this is relevant to the original question and i think the time would be better spent helping people rather than wasting everyone else's time with this sort of nonsense so publicly. It is possible to send emails to individuals off-list if you think they are wrong in some way. Regards from Tom :) Actually time would be better spent assisting the user with Base rather than making such statments as: I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. and It's just that almost everyone avoids Base. While Writer and Cal and the rest attract a LOT of devs they just avoid Base.. If you can't back up those statements with fact, then they are better left unsaid. Gary Lee --- On Fri, 23/9/11, Cor Nouws oo...@nouenoff.nl wrote: From: Cor Nouws oo...@nouenoff.nl Subject: Re: [libreoffice-users] Auto Filling Drop Down Boxes To: users@global.libreoffice.org Date: Friday, 23 September, 2011, 13:58 Tom Davies wrote (23-09-11 14:27) Hi :( If you are familiar with those tools then i am sure you could find an answer faster. Irrelevant. *You* make the statements - lots of well reading sentences that seem to make sense but may as well be tendentious or misleading. So if you do not give a solid ground to your statements, or even want to make real effort in trying to do so, then please stop making them. -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe
Re: [libreoffice-users] Re: Auto Filling Drop Down Boxes
Hi Tom, When there have been posts about this or that in Base, generally there have been quite a few people who have participated. It may be used more than most people realize. Shortly after Base became a part of OpenOffice, I converted, successfully, all of my data from Paradox to Base. If I had been using Access, it would have been slightly easier. Base has been an extremely dependable program for me. The only issue I've had is the one with Java. Yes, I'm aware of a couple of bugs, but none of those affect me in any meaningful way. I've been using it for about 8 years and would not change to anything else since it has worked so well for me, and it serves my needs. Don On 09/24/2011 05:14 AM, Tom Davies wrote: Hi :) Thanks for those links. Some useful information that does indeed contradict what i have previously heard about Base. It makes me wonder about the accuracy of other information i have seen about Base in a variety of places. No, of course i am not going to name names or divulge sources after the way i have been treated. I will quietly ask a few people to see how the misunderstandings arose and see what they say about the links you just gave. More importantly it gives me enough confidence to try out Base myself at work to see if migration is possible after all. Given that this is the first good news i have had about Base i still wouldn't recommend it to other people but it's obviously worth testing if there is enough time. For myself i will make time to test it. Regards from Tom :) --- On Sat, 24/9/11, NoOpgl...@sbcglobal.net wrote: From: NoOpgl...@sbcglobal.net Subject: [libreoffice-users] Re: Auto Filling Drop Down Boxes To: users@global.libreoffice.org Date: Saturday, 24 September, 2011, 0:35 On 09/23/2011 06:55 AM, Tom Davies wrote: Hi :) Lol. Cor appears to be accusing me of being wrong but with no proof to support the accusation. The only link he did give appears to bolster my assertions. It appears to show a lot of work going into Calc and the other apps but none into Base. Of course it is pure geek and difficult to understand but the few i clicked seemed to mention something about Calc and one mentioned wizards. None mentioned Base. The other accusation Cor appears to make is that i have not provided the type of proof he wants, which is a bit hypocritical imo as there is no proof that my assertions were inaccurate or misleading at all. He provided you with a link to query the work being done in LO on Base: http://cgit.freedesktop.org/libreoffice/core/log/ Enter 'dbaccess in the search window you'll see the dev work on Base. That results in: http://cgit.freedesktop.org/libreoffice/core/log/?qt=grepq=dbaccess Another is: http://cgit.freedesktop.org/libreoffice/core/log/connectivity I'm not sure what others may be involved, but it is clear that there is development work on Base in LO. I do know 1 person that has been trying to work on Base and a few people tell me there is another one but the work is not easy. And that person is? It seems to me that there are several people working on Base. Disclaimer: I've just learned about http://cgit.freedesktop.org/libreoffice/core/log/ as well and am still working my way through it. However your continued FUD regarding Base advising new users on this list to stick to Access et al seems to be just that: FUD. Before you continue posting the like, how about actually trying to find out the facts? None of this is relevant to the original question and i think the time would be better spent helping people rather than wasting everyone else's time with this sort of nonsense so publicly. It is possible to send emails to individuals off-list if you think they are wrong in some way. Regards from Tom :) Actually time would be better spent assisting the user with Base rather than making such statments as: I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. and It's just that almost everyone avoids Base. While Writer and Cal and the rest attract a LOT of devs they just avoid Base.. If you can't back up those statements with fact, then they are better left unsaid. Gary Lee --- On Fri, 23/9/11, Cor Nouwsoo...@nouenoff.nl wrote: From: Cor Nouwsoo...@nouenoff.nl Subject: Re: [libreoffice-users] Auto Filling Drop Down Boxes To: users@global.libreoffice.org Date: Friday, 23 September, 2011, 13:58 Tom Davies wrote (23-09-11 14:27) Hi :( If you are familiar with those tools then i am sure you could find an answer faster. Irrelevant. *You* make the statements - lots of well reading sentences that seem to make sense but may as well be tendentious or misleading. So if you do not give a solid ground to your statements, or even want to make real effort in trying to do so, then please stop making them. -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http
[libreoffice-users] Re: Auto Filling Drop Down Boxes
Quick and dirty draft of an embedded HSQLDB with US zip codes: http://www.mediafire.com/?1k312s62qupaqgb The form's dummy text field stands for all those name, address, phone, email fields that may be in a list of addresses. The list box lets you select one particular ZIP code which stands for one particular entry in the list of zips with ZIP, city, county, state. Query qReport merges the info of all tables: Dummy Text ZIP PO Name State LATITUDELONGITUDE - address #1 32009 BRYCEVILLE FLORIDA 30,52111-81,90605 address #2 20015 WASHINGTON DISTRICT OF COLUMBIA38,96926 -77,07095 address #3 10011 NEW YORKNEW YORK40,74092 -73,99977 Addr #4 10046 NEW YORKNEW YORK40,78075-73,97718 addr #5 56035 GENEVA MINNESOTA 43,6739 -93,34887 In theory it should be possible to create an nice looking report with x/y-chart indicating the positions by latitude and longitude. I don't get it in the report builder, may be because I really hate this tool. It's trivial to build such a report with chart on a Calc sheet though. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
Am 23.09.2011 04:26, NoOp wrote: On 09/22/2011 01:40 AM, Andreas Säger wrote: This is impossible because big cities have more than one ZIP and there are ambiguous city names. Actually it's not if you have (in the US) the USPS 5 digit Zip Code database: https://www.usps.com/business/address-information-systems.htm# Five-Digit ZIP® Product I have this list of all USPS zip codes in a .dbf file. http://www.mediafire.com/?cb2tw57jxw32khg A database can help you to find the zip by full address. For logical reasons you can not get the right zip from a city name, but you always get the city name from the zip. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
Am 21.09.2011 19:00, stripedtomato wrote: I have three drop down boxes: City, State, Zip as part of an address record. As of now, I have to make independent selections for each of these drop down boxes. What I would like to do is when selecting a city from the drop down box list, then related state and zip information would automatically be filled in, in their respective drop down boxes, and the information stored in their respective db cells. This is impossible because big cities have more than one ZIP and there are ambiguous city names. You may enter a city name and then choose the actual city and zip from suggested data. I use to enter zip codes. Each zip code belongs to one particular city in one state. Apart from this, big companies and public sectors have their own zip codes. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
Am 21.09.2011 19:09, Tom Davies wrote: Hi :) I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. Regards from Tom :) These things use to work since OOo 1.0 (long before Base) and when they break, the whole office suite would be useless for many millions of potential users. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
On 09/21/2011 10:09 AM, Tom Davies wrote: Hi :) I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. You keep dishing out this advise... that and It's just that almost everyone avoids Base. why? At every turn I see you advising users on this list to 'avoid' Base, stick with Access, use something else. Base is a primary component of LO, and before LO, OOo. Do you have some link to facts that within LO there is almost no-one (sic) working on Base? ... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Auto Filling Drop Down Boxes
Am 21.09.2011 19:00, stripedtomato wrote: I have three drop down boxes: City, State, Zip as part of an address record. As of now, I have to make independent selections for each of these drop down boxes. What I would like to do is when selecting a city from the drop down box list, then related state and zip information would automatically be filled in, in their respective drop down boxes, and the information stored in their respective db cells. == 22/09/2011: Andreas S�ger Wrote:- This is impossible because big cities have more than one ZIP and there are ambiguous city names. You may enter a city name and then choose the actual city and zip from suggested data. I use to enter zip codes. Each zip code belongs to one particular city in one state. Apart from this, big companies and public sectors have their own zip codes. == Hi stripedtomato, What you want to do is actually very easy. At least in Australia where it is possible to download a postcode file from the post office (what USA folk call a zip code we call a postcode (with no spaces)). However even without starting from a set data file it is still possible to create the tables and code and add zip codes as and when required. In the City/Suburb drop down list, all cities, suburbs, towns, villages and other zip codes for the relevant country are listed and should be sorted alphabetically then if there are thirty instances of Bridge Town for example each would have additional columns in the dropdown list for State, zip code and any other information needed to quickly identify the correct Bridge Town then in the afterupdate or onvalidate event (etc. depending on programming platform) simply write code to add the relevant data from the state and zip code columns in the list. Of course to do this you will need a dropdown control capable of handling multiple columns. You could do as Andreas S�ger suggested and sort the list by zip code but that would mean that everyone using the system would need to know the zip codes but this is not very practicable as most people find it much easier to remember actual names rather than the relevant code. So if there was a Bridge Town MA or Bridge Town CA or Bridge Town NJ most users would know instantly which Bridge Town they wanted. (I'm only guessing with Bridge Town because the last time I was in the United States of America I lost count of the number of Bridge Towns I drove through. A bit like Kingston in Australia. Every state's got at least one.) Also in Australia, I'm guessing that it's much the same in your country, there are many small adjoining suburbs with the same postcode. So just entering a zip code would not necessarily give the correct data for location name and state. In Great Brittan and parts of Europe it is much more difficult because each street has at least one or more postcodes, however these codes come in two parts, the first part represents the area and the second part represents a section of the street. Cheers, if you need any code samples, let me know what platform you are using and I'll see if I can help, Bruce Carlson. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
On 09/22/2011 01:40 AM, Andreas Säger wrote: Am 21.09.2011 19:00, stripedtomato wrote: I have three drop down boxes: City, State, Zip as part of an address record. As of now, I have to make independent selections for each of these drop down boxes. What I would like to do is when selecting a city from the drop down box list, then related state and zip information would automatically be filled in, in their respective drop down boxes, and the information stored in their respective db cells. This is impossible because big cities have more than one ZIP and there are ambiguous city names. Actually it's not if you have (in the US) the USPS 5 digit Zip Code database: https://www.usps.com/business/address-information-systems.htm# Five-Digit ZIP® Product Provides 5-digit ZIP Code data that can be appended to computerized mailing lists via address-matching software. With that (or similar) I think that you could easily build a dropdown that links to that. You'd probably need to fine tune by address as each city, street, business may have differing Zip/Postal Codes Unfortunately the USPS doesn't offer an easy way to order: For more information on the AIS View, please contact the National Customer Support Center at 1-800-238-3150, Option 6 and then Option 2 to speak to a customer service representative. You may enter a city name and then choose the actual city and zip from suggested data. I use to enter zip codes. Each zip code belongs to one particular city in one state. Apart from this, big companies and public sectors have their own zip codes. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
Le 21/09/11 19:09, Tom Davies a écrit : Hi Tom, I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. Regards from The poster's question is a common one, which has been answered many times on the OpenOffice.org forums. Yes, cascading dropdown autofill list boxes are a PITA to do on Base, but they can (or at least could) be done with a bit of effort. http://www.oooforum.org/forum/viewtopic.phtml?t=103213 http://user.services.openoffice.org/en/forum/viewtopic.php?f=83t=28235 http://www.oooforum.org/forum/viewtopic.phtml?t=91166highlight=listbox http://www.oooforum.org/forum/viewtopic.phtml?t=59711 http://user.services.openoffice.org/en/forum/download/file.php?id=8687sid=38470f46e1b5b28cdaccf89573dcf574 http://user.services.openoffice.org/en/forum/download/file.php?id=7306 http://www.oooforum.org/forum/viewtopic.phtml?p=386982 These should get that person started. The LibreOffice mailing lists are too young in substance to be of much use for more technical questions like this, the forums, on the other hand, are replete with lots of useful information if you know where to look. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted