Import csv problem

Status
Not open for further replies.

avant-guvnor

New 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

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 

avant-guvnor

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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):



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



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.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 

avant-guvnor

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
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.
Thread starter Similar threads 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 New Slipstick.com Articles 0
N Import Contacts Excel CSV File into Outlook 2010 Using Outlook 2
N Unable to import .csv data into custom form Using Outlook 2
N When I try to import a large CSV from Excel to an Outlook folder, the program crashes... Every time. Using Outlook 2
N Export contacts to .csv to import into Hotmail Using Outlook 15
V Import a CSV file into Outlook calendar Using Outlook 1
F Import Calendar appointments from CSV file Outlook VBA and Custom Forms 3
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
L How to Import Exchange OST file into Outlook? Using Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
Christopher M 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 New Slipstick.com Articles 0
Diane Poremsky How to Import Appointments into a Group Calendar New Slipstick.com Articles 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 New Slipstick.com Articles 0
Diane Poremsky Import Images into the Active Directory New Slipstick.com Articles 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 New Slipstick.com Articles 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
R How to Import Exchange Calendar data to Outlook.com Calendar Using Outlook.com accounts in Outlook 11
R Cannot read Chinese message after import Using Outlook 2
Similar threads


















































Top