ONLY APPLY IF YOU HAVE AT LEAST 2 YEARS VISUAL FOXPRO PROGRAMMING EXPERIENCE AND CAN START IMMEDIATELY. This task is not difficult, but I will have separate follow-up projects that will require a high level of VisFox skills.
I have 800mb in 3 related CSV files that I want to combine into 1 flat file in Visual FoxPro DBF format.
Step 1 = Create 1 flat file with fields identified with a “1” in the BLUE columns in the attached TABLES AND FIELD NAMES.XLSX. Add extra fields to identify if information is repeating for multiple rows in the 2nd or 3rd tables. Use MEMO fields for VARCHAR. Use the date field, not the date-time field.
Attached are reduced versions of these files with 10k records each.
ACCOUNT_APPRL_YEAR_10k.csv (25 fields)
ACCOUNT_INFO_10k.csv (29 fields)
RES_DETAIL_10k.csv (33 fields)
Only send me the empty VisFox database.
Step 2 = Write a simple FoxPro program to combine the data into 1 flat file. Include a screen prompt as to whether to import from the files with “_10k” in their filename or my original versions without the 10k:
ACCOUNT_APPRL_YEAR.csv (25 fields)
ACCOUNT_INFO.csv (29 fields)
RES_DETAIL.csv (33 fields)
This program must copy any rows with misaligned data into separate CSV files. It should display counts of records processed, etc. and save these in a log file. The program must be simple and easy for me to follow. It must be well commented.
FUTURE VISFOX AND DATA ANALYSIS TASKS WILL BE CONTRACTED SEPARATELY
ENTIRE DATA SET:
If you want to use the entire 182mb zipped data set go to
I am working with the 2015 Certified Data Files at Certification (Comma Delimited 07/23/2015)