Technical and Installation Discussions

[dws253]

My CSV source file has two columns that I need to concatenate to create the Vendor Number.  The same CSV is used to create temporary vendors and invoices.  I keep getting Vendor Number is required error when testing.  I have set up the identical calculation (Temp003$+Temp004$) for the Reference number field as a test and it resolves just fine with the two columns stuck together.  The first column is variable length in the CSV file and the second column is always 1, 2, 3, or 4.  Is there a way to get the six rightmost characters from the first column? It appears VI is zero padding the vendor number.  Could be I am trying to put 8 characters into a 7 character field.  Any other ideas?

[rmikolainis]

Why not trying to format the column in Excel? Takes like 5 seconds to do in Excel.

[dws253]

This import is part of a one click solution that is supposed to be simple to use.  Click a desktop icon and the vendors and invoices are imported, ready for posting and printing checks.  The do a lot of these every day.  They are trying to simplify processes.  I may have to do something before the VI processing starts, but it seems so simple to populate a couple of Temp fields and concatenate in the VI job itself...it just doesn't work - at least for Vendor Number, while it does work for some other string field.  I am trying to find out if I am missing something.  Thanks.

[BigLouie]

How are you handling the division number? Even if they do not use divisions you still have to have a value.

[dws253]

Divison number is a separate field in VI.  It is ASSIGNed a static value.  Only one division number in use.

[VKZIMM]

Are you temp fields assigned prior to you assigning the Vendor Number?

Have you tried using a temp field that is calculated like your reference field and then having the Vendor Number

be calculated and put the Temp field in the calculated box?

Yes, if you use the calculated box you can find out how to pad or get specified data from a field.  Check under Functions and Operators.  There is a PVX language manual available somewhere.