Okay
  Public Ticket #2179922
Functionality question
Open

Comments

  • Luka started the conversation

    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

  •  341
    Aleksandar replied

    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:

    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:

    http://www.google.com/ || Google

    And it'd show like this: Google.

    Another way would be to have the column set to string, and define values with HTML tags:

    <a href="www.google.com">Google</a>

    There are a few options, but it should be easily doable.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin

    Kind Regards, 
    Aleksandar Vukovic
    aleksandar.vukovic@tms-outsource.com

  • Luka replied

    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?

  •  341
    Aleksandar replied

    :) 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.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin

    Kind Regards, 
    Aleksandar Vukovic
    aleksandar.vukovic@tms-outsource.com

  • Luka replied

    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...

    Migration in Europe - Statistics and Facts | Statista

    HOW THE WORLD VIEWS MIGRATION.BASIC INFO

    Data and research: Data sources

    International Migration Statistics | migrationpolicy.org

    Migration. Pew Global

    Map: Immigrant and Emigrant Populations by Country of Origin and Destination

    Map: Net Number of Migrants by Country, 1950-2015 (by Five-Year Intervals)

    Migration Law Database

    Reports and resolutions revolving around such issues as migrants’ rights, humanitarian assistance, development, security and policy, among others

    Attitudes towards immigration in an ageing society: Demographic evidence from Japan

    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!

  •  341
    Aleksandar replied

    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.

    Srdačan pozdrav.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin

    Kind Regards, 
    Aleksandar Vukovic
    aleksandar.vukovic@tms-outsource.com

  • Luka replied

    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.

  •  341
    Aleksandar replied

    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.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin

    Kind Regards, 
    Aleksandar Vukovic
    aleksandar.vukovic@tms-outsource.com