Just wanna check would the plugin work for me in this case.
There is a WP website I'm involved into, it's a scholarly database of thousands of links(hyperlink inserted into title/text) and for now those links are divided in couple of pdf docs which is not the best solution.
I want to incorporate them somehow in the site it self and make a searchable database out of it.
By searchable I mean when someone is looking for xyz term, all links within the table having xyz(in the link title) should show up.
From what I've seen on your website, it should be doable. I would need to get the whole thing in csv or excel format, import it and adjust everything within plugin's settings.
What you're looking to achieve should be easily doable with wpDataTables.
First thing to note, though, is that the database consists of thousands of links - which means thousands of rows.
If you wish to import CSV or Excel file, that isn't an issue. Once the import is complete, the table will be saved in the database, and it will have nothing else to do with the original file it was created from. You'll be able to modify it, edit it, style it, and so on.
However, if you choose to link to an existing Excel or CSV file, it wouldn't work so well, simply because these methods of creating tables work well up to a certain row number (no exact limit, but around 2.000 - 3.000). Also, tables created by linking to existing data source are not editable.
You're also mentioning that it is saved in the database. If all this is saved in one table in the database, you can simply create a table showing SQL query data and pull it using a simple query like:
SELECT * FROM my_table
To save the data as hyperlinks in wpDataTables, you'll need to prepare the source to have the correct data in cells. If you set the column type to be URL Link, the data in cell will have to contain the full URL which includes http:// or https:// before the actual address. And if you wish to hide it behind a text, you'll need to add the "two sticks" after the URL. For example:
If I got it right, I would need to transfer it from word to excel, upload excel file, customize it and that's it, right?
How does it work with search? For example, using the link above, if someone types in "globalization" then all of those links/titles where globalization is found would appear?
Where are you from? We can continue in Serbian/Croatian/Bosnian, any of Ex-YU languages, if that's easier for you.
I'm not sure I understand, though. This file is a long word file, and if you export it into Excel, it isn't going to look good. If you have a list of all available files in Word, then you could export it into Excel, create a table list so every row contains a link to an actual Word file - that'd work fine.
Search will look for what's currently displayed on the page, so yeah - "globalization" will come up in search with all instances found in the table.
Napravio bi 10tak excel dokumenata(na temelju kategorija, tipa demografija i migracije, metodologija globalnih migracija itd.) i svaki bi bio jedna tablica na sajtu. Korisnici bi odabrali kategoriju koja ih zanima i upisali npr."number of migrants" i search bi izbacio sve linkove u kojima se fraza spominje u toj tablici.
Ako smo se dobro razumili, cini mi se da bi to islo bez problema :D
Nije problem, Luka. Firma je u Beogradu, tako da i nadređeni razumeju ako nastavimo ovako.
Ovo izgleda super i verujem da bismo mogli da napravimo funkcionalnu tabelu sa ovim podacima.
Ima nekih limitacija što se tiče importovanja iz Excel-a, kao što sam možda već pominjao.
U Excel fajlu to treba da izgleda ovako:
https://www.statista.com/topics/4046/migration-in-europe/ || Migration in Europe - Statistics and Facts | Statista
http://publications.iom.int/system/files/how_the_world_gallup.pdf || HOW THE WORLD VIEWS MIGRATION.BASIC INFO
http://www.globalmigrationgroup.org/content/data-and-research-data-sources || Data and research: Data sources
da bi se podaci uvezli u wpDataTables pravilno i da bismo mogli da koristimo URL Link kolone.
Ili, sa HTML tagovima:
<a href="https://www.statista.com/topics/4046/migration-in-europe/">Migration in Europe - Statistics and Facts | Statista</a>
<a href="http://publications.iom.int/system/files/how_the_world_gallup.pdf">HOW THE WORLD VIEWS MIGRATION.BASIC INFO</a>
<a href="http://www.globalmigrationgroup.org/content/data-and-research-data-sources">Data and research: Data sources</a>
U tom slučaju bismo mogli da koristimo standardne string kolone.
U svakom slučaju, imamo garanciju na povrat sredstava u roku od 15 dana od datuma kupovine, tako da ukoliko vam ne odgovara plugin, možete podneti zahtev za refundaciju u roku od tih 15 dana.
Mi ćemo se svakako potruditi da pomognemo koliko god možemo ukoliko imate nekih pitanja ili problema.
Hi,
Just wanna check would the plugin work for me in this case.
There is a WP website I'm involved into, it's a scholarly database of thousands of links(hyperlink inserted into title/text) and for now those links are divided in couple of pdf docs which is not the best solution.
I want to incorporate them somehow in the site it self and make a searchable database out of it.
By searchable I mean when someone is looking for xyz term, all links within the table having xyz(in the link title) should show up.
From what I've seen on your website, it should be doable. I would need to get the whole thing in csv or excel format, import it and adjust everything within plugin's settings.
Am I missing anything? Would it work like that?
Thanks,
Luka
Hello Luka.
Thank you for your interest in our plugin.
What you're looking to achieve should be easily doable with wpDataTables.
First thing to note, though, is that the database consists of thousands of links - which means thousands of rows.
If you wish to import CSV or Excel file, that isn't an issue. Once the import is complete, the table will be saved in the database, and it will have nothing else to do with the original file it was created from. You'll be able to modify it, edit it, style it, and so on.
However, if you choose to link to an existing Excel or CSV file, it wouldn't work so well, simply because these methods of creating tables work well up to a certain row number (no exact limit, but around 2.000 - 3.000). Also, tables created by linking to existing data source are not editable.
You're also mentioning that it is saved in the database. If all this is saved in one table in the database, you can simply create a table showing SQL query data and pull it using a simple query like:
To save the data as hyperlinks in wpDataTables, you'll need to prepare the source to have the correct data in cells. If you set the column type to be URL Link, the data in cell will have to contain the full URL which includes http:// or https:// before the actual address. And if you wish to hide it behind a text, you'll need to add the "two sticks" after the URL. For example:
And it'd show like this: Google.
Another way would be to have the column set to string, and define values with HTML tags:
There are a few options, but it should be easily doable.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hvala!:-P)
Anyway, I have the links in word docs and the actual format of the links is, for example;
Chapter 1 | Cosmopolitanism in the Age of Globalization ,so the full hyperlink is already inserted into it.
If I got it right, I would need to transfer it from word to excel, upload excel file, customize it and that's it, right?
How does it work with search? For example, using the link above, if someone types in "globalization" then all of those links/titles where globalization is found would appear?
:) Nema na cemu
Where are you from? We can continue in Serbian/Croatian/Bosnian, any of Ex-YU languages, if that's easier for you.
I'm not sure I understand, though. This file is a long word file, and if you export it into Excel, it isn't going to look good. If you have a list of all available files in Word, then you could export it into Excel, create a table list so every row contains a link to an actual Word file - that'd work fine.
Search will look for what's currently displayed on the page, so yeah - "globalization" will come up in search with all instances found in the table.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hrvatska. Svejedno mi je. Ali ako tebi nije problem zbog nadredenih, batalimo engleski.
Kada se eksportira u excel, svaki link je u jednoj celiji, tj. redu tako da mislim da bi trebalo biti ok.
Eto primjer, kako to izgleda u wordu...
v Migration in Europe - Statistics and Facts | Statista
v HOW THE WORLD VIEWS MIGRATION.BASIC INFO
v Data and research: Data sources
v International Migration Statistics | migrationpolicy.org
v Migration. Pew Global
v Map: Immigrant and Emigrant Populations by Country of Origin and Destination
v Map: Net Number of Migrants by Country, 1950-2015 (by Five-Year Intervals)
v Migration Law Database
v Reports and resolutions revolving around such issues as migrants’ rights, humanitarian assistance, development, security and policy, among others
v Attitudes towards immigration in an ageing society: Demographic evidence from Japan
v Migration - OECD - OECD.org
Napravio bi 10tak excel dokumenata(na temelju kategorija, tipa demografija i migracije, metodologija globalnih migracija itd.) i svaki bi bio jedna tablica na sajtu. Korisnici bi odabrali kategoriju koja ih zanima i upisali npr."number of migrants" i search bi izbacio sve linkove u kojima se fraza spominje u toj tablici.
Ako smo se dobro razumili, cini mi se da bi to islo bez problema :D
Pozz!
Nije problem, Luka. Firma je u Beogradu, tako da i nadređeni razumeju ako nastavimo ovako.
Ovo izgleda super i verujem da bismo mogli da napravimo funkcionalnu tabelu sa ovim podacima.
Ima nekih limitacija što se tiče importovanja iz Excel-a, kao što sam možda već pominjao.
U Excel fajlu to treba da izgleda ovako:
da bi se podaci uvezli u wpDataTables pravilno i da bismo mogli da koristimo URL Link kolone.
Ili, sa HTML tagovima:
U tom slučaju bismo mogli da koristimo standardne string kolone.
U svakom slučaju, imamo garanciju na povrat sredstava u roku od 15 dana od datuma kupovine, tako da ukoliko vam ne odgovara plugin, možete podneti zahtev za refundaciju u roku od tih 15 dana.
Mi ćemo se svakako potruditi da pomognemo koliko god možemo ukoliko imate nekih pitanja ili problema.
Srdačan pozdrav.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Aleksandre,
Puno hvala na podrsci! Imam rok za vratom pa mi vrag nije dao mira i preko vikenda sam nasao drugo reijesenje, upravo implementiram.
Hvala jos jednom.
Nikakav problem Luka.
Ako vam ikada zatreba wpDataTables za neki drugi projekat, ili ako zelite da pređete na naš plugin - tu smo.
Srdačan pozdrav.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables