Import Cribmaster information to Epicor10

Yahoo Archive
1
Don't do SSIS it bypasses all the epicor business logic. You need to use the business objects either service connect, DMT , or you can write your own C# code to consume the epicor services


On Friday, June 24, 2016, ionut.rus@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Thank you very much guys!</p><div><br></div><div>I will take into account your advice.</div><div><br></div><div>The thing is that my company wants somehow to have Cribmaster integrated with Epicor10 but not spend any money at all for other tools(DMT or Service Connect)</div><div><br></div><div>First I will give it a try with SSIS and try to play with the UD tables. If that doesn&#39;t work I think we&#39;ll have to go with DMT.</div><div><br></div><div>Regards,</div><div>John</div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>


--

Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

2

Hi,


We export daily a report (.xls) from cribmaster that has information from the vending machines regarding BinNum, Tools, description and quantities.

There are around 4 thousand rows.


Now I want to insert/update from this spreadsheet into WhseBin table (all the BinNums with its specific warehouse code and the description)


I made a separate app, it read the data from the spreadsheet and then using bulkInsert I was able to copy it successfully into the Pilot DB.


Then I tried to open it from Epicor, and all the entries were there, in the Warehouse Bin Maintenance.


The problem was when I tried to update an entry: I got this error:


Record for update was not found by its SysRowID value [ed263794-abeb-47ea-aa65-a62e016df049].



I was told the Service Connect might work but it's pretty expensive.


Any other solutions?



Thanks!!

3
SSIS and DMT would work.
4
We have cribmaster fully integrated with Epicor using Service Connect. It works very well.

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...<mailto:rbucek@...>
Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, June 23, 2016 5:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] import Cribmaster information to Epicor10



Hi,



We export daily a report (.xls) from cribmaster that has information from the vending machines regarding BinNum, Tools, description and quantities.

There are around 4 thousand rows.



Now I want to insert/update from this spreadsheet into WhseBin table (all the BinNums with its specific warehouse code and the description)



I made a separate app, it read the data from the spreadsheet and then using bulkInsert I was able to copy it successfully into the Pilot DB.



Then I tried to open it from Epicor, and all the entries were there, in the Warehouse Bin Maintenance.



The problem was when I tried to update an entry: I got this error:



Record for update was not found by its SysRowID value [ed263794-abeb-47ea-aa65-a62e016df049].





I was told the Service Connect might work but it's pretty expensive.



Any other solutions?





Thanks!!



[Non-text portions of this message have been removed]
5
Well from what I see these are the only 3 solutions..

Which one is easier to implement? What about the costs?


Thank you!
John
6
Of all three the DMT is probably the easiest and the least costly upfront, but it too has some limitations. Service Connect may be costlier and harder to implement, but the ROI it can bring across the entire organization can easily be justified if used correctly and appropriately. SSIS is free and if you are comfortable developing with that it’s a decent tool, but it doesn’t adhere to the business logic Epicor has in place to protect your data integrity. It’s fine if you’re messing around in UD tables, but there are some risks involved when you circumvent the BL Epicor has in place.

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...<mailto:rbucek@...>
Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, June 24, 2016 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: import Cribmaster information to Epicor10



Well from what I see these are the only 3 solutions..

Which one is easier to implement? What about the costs?


Thank you!
John



[Non-text portions of this message have been removed]
7
If you don't have the DMT license already you might consider it. It's useful for all kinds of things.

Once you have your column names in your spreadsheet to match Epicor fields it's easy to import.

Joe

On Fri, Jun 24, 2016 at 11:42 AM, ionut.rus@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Well from what I see these are the only 3 solutions..</p><div><br></div><div>Which one is easier to implement? What about the costs?</div><div><br></div><div><br></div><div>Thank you!</div><div>John</div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

8
Thank you very much guys!

I will take into account your advice.

The thing is that my company wants somehow to have Cribmaster integrated with Epicor10 but not spend any money at all for other tools(DMT or Service Connect)

First I will give it a try with SSIS and try to play with the UD tables. If that doesn't work I think we'll have to go with DMT.

Regards,
John
9
The reason I said SSIS is because you can take data, automatically format that data to DMT format, and run DMT command switches to import on a regular schedule or on file detection all within a single SSIS process.  That way you follow business logic and there is no corrupt data being input, which is probably why you are getting that error.

Basically its a mock SC as long as DMT has the ability for waayyy cheaper.

DO NOT use SSIS/Bulk Insert to directly write to the Epicor DB!! (other than UD tables)


10
duckorz,

Thanks for the info!

I will try to go with SSIS/Bulk Insert for UD tables.

For now, it does what I've wanted!

Cheers,
John