Default data type on import

prohan · Post by **prohan** » Wed 28 Jul 2010 00:25

Hi,
I'm loving DBforge so far but have run into a snag. I'm trying to import a table that has ~400 columns. Each column has data with ~10 decimal points. After I import the data dbforge always cut it down to points.

Any quick way of just changing the type of all of these to something like text when I import

Viktor · Post by **Viktor** » Wed 28 Jul 2010 09:31

Can you send us a sample of the imported file?

prohan · Post by **prohan** » Wed 28 Jul 2010 20:37

Here's the file:

http://dl.dropbox.com/u/530959/All%20Fi ... 272010.csv

prohan · Post by **prohan** » Wed 28 Jul 2010 21:04

I originally tried this as a XLSX and it wouldn't give me the right number of digits. I tried it as a CSV and it sets all the columns to VAR(255) but then complains that I have too many rows. I only have something like 350.

Viktor · Post by **Viktor** » Thu 29 Jul 2010 16:14

1. Create a new table with required types and column lenghs. Import from CSV format to a created table.
2. While importing from CSV, on the Mapping wizard page specify correctly column types and set a required lengh.

...but then complains that I have too many rows

Total of varchar data lenghs in columns of one row should not exceed 65535.
VAR(255)*~400 =~102000

prohan · Post by **prohan** » Thu 29 Jul 2010 23:22

Is there a way to change the types of all the columns at once or do I have to go through and change each one manually.

Viktor · Post by **Viktor** » Fri 30 Jul 2010 10:46

There is no possibility to change data types of all the columns simultaneously. You should set each column type manually.