Export to File Issue

Hi.

I created an ASP page that uses the 'ExportToFile' command to allow a button to appear to Export the contents of my query.
It works fine - however, for some odd reason, it overwrites my date field with an invoice number field.

The only thing that I can think of, is the name of the field is called Invoice #.
Is it possible that the '#' is the cause of this behavior of overwriting a field when the ExportToFile occurs?

As well, where is it exactly that I can see in the system logs the action of an ExportToFile to determine if this is the real cause of the issue?

Here is the Invoice # header that appears on the screen:

Here is the Export to File content in CSV within excel:

Notice how the Invoice # is duplicated instead of having the date appear.

---

One more thing - where is it that you can change the name of the header? I checked in the view, and there is no alias - the actual name of the field is invoice.

I'm confused how the Invoice # is appearing when the view it is based on doesn't have it. Is it possible to rename a header in a block?

Let me know,

Thanks,
Steph

  • 0

    Hi again.

    Ok - I figured it out after increasing the Logs to 5 in the system and reviewing the SQL log.

    It had nothing to do with the header symbol (#). It turns out that the actual field names were the issue - in particular the second one (date field).

    The field name for invoice was "invoice" (which was ok) and the field name for invoice date was "invoice date".

    However, this is ok (in terms of a view) until your ExportToFile - because the 2nd field is two words, it gets confused and rejects it.

    Here's how the export to excel looks once I changed the date field name to a single word:

    ---

    Now I just need to figure out how to rename the header name...

    Thanks,

    Steph