Mass update user defined fields?

Yahoo Archive
1
Service connect can talk to the UD tables.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
kenjirak
Sent: Wednesday, July 22, 2009 7:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Mass update user defined fields?





Wow,
Sounds like it is a little more than I am capable of at this point.
Thank you for the reply!

Ken
--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, Steven
Gotschall <sgotschall@...> wrote:
>
> Its possible, but not straight forward. I've done this two different
ways.
>
> One way is to use ODBC (or JDBC if you use something like Squirrel SQL.
Generally speaking you should not update or change anything in Vantage
through ODBC, but as long as you are confidant that the only thing you are
touching are UD fields, then there shouldn't be a problem.
>
> Another way is through 4GL code. You would have to create a "trigger" to
run the code and then have it loop through your table updating the records
using a updatetablebuffer call.
>
>
>
>
> ________________________________
> From: kenjirak <kenjirak@...>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Tuesday, July 21, 2009 4:50:11 PM
> Subject: [Vantage] Mass update user defined fields?
>
>
> Does anyone know if it is possible to do a mass update of user defined
fields?
> We are looking to create some customizations in customer Maint and Ship to
screens that will hold some special customer ranking information. It would
be beneficial if we could mass update these fields using an Excell
spreadsheet (similar to the "Customer/Contact Import" process). If there is
a way to do this I would like to build it into the customization prior to
deploying.
>
> We are running V8.03.406A
>
> Thank you,
> Ken
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
Does anyone know if it is possible to do a mass update of user defined fields?
We are looking to create some customizations in customer Maint and Ship to screens that will hold some special customer ranking information. It would be beneficial if we could mass update these fields using an Excell spreadsheet (similar to the "Customer/Contact Import" process). If there is a way to do this I would like to build it into the customization prior to deploying.

We are running V8.03.406A

Thank you,
Ken
3
Its possible, but not straight forward. I've done this two different ways.

One way is to use ODBC (or JDBC if you use something like Squirrel SQL. Generally speaking you should not update or change anything in Vantage through ODBC, but as long as you are confidant that the only thing you are touching are UD fields, then there shouldn't be a problem.

Another way is through 4GL code. You would have to create a "trigger" to run the code and then have it loop through your table updating the records using a updatetablebuffer call.




________________________________
From: kenjirak <kenjirak@...>
To: vantage@yahoogroups.com
Sent: Tuesday, July 21, 2009 4:50:11 PM
Subject: [Vantage] Mass update user defined fields?

Â
Does anyone know if it is possible to do a mass update of user defined fields?
We are looking to create some customizations in customer Maint and Ship to screens that will hold some special customer ranking information. It would be beneficial if we could mass update these fields using an Excell spreadsheet (similar to the "Customer/Contact Import" process). If there is a way to do this I would like to build it into the customization prior to deploying.

We are running V8.03.406A

Thank you,
Ken







[Non-text portions of this message have been removed]
4
Wow,
Sounds like it is a little more than I am capable of at this point.
Thank you for the reply!

Ken
--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> Its possible, but not straight forward. I've done this two different ways.
>
> One way is to use ODBC (or JDBC if you use something like Squirrel SQL. Generally speaking you should not update or change anything in Vantage through ODBC, but as long as you are confidant that the only thing you are touching are UD fields, then there shouldn't be a problem.
>
> Another way is through 4GL code. You would have to create a "trigger" to run the code and then have it loop through your table updating the records using a updatetablebuffer call.
>
>
>
>
> ________________________________
> From: kenjirak <kenjirak@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, July 21, 2009 4:50:11 PM
> Subject: [Vantage] Mass update user defined fields?
>
> Â
> Does anyone know if it is possible to do a mass update of user defined fields?
> We are looking to create some customizations in customer Maint and Ship to screens that will hold some special customer ranking information. It would be beneficial if we could mass update these fields using an Excell spreadsheet (similar to the "Customer/Contact Import" process). If there is a way to do this I would like to build it into the customization prior to deploying.
>
> We are running V8.03.406A
>
> Thank you,
> Ken
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>