- Roundtable - muug.ca

CSV files
by John Lange 13 Jul '04

13 Jul '04

This really isn't a Unix question directly so I apologize for that. However, I have a feeling that others here might have done something like this. I have a client who would like their data converted from Access to mySQL. I'm using PHP to do the import because it plays so nice with mySQL and I'm making some changes to the data while it is being imported. So far so good, we are 90% there. The problem is, Access does not export to a valid CSV format. Specifically, if there are any text or memo fields in Access that happen to contain CR/LF Access does not strip them or escape them in any way. The results in a CSV file with end of line markers in the middle of data fields. At this point nothing I've found will import these files. Excel, OpenOffice, even Access itself all treat the CR/LF as an end of record marker even if it is enclosed in quotes. I'm not doing the data exporting from Access and I'm not that familiar with Access. Is there an option to strip CR/LF during export? Any other suggestions on how to clean this data? Thanks -- John Lange

3 3

Articles needed
by Mike Pfaiffer 12 Jul '04

12 Jul '04

Looks like we are having troubles in Japan. This means I'll be putting the magazine together for the next little while. If anybody wants to write an article or three we could certainly use the help. As I said in the meetings we can't pay for them (we don't make enough from subscriptions and sales for that). However, if we get some articles I can make a couple hand labeled copies of the CD available as door prizes in September. A fair trade? We are willing to accept articles on anything computer related as long as it will not get us in trouble and is not directly Windows related (as long as other examples are included there shouldn't be much of a problem). Source code is OK too as long as it is yours and you discuss what it does - perhaps in the context of how to write a program. I'm a bit more easy going compared to our regular editor. ;-) Anyhow... The deadline for the September issue is the 28'th of July. We were planning on eventually releasing a hardcopy issue, so we have a months lead time... In the mean time there are previews (my stuff) for the January to August issues on the Digital Civilization web site for free. I'll be putting the issues I work on up there as well. E-mail any submissions to me and we'll see what can be done from there. Later Mike P.S. Free art work is OK too as long as you did it. -- +----------------------------------------------------------------------+ | Digital Civilization magazine: http://www.digitalcivilization.ca | |Call-A.P.P.L.E. and the Digital Civilization http://www.callapple.org | | http://members.shaw.ca/pfaiffer = Mike Pfaiffer (B.A., B.Sc.) | +----------------------------------------------------------------------+ ----- BEGIN GEEK CODE BLOCK ----- Version: 3.12 GCS/G/IT/PA/SS d s+:- a? C++ UL L++ W++ N++ o+ K- w(---) O+@ M++@ V PS+ PE !PGP t+ 5+ X R tv b+ DI+++ D++ G e++* h! r-- !y-- UF++ ------ END GEEK CODE BLOCK ------

1 0

Re: [RndTbl] rm -r crippled in Red Hat 8
by gedetil＠cs.umanitoba.ca 12 Jul '04

12 Jul '04

According to millward: > In /root/.bashrc I prefixed '#' thus: > #alias rm='rm -i' > Now it's just fine. I can do rm - r > and wipe out my entire system! Which is exactly why the define the above alias for the root account. I'd strongly advise against removing or commenting out that alias, unless you're very careful in using the "rm" command, or like reinstalling your system when you do run into problems. ;) As another member pointed out, you can use the "-f" option to force the removal, which overrides the prompting that gets enabled by the "-i" option. At least this way, you'll hopefully think about it more before you use it, and might be less likely to accidentally wipe out something you didn't want to. (Of course, if you start using the "-rf" options out of habit, it kind of becomes a moot point.) By the way, this isn't something unique to Red Hat 8, nor to more recent versions. Those aliases (on "cp" and "mv" as well) have been there on previous Red Hat versions as far back as I can remember). -- Gilbert E. Detillieux E-mail: <gedetil(a)cs.umanitoba.ca> Dept. of Computer Science Web: http://www.cs.umanitoba.ca/~gedetil/ University of Manitoba Phone: (204)474-8161 Winnipeg, MB, CANADA R3T 2N2 Fax: (204)474-7609

1 0

rm -r crippled in Red Hat 8
by millward 12 Jul '04

12 Jul '04

In /root/.bashrc I prefixed '#' thus: #alias rm='rm -i' Now it's just fine. I can do rm - r and wipe out my entire system! I should have figured this out myself, but I was distracted by /etc/bashrc. It's a lot more complex then /root/.bashrc Anyway, the problem forced me to learn that Natualis can be useful. Thanks to you all for the help!

1 0

rm -r crippled in Red Hat 8
by millward 11 Jul '04

11 Jul '04

To my surprise, rm -r does not work in Red Hat 8. I tried to rub out a directory full of files and sub-directories and Red Hat asked for confirmation of deletion for each and every file! I had to hit "y" 30 times just to delete the files in one sub-directory alone. This is disgusting. How do I get rm * and rm -r to work properly in Red Hat 8 ?

3 2

Re: Roundtable digest, Vol 1 #310 - 3 msgs
by Brock Wolfe 11 Jul '04

11 Jul '04

