Hi,
I am writing a dashboard that pulls data from Sage along from other software packages used within our business.
I note that with the Office365 integration of Sage 50 Cloud, once enabled it dumps some xlsx files in a O365 group (see https://ask.sage.co.uk/scripts/ask.cfg/php.exe/enduser/std_adp.php?p_faqid=35334)
My current process includes copying these files into an Azure storage account, and then importing into a SQL Azure database. The extract to azure storage is working, and now i'm working on the import to SQL. the proof of concept works, however i notice that the files change in size and contents regularly?
What is the process that Sage 50 C uses to update these? Looking at the version history, these file sizes change considerably, without a pattern.
If the files were consistent each time, i'd just drop the tables in the database and reimport. However, its not every friday, or not ever time, which makes it difficult to tune my process logic.
See an example of the version history of transaction.xlsx here.
Can anyone explain the logic here? Would be intrigued to hear what others have.
For note - the Sage Dashboard \ Sage Intelligence dont have the functionality we desire. We are planning on linking data from sage against our Job Management System . For a basic example, to understand if an invoice has been paid against a project, so the team can either proceed with the work or wait. Just one of many requirements.
thanks,