Welcome To T24All
Welcome, Guest
Username Password:

After authorise any txn then export it to excel
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: After authorise any txn then export it to excel

After authorise any txn then export it to excel 1 month ago #10145

  • kda
  • OFFLINE
  • Gold Boarder
  • Posts: 296
  • Karma: 0
Dear all,

In T24, if we want to book any contract and we define fields we want to export after authorised will export to excel.

could you pls guide me to do that.

Thank in advance

Re: After authorise any txn then export it to excel 3 weeks, 5 days ago #10220

Hi,

I suggest you that in an authorization routinre just form a string in predefined format and write that in to a particualr destination with with flle name preceded with .xls. from there you can FTP the same.


Hope it may help.

Re: After authorise any txn then export it to excel 3 weeks, 4 days ago #10227

  • kda
  • OFFLINE
  • Gold Boarder
  • Posts: 296
  • Karma: 0
Hi, usually we can do that write only unix but I want to write with put specific path to drive c or d in window not using FTP, have way?

Re: After authorise any txn then export it to excel 3 weeks, 3 days ago #10230

  • AMMAR.FAIDI
  • OFFLINE
  • Gold Boarder
  • Posts: 201
  • Karma: -4
hi
you can write an authrise routine to write to a text file with , delimiter and convert it to excell
B.R

Re: After authorise any txn then export it to excel 3 weeks, 3 days ago #10231

  • kda
  • OFFLINE
  • Gold Boarder
  • Posts: 296
  • Karma: 0
yeah for this, we can do but write only in unix, out purpose mean write that file to window as drive c or d.

Thanks

Re: After authorise any txn then export it to excel 2 weeks, 1 day ago #10317

  • saahmad
  • OFFLINE
  • Expert Boarder
  • Posts: 101
  • Karma: 3
Have you considered using callj. We are doing the same to get PDF of reports.

Re: After authorise any txn then export it to excel 2 weeks ago #10330

  • balaji2301
  • OFFLINE
  • Fresh Boarder
  • Posts: 19
  • Karma: 0
Create a enquiry for the application with needed fields to export as csv (excel)

Just click Save as CSV on top of enquiry, it will prompt u for path to store in ur computer u can store it as u want

Re: After authorise any txn then export it to excel 4 days, 17 hours ago #10419

  • kda
  • OFFLINE
  • Gold Boarder
  • Posts: 296
  • Karma: 0
Thank so much all,

But my purpose is attach with version booking after authorise will write to local drive

Re: After authorise any txn then export it to excel 2 days, 10 hours ago #10433

  • Azizfatkh
  • OFFLINE
  • Junior Boarder
  • Posts: 21
  • Karma: 0
saahmad could you share you knowledge about using callj... how its done? i got to know that there is jRemote.jar for this matter... don't if i have it. Does it has to be on every client machine?
  • Page:
  • 1
Time to create page: 0.27 seconds