This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SUPPORT Q&A - Importing data

Danc - Tuesday, July 3, 2007 7:02 PM:

What is the best way to import data from excel or comma delimited text files for parts?

Brent - Monday, December 22, 2008 5:26 PM:

Hi - repeat request for info on the possibility of doing this. I need to dump our part data in the system. Currently all data is excel, which is simple enough to change to access or sql server. How do I define the ID field? What else would I need to define? Our data is simple - just part numbers and descriptions at this point.

We at a loss on moving forward with this without the ability to put in our data, and the import tools don't appear to be available publicly.

Brent

PeterSchroer - Tuesday, December 23, 2008 10:22 AM:

Hey Brent,

The import tool available to Subscribers is a great convenience, but it's not the only way to load high volumes of data. One of the other ways to load data is a tool named NASH. it's a web page in the standard distribution. your-server/.../nash.aspx

NASH is a tool for sending XML to the Innovator web server, and inspecting the XML that is returned. Username/Passord and Database instance are specified in fields at the top of the page. The default action is ApplyAML

For example, in the XML textbox. type the following:

Then hit the Send button. The new Part will be created. You can past hundreds of <Item type='Part'>... tags in between the <AML> tags. You don't need to specify the ID or any of the System fields using this technique. When I have data in Excel, it's easy to create this XML format. Insert new columns before and after the column that has the parter number for example, and in these columns add the XML tag names etc. such that when you export the Excel to text, you only need a minor cleanup in a text editor to remove tabs or commas, to create perfect AML ready for NASH.

Drop me an email [email protected] and let me know more about your company and how you are planning to use Aras Innovator. if the NASH idea does not work for you, we can trade use of the standard Import tool for some help in community building (ie. marketing) if you are able to invest some time.

bentzi crystal - Tuesday, March 10, 2009 5:41 AM:

Hi Peter

thanks for your help, some questions about importing information,

in your above example, can we use this format:

Normal 0 MicrosoftInternetExplorer4

<AML>

<Item type='Part' action='add'>

<item_number>partnum #1</item_number><name>partnum #1 name</name>

<item_number>partnum #2</item_number><name>partnum #2 name</name>

</Item>

</AML>

any limit to the number of the importing items?

How can we use the NASH to import topdown nested BOMs (from an excel or a text file)?

do you know where I can find a user guide/help for the NASH tool?, probably the NASH can be used to import other batch info

bentzi crystal

mark_chen - Thursday, July 14, 2011 11:25 PM:

Can I use NASH to upload attachments documents files ?

Thanks,

gixer_racer - Tuesday, November 19, 2013 4:02 PM:

Peter,

A few questions for you or one of the technical staff. First one is easy:

Is there a link somewhere in the subscriber portal for the batch uploader utility? I could not find it and we do not have a CD (as indicated on the developing solutions training) since an ARAS partner did our initial installation.

For the more pressing issue, I'm trying to use the NASH tool to do some batch uploading of some new part numbers and attributes.

For string fields, I'm having no problem uploading data (item_number, name, etc.). However, I'm having no luck with attributes that are either a list or item with ordered data. For the "list", it imports my value to the Grid view, but when I open the part, that field remains blank. For the reference data field (we have a 4 digit code that loads a predefined description), it's telling me that my field is not valid.

I'd be happy to send some screen shots if needed to show what properties/item types are on my part, the part form, etc.

In the above code, the FS01034 populates within the grid view of parts, but when I open the part, it is not visible. The value is a valid value from the parts list.

The fields that have an elipse near them for menu selection, I'm not having any luck figuring out.

heidi - Thursday, September 4, 2014 7:57 AM:

Hi All

I am trying to import into aras using this method. The error I get is as follows, please help me with what this means?

-<SOAP-ENV:Envelope>

-<SOAP-ENV:Body>

-<SOAP-ENV:Fault>

<faultcode>SOAP-ENV:Server</faultcode>

<detail>Error loading ui_resources.xml file.</detail>

</SOAP-ENV:Fault>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

Thanks!

Never mind! was a log in issue. just needed to press "log in".

PeterSchroer - Tuesday, March 10, 2009 8:13 AM:

Bentzi

