I have an order form for product in an excel file like this
Item Description Unit Quantity CaseSelling PriceQuantity


F1AL1080 Capless KG 83.49 5 9.68 1
F1AL1085 Whole KG 100.09 3 24.739 1
F1AL1091 RTS KG 404.46 21 9.68 1

What I need to do is to create an EDI file with the above information in
order to be able to import that file into my system

Could anybody help me?

SAve the file as text or CSV.

"Eduardo" wrote:

I have an order form for product in an excel file like this
Item Description Unit Quantity CaseSelling PriceQuantity


F1AL1080 Capless KG 83.49 5 9.68 1
F1AL1085 Whole KG 100.09 3 24.739 1
F1AL1091 RTS KG 404.46 21 9.68 1

What I need to do is to create an EDI file with the above information in
order to be able to import that file into my system

Could anybody help me?

Joel, thank you for answering my question, what happens is that I need to put
the information in an EDI format as follow:

ISA*00* *00* *ZZ*46 *01*254185739
*070212*0738*|*00406*000000016*0*P*:~
GS*PO*46*254185739*070212*0738*16*X*004060~
ST*850*0000031~
BEG*00*SA*TestOrder1**20070212~
DTM*064*20070212~
DTM*063*20080212~
MSG*CommentLine~
N1*ST**92*24KARA~
PO1**4**8.50**VN*EV0336-001~ (4=quantiy of my order,8.5 price,ev0336=item
code)
PO1**14**9.50**VN*EV0346-001~
PO1**24**11.50**VN*EV0396-001~
PO1**124**18.50**VN*EV0936-001~
CTT*4*~
SE*14*0000031~
GE*1*16~
IEA*1*000000016~

From above I need to figure out, how to get there the information related to
the quantity, item code and price
"Joel" wrote:

SAve the file as text or CSV.

"Eduardo" wrote:

I have an order form for product in an excel file like this
Item Description Unit Quantity CaseSelling PriceQuantity


F1AL1080 Capless KG 83.49 5 9.68 1
F1AL1085 Whole KG 100.09 3 24.739 1
F1AL1091 RTS KG 404.46 21 9.68 1

What I need to do is to create an EDI file with the above information in
order to be able to import that file into my system

Could anybody help me?

I don't know what EDI format is. It doesn't look like the two files contain
the same data (EDI and spreadsheetA). I have written plenty of I/O programs
converting text from one format to another.

Using VBA you can open a text file and same the worksheet format to the text
file any way you want to.

If you give more info on the EDI format I can help
"Eduardo" wrote:

Joel, thank you for answering my question, what happens is that I need to put
the information in an EDI format as follow:

ISA*00* *00* *ZZ*46 *01*254185739
*070212*0738*|*00406*000000016*0*P*:~
GS*PO*46*254185739*070212*0738*16*X*004060~
ST*850*0000031~
BEG*00*SA*TestOrder1**20070212~
DTM*064*20070212~
DTM*063*20080212~
MSG*CommentLine~
N1*ST**92*24KARA~
PO1**4**8.50**VN*EV0336-001~ (4=quantiy of my order,8.5 price,ev0336=item
code)
PO1**14**9.50**VN*EV0346-001~
PO1**24**11.50**VN*EV0396-001~
PO1**124**18.50**VN*EV0936-001~
CTT*4*~
SE*14*0000031~
GE*1*16~
IEA*1*000000016~

From above I need to figure out, how to get there the information related to
the quantity, item code and price
"Joel" wrote:

SAve the file as text or CSV.

"Eduardo" wrote:

I have an order form for product in an excel file like this
Item Description Unit Quantity CaseSelling PriceQuantity


F1AL1080 Capless KG 83.49 5 9.68 1
F1AL1085 Whole KG 100.09 3 24.739 1
F1AL1091 RTS KG 404.46 21 9.68 1

What I need to do is to create an EDI file with the above information in
order to be able to import that file into my system

Could anybody help me?

Joel, I have some documentation in word but as this is my first time posting
a question I don't know how to attach the document, I've tried to paste it
but unsuccefully,
Eduardo


"Joel" wrote:

I don't know what EDI format is. It doesn't look like the two files contain
the same data (EDI and spreadsheetA). I have written plenty of I/O programs
converting text from one format to another.

