Find Jobs
Hire Freelancers

Create an .XSL Stylesheet to convert exported .XML documents to .CSV

$30-250 AUD

Terminado
Publicado hace más de 7 años

$30-250 AUD

Pagado a la entrega
One of our key trading partners is making the transition to automated order processing and will require us to send purchase order documents in .csv format. Our ERP package is natively capable of exporting purchase order information in .xml format or can utilise a .xsl style sheet to manipulate the data. We require an .xsl style sheet to perform 2 functions. 1 we need to output in .csv format. 2 we need to filter the large amount of exported data to include only the following relevant information - Purchase Order Date <DateOrdered>, Purchase Order Number <PO_Unique>, Item Code <SuppPart>, Quantity <Ordered>, Delivery Address <Address> & <City> & <Local State> &<Postal> and P.O Comments <POComment> (this will need formatting data stripped). Our ERP package is Windward System 5 and the relevant help file can be found at [login to view URL] I have attached an example .xml export from our ERP package. I will also add an example of an exported .csv file on Monday so you can see what the output needs to look like.
ID del proyecto: 11977929

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, I am an expert XSLT developer since 15 years. I am a full time professional XML freelancer. I can do this fast and high quality I checked the source XML and noticed that some information needs to be found by foreign key like references. This is easy as long as the XML documents does not grow in file-size over 80 MB or so Should be OK Looking forward to do this for you Best regards Geert Bormans
$88 AUD en 2 días
5,0 (84 comentarios)
6,3
6,3
18 freelancers están ofertando un promedio de $151 AUD por este trabajo
Avatar del usuario
Hi. I would like to learn more about your xslt project. I can produce an xslt file that, when run on your input file, produces output such as the following: Purchase Order Date,Purchase Order Number,Item Code,Quantity,Delivery Address,P.O. Comments 2016-11-04,4519,138,2,"GMobility;11 Hazel Drive;Warragul VIC 3820","" 2016-11-04,4519,183F,2,"GMobility;11 Hazel Drive;Warragul VIC 3820","" Questions: Q1. What version of XSL is supported by Windward? (I did not find this in the docs. Later versions help simplify code to remove RTF.) Q2. How should quote characters be handled in the csv file? (Simplest is to translate " to '. Some programs expect doubled quotes.) Q3. Address: Q3.1 Should the Delivery Address include a name (the InvoiceName for the Company?) Q3.2 Will an address ever have multiple Address lines? (like Account address or Contact address)? Q3.3 In the xml file, City is "Warragul, VIC", and LocalState is "VIC". Is the duplicate ", VIC" in City value a data error to be ignored by the xsl, or must the xsl remove ", VIC" ? Q3.5 As I understand, the Delivery Address is all in one column in the csv file. Should lines separated by line breaks (linefeed &#10;), or some other character like the ';' used above? Q4. Comments: Q4.1 Should both Item/PurchaseOrderComment and Purchase/POComments be included in the P.O. Comments column? Q4.2. What version(s) of RTF may appear in the POComments? Will \u unicode char tags need conversion? I look forward to your reply.
$90 AUD en 1 día
5,0 (13 comentarios)
4,7
4,7
Avatar del usuario
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I can build this using Excel/VBA. Let me know your views. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 AUD en 5 días
4,7 (6 comentarios)
3,4
3,4
Avatar del usuario
Hello Sir, I have reviewed the xml file and I can write a small windows program to convert this xml to csv for just one PO. Thx Aanvik
$220 AUD en 3 días
5,0 (1 comentario)
2,9
2,9
Avatar del usuario
More than 10 years of experience in content handling and an extensive experience in content conversion using XSLT. Looking forward to get the task.
$110 AUD en 2 días
5,0 (1 comentario)
1,6
1,6
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$150 AUD en 3 días
4,0 (1 comentario)
0,6
0,6
Avatar del usuario
A proposal has not yet been provided
$155 AUD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I guarantee accuracy and time to be perfect and fast. Thanks for considering my offer and contact me any time for any details.
$166 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Its very easy to do. I have done this before. I will show you the demo tomorrow, after that please accept my bid. Thank you.
$155 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I can make xsl within 2 days, but I need an example of csv. Pay attention to a symbol ';' which contains in <POcomment>. Symbol ';' is usually used in csv as separator . In your case it is necessary to choose other symbol or to change contents <POcomment>
$70 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Greetings, It is exciting to see your project requesting an .XSL Stylesheet to convert an XML purchase order document exported from your ERP, Windward System, into the CSV format required by your trading partner. My background offers extensive data translation experience, including significant XML to text translation solutions for multiple business documents via the use of XSLT. As an EDI (Electronic Data Interchange) developer, I understand the importance of successfully meeting the needs of your trading partners. In addition, my experience includes working with purchase order data, both in XML and proprietary formats, such as the CSV required by your trading partner. This project would be completed in two parts. First, a lightweight requirements and design document will be provided for sign-off. After requirements have been confirmed, the next milestone is the XSL file utilizing XSLT 1.0. The .XSL file will include comments summarizing purpose and documenting key functionality concepts as needed. I am hopeful that you will find my skill set an excellent match for your needs. It would be my honor to produce successful results for your organization as my first rewarded bid on Freelancer. Thank You.
$88 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Warragul, Australia
5,0
2
Forma de pago verificada
Miembro desde sept 21, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.