Keyword Linking by Siropu [Paid] 1.7.1

[Hoolio]

There is a XML file import function. I have attached two files so you can see the expected format.

View attachment 323622

Many thanks for the two XML file examples

But for a non tech savvy person here (!) - how do we convert a csv file of all product names (replacements) + all their aliases (keywords) and URL's to turn it into that format of XML file you kindly provided?

Any tips?

Thank you!

 

[philmckrackon]

That is going to be tough. About the only way I can come up with is write a custom VB macro inside of Excel or equivalent to do this or import the csv file into Excel and do a conversation one column at a time.
Do you have an example file you can attach?

 

[Hoolio]

Tasked my dev(s) to figure it out at the start of this week. Let me check how they are getting on. Will get back to you. Big thanks...

 

[philmckrackon]

Tasked my dev(s) to figure it out at the start of this week. Let me check how they are getting on. Will get back to you. Big thanks...

Can you attach a file any way? Id like to see if I can help. I'm bored and retired.

 

[Hoolio]

You are the best!!!

Actually, the devs have to figure out how to get the info out of the system they built first!! I really appreciate your offer!!!

 

[philmckrackon]

You are the best!!!

Actually, the devs have to figure out how to get the info out of the system they built first!! I really appreciate your offer!!!

Thanks for the compliment.
They should easily be able to do a simple table dump to a SQL file. Then write a little code (or I can do it) to put it in the format necessary to import.
Here is an example table dump to a SQL file (I do not have thousands of links but the pretense is the same - your SQL dump will differ because your dump is VB). I used phpMyAdmin but depending on your OS the way to dump the table may be different (what is your OS and do you just have SSH access or something like WHM, cPanel or Plex). See the attachment.
BTW, I migrated from VB 3.8 so I understand what a PITA it can be. There were no VB addon imports that worked for me for my VB addons. I had to do almost everything manually.

 

[philmckrackon]

@Hoolio FYI, out of curiosity I used ChatGPT and converted a SQL dump to an XML import file. Just had to be very specific with my work scope.

 

[Hoolio]

Ha! Great tip. Thank you.

 

[Hoolio]

On the VB site I am migrating from we underline keyword (links) rather than use a different color
Is that possible to have Keywords underlined @Siropu / anyone?
(or is that a bad thing to implement…?)

Underlined seems more "link-y" to me, just sayn..

Thanks very much

 

[Chromaniac]

there is a Default keyword settings in addon setting where you can define inline css or a class which you can style as you like! I also use it to underline the links.

 

[tajhay]

On the VB site I am migrating from we underline keyword (links) rather than use a different color
Is that possible to have Keywords underlined @Siropu / anyone?
(or is that a bad thing to implement…?)

Underlined seems more "link-y" to me, just sayn..

Thanks very much

Did you read the resource desicription or look at the resource screenshots? Yet it can via css assigned pee kerword linking rexord.

 

[philmckrackon]

On the VB site I am migrating from we underline keyword (links) rather than use a different color
Is that possible to have Keywords underlined @Siropu / anyone?
(or is that a bad thing to implement…?)

Underlined seems more "link-y" to me, just sayn..

Thanks very much

there is a Default keyword settings in addon setting where you can define inline css or a class which you can style as you like! I also use it to underline the links.

Yes, as stated in the above posts, you can add any custom CSS

 

[Hoolio]

Thanks all.

 

[Hoolio]

Many questions!`

1) Are there any power user tips, say for a large community? (1.5 million threads) to avoid server load / page speed issues etc. Perhaps there is nothing to worry about...

2) If keywords are linking internally is there a best strategy for making them no follow?
and
3) If keywords are linking externally is there a best strategy for making them no follow?

4) Via XML import we have just added 30,000+ items, each with several keywords each so let's call that approx 150,000 keywords(!) Is there a bulk processing method for getting them all active quickly? Or do we have to wait while the system gradually crunches through them all?

5) Can anyone link me to an example of a font awesome put to use using Keyword Linking?

6) We have noticed that Ad Manager 2 also has keyword linking functionality would we be crazyto use that instead of Keyword Linking? (150,000 keywords) Because we like the stats / most viewed / most clicked data reports. @Siropu ?

Thank you!

 

[Siropu]

Are there any power user tips, say for a large community?

Use "Enable keyword caching" admin option if you have many keywords.

2) If keywords are linking internally is there a best strategy for making them no follow?
and
3) If keywords are linking externally is there a best strategy for making them no follow?

Each keyword has a setting to choose the rel attribute:

• Nofollow
• Sponsored
• UGC
• Custom

Is there a bulk processing method for getting them all active quickly?

You can run the rebuild cache options under Tools > Rebuild caches
Else, the cache system will get updated when a thread is accessed for each thread individually.

6) We have noticed that Ad Manager 2 also has keyword linking functionality would we be crazyto use that instead of Keyword Linking?

Yes since It doesn't use caching and will crash your board with that many keywords.