T24 full fill an application with data

[kanounw]

Hi Guys,

I'm Walid Kanoun from Tunisia;
Environment : R09 - Jbase5


Please, I nedd to full fill an application with more than 300 rows of
data.

If I'll do it manually within the browser, It will took me a lot of
time. I know that there are tools for that but I don't have any one of
them.

Otherwise, I have the OFS message ( the .TPR file) how can I full fill
the application with that file.

Thanks and Regards,

[Santosh]

Can you please write clearly......whats the exact issue.

--
Mobile: 973-39406098

"Nobody can go back and start a new beginning, but anyone can start today and make a new ending"

[walid kanoun]

what I mean is that I need a method to automatically put data within
an application.

For example I have an excel file with the informations of different
customers (MNEMONIC, SHORT.NAME, DATE.OF.BIRTH, SECTOR ... all the
necassary fields for CUSTOMER), putting the data within the CUSTOMER
application, customer by customer will take long time. How CAN I do to
automatically generate these data from my excel sheet or CSV file into
the application

Thanks



2009/11/14 Santosh <santosh....@gmail.com>:

[Harish Venugopal]

Dear Walid,
     You can write a simple sub-routine to read from your excel file (CSV file) and convert the data into the OFS format and write it to a local folder. Then you could use a OFS.MESSAGE.SERVICE to process the OFS messages from that directory. Alternatively, you could use the OFS.PROCESS.MANAGER/OFS.BULK.MANAGER to directly process the created OFS message from your sub-routine.

      Also i would like you to take a note of one special thing. Most of the times, the customer record cannot be created using the OFS messages, because of the .NOFS setting in the PGM.FILE record of CUSTOMER application. Hope you'll take care of that before trying to post those messages using the OFS.

Regards,
Harish

[JOSE L MARTINEZ-AVIAL]

I use to do that to modify entitlements. For me the best way is to create the OFS lines in the excel, using CONCATENATE to create the command, and then copy the results to a txt file and copy it to the OFS in dir. If you have the fields of each record in a line, it would be something like the following:

=CONCATENATE("CUSTOMER,OFS/I/PROCESS,//,",A1,", MNEMONIC::=",B1,",SECTOR::=",C1)

assuming that the customer number is in the A column, mnemonic in the B column, sector in the C column, and so on.

Regards

Jose 

2009/11/15 walid kanoun <kan...@gmail.com>

[gabalian]

Walid, you can use a MAINLINE routine to create/update CUSTOMER records thru OFS or you can do the same using
  an agent in case you want to run this process continuously.

--
Imran Khan
T24 Technical Consultant
+92 334 3545114

[Santosh]

Fine...there is no substitute to create bulk records unless the data is common.... since your data is different...here are the few suggestions may be you can consider:

 

1. You can use TAKEOVER.MAPPING to upload with a fixed length of fields. Which creates the record in IHLD status.
2. You can use CUSTOMER.DEFAULT. This is an application which defaults the values per sector. If you already have sector wise customers
you can just default common values. But you need to define how many sectors you have and accordingly you need to define.
3. If you are posting through a version make sure its not firing the VERSION.CONTROL programs it may cause delay.

[ADENIYI KAREEM]

Hello Walid,

Are u using T24 Desktop version...? if Yes... then simple... create a VBA routine/Macro on excel file with the exact field you need to populate the CUSTOMER file....

if No... then TOM will do it.

regards,

--
'Niyi Kareem
IT Consultant
P.O.Box 1006
Satellite Town,
Lagos,Nigeria
+2348023382844