× Discuss on porting data from legacy systems to T24. Data mapping, Data Migration tool, Extract Statergy, Writing runbook, Cut-over, Migrate static and Financial data, Balance transfer, Technical and Functional reconciliation, etc…

Importing Data from Excel to T24Banking.

  • taurus
  • Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 2 months ago #22676 by taurus
I am just a T24 end user, not into development area. But I want to know is there any possibility to Enter data (Fill in field) that can be automated with the use of ExcelMacro(VBA) or is there anything else (Data Integration or other application which is primarily used by developers)
The entry that needs to be input is pretty monotonous so I want way out to automate this process. The entire entry on T24 looks like this:

Step1: Type in number

Press "TAB"

Step 2: Type FEDR

Press "TAB"

Step3: Type date

And once done, just conmit the transaction, which can also be done manually.

These three steps need to be repeated 1000times, so I need a macro like thing to avoid this repetitive entry. I have the data in CSV excel file. So just want to upload this.

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
More
4 years 2 months ago #22677 by VK
Hi
T24 Desktop is able to do that.

Cheers
VK
The following user(s) said Thank You: taurus

Please Log in or Create an account to join the conversation.

  • taurus
  • Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 2 months ago #22682 by taurus
Replied by taurus on topic Importing Data from Excel to T24Banking.
And I guess it will not be possible to download and install it on my own, my company will have to purchase it and implement it across the board given the exorbitant cost of the software ?
Or I can download and install it online ?

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
More
4 years 2 months ago - 4 years 2 months ago #22686 by VK
If you have a T24 instance running you have the right to have Desktop free of charge.

Ask This email address is being protected from spambots. You need JavaScript enabled to view it.; the current version is 1.9.

You'll need telnet server running on your T24 server to be able to use Desktop. Under Windows TAFC there's telnetd.exe in bin folder.

Cheers
VK
Last edit: 4 years 2 months ago by VK.
The following user(s) said Thank You: taurus

Please Log in or Create an account to join the conversation.

  • silvergem
  • silvergem's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
4 years 1 month ago #22700 by silvergem
Replied by silvergem on topic Importing Data from Excel to T24Banking.
You can use EB.FILE.UPLOAD to upload data on any t24 application. for larger data you can use DM.TOOL

Please Log in or Create an account to join the conversation.

Time to create page: 0.081 seconds