Find Jobs
Hire Freelancers

Modification of Existing VBA Code

$30-250 USD

Terminado
Publicado hace más de 10 años

$30-250 USD

Pagado a la entrega
We need someone to modify the module "mdlShip_Manifest" in the attached database to account for the change in the source files that are used to create the data. The current module will take data from all .csv files that are located in the database's directory in the user's computer and populates a .csv called [login to view URL], which is also attached. A few examples of the current formatted file is attached, and all begin with "856-". The new file format is attached, and called SAMPLE ASN FTP.csv. There can be 1 or 1000 of these files that need to be processed. In SAMPLE ASN [login to view URL], the field PO_Number, is the 3rd field from the left, in the header row. This field should be repeated for all records to be included from the same file. The 3rd field from the left is the tracking number, and UPC is the 5th column from the left. The 6th column, should be space delimited to populate the columns SKU, Size1, and Size2, where the data will be populated in that order. As an example, for LP337KH 36 30, which is in the 4th row, LP337KH would go to SKU, 36 would be Size1 and 30 is size2. Likewise, in row 6, for LP337KH 32 30, LP337KH is SKU, size1 is 32 and size2 is 30. The last column is quantity.
ID del proyecto: 5204447

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 10 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 Marc, I hope you remember me, actually I wrote the old version of this script for you :) If you are still interested in working with me, I can modify the code to handle the new file format. This can be completed on Monday. Best Regards, Slavisa Tosic
$80 USD en 3 días
5,0 (64 comentarios)
5,2
5,2
1 freelancer está ofertando un promedio de $80 USD por este trabajo
Avatar del usuario
Hi, I'm an expert MS-Access / SQL / VBA developer and can do this job for you. I have experience with data file imports using VBA and can make the required changes to accommodate the new format data files. I can deliver in 1 - 2 days. Thanks for considering me. Bests, Larry
$231 USD en 3 días
5,0 (15 comentarios)
4,6
4,6

Sobre este cliente

Bandera de UNITED STATES
bronx, United States
5,0
138
Forma de pago verificada
Miembro desde jun 6, 2008

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.