Question

Photo of Ken Roach

0

Is there a data model for Person and Family that I can use to map fields for import?

1

I'm looking at the sample.xml file, trying to work out how to map the field names to those in the file that contains the data I want to import.

Is there a list of standard Family and Person "fields" or attributes?  Can I generate this list using the SQL tool?

What about unique Family or Person attributes?  It doesn't look like the sample.xml file imports any unique family attributes.

I don't have the skills to create an Excavator version based on the F1 import utility, so I'm trying to work out if I can in fact create an XML file that can be imported, and how to map the field names in the sample.xml file to my field names.  (I only have two main files to import: Family and Person.)

  • Photo of David Stevens

    0

    Ken,

    Person attributes are defined under Admin Tools, General Settings, Person Attributes.  You'll notice there is a value in each person's "attributes" section in the XML that maps to a custom FirstVisit attribute.  If you want to add your own attributes and values, you would need to make sure the "attribute" name is the same as the Attribute Key (no spaces) that you defined.

    Most of the Person fields are already included in SampleData.xml and have a corresponding IF statement inside the SampleData.ascx.cs file. If you wanted to access others (like the IsDeceased flag), you would also have to edit SampleData.ascx.cs to include them.  Something like this:
    if ( personElem.Attribute( "isDeceased" ) != null )
    {
        person.IsDeceased = bool.Parse( personElem.Attribute( "isDeceased" ).Value.Trim() );
    }

    Does that help?