Hi Stefano,

You need to check the values in the Creatio system settings connected to the Aspose service.

Please use the screenshot below to check whether the Aspose setting values match the respective system settings in Creatio:

After you apply the changes, we recommend you to log out and log back into Creatio for checking the updates.

Hope this helps!

Best regards,

Max.

Max,

Thank you Max

it works!

By the way, if there is a list of data type matches for decimal values (as I understood, float does not match all of them), I would really appreciate a link.

Кстати, если существует список соответствий типов данных для дробных значений (как я понял, float подходит не для всех), я был бы очень благодарен за ссылку.

Я нашёл необходимый тип данных, им оказался decimal. Вопрос можно закрыть

Вот ссылка на перечнь соответствующих типов:

Элемент процесса [Задание-сценарий] | Creatio Academy (terrasoft.ru)

I've found the necessary data type, it turned out to be decimal.

Above there is a link to a list of data type matches

Hello Stefano, 

Yes. I will show you an example how to achieve it: 

1. Choose the section you want to download from and find the record.

For example in Account section the request will be 

http://localhost:1337/0/odata/AccountFile and so on.

Here is an example for Contacts from my local app.

Find the needed file and  retrieve the Id from the attachment you want to download:  

2. Call this endpoint: 

http://localhost:1337/0/odata/ContactFile(fabc22d4-5d91-435c-8dd4-46cfd…

Where fabc22d4-5d91-435c-8dd4-46cfd626345c - the Id from step 1.

Best Regards, 

Bogdan L.

Thank you very much

Bogdan Lesyk,

Hello Stefano,



Can you please provide us more detailed information on your business task?



Thank you in advance!



Best regards,

Bogdan

Bogdan,

I would like to load programmaticaly the temporary table used by creatio when I import an excel file and then launch  the import, specifing which entity fill 

Hi Federica, 

Actually you are still capable to use OData with business task to achieve required implementation. You don't need to use Scheduler for this, so disregard these deleted links, I will give you fresh one , please take a look on the actual OData 4 link with guide how to set up the integration: 

https://documenter.getpostman.com/view/10204500/SztHX5Qb?version=latest

Please also check out this link from Marketplace where you may find another solution for you task: 

https://marketplace.creatio.com/app/file-manager-creatio

here you may set up key features of needed requirements, so you can make "One click" implementation and it might be much easier for you.

Best Regards, 

Bogdan L. 

The .NET FtpWebRequest class can download a file to an in-memory stream (without actually saving the file anywhere) that you can then process from the stream. This could be used from a ScriptTask in a process etc

FtpWebRequest request =
    (FtpWebRequest)WebRequest.Create("ftp://ftp.example.com/path/file.txt");
request.Credentials = new NetworkCredential("username", "password");
request.Method = WebRequestMethods.Ftp.DownloadFile;
 
using (Stream stream = request.GetResponse().GetResponseStream())
using (StreamReader reader = new StreamReader(stream))
{
    while (!reader.EndOfStream)
    {
        string line = reader.ReadLine();
        // process the line as needed
    }
}

Ryan

Ryan Farley,

That's the script I'm running at the moment and it works!

Hello,

Thank you for your message!

Case Source is the only way to find out whether a record is created from the incoming email. Also, the email gets linked to the case at once.

As for your second question, the mailbox can be seen in the tab "Processing". It's also possible to set a separate case category for each mailbox.

Kind regards,

Anastasiia

Anastasiia Lazurenko,

Thank you for your reply, there is no "Processing" field in Case table.

Hi,

Thank you for your message.

I'm sorry my explanation was not clear enough. For example, you receive an email. A new case is registered based upon this email. Once you open the case, you can find this first email received in the "Processing tab". The email address the request was sent to can be seen there.

There is no information stored in the case table regarding the email it was registered from. Usually, the category field defines the mailbox this case came from.

Hopefully, it's clear now, but please get back if you have any further questions.

Regards,

Anastasiia

Hello Shivani,

Standard "Notes" field will also perfectly store JSON:

So please use it to store JSON on the UI.

Best regards,

Oscar

Oscar Dylan,

Thank you for your reply. Is it possible to add another "notes" field to the table and have the value displayed in a similar manner?

Shivani Lakshman,

