Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

hhhugo

MIS
Dec 3, 2015
5
PR
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.
 
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.
 
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
 
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top