Hi friends,
I am new to Webmethods ...i want a help from u guys....
My problem is i have to read a flat file from one path and i have to insert into database. can any one detailly explain how to do this. i dont have any idea…
the format of flatfile is
1,raj,345;
2,xyz,565;
Rajesh,
Welcome to wmUsers!!!
Based on your format of you flatfile(csv),you need to create a FFSchema with comma seperated format select Delimiter option with record parser(newline),field or composite(,) with NthField option…
Once you have created FFSchema use WmFlatFile Adapter services like(wm.flatfile:convertToValues–for parsing flatfile and it creates IDATA structure values then map the flatfile values to your Insert JDBC Adapter Service to insert into database)…
Also go thru ISFlatFileSchemaUserguide,JDBCAdapterUserguide for basic starting…
Please use search in this forum on defining csv schemas,its been discussed lot of other threads,JDBC InsertSQL AdapterService related information.
HTH,
RMG
Thank you for your kind and fast response i will gothrough the schema defs or CSVs and then ping you back…