Sounds like a good use for an SQL set fields to me
Use the Set fields to fill in the missing data fields into your Pre-Import form
SELECT Nz('$Field1$', Field1), Nz('$Field2$', Field2), Nz('$Field3$',
Field3) from SQL_FORM_VIEW WHERE xxxxx=yyyyy
Nz is the MS-SQL function for Non-Null so if the new data has a value it will
be kept otherwise the original value will be pulled in.
Then just a regular single push will work as all fields have data.
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Reiser, John J
Sent: Tuesday, September 11, 2012 4:05 PM
To: [email protected]
Subject: Data Import Processing.
Hello Listers,
ARS 7.6.03 Build 001
MS SQL 2005
Windows Server 2003 VM
I'm working with a group that needs constant data imports to an asset form in
ARSystem.
To handle this we built a "Pre-Import" form.
Everything gets imported to the Pre-Import form which has filters firing on
merge to see if the asset exists in the ARSystem form. If it exists certain
data is copied to the Pre-import form and used to determine if the asset record
should be updated. If it doesn't exist we just push the Pre-import record
through as a new asset.
Now others want to use this process and they have many more fields to import
but not all of the fields will have data every time.
My dilemma is this, when a record is loaded to the Pre-import form AND it
exists in the asset form, blank fields in the import form clear out the asset
field when merged.
The only way I can think to overcome this is to have a filter per field to
check for $NULL$ and then don't do a filter PUSH on merge for that field.
I'm working on multiple projects at once right now and I just can't wrap my
head around this one.
I don't want to create 40+ filters for this task.
Thank you,
---
John J. Reiser
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
