2. ASPRunnerPro General questions
  3. 3 of 4 Export Formats not usable
This topic is locked

3 of 4 Export Formats not usable

 		10/26/2005 8:19:59 PM
ASPRunnerPro General questions
pbunyon99 author

I have tried all the output formats, and XLS is OK.

  1. The CSV format has quotes on all the text cols, I think because of an extra space in the export.
  2. The Word export format is VERRY big, and many columns to the right are squished.
  3. The XML format produces an error when opening in MS Excel 2003. The error is 'Invalid xml declaration' on Line 6.
    My goal is to have at least 1 other alternate column or indented row format, besides XLS.

    Thanks for any assistance you can provide.
Sergey Kornilov admin 10/26/2005

Do you experience the same problem with export working with ASPRunnerPro livedemo at http://www.xlinesoft.com/asprunnerpro/livedemo?
Where I can see this problem happening?
pbunyon99 author 10/27/2005

Sergey, the site is internal, but I did check the demo. Here are my findings, but the bottom line is I think the CSV format is the only real one that may need to be fixed.

  1. on the DOC format... my database has many columns, and that in combination with a larger font made a very undesirable output.
  2. on the XML format... I do get an error, but different from before... this may be my lack of XML knowledge
  3. on the CSV format, I get the same behavior on the demo... the quotes around the text make the file somewhat useless. I noticed that the first column is OK... this is because there is no preceding space.
    So, the question is... is the CSV format the intended format, or is this a bug ?
Sergey Kornilov admin 10/27/2005

The double quotes around text fields in CSV are perfectly valid. The primary goal is to prevent CSV file format from breaking when any text field has a comma (delimiter) in it.
pbunyon99 author 10/27/2005

Sergey,

The Quotes are not the problem... in front of every " is a 'space' . Excel interperates the whole string, including the quotes as a text. What is inside the quotes is the correct value for the cell. The cell should NOT containg the quotes. I can see the ASP code created by export.asp where the commas are inserted... I think the space has to come out. I can see where the generated ", " are, but I can't figure out how to change export.asp to fix this. Please Help.
500362 11/3/2005

the CSV export works beautifully for me. you can adjust settings in excel on how to sepearte fields or collumns if u want a custom format for the CSV type file you can always edit the ASP code in " "_export.asp Just go down to where it says CSV export and you can play around with the fields. Add letters change spacings get rid of the quotes.. whatevre you please.. just dont mess anythign else up tho <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=6622&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />