ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adrian Crum <adrian.c...@sandglass-software.com>
Subject Re: Data File Tools and Hierarchical Flat Files
Date Fri, 12 Dec 2014 17:02:42 GMT
The easiest way to use the tool is to import the CSV file into a 
specialized table to contain the data. After the import, invoke a 
service that processes the data in the table.

Adrian Crum
Sandglass Software

On 12/12/2014 4:38 PM, Forrest Rae wrote:
> I had a bit more of a play with the tool, read the source, and as far as
> I can tell, it doesn't do anything with relationships.  Basically, it
> will work for the Product entity (as all the examples are based) as
> there is no real relationship involved here.
> Probably best to throw this thing out the window and write one from
> scratch that calls the appropriate services I suppose.  Anyone taken
> this approach before?
> -Forrest
> On 12/11/14, 8:52 PM, Forrest Rae wrote:
>> Hi Guys,
>> I'm a bit stumped by this, and I can't imagine I'm the first person to
>> need to import a bunch of party data from a flat file (CSV).  I'm trying
>> to figure out the Data File Tools.  It makes one small mention of
>> hierarchical flat files:
>> "can support hierarchical flat files (ie where parent/child
>> relationships are implied by sub-records)."
>> I have a CSV file, basically contains a bunch of potential customers
>> from a CRM, exported in the following columns:
>> PartyGroupName
>> Address
>> City
>> stateProvinceGeoId
>> postalCode
>> countryGeoId
>> TelecomNumber
>> Super easy to just import the PartyGroupName, that's much is clear:
>> <record name="PartyGroup" limit="many">
>>   <field name="groupName" type="String" position="0"/>
>> </record>
>> Problem is the PostalAddress and TelecomNumber.  Do I really need to
>> create contactMechs and tie everything together?  How do I model this in
>> the XML schema if not?  The documentation doesn't make another mention
>> of this support for hierarchical flat files.
>> -Forrest
>> https://cwiki.apache.org/confluence/display/OFBENDUSER/OFBiz%27s+Data+File+Tools

View raw message