I need better access to the relationship between records

Question asked by Nicholas Meanley 8 years ago

Dear Support,

I need to do some heavy processing on the accounts data and I would rather not have to scrape all the data from the html so would it be possible to get a csv file of the payment table and the transaction table that the payment_id and the transaction_id in the invoice elude to.

There was a function to download the transactions but this seems to have disappeared from the export page.

Alternatively if you could send me a database dump I could work from that.

Nick

3 Replies

Time
Likes

John Fouracre

Staff

1749 entries

Hi Nicholas,

We do not have a payments report in the system - if you raise this as a ticket we can escalate to the technical team as a request to export the payments table from your database.

https://www.clearbooks.co.uk/support/guides/getting-started-2/new-navigation-raise-support-ticket-within-clear-books/

8 years ago

Nicholas Meanley

8 entries

The export screen does have a secret transaction report that you can download as a csv you just have to add a new option to the drop down list of TRANSACTIONS its more the payments table that I need.

8 years ago

Paul Scholes

Accountant

1127 entries

Hi Nicholas - not sure if this is what you mean but the Transactions download is done from the Transactions report screen, rather than the export screen (which has a similar general ledger export).

8 years ago

I need better access to the relationship between records

3 Replies

Reply to this question

Find out what we do and who we are

Apps

Company

Social