Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

VI Import - Split a data row into multiple detail lines?

Posted By RobertValencia over 1 year ago

Hi,

We want to import a sheet from a client that sends us a csv of monthly invoice info. Some lines on the csv need to be split into 2 and occasionally 3 lines, based on the data.

I can parse the line fine, but is there a way to have multiple detail lines created for the singe data line in this case?

The answer may be "no" but thought I would ask.

Thank you.

0 BigLouie over 1 year ago

The answer is "no" because VI reads the line once and writes out a line and moves on.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 1 year ago in reply to BigLouie

Exactly. When I've encountered this in the past, I run the csv through a VBScript to split the values out into separate lines within a new file, then import that new file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Wayne Schulz over 1 year ago

Depending on the situation - chain the import to another, which reads from a different column. I did this when I had a source file for payroll that held different types of hours in different columns.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

VI Import - Split a data row into multiple detail lines?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING