Hi Italo,What do you mean when saying Base "is missing the scripting feature"? Surely you can use macros in Base, as well as in other components of LibreOffice. These macros can be written in Baisc, which I have often used, or in some other languages, which I haven't tried myself. And without these surely a database application generally would be very "raw", confined to the basic actions. The work that Base or the the database does is essential for the whole business, and without it nothing would work, but the checks and actions done by the additional programming (using macros or even some sophisticated functions of the database system) are the points that end users can value. They decide about a system being accepted. Now much can be done using Basic macros, which is quite easy. Using them really is adding the salt to the dish. There may be some cases where Basic is too slow, because it is interpreting the code. Then you can use other scripting languages, which I haven't done, but other people speak of it. But there may be a big problem for people used to Access: as far as I understand, macros used in Access cannot be simply transferred to LibreOffice, because the Basic dialects are not completely compatible. I have never had to do with these problems, so I cannot say more, but I fear that this may be the cause for some people to reject trying LibreOffice. Which is a shame because looking at a problem from a new angle is in many cases very helpful. As regards Excel instead of Access or Calc instead of Base: that seems to be a general problem, the practically endless table of Calc/Excel provides the basic features most needed at first sight , without any effort for definition of structures; the difficulties creep in later, and the users try for a very long time to mend the problems, instead of rethinking the situation. This is a general problem, not concerned only with LibreOffice. I can only offer my opinion that in many cases the use of Excel (or Calc) is second best and due to a neglect of deeper investigation, which would have yielded a database solution, but how can we change that?
Greetings Gerhard Am 10.02.2019 um 19:08 schrieb Italo Vignoli:
I cannot disagree more. In Italy, most enterprises and every public administration are using Microsoft Access, and this represents a problem when they have to migrate to LibreOffice (as Base is not seen as a good replacement for Microsoft Access, because is missing the scripting feature). On 10/02/2019 10:56, Pedro Rosmaninho wrote:Just to mention that Microsoft Access (the equivalent to Base) is barely used in the professional world. Usually companies use Excel and connect it to MySQL or apps like PowerBI depending on the purpose. On Sun, Feb 10, 2019 at 9:40 AM Heiko Tietze <tietze.heiko@gmail.com> wrote:While the idea of the Notebookbar is exactly this, to provide completely different UIs, I doubt we can make Base "a variant of Calc“. But you are very welcome to draft the idea or implement yourself (should be possible for everyone who uses mailing lists).Am 07.02.2019 um 21:26 schrieb Miguel Mayol <mitcoes@gmail.com>: I had today a idea i think is a very good one: One interface option - better if it is the default one - in LO BASEequal to the CALC oneThe reason is that people are using EXCEL for databases because they do not know because they have the cheaper version of MSO without Access and because they think it is "easier" Doing this and a promo viral video that shows that it is - as easy as a spreadsheet to insert and show data - and as powerful as a database to deal with it, especially addressed to university professors and PhD students, probablywould increase a lot the use of BASE in substitution of MS Excel for managing databases, and the use of other components of LibreOffice.I went to bugzilla, but I was not able to log in, so sorry, but as Ionly collaborate with suggestions, I did not want this one that I think is great, and probably very easy to implement, to pass by.I remembered an old database named FileMaker that was very easy to usebecause it had a interface near to what a spreadsheet is. -- To unsubscribe e-mail to: design+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
-- To unsubscribe e-mail to: design+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy