PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > vBGallery Support > vBGallery Import Scripts

vBGallery Import Scripts Here you will find import scripts to help convert your existing gallery to PhotoPost vBGallery.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old December 21st, 2007, 01:38 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Dec 2007
Posts: 9
Import from flat file

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.
esscott is offline   Reply With Quote
Old December 21st, 2007, 07:38 PM   #2 (permalink)
Registered User
Verified Customer
 
Zachariah's Avatar
 
Join Date: Nov 2005
Location: Canoga Park, CA
Posts: 3,229
Send a message via ICQ to Zachariah Send a message via AIM to Zachariah Send a message via MSN to Zachariah Send a message via Skype™ to 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
Zachariah is offline   Reply With Quote
Old December 28th, 2007, 09:16 AM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Dec 2007
Posts: 9
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=
esscott is offline   Reply With Quote
Old December 28th, 2007, 08:07 PM   #4 (permalink)
Registered User
Verified Customer
 
Zachariah's Avatar
 
Join Date: Nov 2005
Location: Canoga Park, CA
Posts: 3,229
Send a message via ICQ to Zachariah Send a message via AIM to Zachariah Send a message via MSN to Zachariah Send a message via Skype™ to 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
Zachariah is offline   Reply With Quote
Old December 31st, 2007, 10:36 AM   #5 (permalink)
Junior Member
Verified Customer
 
Join Date: Dec 2007
Posts: 9
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
esscott is offline   Reply With Quote
Old December 31st, 2007, 10:44 AM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 52,658
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
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old December 31st, 2007, 02:09 PM   #7 (permalink)
Junior Member
Verified Customer
 
Join Date: Dec 2007
Posts: 9
Well that makes sense, but I tried that too... still no luck.

Sorry to be such a hassle.
esscott is offline   Reply With Quote
Old December 31st, 2007, 03:13 PM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 52,658
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?
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old December 31st, 2007, 04:08 PM   #9 (permalink)
Junior Member
Verified Customer
 
Join Date: Dec 2007
Posts: 9
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.
esscott is offline   Reply With Quote
Old December 31st, 2007, 04:47 PM   #10 (permalink)
Registered User
Verified Customer
 
Zachariah's Avatar
 
Join Date: Nov 2005
Location: Canoga Park, CA
Posts: 3,229
Send a message via ICQ to Zachariah Send a message via AIM to Zachariah Send a message via MSN to Zachariah Send a message via Skype™ to 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
Quote:
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.

Code:
Content visible to verified customers only.
Code:
Content visible to verified customers only.

Last edited by Zachariah; December 31st, 2007 at 04:53 PM.
Zachariah is offline   Reply With Quote
Old January 2nd, 2008, 04:29 PM   #11 (permalink)
Junior Member
Verified Customer
 
Join Date: Dec 2007
Posts: 9
Running the maintenance function worked... Thanks for all the help
esscott is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to import... CallieJo ReviewPost How do I...? 5 January 6th, 2007 08:06 AM
vb Import copying over the same file names. Ghostsuit Photopost Pro Installation & Upgrades 5 November 14th, 2006 10:28 PM
Auto compress/size file & spaces in file name. brihan Before You Buy 1 April 6th, 2006 09:29 AM
Flat File Import Neil Washbrook Before You Buy 5 September 8th, 2005 07:23 PM


All times are GMT -5. The time now is 04:15 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0