Dataport will export an extra blank line

robintptsai
Member Posts: 9
The main purpose of this requirement is to export vendor and it's bank account data into file then import into another company after user has revised the file.
I've define 2 dataitems in this dataport (Import = No)
(1)Integer: CONST(1)
(2)Vendor: Vendor Type=FILTER(EMPLOYEE)
(1) to export the field name in first line, set few fields such as Vendor.FIELDCAPTION("No.") in SourceExpr of dataport field
(2) to export all the data, same fields were defined as (1)
It's supposed to export the file with header and data(starts from line 2)
But after running the dataport, there is always a blank line in line 2(nothing in this line), and vendor data starts in line 3
If I remove (1) the vendor starts in line 1 so I guess the problem comes from (1).
(Cause user needs to revised data it's needed to put the field name as header)
What's the extra blank line come from? ](*,)
Is there anybody knows about this kind of problem?
I will be appreciated for any comments.
Robin
I've define 2 dataitems in this dataport (Import = No)
(1)Integer: CONST(1)
(2)Vendor: Vendor Type=FILTER(EMPLOYEE)
(1) to export the field name in first line, set few fields such as Vendor.FIELDCAPTION("No.") in SourceExpr of dataport field
(2) to export all the data, same fields were defined as (1)
It's supposed to export the file with header and data(starts from line 2)
But after running the dataport, there is always a blank line in line 2(nothing in this line), and vendor data starts in line 3
If I remove (1) the vendor starts in line 1 so I guess the problem comes from (1).
(Cause user needs to revised data it's needed to put the field name as header)
What's the extra blank line come from? ](*,)
Is there anybody knows about this kind of problem?
I will be appreciated for any comments.
Robin
0
Comments
-
Have a look at the property "DataItemSeparator" of the dataport... it is set to 2 newlines ( as per default ) so it will add an empty line between the output of the 2 dataitems. change that property to 1 newline, and i think it'll work.0
-
ya it works
thanks a lot my friend0 -
Gr8
What if you wanted to have no Newlines, No spaces.
You know.. What I would expect to get if i left the field empty.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions