Re: automatic posting instead of manual editing?

It is not my expertise, but once I buildt a site (currently offline) that way. I prepared a spreadsheet with Excell following de textpattern articles table structure (look at it with phpmyadmin or with the plugin rss_admin_db_manager), then I used a desktop software called navicat (but there are tons of similar applications) to insert the content directly to the textpattern database. You can do it without Navicat or similars, just with phpMyAdmin, but I don’t know SQL so for me it was easyer to use a visual interface than mySQL commands.

Any way, before trying any direct data inject to the database, make a backup!

Re: automatic posting instead of manual editing?

Check out the examples for aks_cron. He’s doing something along those lines, modifying existing articles, but you can create new articles as well. Example: Cron script that uses RSS to create new articles and insert them into the TXP database.

Re: automatic posting instead of manual editing?

James, another keyword to look for is XML-RPC (or XMLRPC). TXP comes with an XML-RPC-Server (needs to be activated in admin). XML-RPC-clients/-editors are able to post articles to TXP without using the web backend. Trap: TXP sections are not supported by XML-RPCAFAIK.

Re: automatic posting instead of manual editing?

Aside from what the others have said about pre-preparing posts with a post-date in the future, a few more ideas.

Another way to bring in articles if your source is an rss-feed as maruchan mentioned is to use smd_xml or another import from rss plugin.

If your articles have a fairly simple structure, you could use jmd_csv to import from an excel file and set future post dates (note: the plugin requires a slight change to set custom post dates, see that thread).

One final half-baked idea if you’re thinking mostly of your photos rather than your essays. If you use Adobe Lightroom or similar for managing your photos, it is possible to create export scripts from Adobe Lightroom that will upload the image file (resized if required) and a file with the image metadata (I’ve done this several years ago for a non-txp site before. I believe there’s also a script that will update an online database). I recently experimented with the as yet not publicly released rah_flat which imports from files to the database on a file by file basis and is configurable for different types of files. Theoretically, it might be possible to make Lightroom (etc.) export a file with your image title, name, etc. in a specific format to a particular directory on your homepage and have rah_flat automatically import that as an article. My guess is it would require some experimentation, but it may be a way of publishing photos to your site directly from Lightroom.

Re: automatic posting instead of manual editing?

jakob wrote:

One final half-baked idea if you’re thinking mostly of your photos rather than your essays. If you use Adobe Lightroom or similar for managing your photos, it is possible to create export scripts from Adobe Lightroom that will upload the image file (resized if required) and a file with the image metadata (I’ve done this several years ago for a non-txp site before. I believe there’s also a script that will update an online database). I recently experimented with the as yet not publicly released rah_flat which imports from files to the database on a file by file basis and is configurable for different types of files. Theoretically, it might be possible to make Lightroom (etc.) export a file with your image title, name, etc. in a specific format to a particular directory on your homepage and have rah_flat automatically import that as an article. My guess is it would require some experimentation, but it may be a way of publishing photos to your site directly from Lightroom.

i wonder if there is something like this for uploading sound files too?

Re: automatic posting instead of manual editing?

maruchan wrote:

Are you using Audition? Do you want to end up with individual articles for each sound file, or would it be enough to post a prettified XML feed on your site?

well fairly general needs right now, but on my main site i use custom fields to either input an absolute url, or i use the txp files tab and it references the file number. then that gets parsed into my mp3 player, with a download link as well.

i’m not using audition (most often i use Goldwave), but would be willing to adopt it if i could make use of some of adobe’s scripts

Re: automatic posting instead of manual editing?

Here’s a script I modified that will automatically create an XML feed from a folder full of MP3 files. All you’d have to do is mount the SYSDIR folder in this script as an SSH folder on your local machine, for example via ExpanDrive, and export MP3s from Goldwave to that folder. Then set this script to run on your web server every few minutes via cron. I just tried it and it worked great.

From there you can read the items into Textpattern via smd_xml. If you want to get fancy there are probably ways to pull in ID3 info from the files, too, so you’re not just stuck with filename and link.

Anyway, this would pretty much be like: “Export from Goldwave, done”-easy.