Data conversion tool

Yahoo Archive
1
Hello again,
Scratch that last request for help. I figured it out.
In case there's any interest in the solution, the problem was that I
added a column without making it part of a "named range" in Excel, so
the conversion tool could not see the column I added.
To name a range in Excel: highlight the range of cells, choose
Insert - Name - Define and type in a name for the range. You then need
to use that range name in the Source Query field on the Query Tab of
the Data Conversion Tool and voila...everything is hunky-dory...

Thanks for stopping by....

Darryl Whitelock
Dinn Brothers, Inc.

--- In vantage@yahoogroups.com, "Darryl Whitelock" <dwhitelock@d...>
wrote:
>
> Hello everyone,
> I'm having a problem with the Epicor Data conversion tool. We are
> using Vantage 6.10.514.
> I set up an ODBC connection to an Excel spreadsheet that contains
> the data I want to import. I set up a connection and query in the
data
> conversion tool. I know it works properly because I can click the
> Results button on the Query tab and it shows up properly.
> Here's the problem: I wanted to add another field to import into
> Vantage. So I edit the spreadsheet, put in the column I want, name
the
> column, and put in the data that I want to exist in that field for
> each record. I save the spreadsheet, open the data conversion tool,
> the proper connection and query. On the query page, I add the new
> column/field name into the Source Query Select box and click
Results.
> I get the column headings, but no data.
> Now, according to the documentation I have, if that happens it
means
> there's a problem with the source data. Just for ha-ha's, I remove
the
> new column/field name from the Source Query Select box, and click
> Results. Sure enough, all the data shows up properly, minus the
column
> that I added in the spreadsheet (which really is what I would
expect).
> My first thought is there's something wrong with the column I added,
> but it's formatted as text and I verified the column is formatted
like
> the other columns.
> From what little I've read about the data conversion tool in this
> newsgroup, it seems to be flaky. Hopefully some one here has had a
> similar problem and will be able to help out or have other
> suggestions.
>
> TIA and Happy Holidays!!
>
> Darryl Whitelock
> Dinn Brothers, Inc.
2
Hello everyone,
I'm having a problem with the Epicor Data conversion tool. We are
using Vantage 6.10.514.
I set up an ODBC connection to an Excel spreadsheet that contains
the data I want to import. I set up a connection and query in the data
conversion tool. I know it works properly because I can click the
Results button on the Query tab and it shows up properly.
Here's the problem: I wanted to add another field to import into
Vantage. So I edit the spreadsheet, put in the column I want, name the
column, and put in the data that I want to exist in that field for
each record. I save the spreadsheet, open the data conversion tool,
the proper connection and query. On the query page, I add the new
column/field name into the Source Query Select box and click Results.
I get the column headings, but no data.
Now, according to the documentation I have, if that happens it means
there's a problem with the source data. Just for ha-ha's, I remove the
new column/field name from the Source Query Select box, and click
Results. Sure enough, all the data shows up properly, minus the column
that I added in the spreadsheet (which really is what I would expect).
My first thought is there's something wrong with the column I added,
but it's formatted as text and I verified the column is formatted like
the other columns.
From what little I've read about the data conversion tool in this
newsgroup, it seems to be flaky. Hopefully some one here has had a
similar problem and will be able to help out or have other
suggestions.

TIA and Happy Holidays!!

Darryl Whitelock
Dinn Brothers, Inc.