Page 1 of 1

Adding data for searching in a database using Wordpress

Posted: Thu Sep 21, 2017 6:43 pm
by sjuaq
Hello,

I have a wordpress instalation that i would like to modify but i don't know how.

Basicaly is a wordpress instalation that i want to use the internal search engine to query a mySQL or MariaDB database and show results to the user. This database needs a importation of a sql file and an excel formated file. I want to import those 2 databases to the main database from wordpress and make them accessible on the search engine format.

Does it require much work or can it be done instantly?

Thanks for all...

Re: Adding data for searching in a database using Wordpress

Posted: Sat Sep 23, 2017 6:31 pm
by Vegan
excel formatted data is not in the database so using example.com/s="find it" will not catch it

Re: Adding data for searching in a database using Wordpress

Posted: Sun Sep 24, 2017 3:19 pm
by sjuaq
You seem to be an expert on the subject can you provide with a "how to"?

Re: Adding data for searching in a database using Wordpress

Posted: Mon Sep 25, 2017 9:37 am
by sjuaq
My file is in the following format

name:email:ip

How can i import to SQL?
table "wp_posts"

The method that did convert was changing the : to , and then convert with https://sqlizer.io/
But the wp install corrupted.

Any solutions?

Re: Adding data for searching in a database using Wordpress

Posted: Mon Sep 25, 2017 2:31 pm
by Vegan
if you convert the excel data into some table and import it into a table on WP, then the database can find the details.

Excel can also be embedded into a WP article, but the search capability is limited to text with the embedded object

https://linux-guru.azurewebsites.net/ha ... -survival/

at the bottom of the article there are 3 posts with embedded excel charts, linked from a bulleted list

Re: Adding data for searching in a database using Wordpress

Posted: Mon Sep 25, 2017 3:51 pm
by Celauran
sjuaq wrote:My file is in the following format

name:email:ip

How can i import to SQL?
table "wp_posts"
I don't know that you want that data in wp_posts. It's not a WordPress post. Give it a dedicated table.

Re: Adding data for searching in a database using Wordpress

Posted: Tue Sep 26, 2017 2:21 pm
by sjuaq
Adding a new table doesn't reach the scope of the search...