Re: [sqlite] Issues .import(ing) a .csv file
On Sat, Sep 11, 2010 at 6:02 PM, Rich Shepard wrote: > I cannot see what's wrong with a line in a .csv file. SQLite tells me it > expected 14 columns of data, but found 15. No matter how many times I count > the columns (exported in .csv from an OpenOffice.org Calc spreadsheet with > 14 columns), that's all I find. Nothing appears wrong with the following > line, either. And there's no extra space or char visible in emacs after the > final field's closing ". > > What should I look for that I haven't tried yet to find? > > Rich > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > When you saved the spreadsheet as a csv file, you probably took the default delimiter which happens to be a comma. You should check for a cell with data that has a comma in it. The embedded comma would be treated as a column separator which would result in the extra column. If you have an embedded comma, you have a couple of choices. You can fix the data and remove the comma. Alternatively, you can tell OpenOffice to use a different delimiter. Mel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.23
That fixed it for me. Thanks, Mel On Wed, Mar 10, 2010 at 7:01 AM, D. Richard Hipp wrote: > > On Mar 10, 2010, at 12:54 AM, Melton Low wrote: > > > I just tried to build 3.6.23 on a PPC Mac running OS X 10.4. > > Please try adding SQLITE_ENABLE_LOCKING_STYLE=0 to the compiler options. > > > > >> > >> I got an undefined symbol error and the make aborted. > > > > /bin/sh ./libtool --tag=CC --mode=link gcc -DSQLITE_THREADSAFE=1 > > -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -o libsqlite3.la > > -rpath > > /usr/local/lib -no-undefined -version-info 8:6:8 sqlite3.lo > > gcc -dynamiclib -o .libs/libsqlite3.0.8.6.dylib .libs/sqlite3.o > > -install_name /usr/local/lib/libsqlite3.0.dylib - > > compatibility_version 9 > > -current_version 9.6 > > ld: Undefined symbols: > > _gethostuuid > > /usr/libexec/gcc/powerpc-apple-darwin8/4.0.1/libtool: internal link > > edit > > command failed > > make: *** [libsqlite3.la] Error 1 > > > > I have attached the full configure and make output as an attachment. > > > > Your help would be appreciated. > > > > Mel > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > D. Richard Hipp > d...@hwaci.com > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.23
I just tried to build 3.6.23 on a PPC Mac running OS X 10.4. > > I got an undefined symbol error and the make aborted. /bin/sh ./libtool --tag=CC --mode=link gcc -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -o libsqlite3.la -rpath /usr/local/lib -no-undefined -version-info 8:6:8 sqlite3.lo gcc -dynamiclib -o .libs/libsqlite3.0.8.6.dylib .libs/sqlite3.o -install_name /usr/local/lib/libsqlite3.0.dylib -compatibility_version 9 -current_version 9.6 ld: Undefined symbols: _gethostuuid /usr/libexec/gcc/powerpc-apple-darwin8/4.0.1/libtool: internal link edit command failed make: *** [libsqlite3.la] Error 1 I have attached the full configure and make output as an attachment. Your help would be appreciated. Mel BigMac:~/Downloads/sqlite-3.6.23 melton$ ./configure checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for style of include used by make... GNU checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking dependency style of gcc... gcc3 checking for special C compiler options needed for large files... no checking for _FILE_OFFSET_BITS value needed for large files... no checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ISO C89... (cached) none needed checking dependency style of gcc... (cached) gcc3 checking for ranlib... ranlib checking build system type... powerpc-apple-darwin8.11.0 checking host system type... powerpc-apple-darwin8.11.0 checking for a sed that does not truncate output... /usr/bin/sed checking for grep that handles long lines and -e... /usr/bin/grep checking for egrep... /usr/bin/grep -E checking for ld used by gcc... /usr/libexec/gcc/powerpc-apple-darwin8/4.0.1/ld checking if the linker (/usr/libexec/gcc/powerpc-apple-darwin8/4.0.1/ld) is GNU ld... no checking for /usr/libexec/gcc/powerpc-apple-darwin8/4.0.1/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -p checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking how to run the C preprocessor... gcc -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... gcc3 checking how to run the C++ preprocessor... g++ -E checking for g77... no checking for xlf... no checking for f77... no checking for frt... no checking for pgf77... no checking for cf77... no checking for fort77... no checking for fl32... no checking for af77... no checking for xlf90... no checking for f90... no checking for pgf90... no checking for pghpf... no checking for epcf90... no checking for gfortran... no checking for g95... no checking for xlf95... no checking for f95... no checking for fort... no checking for ifort... no checking for ifc... no checking for efc... no checking for pgf95... no checking for lf95... no checking for ftn... no checking whether we are using the GNU Fortran 77 compiler... no checking whether accepts -g... no checking the maximum length of command line arguments... 196608 checking command to parse /usr/bin/nm -p output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... (cached) ranlib checking for strip... strip checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fno-common checking if gcc PIC flag -fno-common works... yes checking if gcc static flag -static works... no checking if gcc supports -c -o file.o... yes checking whether the gcc linker (/usr/libexec/gcc/powerpc-apple-darwin8/4.0.1/ld) supports shared libraries... yes checking dynamic linker characteristics... darwin8.11.0 dyld checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes configure: creating libtool appending configuration tag "CXX" to libtoo
Re: [sqlite] Mac OS Snow Leopard 32bit vs 64bit
Worked cleanly now. Thanks again. Mel On Wed, Oct 14, 2009 at 7:02 PM, William Kyngesburye wrote: > Odd, works fine here. ... ah, make sure you use the --disable- > dependency-tracking option. The default dependency tracking does not > work with multiple architectures. It's just a compilation process and > not using it has no effect on the generated code. > > On Oct 14, 2009, at 7:42 PM, Melton Low wrote: > > > I got a compile error when the 64bit flag was include. Worked fine > > if I > > just use the 32bit flag. > > Thanks for your help. > > > > Mel > > > > On Wed, Oct 14, 2009 at 6:01 PM, William Kyngesburye > > wrote: > > > >> Add this to your configure command (applies to most all configures): > >> > >> CFLAGS="-arch i386 -arch x86_64" > >> > >> > >> > >> On Oct 14, 2009, at 4:46 PM, Melton Low wrote: > >> > >> I am on a Mac laptop running Mac OS X 10.6.1 (Snow Leopard). > >>> > >>> Version of Sqlite I want to build is 3.6.19. When running > >>> 'configure > >>> --help' I didn't find an option to set the build to 32bit. Is > >>> sqlite > >>> automatically build as a 32bit app with 32bit libraries? Did I > >>> miss an > >>> option? > >>> > >>> Mel > >>> ___ > >>> sqlite-users mailing list > >>> sqlite-users@sqlite.org > >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >>> > >> > >> - > >> William Kyngesburye > >> http://www.kyngchaos.com/ > >> > >> All generalizations are dangerous, even this one. > >> > >> > >> > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > - > William Kyngesburye > http://www.kyngchaos.com/ > > "We are at war with them. Neither in hatred nor revenge and with no > particular pleasure I shall kill every ___ I can until the war is > over. That is my duty." > > "Don't you even hate 'em?" > > "What good would it do if I did? If all the many millions of people of > the allied nations devoted an entire year exclusively to hating the > it wouldn't kill one ___ nor shorten the war one day." > > "And it might give 'em all stomach ulcers." > > - Tarzan, on war > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Mac OS Snow Leopard 32bit vs 64bit
I got a compile error when the 64bit flag was include. Worked fine if I just use the 32bit flag. Thanks for your help. Mel On Wed, Oct 14, 2009 at 6:01 PM, William Kyngesburye wrote: > Add this to your configure command (applies to most all configures): > > CFLAGS="-arch i386 -arch x86_64" > > > > On Oct 14, 2009, at 4:46 PM, Melton Low wrote: > > I am on a Mac laptop running Mac OS X 10.6.1 (Snow Leopard). >> >> Version of Sqlite I want to build is 3.6.19. When running 'configure >> --help' I didn't find an option to set the build to 32bit. Is sqlite >> automatically build as a 32bit app with 32bit libraries? Did I miss an >> option? >> >> Mel >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > - > William Kyngesburye > http://www.kyngchaos.com/ > > All generalizations are dangerous, even this one. > > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Mac OS Snow Leopard 32bit vs 64bit
I got a compile error when the 64bit flag was include. Worked fine if I just use the 32bit flag. Thanks for your help. Mel On Wed, Oct 14, 2009 at 6:01 PM, William Kyngesburye wrote: > Add this to your configure command (applies to most all configures): > > CFLAGS="-arch i386 -arch x86_64" > > > > On Oct 14, 2009, at 4:46 PM, Melton Low wrote: > > I am on a Mac laptop running Mac OS X 10.6.1 (Snow Leopard). >> >> Version of Sqlite I want to build is 3.6.19. When running 'configure >> --help' I didn't find an option to set the build to 32bit. Is sqlite >> automatically build as a 32bit app with 32bit libraries? Did I miss an >> option? >> >> Mel >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > - > William Kyngesburye > http://www.kyngchaos.com/ > > All generalizations are dangerous, even this one. > > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Mac OS Snow Leopard 32bit vs 64bit
I am on a Mac laptop running Mac OS X 10.6.1 (Snow Leopard). Version of Sqlite I want to build is 3.6.19. When running 'configure --help' I didn't find an option to set the build to 32bit. Is sqlite automatically build as a 32bit app with 32bit libraries? Did I miss an option? Mel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
