search

Northteq / Creekridge_Portal

Contains the code for the Creekridge Capital portal.
0 stars 1 forks source link

XML Export file not generating on submission #120

Closed tbstevens closed 9 years ago

tbstevens commented 9 years ago

Issue:

Credit app is submitted but no xml file shows up on the creditApp folder. The error message appearing in Eclipse shows:

16:08:52,520 WARN [http-bio-8080-exec-25][RateFactorRulePersistenceImpl:2852] No RateFactorRule exists with the primary key 0 16:08:52,526 ERROR [PaymentCalculatorUtil:209] com.tamarack.creekridge.NoSuchRateFactorRuleException: No RateFactorRule exists with the primary key 0 16:08:52,578 ERROR [PaymentCalculatorUtil:264] java.lang.RuntimeException: java.lang.NullPointerException

When looking at the submitted creditAppID, the rateFactorRuleID appears to be 0 and it is preventing the xml file feature from working correctly.

Expected:

The rateFactorRuleID should be the rateFactorRuleID from the pricing option chosen to be used for the creditApp, not zero.

tbstevens commented 9 years ago

@divinami - reassigning to Oleg. Just noticed that the creditApp record is not saving the rateFactorRuleID.

tbstevens commented 9 years ago

@olegForce - retested. Similar error that occured with Manage Documents button. I emailed the error.

oleg-underscore-r commented 9 years ago

fixed?

tbstevens commented 9 years ago

@divinami - Mike I believe you're working on finishing this one up. Just wanted to be sure this issue remained open until resolved.

mdivina commented 9 years ago

Fixed.

Creekridge commented 9 years ago

We haven't been shown any part of this functionality - not sure where to look for xml file - cannot test.

tbstevens commented 9 years ago

@Creekridge - The XML files will be exported to the CRCVIP server at the following location: C:\portal\liferay-portal-6.2-ce-ga2\creditApps

Each file in the folder is an xml file titled "creditApp[Customer Name][MMDDYYYY]_[HHMM].xml

Creekridge commented 9 years ago

The file generated, but there isn't any data in the file.

tbstevens commented 9 years ago

@Creekridge - I'm seeing a file in the folder path titled "creditApp_Test_01192015_1600" and there is data in the file.

Creekridge commented 9 years ago

Okay – there is data, but it’s not a valid xml format. Valid xml format would be 10157 for each field.

