Upload de Dados da Linha de Serviço de Chumbo

KathleenP

Estou tentando usar a Solução de Inventário da Linha de Serviço de Chumbo, mas estou tendo problemas com a Ferramenta de Carregamento de Dados para fazer upload de um inventário excel existente com milhares de pontos. No Espaço de Trabalho de Carregamento de Dados, consigo corresponder minhas colunas de origem às colunas de destino, mas o conteúdo dos "materials" não está sendo lido no destino, mesmo que tenham a mesma configuração (Non-Lead Other, Unknown - Material Unknown, etc). Isso está causando para que as colunas "status" não sejam calculadas, levando a simbologias em branco.<\/P>

 <\/P>

Eu verifiquei os scripts Python e eles não são as mesmas linhas de código que são manipuladas no webinar "Using the Lead Service Line Inventory Solution". Não há nenhuma linha para calcular o "status".<\/P>

 <\/P>

Como posso fazer com que os materials sejam lidos corretamente no destino?<\/P>

AlexKabak

Hi Kathleen,

The only way the status fields will be calculated from the material fields in the Data Loading Tools is by adding the python functions to the base.py file. The calculate_utility_status and calculate_customer_status functions seen in the video you referenced do not come with the Data Loading Tools out of the box, they were added in manually after the Data Loading Workspace was created. They are also out of date at this point as there are references to fields and values that have since been updated.

Attached are updated versions of the calculate_utility_status and calculate_customer_status functions in a text file. You can copy and paste the functions to the bottom of your base.py file and reference them in the DataMapping excel sheet the same way the video does.

Once the data has been loaded, be sure to look at all of the Galvanized Requiring Replacement service lines to see if they are currently, or were at some point, downstream of a lead service line. If they have never been downstream, then they don't require replacement and the status can change to Non-Lead. 

I hope this resolves your issue for loading your data.

 

LSLI_status_functions.txt