Gossamer Forum: Products: Gossamer Links: Discussions: Import data Links 2.0 into Links sql

Novice (25 posts)

Feb 2, 2004, 1:51 AM

Post #1 of 17

Shortcut

Import data Links 2.0 into Links sql

Tried to import my links 2.0 text-database into Links SQL. It fails on the date format. In my links 2.0 database all dates are d-m-yyy and links sql expects yyyy-mm-dd.

What can I do to import my 'old' database.

Feb 2, 2004, 1:56 AM

Veteran / Moderator (18441 posts)

Feb 2, 2004, 1:56 AM

Post #2 of 17

Shortcut

Re: [Frest] Import data Links 2.0 into Links sql In reply to

How many links do you have in your Links2 database? That will decide if you need to run a script to update these dates, or if it will be easier to edit your .db file manually :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Feb 2, 2004, 2:14 AM

User (200 posts)

Feb 2, 2004, 2:14 AM

Post #3 of 17

Shortcut

Re: [Frest] Import data Links 2.0 into Links sql In reply to

I've had the same problem and change
something in gossamers import script:

L2S2.pm in folder /cgi-bin/admin/links/import

You have to change something behind line 791
(Backup the original pm before you code it)

Best regards from
Bremen/Germany

Lothar

Feb 2, 2004, 2:38 AM

Novice (25 posts)

Feb 2, 2004, 2:38 AM

Post #4 of 17

Shortcut

Re: [eljot] Import data Links 2.0 into Links sql In reply to

Thanks Andy,

There are 1125 links in the database. And I already changed them 'by hand'. Well, I changed them in MS Access and gave them the format yyyy-mm-dd(text). But again I got this message:
======================
Import error: WARNING: Invalid date `2004-01-01' encountered.
Import error: WARNING: Invalid date for link with ID 133. Link skipped.
=======================

So I think something is very wrong...

And thanks Lothar. I've read another thread in this forum about that solution(?). But now I tried it in my own way, I'm not sure what to do.

Is there a way to just skip the import of the date? I don't really need them.

Feb 2, 2004, 3:09 AM

Veteran / Moderator (18441 posts)

Feb 2, 2004, 3:09 AM

Post #5 of 17

Shortcut

Re: [Frest] Import data Links 2.0 into Links sql In reply to

Hi, in admin/Links/Import/L2S2.pm , on about line 800, find;

Code:
    if ($year and $months{$mon} and $day) { 
        return sprintf("%04d-$months{$mon}-%02d", $year, $day); 
    } else { 
        warning "Invalid date `$in' encountered."; 
        return; 
    }

... and change to;

Code:
    if ($year and $months{$mon} and $day) { 
        return sprintf("%04d-$months{$mon}-%02d", $year, $day); 
    } else { 
        #warning "Invalid date `$in' encountered. Setting to 2004-10-10"; 
        return '2004-10-10'; 
    }

Make sure you have a backup before you make this change.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Feb 2, 2004, 4:59 AM

Novice (25 posts)

Feb 2, 2004, 4:59 AM

Post #6 of 17

Shortcut

Re: [Andy] Import data Links 2.0 into Links sql In reply to

Doesn't work Andy.

===========================
Import error: WARNING: Invalid date for link with ID 1. Link skipped.
===========================

Frown

Feb 2, 2004, 6:31 AM

Veteran / Moderator (18441 posts)

Feb 2, 2004, 6:31 AM

Post #7 of 17

Shortcut

Re: [Frest] Import data Links 2.0 into Links sql In reply to

Odd. What do you have set in Setup > Date ???

Cheers

Andy (mod)
andy@ultranerds.co.uk

Feb 2, 2004, 6:47 AM

Novice (25 posts)

Feb 2, 2004, 6:47 AM

Post #8 of 17

Shortcut

Re: [Andy] Import data Links 2.0 into Links sql In reply to

