Anybody with a php script to upload csv or excell data into mysql
Hi Anybody with the above script Regards -- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us. Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
for your csv , try a variation of http://dev.mysql.com/doc/refman/5.1/en/load-data.html On Wed, Jan 26, 2011 at 3:41 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Anybody with the above script Regards
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
I mean have a userinterface file upload and then update the specified rows to a mysql table On Wed, Jan 26, 2011 at 4:24 PM, Kiti Chigiri <kiti.chigiri@gmail.com>wrote:
for your csv , try a variation of http://dev.mysql.com/doc/refman/5.1/en/load-data.html
On Wed, Jan 26, 2011 at 3:41 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Anybody with the above script Regards
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us. Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
i can make a web-based one that will require you to run it ob your localhost but it will cost you, are you interested? On Wed, Jan 26, 2011 at 6:47 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
I mean have a userinterface file upload and then update the specified rows to a mysql table
On Wed, Jan 26, 2011 at 4:24 PM, Kiti Chigiri <kiti.chigiri@gmail.com>wrote:
for your csv , try a variation of http://dev.mysql.com/doc/refman/5.1/en/load-data.html
On Wed, Jan 26, 2011 at 3:41 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Anybody with the above script Regards
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
After you log into mysql you can use the following command *load data local infile '/path/to/csv/file.csv' into table `mytable` fields terminated by ';' lines terminated by '\n' (field1, field2, field3.....);* * * The order in which they are organized in the csv should be the same way the fields are organized in the command, also ensure the field headers are not included in the csv file. On Wed, Jan 26, 2011 at 3:41 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Anybody with the above script Regards
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
please try edwin@otbafrica.com he will help On Wed, Jan 26, 2011 at 3:41 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Anybody with the above script Regards
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
Why not just use phpmyadmin? On Wed, Jan 26, 2011 at 10:32 PM, nelson kinoti <kinotimutwiri@gmail.com>wrote:
please try edwin@otbafrica.com he will help
On Wed, Jan 26, 2011 at 3:41 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Anybody with the above script Regards
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards Brian Ngure
I need to upload bulk data and i do not think a user form will work Thanks so much for your assistance On Thu, Jan 27, 2011 at 9:41 AM, Dennis Kioko <dmbuvi@gmail.com> wrote:
http://stackoverflow.com/search?q=php+script+to+upload+csv+or+excel+data+int... _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us. Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
http://www.ustrem.org/en/articles/reading-xls-with-php-en/ <http://www.ustrem.org/en/articles/reading-xls-with-php-en/> http://sourceforge.net/projects/phpexcelreader/ <http://sourceforge.net/projects/phpexcelreader/> http://www.phpclasses.org/package/3797-PHP-Access-Excel-spreadsheets-as-data... <http://www.phpclasses.org/package/3797-PHP-Access-Excel-spreadsheets-as-databases-using-ODBC.html> http://www.phpclasses.org/package/1919-PHP-Stream-wrapper-to-read-and-write-... <http://www.phpclasses.org/package/1919-PHP-Stream-wrapper-to-read-and-write-MS-Excel-files.html>Depending on how the rows and columns are arranged in your spreadsheet: 1. Load the excel sheet in a new thread so that the request doesn't go dead 2. Use a loop to read columns and rows and based on that generate a huuuuge SQL statement 3. Run the SQL statement 4. Data's in your table On Fri, Jan 28, 2011 at 1:54 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
I need to upload bulk data and i do not think a user form will work Thanks so much for your assistance
On Thu, Jan 27, 2011 at 9:41 AM, Dennis Kioko <dmbuvi@gmail.com> wrote:
http://stackoverflow.com/search?q=php+script+to+upload+csv+or+excel+data+int... _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- K. K.
This is aphp/mysql app that does csv importation by mapping fields in the csv to those in the database, this is to mean while creating your csv file ensure the column headers are included just to ease the operation. Just edit the config file to suite your environment. On Fri, Jan 28, 2011 at 1:54 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
I need to upload bulk data and i do not think a user form will work Thanks so much for your assistance
On Thu, Jan 27, 2011 at 9:41 AM, Dennis Kioko <dmbuvi@gmail.com> wrote:
http://stackoverflow.com/search?q=php+script+to+upload+csv+or+excel+data+int... _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
Hi Omari...long time. Another quick alternative is to use Open office calc. It can connect to mysql db without need to use ODBC. Save the connection and it is very easy to paste your spread sheet into the database. I use this method all the time. Regards, John Maingi Ndung'u. On Fri, Jan 28, 2011 at 6:10 PM, Nd'wex Common <flexycat@gmail.com> wrote:
This is aphp/mysql app that does csv importation by mapping fields in the csv to those in the database, this is to mean while creating your csv file ensure the column headers are included just to ease the operation. Just edit the config file to suite your environment.
On Fri, Jan 28, 2011 at 1:54 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
I need to upload bulk data and i do not think a user form will work Thanks so much for your assistance
On Thu, Jan 27, 2011 at 9:41 AM, Dennis Kioko <dmbuvi@gmail.com> wrote:
http://stackoverflow.com/search?q=php+script+to+upload+csv+or+excel+data+int... _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards, John Maingi Ndung'u
Hi John, This I did not know. Thanks for the tip. Will investigate :) On Mon, Jan 31, 2011 at 1:54 PM, John Maingi <jmandu7@gmail.com> wrote:
Hi Omari...long time. Another quick alternative is to use Open office calc. It can connect to mysql db without need to use ODBC. Save the connection and it is very easy to paste your spread sheet into the database. I use this method all the time.
Regards, John Maingi Ndung'u.
On Fri, Jan 28, 2011 at 6:10 PM, Nd'wex Common <flexycat@gmail.com> wrote:
This is aphp/mysql app that does csv importation by mapping fields in the csv to those in the database, this is to mean while creating your csv file ensure the column headers are included just to ease the operation. Just edit the config file to suite your environment.
On Fri, Jan 28, 2011 at 1:54 PM, Calvin Omari <calvinebarongo@gmail.com>wrote:
I need to upload bulk data and i do not think a user form will work Thanks so much for your assistance
On Thu, Jan 27, 2011 at 9:41 AM, Dennis Kioko <dmbuvi@gmail.com> wrote:
http://stackoverflow.com/search?q=php+script+to+upload+csv+or+excel+data+int... _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards, John Maingi Ndung'u
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards Brian Ngure
participants (9)
-
Brian Ngure -
Calvin Omari -
Dennis Kioko -
jamo njoroge -
John Maingi -
Kago Kagichiri -
Kiti Chigiri -
Nd'wex Common -
nelson kinoti