-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Èçìåíåíèå êîäèðîâêè txt ôàéëà

Ïÿòíèöà, 08 Ìàÿ 2015 ã. 11:40 + â öèòàòíèê
Äîáðûé Äåíü, ìîæåò ÿ ïëîõî èñêàë íî ðåøåíèÿ òàê è íå íàøåë. Ó ìåíÿ â áàçå ACCESS ôîðìèðóåòñÿ èç òàáëèöû íåêîòîðàÿ èíôîðìàöèÿ êîòîðàÿ â xml ôîðìàòå ìåòîäîì POST ïåðåäàåòñÿ íà ñåðâåð. Ïåðåä îòïðàâêîé ÿ ñîõðàíÿþ äàííûå â txt ôîðìàòå äëÿ ïðîâåðêè åñëè ïîòðåáóåòñÿ (êàê áû ëîã ôàéë), ïîñëå îòïðàâêè äàííûõ, ïîëó÷àþ îòâåò îò ñåðâåðà è îïÿòü çàïèñûâàþ åãî â txt ôàéë ñîõðàíÿþ êàê log. À âîò äàëüøå èäåò ìîÿ ïîëíàÿ áåçãðàìîòíîñòü íå ñìåéòåñü, ÿ êîïèðîâàë òõò ôàéë ñ äàííûìè îò ñåðâåðà, ñîõðàíÿë êàê xml è èìïîðòèðîâàë â Access. Âñå áû õîðîøî, íî äåëî äîøëî äî ðóññêîãî òåêñòà â ôàéëå, è íà ýòîì âñå çàñòîïîðèëîñü. Òåêñò ñîõðàíÿåòñÿ â ANSI à ìíå íóæíî ÷òîáû â utf-8. Âîò çäåñü è âîçíèêàåò âîïðîñ 1 êàê ïîìåíÿòü êîäèðîâêó â txt ôàéëå ñðåäñòâàìè VBA. È âòîðîé âîïðîñ ÿ ïîäîçðåâàþ, ÷òî ïóòü êîòîðûì ÿ èìïîðòèðóþ xml ôàéë õîòü è ðàáî÷èé íî, êàê áû âûðàçèòüñÿ íå êðàñèâûé ÷òî-ëè, íå ïðàâèëüíûé îí, âåäü ìîæíî ïðîñòî âçÿòü äàííûå êîòîðûå ÿ ïîëó÷èë îò ñåðâåðà è áåç ëèøíèõ îïåðàöèé èìïîðòèðîâàòü â áàçó äàííûõ, íî âîò êàê ýòî ñäåëàòü íå çíàþ.
Çàðàíåå ñïàñèáî.



1 Private Sub check_etr_Click()
2 On Error GoTo Err_check_etr_Click

3 Set objXml = CreateObject("Msxml2.XMLHTTP")
4 Set objXmlDoc = CreateObject("MSXML2.DOMDocument")
5 Dim rs As Recordset
6 Dim doc As String, ccode As String, x As String, y As String, my_rc As String
7 Dim rc_int As Integer, rc_full As Double, z As Integer


8 Set rs = CurrentDb.OpenRecordset("check_entered_cards")

9 If rs.RecordCount > 0 Then
10 rs.MoveFirst
11 Do While Not rs.EOF
12 mycart = "" & rs("card_code") & "" & mycart
13 rs.MoveNext
14 Loop
15 End If

16 strXML = "" & _
17 "" & _
18 mycart & _
19 "
" & _


20 Open "D:\c_info_list_exp.txt" For Output As #1
21 Print #1, (strXML)
22 Close #1

23 objXml.Open "POST", "http://000.000.000.000:81/UCS/SOAP/SOAP.php?xml_data=" & strXML, False
24 objXml.send (strXML)


25 Open "D:\c_info_list.txt" For Output As #1
26 Print #1, strXML
27 Close #1

28 FileCopy "D:\c_info_list.txt", "D:\c_info_list" & ".xml"
29 ImportXML "D:\c_info_list.xml"

30 Exit_check_etr_Click:
31 Exit Sub

32 Err_check_etr_Click:
33 MsgBox Err.description
34 Resume Exit_check_etr_Click

35 End Sub

http://www.sql.ru/forum/1155649/izmenenie-kodirovki-txt-fayla


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó