How to migrate data (.csv) wich include line breaks?

I need to migrate data with line breaks. Data migration manager supports CSV 
files which doesn't allow line breaks. 
I tried to convert all line breaks (CRLF) to "\n" with the result that after 
migration I get "\n" displayed in MS CRM.

My next try would be to convert those "\n" to CRLF in the databse directly, 
although direct changes in the database are not recommended by Microsoft.

Any other ideas?
0
Delaveaux (1)
4/17/2009 10:08:12 AM
crm 35858 articles. 1 followers. Follow

1 Replies
731 Views

Similar Articles

[PageSpeed] 49

I can't generate a sample right now but in your csv you still need to have an 
entire record on a single line.   But if you put quotes around the part that 
has line breaks in it and then keep a line break character of some sort in 
that line I think it should work. 

For example:
First Name, Last Name, Description
John, Doe, "This is a []Description" 

Where the [] would be some sort of line break character. 


"Roman Delaveaux" wrote:

> I need to migrate data with line breaks. Data migration manager supports CSV 
> files which doesn't allow line breaks. 
> I tried to convert all line breaks (CRLF) to "\n" with the result that after 
> migration I get "\n" displayed in MS CRM.
> 
> My next try would be to convert those "\n" to CRLF in the databse directly, 
> although direct changes in the database are not recommended by Microsoft.
> 
> Any other ideas?
0
Taylor (82)
4/24/2009 7:38:01 PM
Reply:

Similar Artilces:

Where is the data menu for sorting lists?
Am trying to sort an address list into alphabetical order. Help says click on list and and select from data menu. When i click no data menu appears. can anyone help please? Thank you. Do you want to tell us what Office program you're referring to, and what version of that program? Daddy "Shakoh" <Shakoh@discussions.microsoft.com> wrote in message news:7E04A2BD-DA32-462B-A912-5469035351C9@microsoft.com... > Am trying to sort an address list into alphabetical order. Help says click > on > list and > and select from data menu. When i click no...

Horizontal Lines/Graphics
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I'm trying to replicate the lines/dividers used in this sample r�sum�: <a href="http://www.resumesandcoverletters.com/Classic_Functional_Resume.pdf">http://www.resumesandcoverletters.com/Classic_Functional_Resume.pdf</a> <br><br>I can't figure out how to position the horizontal lines just right (i.e., I can move them, but they won't drag into exactly the right position I want) and I can't figure out how to make those sideways, stretched-out bracket-looking things. &...

How can stop excel from autochanging my cut and paste data?
Recently I need to copy and paste some data in to my excel for references. However, whichever part I copied containing text like 1-0, 1-2 the text will automatically change to 1/1/2000, Jan 2 etc.... Why is it so? How can I stop that? But when I try to reformat cell to text it becomes code numbers like 36586. Help me please. Thank you. p/s I paste the text in HMTL form if I paste special as unicode text. Hi Try pre-formatting the column as Text. Format>Cells>Text -- Regards Roger Govier "Excel doubter" <Excel doubter@discussions.microsoft.com> wrote in messag...

CSV formatted text file to Excel
Hi all, I am writing a small VC++ application of how to import the CSV formatted ..txt file to excel. I am facing problem while parsing the text file. "TicketNo","CarNo","PersonAge" 12534 , 763534 , 23 12345 , 624333, 24 The problem is in MFC there is a SetValue2(CoeVariant:column data) method in which if i will pass an array(12534) then it will be imported to excel.For example IfI will search for the "employee number" field in text file then the values passed to SetValue2()should be 12543 and 12345.But Using C++ I cannot do so as I...

Separate data string into numeric and text
Hi Can anyone help me with a script, to read in a string of mixed numerical and text data, and separate them to a specific format of spacing. This is the raw data: 11-11-11,44444444,JOE R BLOGGS,2757.42, I need to convert the data into 11111144444444JOE R BLOGGS 2757.42 Firstly i need to remove the "-" and ",", so that it all joins up. There needs to be 6 chars at the start for 111111. At the 7th char i need to leave space for 8 digits (44444444 - although sometimes the no. being read in will be less than this). Then 15 chars must be left for name, and the amount will...

refer to data on multiple worksheets using hlookup/look up data on many worksheets?
Hi I have data on many worksheets in the same workbook. Is it possible to look up data on multiple worksheets using Hlookup, which means can the second argument in the formula refer to multiple sources? If it is not possible, is there any other way I can do so? I would like to select and display data according to a fixed order, whereby the data is located in one of many worksheets in the same workbook. For eg, I have stock returns of many firms in many worksheets. Say I would like to display in a single worksheet the returns of Firm D, Firm Z, Firm R; whereby the data of these 3 fir...

Making sure data is saved on closing application
Hi, I have built myself the following application from 'Teach Yourself Visual C++ in 21 Days' chapter 'Day 14 - Retrieving Data from an ODBC Database' http://serghei.net/docs/programming/c++/ty%20visualC++6%2021%20days/ch14/ch14.htm The application lets you edit and add records to a database (as well as just retreive them). The application uses recordset flags in code to make sure that data is saved if you edit one record and move to another. However, there is no code to make sure new or edited data is saved when the application is exited. After having poked about, I have...

Problems XSLT Transformation of XML Data to EXCEL 2000
Does Office Excel 2000 support XSLT transformation of data from XML cause am having problem when the attachment is opened in the client side if the Excels version is in Office 2000 and also its works fine if the Office Excel Version 2002 and up when attachment file is open via browser the data is in a single line of string in the first row of the excel worksheet Glenn Gomez wrote: > Does Office Excel 2000 support XSLT transformation of data from XML cause am > having problem when the attachment is opened in the client side if the Excels > version is in Office 2000 > >...

How to access data buffers in a completion routine for a KMDF driv
I'm porting a WDM upper filter driver to KMDF version. I have two questions about data accessing in a completion routine. 1. In the completion routine of my WDM upper filter driver, it was able to retrieve data from Irp->AssociatedIrp.SystemBuffer( The IRP is using Method Neither I/O, and the data was set by function driver). How to do this for my KMDF driver? 2. In the completion routine of my WDM upper filter driver, it was able to retrieve data by calling MmGetSystemAddressForMdlSafe(Irp->MdlAddress, NormalPagePriority)( The IRP is using Method Neither I/O, and t...

Two Onenote windows on startup (command line switch)
Hi, I have a dual monitor setup, one being a tablet PC, and wanted to get two Onenote windows ready upon startup: - A normal window, opening my last used file and without full screen - let's consider this one the standard launched window, so it's already there by adding onenote.exe to the startup group, so no issues here. - The second window I would like to be on the tablet, and I believe I could get that extra screen by adding a second shortcut with the /sidenote switch (or can I not? Haven't tried as it's not my ideal scenario), but I would ideally want it to open a new On...

Expense data base
does anyone have a database to track household expenses (utilities, insurance, etc.) http://office.microsoft.com/en-gb/templates/TC102068841033.aspx?CategoryID=CT101428511033&av=ZAC000 Or http://www.microsoft.com/money/default.mspx -- Kevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. "cg" <cg@discussions.microsoft.com> wrote in message news:A799A57F-0129-408E-80A8-346685F420F3@microsoft.com... > does anyone h...

Automatically moving data #4
Thanx for all the help. I'm going to make the file smaller first. Where do I email it to -- multipla ----------------------------------------------------------------------- multiplan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1591 View this thread: http://www.excelforum.com/showthread.php?threadid=27391 Thought I gave you this reply earlier ?? Either to: xdemechanik <at>yahoo<dot>com or demechanik <at>yahoo<dot>com (both valid) -- Rgds Max xl 97 --- GMT+8, 1� 22' N 103� 45' E xdemechanik <at>yahoo<dot>...

Automating transfer of data in cells
I have a time management spreadsheet with data stored against work type and date. I need to transfer this data into a similar but more comprehensive spreadsheet and wonder whether it is possible to automate this task by using the work types and dates in a macro (I have almost 10 months of data to transfer), along the lines of check date, check worktype, where argument is true enter data from cell. I think I need to use visual basic, but I can't find out how in the help screens. Any advice is much appreciated. This is not difficult providing you keep your data in simple tables...

CRM 4.0
Hi How does one configure a WF Local Service / Data Exchange Service in CRM 4.0? In a custom WF host I can accomplish this by specifying the service in the host application's configuration file. Is this approach possible with CRM 4.0? I understand that the workflow runtime is hosted by the CRM Asynchronous Service, and I have been able to register custom WF Activity as detailed in the CRM SDK documentation. However I can find no references to registering / configuring a local service. Any help much appreciated! Regards, Gareth On Oct 23, 1:38=A0pm, rgdav...@gmail.com wrote: > H...

Saving data #2
Hi all, I need to save data (results) from a base spread sheet program that i use on a weekly basis. i am in the middle of building this program, and have just discovered macros, but this, along with links is about my current knowledge of excel how can i automate to accumulate data from the base spread sheet (program) when i clear all data from the program to produce fresh results the following week, and to keep past data up to date and available for further use. Any help would be appreciated. legepe With a combination of formulas and dynamic named ranges, it is possible to just add the ...

Importing data via macro
Hi, I want to create a macro, which let me automate the process of importing the data from various files (*.xls) from a particular directory to the main table in MS Access. My Main table in access is called Wire Transfer Main table. And every Monday few specialist go in a share drive and post their completed forms in ..xls format. My macro should go into that shared directory every week and pull out the files from that directory and copy the data from those files to my Wire Transfer Main Table in access database. Please help. Thanks Liz - you're probably better off if you writ...

Adding data from another sheet.
I hope I can find some help on this one. I have a spreadsheet that consists of two sheets. The first is a form. The second is a list of questions. I have added a checkbox next to each question on sheet 2 to select the question and add it to the form on sheet 1. The problem: when you select a question on sheet 2 it will only add it to a specific cell on sheet 1. So if I select question 15 it will go in a position like it is the 15th question when actually I would like it to be the first question. The question: Is there a way to make the questions start adding to the top cell on sheet 1...

Parse multiple text lines into 1 line in excel
help. I am an excel beginner and can't find out how to turn multipl lines of text into 1 row in excel. It's probably really easy but m manual is USELESS. Can anyone help ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com debbie You're a little short on details. If nothing below fits the bill post back. "Multiple lines" is how many and is each line in a separate cell down one column? Do you want all lines to go into one cell? You can use this form...

Vertical Page Break
Is it possible to force a vertical page break on a report? For example, I have a report that is 20 inches across, and I would it to "break"/start the new page at 10 inches. Now, fiddling with the page setup and page layout is fine when I am working with only one printer, but the formatting gets slightly messed up when I am printing across different printers, to PDF, etc. Any ideas on how this vertical page break can be done? Thanks! that sure would be nice to have I'd reccomend just putting the page 2 below page 1.. and use more subreports if you run out of room On ...

Get Access Data into Excel
Hi All, I am using excel macro to get data from access database. My sql query gives me 5 records or more than that. I am able to pull it different cells. But I want all the 5 results in single cell. Please help im not exactly sure what your trying to do, but maybe something like this will do the trick dim accval as string accval=rs!:XXX rs.movenext accval=accval & " " & rs!:xxx loop it till rs.eof=true hth dmoney "fi.or.jp.de" wrote: > Hi All, > > I am using excel macro to get data from access database. >...

Cut'n'Pasting data
Greetings ! I have a CSV data file wot looks something like this - "1529.17698720957","133.597550559965" "1685.21901149326","132.817184396522" "1900.00000000000","130.300887834893" "2193.34485206410","121.730777157435" "2363.17295960769","114.937652855693" "2523.01169878763","108.544103288496" "3240.77088467590","87.805735336415" "3590.69860622591","81.680775462264" "4229.19543928027","78.487652800160" This data i...

Help Fixing Data on Item Stock Status display
GP 8.0, SQL Had an employee "sell" 9,000,000,000 units of an item at $0 price. Instead of deleting the line, he $0 the price. The invoice was posted. I discovered when our income statement showed a loss of $42b! My first mistake was to try and reverse by creating a return for the same # of units at $0 price. But somehow this created problems with the inventory. Basically, I messed around with it with a number of invoices/inventory adjustments. I discovered how to void the RTN and INV using utility > sales > remove sales history. This had the desired effect with one exc...

Drill down pivot table data via VBA macro
I am trying to create a macro that will drill down subtotals from a pivot table. Since the number of rows, and colums, changes frequently I need to reference the total for the row or column. Can this be done via VBA macro? -- jmon76 ------------------------------------------------------------------------ jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=204538 http://www.thecodecage.com/forumz Excel 2007 PivotTable Show subtotal details via macro. Define subtotal with PivotField...

Data from Form to Subform to Table
I have a main form for material inspection, and another form for the inpsection results, and tables for each that store the data. For example, you have to enter the PO# and P/N on the main form, as well as some other info, then you click to open up the inspection results form in datasheet view. The inpsection results form shows the PO# and P/N that you entered on the main form, but it wont store the info in the table for the inspection results. Can someone please help me figure out how to get the info to store in the inspection results table as well as the material inspection tab...

Fuzzy matching data
Hi I have two spreadsheets of similar property data, and Im trying to create a formula in spreadsheet A that will look in spreadsheet B, find the matching property data then return corresponding data to spreadsheet A. Im using the Index formula for this and name ranges, and everything works fine if the property data in spreadsheet A exactly matches spreadsheet B. If there is a slight difference it falls down e.g. spreadsheet A property named '28 St Marks House', spreadsheet B property named 'Flat 28 St Marks House'. Does anyone know of a matching/lookup/index method that...