In Setup|Date >> %yyyy%-%mm%-%dd% (date_db_format). This is the default setting.

Feb 2, 2004, 6:53 AM

Veteran / Moderator (18441 posts)

Feb 2, 2004, 6:53 AM

Post #9 of 17

Shortcut

Re: [Frest] Import data Links 2.0 into Links sql In reply to

Are you definate you commented this line out?

Code:
warning "Invalid date `$in' encountered.";

???

Cheers

Andy (mod)
andy@ultranerds.co.uk

Feb 2, 2004, 6:56 AM

Novice (25 posts)

Feb 2, 2004, 6:56 AM

Post #10 of 17

Shortcut

Re: [Andy] Import data Links 2.0 into Links sql In reply to

Yes,

I did a 'copy - paste' Smile

Feb 2, 2004, 7:01 AM

Veteran / Moderator (18441 posts)

Feb 2, 2004, 7:01 AM

Post #11 of 17

Shortcut

Re: [Frest] Import data Links 2.0 into Links sql In reply to

Afraid I'm stumped then :(

Cheers

Andy (mod)
andy@ultranerds.co.uk

Feb 2, 2004, 7:08 AM

Novice (25 posts)

Feb 2, 2004, 7:08 AM

Post #12 of 17

Shortcut

Re: [Andy] Import data Links 2.0 into Links sql In reply to

Ok Andy,

Thanks anyway. I did a lot of hacking in this database. I probably made some stupid mistake somewhere.

I'm now planning to retype the lot. Unsure

Feb 2, 2004, 2:10 PM

User (200 posts)

Feb 2, 2004, 2:10 PM

Post #13 of 17

Shortcut

Re: [Frest] Import data Links 2.0 into Links sql In reply to

Do you have the original fields in links sql or do you change something,
add new fields or change the order?

Do you use May, Oct, Dec or Mai, Okt, Dez?

What else is different to normal Links 2 installation?

Do you have activated debug_level with 1 in admin section of Links Sql?

Which Links sql version do you use, english?

Best regards from
Bremen/Germany

Lothar

Feb 3, 2004, 12:09 AM

Novice (25 posts)

Feb 3, 2004, 12:09 AM

Post #14 of 17

Shortcut

Re: [eljot] Import data Links 2.0 into Links sql In reply to

Hi Lothar,

I changed all the fields in de Setup|Date and translated them to Dutch (mei, jun,dec). I use the Englishe version of Links SQL and I did not activate the debug_mode. I did not change the field date_db_format!

I did not change much in the Links 2 installation. I added some fields to the links-table.
What I did with the database was: I imported it in a MS Access database; fooled around with it and exported it back again (as text).

In the mean time I have tried every thinkable date-format and nothing worked. Next try is a direct import trough phpMyAdmin.

greetings from
Den Bommel/the Netherlands

Fred.

Feb 3, 2004, 12:31 AM

User (200 posts)

Feb 3, 2004, 12:31 AM

Post #15 of 17

Shortcut

Re: [Frest] Import data Links 2.0 into Links sql In reply to

In Reply To:

I changed all the fields in de Setup|Date and translated them to Dutch (mei, jun,dec). I use the Englishe version of Links SQL and I did not activate the debug_mode. I did not change the field date_db_format!

# $months{Okt} = "10";
# $months{Mai} = "05";
# $months{Dez} = "12";

You must change the language for each month which is in short form not
the same in dutch and english by the example above

Possible that you get more information when you activate the debug mode.

Best regards from
Bremen/Germany

Lothar

Feb 3, 2004, 12:42 AM

Novice (25 posts)

Feb 3, 2004, 12:42 AM

Post #16 of 17

Shortcut

Re: [eljot] Import data Links 2.0 into Links sql In reply to

I changed all dateformats and that part is working fine. But why do you think this formatting has something to do with the importing-problems I have?

Changing the debug mode don't give me extra information. Unsure

Feb 3, 2004, 1:17 AM