ISTech Support Forum - IN-B RoHS Data Entry.

AndyOB

Full Member

Humm...

Posts: 154
Gender: male

IN-B RoHS Data Entry.
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

Back to top

--
Andy O'Brien of Nortra Cables, Inc.
Milpitas, CA

IP Logged

dameng Senior Member DBA / EVO Software Consultant Posts: 275 Gender:	Re: IN-B RoHS Data Entry. Reply #1 - 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.
Back to top	Dave Mengelkamp Digital Consulting 760.832.2536 davemeng@earthlink.net IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: IN-B RoHS Data Entry. Reply #2 - 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.
Back to top	IP Logged

AndyOB

Full Member

Humm...

Posts: 154
Gender: male

Re: IN-B RoHS Data Entry.
Reply #3 - 12/09/10 at 10:53:01

Quote from 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.

Umm...

Quote from 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.

What...

No idea how to do either of that.

Back to top

--
Andy O'Brien of Nortra Cables, Inc.
Milpitas, CA

IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: IN-B RoHS Data Entry. Reply #4 - 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.
Back to top	IP Logged

AndyOB

Full Member

Humm...

Posts: 154
Gender: male

Re: IN-B RoHS Data Entry.
Reply #5 - 12/09/10 at 12:52:29

Quote from 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.

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.

Back to top

--
Andy O'Brien of Nortra Cables, Inc.
Milpitas, CA

IP Logged

GasGiant

Administrator

How can I help?

Posts: 1517
Gender: male

Re: IN-B RoHS Data Entry.
Reply #6 - 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.

Back to top

IP Logged

AndyOB Full Member Humm... Posts: 154 Gender:	Re: IN-B RoHS Data Entry. Reply #7 - 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.
Back to top	-- Andy O'Brien of Nortra Cables, Inc. Milpitas, CA IP Logged

GasGiant

Administrator

How can I help?

Posts: 1517
Gender: male

Re: IN-B RoHS Data Entry.
Reply #8 - 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"?

Back to top

IP Logged

AndyOB Full Member Humm... Posts: 154 Gender:	Re: IN-B RoHS Data Entry. Reply #9 - 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
Back to top	-- Andy O'Brien of Nortra Cables, Inc. Milpitas, CA IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: IN-B RoHS Data Entry. Reply #10 - 12/10/10 at 06:05:11 Quote from GasGiant on 12/09/10 at 14:02:23: A few questions... Is their a server DSN set up on your Pervasive server? Yesterday must have been a hard day. Did I REALLY use "their" in place of "there"?
Back to top	IP Logged

AndyOB Full Member Humm... Posts: 154 Gender:	Re: IN-B RoHS Data Entry. Reply #11 - 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?
Back to top	-- Andy O'Brien of Nortra Cables, Inc. Milpitas, CA IP Logged

NovaZyg Administrator When all else fails.. Read the instructions. Posts: 789 Gender:	Re: IN-B RoHS Data Entry. Reply #12 - 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.
Back to top	Allen Landry Evo~ERP EvoERP and DBA Classic always Beta's of the Latest versions. IP Logged

AndyOB Full Member Humm... Posts: 154 Gender:	Re: IN-B RoHS Data Entry. Reply #13 - 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
Back to top	-- Andy O'Brien of Nortra Cables, Inc. Milpitas, CA IP Logged

dameng Senior Member DBA / EVO Software Consultant Posts: 275 Gender:	Re: IN-B RoHS Data Entry. Reply #14 - 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.
Back to top	Dave Mengelkamp Digital Consulting 760.832.2536 davemeng@earthlink.net IP Logged