UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Upload Data And Sort - Is It Possible?, Access 2010 Web    
 
   
Alexander
post May 1 2017, 03:20 PM
Post#1



Posts: 3,370
Joined: 30-December 03
From: Glasgow, Scotland


I am looking around for a solution which may hopefully be Access based and also be web based.

Currently Secretaries of local clubs (10 in total) email me their results and I compile a full result using Access on my PC and then publish to our club website as a pdf.

A typical result would have Position .... Name ... Speed

If each of the Clubs could upload their results in a simple excel or txt file (or whatever format would work) could Access sort into order and compile a full result?

Does anyone have any experience of such a system or does anyone think this is possible on the web?

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
theDBguy
post May 1 2017, 11:20 PM
Post#2


Access Wiki and Forums Moderator
Posts: 71,217
Joined: 19-June 07
From: SunnySandyEggo


Hi Alexander,

Since we are not familiar with your situation, it is hard to say what is stopping you from getting what you need. You said you already sort the data on your PC using Access, so I don't understand why you're asking if Access can sort the data also.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Alexander
post May 2 2017, 03:40 AM
Post#3



Posts: 3,370
Joined: 30-December 03
From: Glasgow, Scotland


Thanks DBguy ...

To explain a little more .... the clubs would not have Microsoft Access but would need to upload their results say into a web form with 3 fields and input say 10 positions.

Each Club would do that and then my question was could the complete result be sorted and displayed. I had assumed Access would do that?

Maybe I am on the wrong track for this operation.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
theDBguy
post May 2 2017, 10:00 AM
Post#4


Access Wiki and Forums Moderator
Posts: 71,217
Joined: 19-June 07
From: SunnySandyEggo


Hi Alexander,

Thank you for the additional information. You said the users will upload the results to a website. In what format? Will they upload a file or would they be filling out a form on the website? And where do you want the results sorted? Are you saying you want to display all the results on a web page?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Alexander
post May 2 2017, 03:28 PM
Post#5



Posts: 3,370
Joined: 30-December 03
From: Glasgow, Scotland


Hello DBguy .. .. I think this is not an Access solution as it is all web based or I think it is?

I am thinking they would fill in some web form as this is the easiest way.

I had imagined the results from each club would then to gathered together and a full result sorted and displayed.

In its simplest form imagine 2 Clubs .... each connects to the website.

They input their top 3 positions in their club.... the website gathers the data from both clubs and combines and sorts and displays all 6 results sorted by speed.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
theDBguy
post May 2 2017, 03:40 PM
Post#6


Access Wiki and Forums Moderator
Posts: 71,217
Joined: 19-June 07
From: SunnySandyEggo


Okay, you would then have to consider what is the data platform the website is using? For example, if after the user fills in the form online, some code stores the data somewhere, then it should have code to retrieve the information back in a predetermined sorting order. So, what is the platform the website is using? Do you know if it is using a database in the back end? If so, which one? In what language is the web code written? What is the URL?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Alexander
post May 2 2017, 03:54 PM
Post#7



Posts: 3,370
Joined: 30-December 03
From: Glasgow, Scotland


Thanks DBguy ..

I don't have any of those answers.

I started by thinking Access could do it as I read you can use Access on the web !!!

I can see now that it needs specialist code above my pay grade but that will not stop me searching for a solution.

I think I am asking UA if anyone knows of such a system and can it be done.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
theDBguy
post May 2 2017, 04:00 PM
Post#8


Access Wiki and Forums Moderator
Posts: 71,217
Joined: 19-June 07
From: SunnySandyEggo


Ah, okay. If you're trying to determine how to create an online system, then there are plenty of options but most of them will probably not involve Access at all. Some will but most developers will probably recommend against it.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Alexander
post May 2 2017, 04:09 PM
Post#9



Posts: 3,370
Joined: 30-December 03
From: Glasgow, Scotland


I agree DBguy and thanks for trying to help.

I had hoped Access would be involved as I am ok with queries and reports.

I was hoping UA would have pointed me in the right direction but will keep looking for a solution.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
theDBguy
post May 2 2017, 04:24 PM
Post#10


Access Wiki and Forums Moderator
Posts: 71,217
Joined: 19-June 07
From: SunnySandyEggo


Hi Alexander,

UA has a few resources such this Wiki article: Access Web App (However, this approach is now considered a dead-end.)

Or this article in the Tutorials forum.

I think there's more...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
Alexander
post May 2 2017, 05:27 PM
Post#11



Posts: 3,370
Joined: 30-December 03
From: Glasgow, Scotland


Thanks DBguy ...

The second link looks promising and plenty to read and understand.

I will keep at it.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
theDBguy
post May 2 2017, 05:30 PM
Post#12


Access Wiki and Forums Moderator
Posts: 71,217
Joined: 19-June 07
From: SunnySandyEggo


Hi Alexander,

Like I said, there's plenty of options for web platforms. The article in the tutorial, I think, concentrates on only one of the options (PHP). There are others like ASP.Net (using C# or VB.Net), PowerApps, PowerBI, Java, etc.

Good luck!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 06:43 PM