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.
-
Perhaps using Odbc in Access you can import the tables and Views.
-
Assuming you moved this to MySQL or any of a dozen other free dbs, what does one use for the front end?
-
The client doesn't really care what the front end is. The UI isn't anything fancy as it is and there are only 3 people in one office that actually use it anymore. They just don't want to lose access to the data when we shutdown the Lotus Notes server. I'd rather stay away from something like a LAMP setup because then I would have to support an entire server. I'd much rather have it sitting as a file on their Windows server. It doesn't even have to be multiuser.
-
@Mike-Davis if you PM me your contact info I'll have my notes expect contact you
-
@Mike-Davis said in Lotus Notes to Microsoft Access:
The client doesn't really care what the front end is. The UI isn't anything fancy as it is and there are only 3 people in one office that actually use it anymore. They just don't want to lose access to the data when we shutdown the Lotus Notes server. I'd rather stay away from something like a LAMP setup because then I would have to support an entire server. I'd much rather have it sitting as a file on their Windows server. It doesn't even have to be multiuser.
I despise the idea of using an Access DB, but I have no clue what the front end would be for a mariaDB, etc. So I need major help in understanding that part, this is where Access is a major win.
-
I would use LibreOffice Base over Access. Why pay for licensing for something barely used?
-
@JaredBusch said in Lotus Notes to Microsoft Access:
I would use LibreOffice Base over Access. Why pay for licensing for something barely used?
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?
-
@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.
-
@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.
-
OK so that's the situation eh? The dev for doing is this not as easy as using Access? that's a drag!
-
@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?
-
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.
-
@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?
-
Each article is it's own record.
-
@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.
-
@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?
-
@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.
-
@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.
-
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.
