Hello Alex!

I have a problem to understand you. I do have few more cloums which are not a part of the Default Links Database. Thats not a problem to create few new fields in a table. I can ofcourse send to you first ten lines. But thats not the solution.

Lets take a default Links Database. Even just for a test, I am not able to import and export it correctly. For e.g.

The Category are names in my database. Once it gets into MySQL, it will not come out as names back in the export. Also how do I get also the alternate categories in to the correct place. Further how do I get the Alternate category + Category information back into one table, as I cannot have two tables like in links inside MySQL. I can ofcourse have but its better to have one line that is having a unique identifier with Category + Alternate category information togather.

For e.g. lets take a default database from links v2.0, but with Category Names & Alternate Category names instead of their IDS. The Add/Mod_date is in DateTime format. Thats all. Thats my database then. It has more colums but if other columns can go through an array, the remaining will also get in and that should not be a problem. The biggest problem is that :

1-How to get Names in to IDs &get_category_id

2-Get an id into the respective Alternate Category table.

3-Change DateTime format to Time format during import.

4-After import those lines should be deleted so that one knows what went in and whats left to be deleted or what category is not there, etc

How to export for daily offline work:

5-The category IDs should be changed back to names for Category + & Alternate Cat.

6-The tables should be merged to one so that handling is easy. This means that Alternate Category table could be merged togather with the main Links Table. By doing so one does not misplace or loose the information related to it.



Therefore as you see, I have special columns, but what I need is the logic and function as to how the program will work. Honestly I can play a lot with Access and change many things and prepare for the import export. The limitations are datetimeformat and ID<>Names. If both this are programmed then anyone can do exports imports daily without any problems.

Moreover one can also export Validate table and then import it back to Validate of Links.

So a if serious thought is given on this area that will make a script really favorite of webmasters. For e.g. while exporting, one clicks - Delete after export-file of delete line from txt after import, or delete Old data from the table before import etc.

Delete from file during export/import
Delete from table data during export/import

Change to Category names during export/import

Change to Category IDs during export/import.

Change to Date do DateTime and viseversa during export/import

Enter a default value in a field number
during export/import.

Therefore when a link comes out with deletion from the old table forever, there would be no indication of that link in Hits or Votes. This means a Link is complete installed in a database and also completely de-installed from the database.

One can install a link it directly from web into the database or through import/export. This feature is missing. If this was there, I should have had no problem. This would make the life of everybody easier, atleast who are concious of their telephone bills or costs of internet provider sensitive prices.

I know Alex, once you take this in hand this area will be fully developed into its excellence that no one would have to say anything anymore.

------------------
rajani