Calculation of Numeric Data At Import

  • Resolved jaynm26

    (@jaynm26)


    11 years, 2 months ago

    Hello, first I would like to say I appreciate your work and the plugin you developed whether I decide to use it or not I think its awesome just from what I read in description.
    I have one unorthodox question to ask (our current database does this but looking for alternative). First does the plugin allow you to UPDATE data by way of import of CSV?

    If so can the data that is being imported be calculated by the data that is already present inside the database?

    Ex.
    – I have a numeric data field and in record a I am displaying numerial “1”.
    – Next I import new data and the numeric field I am importing is a number 2.
    – As the value in the database is #1 (old data) and the value of the (new data) #2 the new
    value “for that particular field” would be updated (calculated) and shown as a total of 3.

    So in process when the new data is imported the vaule of that numeric field being a 2 the updated record in the database would calculate 2+1=3.
    So once new data is imported with the old it calcualtes then updates as the new record summed with the old.

    https://www.ads-software.com/plugins/participants-database/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Yes, it’s possible. First, you can update the database via CSV. Then to do something like you suggest, you can use a filter to process the values as they come in. You can attach a callback to a filter called “pdb-csv_import_value ” that passes each value in as they are imported.

    Check out the plugin API page.

    Thread Starter jaynm26

    (@jaynm26)

    Thanks for the reply and thanks for the information. I am glad your plugin can do this.

    Thread Starter jaynm26

    (@jaynm26)

    I read over the API and saw the description for “pdb-csv_import…”. First thing im going to do is download the plugin and use it. We have some simple tables I have to create for some other things we need to display. So as I use it and get familiar with it I will see how we can best implement the plugin for our major database. Hopefully I can send you a link to our current database soon once our website is up just so you can get a visual.

    – Images
    Also what about uploading images? Say we have 20 profiles of data from individuals we wanted to display. Each profile we wanted to display the same image in each profile with your plugin. These 20 profiles required all the same image to be uploaded and displayed within their profile in the database is this possible?

    – Example
    You know what here is one example I wasn’t even thinking bout it till now. This is one example of database I am speaking of but our is much, much more simple. https://gamebattles.majorleaguegaming.com/xbox360/call-of-duty-black-ops/ladder/team/standings

    – What we need based off the example
    The only functionality we would need from this example would be the ability to click on a name (that’s a link) to view an individuals profile as pop up in a lightbox style format, and the ability to display an image beside their name everything else in the example link will not be needed.

    – Thank you
    Also I appreciate everything you are doing the support, the plugin the information, and any chance we get to donate or hire you we will. I have a strong feeling we might need to. Thank you

    Plugin Author xnau webdesign

    (@xnau)

    Of course you can upload images for individual records, but if you want the same for all of them, you might want to check the “default image” feature under the general settings tab.

    Thread Starter jaynm26

    (@jaynm26)

    Resolved

    Thread Starter jaynm26

    (@jaynm26)

    Hello how are you Im back. I made this post “UN-resolved” so you could go back over what we discussed. How much in donation would you inquire to set up your plugin so I can import data and it be calculated like discussed above?

    Basically allow me to import data and have the old data calculated called with the new data?

    Plugin Author xnau webdesign

    (@xnau)

    I might not be able to work on it right away, but you can contact me with the details by email and I’ll give you an idea of the cost.

    support at xnau.com

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Calculation of Numeric Data At Import’ is closed to new replies.