alum_import.php File Reference

Go to the source code of this file.

Functions
	handle_pear_error (&$error_obj)
Variables
	$b_dryRun = true
	$s_dsnImport = 'mysql://username:password@localhost/studentinfo'
	$s_importTable = 'importstudents'
	$s_dsnFF = 'mysql://username:password@localhost/fastframe_alumni'
	$s_alumTable = 'alumni_alums'
	$s_profileTable = 'profile'
	$o_dataImport = & DB::connect($s_dsnImport)
	$o_dataFF = & DB::connect($s_dsnFF)
print Importing alums	n
	$s_query
	$o_result = $o_dataImport->query($s_query)
	$s_insertCount = 0
	$s_updateCount = 0
	$a_row ['email'] = empty($a_row['email2']) ? $a_row['email'] : $a_row['email2']
	$s_total = $s_updateCount + $s_insertCount
print Import Done	Inserted

---

Function Documentation

handle_pear_error (  &$  error_obj  )

Definition at line 45 of file alum_import.php.

---

Variable Documentation

$a_row['email'] = empty($a_row['email2']) ? $a_row['email'] : $a_row['email2']

Definition at line 66 of file alum_import.php. Referenced by FF_Model_Log::getLoanLog(), and FF_DataAccess_Ticket_mysql::getNavigationIds().

$b_dryRun = true

Goes through a table of alumni data and imports them into the alum and profile tables if they aren't yet there. Note that you'll probably need to adjust the query that gets the data in order to work with your data. Author: Jason Rust <jrust@codejanitor.com> Definition at line 15 of file alum_import.php.

$o_dataFF = & DB::connect($s_dsnFF)

Definition at line 40 of file alum_import.php.

$o_dataImport = & DB::connect($s_dsnImport)

Definition at line 39 of file alum_import.php.

$o_result = $o_dataImport->query($s_query)

