Import image database from Filemaker application

posa
posa's picture

Joined: 2005-07-04
Posts: 3
Posted: Tue, 2005-08-23 08:41

Hi to all.

I have a database of images (artists pictures) packed in Filemaker Pro.
All the images are external and linked in an archive of FMP.
The archive is pretty simple: contains only few text fields (Name, Date, dimensions, technique, title) and a "code" field corrisponding to a unique code number used also for image names (es: [code_number].jpg).

What is the more simple and clean method to import this database in Gallery2?

I can export all fields in a text file tab-delimited and I have all the images in a single folder, how can I import informations and files without loosing the correct correspondance?

Thanks in advance...

----

Gallery URL (optional): None at this moment
Gallery version: G2 RC1
Webserver (with version): Apache 1.3.x
Datatabase (with version): MySQL 4.0.18
PHP version (eg 4.2.1): 4.3.8
phpinfo URL (optional): /
Graphics Toolkit(s): Imagemagik/GD/NetPBM
Operating system: Suse Professional 9.2
Web browser/version: Firefox
G1 version (for migration bugs): 1.5
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2005-08-23 15:02

you should use the Gallery2 API to import (= create) albums, photos, users, other items. if you wanted to import it without PHP, directly into the database, it would get over complicated because you'd have to take a deep dive into the G2 architecture / database schema, which isn't that easy.
see (obsolete!, but the most up to date version of this image): http://gallery.menalto.com/modules.php?full=1&set_albumName=miscellaneous&id=aaf&op=modload&name=gallery&file=index&include=view_photo.php

so what i'd do is take a look at the migrate module which imports data from Gallery 1 into G2. G1 is also a text file based application.
take a look at modules/migrate/ConfirmImport.inc