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
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. http://your-server/InnovatorServer/client/scripts/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:
<AML><Item type='Part' action='add'><item_number>124456</item_number><name>My New Part</name></Item></AML>
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 pschroer@aras.com 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.
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
br
bentzi crystal
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.
<Item type="Part BOM" action="add">
<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>
<quantity>4</quantity>
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.
thanks for the fast response
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
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
Hi
Can I use NASH to upload attachments documents files ?
Thanks,
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
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
Dear Eric,
its working fine only the thing is we had to add " / " in the End of to </AML>
thanks al lot
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===============
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:
<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>AVX Corporation<manufacturer> <owned_by_id>Component Engineering<owned_by_id> </Item></AML>
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
Dinesh