Need help to create Visual Integrator Import function to Sage 4.40 and Kronos

[hhhugo]

I have a Kronos file where it will contain the employee number, earning code and hours to pay. Started programming the VI import function but would like to look at one that's working or if possible have someone create remotely a new VI function to work. Also would like to create a desktop icon to launch the VI import.

Also not sure on how to apply automatic deductions since they are in the program and that data will not come from the Kronos system.

 

[LouieGrandie]

What version are you on? And normally you would work with your reseller on something such as this. Have you ever done VI imports?

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[hhhugo]

version 4.40 now.

Yes but short on time and would use some help.

I understand version 4.5 has some import jobs already created. Would look into that.

 

[hhhugo]

This is a sample of the timeclock data to import.
division, employee number, earning code, hours worked
00,0000059,01,00080.00
00,0000142,OT,00001.00
00,0000142,01,00079.25
00,0000163,01,00080.00
00,0000332,01,00080.00
00,0000369,ST,00003.25
00,0000369,SR,00002.00
00,0000369,MR,00000.25
00,0000369,OT,00003.50
00,0000369,01,00076.50
00,0000469,01,00039.75
00,0000469,VC,00040.00
00,0000683,BD,00008.00
00,0000683,01,00072.00
00,0000764,01,00080.00
00,0000921,MR,00002.00
00,0000921,01,00078.00
00,0000921,OT,00003.75
00,0001053,01,00080.00
00,0001053,OT,00000.25
00,0001053,ST,00005.00
00,0001224,01,00080.00
00,0001236,01,00049.50
00,0001273,01,00078.00
00,0001273,OT,00002.00
00,0001372,OT,00000.50
00,0001372,01,00079.75
00,0001445,VC,00008.00
00,0001445,01,00072.00
00,0001607,01,00080.00
00,0001656,ST,00005.00
00,0001656,VC,00008.00
00,0001656,01,00072.00
00,0001894,01,00080.00
00,0002292,ST,00003.25
00,0002292,OT,00000.50
00,0002292,MR,00000.50
00,0002292,01,00080.00
00,0002469,OT,00004.25
00,0002469,01,00079.50
00,0002540,01,00072.00
00,0002605,01,00080.00
00,0002797,SL,00008.00
00,0002797,01,00038.00
00,0002797,MR,00000.25
00,0002867,01,00070.00
00,0002867,OT,00005.00
00,0002867,ST,00002.00
00,0002867,SR,00003.00
00,0002867,SL,00005.00
00,0002983,SR,00000.50
00,0002983,OT,00000.25
00,0002983,ST,00004.50
00,0002983,01,00077.25
00,0003571,OT,00001.25
00,0003571,01,00075.25
00,0003671,01,00080.00
00,0003747,01,00080.00
00,0003787,OT,00005.00
00,0003787,01,00048.00
00,0003801,SR,00005.00
00,0003801,SL,00006.00
00,0003801,OT,00000.50
00,0003801,01,00070.25
00,0003888,OT,00003.00
00,0003888,MR,00001.00
00,0003888,01,00077.00
00,0003910,ST,00000.50
00,0003910,SR,00003.50
00,0003910,OT,00000.50
00,0003910,01,00075.25
00,0004287,MR,00000.50
00,0004287,01,00080.00
00,0004378,ST,00008.00
00,0004378,SR,00001.50
00,0004378,OT,00001.50
00,0004378,01,00078.50
00,0004381,SR,00005.00
00,0004381,01,00013.00
00,0004542,01,00080.00
00,0004578,01,00080.00
00,0004620,MR,00000.50
00,0004620,01,00036.00
00,0004712,SL,00004.50
00,0004712,OT,00001.00
00,0004712,01,00071.50
00,0004755,01,00080.00
00,0004852,OT,00004.00
00,0004852,01,00076.00
00,0005102,01,00072.00
00,0005716,01,00080.00
00,0005722,OT,00002.75
00,0005722,MR,00000.50
00,0005722,01,00078.25
00,0005937,OT,00001.00
00,0005937,MR,00000.50
00,0005937,01,00052.75
00,0006021,ST,00008.75
00,0006021,OT,00001.50
00,0006021,MR,00000.50
00,0006021,01,00080.00
00,0006063,ML,00080.00
00,0006074,BD,00008.00
00,0006074,01,00072.00
00,0006305,01,00080.00
00,0006324,SL,00003.25
00,0006324,01,00076.75
00,0006547,OT,00002.25
00,0006547,01,00079.00
00,0006658,SL,00048.00
00,0006658,01,00032.25
00,0006828,01,00080.00
00,0006983,ST,00005.00
00,0006983,OT,00001.25
00,0006983,01,00080.00
00,0007150,01,00080.00
00,0007282,ST,00005.25
00,0007282,MR,00000.25
00,0007282,01,00080.00
00,0007394,OT,00002.25
00,0007394,MR,00008.50
00,0007394,01,00077.00
00,0007443,OT,00001.00
00,0007443,BD,00008.00
00,0007443,01,00071.00
00,0007686,ST,00009.25
00,0007686,OT,00004.50
00,0007686,MR,00001.75
00,0007686,01,00080.00
00,0007794,01,00080.00
00,0007851,ST,00004.00
00,0007851,SR,00001.00
00,0007851,OT,00001.00
00,0007851,01,00079.00
00,0007883,01,00080.00
00,0007899,VC,00003.00
00,0007899,ST,00001.25
00,0007899,SR,00003.25
00,0007899,OT,00001.50
00,0007899,01,00071.75
00,0008004,ST,00006.50
00,0008004,SR,00003.50
00,0008004,OT,00003.50
00,0008004,01,00076.50
00,0008021,01,00080.00
00,0008142,01,00080.00
00,0008157,01,00079.75
00,0008160,OT,00001.00
00,0008160,01,00079.00
00,0008207,SL,00008.00
00,0008207,01,00072.00
00,0008228,01,00080.00
00,0008417,SM,00008.00
00,0008417,01,00072.00
00,0008554,SM,00008.00
00,0008554,01,00077.00
00,0009293,ST,00004.75
00,0009293,01,00080.00
00,0009354,OT,00002.00
00,0009354,01,00049.00
00,0009487,ST,00004.75
00,0009487,OT,00003.25
00,0009487,MR,00000.75
00,0009487,01,00080.00
00,0009536,SR,00016.00
00,0009537,SL,00008.00
00,0009537,01,00072.00

 

[Blorf]

There are quite a few more required fields to make this work. Workers Comp Code, Department Worked, Payrate, Earnings Multiplier, the list goes on. Many of the required fields don't need to be in your data, can be pulled from other tables inside VI.

I recommend that you do real actual data entry on a few employees, then make a VI Export Job so you can see all the data and fields that get created when you do it manually, then start adding fields until you get it right (Or hire someone). The Hire Someone is great if you don't need to learn how to do this stuff for future use, but if you are your companies "Guy" when it comes to this stuff, go in on a Saturday when you won't be bothered and get used to frustration of trial and error. I took a class on VI a number of years ago and didn't get much out of it, it was a very basic setting with little or no take away documentation. VI can be extremely useful so trial and error education is worth the time.

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That DonÆt.

http://www.thelegacyreturns.com/