Beginner asking a question before he makes a recommendation to his boss!!!
I have been tasked with fixing a database issue for my company and I need to ensure I am on the right track so I am asking here for confirmation.
Our current process is we use two forms for input into our database.
A registration form on Wordpress and a Facebook leads form
We take the information from there and we input it into Zoho and a Mysql database behind a Wordpress web portal.
The file format we use is CSV. My understanding of CSV is that the data fields have to match the database table. If there is a column mismatch between the file and the database, data will go into the wrong field unless it is processed in some form to move the column in the CSV file. That is my understanding. Am I correct in this?
So, if my above assumption is correct, then it would be logical that the forms used would need to be standardised in order to ensure the data format is standardised. Please let me now if I am on the right track with this. Thanks
Yes you are on the correct track with this info. If you are importing directly from the CSV then the file format MUST match the database fields. You could write a parser which does the importing for you, this would give you an opportunity to trap crappy data before it hits your DB.
CSV has some gotchas, if it is not well formed, dealing with commas in the data, then you are in big trouble.
"Form" implies a standardised format otherwise it is just free form text.
Never underestimate the power of human stupidity -
I'm old. I know stuff - JSOP
I have to write ASP .NET code that allows for a user to only have one application session active at a time. What the code needs to do is logout an existing user, or session, if the same user logs into the same application in a different browser. In other words the new session should kill the old or existing session. Has anyone done this before? One note is that I am using Windows authentication and not Forms.
One note is that I am using Windows authentication and not Forms.
It's almost impossible to sign out if you're using Windows authentication. In most cases, the only way to accomplish it is to restart the browser.
One possible option:
In a database, map the username to a Guid representing their "active session";
In the "authorize request" event, check for the existence of a custom cookie:
If the cookie exists, verify that its value matches the user's "active session" value in the database, and allow or deny the request as required;
If the cookie doesn't exist, change the user's "active session" value in the database, and set a session cookie on the response with the new value;
Once a user has been kicked off by signing in on another browser or device, they will need to restart their browser to sign in again.
NB: Certain browser settings may cause the browser to retain session cookies even after a restart, which would mean the user would have to manually clear the cookies for your site to sign in again. This affects both Chrome[^] and Firefox[^], and possibly others.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
i am trying to make a REST server with and a client with an oData service.
The server is running and with the restlet tool i can send request and receive the correct information.
the debug from the restlet tool looks:
Is there anyway, I can add all the dlls that are required for the application deployment be automatically added by Nuget, means when I am deploying the application, a tool that can warn me or let me know that this dll is missing from the deployment, if it can be done by nuget itself, it would be a great help.
I am asking this because a serious issue happened in my application deployment, reportviewerforMVC tool that uses the MicroSoft.Sql.Types dll was missing but deployment was happening, it took me considerably long time to identify what was the problem, because ReportViewerForMVC was not giving me any error message.
Please need some help any help would be very very greatful - thanks a lot friends.
I have InProc Session mode set to 20 min(web.config),
If the user is inactive after 20 min user gets logged off and that's fine but
i also want to check after 10min of user inactivity sql table value has to be updated.How to handle this?
Here is my code in the View, this is all I have, don't I have reference to ReportViewer added or some middle line in between the Controller Code is failing like Service Call etc which is making the ViewBag null, just not understanding, any help would be greatly helpful thanks my friend.
I just tested Report Path is also correct, I just put log and tested it, but the problem is, ReportPath is coming like this the Physical Path (C:\PIMS\Reports\LegalEntityReport.rdlc), this Physical Path is correct, I put the Virtual Path (full Path to report hard coded) also, in both cases it failed.
And another one I tested just now is that DataSet and DataTable both are not null values they have rows, so its not because I am passing null values, so it must be something related to setting in config etc.
I am not sure what's the reason for its failure, any config setting or etc, I don't know what it is, any help please
Sorry Richard, it didn't fix the problem yet, is it because of any security hitch because we are using SSL on the Server or am I missing any other dll etc, I have all the dlls added and deployed on the Server, is it because using ReportViewerForMVC itself is a problem? I have not seen much support about that tool also and I don't know using it with SSL is bad combination, or SSL itself is a problem.
I have put the ignore Certificates code as well in Global.asax file, still not working, or just the Physical Path itself is a problem, but the report Viewers that are used by the iFrame are working fine in other applications - those applications are also using the MapPath code means Physical Path, they are on the same Server too, I thought this also works and internally this tool also uses a .aspx page just like their approach but in iFrame approach the code to generate report is written in the .aspx pages Code behind but in the ReportViewerForMVC the report generation code is written in the Controller, but not understanding Richard, not logging any information also.
MapPath is returning Physical Path, is it because of that, is it because Local not Remote, just don't know Richard, very sad in ending up in this way. If anybody can help me who gone through the same situations please help me, I really really thankful to you.
If you still get a NullReferenceException, then you'll need to debug your code to make sure you're actually setting the ViewBag value.
How can I do it on the Server Richard, I am seeing the DataSet and DataTable are not null, I am not getting any information why is it failing, any help would be great for me Richard.
hi Richard, yes you are very true, I changed the approach, I have used the iFrame approach I am getting the following error
An error occurred during local report processing.
The definition of the report 'C:\PIMS\Reports\LegalEntityReport.rdlc' is invalid.
An unexpected error occurred in Report Processing.
Could not load file or assembly 'Microsoft.SqlServer.Types, Version=184.108.40.206, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
but the report is in the same path, is it something related to Path or any other library issue, can you please let me know, thanks a lot my friend.
hi Richard mate - one more thing I have identified, that ReportViewerForMVC is also working fine now, so was it the Microsoft.SqlServer.Types that was missing, if it is then why didn't the ReportViewerForMVC inform me in Exception or etc? Where as the iFrame approach has informed me so that I could able to fix the issue. It would have been easier if I would have known this dll that was missing, it left very bad impression around colleagues that it is simple and I am not able to fix the issue.
Thanks for helping me all the way along this issue mate. Hope you don't mind me calling you - mate
modified 16-Nov-18 17:59pm.
Last Visit: 7-Dec-19 20:32 Last Update: 7-Dec-19 20:32