You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

App Engine & File layout

4 replies [Last post]
vrs_11's picture
User offline. Last seen 12 years 38 weeks ago. Offline
Joined: 06/02/2008
Posts: 4

hello all
i am creating an application where i need to read data from an excel sheet & insert it into records and update the file in the database with the newly added data.
say for example : Ticket id , impact, misroute & so on up to 10 fields are there in a record.
these fields shud get updated & the count of it should get updated when i run an application.

My plan :
What i'd think of doing was to create a file layout and then write an app engine program for that ..
since i am weak at application engine can any1 help me how to go about this ?

CompShack's picture
User offline. Last seen 6 years 23 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: App Engine & File layout

vrs_11,
You are right about what you've said. You need an application engine and file layout to load your data in from a file.

1) You can't load data from an excel file, your will have to convert that to a CSV, or a fixed file.
2) Create your file layout. It is really not that hard, so dive in and read peoplebooks, there are some few good example to help you along the way.
3) Create your application engine and remember to code for your business logic edits before you start inserting data into core tables.

Sorry, but not sure how else I can help. Get started and post any errors/issues you may have along the way. Good luck!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

PARITOSH's picture
User offline. Last seen 10 years 13 weeks ago. Offline
Joined: 06/16/2010
Posts: 19
Re: App Engine & File layout

Hi am able to upload the data through app eng and file laout,but wt about the validations....
where should i put a code for uploading a validate data...

pavanig's picture
User offline. Last seen 10 years 36 weeks ago. Offline
Joined: 06/16/2010
Posts: 3
Re: App Engine & File layout

define a log file in the code which helps in debugging or putting validations without aborting the file while it encounters a errored row of data.

please find below some peice code of code which helps u in creating log files
&fileLog = GetFile("C:\temp\LOGFILE.log", "w", "a", %FilePath_Absolute);
&fileLog.WriteLine("Begin");
&fileLog.WriteLine("End");
&fileLog.Close();

PARITOSH's picture
User offline. Last seen 10 years 13 weeks ago. Offline
Joined: 06/16/2010
Posts: 19
Re: App Engine & File layout

all the validations are workin fine..tx alot.....
Now i need to create a stat file where 1 can find out how many rows are processe,how many errors and how many rows are succed,,,,,
any suggetions would be helpful to mee