Sage 100

I am looking for a mechanism to ignore blank fields when importing changes to existing records.  The import job is set to map to each column in a spreadsheet but if the column is blank on that record we need to ignore it.  By default the existing field imports the blank.  If the column is populated we will overwrite the change to that field.  Having difficulty finding the trick for this.

------------------------------
alan niergarth
Velosio LLC
------------------------------

One temp field per data field.  Set each Sage field condition to when the associated temp field is not blank.  Don't use numeric temp fields... string only to avoid ignoring true zero values.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Alan - You can conditionally Replace the field that is potentially blank. For example let's say you're importing into AR_Customer and EmailAddress on Col 8 may be blank in the spreadsheet. So on Data tab for EmailAddress do your Replace but then on the Condition field add that expression below. It simply means import only if Column 8 is not blank. You can alternatively use TEMP fields for this purpose like Kevin mentioned where instead of IMP$[8] you key in TEMP001$ or whatever the appropriate temp field number is.

NOT(NUL(IMP$[8]))

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA
------------------------------

Original Message:
Sent: 03-04-2021 17:32
From: Kevin Moyes
Subject: VI - Ignoring blank fields when importing to existing records?

One temp field per data field.  Set each Sage field condition to when the associated temp field is not blank.  Don't use numeric temp fields... string only to avoid ignoring true zero values.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

why I love this group.  thanks @Kevin Moyes and @Alnoor Cassim for the input.  ​​my inventory description column was blank.  field skipped using conditional suppression syntax.  



------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 03-04-2021 23:21
From: Alnoor Cassim
Subject: VI - Ignoring blank fields when importing to existing records?

Alan - You can conditionally Replace the field that is potentially blank. For example let's say you're importing into AR_Customer and EmailAddress on Col 8 may be blank in the spreadsheet. So on Data tab for EmailAddress do your Replace but then on the Condition field add that expression below. It simply means import only if Column 8 is not blank. You can alternatively use TEMP fields for this purpose like Kevin mentioned where instead of IMP$[8] you key in TEMP001$ or whatever the appropriate temp field number is.

NOT(NUL(IMP$[8]))

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA
------------------------------


Original Message:
Sent: 03-04-2021 17:32
From: Kevin Moyes
Subject: VI - Ignoring blank fields when importing to existing records?

One temp field per data field.  Set each Sage field condition to when the associated temp field is not blank.  Don't use numeric temp fields... string only to avoid ignoring true zero values.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON

That is a nice shortcut!

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 03-04-2021 23:21
From: Alnoor Cassim
Subject: VI - Ignoring blank fields when importing to existing records?

Alan - You can conditionally Replace the field that is potentially blank. For example let's say you're importing into AR_Customer and EmailAddress on Col 8 may be blank in the spreadsheet. So on Data tab for EmailAddress do your Replace but then on the Condition field add that expression below. It simply means import only if Column 8 is not blank. You can alternatively use TEMP fields for this purpose like Kevin mentioned where instead of IMP$[8] you key in TEMP001$ or whatever the appropriate temp field number is.

NOT(NUL(IMP$[8]))

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA
------------------------------


Original Message:
Sent: 03-04-2021 17:32
From: Kevin Moyes
Subject: VI - Ignoring blank fields when importing to existing records?

One temp field per data field.  Set each Sage field condition to when the associated temp field is not blank.  Don't use numeric temp fields... string only to avoid ignoring true zero values.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON