red1.org

[red1]

Here i have recreated the New Client on version 252 and shall pass the source and expdat jar to Trifon tonite to incorporate the ILF programs.

ExpDat is in http://red1.org/barn/HutzlerCompiereUSA/sources/data/ExpDat_24.jar

Below are setup notes:
Initial Client Setup
Load accounting_CT.csv
Hutzler/Admin/User
During Client Review > Client Window – Material Policy – (FiFo)FiFo/LiFo
AutoArchive (None) None/All(reports/docs)/Docs/External

Client Info – PriceList (Std)

Org > Created Hutzler and Progressus

Import Accounts 455/448 rows/loaded

3 Errors (missing Acct Elems for 23100 ShortTermObliq, 60432 NY UnempmtIns)
379 Account Element: Inserted
66 Account Element: Updated
434 Parent Account: Updated

Calender for 2005 is already there. Opened June period.

[trifon]

Red1,

I will try to migrate source of ILF to 2.5.2.

I think that i do not need expDat, Will try to define everything in Druid and XML2AD.

Regards,
Trifon
_________________
Trifon Trifonov

[red1]

Source is in http://red1.org/barn/HutzlerCompiereUSA/sources/data/C-252d.rar

Trifon,
Its gud if u do not need the ExpDat to save speed. But can u leave instructions on HOWTO put in the ImportRowDetail into Compiere? In case u got faster way.

thanks.

[red1]

Ah.. finally!... got the ILFs all in.
Trifon, i already migrated ILF source to 252d. I even migrated ImportBPartner and ImportShipper into 252d source.

Posted fresh jars to the Final Nightly Builds thread.

Below are my working notes for the day.

[red1]

I have reverted to a clean earlier dump and redo the full XML2AD and ILF as advised by Trifon.
However the Role for Window Access doesnt seem to work fully, but solved manually.

I also tested import of vendors but hit a missing country error, so i TOAD that and leave this dump with vendors. Thus Rich need NOT load vendors again and proceed with other imports.

I have uploaded the ExpDat to http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_02.jar

I may pass another jar tomorrow if need be, that has Product Categories (Item Classes) and BPartner Category included.

[riche]

Errors so far:
Product Import - "ERR= Invalid ProdCategory, Invalid UOM" errors. Probably just forgot to create the product categories and UOMs.
Customer Import - "ERR = Invalid Country, ERR = NOT FOUND Sales Representative". Invalid country should be an easy fix (I will just fill in US instead of leaving blank). Sales Reps are not being loaded somewhere. I'm not sure if this is a problem caused by Vendor Import, or if there is a problem with Customer Import.
This is as far as I was able to test because of the problems with Customer Import. I will not be able to check forums this weekend, but will check in by IM.

-Rich

[trifon]

I found that when importing new BPartner, Compiere do not create Customer, Vendor and Employee Account entries.

When new BPartner is created from Compiere client, all works well.

Regards,
Trifon
_________________
Trifon Trifonov

[riche]

[red1]

Will have to parse SalesRep as Std as i have previously noted. Cos if its a lookup to the BPartner/SalesRep and they do not exist yet, they wont load, whereas Standard do exist or can be created. We then have to load the BP-sales reps first.

I wonder if this is the case. I tot of leaving this to Trifon while i focus on SalesComm, Freight and BOL. Anyway i can quickly test this later and provide what is the cause.

Trifon did converse with me yesterday that the triggers are 'missing' and not locatable within the source. This has created a suspected problem of missing accounts loading during imports. The ImportBPartner may have to be modified but the codes of populating accounts has to be located first. We are looking for them, and they better be OS.

[red1]

Now, if i remember correctly the SalesReps data are in the Vendors Import File itself (!), thus they cannot check themselves thru the door.

The workaround is simple:

1) Set the SalesRepID ERROR to 'N' but Import Status also to N
2) They will thus be permitted, but the ERROR message appears to inform u.
3) Rerun import, as the SalesReps are now in and those with ERRORS are considered not Imported and thuswill be imported this time.

OR 1 even simpler way without touching the codes at all is to break up your vendors file into 2.
a) SalesReps
b) Vendors

Load and import them fully each in turn (a, then b).

I have checked Trifon's codes, they are sound and well done except that trick data above.

(now i m back to the SlidingTable tweaking cos 252d has a new trxName)

[red1]

Rich told me that its Customers that have those SalesReps IDs. Thus i m barking up the wrong tree.

Now, if Customers cannot find the SalesReps IDs its either due to the values been different, or the codes are wrong, which seems OK. I will TOAD-test one customer.salesrepvalue to see if it fetch that ID now.

[trifon]

Imports must be done in this order:
1 ) Import Vendors.
This will set salesrepresentative to this Vendors which Search Key starts with 'S0'.

2 ) Import Customers.

Regards,
Trifon
_________________
Trifon Trifonov

[trifon]

I just mamaged to fix strange behaviour of BPartner window.

The problem was in XML2AD. It sets IsParent flag to "C_BPartner_ID" column.

How to fix it:
Go to "Table and Column", find "C_BPartner" table.
Go to "C_BPartner_ID" column and uncheck "Parent link column".

I will upload new version of XML2AD soon, on well know place.

Regads,
Trifon
_________________
Trifon Trifonov

[trifon]