Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Members   Search   Help    Register    Login   Home
Home » RADICORE development » Application Development » new field for file upload transaction
new field for file upload transaction [message #2557] Thu, 24 June 2010 22:02 Go to next message
edortizq is currently offline edortizq
Messages: 30
Registered: August 2008
Location: Ecuador
Member
Is there a way to add a new field to file upload transacction screen and then use it as parameter for processing this file??

[Updated on: Thu, 24 June 2010 22:07]

Report message to a moderator
Re: new field for file upload transaction [message #2558 is a reply to message #2557] Fri, 25 June 2010 04:14 Go to previous messageGo to next message
AJM is currently offline AJM
Messages: 1206
Registered: April 2006
Location: Surrey, UK
Senior Member
Why should you want an extra variable in the file upload task which tells you how to process the uploaded file?

If a file requires some sort of processing after it has been uploaded then you should put some code in the _cm_post_fileupload() method.

Can you give me an example of this extra variable and how it is supposed to be used?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org
Report message to a moderator
Re: new field for file upload transaction [message #2559 is a reply to message #2558] Fri, 25 June 2010 12:19 Go to previous messageGo to next message
edortizq is currently offline edortizq
Messages: 30
Registered: August 2008
Location: Ecuador
Member
Thanks for your reply. I need a field for the processing date, wich could be the current date, but not necessarily. Thanks for your help
Report message to a moderator
Re: new field for file upload transaction [message #2560 is a reply to message #2559] Fri, 25 June 2010 13:31 Go to previous messageGo to next message
AJM is currently offline AJM
Messages: 1206
Registered: April 2006
Location: Surrey, UK
Senior Member
What is this processing date used for? When is the processing date decided? Is the file going to be processed as soon as it is uploaded, or later?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org
Report message to a moderator
Re: new field for file upload transaction [message #2561 is a reply to message #2560] Fri, 25 June 2010 16:44 Go to previous messageGo to next message
edortizq is currently offline edortizq
Messages: 30
Registered: August 2008
Location: Ecuador
Member
The file is processed as soon as it is uploaded, the user who is uploading the file decides which date will be used for process depending on some factors outside the system. This date will be recorded in the resulting file of the process
Report message to a moderator
Re: new field for file upload transaction [message #2562 is a reply to message #2561] Fri, 25 June 2010 18:15 Go to previous messageGo to next message
AJM is currently offline AJM
Messages: 1206
Registered: April 2006
Location: Surrey, UK
Senior Member
If the file is processed as soon as it is uploaded, why does it need a separate processing date?

What sort of file is it, and how is it processed?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org
Report message to a moderator
Re: new field for file upload transaction [message #2563 is a reply to message #2562] Sat, 26 June 2010 14:29 Go to previous messageGo to next message
edortizq is currently offline edortizq
Messages: 30
Registered: August 2008
Location: Ecuador
Member
The processing date must be entered by user, even when I keep record of the real processing date; this is used for subsequent calculations.
The file is .xls and is processed sequentially
Report message to a moderator
Re: new field for file upload transaction [message #2564 is a reply to message #2563] Sat, 26 June 2010 14:47 Go to previous messageGo to next message
AJM is currently offline AJM
Messages: 1206
Registered: April 2006
Location: Surrey, UK
Senior Member
If it is an xls file, which is data, why can't it contain the processing date as part of its data?

I have written several tasks which upload and process CSV/XLS files, and they take all the data they need from the contents of the file.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org
Report message to a moderator
Re: new field for file upload transaction [message #2565 is a reply to message #2564] Sat, 26 June 2010 18:56 Go to previous messageGo to next message
edortizq is currently offline edortizq
Messages: 30
Registered: August 2008
Location: Ecuador
Member
the file comes from a third party, it's much easier to type a date in a screen than open a file, change it and save it.
If I can't change the file upload screen is there a way to insert a dummy task only for to type the date??
Thanks for your time
Report message to a moderator
Re: new field for file upload transaction [message #2566 is a reply to message #2565] Sun, 27 June 2010 04:45 Go to previous messageGo to next message
AJM is currently offline AJM
Messages: 1206
Registered: April 2006
Location: Surrey, UK
Senior Member
The fileupload screen is for the uploading of files only, which may be any type of file, not just data. It has no provision for any additional fields which are not connected to the upload.

If you are uploading a data file which needs to be imported into the database, then the import has to be a performed in a separate task. This import task should then read records from the data file and update the database with whatever logic you specify. All the data required by this import task should be available either in the data file or in the database.

If this data file is provided by a third party, but it has "missing" data, then this data should be inserted into the file before it is uploaded. You could even put this missing data into a second file which you can upload, then have the import task read both files.

It is not possible to modify the upload task in order to specify values which are missing from the data file.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org
Report message to a moderator
Re: new field for file upload transaction [message #2567 is a reply to message #2566] Sun, 27 June 2010 05:04 Go to previous messageGo to next message
edortizq is currently offline edortizq
Messages: 30
Registered: August 2008
Location: Ecuador
Member
Thanks for your answer, May I insert a task only for to type the date, then pass it as parameter to the file upload task?
The fact is, that I can't ask users to modify the third party file or create a new file.
Thanks for your time.
Report message to a moderator
Re: new field for file upload transaction [message #2568 is a reply to message #2567] Sun, 27 June 2010 06:10 Go to previous messageGo to next message
AJM is currently offline AJM
Messages: 1206
Registered: April 2006
Location: Surrey, UK
Senior Member
It is not possible to modify the upload task so that you can specify data which is missing from the file being uploaded.

If the file supplied by a third party does not contain all the data that you need before it can be added to the database then that is an application issue, not a framework issue.

Instead of uploading this "missing" data via the upload task, why can't you add this data to a database table which you can then access within the task which processes the file after it has been uploaded?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org
Report message to a moderator
Re: new field for file upload transaction [message #2569 is a reply to message #2568] Sun, 27 June 2010 19:24 Go to previous message
edortizq is currently offline edortizq
Messages: 30
Registered: August 2008
Location: Ecuador
Member
If there is no other way, I will have to create a table only for this purpose.
thanks for your time
Report message to a moderator
Previous Topic:USER Management
Next Topic:Problem with read/update of a selected entry
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Thu Sep 09 01:28:21 EDT 2010

Total time taken to generate the page: 0.07144 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.1.
Copyright ©2001-2010 FUDforum Bulletin Board Software