Hot answers tagged

5

I'd recommend turning on "Enable HTTP Authentication?" for your template, so that you must use a username/password to access it, and then setting up a Cron job on your server to save to disk on a nightly basis: 00 00 * * * curl http://username:password@yoursite.com/your/template > /var/www/csv/`date +\%Y\%m\%d\%H\%M\%S`.csv


3

Looks like you have working code to generate XML for multiple orders, and generating XML for a single order is easy by just including the order_hash or order_id parameter. The only problem then is how to move these files into an FTP directory for your CRM. To do this you could either set up a nightly script to check for new orders and save their XML to a ...


3

You could have an admin-only page where you list orders using store:orders, and have each link to the order detail via its order_hash. {exp:store:orders} {if count == "1"}<ul>{/if} <li><a href="{path="orders/view/{order_hash}">Order #{order_id}</a></li> {if count == total_results}</ul>{/if} {/exp:store:orders} Then ...


2

Ok so this has been resolved now. With credit to @Michael Boyink who suggested the following; I had been creating the templates using FTP. However when the templates were created in the Control Panel Template Manager using XML as a template type, the XML gets populated with channel data, just as I had hoped. Relief!!, this one could have stumped me for ...


2

I have ended up going with the following plugin found on devot-ee Weblog Entries Exporter Seemed to do the trick. Specifically for ExpressionEnginev1 it gives the option of exporting as a .CSV or .XML. Just what I needed


2

try DATE_FORMAT(from_unixtime(entry_date), '%Y-%m-%d') AS post_date


2

You can do it like this: <a href="members/index" class="button">Download</a> (place this button anywhere you want) Just create group in your templates called members and add {exp:ajw_export sql="SELECT * FROM exp_member_data" format="csv" filename="members.csv" } to index file.


2

It should work fine. You're just missing a dynamic="no" on your channel:entries tag. Try it like this: {exp:channel:entries channel="my channel" category="{segment_3}" disable="category_fields|member_data|pagination" dynamic="no" }


2

One really flexible and simple shortcut to exporting a .xls spreadsheet of Channel data is to generate an html table using an ExpressionEngine template, save the page as a file, and then open the file with MS Excel. Create a template (eg export.group/index.html) Output all the necessary data using a channel:entries loop and any other necessary template ...


2

think you're very lucky :) check this new post by Sean Smith on how he built a resume builder Channel Form and Grid/Matrix fields


2

Try https://devot-ee.com/add-ons/ajw-export. I recently used it to export Store products.


2

I don't know of any particular 3rd party add-ons that are crafted to specifically export Cart Throb data, but it's a pretty cut-and-dry process to output a MySQL table to CSV. You can use a tool like Sequel Pro (OS X) or MySQL Workbench (Windows, Linux) to select your data with a query and then save the query results as a CSV file. If you require something ...


2

For data import, I highly recommend using AJW datagrab with CSV data. http://brandnewbox.co.uk/products/details/datagrab data export is a little bit trickier, but you can setup a template to output to CSV/XML or you can use a plugin like Zenbu Studios Hokoku to setup exports directly from the admin CP (if you use Zenbu). If you want to setup CSV output and ...


2

You can export the data from the EE MySQL database if you have access to a MySQL utility such as Sequel Pro or Navicat. You'll need to enter some SQL to isolate the data you want, something like this: SELECT t_variable.id AS entry_id, t_variable.name AS entry_name, t_translation.content AS entry_content FROM exp_transcribe_variables t_variable ...


1

You should try to export data into XLSX format with PHP_XLSXWriter. You can try below code which is example of PHP_XLSXWriter. <?php include_once('xlsxwriter.class.php'); /*you can get xlsxwriter.class.php from given GitHub link*/ $filename = "example.xlsx"; header('Content-disposition: attachment; filename="'.XLSXWriter::sanitize_filename($...


1

EE lets you assign arbitrary field names to your content - so there is no 'default' field name for this. EE uses standard field names for some meta-data (e.g. {entry_id} is always the index number for an entry etc.), but not for content. The use of standard field names probably explains why your script works at all, but without modifying it to reflect ...


1

For a simple EE to EE migration (within v.2 at least) there's no need for Datagrab et al, just export the SQL tables that you want and import into the other database.


1

Late answer i know... But i tend to always use Datagrab: http://brandnewbox.co.uk/products/details/datagrab


1

There's no silver bullet unfortunately. I'd bring in the latest site to local. Upgrade local to V3. On local create/rename fields but don't delete. Document every change to the channels & fields because once your local setup is ready you will have to set live to offline. Then update to EE3 then update all channels & fields to match local. Then ...


1

You're not doing anything wrong here - you've just encountered a limitation of the template engine. If you read through the parse order in that link, you'll see that embedded templates are processed after PHP on output it processed - meaning that you cannot include the parsed contents of an embedded template inside of PHP output. If there are a lot of these ...


1

Generally when I want to export data from ExpressionEngine I take one of two approaches, depending how much data I need and how complex the channel structure is. The easiest approach is to build templates to output the data. This is easily done to output XML, but it can also output JSON if you tinker around with the formatting in your template. You build ...


1

Zoo Visitor stores data as channel entires so you should be fine using Export It since it allows exporting of channel data. I have not personally tried exporting Zoo Visitor data but I assume passwords might be your only issue since they are not stored in the DB as plain text but are salted.


1

Not sure exactly what your needs are but would NSM Reports solve your problems?


1

We're just about to a launch a full job portal site for a client that includes Employer access with ability to add/edit jobs, job applicants with ability to upload resume, save jobs to favorites and apply directly to jobs. We used Zoo Visitor for our member management which was beyond easy and then utilized Reefine for the search filters. Freeforms was used ...


1

Have built a few things like this in EE. Look at Zoo Visitor for the member registration and something like Low Search for the search side. There are more than a few ways to go about it. Have a look on Devot-EE for more addons that could help your build.


1

If I understand correctly, you only want to execute the exp:ajw_export tag if the logged in member ID is 1. For this, you don't need the low_variables:parse tag. Instead, in the Low Variables settings, make sure Early Parsed Member Data is set to Yes. Then use (simple, pre EE2.9) conditionals: {if logged_in_group_id == 1} {exp:ajw_export sql="SELECT * ...


1

Just looked at the database of one of my sites running Zoo Visitor. You're going to have to pull and link data from exp_members (to get the member ID), exp_channel_titles (to link the member ID with the author ID), and exp_channel_data (to get the rest of the data you want) Please note that i'm not a database expert! That said, try something like this: ...


1

One quick and dirty way is to output the data into a template then copy/paste the data into a text editor and save as a .csv Create a template in EE that you'll use to output the data Add a channel entries tag to get the data, something like this: {exp:channel:entries channel="my_channel" limit="999" status="open|closed" dynamic="no} {entry_id}|{status}|{...


1

IF the channels share the same custom field group you should be able to use a bit of SQL to check for a specific channel_id and convert it to the channel_id you are keeping. If the channels do not share the same custom field groups you will need to export the data. This can be as simple as creating a template and setting it to XML, or using one of the ...


1

Exporting; exp_channel_data exp_channel_titles and maybe exp_channel_entries_autosave Should get you there. Obviously back it all up first in case it goes horribly wrong. You may also be to approach it the other way and install the add-on on the staging server and get them in synch that way. There may well be much less data to deal with.


Only top voted, non community-wiki answers of a minimum length are eligible