|
|
Rank: Newbie
Groups: Member
Joined: 5/18/2008
Posts: 1
Points: 3
|
I am new to MyLittle Admin, having just been introduced to it as the preferred admin tool by my web hosting company.
Can someone confirm the following please.
1. Does the CSV Import wizard append data to existing data in a table or overwrite existing data.
2. If I have an autonumber in the primary index field will I need to just leave that field blank for the import to have the next sequential numbers added when it is brought into the table.
3. Do I need to use " " round text values that I import or will the existing field properties not require this to determine the correct field value format
Sorry if these questions are a little basic, but I have to update a product catalogue with some extra items and I don't want to cause any problems to the existing catalogue items while the catalogue is live
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Hi -
#1: Default setting is "Append rows" - in v3.5, you can choose between append and overwrite in the Options tab.
#2: use a CSV file with no autonumber and uncheck the autonumber column
#3: the wizard does not require text delimiter -
Note I recommend you to test your settings with a temp table before importing data into a live production db.
|
|
Rank: Newbie
Groups: Member
Joined: 5/26/2009
Posts: 1
Points: 3
Location: Clarence, NY
|
I have a question regarding the CSV import also:
1. Is there a way to import delimited files?
Example file for importing state names:
FIELDS: STATE, ABBREVIATION
Following is an example data file:
"NEW YORK","NY"
"CALIFORNIA","CA"
"OHIO","OH"
If this isn't possible, will it be a feature that will be added?
Thanks,
Shawn
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
CSV with delimiter is not currently supported. It should be in a next release.
|
|
Rank: Newbie
Groups: Member
Joined: 9/2/2009
Posts: 1
Points: 3
Location: London
|
I can't import data into my database. The data I an trying to import contains free text with commas, new lines, etc.
It appears that the new lines (carriage returns, etc) are acting like a delimiter, and the next INSERT statement has text across the next few fields, rather than the correct data for the next row.
Any ideas on how to get around this issue?
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
You won't be able to import such data using the csv import wizard.
|
|
Rank: Newbie
Groups: Member
Joined: 11/23/2009
Posts: 2
Points: 6
|
StuartS wrote:I can't import data into my database. The data I an trying to import contains free text with commas, new lines, etc.
It appears that the new lines (carriage returns, etc) are acting like a delimiter, and the next INSERT statement has text across the next few fields, rather than the correct data for the next row.
Any ideas on how to get around this issue?
Can you make up insert statements in a text file and then paste this into the T-SQL window ?
|
|
|
Guest |