How to into flatfile data (or) record into database

, ,
1

Hi Everyone,

              I am new to webmethods,i am trying to insert data into oracle database using flatfile but i couldn't able to find these services in my developer (version is 7.1)

DBToFF: SelectAdapter

Transformations.FlatFile2DB

and also please guide me how to write flow service to insert data in oracledatabase table from flatfile and viseversa please someone guide me…

Regards,
Eswar

2

Hi,

Try to go through these step by step scenarios, may be helpful for you.

Flat file to Database

Database to Flat file

Database to Flat

Database to EDI

Thanks

3

Hi Khan,

Thanks for reply felt happy by seeing one reply to my question.

This might be small issue,but it is big thing to me i am begginer in webMethods…

I did exactly how they done in that link…but .txt file not generating my service and i am confusing in some place.please guide me how to do this flowservice…

1)FF_Practise.services:select_order_details
service out pipeline out
Select_Order_dtailsOutput <–> Select_Order_dtailsOutput

2)converToString
pipeline In service In

Order_details(Order_potest_schemaDT)<-link—>ffvalues
ffschema(FF_Practise.Schema:Order_potest_schema)

3)sample.IO.test:writeToFile

   pipeline In                                            service In

string <-----> filecontent
filename(C:\sample\test\cc.txt)
overwriteflag(Overwrite)

These r the flow steps in my service…

4

Have you defined the file location where you want to generate file in WmPublic/config/fileaccess.cnf file?
What does that writeToFile service do? You can use pub.file:stringToFile directly.
Post the errors in server.log if you get any.

HTH,
Niteesh

5

Try to do a debug step by step and let us know where you were stuck up:

  1. Does your select Adapter service run successfully giving you the DB output.
  2. Have your Db values successfully converted to a string variable.

If you have the output of these steps then its not a big deal to get a file as an output.

Share your errors with us.

Thanks,
Vikram

6

Hi niteesh,

     Thanks for reply,i didn't try StringtoFile and i didn't set file location also.

       Directly i am giving file path somethig like C:\sample\test\cc.txt in my flow service.

Regards,
Eswar

7

Then server will throw error saying the path has not been defined in allowed path list. Its a must and try that ,let us know if you still face issues.

Regards,
Niteesh

8

Hi Niteesh,

        In Config folder i couldn't able to see any thing ,that folder is empty.

        WriteToFile will write the string to mentionedpath text file.

and pub.file:stringToFile also not able to find in Wmpublic.pub.file:

What i should i do now please guide me :frowning:

Regards,
Eswar