B: Family Import creating additional BLANK previous address

[hkvogeler]

Prerequisites

We will take your suggestion into consideration, however, if you would like to sponsor this change, please email [email protected] and we will process an estimate for you.

Otherwise, bugs will be addressed in the order of criticality, and enhancements will be addressed as sponsored, or as we have the available bandwidth. Note: Our code may not be vetted for, and may not support early release Rock versions only general release Rock versions.

Please answer the following questions for yourself before submitting an issue.

• [ X] I have classified my issue according to the following rules:

Bug Classifications:

Enhancement: A desired change to the code that enhances functionality verses fixing an issue.

Bug: Updating code to work as originally designed.

• [X ] I am running the latest version
• [X ] I checked to make sure that this issue has not already been filed
• [X ] I've named my issue either B: or E: depending on whether it is a bug or an enhancement

Expected Behavior

02 - Family import from CSV to create only address if fields are not null

Current Behavior

Current address is created and a BLANK "Previous Address" is created.

Failure Information (for bugs)

Please help provide information about the failure if this is a bug. If it is not a bug, please remove the rest of this template.

Steps to Reproduce

Please provide detailed steps for reproducing the issue.

1. Imported csv file of 01 - individuals
2. imported csv file of 02 - families

Context

Please provide any relevant information about your setup. This is important in case the issue is not reproducible except for under certain conditions.

• Rock Version: 10.2
• Bulldozer Version: newest release
• SSQL Server Version: 15.0.2000.5
• Windows Version: Windows Server 2019 Standard

Failure Logs

Please include any relevant log snippets or files here.

[lauweijie]

Are there any active plans to have this fixed?

[carlatKFS]

Jonathan,

At this time, we are working other priorities.
If you are interested in getting an estimate to have this issue prioritized and worked, please contact [email protected].

[hkvogeler]

Jonathan
feel free to email me [email protected] or connect on the Rock Community.
If you're comfortable with SQL I can show you how to find & remove the blank ones via SQL command ... but a word of caution, this is directly done on the table and you or someone on your team should be comfortable with this type of operation/commands.
Kurt

[lauweijie]

@hkvogeler I dropped you an email some time back, did you receive it?

[treyhendon]

Hey all, I just looked for this result while testing the sample data in a v11 update branch, and do not see this happening. Was it possible that some special character or even the word null was in the source CSV data that caused the issue?

[hkvogeler]

That’s what I thought until I checked some of our csv files and the second address fields were all empty. Nice perfect row of commas ,,,, H. Kurt Vogeler, SPHR, SHRM-SCP Director of Human Resources Email: [email protected]<mailto:[email protected]> Office: 806.677.1005 * Fax: 806.463.2623 [TF_Logo] www.TFC.org<http://www.tfc.org/> * 806.355.8955 * 5000 Hollywood, Amarillo, TX 79118 From: Trey Hendon <[email protected]> Sent: Tuesday, December 1, 2020 1:50 PM To: KingdomFirst/Bulldozer <[email protected]> Cc: Kurt Vogeler <[email protected]>; Mention <[email protected]> Subject: Re: [KingdomFirst/Bulldozer] B: Family Import creating additional BLANK previous address (#35) Hey all, I just looked for this result while testing the sample data in a v11 update branch, and do not see this happening. Was it possible that some special character or even the word null was in the source CSV data that caused the issue? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FKingdomFirst%2FBulldozer%2Fissues%2F35%23issuecomment-736779118&data=04%7C01%7Ckurtvogeler%40tfc.org%7C4e1ac23bfa35478a42ec08d89632436d%7C34753197579846fbb6b910109ad07ff9%7C0%7C0%7C637424489923952614%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ZgBffSbkZDfh5DUsiKmvffbM4DoCyL4hLtCyD2fFR74%3D&reserved=0>, or unsubscribe<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAP2DJWN5LM3QVY7U3RFKWFLSSVCF3ANCNFSM4OPE46YQ&data=04%7C01%7Ckurtvogeler%40tfc.org%7C4e1ac23bfa35478a42ec08d89632436d%7C34753197579846fbb6b910109ad07ff9%7C0%7C0%7C637424489923962603%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=dCqhUI%2B0iYMPgv6DU54Gyb%2B9QHEa3iVTBBuBKFYs4rw%3D&reserved=0>.