From: tbstevens [mailto:notifications@github.com] Sent: Monday, January 19, 2015 4:19 PM To: TamarackConsulting/Creekridge_Portal Cc: Sandy Graves Subject: Re: [Creekridge_Portal] XML Export file not generating on submission (#120)

@Creekridgehttps://github.com/Creekridge - I'm seeing a file in the folder path titled "creditApp_Test_01192015_1600" and there is data in the file.

<?xml version="1.0" encoding="UTF-8"?>com.tamarack.creekridge.model.CreditAppcreditAppId<![CDATA[1203]]>companyId<![CDATA[10157]]>userId<![CDATA[11120]]>userName<![CDATA[salesreptester]]>createDate<![CDATA[Tue Jan 13 10:34:37 CST 2015]]>modifiedDate<![CDATA[Mon Jan 19 16:00:41 CST 2015]]>groupId<![CDATA[14278]]>vendorId<![CDATA[14278]]>creditAppStatusId<![CDATA[3]]>productId<![CDATA[502]]>termId<![CDATA[103]]>purchaseOptionId<![CDATA[101]]>rateFactorRuleId<![CDATA[8]]>paymentAmount<![CDATA[4186.83]]>equipmentPrice<![CDATA[200000.0]]>equipmentDesc<![CDATA[Test]]>equipmentLocAsCustomerFlag<![CDATA[true]]>equipmentAddress1<![CDATA[]]>equipmentAddress2<![CDATA[]]>equipmentCity<![CDATA[]]>equipmentState<![CDATA[]]>equipmentZip<![CDATA[]]>CustomerName<![CDATA[Test]]>CustomerDBAName<![CDATA[]]>CustomerAddress1<![CDATA[111 Main St reet]]&g t;CustomerAddress2<![CDATA[111 Main Street]]>CustomerCity<![CDATA[Edina]]>CustomerState<![CDATA[MN]]>CustomerZip<![CDATA[55439]]>CustomerContact<![CDATA[John Smith]]>CustomerContactPhone<![CDATA[(555) 555-5555]]>CustomerContactFax![CDATA[]]>CustomerContactEmail<![CDATA[jsmith@test.commailto:jsmith@test.com]]CustomerBusinessDesc<![CDATA[]]>CustomerBusinessType<![CDATA[]]>CustomerBusinessStartDate<![CDATA[Tue Jan 13 00:00:00 CST 2015]]>CustomerBusinessIncorporatedState<![CDATA[]]>CustomerBusinessFederalTaxID<![CDATA[]]>com.tamarack.creekridge.model.PurchaseOptionpurchaseOptionId<![CDATA[101]]>companyId<![CDATA[10157]]>userId<![CDATA[10201]]>userName<![CDATA[test]]>createDate<![CDATA[Wed Nov 19 11:35:38 CST 2014]]>modifiedDate<![CDATA[Wed Nov 19 11:35:38 CST 2014]]>purchaseOptionName<![CDATA[FMV]]>sequenceNumber<![CDATA[1]]>com.tamarack. creekrid ge.model.TermtermId<![CDATA[103]]>companyId<![CDATA[10157]]>userId<![CDATA[0]]>userName<![CDATA[]]>createDate<![CDATA[null]]>modifiedDate<![CDATA[null]]>termMonths<![CDATA[48]]>termName<![CDATA[48 mo]]>sequenceNumber<![CDATA[0]]>com.tamarack.creekridge.model.ProductproductId<![CDATA[502]]>companyId<![CDATA[10157]]>userId<![CDATA[0]]>userName<![CDATA[]]>createDate<![CDATA[null]]>modifiedDate<![CDATA[null]]>productName<![CDATA[0% for 6 months]]>sequenceNumber<![CDATA[2]]>com.tamarack.creekridge.model.RateFactorRulerateFactorRuleId<![CDATA[8]]>companyId<![CDATA[10157]]>userId<![CDATA[10201]]>userName<![CDATA[test]]>createDate<![CDATA[Wed Nov 19 11:35:38 CST 2014]]>modifiedDate<![CDATA[Wed Nov 19 11:35:38 CST 2014]]>productId<![CDATA[502]]>termId<![CDATA[103]]>purchaseOptionId<![CDATA[101]]>vendorId<![CDATA[14278]]>minP rice< ![CDATA[0.0]]>rateFactor<![CDATA[0.006]]>effectiveDate<![CDATA[Wed Jan 01 00:00:00 CST 2014]]>active<![CDATA[true]]>expirationDate<![CDATA[Fri Jan 01 00:00:00 CST 2016]]>com.liferay.portal.model.GroupVendorName<![CDATA[Vendor1]]>VendorAddress<![CDATA[null null]]>Vendor Cit<![CDATA[null]]>VendorState<![CDATA[null]]>VendorZip<![CDATA[

— Reply to this email directly or view it on GitHubhttps://github.com/TamarackConsulting/Creekridge_Portal/issues/120#issuecomment-70571381.

kdolan12 commented 9 years ago

@Creekridge Sandy - This is valid XML. The reason why the XML is formatted in this fashion is that Java has some native XML outputs that it can perform with not much programmatic effort. Since your end goal was to apply a style sheet to the XML anyways, we did not think there is much ROI in trying to make this formatted in a pretty way.

I have created a sample XSL that will convert the Java generated XML into something more like the XML format you were looking for in the above thread. You can enhance this XSL to get it to the Rapport format as needed.

GIT HUB does not support me attaching XML files, so I'll email you the XML Input, the XSL, and the XML Output for your review. Let me know if you have additional concerns.

Creekridge commented 9 years ago

Confirmed it's working and the file is translatable as demonstrated by the e-mailed files. Will need to further discuss how to update that transform to map into Rapport using current Import process (IDS Import tool) that Tamarack assisted us with. Can close issue and that would be out of scope for this project.