Insert in a DB

[pacome]

I've got a table in a word doc with some country and city codes... is there any way of inserting them all into a mysql db without going one by one?

 

thanks!

[pacome]

no way???

[Balmung-San]

Just because somebody doesn't answer you in an hour doesn't mean they don't know. You have to give people some time.

 

Anyway, I believe it would be possible with COM, however that requires your web server to be Windows, and then you have to learn proper COM usage, which is a whole other can of worms.

 

All in all, I don't think it'd be worth the time to write a page to do it.

 

Anybody else know if it's possible without COM?

[pacome]

Sorry I guess sitting here in my PC made me loose my sense of time..

 

thanks for your help!

[chronister]

You might try saving into a csv file and importing from that. I did this kind of thing for an address book I made for my wife. I exported the windows address book into a csv file and then have a script to grab the csv and import it properly.

 

This will take a csv file with the first row being the column names, and puts it into an associative array. You will have to modify it to your needs as it simply prints out the array in the end, but its a pretty neat script.

 

<?php
$file=your_csv_file_here;
//Move through a CSV file, and output an associative array for each line
ini_set("auto_detect_line_endings", 1);
$current_row = 1;
$handle = fopen("$file", "r");
while ( ($data = fgetcsv($handle, 10000, ",") ) !== FALSE )
{
   $number_of_fields = count($data);
   if ($current_row == 1)
   {
   //Header line
       for ($c=0; $c < $number_of_fields; $c++)
       {
           $header_array[$c] = $data[$c];
       }
   }
   else
   {
   //Data line
       for ($c=0; $c < $number_of_fields; $c++)
       {
           $data_array[$header_array[$c]] = $data[$c];
       }
        print_r($data_array);

   }
   $current_row++;
}
fclose($handle);
};
?>

 

I did not write this, I found it in the php manual under the comments in the fgetcsv function(I think). Thanks to the person who wrote this though.

[pacome]

thanks to him/her and to you for passing it to me!!!

[richardw]

Hopefully the post by chronister will work for you.

 

If not I have had good luck extracting data from Word if it's in a column by using this command to exctract the column from word: Place the cursor in the upper left of the first column and then press the Shift and Alt keys together and drag to highlight your column. Cut and paste into notepad and insert the textfile into the respective field... repeat the process a few times.

 

Another tip for data if it is in a table is to cut and paste the table into notepad, all formatting will be lost and the data should be intact. You might have to use a search & replace function to place delimiters between fields.

 

best 

[pacome]

wow! I ' ll try this too!

thanks!