ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Lotus Notes to Microsoft Access

    Job Postings
    9
    25
    4.5k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • DashrenderD
      Dashrender @JaredBusch
      last edited by

      @JaredBusch said in Lotus Notes to Microsoft Access:

      I would use LibreOffice Base over Access. Why pay for licensing for something barely used?

      0_1464366287582_upload-d45bcc4a-b0a9-445b-9fd5-efc726476fa3

      We already have Access as part of our Pro Plus VL - so no worries there..

      But, I thought it was the general consensus here to not ever use Access if possible, use other more enterprise tools like mySQL and something for a front end?

      JaredBuschJ 2 Replies Last reply Reply Quote 0
      • JaredBuschJ
        JaredBusch @Dashrender
        last edited by

        @Dashrender said in Lotus Notes to Microsoft Access:

        We already have Access as part of our Pro Plus VL - so no worries there..

        Who cares what your VL has? You are not the OP.

        1 Reply Last reply Reply Quote 0
        • JaredBuschJ
          JaredBusch @Dashrender
          last edited by JaredBusch

          @Dashrender said in Lotus Notes to Microsoft Access:

          But, I thought it was the general consensus here to not ever use Access if possible, use other more enterprise tools like mySQL and something for a front end?

          The development cost would never be worth it. No matter what @scottalanmiller says.

          I hate Access with a passion. I firmly believe it needs to die in a fire along with Faxing.

          That said Base or Access are the absolute right tool for this job.

          Mike DavisM 1 Reply Last reply Reply Quote 2
          • DashrenderD
            Dashrender
            last edited by

            OK so that's the situation eh? The dev for doing is this not as easy as using Access? that's a drag!

            JaredBuschJ 1 Reply Last reply Reply Quote 0
            • J
              Jason Banned @Mike Davis
              last edited by

              @Mike-Davis said in Lotus Notes to Microsoft Access:

              I have two .nsf files about 300MB each with text in them. (It might be formatted, but no images or attachments) that I need converted to Microsoft Access or Open Database.

              Why would you do this over converting them to Outlook Archives?

              1 Reply Last reply Reply Quote 0
              • Mike DavisM
                Mike Davis
                last edited by

                Outlook Archives? you mean what some people call .pst files? It's not email messages in the database. It's a database of old articles. Pretty basic files such as date, author, body, etc. Being purely text and getting up to 300MB each, it's a lot of records. More than Excel could hold. That was my first attempt.

                dafyreD 1 Reply Last reply Reply Quote 0
                • dafyreD
                  dafyre @Mike Davis
                  last edited by

                  @Mike-Davis said in Lotus Notes to Microsoft Access:

                  Outlook Archives? you mean what some people call .pst files? It's not email messages in the database. It's a database of old articles. Pretty basic files such as date, author, body, etc. Being purely text and getting up to 300MB each, it's a lot of records. More than Excel could hold. That was my first attempt.

                  How are the articles separated?

                  1 Reply Last reply Reply Quote 0
                  • Mike DavisM
                    Mike Davis
                    last edited by

                    Each article is it's own record.

                    1 Reply Last reply Reply Quote 0
                    • Mike DavisM
                      Mike Davis @JaredBusch
                      last edited by

                      @JaredBusch said in Lotus Notes to Microsoft Access:

                      @Dashrender said in Lotus Notes to Microsoft Access:

                      But, I thought it was the general consensus here to not ever use Access if possible, use other more enterprise tools like mySQL and something for a front end?

                      The development cost would never be worth it. No matter what @scottalanmiller says.

                      I hate Access with a passion. I firmly believe it needs to die in a fire along with Faxing.

                      That said Base or Access are the absolute right tool for this job.

                      They have Access already installed and I'm willing to install Base on each computer just for this. I should probably add this is just a legacy system that is read only, so it's not going to grow and use over time will decline.

                      dafyreD JaredBuschJ 2 Replies Last reply Reply Quote 1
                      • dafyreD
                        dafyre @Mike Davis
                        last edited by

                        @Mike-Davis said in Lotus Notes to Microsoft Access:

                        @JaredBusch said in Lotus Notes to Microsoft Access:

                        @Dashrender said in Lotus Notes to Microsoft Access:

                        But, I thought it was the general consensus here to not ever use Access if possible, use other more enterprise tools like mySQL and something for a front end?

                        The development cost would never be worth it. No matter what @scottalanmiller says.

                        I hate Access with a passion. I firmly believe it needs to die in a fire along with Faxing.

                        That said Base or Access are the absolute right tool for this job.

                        They have Access already installed and I'm willing to install Base on each computer just for this. I should probably add this is just a legacy system that is read only, so it's not going to grow and use over time will decline.

                        Ah, ok. I was under the impression these were flat text file type deals. If you already have licenses for Access, why use Base?

                        1 Reply Last reply Reply Quote 1
                        • JaredBuschJ
                          JaredBusch @Dashrender
                          last edited by

                          @Dashrender said in Lotus Notes to Microsoft Access:

                          OK so that's the situation eh? The dev for doing is this not as easy as using Access? that's a drag!

                          You continue to add things that do not exist. Who said anything about the specific dev for this? No one. Who said anything about owning Access (at the time you posted this)? No one.

                          DashrenderD 1 Reply Last reply Reply Quote 0
                          • JaredBuschJ
                            JaredBusch @Mike Davis
                            last edited by

                            @Mike-Davis said in Lotus Notes to Microsoft Access:

                            @JaredBusch said in Lotus Notes to Microsoft Access:

                            @Dashrender said in Lotus Notes to Microsoft Access:

                            But, I thought it was the general consensus here to not ever use Access if possible, use other more enterprise tools like mySQL and something for a front end?

                            The development cost would never be worth it. No matter what @scottalanmiller says.

                            I hate Access with a passion. I firmly believe it needs to die in a fire along with Faxing.

                            That said Base or Access are the absolute right tool for this job.

                            They have Access already installed and I'm willing to install Base on each computer just for this. I should probably add this is just a legacy system that is read only, so it's not going to grow and use over time will decline.

                            Alright, you own access already, so it is certainly an option. You can go that route or Base. Completely up to you. You can even just do it to Access right now and if you want to get off MS later, migrate it to Base with this extension.

                            @Dashrender the problem with using an actual database like MySQL/MariaDB/SQL Express is that you then have to write an interface to even look at the data. For simple data, it is much easier to simply use the GUI that Access/Base provides to look at records.

                            DashrenderD scottalanmillerS 2 Replies Last reply Reply Quote 0
                            • J
                              Jason Banned
                              last edited by Jason

                              If it's just text you could do wordpress maybe for it? Don't know just a random thought

                              But if you have Access already there's no reason not to use it.

                              1 Reply Last reply Reply Quote 0
                              • DashrenderD
                                Dashrender @JaredBusch
                                last edited by

                                @JaredBusch said in Lotus Notes to Microsoft Access:

                                @Dashrender said in Lotus Notes to Microsoft Access:

                                OK so that's the situation eh? The dev for doing is this not as easy as using Access? that's a drag!

                                You continue to add things that do not exist. Who said anything about the specific dev for this? No one. Who said anything about owning Access (at the time you posted this)? No one.

                                Dude STFU - I'm asking for me, not the OP.. yes I'm butting the FUCK into his conversation, but it's mine.. so either answer my question or ignore me, don't harass me 🙂

                                JaredBuschJ 1 Reply Last reply Reply Quote -1
                                • DashrenderD
                                  Dashrender @JaredBusch
                                  last edited by

                                  @JaredBusch said in Lotus Notes to Microsoft Access:

                                  @Dashrender the problem with using an actual database like MySQL/MariaDB/SQL Express is that you then have to write an interface to even look at the data. For simple data, it is much easier to simply use the GUI that Access/Base provides to look at records.

                                  Thank you!

                                  1 Reply Last reply Reply Quote 0
                                  • JaredBuschJ
                                    JaredBusch @Dashrender
                                    last edited by JaredBusch

                                    @Dashrender said in Lotus Notes to Microsoft Access:

                                    @JaredBusch said in Lotus Notes to Microsoft Access:

                                    @Dashrender said in Lotus Notes to Microsoft Access:

                                    OK so that's the situation eh? The dev for doing is this not as easy as using Access? that's a drag!

                                    You continue to add things that do not exist. Who said anything about the specific dev for this? No one. Who said anything about owning Access (at the time you posted this)? No one.

                                    Dude STFU - I'm asking for me, not the OP.. yes I'm butting the FUCK into his conversation, but it's mine.. so either answer my question or ignore me, don't harass me 🙂

                                    Ask your own question.
                                    https://community.spiceworks.com/topic/262564-ask-your-own-question

                                    1 Reply Last reply Reply Quote 0
                                    • PSX_DefectorP
                                      PSX_Defector @Mike Davis
                                      last edited by

                                      https://www-10.lotus.com/ldd/dominowiki.nsf/dx/Importing_Data_from_Notes_Database(.nsf_File)_into_Excel_.xls_File

                                      Hope your shit is up to date, the last time I tried to do this I was running Domino 4 and I didn't have an OBDC driver to leverage.

                                      Files are also flat, so you will need to rebuild your relationships if you have them. If all you need is the data and don't plan on adding to it, export it out into Excel spreadsheets and format accordingly.

                                      1 Reply Last reply Reply Quote 0
                                      • scottalanmillerS
                                        scottalanmiller @JaredBusch
                                        last edited by

                                        @JaredBusch said in Lotus Notes to Microsoft Access:

                                        @Dashrender the problem with using an actual database like MySQL/MariaDB/SQL Express is that you then have to write an interface to even look at the data. For simple data, it is much easier to simply use the GUI that Access/Base provides to look at records.

                                        That's mostly true. If the data is flat or flat-ish, though, standard free tools like myPhpAdmin will give you a GUI without any extra effort. It's not technically included in the base package, but is so standard that many people think of it that way. But definitely would not require writing your own interface if the data did not need to be reassembled in a relational way.

                                        1 Reply Last reply Reply Quote 0
                                        • 1
                                        • 2
                                        • 1 / 2
                                        • First post
                                          Last post