Fred Atkinson

Yannick,

I need to be able to export my database into a CSV format that includes only three of the fields in my Link Library database for one particular Link Category.

I tried the export function. There is such an enormous amount of extraneous data that makes it nearly impossible to edit into a usable format [without an extreme amount of work].

I will then need to import the three fields into a separate MySQL database which will be used by a new plugin that will allow other sites to use that data.

In this way, I can use Link Library to manage the data before sharing it.

Can you think of any way that this could be successfully done?

Regards,

Fred

Thanks, Yannick,

Yannick,

I am trying to find that ‘functions.php’ file in link-library.

I checked every subdirectory but didn’t find it.

I want to upgrade to the latest version of Link Library. But I don’t want to lose the sort routine when I do (I believe you said I would have to insert it each time the plugin was updated).

Regards,

Fred

Done.

Maybe.

Yannick,

That got it!

Regards, and thanks,

Fred

An email letting the administrator know it has been received would be good.
Then it should appear in the Moderate tab so it can be edited [if necessary], the category selected, and then the link should be added to the Link Library.
Sound good?
Thanks,

For the sake of discussion, let me explain the sort method I use.
Amateur radio calls consist of a prefix (1 or 2 letters or one letter and a numeral; the prefix identifies the nation in which the station is licensed), the call district (1 numeral) of the nation the station resides in, and the suffix (1 to 3 letters) that uniquely identifies the station.
In an annual publication known as Callbook, the call signs were listed in this order: First by call district, then by suffix, then by prefix.
When I created the Ham Domain database, I wrote a script to sort them in this order.
First, I did it with CGI. Later, I did it with PHP.
I could only accomplish it using a hidden value which I called the ‘sortcode’. It was never displayed. But it was instrumental in getting it in the right order.
When an Amateur Radio Operator looks up a call, it is easiest if they are listed in this order.
I am not a great programmer. But I can usually accomplish it if I give it the amount of time needed. That may be a good deal of time.
I wrote a blurb explaining the dynamics of my sorting method. It was on my old Web site (before WordPress).
I just republished it on the same URL as before. You can now read it at: https://www.wb4aej.com/hamsort .

• This reply was modified 5 years, 2 months ago by Fred Atkinson.
• This reply was modified 5 years, 2 months ago by Fred Atkinson.
• This reply was modified 5 years, 2 months ago by Fred Atkinson.