I guess I'm getting lost what it is asking me for in the header information. What exactly is it looking for? Is it because I am updating a child table, I have to give the parent table the same information so it knows what to do or am I wrong?
________________________________
From: Kevin Simon <
simstrak@...>
To:
vantage@yahoogroups.com
Sent: Thursday, November 3, 2011 12:24 AM
Subject: RE: [Vantage] Re: Service Connect Workflow
The csv files will work. The trick is to have the same schema for each one.
That means that you need at minimum header information on each record. You
use the first record to create the header, but the rest of the records is
just a place holder. Either of the following would work:
Company,OrdDate,CustID,PartNum,Qty
ABCD,2011-11-03,ACME,PART1234,100
ABCD,2011-11-03,ACME,PART5678,200
ABCD,2011-11-03,ACME,PART9999,300
Or.
Company,OrdDate,CustID,PartNum,Qty
ABCD,2011-11-03,ACME,PART1234,100
, , ,PART5678,200
, , ,PART9999,300
HTH
Kevin Simon
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of
sbraudrick@...
Sent: Wednesday, November 02, 2011 2:31 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Workflow
Â
As mentioned already, you need a main workflow that will create the header
and then a sub-workflow to cycle through the lines.
I've done this with creating Sales Orders from information exported from a
legacy system. I doubt the .csv format will work for you unless you are
dropping multiple files (one for the header and another for the lines). I
found that exporting the data to .xml files worked much better.
If you'd like I can package up the Sales Order workflow and some sample data
so you can look it over, just shoot me an email.
Sean
--- In
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Michelle
de la Vega <mdelavega@...> wrote:
>
> Hi Service Connect Gurus! I need a little help. I would like to use SC to
create a Transfer Order from a .csv file. My question is, how do I cycle on
each line without creating separate transfer order headers for each line?
Below is a sample of data:
>
> Company Requesting Plant Shipping Plant Part Description Quantity Entry
Person
> CJ-CORP MFGSYS REM 3G0081 CLIP, LED POWER SUPPLY/AERO40/80/80DX 5 Dtaylor
> CJ-CORP MFGSYS REM 3J0860-C PANEL, RIGHT SIDE, STAINLESS STEEL 5 Dtaylor
> CJ-CORP MFGSYS REM 2J0221-B FRAME, BLAST UNIT W/ HANDLES 5 Dtaylor
>
> In this case we have a transfer order with 30 lines and I want to create
one transfer order with thirty lines.
>
> Any help would be greatly appreciated.
>
> Michelle the "I thought I knew Service Connect" woman
>
> Michelle de la Vega
> Business Applications Manager
> Cold Jet, LLC
> 455 Wards Corner Road
> Loveland, Ohio 45140
> USA
> +1 513-716-6400 (office)
> +1 513-382-3281 (mobile)
> +1 513-831-1209 (fax)
> www.coldjet.com<http://www.coldjet.com>
> [cid:image001.jpg@...]
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]