Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] IWay DM Tool Data Coversion Automatically To Date Format as Excel
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] IWay DM Tool Data Coversion Automatically To Date Format as Excel
 Login/Join
 
Member
posted
Hi I am using Data Migrator Tool reading the data from Excel by using Excel Adapter the values shown in Excel with number followed by Single Quote (') stays as number in Data Management Console after sampling the data from Excel as it assigns Alpha fixed in bytes as data type but it changes all the other numeric data as it type it text to Date

for Example

Data in Excel Data in Data Management Console after Sampling

'001 001

101 04/10/1900

As data in Excel saves as text type for both single quote or without but one with single quote stays the same as it need to be but on the other hand without quote change to date format instead of keep the same data and it assigns Alpha fixed in bytes as data type in Data Management Console

Did any body know how to fix this issue at Data Migrator level , what the workaround about this issue ?

This message has been edited. Last edited by: Tamra,
 
Posts: 3 | Registered: June 02, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
Hi Najam,

Welcome to Focal Point.

While we wait for other members to reply to your request:
IWay Data Migrator Tool Data Coversion Automatically To Date Format as Excel as Sourc .
This sounds like something a case should be opened for and that way if this is a real issue it can be tracked properly.

Please keep us informed if you do open a case and what the resolution is. Other members will be interested in hearing the outcome.

Thank you for participating and sharing in Focal Point.

Kindest regards,
Tamra Colangelo
iWay Focal Point Moderator


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] IWay DM Tool Data Coversion Automatically To Date Format as Excel

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.