Apache OFBiz Blog - March 2019 Update

Hi Everyone A brief summary of our project news for March month can be found in our monthly blog update at the link below: https://s.apache.org/lI4M Thanks to Sharan Foga, Swapnil M Mane, Suraj Khurana, Deepak Dixit, Michael Brohl, Jacques Le Roux and Pranay Pandey for their continued support.

Re: Legacy Data

Using Excel XML features: -In Web tools: -Export the entity you want to work with, one at a time - open it in Excel Windows - Last I checked, Mac excel XML support sucks. But Mac Excel sucks in general. - Excel will figure out the schema and embed it so

Re: Legacy Data

You can also easily generate load data by Excel itself: - create a new sheet and insert a formula concatenating the static parts with the dynamic parts/cells of the data sheet (see example). - apply the formula to each row by dragging the lower right corner of the cell containing the formula

Re: Legacy Data

Hi James, How much legacy data are you talking about importing? It might be more prudent to use an ETL solution to do that. Best regards, Pierre Smits *Apache Trafodion , Vice President* *Apache Directory , PMC Member* Apache

Re: Legacy Data

Hi James, Never used that but we have https://cwiki.apache.org/confluence/display/OFBIZ/Import+Data+Using+Apache+POI+api https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data Look for Excel at