2. ASPRunnerPro General questions
  3. date conversion error on import
This topic is locked

date conversion error on import

 		10/13/2011 2:47:23 PM
ASPRunnerPro General questions
A
 Aliceerickson author

What I've got is a basic ASPRunner set of pages - list, add, edit, import, etc. No modifications or customizations at all. My database is SQL. Not mySQL, SQL. Windows 8 server, 64 bit.
I'm trying to update a simple table from a csv file. The file did upload to the tmp folder, and this is a snippet of the data:
SchoolID,SkipDate

167,11/11/2011

167,11/21/2011

167,11/22/2011
I'm getting this error for every line of the upload file:
Error: in the line: 167,2011-11-11 More info
SQL query: insert into [dbo].[tblCalendar] ([SchoolID],[SkipDate]) values (167, convert(datetime,'2011-11-11',120));
So, what the import script is doing is taking my mm/dd/yyyy formatted dates and converting them to yyyy/mm/dd. It shouldn't be doing that for SQL server!
I just double checked to see what the edit as properties are for the pages, and they're mm/dd/yyyy English US. So it definitely shouldn't be doing that.
What is the fix on this, please?
Sergey Kornilov admin 10/13/2011

In fact it should. The internal date storage format in all databases is yyyy-mm-dd and doesn't have anything to do with display format. No matter what display format you choose correct internal format is yyyy-mm-dd.
To find what exactly is wrong with this specific app post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We also need to have a sample import file in order to reproduce this issue.
A
 		Aliceerickson author 10/13/2011



In fact it should. The internal date storage format in all databases is yyyy-mm-dd and doesn't have anything to do with display format. No matter what display format you choose correct internal format is yyyy-mm-dd.
To find what exactly is wrong with this specific app post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We also need to have a sample import file in order to reproduce this issue.


Okay, point conceeded on date format in all databases. But the fact remains that simple setups built with this product won't do a simple import. After the one with the dates bombed out, I tried a couple that only handle numbers, and neither of those worked either. Those are only dealing with simple numbers. No decimals, no currency, no nothing. They don't work. I'm a big fan of your products, but I'm surely not a big fan of your Demo Account solution to product support. Since my pages are built for a SQL database that I can't possibly post the login credentials to in the Demo Account, this means that I'm going to need to rebuild things in an Access database and upload that to your Demo Account. Very unsatisfactory, but I suppose there's no help for it if I ever want the import feature to work at all for anything. And I sure do want that. I'll go and reinvent the wheel.
Sergey Kornilov admin 10/13/2011

Alice,
I have no idea why you think Demo Account upload won't work for you. You are the only person who runs ASPRunnerPro on SQl Server, right? Just give it a try.
If you think it's not going to work for you find another way to send your application to us. Whatever works for you.
A
 		Aliceerickson author 10/13/2011



Alice,
I have no idea why you think Demo Account upload won't work for you. You are the only person who runs ASPRunnerPro on SQl Server, right? Just give it a try.
If you think it's not going to work for you find another way to send your application to us. Whatever works for you.


I don't think it won't work for me. I didn't say that at all. It's that I can't put up the set of pages that's failing since they've got the database connection to my customer's sql database in them. It's not that I don't trust you - in fact if it were my own database, I'd just put the pages up as they are. It's not my own database. It's my customer's database, so you can surely see why I can't do that. I'll have to recreate the problem in an Access environment and upload that to your demo account setup.
Sergey Kornilov admin 10/13/2011



I can't put up the set of pages that's failing since they've got the database connection to my customer's sql database in them.


Your assumption is 100% incorrect. Demo Account upload creates a copy of project tables (up 1000 records per table) and uploads it. There is no connection to the live database.
A
 		Aliceerickson author 10/13/2011



Your assumption is 100% incorrect. Demo Account upload creates a copy of project tables (up 1000 records per table) and uploads it. There is no connection to the live database.


Well, that's good to know, but your assumption is 100% incorrect in that it's okay for me to upload my customer's real data anywhere. Why would you assume that? Does your demo copy the real data? If so, then I'll still need to set up a like-kind for one of the pages sets that's failing. If it populates the tables with generic data, then it would be nice if you'd said that to begin with. Let's quit squabbling about this. As I said, I'm a big fan of your products - I've bought both ASPRunner and .Net Runner. I'll probably buy PHPRunner as well, since I have some sites that would profit from that. I'd hate for either one of us to go away mad over a silly thread like this.
Sergey Kornilov admin 10/13/2011

I'm just saying that we need to see your application and data in order to help you. In your original message nothing suggested that you are dealing with sensitive data.
If you have any sensitive data, simply create a one table project, make sure there is no data in this table at all, upload it to demo account and let us help you.