|
ISTech Support Forum
http://www.istechforum.com/YaBB.pl Evo-ERP and DBA Classic >> Items >> IN-B RoHS Data Entry. http://www.istechforum.com/YaBB.pl?num=1291332195 Message started by AndyOB on 12/02/10 at 16:23:14 |
|
Title: IN-B RoHS Data Entry. Post by AndyOB on 12/02/10 at 16:23:14 Here's a simple problem that I think warrants a simple solution. Customer gave a list of 500 assemblies (FGIs) they want to make sure are RoHS, China RoHS, REACH, and Halogen Free. I setup user defined fields for China RoHS, REACH, and Halogen. I want to get a listing all items used in these 500 assemblies so we can search for anything that is not compliant. A lot of these assemblies use the same parts multiple times, but I'm not worried if I get 10-20 entries for the same item. Ideally I'd like to spit out a .CSV (Comma deliminated) file with just the regular inventory part #'s, and the RoHS + 3 user defined fields for all these assemblies so I can just sort them in excel and check off each part as RoHS or not. Getting the info back into Evo I've never tried, but I assume I can just re-import the data from the CSV file. Can anyone help? Thanks much, -Andy@nortra-cables.com |
|
Title: Re: IN-B RoHS Data Entry. Post by dameng on 12/09/10 at 09:56:02 simple solution: have a crystal report created to list that information. then use the report viewer to print or if you really want, export to excel. |
|
Title: Re: IN-B RoHS Data Entry. Post by GasGiant on 12/09/10 at 10:17:06 I'd use MSQuery to pull the data into Excel and probably a pivot table to narrow the list. Five minutes. |
|
Title: Re: IN-B RoHS Data Entry. Post by AndyOB on 12/09/10 at 10:53:01 GasGiant wrote:
Umm... dameng wrote:
What... No idea how to do either of that. |
|
Title: Re: IN-B RoHS Data Entry. Post by GasGiant on 12/09/10 at 12:14:57 Sorry to hear that. Very limiting. If you use DE-A to dump MTICMSTR.B and look at the MTIC.SUBST[2] - MTIC.SUBST[5] fields for your user defined fields you should see your other classifications. |
|
Title: Re: IN-B RoHS Data Entry. Post by AndyOB on 12/09/10 at 12:52:29 GasGiant wrote:
Seems like MSQuery isn't too difficult to figure out. Once the data is retrieved can it be pushed back into Evo? When I select Pervasive ODBC Client Interface when creating a new data source and clicking connect it's asking for a Username/Password. What is it expecting here? Were running Pervasive 2000i SP3 on a 2k Server. Thanks for your assistance. |
|
Title: Re: IN-B RoHS Data Entry. Post by GasGiant on 12/09/10 at 13:10:18 Generally, you do not want to write data into a running DBA/Evo system, but it can be done. If you do decide to write to the Pervasive tables be sure to make a back up and have everyone out of Evo. However, adding data is not a simple process. I have created a number of browser-based tools to allow direct updating of various fields, but the user-defined fields are a real bear to work with. User name and password are nearly always blank. |
|
Title: Re: IN-B RoHS Data Entry. Post by AndyOB on 12/09/10 at 13:18:31 Error if I leave the fields blank, it says: Connection attempt timed out. The SQL Connection Manager may be inactive or using a different transport protocol from the client. Driver's SQLSetConnectAttr failed -A. |
|
Title: Re: IN-B RoHS Data Entry. Post by GasGiant on 12/09/10 at 14:02:23 A few questions... Is their a server DSN set up on your Pervasive server? On the client, in the Server section you have entered the IP address of the Pervasive server and selected "Try TCPIP only"? In the Data Source Name drop down (after clicking the Get DSN List button), you have selected the server DSN that was created on the Pervasive server? Once the above is done, try clicking the Test button on the right. Does it say "Connection Successful"? |
|
Title: Re: IN-B RoHS Data Entry. Post by AndyOB on 12/09/10 at 15:00:36 Got it, added a DSN connection and can use MSQuery now. Thanks for your help, hopefully this will speed up the process. -Andy |
|
Title: Re: IN-B RoHS Data Entry. Post by GasGiant on 12/10/10 at 06:05:11 GasGiant wrote:
Yesterday must have been a hard day. Did I REALLY use "their" in place of "there"? :'( |
|
Title: Re: IN-B RoHS Data Entry. Post by AndyOB on 12/13/10 at 14:57:44 Normally I would of caught that, but I was in a rush. Fingers run on autopilot sometimes. Hey, Is there an easy way to export Where Used data for an inventory item? |
|
Title: Re: IN-B RoHS Data Entry. Post by NovaZyg on 12/13/10 at 17:06:52 If you have Evo then just run IN-A and type in a Part number. press the Where used button, then when the grid comes up press the Print button. Select Print to File and that should do it. |
|
Title: Re: IN-B RoHS Data Entry. Post by AndyOB on 02/11/11 at 11:30:15 Old Thread, new question... Wanted to Query the RoHS field in Evo, but I can't find it in the DBAFILEn.xls file or searching around the MTIC fields. The T6BMB1.RTM report just says the RoHS field is "rohs". Any help appreciated. -Andy |
|
Title: Re: IN-B RoHS Data Entry. Post by dameng on 02/16/11 at 18:08:19 the RoHs field as designated in the Item Master IN-B holds that flag setting in the BKICMSTR file using the BKIC.PROD.DPTNT field. |
|
ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved. |