I create an import configuration for import JSON file, but the Automatically synchronize did not insert the new data in the file. I need to use this configuration for update licences every time I make a new order (update or insert if it is new lisence)
Hi @Juhaina Almama ,
just to be sure - what you are trying to do is setup import from the json file.
What I'm missing here is the object type mapping settings - you need to configure, how exactly these json data should be imported - map the records and its attributes to insight object types and its attributes.
Have you already configured this mapping? Thank you!
1- Creat Configuration
2- choose JSON Import
3- chose name,
4- Import from file, file: AT-02-json (See import file1 in the attached).
5- Cron Expression: 0 0/5 14 * * ?
5- save Import configuration.
6- create predefined configuration -- close
7- I got object "JSON"
10- manual synchronize import the file successfully (see log3)
11- I update the file with new data for the next synchronize after 5 min, but it did not import the new data into the schemes see log2.
Hi @Juhaina Almama ,
thank you for sharing. I think your general configuration is ok, we need to look into these object type mappings and compare it to the json file structure.
Would you please also share the information:
I will try to make my question more specific If Insight is not on my local PC JIRA, how to make Automatically synchronize without uploading the imported file every time it has been updated.
I got what I need from manual synchronize, but it seems that I have problem with Automatically synchronize
I found that I need to save files in location and use the URL, I used this URL from my local PC
but I got error:
Failed to connect to the JSON file specified
I test the URL in my chrome browser and it work fin
have you any advice?
Hi @Juhaina Almama ,
I would recommend you to discuss this topic with your IT department or in general with somebody, who takes care about your Jira instance installation. They should be able to provide you some appropriate way how to get the files from your PC to your instance. The possibilites depend on many factors.
@Hana Kučerová If I am reading through this thread correctly - I have a csv file that we have setup automatic synchronization to occur once a day - it does not work. We have the file moving to one of our jira servers - every night after midnight - the file is there - I am running data center - so putting it on the shared drive. We are using the URL file reference (see below) - and I am getting nothing in any of the logs at all. If I run the synchronization manually - works fine - data imports. So - is this an issue - or are you saying that the the automatic synchronization does not work within Insight?
Hi @JDave ,
I will try to explain.
Insight needs the import file to be accessible to be able to process it, which usually means it needs to be stored at the server, where Jira is installed (it depends on the infrastructure). So, the question is, how to get the file there.
1) The easiest way - you can upload it manually using Upload file button in the import configuration form, which simply stores the file somewhere on a server to Jira folder (something like /var/atlassian/application-data/jira/...), which is accessible for Insight.
2) Somebody, who takes care about the server, provides you some way, some sort of tunnel, which enables you to deliver the file there. Again, it depends on the infrastructure and it is possible, that your admins won't want you to have such an access.
3) Download the file from some URL like http(s)://something. Again, this URL needs to be accessible from the server. You can't use file:///... this is a local protocol that can be used for local files, therefore for Insight it means the file is on the server instead of on your computer.
The /shared-home is the shared directory for my Jira servers (running four node data center setup on Linux). Insight has access to the directory, every night - I have an outside scheduler that replaces the file from the previous day - the uccx.csv file. We have insight sync setup to run once daily and expect it just to pick that file up. After the initial upload - will it look daily at the /shared-home location and pick up a new file (same name, same format - different content)? So - I can get the file there every day - and it does update, at the same location - it just appears that the automatic synchronization does not run from within the import setup.
Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events