Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Problems using import

Quote Reply
Problems using import
Hi,

I've recently purchased dbman sql and am feeling my way around ....

The first major problem I've hit is with the file import facility.

I have a test table with 5 fields as follows:

1 userid VARCHAR(12) Yes TEXT
2 paid_date DATE No 0000-00-00 TEXT
3 company TEXT No TEXT
4 category_code VARCHAR(255) No TEXT
5 paid CHAR(20) No paid TEXT

and I've been trying to import the following dataset (just as a test)

userid|paid_date|company|category_code|paid
a1||(Taiwan Footwear News) Century Exhibitio|OS|no
a2||3M Company|CS|no
a3||3H Machine Industry Company Limited|MC|no

I've tried doing it from file, and by pasting into the box provided. Eventually I got it to import one row out of the three from the box, but the fields were back to front in the table! I then discovered that if I added the fields one by one in the "fields to import" dialogue in the reverse order, they were imported correctly into the table.

Here's a screen print from mysql showing the 3 rows imported:

userid paid_date company category_code paid
a1 0000-00-00 (Taiwan Footwear News) Century Exhibitio OS no Edit Delete
a2 0000-00-00 3M Company CS no Edit Delete
a3 0000-00-00 3H Machine Industry Company Limited MC no Edit Delete

I've tried this several times and got the same result.
This is buggy in the extreme isn't it?? Has anybody else come across this, or got any ideas why dbman sql is behaving so strangely? Has anyone succeeded in getting the file import to work properly. If someone from GT would like to log in and try this for themselves, I'm happy to provide password details.

Tim
Tim Ault
Oxford UK
Subject Author Views Date
Thread Problems using import timbo 3434 Mar 14, 2003, 12:54 AM
Thread Re: [timbo] Problems using import
604 3387 Mar 14, 2003, 9:29 AM
Post Re: [TheStone] Problems using import
jiliu 3360 Mar 24, 2003, 5:36 AM
Thread Re: [timbo] Problems using import
kjellkk 3321 Apr 3, 2003, 4:01 AM
Thread Re: [kjellkk] Problems using import
timbo 3306 Apr 3, 2003, 4:11 AM
Thread Re: [timbo] Problems using import
kjellkk 3314 Apr 3, 2003, 6:19 AM
Post Re: [kjellkk] Problems using import
charly 3270 Apr 14, 2003, 2:22 AM
Thread Re: [kjellkk] Problems using import
604 3280 Apr 14, 2003, 10:36 AM
Post Re: [TheStone] Problems using import
charly 3246 Apr 15, 2003, 12:46 PM