← back to Rentv Sheet Enrich
__pycache__/preflight_matches.cpython-314.pyc
28 lines
+
�f�j� � �h � R t ^ RIt^ RIt^ RIt^ RIt^ RIt]P P ^ ]P P ] 4 4 ^ RI
t
Rt Rt R t
]
P ! 4 t]
P ! ]] 4 t]! R ]! ]! ^]! ]4 4 4 4 ^ 4 t]], tR t]! R4 ]! R4 ]! R 4 utttR
t / t ]! ]^, ]! ]4 4 Fb t ]
! ] ! ] ]4 4 ]
! ] ! ] ]4 4 3t ] ^ , ' g ] ^, ' g KA ] PA ] . 4 PC ] 4 Kd ^ ;t";t#t$]%! ]P
! R 4 4 EF� t&]PN ! ](! ]&4 4 EFd t)]
! ])PU R R
4 4 ]
! ])PU RR
4 4 3t+] PU ]+4 t,],' g| ] P[ 4 U UUUu. uFZ w w rq!' g K V]+^, 8X g K! ]+^ , ' g K2 ]+^ , V 9 g V ]+^ , 9 g KP V F q3NK K\ upppp t,])PU RR
4 t.],' g+ ]/! R]. R])PU R R
4 24 ]$^,
t$EK ],^ , t0] ! ]0]4 ' d# ]/! R]. R]0^, R24 ]#^,
t#EKF ]/! R]. R]0^, 24 ]"^,
t"EKg EK� ]/! R]" R]# R]$ R24 ]/! R]1! R ]! ]^, ]! ]4 4 4 4 24 R# u upppp i ) u� Dry-run: for every staged fanout_batch*_result_navfix.json, resolve each entry against
the LIVE sheet exactly like write_by_contact.py would (by normalized company+name), and
report matched-row / cell-empty / would-write — WITHOUT writing anything.Ni W: zUnique Contacts (all tabs)c �b � \ P ! R RT ;' g RP 4 4 # )z [^a-z0-9]� )�re�sub�lower)�ss &�preflight_matches.py�normr s! � �B�F�F�<��a�g�g�2�_�_�->�?�
?� c # � " � T F= p\ \ V, 4 F w r#VP 4 R 8X g K Vx � K" K? R# 5i)� Contact NameN)� enumerate�rows�strip)�.0�i�j�vs & r � <genexpr>r s6 � � �
i�-���4��7�9K�#�!�q�w�w�y�Zh�Oh�1�1�9K�1�-�s
�2A�Ac �\ a � \ V 3R l\ \ \ 4 4 4 R4 # )c 3 � <" � T F> q\ \ 4 8 d \ V, MR P 4 S8X g K: Vx � K@ R# 5i)r N)�len�hdrr )r r �ls & �r r �hidx.<locals>.<genexpr> s3 �� � �b�_��S��X�:��Q��SU�8\�8\�8^�`a�8a�!�!�_�s
�7A �
A N)�next�ranger r )r s fr �hidxr s �� �D�b�U�3�s�8�_�b�cg�h�
hr
r z
Company/VenuezLinkedIn (Contact)c �� � VeR V \ \ 4 8 d> V\ \ V , 4 8 d# \ V , V, P 4 # RP 4 # )Nr )r r r )�rr s &&r �cellr sD � �Q�]�q��T��{�q��T�RS�W� �~�t�A�w�q�z�d�d�f�f�[]�d�d�f�fr
z%data/fanout_batch*_result_navfix.json�companyr �namez
UNMATCHED z @ z
filled z (row z already has LinkedIn)z
WILL WRITE z -> row z
SUMMARY: z
will write, z already filled, z
unmatchedz$Current LinkedIn(Contact) nonempty: c # �V " � T F p\ V\ 4 ' g K ^x � K! R# 5i)� N)r �LIC)r r s & r r r " s � � �0a�<Q�q�UY�Z[�\_�U`���<Q�s �)�
))2�__doc__�sys�osr �json�glob�path�insert�dirname�__file__�lib�GID�TITLEr � access_token�tok�read_tabr r r �minr �hrr r �NAME�COr% r �idxr �k�
setdefault�append� would_write�already� unmatched�sorted�f�load�open�it�get�key�tgt�items�nm�print�r0�sum)�corI �rsr s 0000r �<module>rO s� ��O� � � � ������2�7�7�?�?�8�,� -�
�
��3�u� ?� �����
�|�|�C�� �� �
i�e�C��#�d�)� ,�-�
i�jk�l��
�2�h�� h��>�"�4��#8��>R�9S� ��R�� f��� �r�!�t�C��I� �A� �D��2�J���T�!�D�\�*�+�A���t�t�q��t�t�S�^�^�A�b�)�0�0��3�
� � � � �G�I� �� � �A�B� C�A��i�i��Q�� ��
�"�&�&��2�&�
'��R�V�V�F�2�->�(?� @�� �G�G�C�L���%(�Y�Y�[� A�[�z�w��r�B��2�s�1�v�:��#�a�&�&��VY�Z[�V\�`b�Vb�fh�lo�pq�lr�fr��}�xy��}��[� A�C�
�6�6�&�� ���E�M�"��S���� �"�1E�0F�G�H�)�UV�,�)�X`� �q�6�� ��3�<�<�� �r�d�&��A���>T� U�V�X_�ab�Xb�X_��m�B�4�x��1��v�6�7��a� �� !�
D� � �K�=�
�g�Y�6G� �{�R\�]� ^� �,�S�0a�E�"�Q�$�s�4�y�<Q�0a�-a�,b�c� d�� As � L,�3 L,� L,�L,�2L,