Kirix Support Forums

Exporting

Please post any help questions, requests or other feedback here.

Exporting

Postby dcalp on Fri Aug 10, 2007 7:40 am

Hello:
Fantastic software, congratulations!

I can't make export to work. After selecting File - Export a dialog informs xdodbc not fount, please reinstall. Ie just installed it.
After that the exporting wizard continues, but I wasn't able to export to Excel or CSV.

I'm working on Ubuntu Feisty.

Thanks!

Diego
dcalp
Registered User
 
Posts: 2
Joined: Fri Aug 10, 2007 7:14 am

Re: Exporting

Postby Ben on Mon Aug 13, 2007 10:13 am

Hello,

My guess is that you need to install unixodbc. Please note there are two odbc's for linux, unixodbc and iodbc. My understanding is that strata runs with unixodbc. After you install unixodbc, that error message should disappear.

All the best,
Ben
Ben Williams
Kirix Support Team
User avatar
Ben
Kirix Support Team
 
Posts: 522
Joined: Mon Dec 19, 2005 6:29 am

Re: Exporting

Postby ericschrauth on Mon Aug 27, 2007 7:45 am

I have unixodbc installed, but get the same message. What I am trying to do is create a connection to an Oracle database (xe on my local (ubuntu) machine). Any clues?[quote]
ericschrauth
Registered User
 
Posts: 1
Joined: Mon Aug 27, 2007 6:42 am

Re: Exporting

Postby Ben on Tue Aug 28, 2007 6:50 am

Hello,

Are you sure that your unixodbc is installed in a path which is included in your /etc/ld.so.conf file? If it is, can you tell me what version number of unixodbc you have? I will attempt to duplicate your problem.

All the best,
Ben
Ben Williams
Kirix Support Team
User avatar
Ben
Kirix Support Team
 
Posts: 522
Joined: Mon Dec 19, 2005 6:29 am

Re: Exporting

Postby amk on Fri Aug 31, 2007 10:43 pm

This also looks like a problem I get.

kubuntu 7.04 Fiesty Fawn (I rather doubt the "k" makes a difference here)
strata 4.0 beta 3
unixodbc 2.2.11-13, from Fiesty's main apt repository

'cat /etc/ld.so.conf' gives 'include /etc/ld.so.conf.d/*.conf'
The only file in '/etc/ld.so.conf.d' is 'i486-linux-gnu', which contains:
# Multiarch support
/lib/i486-linux-gnu
/usr/lib/i486-linux-gnu

Both these directories are empty.

unixodbc .so files are in /usr/lib and /usr/lib/odbc

I've tried adding another file to /etc/ld.so.conf.d/ with the the above directories, and also with the actual .so files, run sudo ldconfig and restarted Strata to no apparent affect. My understanding is that ldconfig should look in /usr/lib regardless of /etc/ld.so.conf

'/lib/ld-linux.so.2 --list /opt/kstrata/bin/kstrata | grep odbc' gives nothing.

'/lib/ld-linux.so.2 /opt/kstrata/bin/xdodbc.so' gives 'undefined symbol: _ZN3xcm5mutexC1Ev' which strikes me as odd.

'/lib/ld-linux.so.2 --list /opt/kstrata/bin/xdodbc.so | grep odbc' gives
libodbc.so.1 => /usr/lib/libodbc.so.1 (0xb7ddf000)
libodbcinst.so.1 => /usr/lib/libodbcinst.so.1 (0xb7dd4000)

'sudo ldconfig -v | grep odbc' gives
libodbccr.so.1 -> libodbccr.so.1.0.0
libodbcinst.so.1 -> libodbcinst.so.1.0.0
libodbc.so.1 -> libodbc.so.1.0.0

So it looks like libodbc.so is being linked correctly.

The MD5 of xdodbc.so is 68336eeb85e328a7f666507ad0765426

Hopefully some of that lot will be of use :)
amk
Registered User
 
Posts: 4
Joined: Fri Aug 31, 2007 4:51 pm

Re: Exporting

Postby Ben on Sat Sep 01, 2007 4:08 pm

Hi,

Many thanks for the excellent bug report. I'll use this information in my testing. I'll keep you posted.

All the best,
Ben
Ben Williams
Kirix Support Team
User avatar
Ben
Kirix Support Team
 
Posts: 522
Joined: Mon Dec 19, 2005 6:29 am

Re: Exporting

Postby Ben on Tue Sep 18, 2007 1:41 am

Hello,

I think I've nailed this bug. Thanks for your post, it helped me fix the problem. You'll see the fix in the upcoming Beta 4 (real soon now).

Thanks,
Ben
Ben Williams
Kirix Support Team
User avatar
Ben
Kirix Support Team
 
Posts: 522
Joined: Mon Dec 19, 2005 6:29 am

Postby amk on Mon Sep 24, 2007 7:58 am

I've tested Beta 4 with the table on the default start page. There's no more complaining about xdodbc, and no error messages unless noted.

Testing "save as external" and "export" with each file type:

Save as external...

csv OK
tsv File contains column headers only
dbf OK, loads correctly into Strata
mdb No file
xls No file
kpg OK

Export
For csv and dbf files, Strata tests for existing directory from filesystem root but then saves files using user's home directory as root, creating extra directories as needed. For example, I try to save to
/home/me/myexportedfiles/
Strata saves in
/home/me/home/me/myexportedfiles/

If I try to save to /home/ or / Strata seg faults.

Saving to a kpg file creates it in the correct place.

kpg Cannot import back into Strata
csv Column headers only
dbf Column headers only using "open", an extra line of apparent garbage with "import"

mdb and xls: After offering to create the file in a popup, gives a popup with:
"There was an error connecting to the specified Microsoft (Access|Excel) file.
Please make sure that the file exists and that it is not currently in use."
Checking the append box seems to make no difference.

Retrying something I tried before...
/lib/ld-linux.so.2 /opt/kstrata/bin/xdodbc.so
Segmentation fault (core dumped)

Running /lib/ld-linux.so.2 --list on each .so in /opt/kstrata/bin
xdaccess.so: error while loading shared libraries: libmdb.0: cannot open shared object file: No such file or directory
xdmysql.so OK
xdodbc.so OK
xdsqlserver.so: error while loading shared libraries: libtds.so.5: cannot open shared object file: No such file or directory
xdfs.so OK
xdnative.so OK
xdoracle.so: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

Still on kubuntu 7.04, unixodbc Version: 2.2.11-13
amk
Registered User
 
Posts: 4
Joined: Fri Aug 31, 2007 4:51 pm

Re: Exporting

Postby Dave on Tue Sep 25, 2007 10:16 am

Hello,

Thanks so much for this thorough bug report. We'll definitely look into each of these issues and keep you posted.

Thanks!

Dave.

#356
Dave Williams
Kirix Support Team
User avatar
Dave
Kirix Support Team
 
Posts: 32
Joined: Wed Sep 21, 2005 11:07 pm

Return to Strata Help & Feedback