importing data through csv file

qadeer_ahmad

friends i have csv file like this fromat

"1000",9/10/99,"J 2400",8.10,8.10,16.20,,,,,,5/26/0,07:05:56 AM,"B","J 2400"
"1000",9/11/99,"A 0085",2.60,2.60,14.40,,,,,,5/26/0,07:05:56 AM,"B","A 0086"
"1000",9/11/99,"J 2400",8.10,8.10,16.20,,,,,,5/26/0,07:05:56 AM,"B","J 2400"

i want to import data in mysql but when i try to import data in database revelent table it work but fill all fields with null values i am trying through sqlyog also same as when i working in net. Note this csv file make from SQL sever. Please give me solution for this.

qadeer_ahmad

still waiting

alvinkoh

Originally posted by qadeer_ahmad
still waiting

Hi qadeer,

Can you paste your mysql INSERT/UPDATE statement here?

Also, it may help if you paste your table structure here as well.

Regards.

Dragnovich

You are getting NULL values when importing your CSV data, because the CSV file looks like:

Field 1,,,,Field 4,Field 5

When the MySQL imports your file and he finds a ,, it is A NULL value so it display NULL. it's simple!

When you created your table you use something like this for the fields:

userIDNum int(7) NOT NULL,

Simply regenerate the table with this:

userIDNum int(7) NOT NULL default '0',

or run the query:
ALTER TABLE table CHANGE userIDNUM userIDNUM INT( 7 ) DEFAULT '0' NOT NULL;

And that's all 😃

qadeer_ahmad

Field Type Null Key Default Extra

customer varchar(6) YES (NULL)

pdate date YES (NULL)

item varchar(6) YES (NULL)

orig float YES (NULL)

revised float YES (NULL)

cost float YES (NULL)

price float YES (NULL)

projected float YES (NULL)

projectedprice float YES (NULL)

budgetprojected float YES (NULL)

flag char(1) YES (NULL)

udate date YES (NULL)

utime time YES (NULL)

usource char(1) YES (NULL)

postitem varchar(6) YES (NULL)

ur right dear all fields are NULL but in my CSV files thier is some date in some fields i say i get result as all fields are NULL

Thanks for guiding. but problem is still remain and also i do not want to change the table structure..

Weedpacket

How about if we saw some code? Maybe that would help us.

Dragnovich

MMmm then the problem is in the IMPORT process, what's the query you are using. Or the PHP routine that imports that data.

qadeer_ahmad

i am not using any script just importing from SQLYog but if u can guid to making script for this i am thankful to u .
Please Please guid me