If this is not the right forum for solving the issues I face, please
refer me to the right one and I'll certainly take my queries there.
Thanks,
Swarup
On Thu, 2007-09-27 at 09:32 -0400, Dinbandhu wrote:
> On Tue, 2007-09-25 at 15:18 -0400, Andrew Jensen wrote:
> > Well, if all you really want to do is query it.
> >
> > Copy it to a directory within your Linux partition ( not absolutely
> > necessary )
> > From OO.org create a new Base file.
> > Instead of a default type select 'Connect to existing database..' and
> > select TEXT from the drop down listbox.
> >
> > Follow the instructions and where asked for select the directory where
> > the file is located.
> >
> > When you open the Base file the file will appear as a table.
> >
> > If you need to edit the data it is a little different.
>
> I have tried this several times, but what I get when I open the Base
> file and click on "table", is not a table but rather that text file with
> all the fields separated by commas.
>
> When I select 'Connect to existing databse...' and select "TEXT" from
> the drop down listbox, then in the next window it asks whether the file
> is of type "text (.txt)", or "CSV (.csv)". There, if I select "text"
> then I get the result described above. And if I select "csv" then the
> database is created with nothing in it.
>
> The file which I export from MS Access does have as its suffix, ".txt".
>
> In the MSA export window, there is no "csv" option as such. There is
> only "txt". In the MSA export wizard, you select to export as "Text
> Files". Then in the next window it asks you whether you want the export
> format as "Delimited (Characters such as comma separate each field)", or
> "Fixed width (Fields are aligned in columns with spaces between each
> field)". I selected "Delimited". Then it asks to choose the delimiter
> that will separate the fields-- so I selected "comma". And the "Text
> qualifier", I let remain as the default ("). Having selected these
> parameters, the file is then exported as type ".txt". So I could not
> figure any way for it to export with type ".csv".
>
> Have I made some error in the above-described process?
>
> Swarup
>
>
>
>
>
>
>
>
> > On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote:
> > > On Tue, 2007-09-25 at 15:02 -0400, Andrew Jensen wrote:
> > > > Wonderful then,
> > > >
> > > > I am sorry that I got caught up with D&D and all that malarkey before,
> > > > forgetting to look at the best way to get the job done with the tool.
> > > >
> > > > Best of luck with your work
> > > >
> > > > Drew
> > >
> > >
> > > Wait-- give me a hint at least, what is the procedure for bringing this
> > > CSV file into linux OO Base?
> > >
> > > Is it a copy and paste? If so, into what window?
> > > Is there an import wizard for it?
> > >
> > > --not sure what you mean by D&D, what you have taught me so far has been
> > > invaluable.
> > >
> > > Swarup
> > >
> > >
> > >
> > > >
> > > > On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote:
> > > > > On Tue, 2007-09-25 at 14:00 -0400, Andrew Jensen wrote:
> > > > > > OK- good, CSV is a good enough choice.
> > > > > >
> > > > > > The real question now is. Just how similar are those different MSA
> > > > > > database tables.
> > > > >
> > > > > Actually, the job is going to be simpler than you think. I only have
> > > > > one
> > > > > table in the database. It is a largish table--in comparison with most
> > > > > of
> > > > > what I do in a database--as it has around 5000 rows.
> > > > >
> > > > > The table is an address list. Each row represents a recipient of our
> > > > > newsletter, i.e. an addressee. And there are around 25 columns. The
> > > > > columns are mostly of type text, but there are several columns which
> > > > > are
> > > > > of type date, and there are some boolean columns as well.
> > > > >
> > > > > There are several queries that I use with that table, but those I can
> > > > > deal with afterward. I will either bring the queries in using the SQL
> > > > > export you pointed out to me if it works smoothly, or I'll recreate
> > > > > the
> > > > > queries in base from scratch.
> > > > >
> > > > > > If they are real close in structure then using a linked TEXT table
> > > > > > in
> > > > > > your Base file works very well and I can walk you through doing
> > > > > > that -
> > > > > > the actual HSQLdb manual gives you the syntax and there are a some
> > > > > > good examples of using Base with it. Speaking of which you don't
> > > > > > read
> > > > > > French by any chance do you?
> > > > >
> > > > > I don't read French well enough to learn from a technical document,
> > > > > unfortunately. But then, I don't think I'll be needing to set up the
> > > > > sort of technical linked Text table to which you refer.
> > > > >
> > > > > Swarup
> > > > >
> > > > >
> > > > > > On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote:
> > > > > > > On Tue, 2007-09-25 at 08:53 -0600, Tim wrote:
> > > > > > > > text/csv is usually the best bet. It can usually be imported
> > > > > > > > into any
> > > > > > > > db. If you decide to use postgresql, I can probably help. I
> > > > > > > > have been
> > > > > > > > importing text/csv files into postresql a lot lately. I use
> > > > > > > > postgresql
> > > > > > > > and OOo on both WinXP and Ubuntu linux.
> > > > > > >
> > > > > > > Thank you. That would be great.
> > > > > > >
> > > > > > > I'll use whatever you think best.
> > > > > > >
> > > > > > > I just went into the MSA file in Windows, selected the table I
> > > > > > > want to
> > > > > > > export, and exported it as type "Text Files". I selected "comma"
> > > > > > > as the
> > > > > > > separator, and the export went fine. It is now a "Text Document"
> > > > > > > sitting
> > > > > > > on my XP desktop.
> > > > > > >
> > > > > > > So if I now boot up into Ubuntu and open OO Base, then what will
> > > > > > > be the
> > > > > > > procedure for bringing this table into Base from my XP desktop?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Swarup
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > > Dinbandhu wrote:
> > > > > > > > > On Tue, 2007-09-25 at 10:17 -0400, Andrew Jensen wrote:
> > > > > > > > >> Swarup,
> > > > > > > > >>
> > > > > > > > >> WOW
> > > > > > > > >>
> > > > > > > > >> You have Access 2003, correct.
> > > > > > > > >>
> > > > > > > > >> Start Access and open your file.
> > > > > > > > >> File > Export
> > > > > > > > >>
> > > > > > > > >> Pick some file based export.
> > > > > > > > >>
> > > > > > > > >> Export your data.
> > > > > > > > >
> > > > > > > > > I have MS Access 2000.
> > > > > > > > >
> > > > > > > > > When I open my file, and go to File > Export, there are a
> > > > > > > > > variety of
> > > > > > > > > options as you know.
> > > > > > > > >
> > > > > > > > > You said it should be "file based".
> > > > > > > > >
> > > > > > > > > There in the options list, I see:
> > > > > > > > >
> > > > > > > > > Text Files
> > > > > > > > > Rich Text Format
> > > > > > > > > ODBC Databases
> > > > > > > > > HTML Documents
> > > > > > > > >
> > > > > > > > > Would any of the above be good?
> > > > > > > > >
> > > > > > > > > Once I do the above export, then to bring it into Linux OO
> > > > > > > > > Base will I
> > > > > > > > > be doing a copy and paste, or is it instead an actual "import"
> > > > > > > > > procedure? Will it involve the "connect to an existing
> > > > > > > > > database" option
> > > > > > > > > in Base?
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > > Swarup
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >> On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote:
> > > > > > > > >>> On Tue, 2007-09-25 at 09:34 -0400, Andrew Jensen wrote:
> > > > > > > > >>>> Hi Swarup,
> > > > > > > > >>>>
> > > > > > > > >>>> Yes, the same people that asked you to upgrade are now
> > > > > > > > >>>> telling you
> > > > > > > > >>>> that after doing so the option is no longer available to
> > > > > > > > >>>> do what it is
> > > > > > > > >>>> you actually wanted to do, in the way you actually wanted
> > > > > > > > >>>> to do it.
> > > > > > > > >>>>
> > > > > > > > >>>> I was one of those people and I apologize.
> > > > > > > > >>>>
> > > > > > > > >>>> What Mechtilde means, I think, is that since OO.org is
> > > > > > > > >>>> free you could
> > > > > > > > >>>> always put a copy under windows, migrate your data to Base
> > > > > > > > >>>> there, then
> > > > > > > > >>>> copy the Base file from the XP formatted partition to the
> > > > > > > > >>>> Linux
> > > > > > > > >>>> formatted partition.
> > > > > > > > >>> As Mechtilde has just explained, he actually refers to an
> > > > > > > > >>> external HSQL
> > > > > > > > >>> DB, rather than the internal one. He recommended MySQL or
> > > > > > > > >>> Postgresql or
> > > > > > > > >>> Oracle.
> > > > > > > > >>>
> > > > > > > > >>> So what would be the best, simplest, most straight forward
> > > > > > > > >>> way of
> > > > > > > > >>> proceeding here? My databases are not complex, I just need
> > > > > > > > >>> to import
> > > > > > > > >>> them in some simple clean way. I could easily download and
> > > > > > > > >>> install the
> > > > > > > > >>> OO 2.3 for Windows if that works well. Or I could try using
> > > > > > > > >>> one of the
> > > > > > > > >>> external HSQL formats if someone explains how it is done
> > > > > > > > >>> (or if there is
> > > > > > > > >>> a good HowTo somewhere).
> > > > > > > > >>>
> > > > > > > > >>> Or failing all that, I will just have to install OO 2.2 on
> > > > > > > > >>> the computer.
> > > > > > > > >>> If nothing else, I know quite well at this point how to do
> > > > > > > > >>> the import
> > > > > > > > >>> that way. I could do all my imports using OO 2.2, then when
> > > > > > > > >>> they're
> > > > > > > > >>> imported, replace 2.2 with 2.3 so I can use 2.3's Forms
> > > > > > > > >>> Wizard. This is
> > > > > > > > >>> a bit of a convoluted approach, but I least I now how to do
> > > > > > > > >>> it.
> > > > > > > > >>>
> > > > > > > > >>> I would rather use either Windows OO 2.3 or an external
> > > > > > > > >>> HSQL DB if they
> > > > > > > > >>> would work well and there is some clear explanation
> > > > > > > > >>> available as to how
> > > > > > > > >>> to do it.
> > > > > > > > >>>
> > > > > > > > >>> Thank you,
> > > > > > > > >>> Regards,
> > > > > > > > >>> Swarup
> > > > > > > > >>>
> > > > > > > > >>>
> > > > > > > > >>>
> > > > > > > > >>>
> > > > > > > > >>>
> > > > > > > > >>>
> > > > > > > > >>>> On 9/25/07, Dinbandhu <[EMAIL PROTECTED]> wrote:
> > > > > > > > >>>>> On Tue, 2007-09-25 at 15:22 +0200, Mechtilde wrote:
> > > > > > > > >>>>>> Frank Schönheit - Sun Microsystems Germany schrieb:
> > > > > > > > >>>>>>> Hello Swarup,
> > > > > > > > >>>>>>>
> > > > > > > > >>>>>>>> I am trying to "connect to an existing database" using
> > > > > > > > >>>>>>>> OO 2.3 Base
> > > > > > > > >>>>>>>> (OS=Linux Ubuntu). The existing database is an MSA
> > > > > > > > >>>>>>>> database in my
> > > > > > > > >>>>>>>> windows partition.
> > > > > > > > >>>>>>> Debian-based distributions contained an experimental
> > > > > > > > >>>>>>> Linux-driver for
> > > > > > > > >>>>>>> .mdb files, but this driver has been removed in their
> > > > > > > > >>>>>>> 2.3 version.
> > > > > > > > >>>>>>> Which, as sorry as this might be, is correct as the
> > > > > > > > >>>>>>> driver was pretty
> > > > > > > > >>>>>>> flawed and effectively a danger to your data.
> > > > > > > > >>>>>> I can confirm this. You can do the connection under
> > > > > > > > >>>>>> Windows to migrate
> > > > > > > > >>>>>> your database to a free (as freespeech) database
> > > > > > > > >>>>>> management system.
> > > > > > > > >>>>> Could you explain a little more? What do I need to do to
> > > > > > > > >>>>> import my MSA
> > > > > > > > >>>>> files. To what free database management system do you
> > > > > > > > >>>>> refer?
> > > > > > > > >>>>>
> > > > > > > > >>>>> Thanks,
> > > > > > > > >>>>> Swarup
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
