Executable to search a database and make a text file to FTP
€30-250 EUR
已完成
已发布超过 11 年前
€30-250 EUR
货到付款
I want some small program that search in a database and do some other things like replace and saving etc.
----------------------------------
----------------------------------
- I will have a executable (or something) with a userform where I can fill in only a order_nr.
- I must have the possibility to EDIT the program later.
- When I run the program by pressing a button, the program should do the following things:
1. Search for the "order_nr" in a specified database on the server in a local network (DBF type: FoxBASE+/Dbase III plus)
2. Get "ref_nr" from the FIRST row of the order i'm searching for
3. Get from all "row_nr"s from the specified order the "description" and "price"
4. Make a text file
5. Place the variable from step 1 in the first row
6. Place the variables from step 2 each in a new row with a counting up number (not the "row_nr") before each row
7. Save it as a .EDI file, with order_nr as filename, on the local PC AND to an external FTP server (username and password set in the program code)
8. Message if succeed.
----------------------------------
----------------------------------
“[login to view URL]”
order_nr description row_nr price ref_nr
E1 item 1 1 price 1 a
E1 item 2 2 price 2 b
E1 item 3 3 price 3 c
E2 item 1 1 price 1 a
E2 item 2 2 price 2 b
E3 item 1 1 price 1 a
E4 item 1 1 price 1 a
E5 item 1 1 price 1 a
E5 item 2 2 price 2 b
----------------------------------
----------------------------------
Output example of program with order_nr = "E1"
Filename "[login to view URL]"
----------------------------------
----------------------------------
a
1
item 1
price 1
2
item 2
price 2
3
item 3
price 3
----------------------------------
----------------------------------
I am very proficient in db and network programming, I have more than 3 projects experience similar with your task. I can fulfill your task without any question. Please check your pm.
Thanks for the opportunity to bid on your project.
I am a Visual FoxPro developer with 19 years experience covering all versions of FoxPro/visual FoxPro (FoxBase to VFP 9 SP2) and I am very good at it. We are currently supporting commercial Visual FoxPro applications.
Having read your tender, I am ready to begin immediately and to develop the desired program in 5 days. I will supply to you documented source code so that you can later edit the program.
Thank you.
I'd already have experience with automated tasks like this. I'd like to know about your desire to have the possibility to EDIT the program later. Regards.
Hello, I have over 20 years of foxpro and related product experience. The only this i would need to get going would be a sample of the data. Or at least the table layouts so i could create some data to work with. This project seems pretty straight forward and I look forward to completing it for you. Let me know when you would like to start on this.