Importing MatchFinder results

Kristin LaBolt

Greetings from Hanover College!

We recently subscribed to the MatchFinder service and just received our results.  According to support, we should dump the results into constituent attributes. The data file has a lot of information, a lot more than the 10 attributes I am being told to add.  To top it off, the results come in a .txt file, not a .csv that we are used to. I have never imported a text file.  Does anyone have any suggestions, as I am not happy with the responses from support? 

Thanks!!

Kristin LaBolt

Advancement Services Coordinator

labolt@hanover.edu

Aaron Rothberg

Hi Kristin-


If you open the text file, are there characters separating the values? I ask because if you were to open a CSV in a text editor, it would look like a TXT file. Similarly, the TXT file might be comma delimited in which case you can simply change the extension to CSV. Can you post a small screenshot of the TXT file replacing any sensitive information with dummy data?

Kristin LaBolt

The file is set up as tab separated.  I have reached out to the Blackbaud guy that sent the file, and he said there is a problem with the file. So its not just me! Yay! 


 KeyInd    ImportID    ORGNAME    AliasName    ADDRIMPID    ADDRLINES    ADDRCITY    AddrState    AddrZip    AddrType    PhoneType    PhoneNum    PhoneType    PhoneNum    OrgMatch    MtcFactor    MTCNotes    MinMtcPer    MaxMtcPer    MaxMtcAnn    IRRelat    IRRecip    IRLink    IRFirstName    IRLastName    IRSuff1    IRPos    IRISContact    IRContactType    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate    CattrImpID    CattrCat    CattrDesc    CattrCom    CattrDate

O    15982-BUS        Telegraph    ADDR_15982-BUS    6111 W. Plano Parkway/nSuite 1000YC    Plano    TX    75093    Matching Gift    MG Phone    8667516031    MG Email    ATT-Support@yourcause.com    Y    1    AT&T Foundation will match employee donations to Team Rubicon and to the AT&T Employee Disaster Relief Fund, which supports employees who live in the areas affected by recent storms.  These contributions will fund immediate and ongoing support in communit    50    15000    15000.0                                                 ATT1_15982-BUS    Employee    EL02         07/27/2018    ATT2_15982-BUS    EDUCATION    EE01,EE02,EE03,EE05,EE06,EE07         07/27/2018    ATT3_15982-BUS    Procedure    PR03        07/27/2018    ATT4_15982-BUS    Athletics    AT02         07/27/2018    ATT5_15982-BUS    Affiliation    AF01         07/27/2018    ATT6_15982-BUS    Other    OT01,OT02,OT03,OT04,OT05,OT07,OT08,OT09,OT11         07/27/2018    ATT6_15982-BUS    Distribution    DS02         07/27/2018    ATT7_15982-BUS    Restrictions    REST02         07/27/2018    ATT7_15982-BUS    Program Guide    https://s3.amazonaws.com/documents.yourcause.com/att/Faq_en-us.pdf         07/27/2018    ATT8_15982-BUS    Online Form    https://att.yourcause.com/         07/27/2018

 

Aaron Rothberg

Sounds like they are going to help you out. You could convert a tab delimited to a comma delimited, but I would follow the course you're following and tell them you want them to re-send the file in CSV or XLSX.

Austen Brown

Kristin LaBolt:

Greetings from Hanover College!

We recently subscribed to the MatchFinder service and just received our results.  According to support, we should dump the results into constituent attributes. The data file has a lot of information, a lot more than the 10 attributes I am being told to add.  To top it off, the results come in a .txt file, not a .csv that we are used to. I have never imported a text file.  Does anyone have any suggestions, as I am not happy with the responses from support? 

Thanks!!

Kristin LaBolt

Advancement Services Coordinator

labolt@hanover.edu

I would convert your .txt file into a .csv file.  You can do this by going to an empty excel document and importing the information in.  That way you can see exactly what will be imported, and what fields it is slated to be imported into.  If you have any other questions, feel free to PM me - I went through this last year when we were subscribed to this service.