May 2014
1 / 3
May 2014
Jun 2014
whispers
May '14

what is the column (in the exported spreadsheet you can save from the transaction logs panel) right before Currency and after Affiliate ID? (Column 'Z' is what I'm looking for?



it has a blank/empty header (and hence fails on direct MySQL importing through MyPHPAdmin..etc)



but 'some' cells in the column have '0's' in them..??



Can we at least give the column header a name here?



These column names/order -do not- match what is shown on screen either when you do a query and view it..

  • created

    May '14

  • last reply

    Jun '14
  • 2

    replies

  • 1.3k

    views

  • 2

    users

  • 1

    link

E-junkie_GuruWebmaster & Support Guru
Jun '14

This help page documents the fields displayed in Web-based log views vs. downloaded log files:

http://www.e-junkie.com/ej/help.transaction-log.htm



The reason for that discrepancy is because the downloaded file format has had to remain almost exactly the same for legacy support of preexisting client integration methods that depend on it, whereas we at least have more freedom to add information and improve comprehension in the Web-based view.



That empty Column Z in the downloaded log file is for an obsolete field, "Affiliate Share (common for txn)" that is only relevant to transactions from 2008-11-07 to 2010-05-30. Before and after those dates, all affiliate earnings are only reported in Column AH, "Affiliate Share (per item)", so for log queries outside that date range, Column Z is retained for legacy compatibility but left blank. The reason for that blanking and the field's obsolescence was to avoid confusion about just where affiliate earnings are actually reported.

whispers
Jun '14

fair enough...



(I wish the header field wasnt blank.. it kills any direct import without additional steps.... but it is what it is)..



Thanks for link and explanation.



-J