Vantage 8.03 - Labor Collection import to Vantage

We have the very same issue but with 6.1. We have invested very heavily in a Time & Attendance and labor collection system and use the Vantage labor collector and gateway to process the transactions right into Vantage . The labor collector and gateway were offered with the TT5 labor collection units direct from Epicor. It processes the labor & time records properly right into Vantage from a ".dbf" file. But in their misguided wisdom, Epicor discontinued the labor collector and gateway with version 8. If we (V-S Industries) are unable to get a labor collector & gateway functionality / ability to import data into the LaborTran table, V-S industries will be done paying maintenance to Epicor and will not migrate to 8.03 or beyond because or shop operations depend very heavily on our data collection system. If we can't get support to move that functionality forward, I wont have a choice but to stop my association with Epicor. The data collection function in Vantage is not designed well of our needs, and we found a system that works great for us and has become mission critical for our operations; hence, V-S Industries needs the ability to import and properly populate that data seamlessly into Vantage. I am still waiting on Epicor on incident /call # 2392724MPS.

I truly hope that Labor collector & gateway functionality are carried forward to 8.03. Epicor needs to realize that there are companies out there like Kronos Workforce & Sage Abra that do such a better job than they do at data collection and would be a more flexible Vantage product by allowing for generic importation of labor data... I hope Epicor will allow us users to utilize the better products on the market for our data collection needs.

Rick Joslin
V-S Industries, Inc.
900 Chaddick Dr.
Wheeling, IL 60090
847-520-1800 ex.206
Fax 847-520-0269
Re: Vantage 8.03 - Labor Collection import to Vantage
Posted by: "lapulsifer" sharon.pulsifer@...
Wed Jun 13, 2007 5:08 am (PST)
Thanks for all the responses. We are not live on Vantage 8.03 yet.
Our go live is planned for January 1st.

Believe it or not, Kronos Worforce was not as expensive for us as for
other people I have talked to. The whole suite was probably only 4
times the cost of Service Connect.

The most desirable option for me would be to push the data directly
into the Labor Header and Labor Detail tables.

I'm sure that I can handle the constraints. I'm not sure that I know
all the application triggers or any other tables that may be effected.

If your company is doing a direct import, I am looking for any
suggestions about things that I may not think about. Are there any
other tables involved other than Labor Header and Labor Detail. Are
there any triggers that happen when a labor record is added?

I would definitely rather buy Service Connect than to corrupt the
database!!

Thanks again for all the responses.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>, "Jason Claggett" <jason@...> wrote:
>
> Our team typically does a direct import into the database. If you
can
> export your Timekeeper data out then you should be able to do this.
>
>
>
> Just need a quick clarification. Are you using SQL Server with
Vantage
> 8.03? If yes, what version of SQL Server?
>
>
>
> Thanks,
>
>
>
> Jason Claggett
>
> Microsoft Small Business Specialist
>
> MCP #3856159
>
> 2W Technologies, LLC
>
> 317.578.2393
>
> jason@...
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>] On
Behalf
> Of lapulsifer
> Sent: Tuesday, June 12, 2007 12:38 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Vantage 8.03 - Labor Collection import to Vantage
>
>
>
> We are a SQL Server shop.
>
> We use Kronos Workforce Timekeeper and Activities for Time and
> Attendance and labor tracking.
>
> We will need to import labor transactions into Vantage.
>
> Does anyone else collect labor outside of Vantage? Do you use
Service
> Connect to import your labor hours or a different method?
>
> Service Connect is very expensive and I am interested some other
> options.
>
> Thanks.
>






[Non-text portions of this message have been removed]
We are a SQL Server shop.

We use Kronos Workforce Timekeeper and Activities for Time and
Attendance and labor tracking.

We will need to import labor transactions into Vantage.

Does anyone else collect labor outside of Vantage? Do you use Service
Connect to import your labor hours or a different method?

Service Connect is very expensive and I am interested some other
options.

Thanks.
Our team typically does a direct import into the database. If you can
export your Timekeeper data out then you should be able to do this.



Just need a quick clarification. Are you using SQL Server with Vantage
8.03? If yes, what version of SQL Server?



Thanks,



Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of lapulsifer
Sent: Tuesday, June 12, 2007 12:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03 - Labor Collection import to Vantage



We are a SQL Server shop.

We use Kronos Workforce Timekeeper and Activities for Time and
Attendance and labor tracking.

We will need to import labor transactions into Vantage.

Does anyone else collect labor outside of Vantage? Do you use Service
Connect to import your labor hours or a different method?

Service Connect is very expensive and I am interested some other
options.

Thanks.





[Non-text portions of this message have been removed]
Regardless of the version of SQL Server, you can create a DTS package that
imports the data directly into Vantage. That being the case, there are
several caveats to consider:



1. You must either have a working ODBC connection into the Kronos DB
or be able to export the data.

2. On import, you will have to account for all of the required default
values and constraints to support the business logic.

3. Product support may claim that direct manipulation of the Vantage
DB voids your warranty in the event that you need assistance in the future.



You can also use the Pervasive toolkit to import the data but that may be
just as expensive as service connect these days. So, yes, you do have
options but they do have issues to contend with.



Regards,



Michael



Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
lapulsifer
Sent: Tuesday, June 12, 2007 9:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03 - Labor Collection import to Vantage



We are a SQL Server shop.

We use Kronos Workforce Timekeeper and Activities for Time and
Attendance and labor tracking.

We will need to import labor transactions into Vantage.

Does anyone else collect labor outside of Vantage? Do you use Service
Connect to import your labor hours or a different method?

Service Connect is very expensive and I am interested some other
options.

Thanks.





[Non-text portions of this message have been removed]
> We use Kronos Workforce Timekeeper and Activities for Time and
> Attendance and labor tracking.

And you're worried about the price of ServiceConnect? ;-)

> We will need to import labor transactions into Vantage.
>
> Does anyone else collect labor outside of Vantage? Do you use Service
> Connect to import your labor hours or a different method?

Are you using KWT for logging into and out of jobs? Is Kronos looking into
your Vantage DB and making sure the job is open and validating the operation?

Any thought to using a MES seat and feeding clock time back into Kronos using
Kronos Connect?

Mark W.
Another option not mentioned here is to write an external application
that executes the business logic of the labor entry process,

This can be done utilizing web services or with the dll's directly. It
is a better option than ODBC as it executes the business logic.

Only during the transaction would a license be consumed and this could
be a MES license.



Regards,

Stephen

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael Barry
Sent: 12 June 2007 20:26
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03 - Labor Collection import to Vantage



Regardless of the version of SQL Server, you can create a DTS package
that
imports the data directly into Vantage. That being the case, there are
several caveats to consider:

1. You must either have a working ODBC connection into the Kronos DB
or be able to export the data.

2. On import, you will have to account for all of the required default
values and constraints to support the business logic.

3. Product support may claim that direct manipulation of the Vantage
DB voids your warranty in the event that you need assistance in the
future.

You can also use the Pervasive toolkit to import the data but that may
be
just as expensive as service connect these days. So, yes, you do have
options but they do have issues to contend with.

Regards,

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
lapulsifer
Sent: Tuesday, June 12, 2007 9:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.03 - Labor Collection import to Vantage

We are a SQL Server shop.

We use Kronos Workforce Timekeeper and Activities for Time and
Attendance and labor tracking.

We will need to import labor transactions into Vantage.

Does anyone else collect labor outside of Vantage? Do you use Service
Connect to import your labor hours or a different method?

Service Connect is very expensive and I am interested some other
options.

Thanks.








[Non-text portions of this message have been removed]
Thanks for all the responses. We are not live on Vantage 8.03 yet.
Our go live is planned for January 1st.

Believe it or not, Kronos Worforce was not as expensive for us as for
other people I have talked to. The whole suite was probably only 4
times the cost of Service Connect.

The most desirable option for me would be to push the data directly
into the Labor Header and Labor Detail tables.

I'm sure that I can handle the constraints. I'm not sure that I know
all the application triggers or any other tables that may be effected.

If your company is doing a direct import, I am looking for any
suggestions about things that I may not think about. Are there any
other tables involved other than Labor Header and Labor Detail. Are
there any triggers that happen when a labor record is added?

I would definitely rather buy Service Connect than to corrupt the
database!!

Thanks again for all the responses.

--- In vantage@yahoogroups.com, "Jason Claggett" <jason@...> wrote:
>
> Our team typically does a direct import into the database. If you
can
> export your Timekeeper data out then you should be able to do this.
>
>
>
> Just need a quick clarification. Are you using SQL Server with
Vantage
> 8.03? If yes, what version of SQL Server?
>
>
>
> Thanks,
>
>
>
> Jason Claggett
>
> Microsoft Small Business Specialist
>
> MCP #3856159
>
> 2W Technologies, LLC
>
> 317.578.2393
>
> jason@...
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of lapulsifer
> Sent: Tuesday, June 12, 2007 12:38 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage 8.03 - Labor Collection import to Vantage
>
>
>
> We are a SQL Server shop.
>
> We use Kronos Workforce Timekeeper and Activities for Time and
> Attendance and labor tracking.
>
> We will need to import labor transactions into Vantage.
>
> Does anyone else collect labor outside of Vantage? Do you use
Service
> Connect to import your labor hours or a different method?
>
> Service Connect is very expensive and I am interested some other
> options.
>
> Thanks.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>