Definition at line 59 of file alum_import.php. Referenced by FF_SystemTest::_checkDBConnectivity(), FF_DataAccess_TicketComment_mysql::add(), FF_DataAccess_Ticket_mysql::add(), FF_DataAccess_Status_mysql::add(), FF_DataAccess_Resolution_mysql::add(), FF_DataAccess_Reddot_mysql::add(), FF_DataAccess_Profile_pgsql::add(), FF_DataAccess_Priority_mysql::add(), FF_DataAccess_Portal_mysql::add(), FF_DataAccess_Permissions_pgsql::add(), FF_DataAccess_Permissions_mysql::add(), FF_DataAccess_OverrideCode_mysql::add(), FF_DataAccess_Log_mysql::add(), FF_DataAccess_Location_mysql::add(), FF_DataAccess_Loan_mysql::add(), FF_DataAccess_Item_mysql::add(), FF_DataAccess_Inventory_mysql::add(), FF_DataAccess_Group_mysql::add(), FF_DataAccess_Demo_mysql::add(), FF_DataAccess::add(), FF_DataAccess_Category_mysql::add(), FF_DataAccess_Borrower_mysql::add(), FF_DataAccess_Advisor_mysql::add(), FF_Model_Demo::addDemoForBorrowers(), FF_DataAccess_Demo_mysql::addDemoToBorrower(), FF_Model_ProfileManager::addMinimalProfile(), FF_DataAccess_Loan_mysql::addNewItems(), FF_Auth::authenticate(), FF_Model_Assignment::batchEdit(), FF_DataAccess_Reddot_mysql::cancel(), FF_Model_Ticket::changeHandler(), FF_Model_Ticket::changePoints(), FF_Model_Ticket::email(), FF_Model_Rule::execute(), FF_Rule_email::execute(), FF_Rule_changepoints::execute(), FF_Rule_changelocation::execute(), FF_Rule_changehandler::execute(), FF_Rule_changecategory::execute(), FF_Model_Rule::executeAll(), FF_DataAccess_PhoneList_ldap::getDataByPrimaryKey(), FF_Model_Catalog::getDataToExport(), FF_Model_Borrower::getDataToExport(), FF_DataAccess_PhoneList_ldap::getListData(), FF_Model_Loan::getOpenLoansForBorrower(), FF_Auth::logout(), FF_DataAccess_Profile_mysql::makeActive(), FF_DataAccess_Catalog_mysql::markAsDownloaded(), FF_DataAccess_Catalog_mysql::markAsExported(), FF_DataAccess_Inventory_mysql::process(), FF_Action_Delete_TicketWatchlist::remove(), FF_DataAccess_TicketWatchlist_mysql::remove(), FF_Action_Delete_TicketComment::remove(), FF_DataAccess_TicketComment_mysql::remove(), FF_Action_Delete_TicketAttachment::remove(), FF_DataAccess_Rule_mysql::remove(), FF_DataAccess_Profile_mysql::remove(), FF_DataAccess_PhoneList_ldap::remove(), FF_DataAccess_Permissions_pgsql::remove(), FF_DataAccess_Permissions_mysql::remove(), FF_DataAccess_OverrideCode_mysql::remove(), FF_DataAccess_MaydayProfile_mysql::remove(), FF_DataAccess_Loan_mysql::remove(), FF_DataAccess_Item_mysql::remove(), FF_Model_Group::remove(), FF_DataAccess_Group_mysql::remove(), FF_DataAccess::remove(), FF_DataAccess_CustomField_mysql::remove(), FF_DataAccess_Category_mysql::remove(), FF_DataAccess_Catalog_mysql::remove(), FF_DataAccess_Borrower_mysql::remove(), FF_Action_BatchDelete_Assignment::remove(), FF_Model_Assignment::remove(), FF_DataAccess_Advisor_mysql::remove(), FF_Model_Demo::removeDemoFromBorrower(), FF_DataAccess_Demo_mysql::removeDemoFromBorrower(), FF_Model_Borrower::removeDemos(), FF_DataAccess_Transaction_mysql::removeItemInTransaction(), FF_Model_Loan::removeItems(), FF_Model_Group::removeItems(), FF_Model_Demo::removeItems(), FF_DataAccess_Rule_mysql::removeRulesForItem(), FF_Output_Page::renderCSS(), FF_Action_Form_Login::renderLoginStatus(), FF_Action_TicketSummary::renderSummaryTable(), FF_Action_LoanSummary::renderSummaryTable(), FF_Action_LoanReturnSummary::renderSummaryTable(), FF_DataAccess_Transaction_mysql::returnItemsInTransaction(), FF_Action_TicketDescriptionEdit::run(), FF_Action_TicketCommentEdit::run(), FF_Action_Display_News::run(), FF_Action_Logout::run(), FF_Action_LoginSubmit::run(), FF_Action_Form_Loan::run(), FF_Action_Delete_Loan::run(), FF_Action_LoanAddItem::run(), FF_Action_List_Item::run(), FF_Action_InventoryProcessSubmit::run(), FF_Action_FormSubmit::run(), FF_Action_FormSubmit_Profile::run(), FF_Action_Export_Catalog::run(), FF_Action_Delete_DemoFromBorrower::run(), FF_Action_Delete::run(), FF_Action_Delete_Catalog::run(), FF_Action_Download_Borrowers::run(), FF_Action_Display_Links::run(), FF_Action_FormSubmit_Ticket::save(), FF_Action_FormSubmit_Rule::save(), FF_Action_FormSubmit_Reddot::save(), FF_Model_Profile::save(), FF_Model_Loan::save(), FF_Action_FormSubmit_Item::save(), FF_Model_Item::save(), FF_Action_FormSubmit_Group::save(), FF_Model_Group::save(), FF_Action_FormSubmit_ForgotPass::save(), FF_FileCache::save(), FF_Model_Demo::save(), FF_Model_Comment::save(), FF_Action_FormSubmit_Category::save(), FF_Model_Category::save(), FF_Action_FormSubmit_BorrowerLookup::save(), FF_Action_FormSubmit_Borrower::save(), FF_Model_Borrower::save(), FF_Model_Permissions::saveObjectPerms(), FF_FileCache::saveUploadedFile(), FF_Model_Loan::setupStoreVars(), FF_DataAccess_TicketComment_mysql::update(), FF_DataAccess_Ticket_mysql::update(), FF_DataAccess_Status_mysql::update(), FF_DataAccess_Resolution_mysql::update(), FF_DataAccess_Reddot_mysql::update(), FF_DataAccess_Profile_pgsql::update(), FF_DataAccess_Priority_mysql::update(), FF_DataAccess_PhoneList_ldap::update(), FF_DataAccess_Permissions_pgsql::update(), FF_DataAccess_Permissions_mysql::update(), FF_DataAccess_OverrideCode_mysql::update(), FF_DataAccess_Location_mysql::update(), FF_DataAccess_Loan_mysql::update(), FF_DataAccess_Item_mysql::update(), FF_DataAccess_Group_mysql::update(), FF_DataAccess_Demo_mysql::update(), FF_DataAccess::update(), FF_DataAccess_Category_mysql::update(), FF_DataAccess_Borrower_mysql::update(), FF_DataAccess_Advisor_mysql::update(), FF_DataAccess_Item_mysql::updateAttributes(), FF_DataAccess_Borrower_mysql::updateAttributes(), FF_DataAccess_Assignment_mysql::updateCourseCodes(), FF_DataAccess_Transaction_mysql::updateItemReturnDates(), FF_DataAccess_Rule_mysql::updateRulesForItem(), FF_DataAccess_Assignment_mysql::updateSession(), FF_DataAccess_Profile_pgsql::updateSingleElement(), FF_DataAccess_Profile_mysql::updateSingleElement(), FF_DataAccess_Item_mysql::updateStatusOfItems(), FF_DataAccess_Assignment_mysql::updateTimes(), FF_DataAccess_Permissions_pgsql::updateUserGroups(), FF_DataAccess_Permissions_mysql::updateUserGroups(), FF_Action_FormSubmit_Rule::validateInput(), FF_Action_FormSubmit_Profile::validateInput(), and FF_Action_FormSubmit_BorrowerLookup::validateInput().

