Standard importing data from file

Technical questions on implementing 1C:ERP WE

#1
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Feb 25, 2022
Company: Docus

Hello,

I created a catalog and want to import data into it.I have one column with data type "date". Can I import it and how? For example date is 21.1.2022. I tried 21/01/2022, 21012022, 21.01.2022. Maybe it has to do something with regional time format. I use Initial filling/Import data from file.

Any ideas?

 
#2
People who like this:0Yes/0No
Administrator
Rating: 23
Joined: Oct 3, 2019
Company:

Hey Savo,

please specify:

1. what is the file format from which you want to import data. Is it Excel? Or something else?

2. what 1C configuration do you use? Any typical configuration? Or designed by yourself?

 
#3
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Mar 4, 2022
Company: 1c

I have an understanding of what the problem is.

1) The data is loaded using the "Import data from spreadsheets" processing, the data is not taken from a file, but specified in a tabular document.

2) Configuration 1C:ERP WE (2.5.7.294)

The solution was as follows, in order to process will be able to convert data into date format, it is necessary to specify the data in the tabular document in the format "20220225"

 
#4
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Aug 28, 2015
Company:

Hello everyone!

Try to do the following:

YourDate = "2022-02-25T16:31:14";

DateType = XDTOFactory.Type("http://www.w3.org/2001/XMLSchema", "dateTime");

Your1CDate = XDTOFactory.Create(DateType, YourDate).Value

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.