[TYPO3-dev] Add pictures / files directly to sys_file table, ...

[Dirk Ho]

Hi Christian and Frans,

thanks for your very interesting answers. Because the part I add the 
newsletters in the "community" will be a quite new "feature" and has no 
connection to older/existing news, I guess I take the new technology of 
tx_news to solve it.

For older existing news on the main page I'll have a look if there's a 
possibility to migrate entries from tt_news to tx_news.

Your answers were a great help!

Thanks and best wishes,

Dirk

Am 10.06.2014 12:23, schrieb Christian Reiter:
> Hi,
>
> as Frans has stated - if you are using the normal tt_news plugin, that
> does not connect to FAL.
>
> So if you want to create old-school tt_news records with images/files
> you need to place copies of the files in the uploads/ folders.
> Just look at some existing manually created tt_news records and their
> file locations and you will see how this works.
>
> Otherwise you can in principle also use FAL with tt_news.
>
> There is an extension called "dam_ttnews" which makes tt_news work with
> DAM files/images instead of copies in uploads/pics.
>
> You can take this code and rewrite the DAM part for displaying the
> images and put in the FAL TCA backend code.
>
> Then yoü have a "fal_ttnews", this works and is a solution if you want
> to continue to use tt_news (because you have huge amounts of working
> legacy features added to it that can't be transferred to tx_news) but
> you still want to profit from FAL. Or if you were already using
> dam_ttnews in TYPO3 4.x and want to migrate to 6.x/ DAM to FAL but don't
> want to "downgrade" tt_news to old-school file management.
>
> Best regards,
>
> Christian
>
>
> Am 09.06.2014 22:41, schrieb Dirk Ho:
>> Hi all,
>>
>> I want to parse our member newsletters, send via mailman, in a cronjob
>> script and add them directly to the typo3 database and add them as a
>> tt_news entry.
>>
>> Therefore I need to know, how the tables work and are related. I guess I
>> have to put the file to upload anywhere in fileadmin and add this path
>> to the sys_file, also. For each file I also add an entry in
>> file_metadata.
>>
>> What do I have to add to sys_file_reference, sys_file_processedfile,
>> sys_file_collection, sys_filemounts to be able to reference the uploaded
>> file in tt_news table?
>>
>> It would be great if you could help me to get this work.
>>
>> Thanks and best wishes,
>>
>> Dirk
>