One last thing, in the email be sure to tell me which table it is you need to export - in case there is more then one - remember queries will look like tables to me here when I open it with Base.
On 9/27/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > On Thu, 2007-09-27 at 13:40 -0400, Andrew Jensen wrote: > > Ah, if you haven't needed IM up till now - maybe no reason to make you > > get it now..Let's try to finish this here and now. If you have the > > time, I have the time then. > > > > You have exported your table from MS Access as a TEXT file, with > > default settings. > > > > You switch to Linux and tried to create a Base TEXT data source to > > read that and all of the fields come in as one long concated string in > > the new table - single field in other words. > > > > BUT didn't you say you wanted to edit that data once it was in > > Base..that is correct isn't it? > > > > So, the simple text data source is not going to work. You really do > > want to import the data to Base, or link it in as a TEXT table. > > > > Did you say what the table structure was in MS Access. I don't suppose > > you know how to run have Access generate a data dictionary file by any > > chance. It' in there but I don't recall how either. If we had that I'd > > just give you back the statement to create the TEXT table link. > > > > Ha - got it. Go back in windows. Make a Copy of that MDB file and in > > the copy delete all the records from the tables, so they are blank. > > OK. Then send me a direct email at > > [EMAIL PROTECTED] and attach that emptied MDB file to the > > email. I'll give you back a very simple script that will create the > > link for you...Can you do that for me? > > Sure. Give me 5-10 minutes to get it, and I will e-mail it to you at the > above address. > > Thanks so much, > Swarup > > > > > On 9/27/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > > > I am sorry Drew, I do not know what "IM client" means-- which probably > > > means I do not have one. But I know people set such real-time mechanisms > > > up free all the time. If you tell me such a site to go to, I'll set one > > > up for myself now. I think Yahoo has something like that, don't they? > > > > > > Swarup > > > > > > > > > On Thu, 2007-09-27 at 13:02 -0400, Andrew Jensen wrote: > > > > ROFL... > > > > > > > > OK - tell you what. Do you have an IM client? > > > > > > > > If so, we can get on-line in about 30 minutes from now and I'll try > > > > and walk you through it..really you are just missing a couple of > > > > really simple steps. Problem is I don't have MS Access on any machines > > > > any more and I can't remember the actual layout of that file. But if > > > > we could talk in Real Time it should only take a couple of minutes. > > > > > > > > On 9/27/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > > > > > On Thu, 2007-09-27 at 12:44 -0400, Andrew Jensen wrote: > > > > > > Swarup, > > > > > > > > > > > > Sorry, you got lost in the switches there. > > > > > > > > > > > > I think I mentioned this before, but if not. > > > > > > > > > > > > http://www.oooforumorg.org > > > > > > > > > > > > Go to the Base section and post a question > > > > > > How to import CSV file to Base > > > > > > > > > > > > There are currently three individuals working that board that I > > > > > > guarantee will get you up and running. > > > > > > > > > > Alright, I'll try that. Thank you. > > > > > > > > > > When I first started my Base queries I had gone there-- but you were > > > > > the > > > > > only one who replied to me there. And you wrote that you weren't going > > > > > to be replying any more there, and I should join the [dba-users] list > > > > > and post my query there. That is why I came over to this list. > > > > > > > > > > Swarup > > > > > > > > > > > > > > > > > > > > > On 9/27/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > > > > > > > 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] > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > 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] > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
