Howto:Edit and upload contacts at the ContactsApp with Libre Office: Difference between revisions

From innovaphone wiki
Jump to navigation Jump to search
Line 46: Line 46:
There are some ways to find a problem on this solution. At first have a look at the upload.log which is located in the workspace.
There are some ways to find a problem on this solution. At first have a look at the upload.log which is located in the workspace.
Then you can stop the autorun of the script. Call the Macro-Editor in Libre Office Calc and edit the Basic-Macros. You will find the macro under document-makros in Module Innovaphone. It is simple named Main. Now you search for the command 'shell (MakroFile,4)' and make it to a comment by writing rem left from the command. After running the makro now you see the script-file uploader.cmd in the workspace and you can anlyze and run it.
Then you can stop the autorun of the script. Call the Macro-Editor in Libre Office Calc and edit the Basic-Macros. You will find the macro under document-makros in Module Innovaphone. It is simple named Main. Now you search for the command 'shell (MakroFile,4)' and make it to a comment by writing rem left from the command. After running the makro now you see the script-file uploader.cmd in the workspace and you can anlyze and run it.
You will find some other commented lines at the macro, yo cann uncomment this to get some messages by running it.
You will find some other commented lines at the macro, yo can uncomment this to get some messages by running it.


==Known Problems==
==Known Problems==

Revision as of 20:16, 23 January 2021

Applies To

This information applies to

  • Innovaphone PBX V13 with a running AppPlattform and a running ContactsApp-Instance.


Problem Details

Up from V13 there is with the ContactsApp a nice tool for serving contacts. Unfortunately there is no Contacts-Editor, but there are some customers outside, which have no LDAP-Source and which are not so fit in handling the UTF8-Export/Import. This project is a try to make it more easy for the customers, because the can edit the contacts and have only to klick upload (if you prepared everything well).

System Requirements

  • Innovaphone PBX V13 with a running AppPlattform and a running ContactsApp-Instance
  • A Windows-PC that supports PowerShell (tested with Win10)
  • workspace-folder with write-access on the PC with a real mounted drive (C:, D:...)
  • the PowerShell-Script from Concept App Contacts saved as CSV-Import.ps1 and the CURL-Ressources in the workspace-folder
  • LibreOffice (portable or installed is not important - tested with V5.4)
  • The ODF-Document from this article


Description of the ODS-file

The document contains 4 sheets. The 4th sheet is hidden and there is no need to show it. You can edit the name of the sheets, but don't rearange them - the macro needs them in this order.

PhoneBook

As you already assumed this is where you edit your contacts. You can customize row 1 and 3, but data has to start at cell A4 and keep the coloums as they are. At hidden row 2 is the headline as used in export for debuggig reasons.

Settings

Here is where you set your environment. For starting the PowerShell-Script there are a few informations needed. This is the address (name or IP) of your App-Plattform. Then there is needed the put-user and the password, which you can set in the settings of the ContacsApp at the PBX-Manager. Additional there is the PBX-Domain needed, on which your instance is running. If you upload a file, the ContacsApp saves the filename and if you upload again you have to use the same filename to update your data and prevent a double data. Here is a problem at many customers and so we write the destination name also in the settings to reduce the trouble here. At column A you will find the desciptions of the setting values and a notice on every cell which descibes the value with a few words. At column B you have to enter the values and you will find a notice with a short german desciption.

ImportData

This table will be filled by the Upload-Macro and exported. Offcourse this can also be hidden, but not with actual version of the macro. If you can improve this feel so free and do it and be so friendly and let us all know youre improvements. Here it is important, that the row 1 will not modified, because this will not touched by the macro. So to make it a little bit safer it's hidden and you know, you can improve this too.

Hilfsdaten

This is the hidden sheet and you see this will be created in german. You don't need this sheet, so there was no need to trsanslate it after creation. It calculates different valus for the macro, because it was the lazy way. Keep it hidden, it looks a little bit chaotic and don't modify it.

Macro

Most parts of the macro are recorded, so it's not optimized to a clean programming style. But you know - you can improve it. The macro jumps to cell A4 of the Phone-Book-sheet, marks all data and copy it to the clipboard. Then it jumps to the sheet Importdata and insert the clipboard-content, with the starting point A2. After this sheet will saved at the documents path with the documents name with the extension UTF8. This will be done by the 'Save As' dialogue. To rescue some ugly things which are done until now the clipboard will be filled with a ampty cell and the document will saved at its original name as ODS-file. Now the macro creats a cmd-file named uploader.cmd at the workspace. It writes some DOS-commands. The correct drive will be adressed and then the script jumps to the workspace-folder and starts the PowerShell-Script CSV-Import.ps1. At the end the sript is deleted by itselfe to prevant files with the crendentials in the folder. The output of CSV-Import.ps1 will be saved in a file called upload.log, so this is the first point for debugging.


Debugging

There are some ways to find a problem on this solution. At first have a look at the upload.log which is located in the workspace. Then you can stop the autorun of the script. Call the Macro-Editor in Libre Office Calc and edit the Basic-Macros. You will find the macro under document-makros in Module Innovaphone. It is simple named Main. Now you search for the command 'shell (MakroFile,4)' and make it to a comment by writing rem left from the command. After running the makro now you see the script-file uploader.cmd in the workspace and you can anlyze and run it. You will find some other commented lines at the macro, yo can uncomment this to get some messages by running it.

Known Problems

By running the upload you lose the content of the clipboard on your PC. Because the password is written clear at the seetings there is al little security risk. Mabye in the next version there comes a password-request if the value is empty, but yo know - you can improve it too. If the ODS-file is saved with a new name you should close any reopen it. I you do this not, the file will saved with the old name by running the macro. Libre Office is not actualizing the cell which is containing the name of the file after at the sheet Hilfsdaten dialogue ‚Save as‘. There is no logical check for the settings, is up to you to check everything. Because the use of Windows-scripts it will only work on windows. Offcourse this solution comes without any warrenty or support. If you need help ask the Community.

Download

File:Contacts-App-ImporterV1 0.zip

Related Articles

Reference13r1:Concept App Contacts