|
 |
asp_databases thread: FW: SQL importing question
Message #1 by "Kamjohn Youthjug" <vze2vppf@v...> on Tue, 15 Jan 2002 09:03:39 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0013_01C19DA3.862DE7B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
-----Original Message-----
From: Kamjohn Youthjug [mailto:vze2vppf@v...]
Sent: Tuesday, January 15, 2002 8:54 AM
To: ASP Databases
Subject: [asp_databases] SQL importing question
Hi everyone
I was given a text file db that consited of the following fields:
JTG 001|JANET JACKSON HITS!|POCKET SONGS|RHYTHM &
BLUES|VOCAL|CDG||1|JACKSON, JANET|AGAIN|3|46|C|29.98|JACKSON,
JANET|Y|11/1/00
JTG 001|JANET JACKSON HITS!|POCKET SONGS|RHYTHM &
BLUES|VOCAL|CDG||17|JACKSON, JANET|WHEN I THINK OF YOU|4|18|A|29.98|JACKSON,
JANET|Y|11/1/00
I used xcel to import the information so the field can be imported to sql
correctly. It looked like this.
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------------------------------------------------------------------------
UID CatalogNum AlbumTitle Manufacturer SongCategory MusicType
MediaType TrackNum Artist SongTitle Minutes Seconds Key Price AlbumArtist Y
ReleaseDate Media AlbumCover Details
1 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 1
JACKSON, JANET AGAIN 3 46 C 29.98 JACKSON, JANET Y 11/1/2000
2 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 17
JACKSON, JANET WHEN I THINK OF YOU 4 18 A 29.98 JACKSON, JANET Y 11/1/2000
3 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 16
JACKSON, JANET WHAT HAVE YOU DONE FOR ME LATELY 3 31 Ebm 29.98 JACKSON,
JANET Y 11/1/2000
4 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 15
JACKSON, JANET TOGETHER AGAIN 4 2 C-Eb 29.98 JACKSON, JANET Y 11/1/2000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-
The UID field I input it myself. and the rest of the fields were generated
when i imported the text file. Here's my issue though. I imported the excel
file to SQL
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
1 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 1
JACKSON, JANET AGAIN 3 46 C 29.98 JACKSON, JANET Y 11/1/2000
2 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 17
JACKSON, JANET WHEN I THINK OF YOU 4 18 A 29.98 JACKSON, JANET Y 11/1/2000
3 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 16
JACKSON, JANET WHAT HAVE YOU DONE FOR ME LATELY 3 31 Ebm 29.98 JACKSON,
JANET Y 11/1/2000
4 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 15
JACKSON, JANET TOGETHER AGAIN 4 2 C-Eb 29.98 JACKSON, JANET Y 11/1/2000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--
and it turned out like the above, which is great. I tried changing the UID
field to a unique identifier but it wouldn't let me. Saying it can't set it
to NULL identifier. So basically I can't get it to increment when i add new
records. it justs puts a <NULL> value in the UID field. Can anyone help with
this?
Best Regards
-Kamjohn Youthjug
Message #2 by "Kamjohn Youthjug" <vze2vppf@v...> on Tue, 15 Jan 2002 09:43:38 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0025_01C19DA9.1CA035E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
I'm sorrie the data fields seem out of wack on this email. In the second
example the excel sheet the 1,2,3, before the JTG stuff is in the UID field.
there are no null values in the UID field after i imported them
kj
-----Original Message-----
From: Giovanni Salucci [mailto:g.salucci@n...]
Sent: Tuesday, January 15, 2002 6:19 AM
To: ASP Databases
Subject: [asp_databases] R: FW: SQL importing question
perhaps you have in the table some blank lines..
remove them, and try again to change UID fields...
HTH
-----Messaggio originale-----
Da: Kamjohn Youthjug [mailto:vze2vppf@v...]
Inviato: marted́ 15 gennaio 2002 18.04
A: ASP Databases
Oggetto: [asp_databases] FW: SQL importing question
-----Original Message-----
From: Kamjohn Youthjug [mailto:vze2vppf@v...]
Sent: Tuesday, January 15, 2002 8:54 AM
To: ASP Databases
Subject: [asp_databases] SQL importing question
Hi everyone
I was given a text file db that consited of the following fields:
JTG 001|JANET JACKSON HITS!|POCKET SONGS|RHYTHM &
BLUES|VOCAL|CDG||1|JACKSON, JANET|AGAIN|3|46|C|29.98|JACKSON,
JANET|Y|11/1/00
JTG 001|JANET JACKSON HITS!|POCKET SONGS|RHYTHM &
BLUES|VOCAL|CDG||17|JACKSON, JANET|WHEN I THINK OF YOU|4|18|A|29.98|JACKSON,
JANET|Y|11/1/00
I used xcel to import the information so the field can be imported to
sql correctly. It looked like this.
------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--
UID CatalogNum AlbumTitle Manufacturer SongCategory MusicType
MediaType TrackNum Artist SongTitle Minutes Seconds Key Price AlbumArtist Y
ReleaseDate Media AlbumCover Details
1 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL
CDG 1 JACKSON, JANET AGAIN 3 46 C 29.98 JACKSON, JANET Y 11/1/2000
2 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL
CDG 17 JACKSON, JANET WHEN I THINK OF YOU 4 18 A 29.98 JACKSON, JANET Y
11/1/2000
3 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL
CDG 16 JACKSON, JANET WHAT HAVE YOU DONE FOR ME LATELY 3 31 Ebm 29.98
JACKSON, JANET Y 11/1/2000
4 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL
CDG 15 JACKSON, JANET TOGETHER AGAIN 4 2 C-Eb 29.98 JACKSON, JANET Y
11/1/2000
------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----
The UID field I input it myself. and the rest of the fields were
generated when i imported the text file. Here's my issue though. I imported
the excel file to SQL
------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
1 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 1
JACKSON, JANET AGAIN 3 46 C 29.98 JACKSON, JANET Y 11/1/2000
2 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 17
JACKSON, JANET WHEN I THINK OF YOU 4 18 A 29.98 JACKSON, JANET Y 11/1/2000
3 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 16
JACKSON, JANET WHAT HAVE YOU DONE FOR ME LATELY 3 31 Ebm 29.98 JACKSON,
JANET Y 11/1/2000
4 JTG 001 JANET JACKSON HITS! POCKET SONGS RHYTHM & BLUES VOCAL CDG 15
JACKSON, JANET TOGETHER AGAIN 4 2 C-Eb 29.98 JACKSON, JANET Y 11/1/2000
------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------
and it turned out like the above, which is great. I tried changing the
UID field to a unique identifier but it wouldn't let me. Saying it can't set
it to NULL identifier. So basically I can't get it to increment when i add
new records. it justs puts a <NULL> value in the UID field. Can anyone help
with this?
Best Regards
-Kamjohn Youthjug
$subst('Email.Unsub').
$subst('Email.Unsub').
|
|
|
View Cart
