|
You are here: Home / Cascade Status Change
Cascade Status Change
Forum /
Support Questions /
Cascade Status Change
Reply
Subscribe
Start new thread
Syndicated Feed (RSS)
|
Displaying 1 to 3 of 3
|
Previous
1
Next |
| Author |
Message |
Russell
Posts: 6
|
Hi,
We are currently importing a large number of files (approx 2000) into a new site using Adobe Air, they are going in fine but the status of all the files is draft. Rather than going in and editing the status of each file - which would be very time consuming - is there any way of changing the status of all files in one go (or at least a folder at a time)?
Any suggestions welcome.
Thanks
Russell
|
|
Back to top
|
|
re599
Posts: 25
Location: Oxfordshire, UK
|
|
Re: Cascade Status Change - Posted: July 23, 2008 - 12:16 PM
|
Quote and reply
|
I've found a table in the MySQL backend called sitellite_filesystem with a field called sitellite_status which is set to draft, would it be adviseable to write a SET syql query to update all these tuples to Approved
Thanks,
Bob
Russell said:
Hi,
We are currently importing a large number of files (approx 2000) into a new site using Adobe Air, they are going in fine but the status of all the files is draft. Rather than going in and editing the status of each file - which would be very time consuming - is there any way of changing the status of all files in one go (or at least a folder at a time)?
Any suggestions welcome.
Thanks
Russell
|
|
Back to top
|
View user profile
Contact this member
|
lux
Posts: 645
Location: Manitoba, Canada
|
|
Re: Cascade Status Change - Posted: July 23, 2008 - 2:26 PM
|
Quote and reply
|
re599 said:
I've found a table in the MySQL backend called sitellite_filesystem with a field called sitellite_status which is set to draft, would it be adviseable to write a SET syql query to update all these tuples to Approved
As long as you do the same to the sitellite_filesystem_sv entries (the versioning table), this should work fine.
Cheers,
Lux
|
|
Back to top
|
View user profile
Contact this member
|
|
|
