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

Jan Bednarik info at bednarik.org
Thu Mar 22 18:43:43 CET 2012


Oh, wow, kinda big guns for such thing. I'm ashamed of myself, but since 
I've spent way too much time on this project, I wanted this as fast as 
possible, so I hacked TYPO3 source codes and changed comma to 
semi-colon. I know ... sorry :)

Jan

Dne 22.3.2012 18:30, Kay Strobach napsal(a):
> 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
>>>
>>
>
>



More information about the TYPO3-english mailing list