Write code to convert the Excel file into EDI format

I have excellent command on MS Excel and can convert the Excel to the required EDI format. I went through the attachments provided and was able to correlate most of the data and I am confident that I can write the macro to achieve this I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair, pinnacle and tennisinsight websites - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API - Built a complex shift allowance calendar and calculator You can see the reviews of the same in my profile

Hi there, I can write PHP code to convert the Excel format directly to EDI format as per specifications. It's a few hours job. I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than 1100 projects over 11 years. Thanks. I look forward to hearing from you Regards, Rajesh Soni.

Hi there..... Warm Greetings We came along with your request for code to convert the Excel file into EDI format and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Processing, Excel, PHP, Software Architecture We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

Hi, I have a VBA code which generate the EDI files from Excel. But need to check your file before. Thanks

This can probably done with an Excel macro. Is that a possibility or do you have security restrictions that could prevent you from using macros?

I am very good and experienced programmer so I insist you give me a chance to try to make your code. Just allow me to do this work by offering this job to me.

I carry diversified integration knowledge by having experience of 12 years in integration space. Worked as SOA Architect, B2B Integration Specialist, ESB designer and implementer. Exposed to different integration tools like webMethods, Dello Boomi, Bots, Mond, MuleSoft. My Analysis: I have gone through the source PDF and target EDI structures at high level. I feel there are no complex transformation logic required to be implemented. However I have below few questions specific to the task: 1. Have you already procured SAD login from RRC? 2. shared EDI file do not seems to be valid EDI file as it is missing few mandatory rows. That can be identified by using EDI test site provided by RRC. Prerequisite to test EDI is SAD login! 3. What is the volume of data (in terms of number of records and frequency) 4. Appreciate if you can share Excel file that you use for data entry on website I can complete this piece of work in 1 - 1.5 days. But system needs to be set up for you to automate this to suit your frequency of reporting. We may have to evaluate if you want to keep self maintenance as an option. My Plan of action: Mapping from source field to target EDI field - 5-6 Hrs Development as per above identification - 3 Hrs Testing in RRS site to comply to website standard - 1 Hr Discussion to tailor your automation to run source files regularly. Thanks, Naveen P L 9986746476