Upload an XML/CSV Transmission problem

[pmalin]

Describe my steps. I choose file and click UPLOAD and data uploaded then BUT i dont have second step when i need to choose TRANSACTION CODE and smth else.

I guess i need to enable this option but dont know how and where. Any ideas?

[cunninghamg]

Re: Upload an XML/CSV Transmission problem

What you are describing is what happens when you upload a csv file.

When you upload an xml, the transaction codes are specified with the xml - so the file just gets processed.

Regards
Gary

[chrisplough]

Re: Upload an XML/CSV Transmission problem

In addition - if you package your CSV files up into a zip file, you can put the transaction code in the control file -- giving you the same flexibility.

--Chris

[Nadeem Naqvi]

Using Python in Oracle Procedure

Hi all,

I have created the given below python script in Linux and now trying to incorporate the same in my PL/SQL Procedure.

What is the best way to call this script in Oracle Procedure??

python ClientUtil.py -command csvImport -hostname abc -username GLOG.ADMIN -password ABC -localDir /csv_file -localFileName abc.csv -csvUtilCommand i -xvalidate=None

[Sachin]

Re: Upload an XML/CSV Transmission problem

What you are describing is what happens when you upload a csv file.

When you upload an xml, the transaction codes are specified with the xml - so the file just gets processed.

Regards
Gary

Hi,

I'm trying to upload a location XML. I have entered the username & password in the xml, also the transaction code as IU.

But i'm unable to upload this xml through integration manager. I'm getting an exception error(attached). I've also attached the location xml which i tried uploading.

Could any body help me in identifying what's wrong in the xml?

Regards,
Rajiv

[Sachin]

Re: Upload an XML/CSV Transmission problem

Unable to upload in xml format. Hence attached in notepad.

[josephliang]

Re: Upload an XML/CSV Transmission problem

Your XML is not valid against to OTM schema (GLogXML.xsd)
Use any XML editor to correct the XML before uploading to OTM.
In addition, whenever you try to create an object, e.g. Location, Order, etc., do NOT include Status elements.

[LourensGlog]

Re: Upload an XML/CSV Transmission problem

To learn a bit more about uploading data, read the Integration Guide, as mentioned here.

Unfortunately for you, Oracle doesn't tell you how your message should look like other than to follow the schema, and there are dozens of do's and dont's like the ones that Joseph shared, that are not documented.

[Sachin]

Re: Upload an XML/CSV Transmission problem

Your XML is not valid against to OTM schema (GLogXML.xsd)
Use any XML editor to correct the XML before uploading to OTM.
In addition, whenever you try to create an object, e.g. Location, Order, etc., do NOT include Status elements.

Hi Joseph & Lourens,

Thanks for your replies.

We extracted the xml from GlogXML.xsd and used it to create new locations in OTM. Here we face an issue like when we try to insert a new location with an existing corporation (parent location gid) in OTM, xml gets processed with out any error.
But when we insert a new location with a new corporation id (parent location gid) the transmission errors out.

Is it not possible to create a new corporation (parent location gid) along with a new location in a single xml transmission?

Regards,
Rajiv

[Sachin]

Re: Upload an XML/CSV Transmission problem

Hi all,

We are developing an interface to create locations in OTM through integration. As I mentioned earlier post, the problem is whenever we try to pass a location with new corporation ID the transmission errors out.

The log file says "Cannot Update the LOCATION_CORPORATION record".

We are passing Corporation GID/XID as parent location GID/XID in xml. What we understand is when we pass parent location GID/XID OTM is trying to update LOCATION_CORPORATION table only and since this is not available in CORPORATION table, it errors.

It will be of great help to us if any one can tell how to create a new corporations through xml transmission?

Thanks,
Rajiv

[Sachin]

Re: Upload an XML/CSV Transmission problem

Hi,

Creation of new corporation through inbound integration is not supported directly and we followed the below workaround and it worked for us.

1. Create Location ID the same as the Corporation ID (Location ID in Parent Location GID). Doing this OTM creates a Corporation and Location with the same ID.

2. Next we can send the location xml with the above created new corporation ID.

Regards,
Rajiv