You can use the standard one available in any newly created section and add it to another tab if needed (but this can be done via the schema code modification directly, this option is not available in the wizard yet, but our product R&D team actively works on adding this feature to the oob functionality).

Hello,

If I understood your request correctly, in this case you just can deploy separate applications on the different servers as a copy of the instance of server A without setting the replication up. With such a configuration, you will be able to remove servers without additional actions.

Before the deployment you also can check the software and hardware requirements based on your product and functionality needs by using the "Requirements calculator":

https://academy.creatio.com/docs/requirements/calculator?document=studio

Best regards,

Roman

Roman Rak,

Yes you are correct in this scenario 

But this is our last hope if we didn't get any solution

But i want same thing to happen on same instance where i can have B,C,D configuration which have basics of A but on changing/modifying  any of these it will not impact other and can be easily shutdown in case of no use

as similar people will be working on them but with little change on each of them so if i switch to other server then it will be costly as each server will cost for licenses

If there is some solution to this please let me know

Thank you

Braj Raj singh Kushwaha,

There's no need to use dedicated server for each application. 

You can run multiple applications on the same server, however you'll need to set up the apps to different ports (example A : host:80 , B: host:81, C: Host:82, etc. ) You'll also need to deploy separate database for each application. 



Please keep in mind that in this case the requirements of the server will be higher. 



Best regards,

Yurii.

Yurii Sokil,

Thank You So much For this Info

1. Currently we are using cloud server can creatio help us to install multiple application on that server

2. Can same user switch between those application using same credentials and license(as mutiple application will be assigned to same user)

Thank You

Braj Raj singh Kushwaha,

The installation of multiple applications on the same server goes the same route as simple On-site deployment. 

You need to deploy a database, set up connection strings and run the application is IIS( for .Net Framework) or Terrasoft.WebHost.dll (for  .Net Core) 

The only difference is that when you're configuring bindings for the site you need to choose dedicated port for each application( for example, there can not be two applications with address  host:80). 

For .Net Core app bindings are configured in applicationsettings.json  file which is located in root folder of the application. 



As for the same credentials - it is indeed possible to have same credentials for different environments, however it's not recommended approach from data security point of view. 



As for the licenses - it's better to ask your responsible manager about that. 



Best regards,

Yurii. 

Hi Jeremy,

Adding data for SysSetting and SysSettingValue are the correct things to package for system settings - I package those frequently and never an issue. Could it be that the SysSettingValue data record isn't including the correct fields? Can you see a record related to the SysSetting record in the SysSettingValue table? Maybe it's not showing the value in the UI because the correct columns aren't being included? (A SysSettingValue record uses one of multiple different fields depending on the datatype of the setting). Could that be the case?

Ryan

Hi Ryan

Yes, there are records in both tables joined by Id-->SysSettingsId.  It's a Text value and there is a value in the Text field on SysSettingsValue. 

I added a value to the setting in the UI and it created another record in SysSettingsValue for that SysSettingsId.  Only diference I could see is that the original entry had a Null for SysAdminUnitId.  Sure enough, after I set that value in the DB, my original value started showing up in the UI. 

I looked at the source system and target system and they both have the same SysAdminUnitId in the SysAdminUnit table.

I ended up decompiling the package to see if the value was in the Data step for SysSettingsValue and it was not.

Any idea why just that value would not copy over?

Hi Stefano,

Can you please specify why are you using empty spaces in the select parameter between columns names? Due to the example from the article, there shouldn't be empty spaces.

Oscar Dylan,

Hi Oscar,

I removed the $select  parameter but the issue persists

Secondly: why are you using eq inside the request URI? Please use this as an example:

https://o_drobina.tscrm.com/0/odata/ContactInTag?$select=Id,TagId,EntityId&$filter=Entity/Id%20eq%20c4ed336c-3e9b-40fe-8b82-5632476472b4

o_drobina.tscrm.com is the baseURI from your screen (change it to your application URI).

Also please double-check the documentation I sent, it contains useful examples.

Great, it works!

the mistake was the filter clause condition.

I used $filter=EntityId eq 8d392b32-3062-4f76-96a2-1a2f650a9c9a and this does not work

$filter=Entity/Id eq 8d392b32-3062-4f76-96a2-1a2f650a9c9a it works

Thank you very much Oscar!