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

I would imagine that a CSV is not the best way to represent this data, and that it'll prevent you from successfully importing into a Grid field. I would take the CSV data and (using PHP or some other tool) reformat it into XML, which will much more readily represent the nested sets of fields in a Grid.


2

Kind of depends on your budget, but in a pinch, Mithra62's "export it" add-on would definitely allow you to handle that.


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

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

You can use a wonderful EE utility called Streeng to do this (and lots of other things). Streeng performs a broad variety of manipulations on the tag outputs, including stripping out some or all of the <html> tags within it, and performing substitutions. You could use these features to achieve what you are describing (and remove the conditional ...


1

Haven't used BBD Stringer, but have used Low List to help with this. You can do something like: {exp:stash:set_list name="XXX" parse_tags="yes" } {exp:low_list:each items="north|east|south|west" as="individual_direction"} {stash:direction}{individual_direction}{/stash:direction} {/exp:low_list:each} {/exp:stash:set_list} By the way,...


1

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


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

Would a plugin like Streeng work out for you? https://github.com/caddis/streeng It allows you to find/replace text. It can encode/decode HTML character codes, selectively strip HTML, etc. As jchrono-battle said, I'd be surprised if there wasn't a CSV exporter already available.


1

I see that you can't use add-ons. I also realized that my previous answer would not work because of parse order issues between EE tags and PHP. Here is an updated, purely PHP answer for you. I've tested it on a template with PHP turned on (doesn't matter if it's input or output). Credit definitely goes to this stack answer: https://stackoverflow.com/...


1

Can you try rebuilding the Super Search Lexicon? (go to: SuperSearch > Utilities). I have a feeling that Super Search only updates this if you add the entries through the Control Panel.


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