General Project Guidance

You want to import data, not upload file.

the user will have an .xlsx file, that contains transaction data. they, the users, will/can upload/import that file, as often as they like. will probably only be once per day, but could be several times a day, if they so choose. Some fields, well actually only one field needs to be changed/modified, because the data in the column is a long string of text and I will need to pull out the two pieces of data and delete the rest of the string. I then take that data table and let phpRunner do the rest of it's display work.

Visuals are always helpful, so here is a sample of the import file. import xlsx example file. I will need to import into a db table, clean the data [the data in column D - removing text, pulling out the two values and the transactionID]. The more I am thinking about this, not so sure that phpRunner can handle it, because this process would need to happen each time a user imports the file.

Think, the very best would definitely be to re-discuss this issues with your boss as in deed nothing is easier under PHPRUNNER to create uneditable user account table under "can only see his own entered data" where the interest rate and loan amount are bound together by simple math, here to show the values seen under B (= interest amount), grouped under loanID. In other words, it seems that one is using Excel table and simple formula inside to produce the "interest amount", however, as said, WHY not telling the users to simply drop the Excel sheet in full and to hop over to user account entries and self-calculating fields? The time-stamping would be done by PHPRUNNER automatically and the ONLINE INPUT table for the user would be totally simple anyway. This is a typical clash between "local workstation runners with locally installed software and some skills to handle same" and the online world where your boss wants only to see grouped cumulative tables to finally see a total amount to be somehow informed that the company ship is not sinking, but still cruising within profitable waters. You need to somehow convince your boss that local software doings on most simple issues like this belong to MIDDLE AGES where "bow and arrow" had been used for hunting ..., yet now, in 2017 we talk ONLINE in out by users and real-time online grouped reporting, say, definitely no need to to upload anything at all as the local calculation job currently done by Excel sheet can be easily lifted into the CLOUD, say, the calculation is happening elsewhere in the hosting centre rather than within the local office workstation. And as locally installed software is usually to run in local networks while the web based cloud operations within hosting centres means GLOBAL NETWORK, any hybrid-like combination between local and cloud operations by means of import Excel data on this very totally simple issue practically means to try to win a business race by use of bicycle with no chance to ever reach the goal as first one, simply because the competing PORSCHE car, running cloud fuel, is already making the pace worldwide since some years now, though in one sleepy towns some antics are unwilling to see the realities as seen by now.
https://xlinesoft.com/phprunner/docs/how_to_calculate_values_on_the_fly.htm - For inspiration purpose for interest amount calculation under PHPRUNNER ..., here even "... on the fly ..."

Hi- and thanks for your response, not sure I followed everything, but the calculations and display is all is done -> the beauty of phpRunner. {i manually created the tables as they should appear/work}.

Ok, got this issue working 75% using the import feature in phprunner, still aways to go, but this answered, I think, the big functionality question.

Let me take the liberty to properly explain this: This forum is NOT a support forum and even NOT a "free of charge" biz consulting forum where monetary people, involved in loans, can simply fetch the non-plus-ultra solution just for free. Of course, the PHPRUNNER can make the 100% to work (to get imported) and not just the 75% only as you mentioned. It's a problem of correct configuration and time window. So, to avoid the totally wrong impression, PHPRUNNER owns functionality problems, is, frankly speaking, NOT a "peace of mind" comment of yours and so, pleez don't expect at least from me to present functionality in this forum on a silver table at all. If you and your boss are thinking, they would like to have 100% functionality under PHPRUNNER, then please study your budget and buy SUPPORT at Xlinesoft directly, as per hourly pricing seen under: https://xlinesoft.com/buy_support.htm (very very affordable ..., compared to typical programming fees charged by others) - Thank you for having taken due notice!

The whole Idea of PHPrunner would be to forget about the xlsx spreadsheet and design forms for the users to enter and submit to database . Then you can design reports for the Boss. If you insist on importing , design a xlsx template for your users to import the data . Make sure to teach them how to map the column data or have the correct headers in the first line so they can easily import . That's it . Better to throw out the excel part and just design the whole process in PHPrunner. Hope this helps.

I am not sure at all what you are referring to. And honestly, I don't understand your tone. As stated in my initial question, I wanted assistance with the approachI should use to import a file and adjust the contents of that file once imported. {NOT A SILVER PLATTER}. I have used phprunner for 10+ years and come to the forums for research and occasionally to pose questions when something has stumped me. If you look around the forum, hundreds, if not thousands of people do the same thing. The developers are kind enough to respond when they have time, but that is kind of the point of a forum, so users can help each other. Not sure if you are upset that I figured it out myself, not sure, very strange.