no limit on the number of Items in the AML transaction. The only problem might be a timout on the transaction (browser is waiting for a reply from the server) if you have tens of thousands of records. I would normally create blocks of 100 +/- just to simplify data handling.

Same format is used to import a BOM. AML supports the creation of Assembly, BOM record and Component in one transaction, or if you have already loaded your Parts, then you can use AML to just make the BOM links.

<source_id><Item type="Part" action="get" where="Part.item_number='xxx'"/></source_id>

<related_id><Item type="Part" action="get" where="Part.item_number="yyy"/></related_id>

</Item>

This AML would make a BOM link with Qty=4 between an assy named XXX and a Component named YYY, assuming that you have already loaded the Parts.

Or you can load everything at one time.
<Item type="Part: action="add">
     <item_number>XXX</item_number>
     <Relationships>
                  <Item type="Part BOM" action="add">
                       <quanity>4</quantity>
                       <related_id>
                           <Item type="Part" action="add">
                                 <item_number>YYYY</item_number>
                          </Item>
                        </related_id>
                   </Item>
            </Relationships>
</Item>

NASH is just a tool for sending AML to the Server. The same AML that is used internally by the standard client and the API's. What you need is documentation on AML not on NASH. Try the Programmers Guide which should be on-line in the documentation area of the web site. The entire AML command set is documented in this guide.

bentzi crystal - Tuesday, March 10, 2009 10:16 AM:

thanks for the fast response

[email protected] - Friday, July 29, 2011 2:09 AM:

Dear Peeter,

when i want to add the below items to manufactures list it only adds the first entry and not all .

<AML>

<Item type="Manufacturer" action="add">

<name>AFTEK</name>
<name>Analogic Tech</name>
<name>APLUS</name>
<name>Aries Electronics</name>
<name>Atmel</name>
<name>Auk</name>
<name>Avago Technologies US Inc.</name>
<name>AVX Corporation</name>
<name>Bivar Inc</name>
<name>Bivar Inc.</name>
<name>Chicago Miniature</name>

</Item>

</AML>

kindly sugest how to update all in one move

regards,

dinesh

Jennifer - Tuesday, November 19, 2013 4:45 PM:

Hi Gixer -

Your subscriber representative will follow up with you directly.

Best,

Jennifer

natek64 - Tuesday, June 23, 2009 7:35 PM:

Hi Peter,

OK, this worked great to import several hundred parts and creating relationships between them looks straightforward. We have a one-to-one relationship between parts and products. Will this work for creating a relationship between products and parts? We don't have model numbers in the sense that Aras appear to be set up to use them.

Thanks in advance,

Nate

eric_h - Friday, July 29, 2011 11:17 AM:

Dinesh,

I have done a little AML stuff already, but not enough to be an expert. But I think you need an <Item> tag for each name value you add. So the above would be:

<AML>
    <Item type="Manufacturer" action="add"><name>AFTEK</name></Item>
    <Item type="Manufacturer" action="add"><name>Analogic Tech</name></Item>
    <Item type="Manufacturer" action="add"><name>APLUS</name></Item>
    <Item type="Manufacturer" action="add"><name>Aries Electronics</name></Item>
    <Item type="Manufacturer" action="add"><name>Atmel</name></Item>
    <Item type="Manufacturer" action="add"><name>Auk</name></Item>
    <Item type="Manufacturer" action="add"><name>Avago Technologies US Inc.</name></Item>
    <Item type="Manufacturer" action="add"><name>AVX Corporation</name></Item>
    <Item type="Manufacturer" action="add"><name>Bivar Inc</name></Item>
    <Item type="Manufacturer" action="add"><name>Bivar Inc.</name></Item>
    <Item type="Manufacturer" action="add"><name>Chicago Miniature</name></Item>
<AML>

If I am wrong, hopefully someone can correct what I am saying here.

Eric

PeterSchroer - Monday, June 29, 2009 3:52 PM:

Nate,

The standard Aras datamodel for Product-Model-Part may not be the best fit for you. I'd recommend creating your own ItemType to represent Products with a relationship to Part. For ease of upgrade, creating a new "Product" itemype named "nate_product" would be bettter than modifying the exisitng Itemtype.

Peter

[email protected] - Monday, August 1, 2011 4:30 AM:

Dear Eric,

