Media Object Mass Upload

[Siva Kumar Kommoju]

Hi Guys,

I've a requirement to upload the list of "Text Descriptions" for
Orders to be uploaded to the media Object Table (F00165) .

Adding to the Media Object descriptions individually throw standard
application take to much time , so we planned to design a mass Upload
Application, if we Run that application all the "Text Descriptions"
for the corresponding orders are going to insert into Media Object
Table.

1)I tried to create a Table Conversion to Upload but Media Objects
Data Item are Store in BLOB format , it is not Allowing us to assign
Data to it .
2)BLOB Data Item Can not be added Business View , So can't Run UBE
also


Please give a solution to Upload Data into Media Object Table.


Thanks
SivaKumar.K

[Jayakumari Solomon]

Hi..

 

 

Try to create Report and use that Media Object which is used by the Appln.

Based on the data selected u can Add & Modify Media Object Text .

 

 

--
Thanks & Regards,
Jaya.

[Siva Kumar Kommoju]

Hi jaya,

I've tried with report , it's working fine for getting the Text from
the Media Object(MO) Table for the Given combination but not for
adding the TEXT in MO table

I tried with media Objects Api's it's working fine with the following
code

JDEDB_RESULT JDBReturn = JDEDB_PASSED;
HREQUEST hRequestGT = NULL;
HUSER hUser = NULL;
JCHAR szFromDatasource[51] = _J(“Business Data – Adev733o”); /* Data
Source*/
JCHAR szObjectName[11] = _J(“ABGT”); /* Media Object Name*/
JCHAR szFormatKey[255] = _J(“1”); /* Primary Key*/
JCHAR szLang[3] = _J(“”);
LPMODATA lpGTData = NULL;
MODATA dsGTNewData = {0};
JCHAR szText[255] = _J(“New Text to be inserted”); /* Actual Text
Going to insert in F00165 Table ,*/

JDBReturn = JDB_InitBhvr(.., &hUser);

JDBReturn = jdeGT_OpenTable (hUser, szFromDatasource, szObjectName,
&hRequestGT);
if (JDBReturn == JDEDB_PASSED)
{
JDBReturn = jdeGT_SelectDataKeyStr (hRequest, szObjectName,
szFormatKey, szLang,

OBJ_JDEALL);
}

if (JDBReturn == JDEDB_PASSED)
{
JDBReturn = jdeGT_FetchData(hRequest, lpGTData, FALSE;
if (JDBReturn != JDEDB_PASSED)
{
dsGTNewData.nSeq = 1;
dsGTNewData.nMOType = OBJ_RTFTEXT;
dsGTNewData.pData = szText;
jdeStrcpy(dsGTNewData.szItemName, _J(“New Text”));
jdeGT_InsertDataKeyStr(hRequest, szObjectName, szFormatKey, 1,
szLang, &dsGTNewData);
}
else
{
jdeGTFreeMOData(lpGTData, 1);
}
}

jdeGT_CloseTable(hRequestGT);
JDB_FreeBhvr(hUser);

return;



We have to call the above Business function in Table Conversion with
input as Flat File (Excel ---having all “Text Descriptions” with the
Key Combination).


Thanks
SivaKumar.K

On Oct 23, 2:57 pm, Jayakumari Solomon <jayakumarisolo...@gmail.com>
wrote:

> Hi..
>
> Try to create Report and use that Media Object which is used by the Appln.
> Based on the data selected u can Add & Modify Media Object Text .
>
> --
> Thanks & Regards,
> Jaya.
>
> On Fri, Oct 23, 2009 at 1:09 PM, Siva Kumar Kommoju

> <sivakumar...@gmail.com>wrote:

>
>
>
>
>
> >  Hi Guys,
>
> > I've a requirement to upload the list of  "Text Descriptions" for
> > Orders to be uploaded to the media Object Table (F00165) .
>
> > Adding to the Media Object descriptions individually throw standard
> > application take to much time , so we planned to design a mass Upload
> > Application, if we Run that application all the "Text Descriptions"
> > for the corresponding orders are going to insert into Media Object
> > Table.
>
> > 1)I tried to create a Table Conversion to Upload  but Media Objects
> > Data Item are Store in BLOB format , it is not Allowing us to assign
> > Data to it .
> > 2)BLOB Data Item Can not be added Business View , So can't Run UBE
> > also
>
> > Please give a solution to Upload Data into Media Object Table.
>
> > Thanks

> > SivaKumar.K- Hide quoted text -
>
> - Show quoted text -