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

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: 82
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: 2312
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?


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: 82
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
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: 2312
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?

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: 82
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
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: 2312
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?


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: 82
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
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: 2312
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.


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: 82
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
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: 2312
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.


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: 82
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.
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: 2312
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?


Re: new field for file upload transaction [message #2569 is a reply to message #2568] Sun, 27 June 2010 19:24 Go to previous messageGo to next message
edortizq is currently offline  edortizq
Messages: 82
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
Re: new field for file upload transaction [message #2953 is a reply to message #2569] Tue, 17 April 2012 04:32 Go to previous message
robinhudda123 is currently offline  robinhudda123
Messages: 1
Registered: April 2012
Junior Member
Nice post in which we are learn a lot of career in the web design and the maintenance. Many of the people got there future in this field. This site maintained very smoothly and very fashionable. Thanks for sharing this information with us. In which learn a lot of knowledgeable information.


robin
Previous Topic: Adding SUM() data to screen and report
Next Topic: Problem with read/update of a selected entry
Goto Forum:
  


Current Time: Sun Jan 29 08:07:51 EST 2023

Total time taken to generate the page: 0.12060 seconds