2018 Import into Job Posting Entry - Error

SOLVED

Having an issue with Cost Codes in an import into Job Posting Entry.  The cost codes, with "-", are longer than 9 characters, and I do have the Skip Source Data Transaction checked.  It still did not like the Cost Code, so I did a calculated field where I took out the dashes.  It then seemed to calculate the cost code correctly, but said it was not on file (which it clearly is).  I changed the Job Cost Options to do no validation, and still cannot get it to accept the cost codes.

I have a cost type (valid, although it shows as invalid since there is no valid cost CODE) and a job number (valid).

Parents Reply Children
  • 0 in reply to David Speck

    Without - I just assigned them all to the same batch this time.  I'll worry about the Next once we have real data to play with.  I looked through my detail log and yup, I had a lot more red lines than TWO.  Which I should have had, because I had some lines with no jobs.  I'm thinking that if there was no job, it skipped it and did not count it as a fail BUT didn't count it as a skip because I had no skip criteria.  Or something else, who knows - but the count wasn't accurate but the imported records appeared to be doing what they should have been doing.

  • +1 in reply to bethbowers
    verified answer

    One caveat of the GetNextEntry method is that because it is a calculated field, VI does not compare its value between the last record and the current record. So make sure you are setting something to a Header field from your source file using the Replace operation.

    Using these settings.

    With this source.

    Gave me these results.

  • 0 in reply to David Speck

    Thanks.  For this particular thing, it's just one big entry anyway, but when I start working on two other upgrades for Job Cost clients, I will need this info...