Need a piece of software to convert Excel file to TXT for uploading to MYOB
$30-250 USD
Ακυρώθηκε
Αναρτήθηκε περίπου 11 χρόνια πριν
$30-250 USD
Πληρωμή κατά την παράδοση
Need a piece of software that will take file called "Synaps 3 [login to view URL]" and convert into format like "output may [login to view URL]" for me to upload into MYOB. (Sample files are attached)
Software needs to allow"
- Importing xls in format provided
- Smart enough to know that that if the field in "Synaps 3 [login to view URL]" call "Amount Paid" is empty or 0 then ignore line.
- Have the ability to allocate product code to the Description in field called "Shipping method" i.e $4.99 FRDLE Courier to NON RURAL address = FRDLE and use as a sales line in export file. There should be ability to add multiple variable into the software for this and allocate Stock code against it.
- The Following is how the fields are mapped in the "output" file compared to the Input file
Co./Last Name = Source
First Name = No used
Addr 1 - Line 1 = Shipping address
- Line 2 = Shipping address
- Line 3 = Shipping address
- Line 4 = Shipping address
Invoice No. = Blank as this is generated by MYOB
Date = Sale Date
Customer PO = Reference
Ship Via = This should be be linked to "Freight stock code" i.e FRDLE = Courier Post or FRNZPOST = NZ Post
Delivery Status = P
Item Number = Product Code
Quantity = Qty Sold
Description = Blank as MYOB picks this up
Price = Sales Price
Inc-GST Price = Sale Price
Discount = 0
Total = Sale price X Qty
Inc-GST Total = Sale price X Qty
Job = Blank
Comment = Ship Ref
Journal Memo = Sale;Source i.e Sale;Trademe or Sales;Sella
Salesperson Last Name = Blank
Salesperson First Name = Blank
Shipping Date = Blank
GST Code = NT
GST Amount = 0
Freight Amount = BLANK
Freight GST Code = NT
Freight GST Amount = 0
Sale Status = I
Terms - Payment is Due = 1
- Discount Days = 0
- Balance Due Days = 0
- % Discount = 0
- % Monthly Charge = 0
Referral Source = Blank
Amount Paid = Blank
Payment Method = Blank
Payment Notes = Blank
Name on Card = Blank
Card Number = Blank
Expiry Date = Blank
Authorisation Code = Blank
Cheque Number = Blank
Inclusive = X
Category = Blank
Card ID = Linked to Source, Should have ability to set in software ie: Source = Trade Me = Card ID: TRADE ME, Record ID = 5
Record ID = Linked to Source
I am very proficient in c and MS files operation. I have 15 years c++ developing experience now, and I have worked for 5 years, please let expert help you.
A have a lot of experience in operating with files. I have written the complete software for Magnet Mapping system which, among other things, save the measurements into txt file and generates various kinds of reports for the user, including excel, pdf etc.
Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.
I can create an Excel Macro that will allow you to convert the file.
I can do this project. I can make a software which convert .xls file into the .txt file format.
The software will read all the string from the .xls file and convert if into the .txt output file as per your requirements.
Lets get started.