View Full Version : Flat File Import
August 16th, 2005, 03:38 PM
Currently I run a slightly modificed dcscripts product for a file library which I can fairly easily manipulate to get a flat file output of its contents. Is there a flat file import into vbGallery available to make the job of repopulating a little less painfull
August 16th, 2005, 03:41 PM
Not really... If you can post one of those flat files here though I *may* be able to help you with an import.
August 16th, 2005, 07:19 PM
Well basically I can create a flat file in any format needed as I can do the programming for that bit <grin>
Probably along the lines of
August 16th, 2005, 07:29 PM
Without any manipulation at all the file looks like this
Category - this would have to be maniipulated to match new category
Description - can be fairly lengthy so may need to be clipped
User Name - for import fairly irrelevant
User Email - for import fairly irrelevant
Dont Care (Number of Ratings)
Dont Care (Average Rating)
August 17th, 2005, 11:38 AM
It shouldn't be too hard to "convert" that into some SQL queries. If you're not familiar with MySQL and would prefer, you could just submit a support ticket via the Members' Area here, be sure to include the info on how to get to your old links directory and get the flat file, and I'll be glad to take care of the import for you.
September 8th, 2005, 06:23 PM
Sorry for the delay in responding - between that post and this one had to have an operation on my foot! I can probably do it myself when the time comes but will raise a ticket if I get a problem
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.