Hi , I am using the plugin "RDBMS CSV Import Export" and I am able to

Sachin Pandey

A Score Level 1

over 11 years ago

Hi , I am using the plugin "RDBMS CSV Import Export" and I am able to export the data to the CSV but some of the columns dont populate. Has any one encounter similar issue and how did they come around it? If not, can anyone tell me what can i do to fix this issue.
Please advice....

Discussion posts and replies are publicly visible

0 Sachin Pandey
A Score Level 1
over 11 years ago

I am able to figure out the problem at my end. Some of our columns has nvarchar datatype which was not recognised by the plugin. Once I change the data type to varchar, all columns got populated.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riteshp over 11 years ago

Hi Sachin, Thanks for Reply!! I got the same solution from your older post, checked no nvarchar :(, With same table it is working fine but i need to change heading of the column and need to export few cloumns, Don't know how to make it!! Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riteshp over 11 years ago

Is this plugin really works with views? I wonder if!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riteshp over 11 years ago

One Correction, Pluging is working with view, but not working with alias names!! e.g.
view - select x.col1 from xyz as x - is OK
but - select x.col1 as myCol from xyz as x - is not OK

Any Idea!! Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 11 years ago

I remember coming across problem with alias (in MySql) db long time ago. See if this might be relevant
bugs.mysql.com/bug.php
You can configure your JDBC URL in your -ds file to allow for alias.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riteshp over 11 years ago

Hi, Thanks a lot Sathya!! got the concept, also we update MSSQL diever, will try with replacing older one and lets see, it should work. Meanwhile, will try to find out the way to fix it. Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sachin Pandey
A Score Level 1
over 11 years ago

Ristesh - I used CAST to change the datatype on the view and it worked for me. We are using MS SQL 2008.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riteshp over 11 years ago

Hi, Thanks all, CAST worked for me!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel