Issue with order export - adding extra column from table

[Endre]

Hi,

I've bought the addon JPS Data Mass Export (Orders : CSV + FTP + CRON + PROFILES) Module.

I'm looking to add an extra column to the csv-jpsmassexportajax.phpfile that is exported, but when I get the correct data from the database table, the orders are copied about 20 times or more.

The exported cvs-file should only have 30 lines at the moment, but the file contains almost 600 lines!

 

I'm trying to get data from the "transaction_id" column in the "order_payment" table into the csv-file.

 

I've contacted the delevoper three times, but I'm not getting any response.

I would be very greatful if someone with a bit more knowledge than me would take a look in the attaced file.

I have added the extra code for "transaction_id" and "order_payment".

 

I would imagine that the issue is related to the conditions for the query, but I'm no programmer, so it's all a bit foreign to me.

 

Best regards

Endre