Export not showing (street address line 1)

DavidM065
Campaign Collaborator
0 Votes
Create a New Contact 1. Fill in all the fields 2. Export the List 3. Open in Excel 4. Street address line 1 – Home is not there The street address is 88888 Fox Rd Examine the export in text editor shows "88888 Fox RdLF", It appears that the code that generates the export has inserted an unnecessary Line Feed. Please advise.
8 REPLIES 8
DavidM065
Campaign Collaborator
0 Votes

I don't know how to start a new question here so will try this. 

After I take the following steps the export does not have street address line 1

Create a New Contact

  1. Fill in all the fields
  2. Export the List
  3. Open in Excel
  4. Street address line 1 – Home is not there

Hope you can help

 

William_A
Administrator
0 Votes

Hello @DavidM065 ,

 

When I checked the contact in your account, there was no data for that contact field at all, so when exporting it's not going to have any info to fill the applicable cell. 

 

For instructions and visual guidance on what you're trying to do, and how the processes work:


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
DavidM065
Campaign Collaborator
0 Votes

Yeah thanks. That was a made up example of what happens and that contact was removed.

Maybe try the scenario I submitted?

William_A
Administrator
0 Votes

I was still not able to recreate the issue, even when inserting a brand new contact. I also wasn't able to recreate the issue, even with the example address provided in your first post. 

 

Are you sure you're selecting all the contact fields you want on the export pop-up box? What spreadsheet program are you using to view the CSV export?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
DavidM065
Campaign Collaborator
0 Votes

Try looking at jimsmith@nomail.com

If you export the list and open in excel and expand the columns, the address will not show.

If you then double click in the address column of that record, the street address entry will then show. Click somewhere else in the sheet. You will see that that entry is now taking up 2 lines in the sheet because of the hidden LF (LIne Feed).

William_A
Administrator
0 Votes

Gotcha, I guess I didn't really consider it since it's how the system is setup to export. Address street fields will combine into a single address line during exports. So if you don't have anything in the Address Line 2 field, it'll be a blank line in the merged export field.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
DavidM065
Campaign Collaborator
0 Votes

Thanks. It is not a blank line. It has the street address 1 with a Line Feed. In order to get rid of the line feed and display address 1 correctly, each row has to be edited to remove the Line Feed. In my opinion this was poor programming. Address 1 and address 2 should be separate.

 

Thanks.

DavidM065
Campaign Collaborator
0 Votes

After I take the following steps the export does not have street address line 1

Create a New Contact

  1. Fill in all the fields
  2. Export the List
  3. Open in Excel
  4. Street address line 1 – Home is not there

It seems that this does not happen when importing from an Excel file but only when adding a single entry as I show above. It seems like whatever is causing this is not the export itself.

Updates
Just Getting Started?

We’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.

Start Here
Upcoming Webinars
Feb 29
Crafting the Right Content Mix: Ideas to Inspire Your Digital Marketing
2PM - 3PM EST