3 / 3
Dec 2010

Hi, when I download my transaction data, any transaction that has a discount code is not complete. For example, when there is a discount code used, the data gives me the normal beginning data, with email, then IP address, and then the discount code. All information ends at that for that row. Normal rows (those with no discount code used), however, continue on after the IP address with the invoice number, prices, etc. This is making organizing my data extremely difficult! Please fix ASAP!

  • created

    Dec '10
  • last reply

    Dec '10
  • 2

    replies

  • 964

    views

  • 2

    users

  • 1

    link

We tested the Download Log function and were not able to reproduce this problem currently; the log files we obtained via Seller Admin included all data for every transaction, regardless of discount code.



Maybe your spreadsheet program is misreading the file somehow? It's a plaintext file, so you could open it in Notepad or textEdit, preferably turn off word-wrapping, search for the discount code you're concerned about, and see whether or not the rest of that line is blank as you reported.



If your Download Log button is still producing a file with missing data for you, please email that file to us as an attachment along with the exact steps you took to produce that file (i.e., what product, date range, and/or affiliate you'd selected, if any, to View Log before you downloaded a copy of that log view):

https://www.e-junkie.com/ej/contact.php

I did what you said, and it is showing up on Notepad with word wrapping off. However, I noticed that when I look at the data that way, there is a comma after each discount code (on applicable lines) and I wonder if that is messing it up. In the past, all I had to do was change the extension to .xls and all data would carry over. I can't help but think this comma has something to do with it.



UPDATE as I write this: I went through the txt file and deleted all commas, and that fixed the problem as all data is now importing into the excel file. However, I still think your system needs to not have that comma there, as it's somehow messing up the data that excel interprets.