Radicore Forum: Application Development » new field for file upload transaction

Home » RADICORE development » Application Development » new field for file upload transaction

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

new field for file upload transaction [message #2557]

Thu, 24 June 2010 22:02

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

AJM
Messages: 2382
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

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

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

AJM
Messages: 2382
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

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

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

AJM
Messages: 2382
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

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

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

AJM
Messages: 2382
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

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

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

AJM
Messages: 2382
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

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.

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

AJM
Messages: 2382
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

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

Report message to a moderator

Re: new field for file upload transaction [message #2953 is a reply to message #2569]

Tue, 17 April 2012 04:32

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jun 19 04:25:19 EDT 2025

Total time taken to generate the page: 0.10336 seconds