How to import caption from .CSV file?

NathanP

Joined: 2005-08-24
Posts: 4
Posted: Mon, 2005-08-29 14:20

I'm trying to import many images as well as captions from a .CSV file. It looked like this was easy with G1 (which I didn't really use), but G2 doesn't seem to use the meta data file. How do I get my captions into the database? I can massage them into SQL if necessary, but I don't want to renter them by hand. My old website has about 20 albums each with about 20 images, all in pre-generated html which I can parse with perl.

-- Nathan P.

----

Gallery version = 2.0-rc-2 core 0.9.36
PHP version = 4.3.3 apache
Webserver = Apache/1.3.28 (Unix) PHP/4.3.3 mod_ssl/2.8.15 OpenSSL/0.9.7b
Database = mysql 3.23.57
Toolkits = Exif, ImageMagick, NetPBM
Operating system = OpenBSD 3.4 RAID#0 i386
Browser = Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.10) Gecko/20050717
 
fryfrog

Joined: 2002-10-30
Posts: 3236
Posted: Mon, 2005-08-29 15:21

It is certainly a round-a-bout way (hahah!), but you could add them to a G1 that you have setup... then use the Import from G1! Crazy, but It should work.
 
NathanP

Joined: 2005-08-24
Posts: 4
Posted: Mon, 2005-08-29 16:54

Hmm, that means I'd have to install both... ick.

So are you implying that this functionality no longer exists, in G2?
 
jmullan
jmullan's picture

Joined: 2002-07-28
Posts: 974
Posted: Mon, 2005-08-29 16:59

You could try hacking g2add.pl
 
NathanP

Joined: 2005-08-24
Posts: 4
Posted: Tue, 2005-08-30 17:00
jmullan wrote:
You could try hacking g2add.pl

Hmm, looks like that could work. I don't want to muck up your code though... might be feature you'd be interested in adding?
 
jmullan
jmullan's picture

Joined: 2002-07-28
Posts: 974
Posted: Tue, 2005-08-30 18:40

I probably won't be adding any features until I rewrite it with the upcoming xmlrpc interface
 
majorxp

Joined: 2006-05-08
Posts: 20
Posted: Tue, 2006-06-13 21:48

Nathan...did you code this? If so, I'd love to see it and adapt it for my use.
 
mlissner

Joined: 2007-10-11
Posts: 7
Posted: Fri, 2007-10-12 02:10

I could really use this feature? Does it exist anywhere?