Using VBA you can open a text file and same the worksheet format to the text
file any way you want to.

If you give more info on the EDI format I can help
"Eduardo" wrote:

Joel, thank you for answering my question, what happens is that I need to put
the information in an EDI format as follow:

ISA*00* *00* *ZZ*46 *01*254185739
*070212*0738*|*00406*000000016*0*P*:~
GS*PO*46*254185739*070212*0738*16*X*004060~
ST*850*0000031~
BEG*00*SA*TestOrder1**20070212~
DTM*064*20070212~
DTM*063*20080212~
MSG*CommentLine~
N1*ST**92*24KARA~
PO1**4**8.50**VN*EV0336-001~ (4=quantiy of my order,8.5 price,ev0336=item
code)
PO1**14**9.50**VN*EV0346-001~
PO1**24**11.50**VN*EV0396-001~
PO1**124**18.50**VN*EV0936-001~
CTT*4*~
SE*14*0000031~
GE*1*16~
IEA*1*000000016~

From above I need to figure out, how to get there the information related to
the quantity, item code and price
"Joel" wrote:

SAve the file as text or CSV.

"Eduardo" wrote:

I have an order form for product in an excel file like this
Item Description Unit Quantity CaseSelling PriceQuantity


F1AL1080 Capless KG 83.49 5 9.68 1
F1AL1085 Whole KG 100.09 3 24.739 1
F1AL1091 RTS KG 404.46 21 9.68 1

What I need to do is to create an EDI file with the above information in
order to be able to import that file into my system

Could anybody help me?

This website doesn't allow attachments. Sent to my email address


I will look at this weekend.

"Eduardo" wrote:

Joel, I have some documentation in word but as this is my first time posting
a question I don't know how to attach the document, I've tried to paste it
but unsuccefully,
Eduardo


"Joel" wrote:

I don't know what EDI format is. It doesn't look like the two files contain
the same data (EDI and spreadsheetA). I have written plenty of I/O programs
converting text from one format to another.

Using VBA you can open a text file and same the worksheet format to the text
file any way you want to.

If you give more info on the EDI format I can help
"Eduardo" wrote:

Joel, thank you for answering my question, what happens is that I need to put
the information in an EDI format as follow:

ISA*00* *00* *ZZ*46 *01*254185739
*070212*0738*|*00406*000000016*0*P*:~
GS*PO*46*254185739*070212*0738*16*X*004060~
ST*850*0000031~
BEG*00*SA*TestOrder1**20070212~
DTM*064*20070212~
DTM*063*20080212~
MSG*CommentLine~
N1*ST**92*24KARA~
PO1**4**8.50**VN*EV0336-001~ (4=quantiy of my order,8.5 price,ev0336=item
code)
PO1**14**9.50**VN*EV0346-001~
PO1**24**11.50**VN*EV0396-001~
PO1**124**18.50**VN*EV0936-001~
CTT*4*~
SE*14*0000031~
GE*1*16~
IEA*1*000000016~

From above I need to figure out, how to get there the information related to
the quantity, item code and price
"Joel" wrote:

SAve the file as text or CSV.

"Eduardo" wrote:

I have an order form for product in an excel file like this
Item Description Unit Quantity CaseSelling PriceQuantity


F1AL1080 Capless KG 83.49 5 9.68 1
F1AL1085 Whole KG 100.09 3 24.739 1
F1AL1091 RTS KG 404.46 21 9.68 1

What I need to do is to create an EDI file with the above information in
order to be able to import that file into my system

Could anybody help me?

It would appear that saving Excel data in EDI format is not a trivial task:
http://edidev.com/XMLvsEDI.html

And these seem aimed at Java, but may be useful:
http://www.americancoders.com/OpenBu...cts/index.html
http://www.stylusstudio.com/data_conversion.html

NickHK

"Eduardo" wrote in message
...
I have an order form for product in an excel file like this
Item Description Unit Quantity CaseSelling PriceQuantity


F1AL1080 Capless KG 83.49 5 9.68 1
F1AL1085 Whole KG 100.09 3 24.739 1
F1AL1091 RTS KG 404.46 21 9.68 1

What I need to do is to create an EDI file with the above information in
order to be able to import that file into my system

Could anybody help me?