UD Table Import Workflow

Yahoo Archive
1
I believe that calling GetNew method returns a datarow with all the default values filled in and then you need to supply the key fields.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Monday, July 13, 2009 1:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UD Table Import Workflow

How does one properly handle nulls in UD table SC imports? If I don't supply a '0' it tells me "The string '' is not a valid Decimal value".
Null and zero of course mean different things.



I figured out how to handle dates, and I see that I'll have to handle Booleans as well.



Anyone have a generic UD table workflow they'd be willing to share?
Mine works but I'm lazy.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~ www.advancedphotonix.com <http://www.advancedphotonix.com>





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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
How does one properly handle nulls in UD table SC imports? If I don't
supply a '0' it tells me "The string '' is not a valid Decimal value".
Null and zero of course mean different things.



I figured out how to handle dates, and I see that I'll have to handle
Booleans as well.



Anyone have a generic UD table workflow they'd be willing to share?
Mine works but I'm lazy.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
3
Are you just speaking about simply importing mass data to a UD table?
For that Ive had some success with DTS packages... faster and easier to
setup..depends on how you want to trigger it I guess..



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Monday, July 13, 2009 12:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UD Table Import Workflow





How does one properly handle nulls in UD table SC imports? If I don't
supply a '0' it tells me "The string '' is not a valid Decimal value".
Null and zero of course mean different things.

I figured out how to handle dates, and I see that I'll have to handle
Booleans as well.

Anyone have a generic UD table workflow they'd be willing to share?
Mine works but I'm lazy.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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





[Non-text portions of this message have been removed]
4
Yes. I figured I'd keep everything within the Epicor framework.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Monday, July 13, 2009 1:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] UD Table Import Workflow

Are you just speaking about simply importing mass data to a UD table?
For that Ive had some success with DTS packages... faster and easier to
setup..depends on how you want to trigger it I guess..



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Monday, July 13, 2009 12:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UD Table Import Workflow





How does one properly handle nulls in UD table SC imports? If I don't
supply a '0' it tells me "The string '' is not a valid Decimal value".
Null and zero of course mean different things.

I figured out how to handle dates, and I see that I'll have to handle
Booleans as well.

Anyone have a generic UD table workflow they'd be willing to share?
Mine works but I'm lazy.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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





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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links