vicidial.org

Does any one know how to convert a comma delimited or pipe delimited to a tab delimited file on console?

I was trying to upload like 250k leads at 1 time as open office sucks when dealing with more than 65k rows.

Code: Select all

tr ',' '\t' < in.txt > out.txt

or

Code: Select all

sed 's/,/\t/g' in.txt > out.txt

In Windows I use Notepad++, or CSVEd for smaller files, or CygWin tools for large files.

ok thanks.

I just wasted 2 hours uploading 250k leads on 1 file using the web loader

You must be brave

I won't take the risk to upload more than 100k leads at once using the web list loader.

there's always the first time on everything

although I didint get to upload all the 250k leads as It only uploaded 223k leads but it was fun.

223k must be a good result

I wonder- is there anyone uploaded more through the web loader? If yes- what were php.ini settings?