I am having the following problem while importing vouchers data through XML from Tally Prime 6.2: I am importing data out of tally Prime for use with my application "TXX". As part of new customer onboarding purpose, I am downloading the entire data till date from Tally, to provision the new user in my application. In order to Sync his data in my application database, I want to subsequently download his incremental business data in Tally as new data is introduced by the user into his Tally depending on his day to day business.
The problem with this approach is, If the customer happens to make a new entry on a previous date (for which data is already downloaded from Tally), or he edits and changes an existing entry in his Tally from a previous date, or delete an entry. With the current logic, and implementation, there is no way my application can get to know of these kind of changes made on the present day, for a previous transaction date.
In order to overcome this, at present, we used a combination of doing a full data import from Tally:
1. Calculate the highest AlterID among the records (from the first data extracted from Tally as part of the initial introduction of the customer)outside of Tally using Python. Call it MaxAltID.
2. As a part of incremental backups from his Tally Database to our Talking Totals database (after x number of days), we do a second export from Tally in which we ask for GUID and ALtID pair along with our query for all records.
3. From this second exported data from Tally, based on earlier computed MaxAltID, we identified the records where AlterID has changed (> MaxAltID)for the same GUID.
4. Records which have the SAME GUID from the First Extract but a Different AlterID, are the changed (edited) records.
This is network intensive as we are downloading the entire records again to identify the changed records.
What I am trying to do now, is to Ask Tally to do the filtering in Tally Itself , based on filtering condition for records with changed AlterID. This is not working.
In fact, I am finding that Tally Prime does not respond to any filtering criteria other than date duration.
Has any one tried applying any filtering condition for Tally data export through XML, other than From and TO dates? (which does not guarantee export of edited records that has a date outside of the period mentioned in the query)
OR, does tally maintain any variable to identiy edited records? I have tried AlterID, and it does not work for filtering on server side.