Home : Products : Gossamer Links : Discussions :

Products: Gossamer Links: Discussions: Import problems: L2S2.pm to Links SQL v2.0.5: Edit Log

Here is the list of edits for this post
Import problems: L2S2.pm to Links SQL v2.0.5
Hello Alex!

The seems to be something not working.

I tried to use L2S2 import module to get ASCII to SQL format. For this I installed a default Links v2.01 and it is working correct. No problems.

Giving the defs location of Links v2.01 in the Links SQL 2.0.5 and tring to import couple of categories and couple of links (Default) it has some problems.

It does only one link import per category!!! So if there are more links it generates errors and checking the code, it shows following trouble area.



if ($bad_cats == @cat_ids) { # Between the category and the alternate categories, there has to be at least ONE good one.

if (@cat_ids == 1) {
warning "Invalid category `$cat_ids[0]' for link $$row[0] (ID: $id, line $.). Link skipped";
next LINK;
}
else {
warning "No valid categories ($cat_name @category_alternates) for link $$row[0] (ID: $id, line $.). Link skipped";
next LINK;
}
}

Lets say there is a link in a Category "Europe". It will therefore create one category Europe. Then if there is anathor link in Europe it may work that it gets inserted.

However, the import was broken and I tried to import it again. So without any option clicked, it skipped the categories saying that there are duplicates. But when it came to importing links it did not. Because it tried to create categories from the lines of the links.db and having found it in there, it gives an error.

-------------------------

What I want is that I would like to import from Access or excel format into SQL format. This is only possible through ASCII imports. For this I have Category.db and Links.db. I can also create some more dbs if necessary like email.db, etc to fill in correct information.

I could create the correct defs files for them. Hence it would be no problem to import then if there are some minor changes of L2S2.pm module. Then it can work perfect.

I would very much appriciate if you could help.




Last edited by:

rajani: Nov 26, 2001, 7:17 AM

Edit Log: