yml file, 78, 93, 201, 217, 223,
230, 245, 273
config/environment.rb file, 206
config/routes.rb file, 100, 201
connect method, 71
Content-Type header, 179
content-type header, 280
controllers, cost-per-sale reporting, 192??“198
correlated subquery, 150
cost field, 280
cost-per-sale reporting
controllers, 193??“198
database, 201??“202
layout, 198??“200
log analyzer, 203??“212
models, 203
parser libraries, 201
routing files, 201
schema, 201??“202
views, 198??“200
count aggregate function, 44
count fields, 232
COUNT function, 20, 25
count method, 60
count variable, 207, 259
count_by_sql method, 144
:counter_cache=>true option, 165
cpc field, 279
nINDEX 286
create method, 63
create_table statement, 90
CRM systems, SugarCRM. See customer
relationship management systems,
SugarCRM
CSS (Cascading Style Sheets), 33
CSV (comma-separated values) data,
converting, 138??“144
current_row method, 58
elements, 125, 126
Customer model, 11
customer relationship management (CRM)
systems, SugarCRM
installing, 155??“156
overview, 155
sales force reporting with, 156??“169
D
data
analyzing, PayPal accounts, 144??“153
analyzing, with grouping and aggregation,
22??“31
calculating drink/win distribution, 26??“31
calculating salary distribution, 25??“26
overview, 22??“24
exporting to spreadsheets, 52??“60
creating spreadsheet report, 53??“60
generating Excel spreadsheet, 52??“53
gathering from PayPal, 133??“136
report, writing small servers to get, 171??“172
XML, importing into Microsoft Access,
251??“260
data center (DC) component, 37
data directory, 246
data method, 37, 45
data_format format, 57
DatabaseFeedCache class, 225
databases, 3??“17
Active Record, 5??“17
calculating player salaries, 6??“11
calculating player wins, 11??“17
overview, 5??“6
choosing, 3??“4
cost-per-sale reporting, 201??“202
overview, 3
Date class, 151
DATE_ADD function, 82
db directory, 246
db/data/training_class_data.
Pages:
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406