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


4

This should cover it. SELECT field_id_49 as 'First Name', field_id_50 as 'Last Name', field_id_51 as 'Email', field_id_56 as 'Date of Birth', field_id_53 as 'Occupation', field_id_52 as 'Gender', field_id_57 as 'Address', field_id_58 as 'Address 2', field_id_59 as 'City', field_id_60 as 'Postal Code', field_id_54 ...


3

There are two steps here. First, getting the data out of the first install. And second, getting it back into the new one. For exporting, there's a number of routes you can take. Since you're relying on some fieldtypes that use their own tables, the easiest route might be to create an XML template for each channel. That will allow you the flexibility to use ...


3

Saw your post in meta - maybe a new answer which distills the entire thread you and Anna have created will be of help? You do need two templates. The first will begin your document, and then list each channel entry, and then close the document. Within that template's channel:entries loop, you will embed your "comments" template, which will run once for ...


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

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

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


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

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.


1

It depends entirely on what format you need the data to be export into (CSV, JSON, XML, etc). Even when you have decided on a format, you probably need to massage the data into specific columns which apply to your new system. Datagrab etc work well for import/export, I don't personally have any experience with the others. In most situations I would ...


1

I don't know if there are existing add-ons that support what you want to accomplish. You will most likely need to create a custom extension using: Member Module Registration Extension Hooks (for default ee registration) member_member_register (if you don't use validation) member_register_validate_members (if you use email validation) and api library - ...


1

Try adding dynamic="no" to your exp:comment:entries tag. I would also add the channel="" parameter to the tag: {exp:comment:entries sort="desc" entry_id="{embed:entry_id}" dynamic="no" channel="XXXX"} Also, confirm that {embed:entry_id} is printing out the correct ID in your embed. If that doesn't work, make sure your exp:comment:entries is NOT inside a ...


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