[TYPO3-english] BE CSV export - semi-colon

Kay Strobach typo3 at kay-strobach.de
Thu Mar 22 18:30:20 CET 2012


Hi Jan,

i had to solve such a problem in the past.
I just created a small cronjob, which created an excel file with
phpexcel and pushed it into a directory, which was accessable for the
user ;)

Regards
Kay

Am 22.03.2012 17:02, schrieb Jan Bednarik:
> Thanks, I need this to be really simple. It's for a BE user that uses
> Mac computer and they want to download list of FE users, using this CSV
> export is the simpliest thing I found. Anyway, I can't make them rename
> file or any other more complicated thing than "double click the
> downloaded file".
> 
> Regards
> 
> Jan
> 
> Dne 22.3.2012 7:16, Gregor Schweppe napsal(a):
>> hi,
>> it is posssible to open every ascii text file and define a delimiter.
>> Space, tab, comma, semicolon or user defined.
>>
>> How do you open the file and which excel version do you use?
>>
>> Cheers
>> Gregor
>>
>> T o n<scoobjuh at hotmail.com>  wrote:
>>
>>
>> start
>> control panel
>> clock language and region
>> region and language
>> additinal settings
>> change the list separator from ; to ,
>> if that does not work, then simply change the main format to English
>>
>>> From: info at bednarik.org
>>> Date: Thu, 22 Mar 2012 06:40:33 +0100
>>> To: typo3-english at lists.typo3.org
>>> Subject: [TYPO3-english] BE CSV export - semi-colon
>>>
>>> Hi all,
>>>
>>> is it possible to configure CSV export from BE to separate fields with
>>> semi-colon? Windows' Excel is not able to open CSV with commas.
>>>
>>> Or is there a way to force Excel to open it correctly?
>>>
>>> Thanks
>>>
>>> Jan
>>> _____________________________________________
>>
>>> TYPO3-english mailing list
>>> TYPO3-english at lists.typo3.org
>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>>                      
>> _____________________________________________
>>
>> TYPO3-english mailing list
>> TYPO3-english at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>>
> 


-- 
http://www.kay-strobach.de - Open Source Rocks

TYPO3 .... inspiring people to share!
Get involved: http://typo3.org

Answer was useful: https://flattr.com/profile/kaystrobach


More information about the TYPO3-english mailing list