$s_alumTable = 'alumni_alums'

Definition at line 27 of file alum_import.php.

$s_dsnFF = 'mysql://username:password@localhost/fastframe_alumni'

Definition at line 24 of file alum_import.php.

$s_dsnImport = 'mysql://username:password@localhost/studentinfo'

Definition at line 18 of file alum_import.php.

$s_importTable = 'importstudents'

Definition at line 21 of file alum_import.php.

$s_insertCount = 0

Definition at line 60 of file alum_import.php.

$s_profileTable = 'profile'

Definition at line 30 of file alum_import.php. Referenced by FF_DataAccess_Ticket_mysql::_getSelectQuery(), FF_DataAccess_Advisor_mysql::getDataByPrimaryKey(), FF_DataAccess_Alumni_mysql::getListData(), FF_DataAccess_Advisor_mysql::getListData(), FF_DataAccess_Ticket_mysql::getNavigationIds(), FF_DataAccess_Catalog_mysql::getStats(), FF_DataAccess_Ticket_mysql::getSummaryData(), FF_DataAccess_Ticket_mysql::getTicketsMatchingFilter(), FF_DataAccess_Permissions_mysql::getUsersForObject(), FF_DataAccess_Permissions_pgsql::getUsersInGroup(), FF_DataAccess_TicketWatchlist_mysql::getWatchlistByTicketId(), and FF_DataAccess_TicketWatchlist_mysql::getWatchlistEmailsByTicketId().

$s_query

