larryhines
Forum Replies Created
-
I forgot to Publish the link. This should work
Here is a link to the screenshots. This is not a big deal. Just thought there might be an easy solution. Also, any chance to modify the words from: “Save Changes to the Database” something like “SUBMIT”
Thanks.
Yes, I am finally making progress. I have a project con figured with parent child table. Thanks. I will close this out. I have more questions, but will open a new topic for those. Thanks for the help.
Thanks. That fixed the problem.
So, I have learned some of the basic SQL syntax and can perform what I want to do fairly easily. My task was to update a column in a table to have an “Open” or “Closed” status based on the event date and the current date. I want to “Open” the event to registration some number of days (e.g. 45) before the actual event date and “Close” Registration some number of days (e.g. 7) before the actual event date. I added columns to represent the open and close timeframes, and then used the SQL update command to update the status. Saved this as a procedure with a trigger to run even day.
I then can use the WHERE clause to filter only the OPEN events.
Sorry to bother you with a trivial matter.
Unless, of course, there is a better way. I am open to suggestions.
I am closing this thread.
I have a column (integer) that represents the number of days prior to schedule date to “open” the event for registration. The value can vary (e.g. 30 days for some events, and 45 for others).
Thus the why the “where” clause would not work easily.
I am new to WP and SQL. It seems I could right a SQL function and run that everyday to update the Status column to either “Open” or “Close”. Would that work?
Worked perfectly. Thanks.
I just learned that you need to publish the page. So sorry
So I created a new table with the same columns as ROSTER. Then successfully imported the CSV file. So there must have been a problem with the ROSTER table.
So all is well. I am closing this out.
I have experimented with several methods with mixed results.
I used Excel for a file (SCHEDULE) to save as a common delimited (UTF-8) file and was able to import this file. Before I had used Google Sheets.
My second file (ROSTER) using Excel also still gives me the same error. I can complete the data mapping and preview the CSV file. But get the same error as before. I do not see any quotes in the CSV file.
The SCHEDULE file has a date column, but is all text data otherwise. The ROSTER table has an integer column (GHIN). Otherwise just text. I will send the file privately.
Really glad to see the new CSV file import feature. Unfortunately, I get an error when I tried to use it. I tried with both Google sheets and Excel files saved in CSV format. Is there any instructions yet?
Thanks you. Yes, this resolved the problem,
As requested here is a link to a screenshot. It is a google doc
https://docs.google.com/document/d/11t-NUL1gWwGo4uGAi43EfzADa-FM86ky88nExdoHGME/edit?usp=sharing
Sorry, but I am completely confused. I am not trying to add a “where” clause. I just want to publish a simple 3 column table. The error shows in the Data Publisher even before I have selected a table or entered any info into the Data Publisher.
I attached screenshot when I replied to the email. I do not think I can add a screen shot tom this forum reply.