DEPRECATION WARNING

This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.

Export everything from tt_address¶

Author:	Kasper Skårhøj
Created:	2002-11-01T00:32:00
Changed by:	Martin Aarhof
Changed:	2010-04-11T23:53:03.660000000
Classification:	maa_tt_address_export
Description:	The keywords help with categorizing and tagging of the manuals. You can combine two or more keywords and add additional keywords yourself. Please use at least one keyword from both lists. If your manual is NOT in english, see next tab "language" ---- forEditors (use this for editors / german "Redakteure") forAdmins (use this for Administrators) forDevelopers (use this for Developers) forBeginners (manuals covering TYPO3 basics) forIntermediates (manuals going into more depth) forAdvanced (covering the most advanced TYPO3 topics) see more: http://wiki.typo3.org/doc_template#tags ----
Keywords:	tt_address, maa, export, xml, html, csv, excel
Author:	Martin Aarhof
Email:	martin@aarhof.eu
Info 4:	Scandesigns A/S
Language:	en (language file for all things)

Export everything from tt_address - maa_tt_address_export

Export everything from tt_address¶

Extension Key: maa_tt_address_export

Language: en (language file for all things)

Keywords: tt_address, maa, export, xml, html, csv, excel

This document is published under the Open Content License

available from http://www.opencontent.org/opl.shtml

The content of this document is related to TYPO3

- a GNU/GPL CMS/Framework available from www.typo3.org

Table of Contents¶

Export everything from tt_address 1

`Introduction 3 <#__RefHeading__324_1391903108>`_

What does it do? 3

`Users manual 4 <#__RefHeading__328_1391903108>`_

Installation 4

Usage 4

`Configuration 5 <#__RefHeading__334_1391903108>`_

`TypoScript 6 <#__RefHeading__301_498025298>`_

`To-Do list 7 <#__RefHeading__336_1391903108>`_

`Change log 8 <#__RefHeading__338_1391903108>`_

`This page is intentionally left blank 9 <#__RefHeading__340_1391903108>`_

Introduction¶

What does it do?¶

Need a possibility to export all your tt_addresses into a document, such as XML, CSV, HTML file or even real excel format, this extension should do it.

You can manually set which fields from the tt_address table you want to export, and from which pages you want to export from.

Users manual¶

Installation¶

When you have installed the extension via Typo3 extension manager, you will have a new icon in the left menu – In the “Admin tools” section – Named “tt_address export”.

Usage¶

When you have pressed the icon a export function will be shown.

In the top right you can choose which export function you want. (this should be choosed before anything else, the page WILL reload)

Now there are 3 or more sections

“Choose pageIDS”

Here you can choose which pages you want to extract the addresses from.

“Export settings”

Its created from each export function.

“Exclude fields”

Here you can choose which fields from the tt_address database you don't want to have in your export.

When you press “Export” you will get a HTML text area with all the contents inside, but beneath it there will be a link to a created file with your data inside. Please right click the link and choose “Save as”

Configuration¶

No configuration is needed.

TypoScript¶

You can define which fields you want to exclude per default by adding this into your user TSConfig.

You can find your user tsconfig in: Admin tools > User Admin > edit your user > Options > TSConfig

Add this line to the user TSConfig

options.maa_tt_address_export_exclude = comma seperated list of exclude fields

The list is a comma seperated list fx.

options.maa_tt_address_export_exclude = uid,pid,www,gender

To-Do list¶

Major test of Excel export
SOAP export (so you don't need to get into typo3 back-end to get a export, maybe it will be a completely new extension
Some other export methods? (give me ideas)
When you get a error, please don't remove checks in check boxes in fx. exclude fields

Change log¶

Version 0.1.1

Added support via TypoScript to automatic select exclude fields

Added support for selecting deleted and hidden addresses

Version 0.1.0

Has now added real Excel 2004 support

Version 0.0.4

Added this manual :)

Version 0.0.3

First real version

Supporting: CSV, XML and HTML (real excel will be added in one of the next releases)

This page is intentionally left blank¶

9