|
Please could anybody help with a file
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? |
Please could anybody help with a file
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? |
Please could anybody help with a file
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? |
Please could anybody help with a file
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? |
Please could anybody help with a file
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? |
Please could anybody help with a file
|
Please could anybody help with a file
|
Please could anybody help with a file
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? |
Please could anybody help with a file
|
Please could anybody help with a file
Joel, thank you very much for your help it works perfectly, without your help
it'd be impossible for me to get that macro. My expertise is accounting, budgeting and forescating if at any time you need some help don't hesitate to contact me. Thank you again "Eduardo" wrote: Hi Joel, I found what was wrong, now macro is working, thanks "Joel" wrote: 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? |
| All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com