Exporting Results

Permalink Browser Info Environment
I have a couple clients looking for licenses for this item but I had once question before I do so. They all would like me to setup a cron job to export records. Could you possible provide me with the query to properly do this? I see your table situation is somewhat complex.

I have a short window so need an answer soon if possible.

Thanks

Type: Ticket
Status: New
mghadmin
View Replies:

concrete5 Environment Information

# concrete5 Version
5.6.0.2

# concrete5 Packages
Advanced Forms (1.9.2.1), MGH Image Slider (1.0), MGH Redirect Manager (1.0), MGH Social Media Button Manager (1.1), OC - Location Manager (1.7), OC Deals (1.2), OC Events (1.0), OC Wedding Stories (1.0), Sidebar Manager (1.0), Theme Switcher (1.5).

# concrete5 Overrides
blocks/sixeightforms, blocks/members, blocks/meet_insiders, blocks/facility, blocks/maps, blocks/slideshow, blocks/services, blocks/dealspotlight, blocks/ask_insiders, blocks/performers, blocks/about_us, blocks/locations, blocks/title_text, blocks/autonav, blocks/youtube_shadowbox, blocks/things_to_do, blocks/locationspotlight, controllers/explore-oc, controllers/members-list.php, controllers/dashboard, controllers/page_types, controllers/dt-feed.php, controllers/maps.php, controllers/beach-weddings.php, controllers/con_events_feed.php, controllers/test.php, controllers/search-track.php, controllers/weddings, controllers/ocean-city-md-deals.php, controllers/rodney.php, controllers/rss-feed.php, controllers/events, controllers/events_feed.php, controllers/page_not_found.php, controllers/sports-planners.php, elements/block_footer_edit.php, elements/mgh-logo.png, elements/dashboard-bg.png, jobs/jobs?auth=96465c7e39d4d990061607d38b39edfc, jobs/insert_newsletter_subscriptions.php, jobs/expire_deals.php, jobs/update_deal_feed.php, jobs/update_weather.php, jobs/upgrades, jobs/copy_legacy_event_images.php, js/jquery.validationEngine.js, js/jquery-gmaps-latlon-picker.js, js/jquery-validation-engine, js/dashboard.js, js/jquery.ui2.js, js/jquery.ui.js, css/dashboard.css, css/images, libraries/PHPExcel.php, libraries/LocationSequence.sh, libraries/Fetch.Weather.php, libraries/InactiveEvents.php, libraries/deals.php, libraries/3rdParty, libraries/locations.php, libraries/DealSequence.sh, libraries/search.php, libraries/Deal_NewFeed.php, libraries/insiders.php, libraries/maps.php, libraries/PHPExcel, libraries/Fetch.Weather.sh, libraries/ocnew_images.php, libraries/ocnewfeed.php, libraries/keygen.php, libraries/members.php, libraries/LocationSequence.php, libraries/DealSequence.php, libraries/sixeightform-subscriptions.php, mail/photo-submission.php, models/womQuestions.php, models/answer_set.php, models/deals.php, models/tripPlanner.php, models/form.php, single_pages/search-results.php, single_pages/ocean-city-md-deals, single_pages/explore-oc, single_pages/members-list.php, single_pages/dashboard, single_pages/dt-feed.php, single_pages/maps.php, single_pages/beach-weddings.php, single_pages/group-travel.php, single_pages/con_events_feed.php, single_pages/test.php, single_pages/search-track.php, single_pages/weddings, single_pages/ocean-city-md-deals.php, single_pages/tests, single_pages/rodney.php, single_pages/rss-feed.php, single_pages/events, single_pages/events_feed.php, single_pages/sports-planners.php, themes/lp-mobile, themes/oc-twentyfourteen, themes/oc, tools/sixeightforms, tools/process_form.php

# Server Software
Apache/2.2.3 (Red Hat)

# Server API
apache2handler

# PHP Version
5.3.6

# PHP Extensions
apache2handler, bz2, calendar, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gearman, gettext, gmp, hash, iconv, imagick, json, libxml, mbstring, memcache, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xdebug, xml, xmlreader, xmlwriter, xsl, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
memory_limit - 250M
post_max_size - 500M
safe_mode - Off
safe_mode_exec_dir - <i>no value</i>
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 500M
memcache.max_failover_attempts - 20
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 100000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH
xdebug.max_nesting_level - 100
xdebug.var_display_max_children - 128
xdebug.var_display_max_data - 512
xdebug.var_display_max_depth - 3

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.