Tanki Online

http://www.tankionline.com

Earth is not revolving around Sun

The earth doesn't revolve around the sun!

SageOne

there's a cool accounting package from Sage-One

signed up  for a 15 day trial

looks good, very user friendly, nice gui :)

 

just started using it


i sharing gdoc with screenshots (click the link below)

SageOne Screenshots

import large csv files intp mysql

you can edit the php.ini

or

i am using XAMPP 1.8.1 on Windows 7 Ultimate Edition

my xampp directory >>> D:\xampp
and database >>> sampledb

copy the data file inside D:\xampp\mysql\data\sampledb

CREATE TABLE IF NOT EXISTS `table2` (
  `FirstName` text,
  `LastName` text,
  `Company` text,
  `Address` text,
  `City` text,
  `County` text,
  `State` text,
  `ZIP` text,
  `Phone` text,
  `Fax` text,
  `Email` text,
  `Web` text
)

* this is not may not be the ideal way create table
   really wanted to create the table in with the loading of data and add the auto-incremental field

my data file is around 22MB and 349996 rows

LOAD DATA INFILE 'data.txt' INTO TABLE table2
  FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES;

weavesilk.com

my tank

Tanki Online

http://tankionline.com/battle-en26.html#

Custom Function in Excel to get the url of the cell

i am working on small excel project to get the url

i copy the links from the webpage straight into excel
well the url or hyperlink its there but the problem is...
i need to insert them into mysql database and...
there are 10,000 records.


































i am still using office 2007 don't whether the function is available in the newer versions..


so here are the steps for ppl using excel 2007..........

open a macro enabled workbook or save it later as .xlsm


Alt + F11 open the visual basic editor

insert a new module

paste the following code (highlighted in yellow)


Function GETURL(HyperlinkCell As Range)

 GETURL = HyperlinkCell.Hyperlinks(1).Address

End Function

save and close the editor

now go back to the sheet view

yii wallpaper