Importing data into a User Defined Table

I have done this several times with an Access database and serializable ODBC
connection. Works great.


--
Randy Weber
weber.randy@...
(651) 263-1811

http://randallweber.com/

On Fri, Jun 18, 2010 at 10:11 AM, Stephen Freeman <stephenf@...>wrote:

>
>
> Has anyone created a User-Defined Table then imported data into it from a
> outside source? What procedure or software did you use to do it?
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Has anyone created a User-Defined Table then imported data into it from a outside source? What procedure or software did you use to do it?


[Non-text portions of this message have been removed]
You could do a simple list/paste from an excel sheet (depending on
size), service connect, even a simple SQL DTS package works pretty
slick.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stephen Freeman
Sent: Friday, June 18, 2010 10:12 AM
To: Vantage E Group (vantage@yahoogroups.com)
Subject: [Vantage] importing data into a User Defined Table





Has anyone created a User-Defined Table then imported data into it from
a outside source? What procedure or software did you use to do it?

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
It's a little under 10,000 records so excel is out. BTW, I'm running a Progress Database. What's been your experience with Service Connect?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Friday, June 18, 2010 11:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] importing data into a User Defined Table



You could do a simple list/paste from an excel sheet (depending on
size), service connect, even a simple SQL DTS package works pretty
slick.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Stephen Freeman
Sent: Friday, June 18, 2010 10:12 AM
To: Vantage E Group (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] importing data into a User Defined Table

Has anyone created a User-Defined Table then imported data into it from
a outside source? What procedure or software did you use to do it?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
We pasted about 15k records in to a UD table. The only thing is if you do more than about 1k at a time it starts to get slower with every new record. Just copied from excel then pasted, cleared the form and then pasted the next 1k.
--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> You could do a simple list/paste from an excel sheet (depending on
> size), service connect, even a simple SQL DTS package works pretty
> slick.
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Stephen Freeman
> Sent: Friday, June 18, 2010 10:12 AM
> To: Vantage E Group (vantage@yahoogroups.com)
> Subject: [Vantage] importing data into a User Defined Table
>
>
>
>
>
> Has anyone created a User-Defined Table then imported data into it from
> a outside source? What procedure or software did you use to do it?
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Pretty much anything you can do in .net you can do in Epicor. You can do a textbook read of an excel file using .net code and then use the data set to populate the UD table (or grid or ??). The only "hard" thing is making sure the excel file is properly formatted.

The approach I have used in the past is to put the actual field names in the first row of the excel sheet. Depending on how you read the excel file, the first row usually becomes the column names. This way you can do a loop of the data set along with an "exists" check before putting the value into the table.

Jim Kinneman
Senior Consultant
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, Stephen Freeman <stephenf@...> wrote:
>
> Has anyone created a User-Defined Table then imported data into it from a outside source? What procedure or software did you use to do it?
>
>
> [Non-text portions of this message have been removed]
>
Just dumping into a str8 UD table...fairly gravy. 10k records would
probably take 30min to an hour through service connect, depends on
system activity and the amount of data per record youre pumping in.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stephen Freeman
Sent: Friday, June 18, 2010 11:21 AM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] importing data into a User Defined Table





It's a little under 10,000 records so excel is out. BTW, I'm running a
Progress Database. What's been your experience with Service Connect?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Rob Bucek
Sent: Friday, June 18, 2010 11:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] importing data into a User Defined Table

You could do a simple list/paste from an excel sheet (depending on
size), service connect, even a simple SQL DTS package works pretty
slick.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Stephen Freeman
Sent: Friday, June 18, 2010 10:12 AM
To: Vantage E Group (vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] importing data into a User Defined Table

Has anyone created a User-Defined Table then imported data into it from
a outside source? What procedure or software did you use to do it?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]