Initial value: sprintf('SELECT * FROM %s WHERE status = %s OR (status = %s AND (TO_DAYS(grad_date) - TO_DAYS(start_date)) > 365)', $s_importTable, $o_dataImport->quote('GRAD'), $o_dataImport->quote('INC')) Definition at line 55 of file alum_import.php. Referenced by FF_DataAccess_Permissions_pgsql::_addPermissionData(), FF_DataAccess_Transaction_mysql::_matchItemsToTransaction(), FF_DataAccess_Profile_pgsql::add(), FF_DataAccess_Permissions_pgsql::add(), FF_DataAccess_Group_mysql::addNewItems(), FF_DataAccess_Demo_mysql::addNewItems(), FF_AuthSource_sql::authenticate(), FF_DataAccess_Profile_pgsql::authenticate(), FF_DataAccess_Profile_mysql::authenticate(), convert_enums(), FF_DataAccess_Permissions_mysql::doesObjectHaveOwnerType(), FF_Rule_changepoints::execute(), FF_Rule_changelocation::execute(), FF_Rule_changehandler::execute(), FF_Rule_changecategory::execute(), FF_DataAccess_Transaction_mysql::filterOutReturnedItems(), FF_DataAccess_Permissions_pgsql::getAllGroups(), FF_DataAccess_Permissions_mysql::getAllGroups(), FF_DataAccess_Profile_pgsql::getAllProfiles(), FF_DataAccess_Profile_mysql::getAllProfiles(), FF_DataAccess_Rule_mysql::getAllRules(), FF_DataAccess_Reddot_mysql::getBlockingReddotCountForBorrower(), FF_DataAccess_PortalBlock_mysql::getBlockOptions(), FF_DataAccess_Borrower_mysql::getBorrowerIdByBarcode(), FF_DataAccess_Transaction_mysql::getBorrowersFromReturnItems(), FF_DataAccess_CustomField_mysql::getCategoriesWithField(), FF_DataAccess_Category_mysql::getCategoryName(), FF_DataAccess_Category_mysql::getCategoryOptions(), FF_DataAccess_Assignment_mysql::getClassOptions(), FF_DataAccess_Priority_mysql::getClosestPriority(), FF_DataAccess_Comment_mysql::getCommentCount(), FF_DataAccess_TicketComment_mysql::getCommentsByTicketId(), FF_DataAccess_Comment_mysql::getCommentsByTransactionId(), FF_DataAccess_Ticket_mysql::getDataByPrimaryKey(), FF_DataAccess_Permissions_pgsql::getDataByPrimaryKey(), FF_DataAccess_Permissions_mysql::getDataByPrimaryKey(), FF_DataAccess_Loan_mysql::getDataByPrimaryKey(), FF_DataAccess_Item_mysql::getDataByPrimaryKey(), FF_DataAccess::getDataByPrimaryKey(), FF_DataAccess_Borrower_mysql::getDataByPrimaryKey(), FF_DataAccess_Advisor_mysql::getDataByPrimaryKey(), FF_DataAccess_Catalog_mysql::getDataToExport(), FF_DataAccess_Borrower_mysql::getDataToExport(), FF_DataAccess_Status_mysql::getDefaultValue(), FF_DataAccess_Resolution_mysql::getDefaultValue(), FF_DataAccess_Priority_mysql::getDefaultValue(), FF_DataAccess_Location_mysql::getDefaultValue(), FF_DataAccess_Category_mysql::getDefaultValue(), FF_DataAccess_Demo_mysql::getDemoItems(), FF_DataAccess_Demo_mysql::getDemosByBorrowerId(), FF_DataAccess_Assignment_mysql::getDescriptionsById(), FF_DataAccess_Profile_mysql::getEmailById(), FF_DataAccess_Profile_mysql::getEmailByUsername(), FF_DataAccess::getFieldByPrimaryKey(), FF_DataAccess_CustomField_mysql::getFieldsByCategory(), FF_DataAccess_Filter_mysql::getFilterOptions(), FF_DataAccess_Spotlight_mysql::getFrontpageId(), FF_DataAccess_Profile_pgsql::getFullNameById(), FF_DataAccess_Profile_mysql::getFullNameById(), FF_DataAccess_Profile_pgsql::getFullNameByUsername(), FF_DataAccess_Profile_mysql::getFullNameByUsername(), FF_DataAccess_Group_mysql::getGroupItems(), FF_DataAccess_Group_mysql::getGroupsForItems(), FF_DataAccess_TicketHistory_mysql::getHistoryForTicket(), FF_DataAccess_Borrower_mysql::getIdByProfileId(), FF_DataAccess_Profile_pgsql::getIdByUserName(), FF_DataAccess_Profile_mysql::getIdByUserName(), FF_DataAccess_Profile_mysql::getIdsByEmail(), FF_DataAccess_Category_mysql::getImmediateParentId(), FF_DataAccess_Status_mysql::getInProgressStatus(), FF_DataAccess_Rule_mysql::getItemCountForBorrower(), FF_DataAccess_Item_mysql::getItemIdByBarcode(), FF_DataAccess_Transaction_mysql::getItemIdsByTransactionId(), FF_DataAccess_Transaction_mysql::getItems(), FF_DataAccess_Transaction_mysql::getItemsByTransactionId(), FF_DataAccess_Rule_mysql::getItemsForRule(), FF_DataAccess_Statistics_mysql::getItemTotalsByStatus(), FF_DataAccess_Advisor_mysql::getKeywords(), FF_DataAccess_Profile_mysql::getLastLoginById(), FF_DataAccess_Ticket_mysql::getListData(), FF_DataAccess_Rule_mysql::getListData(), FF_DataAccess_Reddot_mysql::getListData(), FF_DataAccess_Profile_pgsql::getListData(), FF_DataAccess_Profile_mysql::getListData(), FF_DataAccess_PhoneList_mysql::getListData(), FF_DataAccess_Log_mysql::getListData(), FF_DataAccess_Loan_mysql::getListData(), FF_DataAccess_Item_mysql::getListData(), FF_DataAccess_Inventory_mysql::getListData(), FF_DataAccess_Demo_mysql::getListData(), FF_DataAccess::getListData(), FF_DataAccess_Alumni_mysql::getListData(), FF_DataAccess_Advisor_mysql::getListData(), FF_DataAccess_Log_mysql::getLoanLog(), FF_DataAccess_Location_mysql::getLocationName(), FF_DataAccess_PhoneList_mysql::getLocationOptions(), FF_DataAccess_Location_mysql::getLocationOptions(), FF_DataAccess_Demo_mysql::getMissingDemos(), FF_DataAccess_Transaction_mysql::getMostRecentBorrower(), FF_DataAccess_Ticket_mysql::getNavigationIds(), FF_DataAccess_Priority_mysql::getNextPriority(), FF_DataAccess_Category_mysql::getNodeName(), FF_DataAccess_Loan_mysql::getNumOpen(), FF_DataAccess_Permissions_pgsql::getObjectPerms(), FF_DataAccess_Permissions_mysql::getObjectsForUser(), FF_DataAccess_Permissions_mysql::getObjectUserIds(), FF_DataAccess_Portal_mysql::getPageSettings(), FF_DataAccess_Profile_pgsql::getPasswordById(), FF_DataAccess_Profile_mysql::getPasswordById(), FF_DataAccess_Permissions_pgsql::getPermCount(), FF_DataAccess_Permissions_mysql::getPermCount(), FF_DataAccess_Priority_mysql::getPriorityAlerts(), FF_DataAccess_Priority_mysql::getPriorityOptions(), FF_DataAccess_Reddot_mysql::getProblemReddotCountForBorrower(), FF_DataAccess_Reddot_mysql::getProblemReddotsForBorrower(), FF_DataAccess_Reddot_mysql::getReddotCountForBorrower(), FF_DataAccess_Group_mysql::getRelatedGroups(), FF_DataAccess_Resolution_mysql::getResolutionOptions(), FF_DataAccess_Resolution_mysql::getResolutionResponses(), FF_DataAccess_Status_mysql::getResolutionStatus(), FF_DataAccess_Transaction_mysql::getReturnItemsForBorrower(), FF_DataAccess_Category_mysql::getRootId(), FF_DataAccess_Rule_mysql::getRuleOptions(), FF_DataAccess_Rule_mysql::getRulesForItem(), FF_DataAccess_Assignment_mysql::getSessionOptions(), FF_DataAccess_Catalog_mysql::getStats(), FF_DataAccess_Status_mysql::getStatusColor(), FF_DataAccess_Status_mysql::getStatusColors(), FF_DataAccess_Status_mysql::getStatusName(), FF_DataAccess_Status_mysql::getStatusOptions(), FF_DataAccess_Ticket_mysql::getSummaryData(), FF_DataAccess_Loan_mysql::getSummaryData(), FF_DataAccess_Ticket_mysql::getTicketsMatchingFilter(), FF_DataAccess_Statistics_mysql::getTopGroups(), FF_DataAccess_Statistics_mysql::getTopItems(), FF_DataAccess_Statistics_mysql::getTopUsers(), FF_DataAccess_Statistics_mysql::getTotalGroups(), FF_DataAccess_Statistics_mysql::getTotalItems(), FF_DataAccess_Statistics_mysql::getTotalTransactions(), FF_DataAccess_Statistics_mysql::getTotalTransactionsByType(), FF_DataAccess_Permissions_pgsql::getUserGroups(), FF_DataAccess_Permissions_mysql::getUserGroups(), FF_DataAccess_Profile_pgsql::getUsernameById(), FF_DataAccess_Profile_mysql::getUsernameById(), FF_DataAccess_Permissions_mysql::getUsersForObject(), FF_DataAccess_Permissions_pgsql::getUsersInGroup(), FF_DataAccess_TicketWatchlist_mysql::getWatchlistByTicketId(), FF_DataAccess_TicketWatchlist_mysql::getWatchlistEmailsByTicketId(), FF_DataAccess_Permissions_mysql::hasObjectPerm(), import_demo_items(), import_group_items(), FF_DataAccess_Massmail_mysql::incrementSentCount(), FF_DataAccess_OverrideCode_mysql::isCodeValid(), FF_DataAccess::isDataUnique(), FF_DataAccess_Category_mysql::isTargetIdValid(), FF_DataAccess_Inventory_mysql::process(), FF_DataAccess_TicketComment_mysql::remove(), FF_DataAccess_Rule_mysql::remove(), FF_DataAccess_Permissions_pgsql::remove(), FF_DataAccess_Advisor_mysql::remove(), FF_DataAccess_Permissions_pgsql::removeObjectPerms(), FF_DataAccess_Permissions_pgsql::removeUserGroups(), FF_DataAccess_Transaction_mysql::returnItemsInTransaction(), FF_DataAccess_Permissions_pgsql::saveObjectPerm(), FF_DataAccess_Profile_pgsql::update(), FF_DataAccess_Permissions_pgsql::update(), FF_DataAccess_Loan_mysql::update(), FF_DataAccess_Assignment_mysql::updateCourseCodes(), FF_DataAccess_Advisor_mysql::updateKeywords(), FF_DataAccess_Group_mysql::updateRelationships(), FF_DataAccess_Assignment_mysql::updateSession(), FF_DataAccess_Profile_pgsql::updateSingleElement(), FF_DataAccess_Assignment_mysql::updateTimes(), FF_DataAccess_Permissions_pgsql::updateUserGroups(), and FF_DataAccess_OverrideCode_mysql::useCode().

$s_total = $s_updateCount + $s_insertCount

Definition at line 147 of file alum_import.php. Referenced by FF_Action_Display_Statistics::getGroupAndItemStats(), FF_Action_Display_Statistics::getLoanAndReservationStats(), and FF_Action_TicketSummary::renderSummaryTable().

$s_updateCount = 0

Definition at line 61 of file alum_import.php.

print Import Done Inserted

Definition at line 148 of file alum_import.php.

print Importing Loans n

Definition at line 53 of file alum_import.php. Referenced by FF_ErrorHandler::_makeStringJSSafe(), FF_Action_Form_Ticket::_renderPriorityJS(), _timestampToDateSelect(), FF_DataAccess_Ticket_mysql::buildFilter(), FF_Model_Loan::formatTimestamp(), FF_Model_Profile::getFormattedLastLogin(), and FF_Model_Massmail::sendEmails().

---