Re: Web Based Spreadsheet To MSSQL Mapping
On Friday 25 Feb 2005 15:21 pm, Bryan F. Hogan wrote: send it to me. Against all of my recommendations to have us write an import function they don't want to spend the money. So, fine. Let them do it that way. When it breaks, explain why. -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Spreadsheet To MSSQL Mapping
No not fine. I don't care if they want it or not, I want it to make my job easier. These are people that if they see something that will understand how it will make their jobs easier. That's why I posted looking for something that someone may have already done. I can't believe that this has not been done before and that no one on this list hasn't seen one before. Thanks for your reply -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 10:36 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping On Friday 25 Feb 2005 15:21 pm, Bryan F. Hogan wrote: send it to me. Against all of my recommendations to have us write an import function they don't want to spend the money. So, fine. Let them do it that way. When it breaks, explain why. -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Spreadsheet To MSSQL Mapping
Against all of my recommendations to have us write an import function they don't want to spend the money. Well, if they don't want to spend the money, why care for them anyway? ;-) Do I understand well that if spreadsheets come from their client, they can have about anything in it, in any format? Or do they always have the same type of data in the same columns? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Spreadsheet To MSSQL Mapping
Ok, let me reiterate. I care for them because I know if they can see an example, they will foot the integration bill. These are clients that I have that we have been working with for the last 5 years. I care for them because they sustain our business and even if they were one of our smaller customers I feel that caring about your customers is often times more beneficial that monetary returns. They can come in any format. That's why I'm looking for something where they can upload/open the spreadsheet and map the spreadsheet columns to the MSSQL columns that I supply. Something that I can write rules against. If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. It is an ethical thing that I like to do for my customers. Thanks for your reply. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:11 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping Against all of my recommendations to have us write an import function they don't want to spend the money. Well, if they don't want to spend the money, why care for them anyway? ;-) Do I understand well that if spreadsheets come from their client, they can have about anything in it, in any format? Or do they always have the same type of data in the same columns? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Spreadsheet To MSSQL Mapping
Can you force a spreadsheet format on them? If so, you can generate a spreadsheet with locked cells where they can only enter information in cells you have specified. That would make it much easier for you handle the data. Of course, if the sheets contain varying amounts of data, it might not work as well. M!ke -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 10:24 AM To: CF-Talk Subject: RE: Web Based Spreadsheet To MSSQL Mapping Ok, let me reiterate. I care for them because I know if they can see an example, they will foot the integration bill. These are clients that I have that we have been working with for the last 5 years. I care for them because they sustain our business and even if they were one of our smaller customers I feel that caring about your customers is often times more beneficial that monetary returns. They can come in any format. That's why I'm looking for something where they can upload/open the spreadsheet and map the spreadsheet columns to the MSSQL columns that I supply. Something that I can write rules against. If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. It is an ethical thing that I like to do for my customers. Thanks for your reply. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Spreadsheet To MSSQL Mapping
If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. I was just joking ;-) The reason I asked is because I have a site in which spreadsheets are imported, but the columns always match, so it won't help. I don't know about any matching tool however. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Spreadsheet To MSSQL Mapping
A matching tool as described would be an easy sell to a lot of people. Though probably would be a nightmare to try and make which might be why I have never stumbled upon a canned solution for it. :) On Thu, 03 Mar 2005 11:38:18 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. I was just joking ;-) The reason I asked is because I have a site in which spreadsheets are imported, but the columns always match, so it won't help. I don't know about any matching tool however. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Spreadsheet To MSSQL Mapping
Ah, and that's why I don't want to write it myself. I was thinking something along the lines of a mail merge. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:42 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping A matching tool as described would be an easy sell to a lot of people. Though probably would be a nightmare to try and make which might be why I have never stumbled upon a canned solution for it. :) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Spreadsheet To MSSQL Mapping
A matching tool as described would be an easy sell to a lot of people. Ah ah! A great idea for a new tag? ;-) Though probably would be a nightmare to try Not really, using CFX_ODBCInfo would make it pretty easy. I'm about to release a super new application: The ODBCMyAdmin, version 1.0 and I may consider adding this feature in future version. Version 1.0 already imports tables, ie. copies tables, but here we more talking of import'n translate. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Spreadsheet To MSSQL Mapping
To me the mapping itself would not be the nightmare. It would be the reading in the Excel file and grabbing the data correctly. Dealing with any pretty formating it might have, dealing with multiple worksheets and so on. I actually have the need for something kind of like this and will be tackling it some hopefully this month. My need we at least have a great deal of control over how the spreadsheet will always be laid out so not going to be mapping issues. On Thu, 03 Mar 2005 11:54:02 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: A matching tool as described would be an easy sell to a lot of people. Ah ah! A great idea for a new tag? ;-) Though probably would be a nightmare to try Not really, using CFX_ODBCInfo would make it pretty easy. I'm about to release a super new application: The ODBCMyAdmin, version 1.0 and I may consider adding this feature in future version. Version 1.0 already imports tables, ie. copies tables, but here we more talking of import'n translate. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Spreadsheet To MSSQL Mapping
It would be the reading in the Excel file and grabbing the data correctly. But isn't this supposed to be handled by the ODBC driver? Sure the Excel file may contain things not compatible with the database, but I assume that if the driver cannot get it, I don't see what I could do any better reading the file directly. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197384 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54