Jan-31-2019, 03:13 PM
The software i need to extra data from is called OpenAccounts, it's a database program for payment procurement services that holds payment records and supplier information. Despite it being a database program, it doesn't offer any reasonable way to export the data i need to collect.
When i say what i need is compicated, i mean i need the script to analyse a cell in an excel table row, then search for that value in a column in openAccounts, open that search result, use the value in the next excel cell to do another search and open and so on until it gets to the last window where it then extracts the value i've pointed it at into the excel row it's been reading from, and then doing the exact same process with the next row, and so on until all the rows have been completed.
-"i have very limited theory knowledge"-
-"need above before commenting2
Im not sure what you mean by this. If you mean i should not have posted in this forum as such a beginner then i would be welcome to any suggestions on where else i should ask this question, as i haven't been able to find a beginner friendly programming forum myself.
Lastly, I don't beleive this belongs in the "Jobs" section as the decription is "Post here if you are recruiting Python programmers, or are a Python programmer looking for work." and i am not after either of these.
Thank you for your reply
When i say what i need is compicated, i mean i need the script to analyse a cell in an excel table row, then search for that value in a column in openAccounts, open that search result, use the value in the next excel cell to do another search and open and so on until it gets to the last window where it then extracts the value i've pointed it at into the excel row it's been reading from, and then doing the exact same process with the next row, and so on until all the rows have been completed.
-"i have very limited theory knowledge"-
-"need above before commenting2
Im not sure what you mean by this. If you mean i should not have posted in this forum as such a beginner then i would be welcome to any suggestions on where else i should ask this question, as i haven't been able to find a beginner friendly programming forum myself.
Lastly, I don't beleive this belongs in the "Jobs" section as the decription is "Post here if you are recruiting Python programmers, or are a Python programmer looking for work." and i am not after either of these.
Thank you for your reply