On Sat, 10 Jul 2004 12:01:05 -0500, roundtable-request(a)muug.mb.ca wrote: >Send Roundtable mailing list submissions to > roundtable(a)muug.mb.ca > >To subscribe or unsubscribe via the World Wide Web, visit > http://www.muug.mb.ca/mailman/listinfo/roundtable >or, via email, send a message with subject or body 'help' to > roundtable-request(a)muug.mb.ca > >You can reach the person managing the list at > roundtable-admin(a)muug.mb.ca > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of Roundtable digest..." > > >Today's Topics: > > 1. Rackmount Servers (Brock Wolfe) > 2. Re: Rackmount Servers (John Schulz) > 3. Re: Rackmount Servers (Shawn Wallbridge) > =========================================== Thanks to all for the rackmount server comments. For the Chenbro rackmount servers, what motherboards were used? Brock Brock Wolfe ______________________________________ Expect problems and eat them for breakfast. -- Alfred A. Montapert (American Author) ______________________________________

2 1

Rackmount Servers
by Brock Wolfe 09 Jul '04

09 Jul '04

I am looking at overhauling my network and considering moving to rackmount systems to save some space. Applications run from router/firewall to Application and NAS servers. A quick search shows www.TigerDirect.ca carries Cybertron, Vision, Systemax brands, plus there are numerous "Linux/BSD" brands available from the US. I would like to buy in Canada, and have access to spare parts & accessories without FedEx'ng all the way from Southern California.<g> Any suggestions/experince in off-the-shelf rackmounts running "Fedora Core 2" or FreeBSD/OpenBSD? Thanks in advance for your comments/suggestions. Brock

3 2

Access Annoyances Needed for New Book (fwd)
by gedetil＠cs.umanitoba.ca 01 Jul '04

01 Jul '04

Just FYI, in case any of you are interested in contributing you favourite MS Access annoyance(s) to the book... -- Gilbert E. Detillieux E-mail: <gedetil(a)cs.umanitoba.ca> Dept. of Computer Science Web: http://www.cs.umanitoba.ca/~gedetil/ University of Manitoba Phone: (204)474-8161 Winnipeg, MB, CANADA R3T 2N2 Fax: (204)474-7609 ---------------------------------------------------------------------------- From: marsee(a)oreilly.com To: gedetil(a)muug.mb.ca Subject: Access Annoyances Needed for New Book Date: Wed, 30 Jun 2004 17:52:33 -0700 Dear User Group Leader: O'Reilly is pulling together a new book called "Microsoft Access Annoyances" and, once again, we'd like your help! As you might guess, "Access Annoyances" ponders the problems, snarls, quirks, bugs, and just dumb things about Access that drive users nuts. The annoyances will encompass a range of topics: the Access interface, entering data, queries, reporting hassles, VBA, moving data to and from Excel and SQL databases, data tables, expressions, macros, deployment, security--well, you get the idea. If any members of your group use Access--be they newbies or Access masters--and they have annoyances they'd like to see solved, have them email marsee(a)oreilly.com with "Access Annoyances" in the subject line. Just have them note what version of Access and Windows they're using. As always, thanks for sharing. We'll make sure to get copies of "Access Annoyances" sent to your group shortly after publication. --Marsee *** An example: Long Lines In Small Places THE ANNOYANCE: I'm trying to type a long expression into a tiny text box, which is about as much fun as trying to watch a movie with a couple of basketball players seated in front of you. How the heck do you keep track of what you're typing when you can only see two or three words at a time? THE FIX: One of Access' handier features is the zoom box. Hit <Shift F2>, and Access opens a big, empty text area for editing a long line of text. You can use this trick just about anywhere you see a text box: in the query design grid, in property sheets, in a table design window or datasheet. For that matter, your users can benefit from this trick, too--it works on form fields as well. Highly recommended. [TIP: You'll notice that the zoom box closes when you hit <Enter>. If for some reason, you absolutely need a line break in what you're typing, use <Ctrl-Enter> instead.] ***

1 0

Looking to purchase Cisco 2500 series Routers
by Michael J. Dikkema 27 Jun '04

27 Jun '04

Hi, All. I hope nobody minds me posting this. I'm looking to purchase some used Cisco 2500 series routers for a lab environment. I would need 16mb DRAM and 16mb Flash, and would be looking for DTE-DCE serial cables and ethernet transceivers as well. If anyone has any they're willing to part with, please send me an email off-list. Thanks.

1 0

From eWeek: Linux Enterprise Grip Tightens with EU Wins
by gedetil＠cs.umanitoba.ca 18 Jun '04

18 Jun '04

A more detailed article on EU civic governments adopting open source... http://www.eweek.com/article2/0,1759,1613842,00.asp -- Gilbert E. Detillieux E-mail: <gedetil(a)cs.umanitoba.ca> Dept. of Computer Science Web: http://www.cs.umanitoba.ca/~gedetil/ University of Manitoba Phone: (204)474-8161 Winnipeg, MB, CANADA R3T 2N2 Fax: (204)474-7609

1 0