Usergroup: Customer
Joined: Sep 12, 2004
Total Topics: 2
Total Posts: 7
Posted 09/15/04 - 03:30 PM:
#1
The files themselves are tab delimited.... and each of the category heirarchies are specified in their own column..
The problem is with the category heirarchy...
For the link data to show up in the correct category, the categories need to be created too - and that can only be done by uploading a separate file into the categories table..
Now, to do this, each category has to have a unique ID... AND, each sub-category has to have a parent ID denoting the category under which it belongs..
THAT is the troublesome part to do by hand in Excel..
Usergroup: Member
Joined: Sep 15, 2004
Total Topics: 0
Total Posts: 1
Posted 09/15/04 - 04:32 PM:
#2
Try to post your project at supportuniverse.com, there are hundreds of <a href='http://www.supportuniverse.com' target='_blank'>freelance programmers ready to do whatever you require. Just set the budget that you like, and in minutes you will receive offers from freelancers.
Regards
_____________________
<a href=http://www.supportuniverse.com>freelance programmers</a> find a programmer starting from $50
Usergroup: Customer
Joined: May 12, 2003
Total Topics: 7
Total Posts: 56
Posted 09/15/04 - 05:04 PM:
#3
I've done a few things like this making insert files for WSNlinks with a little script I wrote in PHP and using a lot of preg_match.
it would have to be a three part process, first extracting the cats and subcats out with a routine, giving each cat and subcat an ID number. Then relating them by cycling through again and matching them up, and finally matching the link table items with the correct catID.
honesty, i think it would be easier to extract a category list then just add those categories in WSNlink normally and record the catIDs then just do the final part of matching the links with the correct category. the cat/subcat ID stuff is could be pretty tedious and I personally would want to go back and do the description and meta tag info anyways, so i would just do it all at once. scripting the cat and subcat info to be inserted wouldn't be out of the question, but there is no reason to reinvent the wheel.
_____________________
Those who say do not know Those who know do not say NewsArray News Directory
Usergroup: Customer
Joined: Sep 12, 2004
Total Topics: 2
Total Posts: 7
Posted 09/15/04 - 07:09 PM:
#4
Hi Din, Suniverse
Thanks for your response...
I think Din, you've really got the problem I'm facing...
I sincerely wish I could just extract a category list and add each one manually through the interface... Unfortunately, I have about 150 category and sub-categories.. and these can change frequently...
Thanks for the lead on supportuniverse.com too, Suniverse... I've made a post in a couple of other places and waiting to hear back..
Hopefully, if the cost is not prohibitive, this may be something I can bring back and share with the folks here..
Looking forward to more responses on how this can be solved...
Usergroup: Customer
Joined: Sep 12, 2004
Total Topics: 2
Total Posts: 7
Posted 09/15/04 - 07:20 PM:
#5
Ok.. I have a couple of questions from developers i'm talking to that I'm hoping this forum can help answer...
Can someone provide me with the field names that are necessary to populate in order to upload links data correctly? There are plenty of fields in both the links and category tables, but i'm assuming not all of them are necessary to upload...
Would appreciate if someone can list out for each table the ones that are needed and the ones that are not.
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5703
Posted 09/16/04 - 01:06 AM:
#6
It would be easist for them to start with the available importer.php, as that way they don't have to worry about the database. All they need to do is get the data out of the data file and assign the values to the objects already in importer.php
You can, however, give them the fields by using phpmyadmin to export the wsnlinks_links and wsnlinks_categories fields.
Usergroup: Customer
Joined: Sep 12, 2004
Total Topics: 2
Total Posts: 7
Posted 09/17/04 - 07:01 AM:
#7
Alright,
Update from my side..
I have found someone who can create an interface to allow import of any text file DB..
There are a number of cool options that will be available in the system for importing.. choice of file delimiter, choice of location of file (ftp, online, or via upload) and mapping of fields as per your choice..
Now.. the cost of developing this is going to be $60.. anyone willing to pitch in? The more who contribute, the cheaper it gets for everyone...
Print
Custom Coding project anyone?