[TYPO3-dam] Rename folder, which is indexed by DAM

[Davide Principi]

Isn't it an UPDATE?

UPDATE tx_dam SET file_path = 'is_new' WHERE file_path = 'was_old'

This SQL command replaces 'was_old' with 'is_new' in ALL tx_dam table! 
Be careful!

--Davide

Harald Jung ha scritto:
> Hi Steven,
> 
> thanks...i looked & i understand...but the problem is, that tx_dam >
> file_path has 600 entries !
> 
> Hmm..how can  i automatise this ? Like "find & replace" ?
> 
> Regards,
> 
> Harry
> 
> 
> Steven Bagshaw schrieb:
>> Hi Harald,
>>
>> If I understand correctly, I think you would be able to modify the file_path
>> column in the tx_dam table directly in the database.
>>
>> Have a look at the current values of the column to see if it will work.
>>
>> Steven
>>
>> "Harald Jung" <papaya74 at web.de> wrote in message
>> news:mailman.1.1154009866.1481.typo3-project-dam at lists.netfielders.de...
>>> Hi,
>>>
>>> we have to rename a folder with nearly 600 assets in Typo3. This folder
>>> + subfolders are indexed by DAM, and contain assets which are bind to
>>> special categories.
>>>
>>> We then just put DAM_Download Plugins on each site, and everything is
>>> displayed perfectly.
>>>
>>> NOW:
>>> ====
>>>
>>> What will happen or what do i have to do, if i will rename the
>>>
>>> OLD_FOLDER
>>> ---sub1
>>> ---sub2
>>> ---sub3
>>>
>>>
>>> TO
>>>
>>>
>>> NEW_FOLDER
>>> ---sub1
>>> ---sub2
>>> ---sub3
>>>
>>>
>>> I just tried it with a test-folder, but DAM_Downloads then says: "NO
>> IMAGE".
>>> If i reindex the new folder, then i have to bind the pictures to the
>>> categories again...with more than 600 assets, unfortunatly not acceptable.
>>>
>>> Has anyone a hint or an idea how to get this managed ?
>>>
>>> Thanks a lot !
>>>
>>> /harry
>>