r*******o
发帖数: 38 | 1 I kind of get a werid problem with import XML into SQL server database.
I have a XML file of an Apartment data. I need to import this file into SQL
server Database.
The xml file looks like the following:
LINCOLN PROPERTY COMPANY
799
8203 Southwestern Blvd.
Dallas
TX
I use ADO.Net to read the XML data into Dataset, then |
|
c**t
发帖数: 2744 | 2 import cvs file into one table (SQL Server), there are three indexes
created on the table. Is there any way to import faster?
Now it usually takes 30minutes to finish. about 10 minutes load data,
then build indexes (I guess). |
|
n****u
发帖数: 229 | 3 Sorry I can not write Chinese here.
In MySQL, I have two databases: newdb and olddb
table1 in newdb, table2 and table3 in olddb
table1 has userid, nickname, msn
table2 has userid, nickname
table3 has userid msn
First I use NaviCat to import table2 into table1, very fast! 320,000 records
in 2 mins!
Then I tried to import table 3 into table1, now I have to check userid first
, then UPDATE table1. Very slow. 50,000 records in 12 hours
Anyway I can make it fast?
Thanks |
|
t*********i
发帖数: 217 | 4 yes you should join first then import.
My estimate is the total time would be comparable to only import table2. |
|
n****u
发帖数: 229 | 5 Thanks for your reply.
I test INNER JOIN:
INNER JOIN table 2 and table 3, 40 seconds (not sure it's good or bad for
320,000 records)
So I started to work on my real task
INNER JOIN table 2, table 3 and table 4, 3 mins (320,000 records)
export result to dbf file, 10 mins
import dbf into Table1, 10 mins
Finally I finished my task in half hour, instead of 3 days.
Now how can I improve export and import process?
PS. I am a .net programmer, but team leader asked me to migrate database.
The next task |
|
n****u
发帖数: 229 | 6 I love you both tangyuanlai and Beijing! hehe
Yes, I tried this way, it's sooooooo fast!
Insert new table
select
from inner join of old tables
21.891 ms (migrated 320,000 records)
Previously I used C# code, it would take me 1 week
Then I used NaviCat import wizard, it would take me 3 days
Yesterday I exported query result and imported into new table, it took me 30
mins
Now, 21.891 ms haha
Thank you very much!!! |
|
G***G
发帖数: 16778 | 7 looking for tools for importing data to oracle.
easy to use
no requirement for creating table before importing(it can automatically
create the table including its field and field width, just as MS ACCESS does) |
|
G***G
发帖数: 16778 | 8 is there any good tools for us to create the target table according to a
being imported text file, especially for the field type and field width?
importing is easy, but creating such a table with proper field type and
filed width is not easy, especially for a big text file such as 1000 columns
and 100,000,000 rows.
the
used
determine |
|
B*********L
发帖数: 700 | 9 我用SSIS import and export wizard 从Oracle 数据库import 50个表到sql2005. 这
个Package 有时候success,有时候fail, fail的时候不定在那个TABLE，但是error
message 都一样的。
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:
0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native
Client" Hresult: 0x80004005 Description: "Invalid character value for cast
specification".
我试着把package 变成一个table一个Data Flow Task然后串起来RUN，但是有这个
ERROR。
大家看看有什么办法呢？
谢谢了。 |
|
j*****n
发帖数: 1781 | 10 Here is a dummy solution....
use SSIS to export Oracle data into a text file (Delimited);
use SSIS to import this text file into your destination table. Better
predefine your destination table first, otherwise the data type may differ
when you create it while you import.
Another solution is that use data conversion component, which could do some
type transformations but is limited.
Sure, changing collations is always a pain in the S.
Let me know which one worked well for you. |
|
c*****a
发帖数: 1577 | 11 用Access import excel tables 但是从第6行开始， 前五行是header. 可行吗？
用import wizard 好像不行，是要用VB macro吗？
包子答谢！！ |
|
m********d
发帖数: 82 | 12 新客户的数据需要import到sql server 2000 database.其中一个column是notes field
,很长。在import过程中被告知text data being truncated。
请问如何才能不被truncate?谢谢。 |
|
l******y
发帖数: 60 | 13 大牛们，有没有可以import txt或 xls的sql命令？table 已经建好，但不用sqlloader
，也不用toad中的import功能，就是sql 命令，写入script可以直接运行的？
就像SAS 中的
data XXX
infile '.....a.txt'...
或者把文件中的内容直接输入，类似SAS中的 dataline.....，但不要一行一行地
insert
多谢啦 |
|
x****g
发帖数: 6597 | 14 Thank you first!
I write a program using JBuilder. This program include two packages. The main
class import a class which defined in another packages. How can I compile Java
file in UNIX? I try four hours, it always tells me the errors for the import. |
|
s****j
发帖数: 14 | 15 Project properties:
Paths->Required Libraries
include the jar files/path there
Think about the way you import some commercial packages, like Oracle JDBC
They are the same.
main
Java
import. |
|
t******l
发帖数: 6 | 16 我在书上看到，假如 there are classes with the same name in tow different
package, and then you must either making one or the other calss explicitly, or
you must refer to the class using its fully qualified name.
那我想请问，比如说有一个小程序，都使用 Date class in package java.util and
java.sql
import java.util.Date;
import java.sql.Date;
public class Test
{
Date myDate = new Date();
}
那么这个Date class 到底是谁的? 或者说如果我想说明它是java.util.Date应该怎么板
呢
我这个问题比较STUPID，今天看书的时候突然想到的，也许根本没有人这么写程序吧
谢谢! |
|
k**********a
发帖数: 255 | 17 朋友用的是JDK＋EMACS 他每次都要在source file 里边加上
import java.lang.* 和 import java。io。*
我用的是eclipse 每个java project 自动加入了 JRE system library （version 1。
6） 这个JRE system lib中有很多fold 我每一个都打开看过了 但是没有发现Java。
lang 和java。io？？？？？ |
|
i**p
发帖数: 902 | 18 Is there something like this in Java? Thanks!
#if GNUIO
import gnu.io.*;
#else
import javax.comm.*;
#endif |
|
f****h
发帖数: 97 | 19 各位老大，前面我学stanford那个CS106A的时候，下载的package是能直接import到
eclipse的，现在开始看看core java，网上下载的code，请问怎么import到eclipse里
面运行啊？
叩谢了！ |
|
r****t
发帖数: 10904 | 20 这个practice不好，这让module1 depends on global foo.
如果一定要用global变量, 写到一个module里面：
globalvars.py:
foo = "bar"
foo1 = "bar1"
然后在主程序里头：
import globalvars
or
from globalvars import * |
|
a*****e
发帖数: 176 | 21 【 以下文字转载自 Quant 讨论区 】
发信人: aasmile (红颜弹指老，刹那芳华), 信区: Quant
标 题: 问个matlab import data的简单问题
发信站: BBS 未名空间站 (Mon Jun 4 16:36:22 2007)
data文件可以是csv/txt等，但是不是excel文件，
data的格式如下
new york, NY 45.6
san jose, CA 75.4
orlando， fl 100.9
......., .. ....
which command should I use to import it into matlab?
Thanks very much! |
|
S*******s
发帖数: 13043 | 22 I got an error if I want to run test.py:
@singleton
NameError: name 'singleton' is not defined
if I combine the two files, it would be fine.
what is right way to import decorator?
#in module Singleton.py
def singleton(theClass):
""" decorator for a class to make a singleton out of it """
classInstances = {}
def getInstance(*args, **kwargs):
""" creating or just return the one and only class instance.
The singleton depends on the parameters used in __init__ """... 阅读全帖 |
|
S*******s
发帖数: 13043 | 23 Thanks. still confused, when we import sth, when do we need add the module
name as prefix when we need refer to the element in the imported module?
Also, can you explain a little on how the getinstance get called?
of |
|
S*******s
发帖数: 13043 | 24 My test script runs well in PyDev. but in the IDE, it marks error in the
line import Sybase, with description Unresolved import: Sybase
again, it runs well, which means the python is able to find the egg while
pydev can not. Where shall I direct pydev to solve the reference? |
|
l*******m
发帖数: 1096 | 25 em your OS is win
there are other approaches:
1) use sys.path to add the path, such as
import sys
sys.path.append('/path/to/package')
2) or you can ignore the error by using #@UnresolvedImport. e.g.
import xxx #@UnresolvedImport |
|
B*****g
发帖数: 34098 | 26 3.0?
try:
# for Python2
from Tkinter import *
except ImportError:
# for Python3
from tkinter import *
module" |
|
m******u
发帖数: 12400 | 27 还是不行，import哪行没出错提醒，下面调用，出现出错提示，‘tkinter （tk） is
not defined’ NameError。
>>> from tkinter import *
>>> top = tkinter.tk()
Traceback (most recent call last):
File "", line 1, in
NameError: name 'tkinter' is not defined
>>> |
|
m*****n
发帖数: 3575 | 28 觉得Lexical Scoping好用啊
例如
def cylinder(r, h):
def circle():
return math.pi*r*r
return circle*h
如果找不到变量，向上一级去找就好啦
但是此方法不适用于import
a = 2
import sub
print a
结果sub就不会到上一级main里面去找a这个变量 |
|
s**********l
发帖数: 629 | 29 ☆─────────────────────────────────────☆
发信人: rabbitmm (猪。。。), 信? Actuary
标 题: location is important?
发信站: BBS 未名空间站 (Mon Feb 12 02:51:51 2007)
最近在看本版和华人上的有关精算的信息，大家都认为对于精算找工作来说，location
很重要。那么，精算的工作在那些地方比较集中呢？东西两岸？
还有一个问题跟各位确认以下，我按照精华区的连接查了一下提供精算master得学校，
发现不是很多。是不是绝大部分学校提供的都是精算的本科学位？
谢谢各位了~！
☆─────────────────────────────────────☆
发信人: MoSesMoSes (unsane), 信区: Actuary
标 题: Re: location is important?
发信站: BBS 未名空间站 (Mon Feb 12 08:29:09 2007)
精算的工作在那些地方比较集中呢？东西两岸？
New York, New Jersey, Chicago |
|
j*w
发帖数: 60 | 30 I wanna import some TIF images (with TFW file) into CAD by using an autolisp
application named Tifin. It works fine for images obtained before 2002.
However, for images generated after 2005, it seems that the Tifin
application cannot import images at the right spots and scales. I wonder
anyone on this forum has ideas on solving this issue. Thank you. |
|
l***u
发帖数: 10 | 31 【 以下文字转载自 shopping 讨论区 】
发信人: LiuYu (thinker), 信区: shopping
标 题: how important is the invoice?
发信站: BBS 未名空间站 (Sat Jan 26 15:32:31 2008)
just wikied it.
seems invoice is only a commercial document.
And according to my experience, you have to request to obtain one if you buy
stuffs online.
My question is: how important is the invoice in law? Do I need to request it
every time in order to get a confirmation of my purchase?
Thank you. |
|
p********g
发帖数: 13 | 32 大家好，我是freshman, will declare math major next year. 请教各位大侠:
Our department only has cal, multivarible cal, linear algebra, abstract
analysis and real analysis as 5 required core courses.
Is Number Theory a very important class? or I better take more computer
related classes?
What other classes are important to take? Such as Tpics in Linear Alg & Diff
Eq., Stat, Mathematical Models, Operations Research, Complex Analysis,
Differential Geometry, Combinatorics, functional analysis..... or
other cla |
|
c*******h
发帖数: 107 | 33 http://www.guardian.co.uk/uslatest/story/0,,-6615677,00.html
Tuesday May 8, 2007 1:01 AM
By ANDREW BRIDGES
Associated Press Writer
WASHINGTON (AP) - In a triumph for the pharmaceutical industry, the Senate
on Monday killed a drive to allow consumers to buy prescription drugs from
abroad at a significant savings over domestic prices.
On a 49-40 vote, the Senate required the administration to certify the
safety and effectiveness of imported drugs before they can be imported, a
requirement that off |
|
l****u
发帖数: 84 | 34 【 以下文字转载自 Database 讨论区 】
发信人: lalahu (lalahu), 信区: Database
标 题: Import 50GB data from multiple .txt file into MS SQL database
发信站: BBS 未名空间站 (Wed Jul 15 10:05:29 2009, 美东)
I am going to import very large stock market data from multiple .txt files (
over 3000 files) into sql database. I was wondering which is the most
efficient way to do that?
I used bulk insert and it takes me forever time (estimated 7 days) |
|
z****u
发帖数: 185 | 35 maybe you can try this sequence?
import scipy
import scipy.stats |
|
p********a
发帖数: 5352 | 36 ☆─────────────────────────────────────☆
attone (hehe) 于 (Sat Feb 24 00:26:10 2007) 提到:
I try to import an excel data into SAS, but all the data in one of the
variables was blank after import. Who can help me out of this? Thank!
☆─────────────────────────────────────☆
rainsure (baxia) 于 (Sat Feb 24 00:31:48 2007) 提到:
what kind of variable is it?
Date? character?
☆─────────────────────────────────────☆
leftHand (Hold on...) 于 (Sat Feb 24 00:33:24 2007) 提到:
in excel, make the first |
|
o******6
发帖数: 538 | 37 Some variables in the original excel file are numeric but have no value for
the first 8 observation. When I import the file , these
variables become character variables and their value are all missing. I know
SAS uses the first 8 observations to determine the variable type, does
anyone know how to fix it? Do I need change some SAS setting? Thanks, the only biostatistician in my group didn't help me (no problem in his computer) and I usually figure it out by myself :(.
PROC IMPORT OUT= WORK.a
|
|
o******6
发帖数: 538 | 38 这样的话我还有其他大的DATASET不是无聊死，而且我上次改了REGISTRY KEY后IMPORT
EXCEL很容易，可是IMPORT CSV我改了TEXT下的一些REGISTRY KEY没用不知道咋回事。 |
|
p********a
发帖数: 5352 | 39 proc import当然不是永远都WORK的，尤其是CSV file，所以有时候必须用INFILE。
你可以先用PROC IMPORT，然后到SAS LOG里面去，COPY 里面SAS自动产生的INFILE
CODE，PASTE到EDIOR里面，改正一些需要改正的FORMAT，INFORMAT就行了，最多也就是
个5分钟的问题。
TIP: COPY 前，可以按住ALT KEY，纵向选择要COPY的CODE，避免把SAS LOG的行号COPY
进去。 |
|
y***6
发帖数: 46 | 40 The following is the problem incurred when I try to import excel data file
into sas. Hope someone can help.
SAS Code:
proc import out=Work.Edu
datafile="C:\Documents and Settings\smith\Desktop\education.xls"
dbms=excel replace;
getnames=yes;
mixed=yes;
scantext=yes;
usedate=yes;
scantime=yes;
run;
The excel file have 25 variables and 1272 observation with some missing
values. In addition, the first row in excel f |
|
s******e
发帖数: 841 | 41 I have a for loop in R, in each loop, I want to import data from a database
using different selection criteria.
I know how to use SQL in R to get data with a fixed criterion, but my
criterion changes in each loop, how can I use an R variable in the SQL query
so that each time I can import different data I want?
Thanks |
|
x******e
发帖数: 42 | 42 現有500 excel files and these file names are stored in another file called
file.dat.
How to quickly import these files (500 excel files) and stored as SAS files
respectly after transposing them?
I wrote the code for a single file, but have to run the macro 500 times with
different numbers. It will be tedious.......... Any other convenient way
by taking advantage of the file.dat?
3xs!!!
%macro dataread(number);
PROC IMPORT OUT= file&number
DATAFILE= "C\chart_data\CR&number..xls"
DBMS |
|
l****y
发帖数: 130 | 43 I am trying to importing csv into sas. I use proc import in my computer. It
works fine. But when I use the same code in other computer, it does not work
. The strange thing is that the last variable is always character.Any advice
is welcome.
Thanks a lot. |
|
D******n
发帖数: 2836 | 44 u mean proc import or just use data statement?
用sas import一个csv表格，看起来总是检测不到record的末尾标记，造成这个数据被
输入到那个变
量中，数据和变量乱七八糟的，不相吻合。试了把csv转化成txt，或者excel，都不行。
有没有人碰到过这种情况，该怎么解决呢？ |
|
s****y
发帖数: 21 | 45 用菜单的import，也试了一下data statement，一样的结果。
刚查了一下有这个问题：在某些cell中的文字之间有回车，比如某一个cell的内容是：
colon polyps (66) （回车换行）
uterine cysts (20's)
import之后在sas中看见是分成了两个数据。
我想可能是这个原因造成的，应该怎么办呢？ |
|
S******t
发帖数: 1437 | 46 Can u give a few examples in detail?
In my opinion, proc import is the most convenient way to import csv files
into SAS. But if it doesn't work, you may try data step, that way you can
define each variable to be numerical or character. |
|
p********2
发帖数: 9939 | 47 The access data is big, maybe several GB. Everytime I tried to import access
as SAS, it says "out of source". How could I breakdown the data
observations and then import separately? Or is there any other way to save
access data as SAS file?
Many thanks. |
|
d*******o
发帖数: 493 | 48 Once you use Proc Import, you will eventually have data step infile code on
your log windows. Copy it and save it for future use. Once you like to
change any format, change the data step infile code, instead of your proc
import. |
|
d*******o
发帖数: 493 | 49 By default, in Proc import, SAS read the first 8 observations to decide the
variable type. You can add more rows for SAS to guess.
proc import out = work.n3
datafile="c:\n3.xls"
dbms=excel replace;
range="sheet1$";
getnames=YES;
MIXED=NO;
scantext=YES;
usedata=yes;
scantime=yes;
GUESSINGROWS=10000;
run;
If you try to control exact variable type or length, I suggest to transform
EXCEL to CSV. Then you will specify anything there. |
|
