Peruttu

FileMaker Data Base Import from U.S. Census

Export Census Data from FFIEC website and Import into FileMaker DB

Steps:

1. Download 2012 Census Windows Application from [url removed, login to view]

2. Export all Colorado Data for Demographics, Housing, and Income. Exports are limited to 30 fields. Each Table has 300+ Fields.

3. Create 4 FileMaker Tables for Demographics, Housing, Income. Relate tables using County Code, MSA Code, State Code, Tract Code and Year.

Numeric Fields should be type numeric. If you cant tell by the data, make it type text.

4. Import relevant Census Data into Filemaker table. Maintain Exact Field names across Import.

Notes. The 2012 Census Windows Application does not perform a clean Excel export. Rather, one should plan to:

1. Export to Excel

2. Open Excel and Concatenate Rows 1 & 2 into a new row #1

3. Delete the old rows 1 and 2.

4. Save

5. Prepare the FileMaker Table for Import

6. Import into Filemake Using original field names and in the order they originally appear.

Please save the Excel sheets with a naming convention that identifies the underlying data.

Fields. Convert the Fieldnames in this manner.

Trim Spaces

Substitute "/" with "_"

Substitute " " with "_"

Precede all Fields beginning with a number with "f"

Examples.

I have provided several examples and a base working framework.

1. [url removed, login to view] (If you would like to do this in 8,9,10 or 11 that is Fine!)

This is the started FileMaker database. I have imported the first 4 extracts of the Census Demographics table, the 1st extract of the Income table and the 1st extract of the Housing Table.

"Extract" means that you can only export 35 fields at a time. The first 5 fields of each export should be the matching fields (identified above) and then the 30 next fields.

THE FOLLOWING EXCEL FILES ARE THE EXCEL RESULTS AFTER I HAVE MODIFIED THE COLUMN NAMES.

2. [url removed, login to view] - 5 Matching Fields and then the First 30 something fields.

[url removed, login to view] - 5 Matching Fields and then the NEXT 30 something fields.

[url removed, login to view] - 5 Matching Fields and then the NEXT 30 something fields.

[url removed, login to view] - 5 Matching Fields and then the NEXT 30 something fields.

[url removed, login to view] - 5 Matching Fields and then the First 30 something fields.

[url removed, login to view] - 5 Matching Fields and then the First 30 something fields.

3. FFIEC [url removed, login to view] - Screenshot of the Census Windows Application

Taidot: tietojenkäsittely, Excel, FileMaker

Näytä lisää: base code, msa, 300 names excel, filemaker, data base excel, concatenate, census, base one, excel base data, extract excel files, excel framework, excel delete row, convert code excel, excel extract several files, processing export, excel modified, excel website data download, filemaker data import, data table excel, table extract, filemaker data, excel import export, matching files excel, excel text rows, excel matching files

About the Employer:
( 4 reviews ) Amarillo, United States

Projektin tunnus: #4267785

0 freelanceria on tarjonnut keskimäärin $/tunti tähän työhön

Premshanks

Dear sir, I saw the xls created. I know what you mean by matching fiields. i.e. they aer the primary keys that match across the tables. do you want the filemaker pro for all the 300 fields (so it would require m Lisää

$25 USD / tunti
(44 arvostelua)
4.4