Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • December 1, 2004 at 12:45 pm in reply to: Problem with CSV import #16604
    beaker
    Member

    Thanks for your help. I've had a play with the date_format variable as you suggested and I've managed to get it to display the way I want. I think I'm going to have to write a little conversion routine to get the date in the correct format before I import to my table though.

    Thanks once again 🙂

    November 29, 2004 at 10:35 am in reply to: Problem with CSV import #16602
    beaker
    Member

    Hi Ritesh,

    Here's the 'CREATE TABLE' statement from SQLyog:

    CREATE TABLE `clocking_data` (

    `mcid` tinyint(4) default NULL,

    `inout` tinyint(4) default NULL,

    `clockno` text,

    `time` time default NULL,

    `date` date default NULL,

    `weekday` tinyint(4) default NULL

    ) TYPE=MyISAM

    And here's some sample data from the CSV file:

    “1”,”1″,”10650″,”05:57″,”01:05:04″,”6″

    “1”,”1″,”10730″,”06:00″,”01:05:04″,”6″

    “1”,”1″,”10460″,”06:24″,”01:05:04″,”6″

    “1”,”1″,”10130″,”06:51″,”01:05:04″,”6″

    “1”,”1″,”10440″,”07:01″,”01:05:04″,”6″

    “1”,”1″,”10120″,”08:33″,”01:05:04″,”6″

    “1”,”2″,”10130″,”11:15″,”01:05:04″,”6″

    “1”,”2″,”50103″,”12:00″,”01:05:04″,”6″

    “1”,”2″,”10730″,”12:00″,”01:05:04″,”6″

    “1”,”2″,”10630″,”12:00″,”01:05:04″,”6″

    “1”,”1″,”10650″,”05:58″,”02:05:04″,”7″

    “1”,”1″,”10730″,”06:01″,”02:05:04″,”7″

    “1”,”2″,”50103″,”12:00″,”02:05:04″,”7″

    “1”,”2″,”10730″,”12:00″,”02:05:04″,”7″

    “1”,”1″,”10340″,”05:55″,”04:05:04″,”2″

    “1”,”1″,”10730″,”06:01″,”04:05:04″,”2″

    “1”,”1″,”10220″,”07:18″,”04:05:04″,”2″

    “1”,”1″,”10560″,”07:26″,”04:05:04″,”2″

    “1”,”1″,”10110″,”07:39″,”04:05:04″,”2″

    “4”,”2″,”10050″,”10:00″,”30:04:04″,”5″

    “4”,”1″,”10220″,”13:35″,”30:04:04″,”5″

    “4”,”1″,”10590″,”13:47″,”30:04:04″,”5″

    “4”,”1″,”10030″,”13:53″,”30:04:04″,”5″

    “4”,”1″,”10780″,”13:54″,”30:04:04″,”5″

    “4”,”2″,”10650″,”14:00″,”30:04:04″,”5″

    “4”,”2″,”10440″,”14:02″,”30:04:04″,”5″

    “4”,”2″,”10210″,”14:04″,”30:04:04″,”5″

    “4”,”2″,”10090″,”14:04″,”30:04:04″,”5″

    “4”,”2″,”10310″,”15:00″,”30:04:04″,”5″

    “4”,”2″,”10240″,”15:00″,”30:04:04″,”5″

    “4”,”2″,”10130″,”15:00″,”30:04:04″,”5″

    “4”,”2″,”10630″,”15:00″,”30:04:04″,”5″

    “4”,”2″,”10460″,”15:00″,”30:04:04″,”5″

    I'm new to MySQL and SQLyog so there may well be something wrong with the way I've set the table up. Apologies if it's something rudimentary 😉

    Thanks

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)