How to upload address book data?

[kkannan]

hi all,
we are in the process of uploading address book datas. we are about to use p0101z1 (address book batch revision). but the thing here is we can enter only one record at a time not like in p4101z1(Inbound Item master inquiry) where we can import multiple datas in one step. Is there any way to import address book datas like item master datas? otherwise we have to enter around 5000 entries manually?


thanks.

kkannan

 

[neil_shepherd]

If you have a little MS Access knowledge you could use it to create an ODBC database link to the F0101Z2 table then use a simple query to populate it from your spreadsheet. The F0101Z2 is the table the P0101Z1 application sit's over. Enter some data into this table via the application then examine it in the UTB to see what's required in each of the fields.

Regards

Neil.

 

[hsiao_te_wang]

Hi Neil,
I have the similar question and appreciated for any your inputs:
Can Z1 programs (either P4101Z1, P3002Z1 or whatever) verify the inbound data accurancy automatically ? I mean if I import the excel file into ZI program and then click "OK", should I get the hard error for data inconsistency (for example, for UDC fields) or ZI programs did not verify the data correctness at all ? If the latter is true, any suggestions to check the data imported to Z1 already ? Thanks !
Regards,
John Hsiao, ERP8.0, SP19
P.S. I tried both on P3002Z1 and P4101Z1but they did not check the data after click "OK".

 

[peterban]

Hi Guys!
From bitter experience of most of the "Z" files and their maintenance
programs I can tell you the following is true
1) The maintenance programs pretty much never work as published!
2) The z files have hidden (undocumented) features to make life interesting
3) The upload programs only work most of the time and may not have all the
validation the "real" program has.
4) A lot of validation and cross checking will be needed outside of JDE
(even NN assignment)

Of late I have started to look at using autopilot as a mechanism for
bringing data into JDE with good results in part - but its still early days
and I have not got all the bugs worked out of my scripts yet. Also (not
being a true OW techy) I have not got the "batch" side working - maybe this
is worth another thread.

Best regards,

Peter

Peter Bannister : [email protected]
1st Consulting Ltd : www.1stconsulting.biz
Mobile : +(44)-7711-649358
Fax : +(44)-7739-256227
E-mail on the move : [email protected]



Product Specialist

 

[parora]

Hi John,

If you are using an external program, e.g. MS Access, to populate the Z1 file, there is no validation done. However, once you have populated the Z1 file and attempt to view/edit the data through P0301Z1/P0401Z1/P0101Z1 etc., if a value is not valid (e.g. not in UDC), it will appear in red as an error, preventing you from saving it. Also, when you eventually do run the Batch Program, say R03010Z, any records that can't be validated will appear in your work center with a reason.

What I have done in the past is pull down my UDC Values, F0005 and create an MS Access query against the data I'm uploading and the UDC Values, F0005. This can save a lot of headaches in the end.