Dataport and Temporay table.

Aravindh_Navision

Hai Friends,

I need to export a text file and before exporting, I have to do few manipulations in the data. For that I need to store the data in the temporary table and do manipulations from the temporary table and export the final result in the text file.

Could anyone please give me some tip or tell me how to proceed with this?

Note: I am using more than one dataitem and in this case how can I proceed?

Thanks and Regards,
Aravindh R.

Marije_Brummel

If you do not use the MODIFY command you can manipulate the real table. The changes will be discarded after the process.

Aravindh_Navision

Thanks Mark for your reply.

Actually, I did few calculations/manipulations using the GL Entry table and storing those result values in variables (in dataport fields). I need to copy this variables in the temporary table (created new table) fields for all the records. Then I need to group (need to total) based on the GL Account no, currency code field.

Hope this is clear. Am I?


Thanks and Regards,
Aravindh R.

Marije_Brummel

In that case you should create a new table that matches the layout of the export. This table is a variable with Temporary Yes.

In the predataport you can populate the table and let the dataport run on the integer table for the number of records in the table.

The first onaftergetrecord you do a findset and the next you do a next(1).

The dataport fields are the fields of the temporary table.

The Temporary Table does not have to be in the customers license. They are not checked.

Aravindh_Navision

Mark,

I am using G/L Entry table and am not using the integer table. I did few complicated calculation and am not sure that re-doing in integer dataitem will give me the same result.

I just need to store the dataport fields in the new temporary table and from the temporary table I need to do take the records and group based on GL Account No. and Currency Code.

Marije_Brummel

Please read my reply carefully and in detail and then implement the solution. It will work.