Sage 100

Has anyone done a VI import into Time Track Entry? Sage 100 2018 and PR 2.19.
I figured out that I need to import Dept and Employee No into Temp fields with the Key Assigns Only or my EmployeeKey will end up being blank.
Then, I thought I needed to use this trick.  obj'ConvertToEmployeeKey$(Temp002$,Temp004$) as my calculation, but I can't even save the calculation field with that - it yields an error 26.
Meanwhile, using this: Temp002$+Temp004$ yields an import error "01-0000121 is not on file" when I can see in the log that it is the correct Employee ID. #Sage100 #VI​​​ Thanks in advance

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Rhonda,
I think you need an underscore at the beginning of your calculation (_obj'ConvertToEmployeeKey$(Temp002$,Temp004$)

------------------------------
Billy Balser
Sage 100 Consultant
Blytheco LLC
Atlanta GA
9495839500
------------------------------

Foiled, again, by the least-like-English syntax ever!  Thank you for the eagle-eyed catch, Billy! My import now runs.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Original Message:
Sent: 07-11-2019 08:40
From: Billy Balser
Subject: Importing into Time Track -

Rhonda,
I think you need an underscore at the beginning of your calculation (_obj'ConvertToEmployeeKey$(Temp002$,Temp004$)

------------------------------
Billy Balser
Sage 100 Consultant
Blytheco LLC
Atlanta GA
9495839500
------------------------------

Sage 100 2019 test upgrade - knocking my head against a wall trying to recreate a timetrack import based on an ascii file previously used to import into timecard.  Not getting past square 1 trying to apply the employee number using the tips mentioned above.  Are you putting dept and employee each into a unique temp field with a key assign.  then creating employee key using the calculation above (with the _obj'...)  did you create a third temp field combing 1 and 2 and then applying the formula to temp 3?  do you have an example of an .EXP file you could share?  


------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 07-11-2019 09:34
From: Rhonda McNamara
Subject: Importing into Time Track -

Foiled, again, by the least-like-English syntax ever!  Thank you for the eagle-eyed catch, Billy! My import now runs.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------


Original Message:
Sent: 07-11-2019 08:40
From: Billy Balser
Subject: Importing into Time Track -

Rhonda,
I think you need an underscore at the beginning of your calculation (_obj'ConvertToEmployeeKey$(Temp002$,Temp004$)

------------------------------
Billy Balser
Sage 100 Consultant
Blytheco LLC
Atlanta GA
9495839500

Not sure this applies, but ​if the dept-empnumber combination is in the same field (IE: 10-employe), you can point the Employee Key to that field and not have to do the temp 1 temp 2 and calculate.  I've been able to do that in the payroll imports.  Hopefully Time Track would allow for the same thing.
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Original Message:
Sent: 12-09-2019 16:45
From: alan niergarth
Subject: Importing into Time Track -

Sage 100 2019 test upgrade - knocking my head against a wall trying to recreate a timetrack import based on an ascii file previously used to import into timecard.  Not getting past square 1 trying to apply the employee number using the tips mentioned above.  Are you putting dept and employee each into a unique temp field with a key assign.  then creating employee key using the calculation above (with the _obj'...)  did you create a third temp field combing 1 and 2 and then applying the formula to temp 3?  do you have an example of an .EXP file you could share?


------------------------------
alan niergarth
Velosio LLC
------------------------------


Original Message:
Sent: 07-11-2019 09:34
From: Rhonda McNamara
Subject: Importing into Time Track -

Foiled, again, by the least-like-English syntax ever!  Thank you for the eagle-eyed catch, Billy! My import now runs.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com


Original Message:
Sent: 07-11-2019 08:40
From: Billy Balser
Subject: Importing into Time Track -

Rhonda,
I think you need an underscore at the beginning of your calculation (_obj'ConvertToEmployeeKey$(Temp002$,Temp004$)

------------------------------
Billy Balser
Sage 100 Consultant
Blytheco LLC
Atlanta GA
9495839500

@Nancy Hanson as usual I was over thinking the requirements making it more difficult than needed.  Jeremy Fox figured it out.  We did not need to use temp fields or formula.  The raw data had a formatted employee number.  Just needed to use an Employee Key value as a "Replace" using a substring matching the position of the full employee number in the ascii text.   Works like GL account numbers and the account key.  Raw data looks like:
90-0010006 0036.5000000000000000 00000000 90 00000000 0000000 0001
20-0010008 0038.3300000000000000 00000000 20 00000000 0000000 0001

------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 12-09-2019 16:49
From: Nancy Hanson
Subject: Importing into Time Track -

Not sure this applies, but ​if the dept-empnumber combination is in the same field (IE: 10-employe), you can point the Employee Key to that field and not have to do the temp 1 temp 2 and calculate.  I've been able to do that in the payroll imports.  Hopefully Time Track would allow for the same thing.
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------


Original Message:
Sent: 12-09-2019 16:45
From: alan niergarth
Subject: Importing into Time Track -

Sage 100 2019 test upgrade - knocking my head against a wall trying to recreate a timetrack import based on an ascii file previously used to import into timecard.  Not getting past square 1 trying to apply the employee number using the tips mentioned above.  Are you putting dept and employee each into a unique temp field with a key assign.  then creating employee key using the calculation above (with the _obj'...)  did you create a third temp field combing 1 and 2 and then applying the formula to temp 3?  do you have an example of an .EXP file you could share?


------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 07-11-2019 09:34
From: Rhonda McNamara
Subject: Importing into Time Track -

Foiled, again, by the least-like-English syntax ever!  Thank you for the eagle-eyed catch, Billy! My import now runs.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com


Original Message:
Sent: 07-11-2019 08:40
From: Billy Balser
Subject: Importing into Time Track -

Rhonda,
I think you need an underscore at the beginning of your calculation (_obj'ConvertToEmployeeKey$(Temp002$,Temp004$)

------------------------------
Billy Balser
Sage 100 Consultant
Blytheco LLC
Atlanta GA
9495839500

OK next related question to importing into timeTrack.  How do you assign Tax profiles?  There is no option to File Assign from the PR Employee table.

If the Profile is omitted from the import, the DEFAULT employee profile is used automatically.  Case resolved.  profile only needed when overriding the default.  
------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 12-10-2019 08:39
From: alan niergarth
Subject: Importing into Time Track -

@Nancy Hanson as usual I was over thinking the requirements making it more difficult than needed.  Jeremy Fox figured it out.  We did not need to use temp fields or formula.  The raw data had a formatted employee number.  Just needed to use an Employee Key value as a "Replace" using a substring matching the position of the full employee number in the ascii text.   Works like GL account numbers and the account key.  Raw data looks like:
90-0010006 0036.5000000000000000 00000000 90 00000000 0000000 0001
20-0010008 0038.3300000000000000 00000000 20 00000000 0000000 0001

------------------------------
alan niergarth
Velosio LLC
------------------------------


Original Message:
Sent: 12-09-2019 16:49
From: Nancy Hanson
Subject: Importing into Time Track -

Not sure this applies, but ​if the dept-empnumber combination is in the same field (IE: 10-employe), you can point the Employee Key to that field and not have to do the temp 1 temp 2 and calculate.  I've been able to do that in the payroll imports.  Hopefully Time Track would allow for the same thing.
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 12-09-2019 16:45
From: alan niergarth
Subject: Importing into Time Track -

Sage 100 2019 test upgrade - knocking my head against a wall trying to recreate a timetrack import based on an ascii file previously used to import into timecard.  Not getting past square 1 trying to apply the employee number using the tips mentioned above.  Are you putting dept and employee each into a unique temp field with a key assign.  then creating employee key using the calculation above (with the _obj'...)  did you create a third temp field combing 1 and 2 and then applying the formula to temp 3?  do you have an example of an .EXP file you could share?


------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 07-11-2019 09:34
From: Rhonda McNamara
Subject: Importing into Time Track -

Foiled, again, by the least-like-English syntax ever!  Thank you for the eagle-eyed catch, Billy! My import now runs.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com


Original Message:
Sent: 07-11-2019 08:40
From: Billy Balser
Subject: Importing into Time Track -

Rhonda,
I think you need an underscore at the beginning of your calculation (_obj'ConvertToEmployeeKey$(Temp002$,Temp004$)

------------------------------
Billy Balser
Sage 100 Consultant
Blytheco LLC
Atlanta GA
9495839500

This thread helped, but any thoughts on doing a file-assign for the pay rate field?  "Not allowed for numeric field" and same if try to use a numeric Temp field.  That was after I linked in the PR_Employee file via Export Job Maint 'Link' button. 

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------

Original Message:
Sent: 12-10-2019 16:48
From: alan niergarth
Subject: Importing into Time Track -

OK next related question to importing into timeTrack.  How do you assign Tax profiles?  There is no option to File Assign from the PR Employee table.

If the Profile is omitted from the import, the DEFAULT employee profile is used automatically.  Case resolved.  profile only needed when overriding the default.
------------------------------
alan niergarth
Velosio LLC
------------------------------


Original Message:
Sent: 12-10-2019 08:39
From: alan niergarth
Subject: Importing into Time Track -

@Nancy Hanson as usual I was over thinking the requirements making it more difficult than needed.  Jeremy Fox figured it out.  We did not need to use temp fields or formula.  The raw data had a formatted employee number.  Just needed to use an Employee Key value as a "Replace" using a substring matching the position of the full employee number in the ascii text.   Works like GL account numbers and the account key.  Raw data looks like:
90-0010006 0036.5000000000000000 00000000 90 00000000 0000000 0001
20-0010008 0038.3300000000000000 00000000 20 00000000 0000000 0001

------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 12-09-2019 16:49
From: Nancy Hanson
Subject: Importing into Time Track -

Not sure this applies, but ​if the dept-empnumber combination is in the same field (IE: 10-employe), you can point the Employee Key to that field and not have to do the temp 1 temp 2 and calculate.  I've been able to do that in the payroll imports.  Hopefully Time Track would allow for the same thing.
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 12-09-2019 16:45
From: alan niergarth
Subject: Importing into Time Track -

Sage 100 2019 test upgrade - knocking my head against a wall trying to recreate a timetrack import based on an ascii file previously used to import into timecard.  Not getting past square 1 trying to apply the employee number using the tips mentioned above.  Are you putting dept and employee each into a unique temp field with a key assign.  then creating employee key using the calculation above (with the _obj'...)  did you create a third temp field combing 1 and 2 and then applying the formula to temp 3?  do you have an example of an .EXP file you could share?


------------------------------
alan niergarth
Velosio LLC


Original Message:
Sent: 07-11-2019 09:34
From: Rhonda McNamara
Subject: Importing into Time Track -

Foiled, again, by the least-like-English syntax ever!  Thank you for the eagle-eyed catch, Billy! My import now runs.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com


Original Message:
Sent: 07-11-2019 08:40
From: Billy Balser
Subject: Importing into Time Track -

Rhonda,
I think you need an underscore at the beginning of your calculation (_obj'ConvertToEmployeeKey$(Temp002$,Temp004$)

------------------------------
Billy Balser
Sage 100 Consultant
Blytheco LLC
Atlanta GA
9495839500

I have a customer I'm importing to TT, don't have access right this minute, but can look at their system.  I thought I left Pay Rate off the import job unless you need to do different pay rates (which I did not.)
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Original Message:
Sent: 05-05-2021 22:31
From: Brett Zimmerman
Subject: Importing into Time Track -

@Nancy Hanson, that would be awesome if you could get your hands on the import job.​

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------

Original Message:
Sent: 05-05-2021 22:44
From: Nancy Hanson
Subject: Importing into Time Track -

I have a customer I'm importing to TT, don't have access right this minute, but can look at their system.  I thought I left Pay Rate off the import job unless you need to do different pay rates (which I did not.)
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------


Original Message:
Sent: 05-05-2021 22:31
From: Brett Zimmerman
Subject: Importing into Time Track -

This job is written in v2020, I sent along a sample file too.  good luck!

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Original Message:
Sent: 05-06-2021 08:44
From: Brett Zimmerman
Subject: Importing into Time Track -

@Nancy Hanson, that would be awesome if you could get your hands on the import job.​

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------


Original Message:
Sent: 05-05-2021 22:44
From: Nancy Hanson
Subject: Importing into Time Track -

I have a customer I'm importing to TT, don't have access right this minute, but can look at their system.  I thought I left Pay Rate off the import job unless you need to do different pay rates (which I did not.)
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 05-05-2021 22:31
From: Brett Zimmerman
Subject: Importing into Time Track -

sorry, let's try this one for the attachments.

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Original Message:
Sent: 05-06-2021 10:00
From: Nancy Hanson
Subject: Importing into Time Track -

This job is written in v2020, I sent along a sample file too.  good luck!

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------


Original Message:
Sent: 05-06-2021 08:44
From: Brett Zimmerman
Subject: Importing into Time Track -

@Nancy Hanson, that would be awesome if you could get your hands on the import job.​

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area


Original Message:
Sent: 05-05-2021 22:44
From: Nancy Hanson
Subject: Importing into Time Track -

I have a customer I'm importing to TT, don't have access right this minute, but can look at their system.  I thought I left Pay Rate off the import job unless you need to do different pay rates (which I did not.)
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 05-05-2021 22:31
From: Brett Zimmerman
Subject: Importing into Time Track -

@Brett Zimmerman We have clients importing into TT from Kronos output tables.  These include Job Cost posting.  Let me know if you need another example of an import job.  Nothing really special in the job.  ​

------------------------------
alan niergarth
Velosio LLC
------------------------------

Original Message:
Sent: 05-06-2021 10:02
From: Nancy Hanson
Subject: Importing into Time Track -

sorry, let's try this one for the attachments.

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------


Original Message:
Sent: 05-06-2021 10:00
From: Nancy Hanson
Subject: Importing into Time Track -

This job is written in v2020, I sent along a sample file too.  good luck!

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 05-06-2021 08:44
From: Brett Zimmerman
Subject: Importing into Time Track -

@Nancy Hanson, that would be awesome if you could get your hands on the import job.​

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area


Original Message:
Sent: 05-05-2021 22:44
From: Nancy Hanson
Subject: Importing into Time Track -

I have a customer I'm importing to TT, don't have access right this minute, but can look at their system.  I thought I left Pay Rate off the import job unless you need to do different pay rates (which I did not.)
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 05-05-2021 22:31
From: Brett Zimmerman
Subject: Importing into Time Track -

Thanks much, @Nancy Hanson, @alan niergarth!!​​

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area
------------------------------

Original Message:
Sent: 05-06-2021 10:41
From: alan niergarth
Subject: Importing into Time Track -

@Brett Zimmerman We have clients importing into TT from Kronos output tables.  These include Job Cost posting.  Let me know if you need another example of an import job.  Nothing really special in the job.  ​

------------------------------
alan niergarth
Velosio LLC
------------------------------


Original Message:
Sent: 05-06-2021 10:02
From: Nancy Hanson
Subject: Importing into Time Track -

sorry, let's try this one for the attachments.

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 05-06-2021 10:00
From: Nancy Hanson
Subject: Importing into Time Track -

This job is written in v2020, I sent along a sample file too.  good luck!

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 05-06-2021 08:44
From: Brett Zimmerman
Subject: Importing into Time Track -

@Nancy Hanson, that would be awesome if you could get your hands on the import job.​

------------------------------
Brett Zimmerman
Net at Work
Greater Boston Area


Original Message:
Sent: 05-05-2021 22:44
From: Nancy Hanson
Subject: Importing into Time Track -

I have a customer I'm importing to TT, don't have access right this minute, but can look at their system.  I thought I left Pay Rate off the import job unless you need to do different pay rates (which I did not.)
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN


Original Message:
Sent: 05-05-2021 22:31
From: Brett Zimmerman
Subject: Importing into Time Track -