Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Import.pl not getting everything?

Quote Reply
Import.pl not getting everything?
Ok. In my old Links2 db I had 211 categories and 1962 links. I don't believe I have made any mods to v2.

On import I get a lot of errors. After visiting the admin, it appears that I have successfully imported 211 categories, and 955 links. Now that is about 1,000 links short. Here is a piece from the error.txt:
Code:
Error: can't find category id for 'Math/High-School 9-12/Geometry'
Error: can't find category id for 'Social Studies/Primary K-12'
Error: can't find category id for 'Technology/Primary K-2'
Error: can't find category id for 'Technology/Intermediate 3-5'
Error: can't find category id for 'Technology/Middle School 6-8'
Error: can't find category id for 'Seaonal Activities'
Error: can't find category id for 'Seaonal Activities'
Error: can't find category id for 'Seaonal Activities'
Error: can't find category id for 'Seaonal Activities'
Error: can't find category id for 'Writing/6 Trait'
Error: can't find category id for 'Writing/6 Trait/Ideas'
Error: <ul><li>Rating (Invalid format)</ul>
1: 20 5 Short Lessons http://artswire.org/kenroar/lessons/early/early7.html 6-Nov-1999 Visual_Arts/Primary_K-2 Need some fun activities for those things laying around the house...toilet paper rolls, film canisters, bottle caps, etc? Here are some lessons for you! jen teach@seqnet.net 294 No No Yes 0 Yes
Error: <ul><li>Rating (Invalid format)</ul>
2: 21 Primary Color Mixing http://artswire.org/kenroar/lessons/early/early8.html 6-Nov-1999 Visual_Arts/Primary_K-2 Introduce young students to the world of mixing paints in a fun and non-messy way! jen teach@seqnet.net 96 No No No 0 Yes
Error: <ul><li>Rating (Invalid format)</ul>
4: 13 SNIPS http://artswire.org/kenroar/lessons/early/early1.html 6-Nov-1999 Visual_Arts/Primary_K-2 Teach children to cut and construct fun pictures. jen teach@seqnet.net 101 No No Yes 0 Yes
Error: <ul><li>Rating (Invalid format)</ul>
5: 14 Morning Pictures http://artswire.org/kenroar/lessons/early/early2.html 6-Nov-1999 Visual_Arts/Primary_K-2 This lesson introduces children to variety in lines. jen teach@seqnet.net 100 No No Yes 0 Yes
Error: <ul><li>Rating (Invalid format)</ul>
Now this log continues with "Error: <ul><li>Rating (Invalid format)</ul>" for about 1,000 links (the links I am missing?)

2 Questions:
1. If I am getting the Category ID errors, will this cause a problem?
2. How can I get the 'lost' links?

Thanks again for the help!!!

Chad


Quote Reply
Re: Import.pl not getting everything? In reply to
What format is your "Rating" field in for those links?

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Import.pl not getting everything? In reply to
You know, I did try in the past to make an alternate category mod on that database that screwed up the data base (I just now remembered). In the old database, It is placing a 'yes' in the rating field of those particular links. I think I will try to alter that field using a 'find/replace' in a text editor. I'll get back to you.

If I fix the links, Will the categories errors create a problem?

Quote Reply
Re: Import.pl not getting everything? In reply to
>>>If I fix the links, Will the categories errors create a problem?

I dunno... first things first <G>



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Import.pl not getting everything? In reply to
Ok,
The problem was an inconsistency in the data base. I had a 'yes/no' in a '0' field for almost all of the links. I now am able to import all but about 10 links. I will check them later. Ok, now back to the category errors. It appears that they have been imported, so why do I get the ID error? Let me know if you figure it out.

Thanks for the tips! You kicked me, and I got it!

Thanks again,

Chad

Quote Reply
Re: Import.pl not getting everything? In reply to
Can you point me at your site? I have a silly idea, but I'd need to see your site first. It might just be the program didn't want to insert those links. Phase of the moon and all.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Import.pl not getting everything? In reply to
Sorry for the delay, I am at work now.

I have not built the site yet, but the old links is for lessonplansearch.com.

I have a separate directory structure for SQL. I have not built it because I don't want to have to go through and delete it.

Chad