Welcome, Guest. Please Login.
05/14/25 at 19:44:23
News:
Home Help Search Login


Pages: 1
Send Topic Print
DE-A Export Data - Quotes Not Escaped (Read 974 times)
BethanyW
Browser
*




Posts: 46
DE-A Export Data - Quotes Not Escaped
01/16/13 at 06:20:59
 
I'm used DE-A to export data, and have discovered that quotes are not escaped when exporting.  It's messing up the columns of my export when I open it as a spreadsheet, and there's no easy way to fix it that I can think of.
 
In case the problem limited to something specific, here are the parameters I used:
Date: ISO format
DBA Filename: ROUTING
Output Filename: ROUTING.TXT
Output File Type: Delimited
All Fields: Yes
Back to top
 
 

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: DE-A Export Data - Quotes Not Escaped
Reply #1 - 01/16/13 at 11:38:15
 
The latest version of DE-A uses JDBC and is far more flexible than the one you are using.  Try logging in as ADMIN and using the new one.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
BethanyW
Browser
*




Posts: 46
Re: DE-A Export Data - Quotes Not Escaped
Reply #2 - 01/16/13 at 12:20:44
 
It said I need to run T7Jsettings, so I did but I'm having issues with that.  I entered the host, the port was automatically filled in, I entered the name and destination.  When I went to Test Settings, I get an error:
File Not Found Exception: jdbc.ini
 
Interestingly, and I imagine related, the parameters listed at the top show NULL for db host, db port, and db name.
 
Am I doing something wrong?
Back to top
 
 

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: DE-A Export Data - Quotes Not Escaped
Reply #3 - 01/16/13 at 12:37:46
 
Save the settings and close SM-T and go back in, then test.  I have asked Allen to disable the Test Settings button until the settings are saved.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
BethanyW
Browser
*




Posts: 46
Re: DE-A Export Data - Quotes Not Escaped
Reply #4 - 01/17/13 at 05:33:33
 
That worked, thanks!
 
I have a little feedback about SM-T though.  In all the applications I've used a test function uses whatever values are shown in fields - not what's been saved and is (perhaps, if the user has entered different values) not shown.  This seems to make sense because you don't want to have to save settings that you're not sure even work.
Back to top
 
 

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11
WWW   IP Logged
Pages: 1
Send Topic Print