You are here: Re: Importing csv file into mysql « All PHP « IT news, forums, messages
Re: Importing csv file into mysql

Posted by Steve on 03/03/07 17:49

"kenoli" <kenoli.p@gmail.com> wrote in message
news:1172941734.509915.110720@z35g2000cwz.googlegroups.com...
| On Mar 2, 6:08 am, "Steve" <no....@example.com> wrote:
|
| > you do realize this is a shitty format for csv...right?
|
| I at least suspected as much. This format is what Excel puts out and
| I have been trying to understand regular expressions well enought to
| correct it in text wrangler. As you can tell, I am learning this as I
| go along. I can see that the two scripts above also change the format
| though I wasn't able to exactly figure out how the syntax works. I
| did try.

look, you can save excel data in a number of formats...why not try xml?


| > christ kenoli, you have two examples of how to do this. the least you
could
| > do is try to output some debugging info in the code.
|
| I wasn't aware of the debugging output I could request and will put
| some time into figuring out how to do this. The earlier suggestions
| on this are helpful.

'request'?!!! it consists of:

foreach (rowsOfData as id => row)
{
if (some condition is fubar)
{
print out the offending row number (id)
then crack open your file and go to that line
and look for something amis
}
}

debugging and testing is up to no one but you.


| > my recommendation: don't quit your day job.
|
| Don't worry, I barely have a day job to quit. I am doing this for
| some community projects I am involved in. A friend and I are involved
| in a project to help communities develop a vision for themselves and
| then put together the resources to make it happen.

so you've dropped the realestate application you've been working on for the
past year or so?

| We work hand to
| mouth and one of the reasons I am doing this is that we can't afford
| to hire anyone else to do it.

but a business plan together and get a financier. almost any non-profit
starts this way. there are plenty of philanthropic people around...the rest
whom give money do it for the tax breaks or good pr.

besides, you treat this ng like we *are* your hired help. do you not have
enough money to buy a beginners book on php? i do get rude with you from
time to time, but i'm being sincere here. if you were to express in english
what you wanted out of a function or other code, you could more easily look
for functions in the manual or book that would accomplish your goals.

if you just keep mindlessly asking us 'how can i do this?', you will learn
nothing and we can be assured in answering you that we'll hear from you
again in a day or two asking how to do your next set of functions...that's
why i think you consider us to be your UN-paid 'hired' help.

i just get sick of seeing others that don't know better, anwering your posts
thinking they are helping you out...when it is really they who need help
from being taken advantage of.

| There is no question I an a novice. I
| never expect to be a professional, though I would love to learn enough
| to make it all go more easily and quickly.

there is nothing quick nor easy about learning something - with few
exceptions. an exception would be a savaunt or person who has a natural
knack. since you are neither of these regarding php, you have stated a
contradiction...you can EITHER want to LEARN...OR you want something QUICK
and EZ.

from what i've seen over the course of the past year or so, is that you have
NO interest in the former - unless it is a fortunate side-effect - and are
solely focused on the latter.

| The assistance that people on this list have given is hugely valuable
| and appreciated.

i'm sure it has been and is appreciated. you forgot to mention, FREE.

| I'm sorry if my own ignorance makes my questions
| incomplete or foollish.

it's not alway HOW you're asking what you need. it's more that you ARE
asking without you having done ANY work to supply your own answer...such as
RTFM or looking up examples on the net.

| I think I'm getting better.

uhhhmmmm...no, you're not. you are modus-apparandi; business as usual.

| At any rate, my
| code needs less and less debugging.

the quality of those who supply it to you must have improved.

| It is an achievement for me when
| I can type out a dozen lines of code and they actually work the first
| time!

i imagine a great deal of truth lies in that statement...as you rarely ever
originate one line, much less a dozen.

| I ended up taking the novice's way out here and downloaded a
| demonstration copy of Navicat. It made importing the records very
| easy.

good for you. so does that mean you're going to take the professional
approach to programming and start writing your own code, reading the manual,
and looking at examples from the web or a book? anything less, and you
should change 'i ended up taking ...' with 'i'm still taking the novice way
out ...' and just finish the sentence with 'and posted yet another
help-write-my-code'. hell, we all know your game enough. why not just
title/subject your posts with 'IT'S ME AGAIN'...that way i don't have to
check for 'kenoli' as the op before deciding to help or not.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация