Posted
by markdorison
on Stack Overflow
See other posts from Stack Overflow
or by markdorison
Published on 2010-03-15T01:50:31Z
Indexed on
2010/03/15
1:59 UTC
Read the original article
Hit count: 195
Is it possible for me to access a Google Docs spreadsheet (possibly as a CSV file?) and build that into a PHP array?
© Stack Overflow or respective owner
as seen on Server Fault
- Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to:
pm = ondemand
pm.max_children = 12
pm.start_servers = 2
pm.min_spare_servers = 2
pm.max_spare_servers = 10
pm.max_requests = 500
php_admin_value[memory_limit] = 128M
Problem…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
[root@ip ~]# yum install php-pear*
Reducing CentOS-5 Testing to included packages only
Finished
Setting up Install Process
Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio …
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am taking over an application server and discover that it contain the following settings:
AddType text/html php
Although it works, but my understanding is that it should set as following:
AddType application/x-httpd-php php .php
What are the key differences between the two settings?…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hello.
I have a server with VBulletin forum (working under Apache 2.2, CentOS). The default settings for it in .htaccess are as follows:
RewriteEngine on
RewriteCond %{HTTP_HOST} ^gsmforum\.ru
RewriteRule (.*) http://www.gsmforum.ru/$1 [R=301,L]
# If you are having problems or are using VirtualDocumentRoot…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I have installed memcached fine, and now I will need to install PECL extension memcache. Im running RedHat x86_64 es5. The installation gives me this:
downloading memcache-2.2.6.tgz ...
Starting to download memcache-2.2.6.tgz (35,957 bytes)
..........done: 35,957 bytes
11 source files, building
running:…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
This is from the DBD::File-documentation:
f_ext
This attribute is used for setting the file extension where (CSV) files are opened. There are several possibilities.
DBI:CSV:f_dir=data;f_ext=.csv
In this case, DBD::File will open only table.csv if both table.csv and table exist…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Here is my class,
public class FreebasePeopleResults {
public String intendedSearch;
public String weight;
public Double heightMeters;
public Integer age;
public String type;
public String parents;
public String profession;
public String alias;
public String children;
public String siblings;
public…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
What am I trying to do: export data to csv.
I have a form which allows user to select the format (from a drop down menu). So based on the selection of the format the ouput is displayed using a ajax call. Works fine for html but when I select the format as csv I don't see any pop up on the screen…
>>> More
as seen on Super User
- Search for 'Super User'
I have these 3 files
21/08/2014 07:15 PM 122 Tw2AWK.csv
21/08/2014 07:15 PM 125 Tw2Notepad.csv
21/08/2014 07:15 PM 119 Tw2REPL.csv
C:\myfilesfile Tw2AWK.csv TwREPL.csv Tw2Notepad.csv
Tw2AWK.csv; UTF-8 Unicode text, with CRLF line terminators
Tw2REPL…
>>> More
as seen on Super User
- Search for 'Super User'
My data:
It's a 71 MB file with 1.5 million rows.
It has 6 fields
All six fields combine to form a unique key - so that's what I need to sort on.
Sort statement:
sort -t ',' -k1,1 -k2,2 -k3,3 -k4,4 -k5,5 -k6,6 -o output.csv input.csv
The problem:
If I sort without keys, it takes 30 seconds…
>>> More
