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.
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
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