its working fine only the thing is we had to add " / " in the End of to </AML>

thanks al lot

dinesh

[email protected] - Monday, August 1, 2011 4:43 AM:

Dear Eric

I had now Manufacturer part associated with the Manufactures

I want to add parts but how to get manufactured and Identity from database.

With this script iam not able to add the manufactured and Identity from database.

==========Code Starts==============

<AML>
<Item type="Manufacturer Part" action="add">
<item_number>demodata1</item_number>
<name>Name of Manufacturer Part</name>
<description>Description of Manufacturer Part</description>
<unit>EA</unit>
<unit_price>50</unit_price>
<Relationships>
<Item type="Manufacturer" Manufacturer="AVX Corporation" action="get"></Item>
<Item type="Identity" owned_by_id="Component Engineering" action="get"></Item>
</Relationships>
</Item>
</AML>

=============Code Ends===============

eric_h - Tuesday, August 2, 2011 6:08 PM:

Dinesh,

I am just taking a guess at this, but 'manufacturer' and 'owned_by_id' are not actually relationships in the standard Aras sense. They are just properties of data type 'Item' which means they link to another item type (they do not have their own relationship tab.) As such, in the AML, you might not need the 'Relationships' tag set, but can instead treat these fields like any other properties. This is just a guess, but this is the AML I would try first (you will of course need an 'Item' tag set for each part you add.) If you try it, let me know if it works. My only concern is that the values as stored in the 'Manufacturer Part' table will be as the GUID for the manufacturer and owned_by_id, so not sure if the AML below will convert that properly, or do you need to actually get the id for what you want to add:

Eric

[email protected] - Tuesday, August 2, 2011 7:42 PM:

Dear Eric,

Manufacturer amd identity (owned_by_id) is the item type we need to pick from database through link so when we use this script

manufacturer>AVX Corporation<manufacturer> (We earlier created )
<owned_by_id>Component Engineering<owned_by_id> (identity)

are not created

regards,

Dinesh

eric_h - Wednesday, August 3, 2011 1:18 PM:

Hi Dinesh,

I was worried about that. Because the Mnf. Part table stores the 'item' properties as GUID links to entry in the associated tables, you need to do a 'get' on these item types to get the proper ID. I tested this, and it seems to work as expected:

<AML>
    <Item type="Manufacturer Part" action="add">
        <item_number>demodata1</item_number>
        <name>Name of Manufacturer Part</name>
        <description>Description of Manufacturer Part</description>
        <unit>EA</unit>
        <unit_price>50</unit_price>
        <manufacturer>
            <Item type="Manufacturer" action="get">
                <name>AVX Corporation</name>
            </Item>
        </manufacturer>
        <owned_by_id>
            <Item type="Identity" action="get">
                <name>Component Engineering</name>
            </Item>
        </owned_by_id>
    </Item>
</AML>

By the way, my example yesterday was missing to slashes in the closing tags, but it was not right anyway. I think this here should work though.

Eric

sabika kazmi - Friday, January 30, 2015 12:10 PM:

Hi!

If in case somebody else needs the answer to Dinesh's question-

To add a manufacturer part with the existing manufacturer and Identity.

AML would be like this-

<....>------</ > (Any other properties if required)

<owned_by_id>

<name>Name of Identity</name>

</Item>

</owned_by_id>

<name>Name of Manufacturer</name>

</Item>

</manufacturer>
</Item>

Regards,

Sabika

[email protected] - Thursday, August 4, 2011 12:03 AM:

Dear Eric,

Great Work done,

U had opened the doors for mass data upload

its working .....

Thanks

Dinesh

rvdijk - Wednesday, March 7, 2012 11:19 AM:

Dear All,

I am new to ARAS and AML but learning fast thanks to the forum posts. I was able to create codes for mass upload PARTs, Manufacturing Parts including relationships. Now I am looking for a solution to mass upload CAD-files. Is this possible through AML also?

Hope for positive repsons =D

BR,

Rob

NINJA - Friday, May 25, 2012 5:18 AM:

Dear All

Does anyone know how to add a Released part ?

I tried ' <state>Released</state> ' and ' <is_released>1</is_released> ' but it is not work.

Best Regards.

SUPPORT Q&A - Importing data

Legal

Connect With Us