Import from flat file

[esscott]

I am moving from a site that had a custom coded ASP image gallery of sorts. I have downloaded the data in excel files. I'm wondering if there is an import script that will allow me to formate this data and import it.

[Zachariah]

I use and old 3rd party windows application. It has an option to import CVS files into your databases. "MySQL-Front"

I think:
http://www.phpmyadmin.net

There are a few import scripts here that moves data from 1 database to the other.

This is also nice:
http://us3.php.net/fgetcsv

[esscott]

I have the data imported and it looks like it all worked. However, I can't figure out where it is looking for my images. What directory should I upload my files to for them to be found.

http://67.192.62.180/gallery/browsei...p?c=13&userid=

[Zachariah]

URL to Gallery Images:
$gallery_url = http://www.domain.com/gallery/files

Path of Images:
$gallery_path = /path/to your/gallery/files

$userid = User ID is the Id given by vBulletin

$userid_path = implode('/',preg_split('//', $userid, -1, PREG_SPLIT_NO_EMPTY));

$path = "$gallery_path/$userid_path";

Path:
/path/to your/gallery/files/u/s/e/r/i/d/image_name.jpg
URL:
http://www.domain.com/gallery/files/u/s/e/r/i/d/image_name.jpg

Images:
Thumbnail: image_name_thumb.jpg
Med/Large: image_name.jpg
Original: image_name_original.jpg

[esscott]

I've placed the image file in a folder that should match the format you provided and - no luck.

What next...

This is the post that should pull up the image:
http://67.192.62.180/gallery/showimage.php?i=809&c=13

This is the image on my site:
http://67.192.62.180/gallery/files/a/d/m/i/n/13671A.jpg

Could I have the database incorrect? I wasn't able to provide a dimensions or file size for the images? This is the database entry for this item:

809 1963 mercury comet 4 door wagon :: John Hunten 1963 comet 4 door wagon,converted into a 2 door co... 13 0 1 admin jpg 13671A.jpg 0 0 0 0 0 0 7 0 1 1 0 0 0 0 0

[Chuck S]

I beleive what Zachariah has told you is the files should be userid not username like so

INCORRECT

http://67.192.62.180/gallery/files/a/d/m/i/n/13671A.jpg

CORRECT

http://67.192.62.180/gallery/files/1/13671A.jpg

[esscott]

Well that makes sense, but I tried that too... still no luck.

Sorry to be such a hassle.

[Chuck S]

Well I am not the vbgallery guru here so I will let Josh respond but your issue seems centered around your import thing and not specifically the product itself.

The files are like that on my test site?

http://omegatron.net/gallery/showimage.php?i=1&catid=3

http://www.omegatron.net/gallery/fil...nterLeaves.jpg

More than likely once you get all the main images showing you need to rebuild your thumbnails. You sure your import worked correctly? Is the filename correct in the filename field in the database?

[esscott]

My guess is my data isn't correct. I included a example line out of my database in the earlier post. I hope that the problem isn't the image size fields being blank.

[Zachariah]

If the names are correct and the images are in the correct place you can run a utility in maintenance of the gallery.

AdminCP => vBGallery => Maintenance
- Rebuild Image Info

This tool will re-calculate the width, height, and filesize of your images. Select the number of images you would like to process at a time, the category you would like to rebuild images in, and then click 'Rebuild Image Info' to begin

Sample Image 25 below.
I exported a image and its fields for data layout.

Content visible to verified customers only.

Content visible to verified customers only.

[esscott]

Running the maintenance function worked... Thanks for all the help