Special Import of GT links

[esm]

Dody

I have attached a stripped down version of the indexu lite version of db_import.

It is designed to import nothing but links from GT Links 2. Categories have already been added.

I haven't tested it yet ( not enough time and I have a meeting to go to for a few hours ). But I wanted you to look at it to see if it has any serious problems.

Assume the fields all line up and would end up in the correct columns of the SQL table. Come to think of it, I'm not sure how it knows to use the idx_link table.

I have added the necessary columns to the table thru the admin center of 3.1 ( and previously imported the links with no problems )

I want to use this since the import for v3.1 does not do several things:

* Does not handle dates for custom fields
* Does not convert Yes/No to 1/0
* Does not "match" data in the GT links file to any corresponding fields in the standard indexu table ( for example, I already have a password field ).

With over 800 links, I need to do something like this.

[dody]

Thank you for your addition. I was not use gt link, but I already tested with my friend data that spidered with Dmoz extractor in gt link 2 format. The data itself contain 10000 links and 1500 categories, it's soccer related web directory.

[esm]

my question is:

will the attached file work???

I already know that I need to add

ShowFormImport();

after the

ConnectDB();

how does it know to use the table idx_link?

[dody]

esm, gt link 2 import will work with data without custom field. Indexu may can't import if the data is different with original data provided by gt link.

If you have custom fields data, you should use csv (tab delimiter) file import. It will work. The data should be correctly ordered like idx_link table structure that is provided in technical notes.

But surely, your hack for gt link import will be a great addition.

[esm]

yes, I know that "gt link 2 import will work with data without custom field"

I have used it and it does import the GT links. I have been able to browse thru my imported links.

BUT...

I want to use the attached file since the "gt link 2 import" for v3.1 does not do several things:

* Does not handle dates for custom fields
* Does not convert Yes/No to 1/0
* Does not "match" data in the GT links file to any corresponding fields in the standard indexu table ( for example, I already have a password field ).

BUT THE ATTACHED FILE HAS ERRORS. CAN YOU HELP ME WITH THE ERRORS. To see the errors, run it yourself.

It uses the db_import_form.html file from the lite version.