Import csv problem

Status
Not open for further replies.
avant-guvnor

avant-guvnor

Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I am running Outlook 2016 16.0.9126.2152 32 bit on a Window 10 Pro 64-bit version 1709 (OS Build 16299.371) PC.

If I import into a calendar, the attached csv file (which contains 2 calendar events), the description field in the second event is not parsed correctly .

In the first event the description correctly shows as:
Notes line 01
Brazil, Switzerland, Costa and Serbia
Notes line 03

However the second event incorrectly shows as:
Notes line 01
Brazil, Switzerland, Costa Rica and Serbia Notes line 03

but I am expecting 3 lines, not 2 lines, as shown above. The end of line character (for the 2nd line) is converted to a space character in the second event. The only difference between the 2 description fields is the second event contains Costa Rica and not Costa. This is very bizarre.

Please can someone help/advise?

Please note: I had to change the file extension for the attachment, from csv to txt, to allow the forum software to allow the attachment.
 

Attachments

When i looked at it in Notepad++ and showed the EOL characters, the additional lines had CRLF, not LF. copying the line with LF pasted it as CRLF.

But line length is also a factor -
Brazil, Switzerland, Costa 1 and Serbia worked as desired
Brazil, Switzerland, Costa 12 and Serbia failed/wrapped

if i add a blank line, it works as expected - with a blank line between Serbia and the text 'notes line 3'


notetab.png
 
When i converted the CRLF to LF in notepad++ , it failed to import:
"A file error has occurred in the Comma Separated Values translator while initializing a translator to build a field map." - but the software changed all CRLF to LF, not the lines i wanted changed.

When i used Alt+Enter to add line feeds with the field open in Excel, the second line imported correctly, but like the first line, when i added 'Rica" to the line, it failed/wrapped.
 
I went back to Excel and used the Alt+Enter line feeds and can confirm the EOL character is a linefeed (LF) and the end-of-record character is the Carriage Return+Linefeed combination (CR+LF):

NeEwciN.jpg


On import, the results are the same as my original post:

N86J7aa.jpg


I did report this issue to Microsoft before posting here, but sadly 1st tier support is not fit for purpose.

The technician said there was a problem with my Office 365 installation/Windows 10 PC. I explained that I had also imported the same csv on 2 other totally unrelated windows 10 PCs with the same results. The technician promptly left the support session, never to return.
 
I think its outlook's (stupid) remove line breaks feature. I added 2 spaces at the beginning of the next line and they didn't wrap. I recalled an issue with email and the line wraps - to prevent wrapping you needed to pad the line with extra spaces or... turn off the option to remove line breaks in File, options, Mail - its near the bottom.
 
Diane Poremsky said:
I think its outlook's (stupid) remove line breaks feature. I added 2 spaces at the beginning of the next line and they didn't wrap. I recalled an issue with email and the line wraps - to prevent wrapping you needed to pad the line with extra spaces or... turn off the option to remove line breaks in File, options, Mail - its near the bottom.
Click to expand...

You are correct. Even though I am importing Calendar events, the Mail option is affecting the import.

I went to Outlook Options >> Mail >> Message Format and un-ticked the Remove extra line breaks in plain text messages option and the import works as expected.

What is even more bizarre, is that if the option is ticked again after importing, this eventually causes the format of the description field to change again, to the unwanted formatting regardless of whether the calendar event is saved or not.

Thank you very much for your help.
 
Status
Not open for further replies.
< Deleting Sent Task Email, Deletes the task from my list | Outlook 2013 opens with FILE tab selected. >
Similar threads
Thread starter Title Forum Replies Date
T Outlook 2016 CSV Translator Import Error Using Outlook 6
Diane Poremsky Can't import CSV or move Outlook items into EAS Accounts Using Outlook 0
F Import Calendar appointments from CSV file Outlook VBA and Custom Forms 3
S Import pst file into 365 desktop and have it sync one Using Outlook.com accounts in Outlook 2
C New pc, new outlook, is it possible to import auto-complete emailaddress Using Outlook 5
T How to Export & Import GMAIL Contacts into Outlook 2021 ? Using Outlook 4
W Outlook 365 File access denied attempting to import .pst Using Outlook 6
S Import PST to Office 365 Using Outlook 1
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
J How to import many msg into different public folders in Outlook Outlook VBA and Custom Forms 7
K Disabling import/export button to restrict PST creation Using Outlook 3
I Outlook 365 - import/attach PST file that used POP3 Using Outlook.com accounts in Outlook 0
M Export-Import .pst file problems Using Outlook 2
N .pst archive from work will not open/import on Microsoft 365 Exchange Server Administration 0
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
CWM330 Import Exchange Server Administration 1
R PST->Outlook.com (Import vs Drag-n-Drop methods Using Outlook.com accounts in Outlook 2
DoctorJellybean Import accounts\files Using Outlook 1
S Import contacts to a shared mailbox Outlook VBA and Custom Forms 2
P Import Categories from Outlook 2003 Using Outlook 8
Rupert Dragwater How to import contact list Using Outlook 15
C Import Outlook 2016 contacts into to: field Using Outlook 1
P Import an .ics file to a specific calendar Using Outlook 4
L Need to import multiple Outlook files to Office 365 Account Using Outlook 4
R ost file import Using Outlook 2
T Outlook Calendar 2016 import Excel Using Outlook 1
I Import Office theme .thmx Using Outlook 4
Diane Poremsky Batch Import Photos into Outlook Contacts Using Outlook 0
Diane Poremsky How to Import Appointments into a Group Calendar Using Outlook 0
B Import Excel Text into Outlook Calender Using Outlook 4
M How to Import YES/NO Checkboxes? BCM (Business Contact Manager) 0
J Converted .ost to .pst: Want to Import and Reconnect with IMAP Email Account Using Outlook 2
GregS Import from Outlook.com .ost to IMAP .pst? Using Outlook 3
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
Diane Poremsky Macro to Bulk Import Contacts and vCards into Outlook Using Outlook 0
Diane Poremsky Import Images into the Active Directory Using Outlook 0
M convert/import a customized record into the default "Account" record BCM (Business Contact Manager) 0
Diane Poremsky Macro to Bulk Import vCards into Outlook Using Outlook 0
e_a_g_l_e_p_i question about saving my .pst so I can import it to my Outlook after I build a new system Using Outlook 10
V Import from Outlook 2013 ost file? Using Outlook 2
ogodt Change Default contact form and import from Excel 2010 Using Outlook 1
E Want to Import Outlook 2003 pst files to later version Using Outlook 6
A Does Outlook import Gmail Archive? Using Outlook 1
E PDF Import Using Outlook 1
B Problem with import Excel BCM (Business Contact Manager) 1
bhogesh How to import .htm saved mail to outlook Using Outlook 3
J Easy way to re-import Gmail folders/labels into Outlook? Using Outlook 9
J Opening/Archiving/Import/Export PST files Using Outlook 4
Calvyn Outlook 2003 cannot import .vcs subject Using Outlook 1

Similar threads

Back
Top