Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and Listcsv import integercsv import integer
Previous
 
Next
New Post
10/10/2012 5:20 PM
 
I have a csv file with a text column and an integer column. The integer column is imported as text - I need it imported as integer. Yes, I know that I can change it once imported. But I do this import daily and actulaly have about 6 integer columns. It gets a bit tedious to do this every day. So, how do I tell F&L in advance to import some columns as integers?
 
New Post
10/10/2012 5:35 PM
 

Sorry, you can't.

 
New Post
10/11/2012 11:16 AM
 

Hard to believe there's no import function to import data into an existing table. This would be an extremely useful feature!!

That aside - does F&L recognize any data types (other than text) when importing from a csv file?

 

 
New Post
10/11/2012 2:33 PM
 

I tested this on our development server, but USE AT YOUR OWN RISK.

To figure out the moduleID of your Form and List module, you can try the following script (from within SQL management studio (SMS)):

SELECT     UserDefinedFields.ModuleId, UserDefinedData.UserDefinedRowID, UserDefinedFields.FieldTitle, UserDefinedData.FieldValue
FROM         UserDefinedData INNER JOIN
                      UserDefinedFields ON UserDefinedData.UserDefinedFieldId = UserDefinedFields.UserDefinedFieldId
where UserDefinedData.FieldValue like '%Labor%'
order by UserDefinedData.UserDefinedRowID desc

This will list all Form and List module items which have "Labor" in their field name.  This will help you track down your moduleID; in this example '3770' is the moduleID of the module I need to edit.

Once you do this, you can then use this script to figure out  the UserDefinedFieldID for your appropriate column(s); again using SMS.

SELECT *
  FROM [UserDefinedFields]
  where moduleID like '3770'

Once you figured out the UserDefinedFieldID ('1113' in this example) of your columns, you can change the FieldType by doing the following SQL script within SMS:

Update UserDefinedFields
Set FieldType='EMail'
where UserDefinedFieldId like '1113' and ModuleId like '3770'

This will update this field from whatever it was to an EMail column type.

Hope this helps you out..

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and Listcsv import integercsv import integer


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out